diff options
| -rw-r--r-- | sql/updates/world/2012_01_31_02_world_hotfix_data.sql | 5 | ||||
| -rwxr-xr-x | src/server/game/Globals/ObjectMgr.cpp | 4 | ||||
| -rwxr-xr-x | src/server/game/Globals/ObjectMgr.h | 2 | ||||
| -rw-r--r-- | src/server/game/Handlers/CharacterHandler.cpp | 2 |
4 files changed, 9 insertions, 4 deletions
diff --git a/sql/updates/world/2012_01_31_02_world_hotfix_data.sql b/sql/updates/world/2012_01_31_02_world_hotfix_data.sql new file mode 100644 index 00000000000..ce45feed943 --- /dev/null +++ b/sql/updates/world/2012_01_31_02_world_hotfix_data.sql @@ -0,0 +1,5 @@ +ALTER TABLE hotfix_data ADD `hotfixDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `unk`; +UPDATE `hotfix_data` SET `hotfixDate`=FROM_UNIXTIME(`unk`); +ALTER TABLE `hotfix_data` DROP PRIMARY KEY; +ALTER TABLE `hotfix_data` ADD PRIMARY KEY (`entry`,`type`,`hotfixDate`); +ALTER TABLE `hotfix_data` DROP `unk`; diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index 9c0c5553b91..6bd34ae19ba 100755 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -9038,7 +9038,7 @@ void ObjectMgr::LoadHotfixData() { uint32 oldMSTime = getMSTime(); - QueryResult result = WorldDatabase.Query("SELECT entry, type, unk FROM hotfix_data"); + QueryResult result = WorldDatabase.Query("SELECT entry, type, UNIX_TIMESTAMP(hotixDate) FROM hotfix_data"); if (!result) { @@ -9058,7 +9058,7 @@ void ObjectMgr::LoadHotfixData() HotfixInfo info; info.Entry = fields[0].GetUInt32(); info.Type = fields[1].GetUInt32(); - info.Unk = fields[2].GetUInt32(); + info.Timestamp = fields[2].GetUInt32(); _hotfixData.push_back(info); ++count; diff --git a/src/server/game/Globals/ObjectMgr.h b/src/server/game/Globals/ObjectMgr.h index 22bb5e09e50..023b28d0860 100755 --- a/src/server/game/Globals/ObjectMgr.h +++ b/src/server/game/Globals/ObjectMgr.h @@ -589,7 +589,7 @@ typedef UNORDERED_MAP<uint32, DungeonEncounterList> DungeonEncounterMap; struct HotfixInfo { uint32 Type; - uint32 Unk; + uint32 Timestamp; uint32 Entry; }; diff --git a/src/server/game/Handlers/CharacterHandler.cpp b/src/server/game/Handlers/CharacterHandler.cpp index 3dccfe9b245..44556f0ec20 100644 --- a/src/server/game/Handlers/CharacterHandler.cpp +++ b/src/server/game/Handlers/CharacterHandler.cpp @@ -977,7 +977,7 @@ void WorldSession::HandlePlayerLogin(LoginQueryHolder* holder) for (uint32 i = 0; i < hotfix.size(); ++i) { data << uint32(hotfix[i].Type); - data << uint32(hotfix[i].Unk); + data << uint32(hotfix[i].Timestamp); data << uint32(hotfix[i].Entry); } SendPacket(&data); |