⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 createtriggers.sql

📁 天之炼狱OpenDE_SQL.tar.gz
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : AnsweredBy \n		ScriptID : 2500\n		AnswerID : 3\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : AnsweredBy \n		ScriptID : 2500\n		AnswerID : 4\n	','\n	ActionType : QuitDialogue\n	ActionType : SetResurrectZone\n		ZoneID : 2011\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : AnsweredBy\n		ScriptID : 2500\n		AnswerID : 5\n	','\n	ActionType : QuitDialogue\n	');

##########################################################################################
## 叶布基尼
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AtFirst',
		'\n	ActionType : SetPosition\n		ZoneID : 2012\n		X : 17\n		Y : 29\n		Dir : 3\n	ActionType : InitPartnerWaitingManager\n	'); 
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : EveryTime\n		Turn : 677',
		'\n	ActionType : RandomSay\n		StartScriptID : 2601\n		EndScriptID : 2608\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : TalkedBy',
		'ActionType : Ask\n		ScriptID : 2600\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy \n		ScriptID : 2600\n		AnswerID : 1\n	',
		'\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy \n		ScriptID : 2600\n		AnswerID : 2\n	',
		'\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy\n		ScriptID : 2600\n		AnswerID : 3\n	',
		'\n	ActionType : Ask\n	ScriptID : 2610\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy\n		ScriptID : 2600\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 : 159\n		Period : 300\n	');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy	\n	ScriptID : 2610\n	AnswerID : 1\n	',
		'\n	ActionType : WaitForMeetCouple\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy	\n	ScriptID : 2610\n	AnswerID : 2\n	',
		'\n	ActionType : AcceptCoupleRequest\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy	\n	ScriptID : 2610\n	AnswerID : 3\n	',
		'\n	ActionType : Ask\n	ScriptID : 2611\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy	\n	ScriptID : 2610\n	AnswerID : 4\n	',
		'\n	ActionType : AcceptApartCouple\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy
			ScriptID : 2610
			AnswerID : 5',
		'ActionType : Ask
			ScriptID : 2600');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy	\n	ScriptID : 2611\n	AnswerID : 1\n	',
		'\n	ActionType : WaitForApartCouple\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','叶布基尼',0,
		'ConditionType : AnsweredBy	\n	ScriptID : 2611\n	AnswerID : 2\n	',
		'\n	ActionType : ForceApartCouple\n	');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尼古拉',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2012\n		X : 33\n		Y : 24\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尼古拉',0,'ConditionType : EveryTime\n		Turn : 432','\n	ActionType : RandomSay\n		StartScriptID : 2701\n		EndScriptID : 2704\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尼古拉',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 2700\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尼古拉',0,'ConditionType : AnsweredBy \n		ScriptID : 2700\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尼古拉',0,'ConditionType : AnsweredBy \n		ScriptID : 2700\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尼古拉',0,'ConditionType : AnsweredBy\n		ScriptID : 2700\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 : 160\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','理查德森',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2012\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 : 555','\n	ActionType : RandomSay\n		StartScriptID : 2801\n		EndScriptID : 2805\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','理查德森',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 2800\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','理查德森',0,'ConditionType : AnsweredBy \n		ScriptID : 2800\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','理查德森',0,'ConditionType : AnsweredBy \n		ScriptID : 2800\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','理查德森',0,'ConditionType : AnsweredBy\n		ScriptID : 2800\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 : 161\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 : 32\n		Y : 21\n		Dir : 1\n	ActionType : InitEventQuest\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : EveryTime\n		Turn : 865','\n	ActionType : RandomSay\n		StartScriptID : 2901\n		EndScriptID : 2909\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 2900\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy \n		ScriptID : 2900\n		AnswerID : 1\n	','\n	ActionType : TeachSkill\n		DomainType : ENCHANT\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy \n		ScriptID : 2900\n		AnswerID : 2\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy \n		ScriptID : 2900\n		AnswerID : 3\n	','\n	ActionType : Buy\n	');

#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2900\n		AnswerID : 4\n	',
#		'\n	ActionType : AskByQuestLevel\n	Level1 : 2923\n	Level2 : 2923\n	Level3 : 2920\n	Level4 : 2921\n	Level5 : 2922\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2900\n		AnswerID : 5\n	',
#		'\n	ActionType : GiveEventQuestScript\n	Level1 : 2927\n	Level2 : 2927\n	Level3 : 2924\n	Level4 : 2925\n	Level5 : 2926\n	NotComplete : 2928\n	Success : 2929\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2900\n		AnswerID : 6\n	',
#		'\n ActionType : RewardEventQuest\n	Level1 : 2932\n	Level2 : 2932\n	Level3 : 2930\n	Level4 : 2931\n	Level5 : 2932\n	Counter : 2938\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2900\n		AnswerID : 7\n	',
#		'ActionType : CancelEventQuestScript\n	Level1 : 2934\n	Level2 : 2934\n	Level3 : 2933\n	Level4 : 2933\n	Level5 : 2934\n	Counter : 2934\n	Success : 2935\n	');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2900\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 : 25\n		Period : 300\n	');

#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2920\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2921\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2922\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2923\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2924\n		AnswerID : 1\n	','\n	ActionType : AskVariable\n	ScriptID : 2936\n	Variable : QuestZone:EventQuestZone(3)\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2925\n		AnswerID : 1\n	','\n	ActionType : AskVariable\n	ScriptID : 2937\n	Variable : QuestZone:EventQuestZone(4),QuestMonster:EventQuestMonster(4)\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2926\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2927\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2928\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2929\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2930\n		AnswerID : 1\n	','\n	ActionType : AdvanceEventQuest\n	QuestLevel : 3\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2930\n		AnswerID : 2\n	','\n	ActionType : GiveLotto\n	QuestLevel : 3\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2931\n		AnswerID : 1\n	','\n	ActionType : AdvanceEventQuest\n	QuestLevel : 4\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2931\n		AnswerID : 2\n	','\n	ActionType : GiveLotto\n	QuestLevel : 4\n	');
#
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2933\n		AnswerID : 1\n	','\n	ActionType : CancelQuest\n	ScriptID : 0\n	CounterScriptID : 0\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2933\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2938\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2932\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2934\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2935\n		AnswerID : 1\n	','\n	ActionType : QuitDialogue\n	');
#
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2936\n		AnswerID : 1\n	','\n	ActionType : StartEventQuest\n	QuestLevel : 3\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2936\n		AnswerID : 2\n	','\n	ActionType : QuitDialogue\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2937\n		AnswerID : 1\n	','\n	ActionType : StartEventQuest\n	QuestLevel : 4\n	');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉尼伐',0,'ConditionType : AnsweredBy\n		ScriptID : 2937\n		AnswerID : 2\n	','\n	ActionType : QuitDialogue\n	');
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -