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 about_polyuntri.	Death Realm death_realm_basic

Gods:	Races:	Magic:
gods_generic_basic about_laanx_sunshine laanx_advanced blackflame_fanatics	races_basic nolthrir_basic	magic_basic

• general
• newbie (used by tutorial NPCs and few others, most answers are OOC)
• winch_info (seems to be used by some merchants, not very consistently)
• greeting_evil (used by Dark Wanderer and Nodramok)
• merchant (used by Lerok Dilechi, Jashoky Dakarn) SHOULD BE REMOVED
• lyeorire_fisk (is assigned to Archilaya Gurpleferd, seems to contain duplicates)

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 or specific NPC group:

• ash_brotherhood
• 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