From 1cdeb4d057d525ec15d60474a8d187fac43b9918 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Fri, 17 Dec 2010 17:29:16 +0100 Subject: Core/Player: Change equipmentset saving to use prepared statements. Update issue #4550 Please try to re-reproduce --HG-- branch : trunk --- src/server/shared/Database/Implementation/CharacterDatabase.cpp | 5 +++++ src/server/shared/Database/Implementation/CharacterDatabase.h | 4 ++++ 2 files changed, 9 insertions(+) (limited to 'src/server/shared/Database') diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.cpp b/src/server/shared/Database/Implementation/CharacterDatabase.cpp index e1a092a1431..c11fdb57cd0 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/shared/Database/Implementation/CharacterDatabase.cpp @@ -246,5 +246,10 @@ bool CharacterDatabaseConnection::Open() PrepareStatement(CHAR_SET_CHANNEL_USAGE, "UPDATE channels SET last_used = UNIX_TIMESTAMP() WHERE m_name = ? AND m_team = ?", true); PrepareStatement(CHAR_CLEAN_CHANNEL, "DELETE FROM channels WHERE m_ownership = 1 AND (last_used + ?) < UNIX_TIMESTAMP()", true); + // Equipmentsets + PrepareStatement(CHAR_SET_EQUIP_SET, "UPDATE character_equipmentsets SET name=?, iconname=?, item0=?, item1=?, item2=?, item3=?, item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?", true); + PrepareStatement(CHAR_ADD_EQUIP_SET, "INSERT INTO character_equipmentsets (guid,setguid,setindex,name,iconname,item0,item1,item2,item3,item4,item5,item6,item7,item8,item9,item10,item11,item12,item13,item14,item15,item16,item17,item18) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", true); + PrepareStatement(CHAR_DEL_EQUIP_SET, "DELETE FROM character_equipmentsets WHERE setguid=?", true); + return true; } diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.h b/src/server/shared/Database/Implementation/CharacterDatabase.h index f53751065c7..77b300640e5 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.h +++ b/src/server/shared/Database/Implementation/CharacterDatabase.h @@ -206,6 +206,10 @@ enum CharacterDatabaseStatements CHAR_SET_CHANNEL_USAGE, CHAR_CLEAN_CHANNEL, + CHAR_SET_EQUIP_SET, + CHAR_ADD_EQUIP_SET, + CHAR_DEL_EQUIP_SET, + MAX_CHARACTERDATABASE_STATEMENTS, }; -- cgit v1.2.3