diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-04-05 23:47:05 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-04-05 23:47:05 +0200 |
| commit | d29dd1eeb5c52dc76bd741fe1ee0e875c416b8e7 (patch) | |
| tree | 19b4dda1de5bee6f3d45a3472f131380443365d4 /src/server/game/Support | |
| parent | c648ac58e0a0724a6eff0242afaf665443f675ef (diff) | |
Core/Misc: Change all unix time columns in character database to bigint (signed)
Diffstat (limited to 'src/server/game/Support')
| -rw-r--r-- | src/server/game/Support/SupportMgr.cpp | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/src/server/game/Support/SupportMgr.cpp b/src/server/game/Support/SupportMgr.cpp index 603983b8063..ffb69854952 100644 --- a/src/server/game/Support/SupportMgr.cpp +++ b/src/server/game/Support/SupportMgr.cpp @@ -103,7 +103,7 @@ void BugTicket::LoadFromDB(Field* fields) _id = fields[ idx].GetUInt32(); _playerGuid = ObjectGuid::Create<HighGuid::Player>(fields[++idx].GetUInt64()); _note = fields[++idx].GetString(); - _createTime = fields[++idx].GetUInt32(); + _createTime = fields[++idx].GetInt64(); _mapId = fields[++idx].GetUInt16(); _pos.m_positionX = fields[++idx].GetFloat(); _pos.m_positionY = fields[++idx].GetFloat(); @@ -134,6 +134,7 @@ void BugTicket::SaveToDB() const stmt->setUInt32(idx, _id); stmt->setUInt64(++idx, _playerGuid.GetCounter()); stmt->setString(++idx, _note); + stmt->setInt64(++idx, _createTime); stmt->setUInt16(++idx, _mapId); stmt->setFloat(++idx, _pos.GetPositionX()); stmt->setFloat(++idx, _pos.GetPositionY()); @@ -189,7 +190,7 @@ void ComplaintTicket::LoadFromDB(Field* fields) _id = fields[ idx].GetUInt32(); _playerGuid = ObjectGuid::Create<HighGuid::Player>(fields[++idx].GetUInt64()); _note = fields[++idx].GetString(); - _createTime = fields[++idx].GetUInt32(); + _createTime = fields[++idx].GetInt64(); _mapId = fields[++idx].GetUInt16(); _pos.m_positionX = fields[++idx].GetFloat(); _pos.m_positionY = fields[++idx].GetFloat(); @@ -220,7 +221,7 @@ void ComplaintTicket::LoadFromDB(Field* fields) void ComplaintTicket::LoadChatLineFromDB(Field* fields) { - _chatLog.Lines.emplace_back(fields[0].GetUInt32(), fields[1].GetString()); + _chatLog.Lines.emplace_back(fields[0].GetInt64(), fields[1].GetString()); } void ComplaintTicket::SaveToDB() const @@ -232,6 +233,7 @@ void ComplaintTicket::SaveToDB() const stmt->setUInt32(idx, _id); stmt->setUInt64(++idx, _playerGuid.GetCounter()); stmt->setString(++idx, _note); + stmt->setInt64(++idx, _createTime); stmt->setUInt16(++idx, _mapId); stmt->setFloat(++idx, _pos.GetPositionX()); stmt->setFloat(++idx, _pos.GetPositionY()); @@ -255,7 +257,7 @@ void ComplaintTicket::SaveToDB() const stmt = CharacterDatabase.GetPreparedStatement(CHAR_INS_GM_COMPLAINT_CHATLINE); stmt->setUInt32(idx, _id); stmt->setUInt32(++idx, lineIndex); - stmt->setUInt32(++idx, c.Timestamp); + stmt->setInt64(++idx, c.Timestamp); stmt->setString(++idx, c.Text); trans->Append(stmt); @@ -312,7 +314,7 @@ void SuggestionTicket::LoadFromDB(Field* fields) _id = fields[ idx].GetUInt32(); _playerGuid = ObjectGuid::Create<HighGuid::Player>(fields[++idx].GetUInt64()); _note = fields[++idx].GetString(); - _createTime = fields[++idx].GetUInt32(); + _createTime = fields[++idx].GetInt64(); _mapId = fields[++idx].GetUInt16(); _pos.m_positionX = fields[++idx].GetFloat(); _pos.m_positionY = fields[++idx].GetFloat(); @@ -343,6 +345,7 @@ void SuggestionTicket::SaveToDB() const stmt->setUInt32(idx, _id); stmt->setUInt64(++idx, _playerGuid.GetCounter()); stmt->setString(++idx, _note); + stmt->setInt64(++idx, _createTime); stmt->setUInt16(++idx, _mapId); stmt->setFloat(++idx, _pos.GetPositionX()); stmt->setFloat(++idx, _pos.GetPositionY()); |