From b821a729733db0d3742b4aefe05e5a8305724f66 Mon Sep 17 00:00:00 2001 From: Matan Shukry Date: Sun, 26 Dec 2021 20:14:46 +0200 Subject: Core/Player: Initial War Mode support (#25926) * Enable PvP talents * War Mode buff aura * Forced PvP flagging Co-authored-by: Shauren --- src/server/database/Database/Implementation/CharacterDatabase.cpp | 3 +++ src/server/database/Database/Implementation/CharacterDatabase.h | 2 ++ 2 files changed, 5 insertions(+) (limited to 'src/server/database/Database/Implementation') diff --git a/src/server/database/Database/Implementation/CharacterDatabase.cpp b/src/server/database/Database/Implementation/CharacterDatabase.cpp index 0879d50c074..99c2d8ea45a 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -797,6 +797,9 @@ void CharacterDatabaseConnection::DoPrepareStatements() PrepareStatement(CHAR_DEL_CHARACTER_AURA_STORED_LOCATION, "DELETE FROM character_aura_stored_location WHERE Guid = ? AND Spell = ?", CONNECTION_ASYNC); PrepareStatement(CHAR_INS_CHARACTER_AURA_STORED_LOCATION, "INSERT INTO character_aura_stored_location (Guid, Spell, MapId, PositionX, PositionY, PositionZ, Orientation) " "VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC); + + // War mode + PrepareStatement(CHAR_SEL_WAR_MODE_TUNING, "SELECT race, COUNT(guid) FROM characters WHERE ((playerFlags & 0x00000800) = 0x00000800) AND logout_time >= (UNIX_TIMESTAMP() - 604800) GROUP BY race", CONNECTION_SYNCH); } CharacterDatabaseConnection::CharacterDatabaseConnection(MySQLConnectionInfo& connInfo) : MySQLConnection(connInfo) diff --git a/src/server/database/Database/Implementation/CharacterDatabase.h b/src/server/database/Database/Implementation/CharacterDatabase.h index e1862ce8eaf..571cc26183c 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -665,6 +665,8 @@ enum CharacterDatabaseStatements : uint32 CHAR_DEL_CHARACTER_AURA_STORED_LOCATION, CHAR_INS_CHARACTER_AURA_STORED_LOCATION, + CHAR_SEL_WAR_MODE_TUNING, + MAX_CHARACTERDATABASE_STATEMENTS }; -- cgit v1.2.3