From b2b9ed4a32225a2e51db1f5f417e8392002e232c Mon Sep 17 00:00:00 2001
From: Spp <spp@jorge.gr>
Date: Mon, 2 Aug 2010 13:22:05 +0200
Subject: Add selection weights to BG and Arenas. Will determine the selected
 BG/Arena chosen using random BG/Arenas from the enabled list.

Closes issue 2843

--HG--
branch : trunk
---
 sql/base/world_database.sql | 29 +++++++++++++++--------------
 1 file changed, 15 insertions(+), 14 deletions(-)

(limited to 'sql/base/world_database.sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index f0c2607a3d2..106851769ee 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -241,6 +241,7 @@ CREATE TABLE `battleground_template` (
   `AllianceStartO` float NOT NULL,
   `HordeStartLoc` mediumint(8) unsigned NOT NULL,
   `HordeStartO` float NOT NULL,
+  `Weight` tinyint(2) unsigned NOT NULL DEFAULT 1,
   `Comment` char(32) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -252,20 +253,20 @@ CREATE TABLE `battleground_template` (
 
 LOCK TABLES `battleground_template` WRITE;
 /*!40000 ALTER TABLE `battleground_template` DISABLE KEYS */;
-INSERT INTO `battleground_template` (`id`,`MinPlayersPerTeam`,`MaxPlayersPerTeam`,`MinLvl`,`MaxLvl`,`AllianceStartLoc`,`AllianceStartO`,`HordeStartLoc`,`HordeStartO`) VALUES
-(1,20,40,51,80,611,2.72532,610,2.27452),
-(2,5,10,10,80,769,3.14159,770,3.14159),
-(3,8,15,20,80,890,3.40156,889,0.263892),
-(4,0,2,10,80,929,0,936,3.14159),
-(5,0,2,10,80,939,0,940,3.14159),
-(6,0,2,10,80,0,0,0,0),
-(7,8,15,61,80,1103,3.40156,1104,0.263892),
-(8,0,2,10,80,1258,0,1259,3.14159),
-(9,7,15,71,80,1367,0,1368,0),
-(10,5,5,10,80,1362,0,1363,0),
-(11,5,5,10,80,1364,0,1365,0),
-(30,20,40,71,80,1485,0,1486,0),
-(32,10,10,0,80,0,0,0,0);
+INSERT INTO `battleground_template` (`id`,`MinPlayersPerTeam`,`MaxPlayersPerTeam`,`MinLvl`,`MaxLvl`,`AllianceStartLoc`,`AllianceStartO`,`HordeStartLoc`,`HordeStartO`, `Weight`) VALUES
+(1,20,40,51,80,611,2.72532,610,2.27452,1),
+(2,5,10,10,80,769,3.14159,770,3.14159,1),
+(3,8,15,20,80,890,3.40156,889,0.263892,1),
+(4,0,2,10,80,929,0,936,3.14159,1),
+(5,0,2,10,80,939,0,940,3.14159,1),
+(6,0,2,10,80,0,0,0,0,1),
+(7,8,15,61,80,1103,3.40156,1104,0.263892,1),
+(8,0,2,10,80,1258,0,1259,3.14159,1),
+(9,7,15,71,80,1367,0,1368,0,1),
+(10,5,5,10,80,1362,0,1363,0,1),
+(11,5,5,10,80,1364,0,1365,0,1),
+(30,20,40,71,80,1485,0,1486,0,1),
+(32,10,10,0,80,0,0,0,0,1);
 /*!40000 ALTER TABLE `battleground_template` ENABLE KEYS */;
 UNLOCK TABLES;
 
-- 
cgit v1.2.3

