diff options
| author | Neo2003 <none@none> | 2008-10-11 14:16:25 -0500 |
|---|---|---|
| committer | Neo2003 <none@none> | 2008-10-11 14:16:25 -0500 |
| commit | 95b91afbab455d917a2800d8936e1f29e4d9604d (patch) | |
| tree | 85e9e642d493123cd8cbafbf8d88ce9cafa32ddf /sql/updates | |
| parent | f84ae3af9e9ab10bf43243187e5b458698e9a39a (diff) | |
[svn] * svn:eol-style native set on all files that need it
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/10_world.sql | 78 | ||||
| -rw-r--r-- | sql/updates/11_characters.sql | 8 |
2 files changed, 43 insertions, 43 deletions
diff --git a/sql/updates/10_world.sql b/sql/updates/10_world.sql index c3234c3099e..bfe967ad293 100644 --- a/sql/updates/10_world.sql +++ b/sql/updates/10_world.sql @@ -1,39 +1,39 @@ -DELETE FROM `instance_template` WHERE `map` IN ('489', '30', '529', '566', '559', '562', '572');
-INSERT INTO `instance_template` (`map`, `parent`, `levelMin`, `levelMax`, `maxPlayers`, `reset_delay`) VALUES
-('489', '0', '10', '0', '50', '0'),
-('30', '0', '10', '0', '50', '0'),
-('529', '0', '10', '0', '50', '0'),
-('566', '0', '10', '0', '50', '0'),
-('559', '0', '10', '0', '50', '0'),
-('562', '0', '10', '0', '50', '0'),
-('572', '0', '10', '0', '50', '0');
-
-DELETE FROM `command` WHERE `name` = "flusharenapoints";
-DELETE FROM `command` WHERE `name` = "debug arena";
-INSERT INTO `command` (`name`, `security`, `help`) VALUES
-('flusharenapoints',3,'Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'),
-('debug arena',3,'Syntax: .debug arena\r\n\r\n Toggles arena 1v1 or normal mode.');
-
-
-DELETE FROM mangos_string WHERE entry IN (711,712);
-DELETE FROM mangos_string WHERE entry BETWEEN 730 AND 745;
-INSERT INTO mangos_string (entry, content_default) VALUES
- (711,'Your group is too large for this battleground. Please regroup to join.'),
- (712,'Your group is too large for this arena. Please regroup to join.'),
- (730,'Your group has members not in your arena team. Please regroup to join.'),
- (731,'Your group does not have enough players to join this match.'),
- (732,'The Gold Team wins!'),
- (733,'The Green Team wins!'),
- (734, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.'),
- (735, 'Your group has an offline member. Please remove him before joining.'),
- (736, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.'),
- (737, 'Your group has players from different battleground brakets. You can\'t join as group.'),
- (738, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.'),
- (739, 'Someone in your party is Deserter. You can\'t join as group.'),
- (740, 'Someone in your party is already in three battleground queues. You cannot join as group.'),
- (741, 'You cannot teleport to a battleground or arena map.'),
- (742, 'You cannot summon players to a battleground or arena map.'),
- (743, 'You must be in GM mode to teleport to a player in a battleground.'),
- (744, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'),
- (745, 'Arena testing turned %s');
-
+DELETE FROM `instance_template` WHERE `map` IN ('489', '30', '529', '566', '559', '562', '572'); +INSERT INTO `instance_template` (`map`, `parent`, `levelMin`, `levelMax`, `maxPlayers`, `reset_delay`) VALUES +('489', '0', '10', '0', '50', '0'), +('30', '0', '10', '0', '50', '0'), +('529', '0', '10', '0', '50', '0'), +('566', '0', '10', '0', '50', '0'), +('559', '0', '10', '0', '50', '0'), +('562', '0', '10', '0', '50', '0'), +('572', '0', '10', '0', '50', '0'); + +DELETE FROM `command` WHERE `name` = "flusharenapoints"; +DELETE FROM `command` WHERE `name` = "debug arena"; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('flusharenapoints',3,'Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'), +('debug arena',3,'Syntax: .debug arena\r\n\r\n Toggles arena 1v1 or normal mode.'); + + +DELETE FROM mangos_string WHERE entry IN (711,712); +DELETE FROM mangos_string WHERE entry BETWEEN 730 AND 745; +INSERT INTO mangos_string (entry, content_default) VALUES + (711,'Your group is too large for this battleground. Please regroup to join.'), + (712,'Your group is too large for this arena. Please regroup to join.'), + (730,'Your group has members not in your arena team. Please regroup to join.'), + (731,'Your group does not have enough players to join this match.'), + (732,'The Gold Team wins!'), + (733,'The Green Team wins!'), + (734, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.'), + (735, 'Your group has an offline member. Please remove him before joining.'), + (736, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.'), + (737, 'Your group has players from different battleground brakets. You can\'t join as group.'), + (738, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.'), + (739, 'Someone in your party is Deserter. You can\'t join as group.'), + (740, 'Someone in your party is already in three battleground queues. You cannot join as group.'), + (741, 'You cannot teleport to a battleground or arena map.'), + (742, 'You cannot summon players to a battleground or arena map.'), + (743, 'You must be in GM mode to teleport to a player in a battleground.'), + (744, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'), + (745, 'Arena testing turned %s'); + diff --git a/sql/updates/11_characters.sql b/sql/updates/11_characters.sql index 348eba197a5..a9a002270fb 100644 --- a/sql/updates/11_characters.sql +++ b/sql/updates/11_characters.sql @@ -1,5 +1,5 @@ -ALTER TABLE `arena_team_member` ADD COLUMN `points_to_add` int(10) UNSIGNED NOT NULL DEFAULT '0';
-DROP TABLE IF EXISTS `saved_variables`;
-CREATE TABLE `saved_variables` (
- `NextArenaPointDistributionTime` timestamp NOT NULL
+ALTER TABLE `arena_team_member` ADD COLUMN `points_to_add` int(10) UNSIGNED NOT NULL DEFAULT '0'; +DROP TABLE IF EXISTS `saved_variables`; +CREATE TABLE `saved_variables` ( + `NextArenaPointDistributionTime` timestamp NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
\ No newline at end of file |
