root/trunk/sql/updates/10_world.sql @ 44

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

[svn] * Merge Temp dev SVN with Assembla.
* Changes include:

  • Implementation of w12x's Outdoor PvP and Game Event Systems.
  • Temporary removal of IRC Chat Bot (until infinite loop when disabled is fixed).
  • All mangos -> trinity (to convert your mangos_string table, please run mangos_string_to_trinity_string.sql).
  • Improved Config cleanup.
  • And many more changes.

Original author: Seline
Date: 2008-10-14 11:57:03-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 trinity_string WHERE entry IN (711,712);
19DELETE FROM trinity_string WHERE entry BETWEEN 730 AND 745;
20INSERT INTO trinity_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.