aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2022-09-02 19:17:56 +0200
committerShauren <shauren.trinity@gmail.com>2022-09-02 19:27:27 +0200
commit6d2b8511547004b997cc1de76cdbaf5498b8b12c (patch)
treeefff0e743318d63b011f6aed08bc7a51f4589d41 /sql/updates
parent10302dca55ffc7db8c8cfc5b42f68bb082b1e8d7 (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.sql8
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.');