From 7e70df2e7d08d4d2672efe07dedfc12ae5408b89 Mon Sep 17 00:00:00 2001 From: Drahy Date: Thu, 5 Feb 2009 20:06:19 +0100 Subject: * Updated CMakeLists with precious revisions * Modified sql updates to more proper version * Added script names to script_full table --HG-- branch : trunk --- sql/updates/1206_world_scripts.sql | 2 +- sql/updates/1207_world_scripts.sql | 4 ++-- sql/updates/CMakeLists.txt | 2 ++ 3 files changed, 5 insertions(+), 3 deletions(-) (limited to 'sql/updates') 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) -- cgit v1.2.3