Loading...   


SELECT
npc_types.id,
npc_types.`name`,
npc_types.`level`,
npc_types.npc_spells_id,
npc_spells.id,
npc_spells.`name`,
npc_spells.parent_list,
npc_spells.attack_proc,
npc_spells.proc_chance,
npc_spells.range_proc,
npc_spells.rproc_chance,
npc_spells.defensive_proc,
npc_spells.dproc_chance,
npc_spells.fail_recast,
npc_spells.engaged_no_sp_recast_min,
npc_spells.engaged_no_sp_recast_max,
npc_spells.engaged_b_self_chance,
npc_spells.engaged_b_other_chance,
npc_spells.engaged_d_chance,
npc_spells.pursue_no_sp_recast_min,
npc_spells.pursue_no_sp_recast_max,
npc_spells.pursue_d_chance,
npc_spells.idle_no_sp_recast_min,
npc_spells.idle_no_sp_recast_max,
npc_spells.idle_b_chance,
spawnentry.npcID
FROM
(npc_types ,
spawn2)
INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID AND spawnentry.spawngroupID = spawn2.spawngroupID ,
npc_spells
WHERE spawn2.zone = 'frozenshadow'

Raw Paste Data