각종 노하우 분류
레드문 퀘스트 트리거
컨텐츠 정보
- 129 조회
- 0 추천
- 0 비추천
- 목록
본문
버전이나 셋팅에 따라 퀘스트 몹이 안나와서 진행이 안되는 버전도 존재합니다 그럴때 사용하는 트리거입니다
CREATE TRIGGER TR_INSERT_TBLGAMEID1 ON TBLGAMEID1
FOR INSERT
AS
BEGIN
DECLARE @GAMEID CHAR(14)
SELECT @GAMEID= GAMEID FROM INSERTED
BEGIN
insert into tblRebirth (GameID, rebirth, change, data) values (@GameID, 0, 0, 2005-11-1)
UPDATE TBLGAMEID1 SET Item='0:6-204/3.1:6-205/3.2:6-206/3.3:6-207/3.' WHERE GAMEID=@GameID
UPDATE TBLGAMEID1 SET SETimer='0:500000.3:500000.23:500000.25:500000.30:500000.32:500000.33:500000.42:500000.53:0.58:0.60:500000.62:500000.64:500000.' WHERE GAMEID=@GameID
insert into tblUserQuest1 (QuestID,DoneCount,LastProcTime,QuestItem,TaskID,RemainTime,TaskType,Value1,Value2,Value3,Value4,Value5,Value6,GameID)
values (1,1,2005-11-1,1,0,0,-1,-1,-1,-1,-1,-1,-1,@GameID)
END
END
CREATE TRIGGER TR_INSERT_TBLGAMEID1 ON TBLGAMEID1
FOR INSERT
AS
BEGIN
DECLARE @GAMEID CHAR(14)
SELECT @GAMEID= GAMEID FROM INSERTED
BEGIN
insert into tblRebirth (GameID, rebirth, change, data) values (@GameID, 0, 0, 2005-11-1)
UPDATE TBLGAMEID1 SET Item='0:6-204/3.1:6-205/3.2:6-206/3.3:6-207/3.' WHERE GAMEID=@GameID
UPDATE TBLGAMEID1 SET SETimer='0:500000.3:500000.23:500000.25:500000.30:500000.32:500000.33:500000.42:500000.53:0.58:0.60:500000.62:500000.64:500000.' WHERE GAMEID=@GameID
insert into tblUserQuest1 (QuestID,DoneCount,LastProcTime,QuestItem,TaskID,RemainTime,TaskType,Value1,Value2,Value3,Value4,Value5,Value6,GameID)
values (1,1,2005-11-1,1,0,0,-1,-1,-1,-1,-1,-1,-1,@GameID)
END
END
-
등록일 2025.09.29
-
등록일 2025.09.29
관련자료
댓글 0
등록된 댓글이 없습니다.