Merge pull request #13361 from Sovak/602

Core/NetworkIO: *Fixed basic auth packets

3 files changed, 51 insertions, 0 deletions

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);