Try this:
Code:
select id, name from spells_new where id in (select spellid from bot_spells_entries where npc_spells_id = 3005);
I tested the updated db and a raw install of peq and both returned these results:
Quote:
5012,Spike of Disease
2571,Despair
229,Fear
3561,Spear of Disease
370,Shadow Vortex
127,Invoke Fear
3560,Spear of Pain
3562,Spear of Plague
6986,Shadow Voice
6987,Shadow Bellow
3491,Spear of Decay
4904,Miasmic Spear
6988,Shadow Howl
5334,Spear of Muram
346,Grim Aura
359,Vampiric Embrace
1289,Strengthen Death
236,Shieldskin
2574,Scream of Death
1376,Shroud of Undeath
393,Steelskin
394,Diamondskin
661,Augment Death
3227,Shroud of Chaos
1414,Augmentation of Death
5327,Shroud of Discord
5332,Rune of Decay
199,Harmshield
491,Leering Corpse
351,Bone Walk
362,Convoke Shadow
492,Restless Bones
440,Animate Dead
441,Summon Dead
442,Malignant Dead
495,Cackling Bones
443,Invoke Death
5331,Son of Decay
341,Lifetap
502,Lifespike
445,Lifedraw
692,Life Leech
525,Drain Spirit
447,Drain Soul
3401,Touch of Volatis
3413,Touch of Innoruuk
5324,Touch of Inruku
5338,Touch of the Devourer
344,Clinging Darkness
355,Engulfing Darkness
452,Dooming Darkness
453,Cascading Darkness
3400,Festering Darkness
340,Disease Cloud
360,Heat Blood
367,Heart Flutter
3686,Blood of Pain
451,Boil Blood
454,Vampiric Curse
1508,Asystole
6,Ignite Blood
456,Bond of Death
3489,Blood of Hate
5320,Blood of Discord
5322,Dark Constriction
5323,Bond of Inruku
5330,Blood of Inruku
343,Siphon Strength
2572,Scream of Hate
2573,Scream of Pain
1457,Shroud of Hate
1458,Shroud of Pain
2575,Abduction of Strength
2577,Torrent of Hate
2578,Torrent of Pain
2579,Torrent of Fatigue
3406,Aura of Darkness
213,Cure Disease
|
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|