/*sql for zulaman*/ UPDATE `creature_template` SET `ScriptName` = 'boss_nalorakk' WHERE `entry` = 23576; UPDATE `creature_template` SET `flags_extra` = 33 WHERE `entry` = 23576; /*no crush*/ UPDATE `creature_template` set `ScriptName` = 'boss_akilzon' where entry = 23574; UPDATE `creature_template` set `ScriptName` = 'mob_akilzon_eagle' where `entry`=24858; /*default is event ai*/ UPDATE `creature_template` SET `ScriptName` = 'boss_halazzi' WHERE `entry` = '23577'; UPDATE `creature_template` SET `ScriptName` = 'mob_halazzi_lynx' WHERE `entry` = '24143'; UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = '24224'; /*totem default `spell1` = '43301' should be in DB*/ UPDATE `creature_template` SET `ScriptName` = 'boss_janalai' WHERE `entry` = '23578'; UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_hatcher' WHERE `entry` = '23818'; UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_hatchling' WHERE `entry` = '23598'; UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_egg' WHERE `entry` = '23817'; UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_firebomb' WHERE `entry` = '23920'; UPDATE `creature_template` SET `ScriptName` = 'boss_hexlord_malacrass' WHERE `entry` =24239; UPDATE `creature_template` SET `ScriptName` = 'boss_alyson_antille' WHERE `entry` =24240; UPDATE `creature_template` SET `ScriptName` = 'boss_thurg' WHERE `entry` =24241; UPDATE `creature_template` SET `ScriptName` = 'boss_slither' WHERE `entry` =24242; UPDATE `creature_template` SET `ScriptName` = 'boss_lord_raadan' WHERE `entry` =24243; UPDATE `creature_template` SET `ScriptName` = 'boss_gazakroth' WHERE `entry` =24244; UPDATE `creature_template` SET `ScriptName` = 'boss_fenstalker' WHERE `entry` =24245; UPDATE `creature_template` SET `ScriptName` = 'boss_darkheart' WHERE `entry` =24246; UPDATE `creature_template` SET `ScriptName` = 'boss_koragg' WHERE `entry` =24247; UPDATE `creature` SET `position_x` = '117.8827',`position_y` = '921.2795',`position_z` = '33.8883',`orientation` = '1.5696' WHERE `id` = '24239' LIMIT 1; UPDATE `creature_template` SET `faction_A` = '1890', `faction_H` = '1890' WHERE `entry` in ('24240', '24241', '24242', '24243', '24244', '24245', '24246', '24247'); UPDATE `creature_template` SET `ScriptName` = 'boss_zuljin' WHERE `entry` =23863; UPDATE `creature_template` SET `ScriptName` = 'do_nothing' WHERE `entry` = '24187'; UPDATE `creature_template` SET `ScriptName` = 'mob_zuljin_vortex' WHERE `entry` = '24136'; UPDATE `creature_template` SET `minlevel` = '73', `maxlevel` = '73' WHERE `entry` IN (24187, 24136); DELETE FROM `spell_proc_event` WHERE `entry` = 43983; INSERT INTO `spell_proc_event` VALUES ('43983', '0', '0', '0', '0', '0', '16384', '0', '0'); DELETE FROM `spell_script_target` WHERE `entry` = 42577; INSERT INTO `spell_script_target` VALUES ('42577', '1', '24136'); UPDATE `creature_template` SET `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001);