diff options
Diffstat (limited to 'src')
3 files changed, 4 insertions, 2 deletions
diff --git a/src/server/database/Database/Implementation/CharacterDatabase.cpp b/src/server/database/Database/Implementation/CharacterDatabase.cpp index 6c17f0c4c07..80be3a59bee 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -252,7 +252,6 @@ void CharacterDatabaseConnection::DoPrepareStatements() // Tutorials PrepareStatement(CHAR_SEL_TUTORIALS, "SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC); - PrepareStatement(CHAR_SEL_HAS_TUTORIALS, "SELECT 1 FROM account_tutorial WHERE accountId = ?", CONNECTION_SYNCH); PrepareStatement(CHAR_INS_TUTORIALS, "INSERT INTO account_tutorial(tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7, accountId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC); PrepareStatement(CHAR_UPD_TUTORIALS, "UPDATE account_tutorial SET tut0 = ?, tut1 = ?, tut2 = ?, tut3 = ?, tut4 = ?, tut5 = ?, tut6 = ?, tut7 = ? WHERE accountId = ?", CONNECTION_ASYNC); PrepareStatement(CHAR_DEL_TUTORIALS, "DELETE FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC); diff --git a/src/server/database/Database/Implementation/CharacterDatabase.h b/src/server/database/Database/Implementation/CharacterDatabase.h index 0d9b518cafa..1991c9e4b68 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -210,7 +210,6 @@ enum CharacterDatabaseStatements CHAR_DEL_PLAYER_ACCOUNT_DATA, CHAR_SEL_TUTORIALS, - CHAR_SEL_HAS_TUTORIALS, CHAR_INS_TUTORIALS, CHAR_UPD_TUTORIALS, CHAR_DEL_TUTORIALS, diff --git a/src/server/game/Server/WorldSession.cpp b/src/server/game/Server/WorldSession.cpp index c716b0bdd3b..7eda06aefec 100644 --- a/src/server/game/Server/WorldSession.cpp +++ b/src/server/game/Server/WorldSession.cpp @@ -780,6 +780,10 @@ void WorldSession::SaveTutorialsData(SQLTransaction &trans) stmt->setUInt32(MAX_ACCOUNT_TUTORIAL_VALUES, GetAccountId()); trans->Append(stmt); + // now has, set flag so next save uses update query + if (!hasTutorialsInDB) + m_TutorialsChanged |= TUTORIALS_FLAG_LOADED_FROM_DB; + m_TutorialsChanged &= ~TUTORIALS_FLAG_CHANGED; } |