diff options
author | Shauren <shauren.trinity@gmail.com> | 2022-09-02 19:17:56 +0200 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2022-09-02 19:27:27 +0200 |
commit | 6d2b8511547004b997cc1de76cdbaf5498b8b12c (patch) | |
tree | efff0e743318d63b011f6aed08bc7a51f4589d41 /sql/updates | |
parent | 10302dca55ffc7db8c8cfc5b42f68bb082b1e8d7 (diff) |
Core/Commands: Convert quest commands to new system
Diffstat (limited to 'sql/updates')
-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.'); |