diff options
| author | teacher <none@none> | 2010-04-07 18:21:31 +0200 |
|---|---|---|
| committer | teacher <none@none> | 2010-04-07 18:21:31 +0200 |
| commit | 502fc82fb822e4245aff0530d22c013daa5d3de9 (patch) | |
| tree | 745b2826711d07ffa16e7a6abe5338c78d684d27 | |
| parent | 7afdb17ed39f85c5e9e69de8c91a0cfed9a0fe84 (diff) | |
Little sql cleanup and full update.
--HG--
branch : trunk
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 1 | ||||
| -rw-r--r-- | sql/updates/7705_characters_worldstates.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7748_word_scriptname.sql (renamed from sql/updates/7748_word_scriptnames.sql) | 0 |
3 files changed, 2 insertions, 1 deletions
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_scriptnames.sql b/sql/updates/7748_word_scriptname.sql index a9b07086f06..a9b07086f06 100644 --- a/sql/updates/7748_word_scriptnames.sql +++ b/sql/updates/7748_word_scriptname.sql |