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

📄 createtriggers.sql

📁 天之炼狱OpenDE_SQL.tar.gz
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
		'ConditionType : AnsweredBy
			ScriptID : 200
			AnswerID : 1',
		'ActionType : Repair'
);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
		'ConditionType : AnsweredBy
			ScriptID : 200
			AnswerID : 2',
		'ActionType : SilverCoating'
);
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
#		'ConditionType : AnsweredBy
#			ScriptID : 200
#			AnswerID : 3',
#		'ActionType : Ask
#			ScriptID : 206'
#);
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
#		'ConditionType : AnsweredBy
#			ScriptID : 200
#			AnswerID : 4',
#		'ActionType : TradeLairItem
#			Type : 7'
#);
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
#		'ConditionType : AnsweredBy
#			ScriptID : 200
#			AnswerID : 5',
#		'ActionType : TradeLairItem
#			Type : 8'
#);
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,
		'ConditionType : AnsweredBy
			ScriptID : 200		
			AnswerID : 3',
		'ActionType : QuitDialogue');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 206\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,'ConditionType : AnsweredBy \n		ScriptID : 206\n		AnswerID : 1\n	','ActionType : Ask\n 	ScriptID : 207\n');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,'ConditionType : AnsweredBy \n		ScriptID : 206\n		AnswerID : 2\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 207\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,'ConditionType : AnsweredBy \n		ScriptID : 207\n		AnswerID : 1\n	','ActionType : GiveAccountEventItem\n SpecialEventFlag : 2\n	CommonFilename : ../data/lua/premiumEventItemCommon.luc\n SlayerFilename : ../data/lua/premiumEventItemSlayer.luc\n  VampireFilename : ../data/lua/premiumEventItemVampire.luc\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','司马尔罗维奇',0,'ConditionType : AnsweredBy \n		ScriptID : 207\n		AnswerID : 2\n	','\n	ActionType : QuitDialogue\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2021\n		X : 43\n		Y : 39\n		Dir : 1\n	ActionType : PrepareShop\n		NPCID : 101\n		MarketConditionBuy : 25\n		MarketConditionSell : 100\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : EveryTime\n		Turn : 546','\n	ActionType : RandomSay\n		StartScriptID : 301\n		EndScriptID : 305\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : AnsweredBy \n		ScriptID : 300\n		AnswerID : 1\n	','\n	ActionType : Heal\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : AnsweredBy \n		ScriptID : 300\n		AnswerID : 2\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : AnsweredBy \n		ScriptID : 300\n		AnswerID : 3\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : AnsweredBy \n		ScriptID : 300\n		AnswerID : 4\n	','\n	ActionType : QuitDialogue\n	ActionType : SetResurrectZone\n		ZoneID : 2021\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','约翰娜',0,'ConditionType : AnsweredBy\n		ScriptID : 300\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 : 2022\n		X : 19\n		Y : 25\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','西哈拉',0,'ConditionType : EveryTime\n		Turn : 444','\n	ActionType : RandomSay\n		StartScriptID : 401\n		EndScriptID : 406\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','西哈拉',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 400');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','西哈拉',0,'ConditionType : AnsweredBy \n		ScriptID : 400\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','西哈拉',0,'ConditionType : AnsweredBy \n		ScriptID : 400\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','西哈拉',0,'ConditionType : AnsweredBy\n		ScriptID : 400\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 : 100\n		Period : 300\n	');

################################################################################
## 克里斯
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AtFirst','ActionType : SetPosition\n		ZoneID : 2021\n	 	X : 20\n	 	Y : 23\n	 	Dir : 1\n	 ActionType : InitSimpleQuest\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : EveryTime\n		Turn : 555','ActionType : RandomSay\n		StartScriptID : 501\n		EndScriptID : 509\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 500');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 500\n		AnswerID : 1','ActionType : StashSell');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 500\n		AnswerID : 2','ActionType : StashOpen');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 500\n		AnswerID : 3','ActionType : SelectQuest');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 500\n		AnswerID : 4','ActionType : QuestReward');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 500\n		AnswerID : 5','ActionType : Ask\n	ScriptID : 510');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 500\n		AnswerID : 6','ActionType : QuitDialogue');

INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 510\n		AnswerID : 1','ActionType : CancelQuest\n	ScriptID : 512\n	CounterScriptID : 511');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 510\n		AnswerID : 2','ActionType : QuitDialogue');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 511\n		AnswerID : 1','ActionType : QuitDialogue');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯',0,'ConditionType : AnsweredBy\n		ScriptID : 512\n		AnswerID : 1','ActionType : QuitDialogue');



INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','山德拉',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2022\n		X : 45\n		Y : 35\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','山德拉',0,'ConditionType : EveryTime\n		Turn : 777','\n	ActionType : RandomSay\n		StartScriptID : 601\n		EndScriptID : 603\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','山德拉',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 600\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','山德拉',0,'ConditionType : AnsweredBy \n		ScriptID : 600\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','山德拉',0,'ConditionType : AnsweredBy \n		ScriptID : 600\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','山德拉',0,'ConditionType : AnsweredBy\n		ScriptID : 600\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 : 97\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2023\n		X : 13\n		Y : 46\n		Dir : 3\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : EveryTime\n		Turn : 987','\n	ActionType : RandomSay\n		StartScriptID : 701\n		EndScriptID : 703\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 700\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : AnsweredBy \n		ScriptID : 700\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : AnsweredBy \n		ScriptID : 700\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : AnsweredBy \n		ScriptID : 700\n		AnswerID : 3\n	','\n	ActionType : SilverCoating\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','赫斯布罗',0,'ConditionType : AnsweredBy\n		ScriptID : 700\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 : 110\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2023\n		X : 41\n		Y : 30\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : EveryTime\n		Turn : 1024','\n	ActionType : RandomSay\n		StartScriptID : 801\n		EndScriptID : 806\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 800\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : AnsweredBy \n		ScriptID : 800\n		AnswerID : 1\n	','\n	ActionType : TeachSkill\n		DomainType : BLADE\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : AnsweredBy \n		ScriptID : 800\n		AnswerID : 2\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : AnsweredBy \n		ScriptID : 800\n		AnswerID : 3\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','尤娃',0,'ConditionType : AnsweredBy\n		ScriptID : 800\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 : 14\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : AtFirst','\n	ActionType : SetPosition\n		ZoneID : 2023\n		X : 33\n		Y : 20\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : EveryTime\n		Turn : 690','\n	ActionType : RandomSay\n		StartScriptID : 901\n		EndScriptID : 906\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 900\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : AnsweredBy \n		ScriptID : 900\n		AnswerID : 1\n	','\n	ActionType : TeachSkill\n		DomainType : SWORD\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : AnsweredBy \n		ScriptID : 900\n		AnswerID : 2\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : AnsweredBy \n		ScriptID : 900\n		AnswerID : 3\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','汉',0,'ConditionType : AnsweredBy\n		ScriptID : 900\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 : 24\n		Period : 300\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','可南',0,'ConditionType : Idle \n	','ActionType : RegenEventShop\n	   NPCID : 157\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 : 194\n		Y : 149\n		Dir : 1\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','杰克',0,'ConditionType : EveryTime\n		Turn : 789','\n	ActionType : RandomSay\n		StartScriptID : 1101\n		EndScriptID : 1105\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','杰克',0,'ConditionType : TalkedBy','ActionType : Ask\n		ScriptID : 1100\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','杰克',0,'ConditionType : AnsweredBy \n		ScriptID : 1100\n		AnswerID : 1\n	','\n	ActionType : Sell\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','杰克',0,'ConditionType : AnsweredBy \n		ScriptID : 1100\n		AnswerID : 2\n	','\n	ActionType : Buy\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','杰克',0,'ConditionType : AnsweredBy \n		ScriptID : 1100\n		AnswerID : 3\n	','\n	ActionType : SearchMotorcycle\n	');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','杰克',0,'ConditionType : AnsweredBy \n		ScriptID : 1100\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 : 1100\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 : 109\n		Period : 300\n	');
12345

⌨️ 快捷键说明

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