diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth/2015_09_05_00_auth.sql | 2 | ||||
| -rw-r--r-- | sql/updates/characters/2015_09_05_00_characters.sql | 1 |
3 files changed, 5 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 54ebdf24e15..27a9f4be522 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -275,7 +275,7 @@ CREATE TABLE `battlenet_components` ( LOCK TABLES `battlenet_components` WRITE; /*!40000 ALTER TABLE `battlenet_components` DISABLE KEYS */; -INSERT INTO `battlenet_components` VALUES ('Bnet','Mc64',37165),('Bnet','Win',37165),('Bnet','Wn64',37165),('WoW','base',20182),('WoW','deDE',0),('WoW','enCN',0),('WoW','enGB',0),('WoW','enTW',0),('WoW','enUS',0),('WoW','esES',0),('WoW','esMX',0),('WoW','frFR',0),('WoW','itIT',0),('WoW','koKR',0),('WoW','Mc64',20338),('WoW','ptBR',0),('WoW','ptPT',0),('WoW','ruRU',0),('WoW','Win',20338),('WoW','Wn64',20338),('WoW','zhCN',0),('WoW','zhTW',0); +INSERT INTO `battlenet_components` VALUES ('Bnet','Mc64',37165),('Bnet','Win',37165),('Bnet','Wn64',37165),('WoW','base',20444),('WoW','deDE',0),('WoW','enCN',0),('WoW','enGB',0),('WoW','enTW',0),('WoW','enUS',0),('WoW','esES',0),('WoW','esMX',0),('WoW','frFR',0),('WoW','itIT',0),('WoW','koKR',0),('WoW','Mc64',20444),('WoW','ptBR',0),('WoW','ptPT',0),('WoW','ruRU',0),('WoW','Win',20444),('WoW','Wn64',20444),('WoW','zhCN',0),('WoW','zhTW',0); /*!40000 ALTER TABLE `battlenet_components` ENABLE KEYS */; UNLOCK TABLES; @@ -605,7 +605,7 @@ CREATE TABLE `realmlist` ( LOCK TABLES `realmlist` WRITE; /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */; -INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,20182,2,1); +INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,20444,2,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/2015_09_05_00_auth.sql b/sql/updates/auth/2015_09_05_00_auth.sql new file mode 100644 index 00000000000..d6858d8a6d4 --- /dev/null +++ b/sql/updates/auth/2015_09_05_00_auth.sql @@ -0,0 +1,2 @@ +UPDATE `battlenet_components` SET `Build`=20444 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20444; +UPDATE `realmlist` SET `gamebuild`=20444 WHERE `gamebuild`=20182; diff --git a/sql/updates/characters/2015_09_05_00_characters.sql b/sql/updates/characters/2015_09_05_00_characters.sql new file mode 100644 index 00000000000..f6294e6234a --- /dev/null +++ b/sql/updates/characters/2015_09_05_00_characters.sql @@ -0,0 +1 @@ +UPDATE `characters` SET `knownTitles`=SUBSTRING_INDEX(CONCAT(`knownTitles`, ' 0 0 0 0 0 0 0 0 0 0 0 0'), ' ', 12); |