From 8d1e542231d80efd5c06cc567571d611a454af3d Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 00:50:38 +0100 Subject: DB/Script : kill more gameobject_scripts. THIS UNSUPPORTS THE FOLLOWING DUNGEON BOSSES: Scholomance: Kirtenos the Herald Scarlet Monestry - Cathedral: Fairbanks, Mograine, Whitemane --- sql/updates/world/2013_01_02_12_world_go_script.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2013_01_02_12_world_go_script.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_12_world_go_script.sql b/sql/updates/world/2013_01_02_12_world_go_script.sql new file mode 100644 index 00000000000..aea0a67c47e --- /dev/null +++ b/sql/updates/world/2013_01_02_12_world_go_script.sql @@ -0,0 +1,11 @@ +-- remove the summoning of the herald and closing of the gate via the brazier +-- this is an instance encounter and should be handled via cpp, reopen the door if npc is dead +DELETE FROM `gameobject_scripts` WHERE `id`=43208; + +-- This script will NOT work untill CPP changes are made, this UNSUPPORTS Scarlet Monestry Cathedral wing! +DELETE FROM `gameobject_scripts` WHERE `id` IN (11881,11894); +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (104589,97701); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (104589,97701) AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(104589,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,11875,104591,0,0,0,0,0,'Lever - On activate - Activate Chapel Door'), +( 97701,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,11876, 97700,0,0,0,0,0,'Torch - On activate - Activate Secret Door'); -- cgit v1.2.3 From a7a23cca342a9cade8edd32c72e5180cd412c9ef Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 01:12:04 +0100 Subject: DB/Script: More horribad script removals: Zul gurub: Brazier summons 4 creatures, removed 3 bad spawns, and unsupported the encounters starting with Gri'lek Fix the MovementType issue Closes #8834 --- sql/updates/world/2013_01_03_00_world_gameobject_scripts.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2013_01_03_00_world_gameobject_scripts.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_00_world_gameobject_scripts.sql b/sql/updates/world/2013_01_03_00_world_gameobject_scripts.sql new file mode 100644 index 00000000000..32faf4b03a0 --- /dev/null +++ b/sql/updates/world/2013_01_03_00_world_gameobject_scripts.sql @@ -0,0 +1,6 @@ +-- the brazier should summon multiple bosses, this is part of +-- an instance encounter and should be handled via cpp +DELETE FROM `gameobject_scripts` WHERE `id` IN (28704,21608,21609,21610); +DELETE FROM gameobject WHERE guid IN (21608,21609,21610); +-- while at it, fix startup issue with npc 3939 +UPDATE `creature` SET `MovementType`=0 WHERE `id`=3939; -- cgit v1.2.3 From c6ed15f826d4fccc3db85bc5be6d7b82a6d5e08b Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 01:31:06 +0100 Subject: DB/Script: more gameobject_script removals: Stasis Chamber Alpha conversion --- sql/updates/world/2013_01_03_01_world_sai.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2013_01_03_01_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_01_world_sai.sql b/sql/updates/world/2013_01_03_01_world_sai.sql new file mode 100644 index 00000000000..9e0e56eb645 --- /dev/null +++ b/sql/updates/world/2013_01_03_01_world_sai.sql @@ -0,0 +1,7 @@ +DELETE FROM `gameobject_scripts` WHERE `id`=47301; +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=185512; +DELETE FROM `smart_scripts` WHERE `entryorguid`=185512 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18551200 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(185512,1,0,0,70,0,100,0,2,0,0,0,80,18551200,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Stasis Chamber Alpha - On Activate - Start Script'), +(18551200,9,0,0,0,0,100,0,10000,10000,0,0,12,22920,1,300000,0,1,0,8,0,0,0,3989.02,6071.37,266.41,3.72,'Script - After 10s - Summon Thuk the Defiant'); -- cgit v1.2.3 From ec1d17f2073bd74fb7366f3cd811466622a08220 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 02:00:10 +0100 Subject: DB/Scripts: More removals of gameobject_scripts UNSUPPORTS old treasure chest in Scholomance --- sql/updates/world/2013_01_03_02_world_sai.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2013_01_03_02_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_02_world_sai.sql b/sql/updates/world/2013_01_03_02_world_sai.sql new file mode 100644 index 00000000000..ecd84c96800 --- /dev/null +++ b/sql/updates/world/2013_01_03_02_world_sai.sql @@ -0,0 +1,10 @@ +DELETE FROM `gameobject_scripts` WHERE `id` IN (43177,44809,44811,45625,45428,61664); +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (193020,175432,176767,101852,101853,177385); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (193020,175432,176767,101852,101853,177385) AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(193020,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,61606,193019,0,0,0,0,0, 'Lever - On activate - Activate The Violet Hold'), +(175432,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,45626,175369,0,0,0,0,0, ' - On activate - Activate Elders Square Service Entrance'), +(176767,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,45427,174626,0,0,0,0,0, 'Torch - On activate - Activate Scholomance Door'), +(101852,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,15013,101851,0,0,0,0,0, 'Lever - On activate - Activate Armory Door'), +(101853,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,15012,101850,0,0,0,0,0, 'Lever - On activate - Activate Cathedral Door'), +(177385,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,43178,175610,0,0,0,0,0, 'Torch - On activate - Activate Door'); -- cgit v1.2.3 From 43f1c08e96202a19acf520cc7fe4bfcbaf7c65dc Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Thu, 3 Jan 2013 02:52:13 +0100 Subject: DB/Ulduar: Fix Kologarn Stone Grip in 25m mode --- sql/updates/world/2013_01_03_03_world_spelldifficulty_dbc.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2013_01_03_03_world_spelldifficulty_dbc.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_03_world_spelldifficulty_dbc.sql b/sql/updates/world/2013_01_03_03_world_spelldifficulty_dbc.sql new file mode 100644 index 00000000000..6a41f705491 --- /dev/null +++ b/sql/updates/world/2013_01_03_03_world_spelldifficulty_dbc.sql @@ -0,0 +1,3 @@ +DELETE FROM `spelldifficulty_dbc` WHERE `id`=62166 OR `spellid0`=62166; +INSERT INTO `spelldifficulty_dbc`(`id`,`spellid0`,`spellid1`) VALUES +(62166,62166,63981); -- Stone Grip -- cgit v1.2.3 From 8403081240f37953b5f2617f6494b179ac45ab21 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 11:14:10 +0100 Subject: DB/Script: More removal of gameobject scripts. some of the doors do not work yet, this is a known issue --- sql/updates/world/2013_01_03_world_sai.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/2013_01_03_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_world_sai.sql b/sql/updates/world/2013_01_03_world_sai.sql new file mode 100644 index 00000000000..ccac9266af2 --- /dev/null +++ b/sql/updates/world/2013_01_03_world_sai.sql @@ -0,0 +1,14 @@ +UPDATE `gameobject` SET `position_x`=-113.4616,`position_y`=2165.083,`position_z`=156.7546,`orientation`=1.195702,`rotation0`=0.6946974,`rotation1`=-0.1318922,`rotation2`=0.6946964,`rotation3`=0.1318972,`spawntimesecs`=7200,`animprogress`=255 WHERE `guid`=32480; + +DELETE FROM `gameobject_scripts` WHERE `id` IN (32260,32378,32480,32625,32442,32443,32444,34006); +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (18900,18901,18899,90567,101811,101812,101855,185501); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18900,18901,18899,90567,101811,101812,101855,185501) AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +( 18900,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32445,18934,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), +( 18901,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,33219,18936,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), +( 18899,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,33241,18971,0,0,0,0,0, 'Lever - On activate - Activate Arugals Lair'), +( 90567,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32373,90566,0,0,0,0,0, 'Lever - On activate - Activate Workshop Door'), +(101811,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32446,18935,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), +(101812,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,20835,18895,0,0,0,0,0, 'Lever - On activate - Activate Courtyard Door'), +(101855,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32250,101854,0,0,0,0,0, 'Lever - On activate - Activate Herods Door'), +(185501,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,25064,184212,0,0,0,0,0, 'Waterfall Control Console - On activate - Activate Waterfall'); -- cgit v1.2.3 From 5ae81724f3ab5631ea1b28238976c4a4a62e668e Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 11:25:34 +0100 Subject: DB/Script: more conversions THIS UNSUPPORTS THE BLACKROCK DUNGEON untill a fix is found for SAI issues also fixed naming of file --- sql/updates/world/2013_01_03_04_world_sai.sql | 14 ++++++++++++++ sql/updates/world/2013_01_03_05_world_sai.sql | 8 ++++++++ sql/updates/world/2013_01_03_world_sai.sql | 14 -------------- 3 files changed, 22 insertions(+), 14 deletions(-) create mode 100644 sql/updates/world/2013_01_03_04_world_sai.sql create mode 100644 sql/updates/world/2013_01_03_05_world_sai.sql delete mode 100644 sql/updates/world/2013_01_03_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_04_world_sai.sql b/sql/updates/world/2013_01_03_04_world_sai.sql new file mode 100644 index 00000000000..ccac9266af2 --- /dev/null +++ b/sql/updates/world/2013_01_03_04_world_sai.sql @@ -0,0 +1,14 @@ +UPDATE `gameobject` SET `position_x`=-113.4616,`position_y`=2165.083,`position_z`=156.7546,`orientation`=1.195702,`rotation0`=0.6946974,`rotation1`=-0.1318922,`rotation2`=0.6946964,`rotation3`=0.1318972,`spawntimesecs`=7200,`animprogress`=255 WHERE `guid`=32480; + +DELETE FROM `gameobject_scripts` WHERE `id` IN (32260,32378,32480,32625,32442,32443,32444,34006); +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (18900,18901,18899,90567,101811,101812,101855,185501); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18900,18901,18899,90567,101811,101812,101855,185501) AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +( 18900,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32445,18934,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), +( 18901,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,33219,18936,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), +( 18899,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,33241,18971,0,0,0,0,0, 'Lever - On activate - Activate Arugals Lair'), +( 90567,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32373,90566,0,0,0,0,0, 'Lever - On activate - Activate Workshop Door'), +(101811,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32446,18935,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), +(101812,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,20835,18895,0,0,0,0,0, 'Lever - On activate - Activate Courtyard Door'), +(101855,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32250,101854,0,0,0,0,0, 'Lever - On activate - Activate Herods Door'), +(185501,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,25064,184212,0,0,0,0,0, 'Waterfall Control Console - On activate - Activate Waterfall'); diff --git a/sql/updates/world/2013_01_03_05_world_sai.sql b/sql/updates/world/2013_01_03_05_world_sai.sql new file mode 100644 index 00000000000..9e5537835ff --- /dev/null +++ b/sql/updates/world/2013_01_03_05_world_sai.sql @@ -0,0 +1,8 @@ +DELETE FROM `gameobject_scripts` WHERE `id`=15351; +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=161460; +DELETE FROM `smart_scripts` WHERE `entryorguid`=161460 AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(161460,1,0,1,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,15639,161461,0,0,0,0,0, 'Shadowforge Lock - On Activate - Open the Giant Door Mechanism'), +(161460,1,1,2,61,0,100,0,0,0,0,0,9,0,0,0,0,0,0,14,15576,157923,0,0,0,0,0, 'Shadowforge Lock - On Activate - Close the Giant Doors'), +(161460,1,2,3,61,0,100,0,0,0,0,0,9,0,0,0,0,0,0,14,15640,161462,0,0,0,0,0, 'Shadowforge Lock - On Activate - Remove the great invisible wall'), +(161460,1,3,0,61,0,100,0,0,0,0,0,9,0,0,0,0,0,0,14,15352,161516,0,0,0,0,0, 'Shadowforge Lock - On Activate - Remove the invisible wall on top'); diff --git a/sql/updates/world/2013_01_03_world_sai.sql b/sql/updates/world/2013_01_03_world_sai.sql deleted file mode 100644 index ccac9266af2..00000000000 --- a/sql/updates/world/2013_01_03_world_sai.sql +++ /dev/null @@ -1,14 +0,0 @@ -UPDATE `gameobject` SET `position_x`=-113.4616,`position_y`=2165.083,`position_z`=156.7546,`orientation`=1.195702,`rotation0`=0.6946974,`rotation1`=-0.1318922,`rotation2`=0.6946964,`rotation3`=0.1318972,`spawntimesecs`=7200,`animprogress`=255 WHERE `guid`=32480; - -DELETE FROM `gameobject_scripts` WHERE `id` IN (32260,32378,32480,32625,32442,32443,32444,34006); -UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (18900,18901,18899,90567,101811,101812,101855,185501); -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18900,18901,18899,90567,101811,101812,101855,185501) AND `source_type`=1; -INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -( 18900,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32445,18934,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), -( 18901,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,33219,18936,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), -( 18899,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,33241,18971,0,0,0,0,0, 'Lever - On activate - Activate Arugals Lair'), -( 90567,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32373,90566,0,0,0,0,0, 'Lever - On activate - Activate Workshop Door'), -(101811,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32446,18935,0,0,0,0,0, 'Lever - On activate - Activate Cell Door'), -(101812,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,20835,18895,0,0,0,0,0, 'Lever - On activate - Activate Courtyard Door'), -(101855,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,32250,101854,0,0,0,0,0, 'Lever - On activate - Activate Herods Door'), -(185501,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,25064,184212,0,0,0,0,0, 'Waterfall Control Console - On activate - Activate Waterfall'); -- cgit v1.2.3 From c56a83e85c869fb1cfff0162fdf74edfcaec9f5a Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 11:46:51 +0100 Subject: DB/Scripts and more gameobject_script removals, only 1 left?! --> please not that not all doors may function yet. this is a known issue --- sql/updates/world/2013_01_03_06_world_sai.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2013_01_03_06_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_06_world_sai.sql b/sql/updates/world/2013_01_03_06_world_sai.sql new file mode 100644 index 00000000000..e77122e908e --- /dev/null +++ b/sql/updates/world/2013_01_03_06_world_sai.sql @@ -0,0 +1,11 @@ +DELETE FROM `gameobject_scripts` WHERE `id` IN (24397,24398,25980,26188,26192); +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (101831,101832,101833,101834,183517,183518,185123); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (101831,101832,101833,101834,183517,183518,185123) AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(101831,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,30533,13965,0,0,0,0,0, 'Door Lever - On activate - Activate Factory Door'), +(101832,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,26185,17153,0,0,0,0,0, 'Door Lever - On activate - Activate Heavy Door'), +(101833,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,30534,16397,0,0,0,0,0, 'Door Lever - On activate - Activate Iron Clad Door'), +(101834,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,26182,17153,0,0,0,0,0, 'Door Lever - On activate - Activate Heavy Door'), +(183517,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,25826,184912,0,0,0,0,0, 'Lever - On activate - Activate The Shattered Halls'), +(183518,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,24141,183294,0,0,0,0,0, 'Lever - On activate - Activate The Shadow Labyrinth'), +(185123,1,0,0,70,0,100,0,2,0,0,0,9,0,0,0,0,0,0,14,25083,184246,0,0,0,0,0, 'Lever - On activate - Activate Heavy Iron Portcullis'); -- cgit v1.2.3 From abcc6c5fd8d25c981c5bf76c5cd10b69008e1d43 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 11:52:27 +0100 Subject: DB/SAI: converted the last gameobject_script to SAI, jeej! --- sql/updates/world/2013_01_03_07_world_sai.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2013_01_03_07_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_07_world_sai.sql b/sql/updates/world/2013_01_03_07_world_sai.sql new file mode 100644 index 00000000000..35a03b9078c --- /dev/null +++ b/sql/updates/world/2013_01_03_07_world_sai.sql @@ -0,0 +1,6 @@ +DELETE FROM `gameobject_scripts` WHERE `id` IN (12609,26185,30534); +DELETE FROM `smart_scripts` WHERE `entryorguid`=177673 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=17767300 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(177673,1,0,0,70,0,100,0,2,0,0,0,80,17767300,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Serpent Statue - On activate - Start Script'), +(17767300,9,0,0,1,0,100,0,2000,2000,0,0,12,12369,1,300000,0,1,0,8,0,0,0,251.381,2962.47,2.76527,0.860446, 'Serpent Statue - After 2s - Summon Lord Kragaru'); -- cgit v1.2.3 From afc21ccf29dfdf27176bf593907278ed547d6af0 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 11:57:43 +0100 Subject: DB/Misc: remove the scripts! --- sql/updates/world/2013_01_03_08_world_misc.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2013_01_03_08_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_08_world_misc.sql b/sql/updates/world/2013_01_03_08_world_misc.sql new file mode 100644 index 00000000000..816b4b4dcf6 --- /dev/null +++ b/sql/updates/world/2013_01_03_08_world_misc.sql @@ -0,0 +1,2 @@ +-- remove the leverscript not non-existing doorscripts! +DELETE FROM `gameobject_scripts` WHERE `id` IN (26206,26197); -- cgit v1.2.3 From 0cba1013150888cf690c5fab1b08ef2a30879192 Mon Sep 17 00:00:00 2001 From: JunkyBulgaria Date: Thu, 3 Jan 2013 15:39:47 +0100 Subject: DB/SAI: SAI for some of the trash in ICC Closes #8773 --- sql/updates/world/2013_01_03_09_world_sai.sql | 81 +++++++++++++++++++++++++++ 1 file changed, 81 insertions(+) create mode 100644 sql/updates/world/2013_01_03_09_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_09_world_sai.sql b/sql/updates/world/2013_01_03_09_world_sai.sql new file mode 100644 index 00000000000..c15eeb88843 --- /dev/null +++ b/sql/updates/world/2013_01_03_09_world_sai.sql @@ -0,0 +1,81 @@ +-- Servant of the Throne [SAI] +SET @ENTRY := 36724; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,@SOURCETYPE,3,0,0,0,100,30,5000,7000,5000,9000,11,70980,0,0,0,0,0,4,0,0,0,0,0,0,0, 'Cast Web Wrap'), +(@ENTRY,@SOURCETYPE,1,0,0,0,100,0,3000,6000,6000,12000,11,71029,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Cast Glacial Blast'); +-- Ancient Skeletal Soldier +SET @ENTRY := 37012; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,3,0,0,0,100,30,5000,7000,5000,9000,11,70980,0,0,0,0,0,4,0,0,0,0,0,0,0, 'Cast Web Wrap'), +(@ENTRY,@SOURCETYPE,0,0,0,0,100,0,3000,6000,6000,8000,11,70964,2,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Cast Shield Bash(70964)'); +-- Nerub'ar Broodkeeper +SET @ENTRY := 36725; +SET @SOURCETYPE :=0; +UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=@ENTRY; +DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY; +DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY; +INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES +(@ENTRY,@SOURCETYPE,1,0,10,0,100,30,1,60,1000,1000,38,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Nerub''ar Broodkeeper - On LOS - Zone Combat Pulse'), +(@ENTRY,@SOURCETYPE,2,0,0,0,100,30,5000,7000,5000,9000,11,70965,0,0,0,0,0,4,0,0,0,0,0,0,0, 'Nerub''ar Broodkeeper - In Combat - Cast Crypt Scarabs'), +(@ENTRY,@SOURCETYPE,3,0,0,0,100,30,5000,7000,5000,9000,11,70980,0,0,0,0,0,4,0,0,0,0,0,0,0, 'Nerub''ar Broodkeeper - In Combat - Cast Web Wrap'), +(@ENTRY,@SOURCETYPE,4,0,14,0,100,30,5000,30,8000,13000,11,36725,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Nerub''ar Broodkeeper - In Combat - Cast Dark Mending on Friendlies'); +-- Deathbound Ward +SET @ENTRY := 37007; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,@SOURCETYPE,0,0,0,0,100,0,3000,6000,6000,8000,11,71021,2,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Saber Lash'), +(@ENTRY,@SOURCETYPE,1,0,0,0,100,0,6000,8000,6000,12000,11,71022,2,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Disrupting Shout'); +-- Entrance Mobs End +-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +-- Starting Mobs infront Lady Deathwhisper +-- Deathspeaker Zealot +SET @ENTRY := 36808; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,@SOURCETYPE,0,0,0,0,100,0,3000,6000,6000,8000,11,69492,2,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Shadow Cleave'); +-- Deathspeaker Servant +SET @ENTRY := 36805; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,@SOURCETYPE,0,0,0,0,100,0,3000,6000,6000,8000,11,69576,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Chaos Bolt'), +(@ENTRY,@SOURCETYPE,1,0,0,0,100,0,3000,6000,6000,8000,11,69405,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Consuming Shadows'), +(@ENTRY,@SOURCETYPE,2,0,0,0,100,0,3000,6000,6000,8000,11,69404,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Curse of Agony'); +-- Deathspeaker Attendant +SET @ENTRY := 36811; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,@SOURCETYPE,0,0,0,0,100,0,3000,6000,6000,8000,11,69387,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Cast Shadow Bolt'), +(@ENTRY,@SOURCETYPE,1,0,0,0,100,0,3000,6000,6000,8000,11,69355,0,0,0,0,0,18,15,0,0,0.0,0.0,0.0,0.0,'Cast Shadow Nova on 15 yard distance'); +-- Deathspeaker Disciple +DELETE FROM smart_scripts WHERE entryorguid = 36807 AND source_type = 0; +SET @ENTRY := 36807; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@ENTRY, @SOURCETYPE, 0, 0, 0, 0, 100, 30, 0, 3000, 4000, 6000, 11, 69387, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Deathspeaker Disciple - Cast Shadow Bolt'), +(@ENTRY, @SOURCETYPE, 1, 0, 16, 0, 100, 30, 69391, 40, 15000, 20000, 11, 69391, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Deathspeaker Disciple - Cast Dark Blessing'), +(@ENTRY, @SOURCETYPE, 2, 0, 14, 0, 100, 30, 90000, 40, 15000, 20000, 11, 69389, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Deathspeaker Disciple - Cast Shadow Mend'); +-- Deathspeaker High Priest [SAI] +SET @ENTRY := 36829; +SET @SOURCETYPE := 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; +UPDATE creature_template SET AIName='SmartAI' WHERE entry=@ENTRY LIMIT 1; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,@SOURCETYPE,0,0,0,0,100,0,3000,6000,10000,15000,11,69483,2,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,'Cast Dark Reckoning'), +(@ENTRY,@SOURCETYPE,1,0,32,0,100,1,0,10000,0,0,11,69491,2,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Cast Aura of Darkness On Self'); -- when combat starts -- cgit v1.2.3 From 9e6344b220c1f369be14f68b87648a75d3e8bcb4 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 15:47:24 +0100 Subject: DB/Gameobject: Add Invincible Grave Plaque Closes #8693 --- sql/updates/world/2013_01_03_10_world_gameobject.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2013_01_03_10_world_gameobject.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_10_world_gameobject.sql b/sql/updates/world/2013_01_03_10_world_gameobject.sql new file mode 100644 index 00000000000..11700da1dc9 --- /dev/null +++ b/sql/updates/world/2013_01_03_10_world_gameobject.sql @@ -0,0 +1,4 @@ +-- Issue 8693 Invincible Grave Plaque +DELETE FROM `gameobject` WHERE `guid`=364; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(364,192835,0,1,1,2044.38,-520.9688,46.01406,-3.097385,0,0,0,1,120,255,1); -- cgit v1.2.3 From 0419abf2235a2df46cb996d0f11c7ade8545840b Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 3 Jan 2013 15:54:15 +0100 Subject: DB/Item: add proper flags to real-life-duration items Closes #3601 --- sql/updates/world/2013_01_03_11_world_item_template.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2013_01_03_11_world_item_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_03_11_world_item_template.sql b/sql/updates/world/2013_01_03_11_world_item_template.sql new file mode 100644 index 00000000000..df0bd5cd1e7 --- /dev/null +++ b/sql/updates/world/2013_01_03_11_world_item_template.sql @@ -0,0 +1,2 @@ +-- make sure timers are real-time via flagsCustom +UPDATE `item_template` SET `flagsCustom`=`flagsCustom`|1 WHERE `entry` IN(39878,44623,44625,44626,44632,44717); -- cgit v1.2.3