From 5d0cc2e531956e20643ae1a8cbe06dbef60c14f6 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 11 Oct 2014 03:02:47 +0200 Subject: DB/Gameobject: Revert hack in cabfcb1a3df7faf1425e5fecc1cc5100eec5ffb0 --- sql/updates/world/2014_10_10_06_world.sql | 12 +++++++++++ .../world/2014_10_10_06_world_smart_scripts.sql | 12 ----------- sql/updates/world/2014_10_11_00_world.sql | 23 ++++++++++++++++++++++ 3 files changed, 35 insertions(+), 12 deletions(-) create mode 100644 sql/updates/world/2014_10_10_06_world.sql delete mode 100644 sql/updates/world/2014_10_10_06_world_smart_scripts.sql create mode 100644 sql/updates/world/2014_10_11_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_10_06_world.sql b/sql/updates/world/2014_10_10_06_world.sql new file mode 100644 index 00000000000..c3fbca838b2 --- /dev/null +++ b/sql/updates/world/2014_10_10_06_world.sql @@ -0,0 +1,12 @@ +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=30945 AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `link`=28 WHERE `entryorguid`=28659 AND `source_type`=0 AND `id`=26; +UPDATE `smart_scripts` SET `link`=4 WHERE `entryorguid`=27788 AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `link`=1 WHERE `entryorguid`=26434 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=25979 AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `event_type`=61 WHERE `entryorguid`=23859 AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `link`=6 WHERE `entryorguid` IN (34965,19643) AND `source_type`=0 AND `id`=5; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` BETWEEN -23715 AND -23712 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=12996 AND `source_type`=0 AND `id`=8; +UPDATE `smart_scripts` SET `link`=8 WHERE `entryorguid`=18171 AND `source_type`=0 AND `id`=7; +UPDATE `smart_scripts` SET `link`=5 WHERE `entryorguid`=19657 AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `id`=21, `link`=0, `comment`="The Leaper - In Combat - Cast Hunger For Blood" WHERE `entryorguid`=29840 AND `source_type`=0 AND `id`=7 AND `link`=21; diff --git a/sql/updates/world/2014_10_10_06_world_smart_scripts.sql b/sql/updates/world/2014_10_10_06_world_smart_scripts.sql deleted file mode 100644 index c3fbca838b2..00000000000 --- a/sql/updates/world/2014_10_10_06_world_smart_scripts.sql +++ /dev/null @@ -1,12 +0,0 @@ -UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=30945 AND `source_type`=0 AND `id`=3; -UPDATE `smart_scripts` SET `link`=28 WHERE `entryorguid`=28659 AND `source_type`=0 AND `id`=26; -UPDATE `smart_scripts` SET `link`=4 WHERE `entryorguid`=27788 AND `source_type`=0 AND `id`=3; -UPDATE `smart_scripts` SET `link`=1 WHERE `entryorguid`=26434 AND `source_type`=0 AND `id`=0; -UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=25979 AND `source_type`=0 AND `id`=1; -UPDATE `smart_scripts` SET `event_type`=61 WHERE `entryorguid`=23859 AND `source_type`=0 AND `id`=3; -UPDATE `smart_scripts` SET `link`=6 WHERE `entryorguid` IN (34965,19643) AND `source_type`=0 AND `id`=5; -UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` BETWEEN -23715 AND -23712 AND `source_type`=0 AND `id`=0; -UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=12996 AND `source_type`=0 AND `id`=8; -UPDATE `smart_scripts` SET `link`=8 WHERE `entryorguid`=18171 AND `source_type`=0 AND `id`=7; -UPDATE `smart_scripts` SET `link`=5 WHERE `entryorguid`=19657 AND `source_type`=0 AND `id`=4; -UPDATE `smart_scripts` SET `id`=21, `link`=0, `comment`="The Leaper - In Combat - Cast Hunger For Blood" WHERE `entryorguid`=29840 AND `source_type`=0 AND `id`=7 AND `link`=21; diff --git a/sql/updates/world/2014_10_11_00_world.sql b/sql/updates/world/2014_10_11_00_world.sql new file mode 100644 index 00000000000..dcfb679e7e7 --- /dev/null +++ b/sql/updates/world/2014_10_11_00_world.sql @@ -0,0 +1,23 @@ +-- Scourge Cage +UPDATE `gameobject_template` SET `data2`=120000, AIName='SmartGameObjectAI', ScriptName='', `VerifiedBuild`=-18019 WHERE `entry` IN ( +187854, +187855, +187856, +187857, +187858, +187859, +187860, +187861, +187862, +187863, +187864, +187865, +187866, +187867, +187868, +187870, +187871, +187872, +187873, +187874 +); -- cgit v1.2.3