Quest Clear Trigger for 4.x Server

[advenire]

CREATE TRIGGER [Quest_Clear] ON [dbo].[tblGameID1]
FOR INSERT
AS
BEGIN
DECLARE @GAMEID CHAR(14)
SELECT @GAMEID = GAMEID FROM INSERTED
BEGIN
insert into tblUserQuest1 (QuestID,DoneCount,LastProcTime,QuestItem,TaskID,RemainTime,TaskType,Value1,Value2,Value3,Value4,Value5,Value6,GameID)
values (1,1,2004-08-26,1,0,0,-1,-1,-1,-1,-1,-1,-1,@GameID)
END
END


Created by FREEZONE

[MentaL]