44,967
editsSplit query into 3 types
(Don't show NPC spells) |
HiddenDragon (talk | contribs) (Split query into 3 types) |
||
Line 1: | Line 1: | ||
{{SpellsTab}} | {{SpellsTab}} | ||
{{Spell table | {{Spell table | ||
|where=spell_level = | |where=spell_level="0" AND (classes HOLDS "Wizard" OR classes HOLDS "Sorcerer" OR classes HOLDS "Cleric" OR classes HOLDS "Bard" OR classes HOLDS "Ranger" OR classes HOLDS "Druid" OR classes HOLDS "Paladin" OR classes HOLDS "Warlock") AND (is_npc = false OR is_npc IS NULL) | ||
}} | |||
=== Item/Variant spells === | |||
{{Spell table | |||
|where=spell_level="0" AND classes HOLDS NOT "Wizard" AND classes HOLDS NOT "Sorcerer" AND classes HOLDS NOT "Cleric" AND classes HOLDS NOT "Bard" AND classes HOLDS NOT "Ranger" AND classes HOLDS NOT "Druid" AND classes HOLDS NOT "Paladin" AND classes HOLDS NOT "Warlock" AND (is_npc = false OR is_npc IS NULL) | |||
}} | |||
=== NPC Only === | |||
{{Spell table | |||
|where=spell_level="0" AND is_npc = true | |||
}} | }} | ||