aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-06-08 15:34:24 +0200
committerShauren <shauren.trinity@gmail.com>2014-06-08 15:34:24 +0200
commit9f69eda67f7fad50553f8d569851a5005437e677 (patch)
treeb918ef48a31a1970aad165808be344cf4744ef26 /sql
parent05c0524bf3d97ba29496fa13e93acd3b8d7d37a4 (diff)
Core/Battle.net: Additional checks
* Force grunt login for versions < 15595 * Force bn login if supported and game account is linked to bn account
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql6
-rw-r--r--sql/updates/auth/2014_06_08_01_auth_account_434.sql3
2 files changed, 3 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 6dca9aa1e14..3ccbadbbda0 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -216,18 +216,12 @@ LOCK TABLES `battlenet_components` WRITE;
/*!40000 ALTER TABLE `battlenet_components` DISABLE KEYS */;
INSERT INTO `battlenet_components` VALUES
('Bnet','Cmp1',3),
-('Bnet','Win',21719),
('Bnet','Win',26487),
('Bnet','Wn64',26487),
-('Tool','Win',1569),
('Tool','Win',2736),
-('WoW','base',12340),
('WoW','base',15595),
-('WoW','enGB',12340),
('WoW','enGB',15595),
-('WoW','enUS',12340),
('WoW','enUS',15595),
-('WoW','Win',12340),
('WoW','Win',15595),
('WoW','Wn64',15595);
/*!40000 ALTER TABLE `battlenet_components` ENABLE KEYS */;
diff --git a/sql/updates/auth/2014_06_08_01_auth_account_434.sql b/sql/updates/auth/2014_06_08_01_auth_account_434.sql
new file mode 100644
index 00000000000..dc05a98d17b
--- /dev/null
+++ b/sql/updates/auth/2014_06_08_01_auth_account_434.sql
@@ -0,0 +1,3 @@
+DELETE FROM `battlenet_components` WHERE `Program`='WoW' AND `Build`=12340;
+DELETE FROM `battlenet_components` WHERE `Program`='Tool' AND `Build`=1569;
+DELETE FROM `battlenet_components` WHERE `Program`='Bnet' AND `Build`=21719;