diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1304_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/2.4.3_updates/1247_world.sql (renamed from sql/updates/1247_world.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/2.4.3_updates/1249_world.sql (renamed from sql/updates/1249_world.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/2.4.3_updates/1261_world.sql (renamed from sql/updates/1261_world.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/2.4.3_updates/1265_world.sql (renamed from sql/updates/1265_world.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/2.4.3_updates/1304_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/2432_mangos_7615_01_world_command.sql (renamed from sql/updates/7615_01_mangos_command.sql) | 5 | ||||
| -rw-r--r-- | sql/updates/2433_mangos_7616_01_world_trinity_string.sql | 6 | ||||
| -rw-r--r-- | sql/updates/2433_mangos_7616_02_world_command.sql (renamed from sql/updates/7616_02_mangos_command.sql) | 5 | ||||
| -rw-r--r-- | sql/updates/2450_world.sql | 7 | ||||
| -rw-r--r-- | sql/updates/7616_01_mangos_mangos_string.sql | 6 | ||||
| -rw-r--r-- | sql/world_scripts_full.sql | 4 |
12 files changed, 28 insertions, 19 deletions
diff --git a/sql/updates/1304_world.sql b/sql/updates/1304_world.sql deleted file mode 100644 index 52663b214f3..00000000000 --- a/sql/updates/1304_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -delete from command where name in ('reload spell_linked_spell'); -insert into command (name, security, help) values -('reload spell_linked_spell','3','Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.'), diff --git a/sql/updates/1247_world.sql b/sql/updates/2.4.3_updates/1247_world.sql index 2e9a7088beb..324e4b142c1 100644 --- a/sql/updates/1247_world.sql +++ b/sql/updates/2.4.3_updates/1247_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_jump_a_tron' WHERE `entry` = 183146; +UPDATE `gameobject_template` SET `ScriptName` = 'go_jump_a_tron' WHERE `entry` = 183146;
\ No newline at end of file diff --git a/sql/updates/1249_world.sql b/sql/updates/2.4.3_updates/1249_world.sql index 6ce0e777210..4799b67e540 100644 --- a/sql/updates/1249_world.sql +++ b/sql/updates/2.4.3_updates/1249_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421;
\ No newline at end of file diff --git a/sql/updates/1261_world.sql b/sql/updates/2.4.3_updates/1261_world.sql index 3f97153d3dd..8433b5137e3 100644 --- a/sql/updates/1261_world.sql +++ b/sql/updates/2.4.3_updates/1261_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `scriptname` = 'go_sacred_fire_of_life' WHERE `entry` = 175944; +UPDATE `gameobject_template` SET `scriptname` = 'go_sacred_fire_of_life' WHERE `entry` = 175944;
\ No newline at end of file diff --git a/sql/updates/1265_world.sql b/sql/updates/2.4.3_updates/1265_world.sql index 5b5b87523cc..668718cd5f6 100644 --- a/sql/updates/1265_world.sql +++ b/sql/updates/2.4.3_updates/1265_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `scriptname`='go_skull_pile' WHERE `entry`=185913; +UPDATE `gameobject_template` SET `scriptname`='go_skull_pile' WHERE `entry`=185913;
\ No newline at end of file diff --git a/sql/updates/2.4.3_updates/1304_world.sql b/sql/updates/2.4.3_updates/1304_world.sql new file mode 100644 index 00000000000..7eec5331e50 --- /dev/null +++ b/sql/updates/2.4.3_updates/1304_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` IN ('reload spell_linked_spell'); +INSERT INTO `command` VALUES +('reload spell_linked_spell','3','Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.');
\ No newline at end of file diff --git a/sql/updates/7615_01_mangos_command.sql b/sql/updates/2432_mangos_7615_01_world_command.sql index 17e208a5baa..0f1d14d8520 100644 --- a/sql/updates/7615_01_mangos_command.sql +++ b/sql/updates/2432_mangos_7615_01_world_command.sql @@ -1,9 +1,8 @@ -ALTER TABLE db_version CHANGE COLUMN required_7568_01_mangos_spell_proc_event required_7615_01_mangos_command bit; +/*ALTER TABLE db_version CHANGE COLUMN required_7568_01_mangos_spell_proc_event required_7615_01_mangos_command bit;*/ DELETE FROM `command` WHERE `name` IN ('senditems','sendmail','sendmoney','sendmessage','send items','send mail','send money','send message'); - INSERT INTO `command` VALUES ('send items',3,'Syntax: .send items #playername "#subject" "#text" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in "". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'), ('send mail',1,'Syntax: .send mail #playername "#subject" "#text"\r\n\r\nSend a mail to a player. Subject and mail text must be in "".'), ('send message',3,'Syntax: .send message $playername $message\r\n\r\nSend screen message to player from ADMINISTRATOR.'), -('send money','3','Syntax: .send money #playername "#subject" "#text" #money\r\n\r\nSend mail with money to a player. Subject and mail text must be in "".'); +('send money','3','Syntax: .send money #playername "#subject" "#text" #money\r\n\r\nSend mail with money to a player. Subject and mail text must be in "".');
\ No newline at end of file diff --git a/sql/updates/2433_mangos_7616_01_world_trinity_string.sql b/sql/updates/2433_mangos_7616_01_world_trinity_string.sql new file mode 100644 index 00000000000..d358f72391e --- /dev/null +++ b/sql/updates/2433_mangos_7616_01_world_trinity_string.sql @@ -0,0 +1,6 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7615_01_mangos_command required_7616_01_mangos_mangos_string bit;*/ + +DELETE FROM `trinity_string` WHERE `entry` IN (1200,1201); +INSERT INTO `trinity_string` VALUES +(1200,'You try to view cinemitic %u but it doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(1201,'You try to view movie %u but it doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/7616_02_mangos_command.sql b/sql/updates/2433_mangos_7616_02_world_command.sql index 42f55f03b6a..405415ac311 100644 --- a/sql/updates/7616_02_mangos_command.sql +++ b/sql/updates/2433_mangos_7616_02_world_command.sql @@ -1,8 +1,7 @@ -ALTER TABLE db_version CHANGE COLUMN required_7616_01_mangos_mangos_string required_7616_02_mangos_command bit; +/*ALTER TABLE db_version CHANGE COLUMN required_7616_01_mangos_mangos_string required_7616_02_mangos_command bit;*/ DELETE FROM `command` WHERE `name` IN ('debug playsound','debug play sound','debug play cinematic','debug play movie'); - INSERT INTO `command` VALUES ('debug play cinematic',1,'Syntax: .debug play cinematic #cinematicid\r\n\r\nPlay cinematic #cinematicid for you. You stay at place while your mind fly.\r\n'), ('debug play movie',1,'Syntax: .debug play movie #movieid\r\n\r\nPlay movie #movieid for you.'), -('debug play sound',1,'Syntax: .debug play sound #soundid\r\n\r\nPlay sound with #soundid.\r\nSound will be play only for you. Other players do not hear this.\r\nWarning: client may have more 5000 sounds...'); +('debug play sound',1,'Syntax: .debug play sound #soundid\r\n\r\nPlay sound with #soundid.\r\nSound will be play only for you. Other players do not hear this.\r\nWarning: client may have more 5000 sounds...');
\ No newline at end of file diff --git a/sql/updates/2450_world.sql b/sql/updates/2450_world.sql new file mode 100644 index 00000000000..407ce84cc24 --- /dev/null +++ b/sql/updates/2450_world.sql @@ -0,0 +1,7 @@ +UPDATE `gameobject_template` SET `ScriptName`='go_jump_a_tron' WHERE `entry`=183146;
+UPDATE `gameobject_template` SET `ScriptName`='go_ethereum_prison' WHERE `entry`=184421;
+UPDATE `gameobject_template` SET `scriptname`='go_sacred_fire_of_life' WHERE `entry`=175944;
+UPDATE `gameobject_template` SET `scriptname`='go_skull_pile' WHERE `entry`=185913;
+DELETE FROM `command` WHERE `name` IN ('reload spell_linked_spell');
+INSERT INTO `command` VALUES
+('reload spell_linked_spell','3','Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.');
\ No newline at end of file diff --git a/sql/updates/7616_01_mangos_mangos_string.sql b/sql/updates/7616_01_mangos_mangos_string.sql deleted file mode 100644 index cd6e315adf9..00000000000 --- a/sql/updates/7616_01_mangos_mangos_string.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7615_01_mangos_command required_7616_01_mangos_mangos_string bit; - -DELETE FROM mangos_string WHERE entry IN(1200,1201); -INSERT INTO mangos_string VALUES -(1200,'You try to view cinemitic %u but it doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1201,'You try to view movie %u but it doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index 62c6be957e8..b3ab01427ae 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -23,6 +23,10 @@ UPDATE `gameobject_template` SET `ScriptName`='go_mausoleum_trigger' WHERE `entr UPDATE `gameobject_template` SET `ScriptName`='go_mausoleum_door' WHERE `entry`=176594; UPDATE `gameobject_template` SET `ScriptName`='go_crystal_prison' WHERE `entry`=185126; UPDATE `gameobject_template` SET `ScriptName`='go_legion_obelisk' WHERE `entry` IN (185193,185195,185196,185197,185198); +UPDATE `gameobject_template` SET `ScriptName`='go_jump_a_tron' WHERE `entry`=183146; +UPDATE `gameobject_template` SET `ScriptName`='go_ethereum_prison' WHERE `entry`=184421; +UPDATE `gameobject_template` SET `scriptname`='go_sacred_fire_of_life' WHERE `entry`=175944; +UPDATE `gameobject_template` SET `scriptname`='go_skull_pile' WHERE `entry`=185913; /* GUARD */ UPDATE `creature_template` SET `ScriptName`='guard_azuremyst' WHERE `entry`=18038; |