aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-03-08 15:53:33 +0100
committerKillyana <morphone1@gmail.com>2018-03-08 15:53:33 +0100
commit3e7b3c15bbe8396ab371d46d179b2167f8290045 (patch)
tree2eafc25d68277454e806c5385187c4897f8b1da8 /sql
parent18222b8d5053a04c9c1665de9562d87ebccddef3 (diff)
DB/Gameobject: Replace temp gob by the correct ones
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2018_03_08_01_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_03_08_01_world.sql b/sql/updates/world/3.3.5/2018_03_08_01_world.sql
new file mode 100644
index 00000000000..733c143e6e3
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_03_08_01_world.sql
@@ -0,0 +1,7 @@
+--
+DELETE FROM `gameobject_template` WHERE `entry`=300077;
+DELETE FROM `gameobject_template_addon` WHERE `entry`=300077;
+UPDATE `gameobject` SET `id`=182140 WHERE `guid`=99918 AND `id`=300077;
+UPDATE `gameobject` SET `id`=182141 WHERE `guid`=99919 AND `id`=300077;
+UPDATE `gameobject` SET `id`=182142 WHERE `guid`=99920 AND `id`=300077;
+UPDATE `gameobject` SET `id`=182143 WHERE `guid`=99921 AND `id`=300077;