aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorDrahy <none@none>2009-02-05 20:06:19 +0100
committerDrahy <none@none>2009-02-05 20:06:19 +0100
commit7e70df2e7d08d4d2672efe07dedfc12ae5408b89 (patch)
treec315915a119a371907af91e8cf8026e4950035f0 /sql/updates
parentb045829900f4b9e747dc14d66304218f9c574add (diff)
* Updated CMakeLists with precious revisions
* Modified sql updates to more proper version * Added script names to script_full table --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/1206_world_scripts.sql2
-rw-r--r--sql/updates/1207_world_scripts.sql4
-rw-r--r--sql/updates/CMakeLists.txt2
3 files changed, 5 insertions, 3 deletions
diff --git a/sql/updates/1206_world_scripts.sql b/sql/updates/1206_world_scripts.sql
index b48a714ffbc..b35e054f57c 100644
--- a/sql/updates/1206_world_scripts.sql
+++ b/sql/updates/1206_world_scripts.sql
@@ -1 +1 @@
-UPDATE `gameobject_template` SET `ScriptName` = 'go_legion_obelisk' WHERE `entry` = 185193; UPDATE `gameobject_template` SET `ScriptName` = 'go_legion_obelisk' WHERE `entry` = 185195; UPDATE `gameobject_template` SET `ScriptName` = 'go_legion_obelisk' WHERE `entry` = 185196; UPDATE `gameobject_template` SET `ScriptName` = 'go_legion_obelisk' WHERE `entry` = 185197; UPDATE `gameobject_template` SET `ScriptName` = 'go_legion_obelisk' WHERE `entry` = 185198; \ No newline at end of file
+UPDATE `gameobject_template` SET `ScriptName`='go_legion_obelisk' WHERE `entry` IN (185193,185195,185196,185197,185198); \ No newline at end of file
diff --git a/sql/updates/1207_world_scripts.sql b/sql/updates/1207_world_scripts.sql
index addabe98f1b..ac955837516 100644
--- a/sql/updates/1207_world_scripts.sql
+++ b/sql/updates/1207_world_scripts.sql
@@ -1,2 +1,2 @@
-UPDATE creature_template SET ScriptName='npc_surristrasz' WHERE entry=24795;
-UPDATE creature_template SET ScriptName='npc_tiare' WHERE entry=30051;
+UPDATE `creature_template` SET `ScriptName`='npc_surristrasz' WHERE `entry`=24795;
+UPDATE `creature_template` SET `ScriptName`='npc_tiare' WHERE `entry`=30051; \ No newline at end of file
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 75df4d2bcd6..975d18ef279 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -18,4 +18,6 @@ INSTALL(FILES
1185_(mangos_7214)_01_world_command.sql
1185_(mangos_7214)_02_world_trinity_string.sql
1185_(mangos_7214)_03_mangos_spell_proc_event.sql
+1206_world_scripts.sql
+1207_world_scripts.sql
DESTINATION share/trinity/sql/updates)