From 1e127eef730ccb7f4fd5bec0c128104d667132c4 Mon Sep 17 00:00:00 2001 From: silinoron Date: Sat, 18 Sep 2010 19:21:03 -0700 Subject: Core/DBLayer: Change some regular statements to prepared statements. Patch by thyros82@gmx.de. Fixes issue #3774 --HG-- branch : trunk --- src/server/shared/Database/Implementation/WorldDatabase.cpp | 2 ++ src/server/shared/Database/Implementation/WorldDatabase.h | 2 ++ 2 files changed, 4 insertions(+) (limited to 'src/server/shared/Database') diff --git a/src/server/shared/Database/Implementation/WorldDatabase.cpp b/src/server/shared/Database/Implementation/WorldDatabase.cpp index 9dbd8a400be..b018f921b44 100644 --- a/src/server/shared/Database/Implementation/WorldDatabase.cpp +++ b/src/server/shared/Database/Implementation/WorldDatabase.cpp @@ -33,6 +33,8 @@ bool WorldDatabaseConnection::Open(const std::string& infoString) PrepareStatement(WORLD_DEL_CRESPAWNTIME, "DELETE FROM creature_respawn WHERE guid = ? AND instance = ?"); PrepareStatement(WORLD_ADD_CRESPAWNTIME, "INSERT INTO creature_respawn VALUES (?, ?, ?)"); PrepareStatement(WORLD_LOAD_QUEST_POOLS, "SELECT entry, pool_entry FROM pool_quest"); + PrepareStatement(WORLD_DEL_CRELINKED_RESPAWN, "DELETE FROM creature_linked_respawn WHERE guid = ?"); + PrepareStatement(WORLD_REP_CRELINKED_RESPAWN, "REPLACE INTO creature_linked_respawn (guid,linkedGuid) VALUES (?, ?)"); return true; } diff --git a/src/server/shared/Database/Implementation/WorldDatabase.h b/src/server/shared/Database/Implementation/WorldDatabase.h index 7f909d0de23..e810a6a07f9 100644 --- a/src/server/shared/Database/Implementation/WorldDatabase.h +++ b/src/server/shared/Database/Implementation/WorldDatabase.h @@ -46,6 +46,8 @@ enum WorldDatabaseStatements WORLD_DEL_CRESPAWNTIME, WORLD_ADD_CRESPAWNTIME, WORLD_LOAD_QUEST_POOLS, + WORLD_DEL_CRELINKED_RESPAWN, + WORLD_REP_CRELINKED_RESPAWN, MAX_WORLDDATABASE_STATEMENTS, }; -- cgit v1.2.3