Core/DBLayer: More type fixes

3 files changed, 9 insertions, 5 deletions

diff --git a/src/server/game/Chat/Commands/Level3.cpp b/src/server/game/Chat/Commands/Level3.cpp
index 062f04bf4dd..d3417705867 100755
--- a/src/server/game/Chat/Commands/Level3.cpp
+++ b/src/server/game/Chat/Commands/Level3.cpp
@@ -427,7 +427,7 @@ bool ChatHandler::HandleListItemCommand(const char *args)
     result = CharacterDatabase.Query(stmt);
 
     if (result)
-        inv_count = (*result)[0].GetUInt32();
+        inv_count = (*result)[0].GetUInt64();
 
     stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY);
     stmt->setUInt32(0, item_id);
@@ -476,7 +476,7 @@ bool ChatHandler::HandleListItemCommand(const char *args)
     result = CharacterDatabase.Query(stmt);
 
     if (result)
-        mail_count = (*result)[0].GetUInt32();
+        mail_count = (*result)[0].GetUInt64();
 
     if (count > 0)
     {
@@ -523,7 +523,7 @@ bool ChatHandler::HandleListItemCommand(const char *args)
     result = CharacterDatabase.Query(stmt);
 
     if (result)
-        auc_count = (*result)[0].GetUInt32();
+        auc_count = (*result)[0].GetUInt64();
 
     if (count > 0)
     {
@@ -560,7 +560,7 @@ bool ChatHandler::HandleListItemCommand(const char *args)
     result = CharacterDatabase.Query(stmt);
 
     if (result)
-        guild_count = (*result)[0].GetUInt32();
+        guild_count = (*result)[0].GetUInt64();
 
     stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY);
     stmt->setUInt32(0, item_id);
diff --git a/src/server/game/Handlers/MailHandler.cpp b/src/server/game/Handlers/MailHandler.cpp
index 187b12d5d2e..c30cbaa622e 100755
--- a/src/server/game/Handlers/MailHandler.cpp
+++ b/src/server/game/Handlers/MailHandler.cpp
@@ -138,7 +138,7 @@ void WorldSession::HandleSendMail(WorldPacket & recv_data)
         if (result)
         {
             Field* fields = result->Fetch();
-            mails_count = fields[0].GetUInt32();
+            mails_count = fields[0].GetUInt64();
         }
 
         stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_CHAR_LEVEL);
diff --git a/src/server/game/Tickets/TicketMgr.cpp b/src/server/game/Tickets/TicketMgr.cpp
index 930bf0d3372..68e28014319 100755
--- a/src/server/game/Tickets/TicketMgr.cpp
+++ b/src/server/game/Tickets/TicketMgr.cpp
@@ -65,6 +65,8 @@ GmTicket::~GmTicket() { }
 
 bool GmTicket::LoadFromDB(Field* fields)
 {
+    //     0       1     2      3          4        5      6     7     8           9            10         11         12        13        14        15
+    // ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed
     uint8 index = 0;
     _id                 = fields[  index].GetUInt32();
     _playerGuid         = MAKE_NEW_GUID(fields[++index].GetUInt32(), 0, HIGHGUID_PLAYER);
@@ -87,6 +89,8 @@ bool GmTicket::LoadFromDB(Field* fields)
 
 void GmTicket::SaveToDB(SQLTransaction& trans) const
 {
+    //     0       1     2      3          4        5      6     7     8           9            10         11         12        13        14        15
+    // ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed
     uint8 index = 0;
     PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_REP_GM_TICKET);
     stmt->setUInt32(  index, _id);