SQL: Quest - RageGate/ServerStuff GitHub Wiki

##Quest Queries

###Standard Quest Template

SET
@Quest_Name := Name_Here,
@Quest_ID := Id_Here,
@Quest_ := _Here,
@Quest_ := _Here,
@Quest_ := _Here,

###Play sound on quest accept

SET @Sound :=1234;  -- Replace with desired sound ID you wish you play.
SET @Start :=5555; -- Replace with Unique ID for end Script, set this to whatever you want.
SET @Quest :=25; -- Replace with Quest ID wished to link sound to.
INSERT INTO `quest_start_scripts` VALUES (@Start, 1, 16, @Sound, 1, 0, 0, 0, 0, 0);
UPDATE `quest_template` SET startscript=@Start WHERE id=@Quest;