From ab9eb277b4f001332ef2d0b623f72cfe176130d9 Mon Sep 17 00:00:00 2001 From: w12x Date: Fri, 17 Oct 2008 16:36:07 -0500 Subject: [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. --HG-- branch : trunk --- sql/updates/54_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/54_world.sql (limited to 'sql') diff --git a/sql/updates/54_world.sql b/sql/updates/54_world.sql new file mode 100644 index 00000000000..f63e1f8134f --- /dev/null +++ b/sql/updates/54_world.sql @@ -0,0 +1,5 @@ +CREATE TABLE `game_event_battleground_holiday` ( + `event` int(10) unsigned NOT NULL, + `bgflag` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`event`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file -- cgit v1.2.3