aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorNeo2003 <none@none>2008-10-11 14:16:25 -0500
committerNeo2003 <none@none>2008-10-11 14:16:25 -0500
commit95b91afbab455d917a2800d8936e1f29e4d9604d (patch)
tree85e9e642d493123cd8cbafbf8d88ce9cafa32ddf /sql/updates
parentf84ae3af9e9ab10bf43243187e5b458698e9a39a (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.sql78
-rw-r--r--sql/updates/11_characters.sql8
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