KAs (Knowledge Areas) list and structure

You can extract all the knowledge areas not specific to NPCs with this query:

select distinct(nka.area) from npc_knowledge_areas nka left join `characters` c on nka.area=CONCAT(c.name, " ",c.lastname) where c.name is null;

Locations

Hydlaa: Hydlaa_important_people gods_basic_hydlaa hydlaa_basic goodbye01_hydlaa goodbye02_hydlaa goodbye03_hydlaa greetings01_hydlaa greetings02_hydlaa hydlaa_townsperson hydlaaplaza_townie	Ojaveda: ojaveda_basic gods_basic_ojaveda greetings02_ojaveda-native greetings01_ojaveda-native goodbye01_ojaveda-native goodbye02_ojaveda-native akkaio_dockhands ojaveda_plague	OjaRoad: ojaroad_basic goodbye01_ojaroad greetings01_ojaroad	Arena: arena_basic arena_gladiator goodbye01_arena greetings01_arena
Gugrontid: Gugrontid_basic	Amdeneir: Amdeneir_Basic	Eagle Bronze Doors: EagleBD_Basic stone_labyrinths	Death Realm death_realm_basic

Gods:

• gods_generic_basic
• about_laanx_sunshine
• laanx_advanced
• blackflame_fanatics

Races:

• races_basic
• nolthrir_basic

• general
• magic_basic
• newbie
• winch_info
• ash_brotherhood
• about_polyuntri.
• greeting_evil
• merchant
• lyeorire_fisk

Proximity Guards:

• Proximity_Guard_Checks_Oja
• Proximity_Guard_Checks_Hydlaa
• Proximity_Guard_Checks_Gug

Pet KAs:

• Pet Groffel 1
• Pet Yulbar 1
• Pet Rivnak 1
• Pet Drifter 1
• Pet Serpent Gobble 1
• Pet Eagle Gobble 1

NPC name typos:

• Vuudjehn Korthel (its actually linked correctly on the NPC) -> Vuddjehn Korthel
• Heedel Remains (its actually linked correctly on the NPC) -> Heedel's Remains
• Skull (its actually linked correctly on the NPC) -> Mr Skull
• Bread (its actually linked correctly on the NPC) -> Mr Bread

Tests:

• AndrewTestNPC
• AndrewTestNPC2