Core/Misc: Change all unix time columns in character database to bigint (signed)

1 files changed, 8 insertions, 8 deletions

diff --git a/src/server/game/Achievements/AchievementMgr.cpp b/src/server/game/Achievements/AchievementMgr.cpp
index 7e60de8b1cc..21d52ecd0fa 100644
--- a/src/server/game/Achievements/AchievementMgr.cpp
+++ b/src/server/game/Achievements/AchievementMgr.cpp
@@ -249,7 +249,7 @@ void PlayerAchievementMgr::LoadFromDB(PreparedQueryResult achievementResult, Pre
                 continue;
 
             CompletedAchievementData& ca = _completedAchievements[achievementid];
-            ca.Date = time_t(fields[1].GetUInt32());
+            ca.Date = fields[1].GetInt64();
             ca.Changed = false;
 
             _achievementPoints += achievement->Points;
@@ -271,7 +271,7 @@ void PlayerAchievementMgr::LoadFromDB(PreparedQueryResult achievementResult, Pre
             Field* fields = criteriaResult->Fetch();
             uint32 id = fields[0].GetUInt32();
             uint64 counter = fields[1].GetUInt64();
-            time_t date = time_t(fields[2].GetUInt32());
+            time_t date = fields[2].GetInt64();
 
             Criteria const* criteria = sCriteriaMgr->GetCriteria(id);
             if (!criteria)
@@ -315,7 +315,7 @@ void PlayerAchievementMgr::SaveToDB(CharacterDatabaseTransaction& trans)
             stmt = CharacterDatabase.GetPreparedStatement(CHAR_INS_CHAR_ACHIEVEMENT);
             stmt->setUInt64(0, _owner->GetGUID().GetCounter());
             stmt->setUInt32(1, iter->first);
-            stmt->setUInt32(2, uint32(iter->second.Date));
+            stmt->setInt64(2, iter->second.Date);
             trans->Append(stmt);
 
             iter->second.Changed = false;
@@ -340,7 +340,7 @@ void PlayerAchievementMgr::SaveToDB(CharacterDatabaseTransaction& trans)
                 stmt->setUInt64(0, _owner->GetGUID().GetCounter());
                 stmt->setUInt32(1, iter->first);
                 stmt->setUInt64(2, iter->second.Counter);
-                stmt->setUInt32(3, uint32(iter->second.Date));
+                stmt->setInt64(3, iter->second.Date);
                 trans->Append(stmt);
             }
 
@@ -738,7 +738,7 @@ void GuildAchievementMgr::LoadFromDB(PreparedQueryResult achievementResult, Prep
                 continue;
 
             CompletedAchievementData& ca = _completedAchievements[achievementid];
-            ca.Date = time_t(fields[1].GetUInt32());
+            ca.Date = fields[1].GetInt64();
             Tokenizer guids(fields[2].GetString(), ' ');
             for (uint32 i = 0; i < guids.size(); ++i)
                 ca.CompletingPlayers.insert(ObjectGuid::Create<HighGuid::Player>(uint64(strtoull(guids[i], nullptr, 10))));
@@ -757,7 +757,7 @@ void GuildAchievementMgr::LoadFromDB(PreparedQueryResult achievementResult, Prep
             Field* fields = criteriaResult->Fetch();
             uint32 id = fields[0].GetUInt32();
             uint64 counter = fields[1].GetUInt64();
-            time_t date = time_t(fields[2].GetUInt32());
+            time_t date = fields[2].GetInt64();
             ObjectGuid::LowType guid = fields[3].GetUInt64();
 
             Criteria const* criteria = sCriteriaMgr->GetCriteria(id);
@@ -801,7 +801,7 @@ void GuildAchievementMgr::SaveToDB(CharacterDatabaseTransaction& trans)
         stmt = CharacterDatabase.GetPreparedStatement(CHAR_INS_GUILD_ACHIEVEMENT);
         stmt->setUInt64(0, _owner->GetId());
         stmt->setUInt32(1, itr->first);
-        stmt->setUInt32(2, uint32(itr->second.Date));
+        stmt->setInt64(2, itr->second.Date);
         for (GuidSet::const_iterator gItr = itr->second.CompletingPlayers.begin(); gItr != itr->second.CompletingPlayers.end(); ++gItr)
             guidstr << gItr->GetCounter() << ',';
 
@@ -825,7 +825,7 @@ void GuildAchievementMgr::SaveToDB(CharacterDatabaseTransaction& trans)
         stmt->setUInt64(0, _owner->GetId());
         stmt->setUInt32(1, itr->first);
         stmt->setUInt64(2, itr->second.Counter);
-        stmt->setUInt32(3, uint32(itr->second.Date));
+        stmt->setInt64(3, itr->second.Date);
         stmt->setUInt64(4, itr->second.PlayerGUID.GetCounter());
         trans->Append(stmt);
     }