Changeset 44 for trunk/sql/updates

Show
Ignore:
Timestamp:
11/19/08 13:27:40 (17 years ago)
Author:
yumileroy
Message:

[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

Location:
trunk/sql/updates
Files:
3 added
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/sql/updates/10_world.sql

    r37 r44  
    1616 
    1717 
    18 DELETE FROM mangos_string WHERE entry IN (711,712); 
    19 DELETE FROM mangos_string WHERE entry BETWEEN 730 AND 745; 
    20 INSERT INTO mangos_string (entry, content_default) VALUES 
     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 
    2121    (711,'Your group is too large for this battleground. Please regroup to join.'), 
    2222    (712,'Your group is too large for this arena. Please regroup to join.'), 

  • trunk/sql/updates/40_world.sql

    r39 r44  
    7070 
    7171-- Add ircpm command. 
     72delete from `command` WHERE `name`='ircpm'; 
    7273insert into `command` (`name`, `security`, `help`) values ('ircpm', 0, 'Syntax: .ircpm <user> <text>\n\nSends a PM with <text> to <user> on IRC.'); 
    7374 
    7475-- Add auto announce string. 
    75 insert into `mangos_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values('746','|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
     76DELETE FROM `trinity_string` WHERE `entry`=746; 
     77insert into `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values('746','|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);