From 1c852af7f2c820e429eaf8389822e8c910f961a1 Mon Sep 17 00:00:00 2001 From: Matan Shukry Date: Sun, 28 Mar 2021 02:22:34 +0300 Subject: Core/Spells: Implement SPELL_EFFECT_TELEPORT_TO_RETURN_POINT (#26217) --- src/server/database/Database/Implementation/CharacterDatabase.cpp | 7 +++++++ src/server/database/Database/Implementation/CharacterDatabase.h | 5 +++++ 2 files changed, 12 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 7f8273170b3..3f811766ea9 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -800,6 +800,13 @@ void CharacterDatabaseConnection::DoPrepareStatements() 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); + + // Spell Location + PrepareStatement(CHAR_SEL_CHARACTER_AURA_STORED_LOCATIONS, "SELECT Spell, MapId, PositionX, PositionY, PositionZ, Orientation FROM character_aura_stored_location WHERE Guid = ?", CONNECTION_ASYNC); + PrepareStatement(CHAR_DEL_CHARACTER_AURA_STORED_LOCATIONS_BY_GUID, "DELETE FROM character_aura_stored_location WHERE Guid = ?", CONNECTION_ASYNC); + 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); } 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 c756578c206..d05554f1219 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -671,6 +671,11 @@ enum CharacterDatabaseStatements : uint32 CHAR_INS_SCENARIO_INSTANCE_CRITERIA, CHAR_DEL_SCENARIO_INSTANCE_CRITERIA_FOR_INSTANCE, + CHAR_SEL_CHARACTER_AURA_STORED_LOCATIONS, + CHAR_DEL_CHARACTER_AURA_STORED_LOCATIONS_BY_GUID, + CHAR_DEL_CHARACTER_AURA_STORED_LOCATION, + CHAR_INS_CHARACTER_AURA_STORED_LOCATION, + MAX_CHARACTERDATABASE_STATEMENTS }; -- cgit v1.2.3