diff options
Diffstat (limited to 'src/server/shared/Database')
-rwxr-xr-x | src/server/shared/Database/Implementation/CharacterDatabase.cpp | 9 | ||||
-rwxr-xr-x | src/server/shared/Database/Implementation/CharacterDatabase.h | 7 |
2 files changed, 16 insertions, 0 deletions
diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.cpp b/src/server/shared/Database/Implementation/CharacterDatabase.cpp index 98db2e51dfa..f42d5b3062e 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/shared/Database/Implementation/CharacterDatabase.cpp @@ -273,6 +273,15 @@ bool CharacterDatabaseConnection::Open() PREPARE_STATEMENT(CHAR_ADD_INSTANCE_SAVE, "INSERT INTO instance (id,map,resettime,difficulty,completedEncounters,data) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC) PREPARE_STATEMENT(CHAR_UPDATE_INSTANCE_DATA, "UPDATE instance SET completedEncounters=?, data=? WHERE id=?", CONNECTION_ASYNC) + // Game event saves + PREPARE_STATEMENT(CHAR_DEL_GAME_EVENT_SAVE, "DELETE FROM game_event_save WHERE eventEntry = ?", CONNECTION_ASYNC) + PREPARE_STATEMENT(CHAR_ADD_GAME_EVENT_SAVE, "INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ? , ?)", CONNECTION_ASYNC) + + // Game event condition saves + PREPARE_STATEMENT(CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ?", CONNECTION_ASYNC) + PREPARE_STATEMENT(CHAR_DEL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ? AND condition_id = ?", CONNECTION_ASYNC) + PREPARE_STATEMENT(CHAR_ADD_GAME_EVENT_CONDITION_SAVE, "INSERT INTO game_event_condition_save (eventEntry, condition_id, done) VALUES (?, ?, ?)", CONNECTION_ASYNC) + for (PreparedStatementMap::const_iterator itr = m_queries.begin(); itr != m_queries.end(); ++itr) PrepareStatement(itr->first, itr->second.first, itr->second.second); diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.h b/src/server/shared/Database/Implementation/CharacterDatabase.h index 8fc1c9a38e9..9abc7a65b68 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.h +++ b/src/server/shared/Database/Implementation/CharacterDatabase.h @@ -228,6 +228,13 @@ enum CharacterDatabaseStatements CHAR_ADD_INSTANCE_SAVE, CHAR_UPDATE_INSTANCE_DATA, + CHAR_DEL_GAME_EVENT_SAVE, + CHAR_ADD_GAME_EVENT_SAVE, + + CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE, + CHAR_DEL_GAME_EVENT_CONDITION_SAVE, + CHAR_ADD_GAME_EVENT_CONDITION_SAVE, + MAX_CHARACTERDATABASE_STATEMENTS, }; |