aboutsummaryrefslogtreecommitdiff
path: root/src/server/shared/Database/Implementation
diff options
context:
space:
mode:
Diffstat (limited to 'src/server/shared/Database/Implementation')
-rw-r--r--src/server/shared/Database/Implementation/WorldDatabase.cpp9
-rw-r--r--src/server/shared/Database/Implementation/WorldDatabase.h2
2 files changed, 10 insertions, 1 deletions
diff --git a/src/server/shared/Database/Implementation/WorldDatabase.cpp b/src/server/shared/Database/Implementation/WorldDatabase.cpp
index 26a270f565a..12383490e91 100644
--- a/src/server/shared/Database/Implementation/WorldDatabase.cpp
+++ b/src/server/shared/Database/Implementation/WorldDatabase.cpp
@@ -20,11 +20,18 @@
bool WorldDatabaseConnection::Open(const std::string& infoString)
{
+ if (!MySQLConnection::Open(infoString))
+ return false;
+
+ m_stmts.resize(MAX_WORLDDATABASE_STATEMENTS);
+
/*
##################################
LOAD YOUR PREPARED STATEMENTS HERE
##################################
*/
+ PrepareStatement(WORLD_DEL_CRESPAWNTIME, "DELETE FROM creature_respawn WHERE guid = ? AND instance = ?");
+ PrepareStatement(WORLD_ADD_CRESPAWNTIME, "INSERT INTO creature_respawn VALUES (?, ?, ?)");
- return MySQLConnection::Open(infoString);
+ return true;
}
diff --git a/src/server/shared/Database/Implementation/WorldDatabase.h b/src/server/shared/Database/Implementation/WorldDatabase.h
index eb76791faaa..fb40869cc19 100644
--- a/src/server/shared/Database/Implementation/WorldDatabase.h
+++ b/src/server/shared/Database/Implementation/WorldDatabase.h
@@ -37,6 +37,8 @@ typedef DatabaseWorkerPool<WorldDatabaseConnection> WorldDatabaseWorkerPool;
enum WorldDatabaseStatements
{
+ WORLD_DEL_CRESPAWNTIME,
+ WORLD_ADD_CRESPAWNTIME,
MAX_WORLDDATABASE_STATEMENTS,
};