root/trunk/sql/updates/54_world.sql @ 50

Revision 50, 202 bytes (checked in by yumileroy, 17 years ago)

[svn] Enabled game events to change the honor and reputation gaining speed in battlegrounds. This is done by a new table in the world database, game_event_battleground_holiday. Structure is the following:
event - id of the game event
bgflag - bitmask, used to set which battleground(s) give extra honor/reputation when the event is active. To add extra honor on a battleground, use 2 bgTypeId as mask. Multiple battlegrounds can be set by logical 'or' ('|') operation.
You will need database data for the table, please check trinitydatabase.org.

Original author: w12x
Date: 2008-10-17 16:36:07-05:00
Line 
1CREATE TABLE `game_event_battleground_holiday` (
2 `event` int(10) unsigned NOT NULL,
3 `bgflag` int(10) unsigned NOT NULL default '0',
4 PRIMARY KEY  (`event`)
5) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Note: See TracBrowser for help on using the browser.