diff options
| -rw-r--r-- | sql/updates/2828_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/2885_world_spell_proc_event.sql | 3 | ||||
| -rw-r--r-- | sql/updates/2907_mangos_7705_01_world_command.sql (renamed from sql/updates/7705_01_mangos_command.sql) | 10 | ||||
| -rw-r--r-- | sql/updates/2907_mangos_7706_01_world_command.sql (renamed from sql/updates/7706_01_mangos_command.sql) | 5 | ||||
| -rw-r--r-- | sql/updates/2923_world_spell_proc_event.sql | 4 |
5 files changed, 9 insertions, 15 deletions
diff --git a/sql/updates/2828_world_spell_proc_event.sql b/sql/updates/2828_world_spell_proc_event.sql index 23c436533cd..cd168bf6a67 100644 --- a/sql/updates/2828_world_spell_proc_event.sql +++ b/sql/updates/2828_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (16544, 16086); INSERT INTO `spell_proc_event` VALUES (16544, 0x00, 11, 0x00000000, 0x00040000, 0x00000000, 0x00000000, 0x0000000, 0.000000, 0.000000, 0), -(16086, 0x00, 11, 0x00000000, 0x00040000, 0x00000000, 0x00000000, 0x0000000, 0.000000, 0.000000, 0); +(16086, 0x00, 11, 0x00000000, 0x00040000, 0x00000000, 0x00000000, 0x0000000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/2885_world_spell_proc_event.sql b/sql/updates/2885_world_spell_proc_event.sql index 5dc4f5535f1..0fad491b7cb 100644 --- a/sql/updates/2885_world_spell_proc_event.sql +++ b/sql/updates/2885_world_spell_proc_event.sql @@ -5,5 +5,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (34456); INSERT INTO `spell_proc_event` VALUES (19615, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000002, 0.000000, 0.000000, 0); -INSERT INTO trinity_string (entry, content_default)VALUES (6616 , "Pet spells will reset for all players at login. Strongly recommend re-login!"); - +INSERT INTO trinity_string (entry, content_default)VALUES (6616 , "Pet spells will reset for all players at login. Strongly recommend re-login!");
\ No newline at end of file diff --git a/sql/updates/7705_01_mangos_command.sql b/sql/updates/2907_mangos_7705_01_world_command.sql index 4e6b8ff31ea..b711be14457 100644 --- a/sql/updates/7705_01_mangos_command.sql +++ b/sql/updates/2907_mangos_7705_01_world_command.sql @@ -1,13 +1,11 @@ -ALTER TABLE db_version CHANGE COLUMN required_7662_02_mangos_spell_bonus_data required_7705_01_mangos_command bit; +/*ALTER TABLE db_version CHANGE COLUMN required_7662_02_mangos_spell_bonus_data required_7705_01_mangos_command bit;*/ -DELETE FROM `command` WHERE `name` IN ( - 'account lock','account password','chardelete','character customize','character delete', - 'character rename','customize','lockaccount','password','rename' -); +DELETE FROM `command` WHERE `name` IN +('account lock','account password','chardelete','character customize','character delete','character rename','customize','lockaccount','password','rename'); INSERT INTO `command` VALUES ('account lock',0,'Syntax: .account lock [on|off]\r\n\r\nAllow login from account only from current used IP or remove this requirement.'), ('account password',0,'Syntax: .account password $old_password $new_password $new_password\r\n\r\nChange your account password.'), ('character customize',2,'Syntax: .character customize [$name]\r\n\r\nMark selected in game or by $name in command character for customize at next login.'), ('character delete',4,'Syntax: .character delete $name\r\n\r\nDelete character $name.'), -('character rename',2,'Syntax: .character rename [$name]\r\n\r\nMark selected in game or by $name in command character for rename at next login.'); +('character rename',2,'Syntax: .character rename [$name]\r\n\r\nMark selected in game or by $name in command character for rename at next login.');
\ No newline at end of file diff --git a/sql/updates/7706_01_mangos_command.sql b/sql/updates/2907_mangos_7706_01_world_command.sql index a57ddcc566f..d9661276880 100644 --- a/sql/updates/7706_01_mangos_command.sql +++ b/sql/updates/2907_mangos_7706_01_world_command.sql @@ -1,6 +1,5 @@ -ALTER TABLE db_version CHANGE COLUMN required_7705_01_mangos_command required_7706_01_mangos_command bit; +/*ALTER TABLE db_version CHANGE COLUMN required_7705_01_mangos_command required_7706_01_mangos_command bit;*/ DELETE FROM `command` WHERE `name` IN ('plimit','server plimit'); - INSERT INTO `command` VALUES -('server plimit',3,'Syntax: .server plimit [#num|-1|-2|-3|reset|player|moderator|gamemaster|administrator]\r\n\r\nWithout arg show current player amount and security level limitations for login to server, with arg set player linit ($num > 0) or securiti limitation ($num < 0 or security leme name. With `reset` sets player limit to the one in the config file'); +('server plimit',3,'Syntax: .server plimit [#num|-1|-2|-3|reset|player|moderator|gamemaster|administrator]\r\n\r\nWithout arg show current player amount and security level limitations for login to server, with arg set player linit ($num > 0) or securiti limitation ($num < 0 or security leme name. With `reset` sets player limit to the one in the config file');
\ No newline at end of file diff --git a/sql/updates/2923_world_spell_proc_event.sql b/sql/updates/2923_world_spell_proc_event.sql index 4212d703e75..c49c8b643a5 100644 --- a/sql/updates/2923_world_spell_proc_event.sql +++ b/sql/updates/2923_world_spell_proc_event.sql @@ -1,6 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (47569, 47570); INSERT INTO `spell_proc_event` VALUES (47569, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 50.000000, 0), -(47570, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 100.000000, 0); - - +(47570, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 100.000000, 0);
\ No newline at end of file |