aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2013-09-02 16:18:55 +0100
committerNay <dnpd.dd@gmail.com>2013-09-02 16:18:55 +0100
commit9b92bc9409326fe8567fd1d1970c7742bc8350b4 (patch)
treeadee538657acf1e06f397cabbfa9bf0b9b4147fc /sql
parent579f969d6a54b4fa2ea61eb718ad156d0e6dfce1 (diff)
Core: Fix compile with PCH enabled and warnings
Few corrections to worldserver.conf
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_09_01_07_world_trinity_strings.sql45
1 files changed, 22 insertions, 23 deletions
diff --git a/sql/updates/world/2013_09_01_07_world_trinity_strings.sql b/sql/updates/world/2013_09_01_07_world_trinity_strings.sql
index 7dd8bb89ee6..6c69a0a44ff 100644
--- a/sql/updates/world/2013_09_01_07_world_trinity_strings.sql
+++ b/sql/updates/world/2013_09_01_07_world_trinity_strings.sql
@@ -1,26 +1,25 @@
-DELETE FROM `trinity_string` WHERE entry IN (749, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881);
-INSERT INTO `trinity_string` (entry, content_default, content_loc1, content_loc2, content_loc3, content_loc4, content_loc5, content_loc6, content_loc7, content_loc8) VALUES
-(749,'│ OS: %s - Latency: %u ms', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(872, 'Entered email is not equal to registration email, check input', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(873, 'The new emails do not match', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(874, 'The email was changed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(875, 'Your email can''t be longer than 64 characters, email not changed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(876, 'Email not changed (unknown error)!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(877, 'Email change unnecessary, new email is equal to old email', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(878, 'Your email is: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(879, '│ Registration Email: %s - Email: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(880, 'Security Level: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(881, 'You require an email to change your password.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+DELETE FROM `trinity_string` WHERE `entry` IN (749, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881);
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(749,'│ OS: %s - Latency: %u ms'),
+(872, 'Entered email is not equal to registration email, check input'),
+(873, 'The new emails do not match'),
+(874, 'The email was changed'),
+(875, 'Your email can''t be longer than 64 characters, email not changed!'),
+(876, 'Email not changed (unknown error)!'),
+(877, 'Email change unnecessary, new email is equal to old email'),
+(878, 'Your email is: %s'),
+(879, '│ Registration Email: %s - Email: %s'),
+(880, 'Security Level: %s'),
+(881, 'You require an email to change your password.');
-UPDATE `command` SET help = 'Syntax: .account password $old_password $new_password $new_password [$email]\r\n\r\nChange your account password. You may need to check the actual security mode to see if email input is necessary.' WHERE name = 'account password';
+UPDATE `command` SET `help` = 'Syntax: .account password $old_password $new_password $new_password [$email]\r\n\r\nChange your account password. You may need to check the actual security mode to see if email input is necessary.' WHERE name = 'account password';
+UPDATE `command` SET `help` = 'Syntax: .account\r\n\r\nDisplay the access level of your account and the email adress if you possess the necessary permissions.' WHERE name = 'account';
-UPDATE `command` SET help = 'Syntax: .account\r\n\r\nDisplay the access level of your account and the email adress if you possess the necessary permissions.' WHERE name = 'account';
+DELETE FROM `command` WHERE `name` = 'account email';
+DELETE FROM `command` WHERE `name` = 'account set sec email';
+DELETE FROM `command` WHERE `name` = 'account set sec regmail';
-DELETE FROM `command` WHERE name = 'account email';
-INSERT INTO `command` (name, security, help) VALUES ('account email', 0, 'Syntax: .account email $oldemail $currentpassword $newemail $newemailconfirmation\r\n\r\n Change your account email. You may need to check the actual security mode to see if email input is necessary for password change');
-
-DELETE FROM `command` WHERE name = 'account set sec email';
-INSERT INTO `command` (name, security, help) VALUES ('account set sec email', 3, 'Syntax: .account set sec email $accountname $email $emailconfirmation\r\n\r\nSet the email for entered player account.');
-
-DELETE FROM `command` WHERE name = 'account set sec regmail';
-INSERT INTO `command` (name, security, help) VALUES ('account set sec regmail', 4, 'Syntax: .account set sec regmail $account $regmail $regmailconfirmation\r\n\r\nSets the regmail for entered player account.');
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('account email', 263, 'Syntax: .account email $oldemail $currentpassword $newemail $newemailconfirmation\r\n\r\n Change your account email. You may need to check the actual security mode to see if email input is necessary for password change'),
+('account set sec email', 265, 'Syntax: .account set sec email $accountname $email $emailconfirmation\r\n\r\nSet the email for entered player account.'),
+('account set sec regmail', 266, 'Syntax: .account set sec regmail $account $regmail $regmailconfirmation\r\n\r\nSets the regmail for entered player account.');