aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2013_03_15_01_world_keychain_db2.sql43
-rw-r--r--sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql43
-rw-r--r--src/server/game/Globals/ObjectMgr.cpp2
3 files changed, 44 insertions, 44 deletions
diff --git a/sql/updates/world/2013_03_15_01_world_keychain_db2.sql b/sql/updates/world/2013_03_15_01_world_keychain_db2.sql
deleted file mode 100644
index b5756fc62d1..00000000000
--- a/sql/updates/world/2013_03_15_01_world_keychain_db2.sql
+++ /dev/null
@@ -1,43 +0,0 @@
-DROP TABLE IF EXISTS `keychain_db2`;
-CREATE TABLE `keychain_db2` (
- `keyId` INT UNSIGNED NOT NULL DEFAULT '0',
- `k1` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k2` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k3` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k4` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k5` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k6` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k7` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k8` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k9` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k10` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k11` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k12` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k13` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k14` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k15` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k16` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k17` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k18` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k19` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k20` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k21` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k22` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k23` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k24` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k25` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k26` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k27` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k28` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k29` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k30` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k31` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `k32` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`keyId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `keychain_db2` VALUES
-(33, 53, 6, 164, 135, 117, 210, 209, 135, 247, 162, 85, 200, 76, 220, 107, 56, 80, 214, 44, 121, 29, 66, 81, 25, 41, 38, 208, 8, 235, 154, 58, 139),
-(35, 16, 209, 60, 47, 154, 100, 204, 97, 125, 161, 79, 126, 191, 163, 7, 45, 64, 188, 199, 88, 141, 46, 153, 90, 143, 40, 6, 80, 29, 133, 217, 135),
-(36, 3, 169, 217, 5, 156, 76, 33, 82, 75, 181, 233, 203, 230, 52, 67, 197, 57, 99, 27, 108, 100, 197, 93, 156, 174, 2, 248, 216, 244, 115, 164, 210),
-(37, 119, 7, 189, 206, 199, 253, 234, 73, 232, 17, 162, 79, 0, 35, 222, 224, 7, 98, 132, 147, 229, 36, 19, 253, 79, 59, 198, 59, 48, 121, 97, 215);
diff --git a/sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql b/sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql
new file mode 100644
index 00000000000..fb8364d47d0
--- /dev/null
+++ b/sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql
@@ -0,0 +1,43 @@
+DROP TABLE IF EXISTS `keychain_db2`;
+CREATE TABLE `keychain_db2` (
+ `keyId` INT UNSIGNED NOT NULL DEFAULT '0',
+ `k1` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k2` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k3` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k4` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k5` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k6` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k7` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k8` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k9` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k10` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k11` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k12` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k13` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k14` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k15` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k16` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k17` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k18` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k19` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k20` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k21` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k22` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k23` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k24` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k25` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k26` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k27` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k28` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k29` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k30` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k31` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ `k32` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+ PRIMARY KEY (`keyId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `keychain_db2` VALUES
+(33, 53, 6, 164, 135, 117, 210, 209, 135, 247, 162, 85, 200, 76, 220, 107, 56, 80, 214, 44, 121, 29, 66, 81, 25, 41, 38, 208, 8, 235, 154, 58, 139),
+(35, 16, 209, 60, 47, 154, 100, 204, 97, 125, 161, 79, 126, 191, 163, 7, 45, 64, 188, 199, 88, 141, 46, 153, 90, 143, 40, 6, 80, 29, 133, 217, 135),
+(36, 3, 169, 217, 5, 156, 76, 33, 82, 75, 181, 233, 203, 230, 52, 67, 197, 57, 99, 27, 108, 100, 197, 93, 156, 174, 2, 248, 216, 244, 115, 164, 210),
+(37, 119, 7, 189, 206, 199, 253, 234, 73, 232, 17, 162, 79, 0, 35, 222, 224, 7, 98, 132, 147, 229, 36, 19, 253, 79, 59, 198, 59, 48, 121, 97, 215);
diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp
index dfb84c23113..ec44ff8977d 100644
--- a/src/server/game/Globals/ObjectMgr.cpp
+++ b/src/server/game/Globals/ObjectMgr.cpp
@@ -8769,7 +8769,7 @@ void ObjectMgr::LoadMissingKeyChains()
do
{
Field* fields = result->Fetch();
- uint32 id = fields[0].GetUInt32();;
+ uint32 id = fields[0].GetUInt32();
KeyChainEntry* kce = sKeyChainStore.CreateEntry(id, true);
kce->Id = id;