diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1613_world_scripts.sql | 4 | ||||
| -rw-r--r-- | sql/updates/1614_characters_auctionhouse.sql | 2 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 2 | ||||
| -rw-r--r-- | sql/world_scripts_full.sql | 2 |
4 files changed, 6 insertions, 4 deletions
diff --git a/sql/updates/1613_world_scripts.sql b/sql/updates/1613_world_scripts.sql index 84cfbf81c88..dae1af2bfe9 100644 --- a/sql/updates/1613_world_scripts.sql +++ b/sql/updates/1613_world_scripts.sql @@ -1,3 +1,3 @@ -- Script for Skarvald and Dalronn -update creature_template set scriptname = 'boss_skarvald_the_constructor' where entry in (24200,27390); -update creature_template set scriptname = 'boss_dalronn_the_controller' where entry in (24201,27389);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`= 'boss_skarvald_the_constructor' WHERE `entry` IN (24200,27390); +UPDATE `creature_template` SET `ScriptName`= 'boss_dalronn_the_controller' WHERE `entry` IN (24201,27389);
\ No newline at end of file diff --git a/sql/updates/1614_characters_auctionhouse.sql b/sql/updates/1614_characters_auctionhouse.sql index 79423f1402d..d49ecbe2cb1 100644 --- a/sql/updates/1614_characters_auctionhouse.sql +++ b/sql/updates/1614_characters_auctionhouse.sql @@ -21,4 +21,4 @@ ALTER TABLE `auctionhousebot` ADD COLUMN `maxstackorange` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackpurple`, ADD COLUMN `maxstackyellow` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackorange`, ADD COLUMN `buyerpriceorange` int(11) default '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse' AFTER `buyerpricepurple`, - ADD COLUMN `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse' AFTER `buyerpriceorange`; + ADD COLUMN `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse' AFTER `buyerpriceorange`;
\ No newline at end of file diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index e14be0119e6..559a4d00c89 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -50,7 +50,7 @@ INSTALL(FILES 1558_world_spell_linked_spell.sql 1559_world.sql 1576_mangos_7332_01_world_command.sql -1605_mangos_7349_01_world_spell_area +1605_mangos_7349_01_world_spell_area.sql 1613_world_scripts.sql 1614_characters_auctionhouse.sql 1618_world.sql diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index 0601dc6d0f1..236d6544f40 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -908,6 +908,8 @@ UPDATE `creature_template` SET `scriptname` = 'boss_keleseth' WHERE `entry` = '2 UPDATE `creature_template` SET `scriptname` = 'mob_frost_tomb' WHERE `entry` = '23965'; UPDATE `instance_template` SET `script`='instance_utgarde_keep' WHERE `map`= '574'; UPDATE `creature_template` SET `ScriptName`='mob_vrykul_skeleton' WHERE `entry`=23970; +UPDATE `creature_template` SET `ScriptName`= 'boss_skarvald_the_constructor' WHERE `entry` IN (24200,27390); +UPDATE `creature_template` SET `ScriptName`= 'boss_dalronn_the_controller' WHERE `entry` IN (24201,27389); /* WAILING CAVERNS */ |