aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorw12x <none@none>2008-10-17 16:36:07 -0500
committerw12x <none@none>2008-10-17 16:36:07 -0500
commitab9eb277b4f001332ef2d0b623f72cfe176130d9 (patch)
treec39e35d77fd89997dc1091910746fd84899fa7a4 /sql
parent62409ac2a44b4af071aad765fd60e8281593aad7 (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')
-rw-r--r--sql/updates/54_world.sql5
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