From 1206e815cd9785e4671f30548140f038567811a2 Mon Sep 17 00:00:00 2001 From: kelno Date: Mon, 8 Jan 2018 00:32:22 +0100 Subject: Core/Creature: improve DB linked_respawn handling (#21172) * Fixed SetCreatureLinkedRespawn function possible erasing/replacing a GameObject link (instead of a creature one) (cherry picked from commit 70eb18d0e58ecf0cfcda4f410a183c671fbafe5c) --- src/server/database/Database/Implementation/WorldDatabase.cpp | 5 +++-- src/server/database/Database/Implementation/WorldDatabase.h | 5 +++-- 2 files changed, 6 insertions(+), 4 deletions(-) (limited to 'src/server/database/Database/Implementation') diff --git a/src/server/database/Database/Implementation/WorldDatabase.cpp b/src/server/database/Database/Implementation/WorldDatabase.cpp index 06a9cfeb27d..a5ff404397f 100644 --- a/src/server/database/Database/Implementation/WorldDatabase.cpp +++ b/src/server/database/Database/Implementation/WorldDatabase.cpp @@ -24,8 +24,9 @@ void WorldDatabaseConnection::DoPrepareStatements() m_stmts.resize(MAX_WORLDDATABASE_STATEMENTS); PrepareStatement(WORLD_SEL_QUEST_POOLS, "SELECT entry, pool_entry FROM pool_quest", CONNECTION_SYNCH); - PrepareStatement(WORLD_DEL_CRELINKED_RESPAWN, "DELETE FROM linked_respawn WHERE guid = ?", CONNECTION_ASYNC); - PrepareStatement(WORLD_REP_CREATURE_LINKED_RESPAWN, "REPLACE INTO linked_respawn (guid, linkedGuid) VALUES (?, ?)", CONNECTION_ASYNC); + PrepareStatement(WORLD_DEL_LINKED_RESPAWN, "DELETE FROM linked_respawn WHERE guid = ? AND linkType = ?", CONNECTION_ASYNC); + PrepareStatement(WORLD_DEL_LINKED_RESPAWN_MASTER, "DELETE FROM linked_respawn WHERE linkedGuid = ? AND linkType = ?", CONNECTION_ASYNC); + PrepareStatement(WORLD_REP_LINKED_RESPAWN, "REPLACE INTO linked_respawn (guid, linkedGuid, linkType) VALUES (?, ?, ?)", CONNECTION_ASYNC); PrepareStatement(WORLD_SEL_CREATURE_TEXT, "SELECT CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange FROM creature_text", CONNECTION_SYNCH); PrepareStatement(WORLD_SEL_SMART_SCRIPTS, "SELECT entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, event_param5, event_param_string, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o FROM smart_scripts ORDER BY entryorguid, source_type, id, link", CONNECTION_SYNCH); PrepareStatement(WORLD_SEL_SMARTAI_WP, "SELECT entry, pointid, position_x, position_y, position_z FROM waypoints ORDER BY entry, pointid", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/WorldDatabase.h b/src/server/database/Database/Implementation/WorldDatabase.h index 0bac46285ef..99a54fc35ae 100644 --- a/src/server/database/Database/Implementation/WorldDatabase.h +++ b/src/server/database/Database/Implementation/WorldDatabase.h @@ -29,8 +29,9 @@ enum WorldDatabaseStatements : uint32 */ WORLD_SEL_QUEST_POOLS, - WORLD_DEL_CRELINKED_RESPAWN, - WORLD_REP_CREATURE_LINKED_RESPAWN, + WORLD_DEL_LINKED_RESPAWN, + WORLD_DEL_LINKED_RESPAWN_MASTER, + WORLD_REP_LINKED_RESPAWN, WORLD_SEL_CREATURE_TEXT, WORLD_SEL_SMART_SCRIPTS, WORLD_SEL_SMARTAI_WP, -- cgit v1.2.3