createtriggers.sql

天之炼狱OpenDE_SQL.tar.gz

##############################################################################
## 沙莫尔
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : AtFirst',
		'\n	ActionType : SetPosition\n		ZoneID : 2013\n		X : 20\n		Y : 33\n		Dir : 3\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : EveryTime\n		Turn : 533',
		'\n	ActionType : RandomSay\n		StartScriptID : 3001\n		EndScriptID : 3006\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : TalkedBy',
		'ActionType : Ask\n		ScriptID : 3000\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : AnsweredBy \n		ScriptID : 3000\n		AnswerID : 1\n	',
		'\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : AnsweredBy \n		ScriptID : 3000\n		AnswerID : 2\n	',
		'\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : AnsweredBy\n		ScriptID : 3000\n		AnswerID : 3\n	',
		'\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC',
		'沙莫尔',0,
		'ConditionType : Idle',
		'\n	ActionType : RegenShop\n		NPCID : 162\n		Period : 300\n	');





INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2013\n		X : 42\n		Y : 33\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : EveryTime\n		Turn : 657','\n	ActionType : RandomSay\n		StartScriptID : 3101\n		EndScriptID : 3103\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 3100\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : AnsweredBy \n		ScriptID : 3100\n		AnswerID : 1\n	','\n	ActionType : TeachSkill\n		DomainType : HEAL\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : AnsweredBy \n		ScriptID : 3100\n		AnswerID : 2\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : AnsweredBy \n		ScriptID : 3100\n		AnswerID : 3\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : AnsweredBy\n		ScriptID : 3100\n		AnswerID : 4\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','拉可马诺夫',0,'ConditionType : Idle','\n	ActionType : RegenShop\n		NPCID : 163\n		Period : 300\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 12\n		X : 198\n		Y : 103\n		Dir : 1\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : EveryTime\n		Turn : 768','\n	ActionType : RandomSay\n		StartScriptID : 3301\n		EndScriptID : 3306\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 3300\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : AnsweredBy \n		ScriptID : 3300\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : AnsweredBy \n		ScriptID : 3300\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : AnsweredBy \n		ScriptID : 3300\n		AnswerID : 3\n	','\n	ActionType : SearchMotorcycle\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : AnsweredBy \n		ScriptID : 3300\n		AnswerID : 4\n	','\n	ActionType : QuitDialogue\n	ActionType : RedeemMotorcycle\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : AnsweredBy\n		ScriptID : 3300\n		AnswerID : 5\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','漠',0,'ConditionType : Idle','\n	ActionType : RegenShop\n		NPCID : 19\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','佛利可乐加斯',0,'ConditionType : Idle\n	','ActionType : RegenEventShop\n	  NPCID : 92\n	  Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','佛利可乐加斯',0,'ConditionType : AnsweredBy\n		ScriptID : 3412\n		AnswerID : 1\n	','ActionType : RedistributeAttr\n		AttrType : INT');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','佛利可乐加斯',0,'ConditionType : AnsweredBy\n		ScriptID : 3412\n		AnswerID : 2\n	','ActionType : QuitDialogue');

#############################################################################
## 卡帕提尼
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 1003\n		X : 27\n		Y : 73\n		Dir : 1\n	ActionType : InitSimpleQuest\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : EveryTime\n		Turn : 897','\n	ActionType : RandomSay\n		StartScriptID : 3501\n		EndScriptID : 3507\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 3500\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3500\n		AnswerID : 1\n	','\n	ActionType : StashSell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3500\n		AnswerID : 2\n	','\n	ActionType : StashOpen\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3500\n		AnswerID : 3\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3500\n		AnswerID : 4\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy\n		ScriptID : 3500\n		AnswerID : 5\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : Idle','\n	ActionType : RegenShop\n		NPCID : 93\n		Period : 300\n	');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3508\n		AnswerID : 1\n	','\n	ActionType : CancelQuest\n	ScriptID : 3510\n	CounterScriptID : 3511');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3508\n		AnswerID : 2\n	','\n	ActionType : QuitDialogue\n	');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3510\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','卡帕提尼',0,'ConditionType : AnsweredBy \n		ScriptID : 3511\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');

############################################################################33
## 巴勒里
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,
		'ConditionType : AtFirst',
		'
			ActionType : SetPosition
						 ZoneID : 1003
						 X : 69
						 Y : 29
						 Dir : 1
		');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,
		'ConditionType : EveryTime 
		                 Turn : 657',
		'
			ActionType : RandomSay
						 StartScriptID : 3601
						 EndScriptID : 3604
		');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 3600\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,'ConditionType : AnsweredBy \n		ScriptID : 3600\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,'ConditionType : AnsweredBy \n		ScriptID : 3600\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,'ConditionType : AnsweredBy\n		ScriptID : 3600\n		AnswerID : 3\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','巴勒里',0,'ConditionType : Idle','\n	ActionType : RegenShop\n		NPCID : 94\n		Period : 300\n	');



#############################################################################
# 赛思
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 1003\n		X : 46\n		Y : 98\n		Dir : 3\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : EveryTime\n		Turn : 587','\n	ActionType : RandomSay\n		StartScriptID : 3701\n		EndScriptID : 3707\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 3700\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AnsweredBy \n		ScriptID : 3700\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AnsweredBy \n		ScriptID : 3700\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AnsweredBy \n		ScriptID : 3700\n		AnswerID : 3\n	','\n	ActionType : Ask\n	ScriptID : 3710\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AnsweredBy\n		ScriptID : 3700\n		AnswerID : 4\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AnsweredBy\n		ScriptID : 3710\n		AnswerID : 1\n	','\n	ActionType : TakeOutGoods\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : AnsweredBy\n		ScriptID : 3710\n		AnswerID : 2\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赛思',0,'ConditionType : Idle','\n	ActionType : RegenShop\n		NPCID : 219\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','凯泽',0,'ConditionType : Idle\n	','ActionType : RegenEventShop\n	  NPCID : 17\n	  Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','凯泽',0,'ConditionType : AnsweredBy \n		ScriptID : 4010