From fda65981c7a4c475c270755c198dee85cd38dfa3 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 19 Apr 2022 22:15:12 +0200 Subject: Core/Conversations: Conversation actor improvements * Store NoActorObject in database * Support adding player as conversation actor using database * Send actor id in packets Co-authored-by: funjoker Closes #27911 --- sql/updates/world/master/2022_04_19_00_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/master/2022_04_19_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2022_04_19_00_world.sql b/sql/updates/world/master/2022_04_19_00_world.sql new file mode 100644 index 00000000000..e4f80fd062b --- /dev/null +++ b/sql/updates/world/master/2022_04_19_00_world.sql @@ -0,0 +1,7 @@ +ALTER TABLE `conversation_actors` + ADD `NoActorObject` TINYINT(3) UNSIGNED NULL DEFAULT '0' AFTER `CreatureDisplayInfoId`, + ADD `ActivePlayerObject` TINYINT(3) UNSIGNED NULL DEFAULT '0' AFTER `NoActorObject`; + +DELETE FROM `conversation_actors` WHERE `ConversationId`=13254 AND `Idx`=1; +INSERT INTO `conversation_actors` (`ConversationId`,`ConversationActorId`,`ConversationActorGuid`,`Idx`,`CreatureId`,`CreatureDisplayInfoId`,`NoActorObject`,`ActivePlayerObject`,`VerifiedBuild`) VALUES +(13254,0,0,1,0,0,0,1,40120); -- cgit v1.2.3