aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2012-04-20 23:00:17 +0200
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2012-04-20 23:00:17 +0200
commita16b07188f6e57eeb17d468638a127f6237666f4 (patch)
treebca39ad20f7b5dd4b264a24c23080b82e3311328
parentb3f0c7fbcfdce2fb825269c368838a49e9f879df (diff)
DB/Gameobject: Fix Horrible error from UP34
-rw-r--r--sql/updates/world/2012_04_20_05_gameobject_template.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_20_05_gameobject_template.sql b/sql/updates/world/2012_04_20_05_gameobject_template.sql
new file mode 100644
index 00000000000..6fdd2be9f2f
--- /dev/null
+++ b/sql/updates/world/2012_04_20_05_gameobject_template.sql
@@ -0,0 +1,8 @@
+-- Restore horrible mistake in UP34 from myself
+UPDATE `gameobject_template` SET `data1`=27512 WHERE `entry`=195669;
+UPDATE `gameobject_template` SET `data1`=27517 WHERE `entry`=195670;
+UPDATE `gameobject_template` SET `data1`=27518 WHERE `entry`=195671;
+-- Fix loottemplates along with it
+UPDATE `gameobject_loot_template` SET `entry`=27512 WHERE `entry`=195669
+UPDATE `gameobject_loot_template` SET `entry`=27517 WHERE `entry`=195670;
+UPDATE `gameobject_loot_template` SET `entry`=27518 WHERE `entry`=195671;