From 1292a987f17552d0d88db665f5b0192b704225a2 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Mon, 9 Oct 2017 21:22:47 +0200
Subject: Core/Mails: Fixed mail_items entries being left in database after
 deleting expired mails

Closes #20194
Closes #20461

(cherry picked from commit 1f3cf8bcf4ff786bea691a6460239a4127b2f97f)
---
 src/server/game/Globals/ObjectMgr.cpp | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'src')

diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp
index 24a54057d0d..07017fe5e78 100644
--- a/src/server/game/Globals/ObjectMgr.cpp
+++ b/src/server/game/Globals/ObjectMgr.cpp
@@ -5825,6 +5825,10 @@ void ObjectMgr::ReturnOrDeleteOldMails(bool serverUp)
                     stmt->setUInt64(0, itr2->item_guid);
                     CharacterDatabase.Execute(stmt);
                 }
+
+                stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_MAIL_ITEM_BY_ID);
+                stmt->setUInt32(0, m->messageID);
+                CharacterDatabase.Execute(stmt);
             }
             else
             {
-- 
cgit v1.2.3