From 502fc82fb822e4245aff0530d22c013daa5d3de9 Mon Sep 17 00:00:00 2001 From: teacher Date: Wed, 7 Apr 2010 18:21:31 +0200 Subject: Little sql cleanup and full update. --HG-- branch : trunk --- sql/FULL/world_scripts_full.sql | 1 + sql/updates/7705_characters_worldstates.sql | 2 +- sql/updates/7748_word_scriptname.sql | 3 +++ sql/updates/7748_word_scriptnames.sql | 3 --- 4 files changed, 5 insertions(+), 4 deletions(-) create mode 100644 sql/updates/7748_word_scriptname.sql delete mode 100644 sql/updates/7748_word_scriptnames.sql (limited to 'sql') diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 35c429ee480..7e9651d759a 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -420,6 +420,7 @@ UPDATE `item_template` SET `scriptname`='item_dehta_trap_smasher' WHERE `entry`= UPDATE `creature_template` SET `ScriptName`='npc_magmoth_crusher' WHERE `entry`=25434; UPDATE `creature_template` SET `ScriptName`='npc_valiance_keep_cannoneer' WHERE `entry`=25306; UPDATE `creature_template` SET `ScriptName`='npc_warmage_coldarra' WHERE `entry` IN (27173,27904,27906); +UPDATE `creature_template` SET `ScriptName`= 'npc_valiance_keep_cannoneer' WHERE `entry`=25306; /* BURNING STEPPES */ UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563; diff --git a/sql/updates/7705_characters_worldstates.sql b/sql/updates/7705_characters_worldstates.sql index 7c43bc06617..39e731b679b 100644 --- a/sql/updates/7705_characters_worldstates.sql +++ b/sql/updates/7705_characters_worldstates.sql @@ -6,4 +6,4 @@ RENAME `worldstates`, ROW_FORMAT=DYNAMIC; -- Only posible value is NextArenaPointDistributionTime so make the conversion to custom worldstate -UPDATE `worldstates` SET `entry`=20001, `comment`='NextArenaPointDistributionTime'; \ No newline at end of file +UPDATE `worldstates` SET `entry`=20001, `comment`='NextArenaPointDistributionTime'; diff --git a/sql/updates/7748_word_scriptname.sql b/sql/updates/7748_word_scriptname.sql new file mode 100644 index 00000000000..a9b07086f06 --- /dev/null +++ b/sql/updates/7748_word_scriptname.sql @@ -0,0 +1,3 @@ +UPDATE `areatrigger_scripts` SET `ScriptName`='at_aldurthar_gate' WHERE `entry` IN (5284,5285,5286,5287); +UPDATE `areatrigger_scripts` SET `ScriptName`='at_warsong_farms' WHERE `entry` IN (4871,4872,4873); +UPDATE `areatrigger_scripts` SET `ScriptName`='at_stormwright_shelf' WHERE `entry`=5108; diff --git a/sql/updates/7748_word_scriptnames.sql b/sql/updates/7748_word_scriptnames.sql deleted file mode 100644 index a9b07086f06..00000000000 --- a/sql/updates/7748_word_scriptnames.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `areatrigger_scripts` SET `ScriptName`='at_aldurthar_gate' WHERE `entry` IN (5284,5285,5286,5287); -UPDATE `areatrigger_scripts` SET `ScriptName`='at_warsong_farms' WHERE `entry` IN (4871,4872,4873); -UPDATE `areatrigger_scripts` SET `ScriptName`='at_stormwright_shelf' WHERE `entry`=5108; -- cgit v1.2.3