Completing a Quest

Description

A player completes a quest and receives rewards.

SQL Example

UPDATE Character 
SET EXP = EXP + (SELECT EXP_Reward FROM Quest WHERE QuestID = 1),
    Gold = Gold + (SELECT Gold_Reward FROM Quest WHERE QuestID = 1)
WHERE CharacterID = 1;