aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-01-04 23:25:27 -0600
committermegamage <none@none>2009-01-04 23:25:27 -0600
commite5575eeaf458f5a07d250af33908c4d603fa259d (patch)
tree5b5562e8e71cace87e28bb55d60cd8f8eaae50bf /sql
parent190b0269507fce596d96821dd2d79d3c6c7c7e31 (diff)
*Mangos [7026] Current arena season id and state send and setting in mangosd.conf. By GriffonHeart.
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/7026_01_mangos_battleground_template.sql7
-rw-r--r--sql/updates/TBC-WLK_world.sql6
2 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/7026_01_mangos_battleground_template.sql b/sql/updates/7026_01_mangos_battleground_template.sql
new file mode 100644
index 00000000000..9da034c3ec5
--- /dev/null
+++ b/sql/updates/7026_01_mangos_battleground_template.sql
@@ -0,0 +1,7 @@
+ALTER TABLE db_version CHANGE COLUMN required_7024_01_mangos_spell_chain required_7026_01_mangos_battleground_template bit;
+
+DELETE FROM battleground_template WHERE id IN (9,10,11);
+INSERT INTO battleground_template VALUES
+(9,0,0,0,0,1367,0,1368,0),
+(10,5,5,10,80,1362,0,1363,0),
+(11,5,5,10,80,1364,0,1365,0);
diff --git a/sql/updates/TBC-WLK_world.sql b/sql/updates/TBC-WLK_world.sql
index 7106fecc508..a804e1c41be 100644
--- a/sql/updates/TBC-WLK_world.sql
+++ b/sql/updates/TBC-WLK_world.sql
@@ -1,3 +1,9 @@
+DELETE FROM battleground_template WHERE id IN (9,10,11);
+INSERT INTO battleground_template VALUES
+(9,0,0,0,0,1367,0,1368,0),
+(10,5,5,10,80,1362,0,1363,0),
+(11,5,5,10,80,1364,0,1365,0);
+
TRUNCATE creature_equip_template;
alter table `creature_equip_template`
drop column `equipinfo1`,