diff options
| author | Rat <none@none> | 2009-04-08 15:06:06 +0200 |
|---|---|---|
| committer | Rat <none@none> | 2009-04-08 15:06:06 +0200 |
| commit | bd7955c5a94bd2967942c2df9925ca095dcbbfec (patch) | |
| tree | 6bb4b9b6868f99ec0a27d1b653509b9527c812b0 /sql | |
| parent | d89e8346f175271c934846fc5f18ee76ccffb53f (diff) | |
'small' update to Hyjal instance
*all bosses, trashes rescripted
*almost all 'events' done
*all mobs now use waypoints
*added instance gate scripts (horde gate entry: 182060, elf: 182061)
and lots of other fixes
todo:
-finish the 'cleaning waves'
-code cleanup
-fix small bugs
(istance is fully playable at corrent dev point)
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1318_world_scripts.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/sql/updates/1318_world_scripts.sql b/sql/updates/1318_world_scripts.sql new file mode 100644 index 00000000000..bae41913997 --- /dev/null +++ b/sql/updates/1318_world_scripts.sql @@ -0,0 +1,33 @@ +UPDATE `creature_template` SET `ScriptName`='mob_giant_infernal' WHERE `entry`=17908; +UPDATE `creature_template` SET `ScriptName`='mob_abomination' WHERE `entry`=17898; +UPDATE `creature_template` SET `ScriptName`='mob_ghoul' WHERE `entry`=17895; +UPDATE `creature_template` SET `ScriptName`='mob_necromancer' WHERE `entry`=17899; +UPDATE `creature_template` SET `ScriptName`='mob_banshee' WHERE `entry`=17905; +UPDATE `creature_template` SET `ScriptName`='mob_crypt_fiend' WHERE `entry`=17897; +UPDATE `creature_template` SET `ScriptName`='mob_fel_stalker' WHERE `entry`=17916; +UPDATE `creature_template` SET `ScriptName`='mob_frost_wyrm' WHERE `entry`=17907; +UPDATE `creature_template` SET `ScriptName`='mob_gargoyle' WHERE `entry`=17906; +UPDATE `creature_template` SET `ScriptName`='alliance_rifleman' WHERE `entry`=17921; + +UPDATE `creature_template` SET `ScriptName`='mob_towering_infernal' WHERE `entry`=17818; +UPDATE `creature_template` SET `ScriptName`='boss_anetheron' WHERE `entry`=17808; + +UPDATE `creature_template` SET `ScriptName`='boss_azgalor' WHERE `entry`=17842; +UPDATE `creature_template` SET `ScriptName`='mob_lesser_doomguard' WHERE `entry`=17864; + +UPDATE `creature_template` SET `ScriptName`='boss_kazrogal' WHERE `entry`=17888; + +UPDATE `creature_template` SET `ScriptName`='boss_rage_winterchill' WHERE `entry`=17767; + +UPDATE `creature_template` SET `scale`='0.5' WHERE `entry`=17968; + +UPDATE `creature_template` SET `equipment_id`='17888' WHERE `entry`=17888; +UPDATE `creature_template` SET `equipment_id`='17921' WHERE `entry`=17921; + +DELETE FROM creature_equip_template WHERE `entry` IN (17888, 17921); +INSERT INTO creature_equip_template () VALUES (17888, 45776, 0, 0, 33490946, 0, 0, 0, 0, 0); +INSERT INTO creature_equip_template () VALUES (17921, 20732, 0, 20732, 33489666, 0, 33489666, 26, 0, 26); + + + + |