diff options
Diffstat (limited to 'src/server/database')
| -rw-r--r-- | src/server/database/Database/Implementation/CharacterDatabase.cpp | 4 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/CharacterDatabase.h | 4 |
2 files changed, 2 insertions, 6 deletions
diff --git a/src/server/database/Database/Implementation/CharacterDatabase.cpp b/src/server/database/Database/Implementation/CharacterDatabase.cpp index 5845a0d6a3a..9027b3f575a 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -735,9 +735,7 @@ void CharacterDatabaseConnection::DoPrepareStatements() // Scenario PrepareStatement(CHAR_SEL_SCENARIO_INSTANCE_CRITERIA_FOR_INSTANCE, "SELECT criteria, counter, date FROM instance_scenario_progress WHERE id = ?", CONNECTION_SYNCH); - PrepareStatement(CHAR_SEL_SCENARIO_INSTANCE_CRITERIA, "SELECT counter, date FROM instance_scenario_progress WHERE id = ? AND criteria = ?", CONNECTION_SYNCH); + PrepareStatement(CHAR_DEL_SCENARIO_INSTANCE_CRITERIA, "DELETE FROM instance_scenario_progress WHERE id = ? AND criteria = ?", CONNECTION_ASYNC); PrepareStatement(CHAR_INS_SCENARIO_INSTANCE_CRITERIA, "INSERT INTO instance_scenario_progress (id, criteria, counter, date) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC); PrepareStatement(CHAR_DEL_SCENARIO_INSTANCE_CRITERIA_FOR_INSTANCE, "DELETE FROM instance_scenario_progress WHERE id = ?", CONNECTION_ASYNC); - PrepareStatement(CHAR_UPD_SCENARIO_INSTANCE_CRITERIA, "UPDATE instance_scenario_progress SET counter = ?, date = ? WHERE id = ? AND criteria = ?", CONNECTION_ASYNC); - PrepareStatement(CHAR_DEL_INVALID_SCENARIO_INSTANCE_CRITERIA, "DELETE FROM instance_scenario_progress WHERE id = ? AND criteria = ?", CONNECTION_ASYNC); } diff --git a/src/server/database/Database/Implementation/CharacterDatabase.h b/src/server/database/Database/Implementation/CharacterDatabase.h index 02969290007..91f8a51eda3 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -624,11 +624,9 @@ enum CharacterDatabaseStatements CHAR_INS_BLACKMARKET_AUCTIONS, CHAR_SEL_SCENARIO_INSTANCE_CRITERIA_FOR_INSTANCE, - CHAR_SEL_SCENARIO_INSTANCE_CRITERIA, + CHAR_DEL_SCENARIO_INSTANCE_CRITERIA, CHAR_INS_SCENARIO_INSTANCE_CRITERIA, CHAR_DEL_SCENARIO_INSTANCE_CRITERIA_FOR_INSTANCE, - CHAR_UPD_SCENARIO_INSTANCE_CRITERIA, - CHAR_DEL_INVALID_SCENARIO_INSTANCE_CRITERIA, MAX_CHARACTERDATABASE_STATEMENTS }; |