diff options
| author | blub <Vincent_Michael@gmx.de> | 2013-01-07 14:04:53 -0800 |
|---|---|---|
| committer | blub <Vincent_Michael@gmx.de> | 2013-01-07 14:04:53 -0800 |
| commit | be5d3e5fd889439b94ad2eea0ffe37f2a5ff38b3 (patch) | |
| tree | 60de9343b35b208faeb7082a4cf76b6aa6a7af58 /sql | |
| parent | 669e2ed20f3c9b6b421b5353c0d31475d64b4f20 (diff) | |
| parent | ab0d4624b8563380fe10b938f1b216fa7cb754e6 (diff) | |
Merge pull request #8755 from krofna/crofixes
Script/AQ: Implement Buru the Gorger
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_12_23_02_world_buru.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/2012_12_23_02_world_buru.sql b/sql/updates/world/2012_12_23_02_world_buru.sql new file mode 100644 index 00000000000..daab88f6cea --- /dev/null +++ b/sql/updates/world/2012_12_23_02_world_buru.sql @@ -0,0 +1,23 @@ +UPDATE `creature_template` SET ScriptName='npc_buru_egg' WHERE entry=15514; +UPDATE `creature_template` SET `faction_A`=16,`faction_H`=16 WHERE `entry` IN (15514,15370); +DELETE FROM `creature` WHERE `id`=15521; -- because **** you, thats why +SET @GUID :=xxx; -- Change me plz +DELETE FROM `creature` WHERE `id`=15514; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@GUID, 15514, 509, 1, 1, -9270.393, 1243.896, -63.76731, 2.722714, 7200, 0, 0), +(@GUID+1, 15514, 509, 1, 1, -9300.067, 1305.085, -63.69709, 4.18879, 7200, 0, 0), +(@GUID+2, 15514, 509, 1, 1, -9263.014, 1295.236, -63.80813, 1.797689, 7200, 0, 0), +(@GUID+3, 15514, 509, 1, 1, -9243.427, 1280.498, -63.59377, 3.822271, 7200, 0, 0), +(@GUID+4, 15514, 509, 1, 1, -9234.326, 1243.826, -63.52806, 3.490659, 7200, 0, 0), +(@GUID+5, 15514, 509, 1, 1, -9300.189, 1266.665, -63.74272, 0.2617994, 7200, 0, 0); +DELETE FROM `linked_respawn` WHERE `linkedGuid`=90873; +INSERT INTO `linked_respawn` (`guid`, `linkedGuid`, `linkType`) VALUES +(@GUID, 90873, 0), +(@GUID+1, 90873, 0), +(@GUID+2, 90873, 0), +(@GUID+3, 90873, 0), +(@GUID+4, 90873, 0), +(@GUID+5, 90873, 0); +DELETE FROM `spell_script_names` WHERE `spell_id`=19593; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(19593, 'spell_egg_explosion'); |