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;
Pet KAs:
- Pet Groffel 1
- Pet Yulbar 1
- Pet Rivnak 1
- Pet Drifter 1
- Pet Serpent Gobble 1
- Pet Eagle Gobble 1
- general
- magic_basic
- races_basic
- Hydlaa_important_people
- newbie
- gods_basic_hydlaa
- hydlaa_basic
- goodbye01_hydlaa
- Proximity_Guard_Checks_Hydlaa
- stone_labyrinths
- greetings01_hydlaa
- goodbye02_hydlaa
- winch_info
- gods_generic_basic
- goodbye01_ojaveda-native
- ojaroad_basic
- ojaveda_basic
- gods_basic_ojaveda
- greetings02_ojaveda-native
- greetings01_ojaveda-native
- greetings02_hydlaa
- goodbye02_ojaveda-native
- arena_basic
- arena_gladiator
- ojaveda_plague
- Proximity_Guard_Checks_Oja
- Gugrontid_basic
- Amdeneir_Basic
- nolthrir_basic
- achieve_hydlaa_plaza
- ash_brotherhood
- goodbye03_hydlaa
- about_laanx_sunshine
- EagleBD_Basic
- laanx_advanced
- goodbye01_arena
- greetings01_arena
- blackflame_fanatics
- Proximity_Guard_Checks_Gug
- goodbye01_ojaroad
- greetings01_ojaroad
- akkaio_dockhands
- death_realm_basic
- hydlaa_townsperson
- about_polyuntri.
- hydlaaplaza_townie
- greeting_evil
- merchant
- lyeorire_fisk
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
Harnquist:
- hydlaa_important_people
- hydlaa_basic
- goodbye02_hydlaa
- gods_basic_hydlaa
- races_basic
- general
Brado:
- ojaveda_basic
- greetings02_ojaveda-native
- races_basic
- gods_basic_ojaveda
- goodbye01_ojaveda-native
- winch_info
- magic_basic
- general