createtriggers.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateTriggers.sql
#  Description : 飘府芭 府胶飘
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.09.06    厘全芒        饭绢 付胶磐 眠啊
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS Triggers;

CREATE TABLE Triggers (
  TriggerID 	int(10) 	unsigned NOT NULL auto_increment,
  TriggerType 	enum('NPC',
	                 'QUEST',
					 'MONSTER') 	NOT NULL default 'NPC',
  NPC 			varchar(20) 				 default NULL,
  QuestID 		int(10) 	unsigned 		 default '0',
  Conditions 	text 				NOT NULL,
  Actions 		text 				NOT NULL,

  PRIMARY KEY  (TriggerID)

) TYPE=MyISAM;


################################################################################
# 牢郸胶 积己



################################################################################
# Sequence 积己



################################################################################
# 鼻汉 汲沥 



################################################################################
# 单捞磐 持扁

###############################################################################
## 哥鲁伯
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : AtFirst',
		'ActionType : SetPosition
			ZoneID : 2022
			X : 38
			Y : 25
			Dir : 3'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : EveryTime
			Turn : 674',
		'ActionType : RandomSay
			StartScriptID : 101
			EndScriptID : 106'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : TalkedBy',
		'ActionType : Ask
			ScriptID : 100'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : AnsweredBy
			ScriptID : 100
			AnswerID : 1',
		'ActionType : Sell'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : AnsweredBy
			ScriptID : 100
			AnswerID : 2',
		'ActionType : Buy'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : AnsweredBy
			ScriptID : 100
			AnswerID : 3',
		'ActionType : QuitDialogue '
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥鲁伯',0,
		'ConditionType : Idle',
		'ActionType : RegenShop
			NPCID : 95
			Period : 300'
);

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
		'ConditionType : AtFirst',
		'ActionType : SetPosition
			ZoneID : 2021
			X : 31
			Y : 17
			Dir : 1'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
		'ConditionType : EveryTime
			Turn : 1112',
		'ActionType : RandomSay
			StartScriptID : 201
			EndScriptID : 205'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
		'ConditionType : TalkedBy',
		'ActionType : Ask
			ScriptID : 200'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,