From d8ddf38453cb988645244d0f10da10f1d1665c93 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 21 Sep 2010 21:55:16 +0200 Subject: Core/Items: Implemented trading soulbound loot items Core/DBLayer: Converted more more player-related queries into prepared statements Core/Items: Fixed loading of enchantments Closes issue #4130. --HG-- branch : trunk --- src/server/game/Globals/ObjectMgr.cpp | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'src/server/game/Globals/ObjectMgr.cpp') diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index 34c122109e1..c67c3e214e4 100644 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -5553,7 +5553,11 @@ void ObjectMgr::ReturnOrDeleteOldMails(bool serverUp) { // mail open and then not returned for (std::vector::iterator itr2 = m->items.begin(); itr2 != m->items.end(); ++itr2) - CharacterDatabase.PExecute("DELETE FROM item_instance WHERE guid = '%u'", itr2->item_guid); + { + PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_ITEM_INSTANCE); + stmt->setUInt32(0, itr2->item_guid); + CharacterDatabase.Execute(stmt); + } } else { -- cgit v1.2.3