diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_09_02_01_world.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/sql/updates/world/master/2022_09_02_01_world.sql b/sql/updates/world/master/2022_09_02_01_world.sql index c94250e6468..3e212b7e1f8 100644 --- a/sql/updates/world/master/2022_09_02_01_world.sql +++ b/sql/updates/world/master/2022_09_02_01_world.sql @@ -1,10 +1,12 @@ -- -SET @STRINGENTRY := 884; +SET @OBJECTIVE_STRING_ID := 884; +SET @QUEST_NOT_FOUND_STRING_ID := 1517; DELETE FROM `command` WHERE `name`='quest objective complete'; INSERT INTO `command` (`name`,`help`) VALUES ('quest objective complete','Syntax: .quest objective complete #questObjectiveId\nMark specific quest objective as completed for target character.'); -DELETE FROM `trinity_string` WHERE `entry`=@STRINGENTRY; +DELETE FROM `trinity_string` WHERE `entry` IN (@OBJECTIVE_STRING_ID,@QUEST_NOT_FOUND_STRING_ID); INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(@STRINGENTRY, 'Objective %u not found.'); +(@OBJECTIVE_STRING_ID, 'Objective %u not found.'), +(@QUEST_NOT_FOUND_STRING_ID, 'Quest ID %u does not exist.'); |