Merge pull request #13361 from Sovak/602

Core/NetworkIO: *Fixed basic auth packets

4 files changed, 52 insertions, 1 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 47ef5ec9c8b..c223456dab6 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -40,7 +40,7 @@ CREATE TABLE `account` (
   `lock_country` varchar(2) NOT NULL DEFAULT '00',
   `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
   `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '3',
+  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '5',
   `mutetime` bigint(20) NOT NULL DEFAULT '0',
   `mutereason` varchar(255) NOT NULL DEFAULT '',
   `muteby` varchar(50) NOT NULL DEFAULT '',
diff --git a/sql/updates/auth/2014_10_19_00_auth_6x.sql b/sql/updates/auth/2014_10_19_00_auth_6x.sql
new file mode 100644
index 00000000000..a0a28f91359
--- /dev/null
+++ b/sql/updates/auth/2014_10_19_00_auth_6x.sql
@@ -0,0 +1,2 @@
+ALTER TABLE account MODIFY COLUMN expansion TINYINT(3) UNSIGNED DEFAULT 5 NOT NULL;
+UPDATE account SET expansion = 5;
diff --git a/sql/updates/world/2014_10_19_01_world_6x.sql b/sql/updates/world/2014_10_19_01_world_6x.sql
new file mode 100644
index 00000000000..99e7b4ee0c1
--- /dev/null
+++ b/sql/updates/world/2014_10_19_01_world_6x.sql
@@ -0,0 +1,4 @@
+ALTER TABLE creature_classlevelstats ADD COLUMN basehp4 MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1 AFTER basehp3;
+ALTER TABLE creature_classlevelstats ADD COLUMN basehp5 MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1 AFTER basehp4;
+ALTER TABLE creature_classlevelstats ADD COLUMN damage_exp4 FLOAT NOT NULL DEFAULT 0 AFTER damage_exp3;
+ALTER TABLE creature_classlevelstats ADD COLUMN damage_exp5 FLOAT NOT NULL DEFAULT 0 AFTER damage_exp4;
diff --git a/sql/updates/world/2014_10_19_02_world_6x.sql b/sql/updates/world/2014_10_19_02_world_6x.sql
new file mode 100644
index 00000000000..f9285741671
--- /dev/null
+++ b/sql/updates/world/2014_10_19_02_world_6x.sql
@@ -0,0 +1,45 @@
+DROP TABLE IF EXISTS class_expansion_requirement;
+CREATE TABLE class_expansion_requirement
+(
+  `classID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`classID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO class_expansion_requirement (classID, expansion) VALUES
+(1,0),
+(2,0),
+(3,0),
+(4,0),
+(5,0),
+(6,2),
+(7,0),
+(8,0),
+(9,0),
+(10,4),
+(11,0);
+
+DROP TABLE IF EXISTS race_expansion_requirement;
+CREATE TABLE race_expansion_requirement
+(
+  `raceID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`raceID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO race_expansion_requirement (raceID, expansion) VALUES
+(1,0),
+(2,0),
+(3,0),
+(4,0),
+(5,0),
+(6,0),
+(7,0),
+(8,0),
+(9,1),
+(10,1),
+(11,1),
+(22,1),
+(24,1),
+(25,1),
+(26,1);