root/trunk/sql/updates/10_instantiated_battlegrounds.sql @ 28

Revision 28, 2.5 kB (checked in by yumileroy, 17 years ago)

[svn] * Updated to 6743 and 685

Moved language id used by Arena to a higher place to solve conflicts
Added the empty script folders

Original author: Neo2003
Date: 2008-10-09 08:42:22-05:00

Line 
1DELETE FROM `instance_template` WHERE `map` IN ('489', '30', '529', '566', '559', '562', '572');
2INSERT INTO `instance_template` (`map`, `parent`, `levelMin`, `levelMax`, `maxPlayers`, `reset_delay`) VALUES 
3('489', '0', '10', '0', '50', '0'),
4('30', '0', '10', '0', '50', '0'),
5('529', '0', '10', '0', '50', '0'),
6('566', '0', '10', '0', '50', '0'),
7('559', '0', '10', '0', '50', '0'),
8('562', '0', '10', '0', '50', '0'),
9('572', '0', '10', '0', '50', '0');
10
11DELETE FROM `command` WHERE `name` = "flusharenapoints";
12DELETE FROM `command` WHERE `name` = "debug arena";
13INSERT INTO `command` (`name`, `security`, `help`) VALUES
14('flusharenapoints',3,'Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'),
15('debug arena',3,'Syntax: .debug arena\r\n\r\n Toggles arena 1v1 or normal mode.');
16
17
18DELETE FROM mangos_string WHERE entry IN (711,712);
19DELETE FROM mangos_string WHERE entry BETWEEN 730 AND 745;
20INSERT INTO mangos_string (entry, content_default) VALUES
21    (711,'Your group is too large for this battleground. Please regroup to join.'),
22    (712,'Your group is too large for this arena. Please regroup to join.'),
23    (730,'Your group has members not in your arena team. Please regroup to join.'),
24    (731,'Your group does not have enough players to join this match.'),
25    (732,'The Gold Team wins!'),
26    (733,'The Green Team wins!'),
27    (734, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.'),
28    (735, 'Your group has an offline member. Please remove him before joining.'),
29    (736, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.'),
30    (737, 'Your group has players from different battleground brakets. You can\'t join as group.'),
31    (738, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.'),
32    (739, 'Someone in your party is Deserter. You can\'t join as group.'),
33    (740, 'Someone in your party is already in three battleground queues. You cannot join as group.'),
34    (741, 'You cannot teleport to a battleground or arena map.'),
35    (742, 'You cannot summon players to a battleground or arena map.'),
36    (743, 'You must be in GM mode to teleport to a player in a battleground.'),
37    (744, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'),
38    (745, 'Arena testing turned %s');
39   
Note: See TracBrowser for help on using the browser.