diff options
| author | Malcrom <malcromdev@gmail.com> | 2023-12-09 19:25:40 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-12-10 00:25:40 +0100 |
| commit | 624dfafeb2458922bdad6f3764002b96c2c5ff5d (patch) | |
| tree | 563001392f1c01b6f5c6b6d80acad60b5704e88c /sql/updates | |
| parent | e8f98d8d84402754520e5266229efc94c925e345 (diff) | |
Scripts/ExilesReach: Fix some cosmetic issues (#29486)
* instantly update NPCs for Emergency First Aid after healing them to instantly make them stand
* fixed actor guid and conditions for conversation of Finding the Lost Expedition
* fixed issue of Won'za/Alaria not laying injured after turning Cooking Meat quest in
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2023_12_10_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_12_10_00_world.sql b/sql/updates/world/master/2023_12_10_00_world.sql new file mode 100644 index 00000000000..6f629ec0d35 --- /dev/null +++ b/sql/updates/world/master/2023_12_10_00_world.sql @@ -0,0 +1,10 @@ +-- Fix guid for Wonza error in a previous commit +UPDATE `conversation_actors` SET `ConversationActorGuid`=1051211 WHERE `ConversationId`=12058 AND `ConversationActorId`=76284; -- CONVERSATION_LINE_ESCORT_SURVIVOR_CAMP Wonza + +-- Missing Conditions on conversation lines for "Finding the lost Expedition" +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=29 AND `SourceEntry` IN (29322,34645,36152,36153); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(29,0,29322,0,0,6,0,469,0,0,0,0,0,'','Allow conversation line 29322 if team is Alliance'), +(29,0,34645,0,0,6,0,469,0,0,0,0,0,'','Allow conversation line 34645 if team is Alliance'), +(29,0,36152,0,0,6,0,67,0,0,0,0,0,'','Allow conversation line 36152 if team is horde'), +(29,0,36153,0,0,6,0,67,0,0,0,0,0,'','Allow conversation line 36153 if team is horde'); |