diff options
| author | w12x <none@none> | 2008-10-17 16:36:07 -0500 |
|---|---|---|
| committer | w12x <none@none> | 2008-10-17 16:36:07 -0500 |
| commit | ab9eb277b4f001332ef2d0b623f72cfe176130d9 (patch) | |
| tree | c39e35d77fd89997dc1091910746fd84899fa7a4 /sql/updates | |
| parent | 62409ac2a44b4af071aad765fd60e8281593aad7 (diff) | |
[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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/54_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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 |