From 042df135067b9f18d4ffe0e54ff54f31ee45dd10 Mon Sep 17 00:00:00 2001 From: Filip Date: Sat, 14 Sep 2013 00:44:10 +0200 Subject: DB/Update: Warm Up - credit update Fixes #10804 --- sql/updates/world/2013_09_14_00_world_update.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_09_14_00_world_update.sql (limited to 'sql') diff --git a/sql/updates/world/2013_09_14_00_world_update.sql b/sql/updates/world/2013_09_14_00_world_update.sql new file mode 100644 index 00000000000..03a7515e6b3 --- /dev/null +++ b/sql/updates/world/2013_09_14_00_world_update.sql @@ -0,0 +1 @@ +UPDATE `smart_scripts` SET `target_type`=24 WHERE `entryorguid`=2935200 AND `source_type`=9 AND `id`=0 AND `link`=0; -- cgit v1.2.3 From 9c7de29e9340c7273f9aeb05a3f697e042f0530b Mon Sep 17 00:00:00 2001 From: Filip Date: Sat, 14 Sep 2013 14:20:41 +0200 Subject: DB/GO: Spell Focus for Trial of the Lake Closes #10807 --- sql/updates/world/2013_09_14_01_world_gobject.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2013_09_14_01_world_gobject.sql (limited to 'sql') diff --git a/sql/updates/world/2013_09_14_01_world_gobject.sql b/sql/updates/world/2013_09_14_01_world_gobject.sql new file mode 100644 index 00000000000..b2b59b0d794 --- /dev/null +++ b/sql/updates/world/2013_09_14_01_world_gobject.sql @@ -0,0 +1,3 @@ +DELETE FROM `gameobject` WHERE `id`= 15885; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(99849, 15885, 1, 1, 1, 7853.95, -2212.3, 456.397, 0, 0, 0, 0, 0, 0, 0, 1); -- cgit v1.2.3