From a09340836080f02d4b724d215587aef805f90767 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sat, 18 Dec 2010 23:25:03 +0100 Subject: Core/Player: Convert _SaveAuras to prepared statement format --HG-- branch : trunk --- src/server/shared/Database/Implementation/CharacterDatabase.cpp | 5 +++++ src/server/shared/Database/Implementation/CharacterDatabase.h | 3 +++ 2 files changed, 8 insertions(+) (limited to 'src/server/shared/Database/Implementation') diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.cpp b/src/server/shared/Database/Implementation/CharacterDatabase.cpp index c11fdb57cd0..5e5ab97e075 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/shared/Database/Implementation/CharacterDatabase.cpp @@ -251,5 +251,10 @@ bool CharacterDatabaseConnection::Open() 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); + // Auras + PrepareStatement(CHAR_DEL_AURA, "DELETE FROM character_aura WHERE guid = ?", true); + PrepareStatement(CHAR_ADD_AURA, "INSERT INTO character_aura (guid,caster_guid,spell,effect_mask,recalculate_mask,stackcount,amount0,amount1,amount2,base_amount0,base_amount1,base_amount2,maxduration,remaintime,remaincharges) " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", true); + return true; } diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.h b/src/server/shared/Database/Implementation/CharacterDatabase.h index 77b300640e5..e9b83fcfad8 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.h +++ b/src/server/shared/Database/Implementation/CharacterDatabase.h @@ -210,6 +210,9 @@ enum CharacterDatabaseStatements CHAR_ADD_EQUIP_SET, CHAR_DEL_EQUIP_SET, + CHAR_DEL_AURA, + CHAR_ADD_AURA, + MAX_CHARACTERDATABASE_STATEMENTS, }; -- cgit v1.2.3