📄 createtriggers.sql
字号:
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','戴维',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 2001\n X : 33\n Y : 25\n Dir : 1\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','戴维',0,'ConditionType : EveryTime\n Turn : 1001','\n ActionType : RandomSay\n StartScriptID : 1201\n EndScriptID : 1205\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','戴维',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1200\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','戴维',0,'ConditionType : AnsweredBy \n ScriptID : 1200\n AnswerID : 1\n ','\n ActionType : Repair\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','戴维',0,'ConditionType : AnsweredBy\n ScriptID : 1200\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 : 2001\n X : 22\n Y : 22\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 : 1301\n EndScriptID : 1305\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','凯文',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1300\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','凯文',0,'ConditionType : AnsweredBy\n ScriptID : 1300\n AnswerID : 1\n ','\n ActionType : StashSell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','凯文',0,'ConditionType : AnsweredBy\n ScriptID : 1300\n AnswerID : 2\n ','\n ActionType : StashOpen\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','凯文',0,'ConditionType : AnsweredBy\n ScriptID : 1300\n AnswerID : 3\n ','\n ActionType : QuitDialogue\n ');
##################################################################################
## 沙拉曼德
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 2001\n X : 42\n Y : 36\n Dir : 1\n ActionType : PrepareShop\n NPCID : 98\n MarketConditionBuy : 25\n MarketConditionSell : 100\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : EveryTime\n Turn : 811','\n ActionType : RandomSay\n StartScriptID : 1401\n EndScriptID : 1406\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1400\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : AnsweredBy \n ScriptID : 1400\n AnswerID : 1\n ','\n ActionType : Heal\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : AnsweredBy \n ScriptID : 1400\n AnswerID : 2\n ','\n ActionType : Sell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : AnsweredBy \n ScriptID : 1400\n AnswerID : 3\n ','\n ActionType : Buy\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : AnsweredBy \n ScriptID : 1400\n AnswerID : 4\n ','\n ActionType : QuitDialogue\n ActionType : SetResurrectZone\n ZoneID : 2001\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','沙拉曼德',0,'ConditionType : AnsweredBy\n ScriptID : 1400\n AnswerID : 5\n ','\n ActionType : QuitDialogue\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : AtFirst','ActionType : SetPosition\n ZoneID : 2002\n X : 31\n Y : 21\n Dir : 1\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : EveryTime\n Turn : 647','ActionType : RandomSay\n StartScriptID : 1501\n EndScriptID : 1506\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1500\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : AnsweredBy \n ScriptID : 1500\n AnswerID : 1\n ','ActionType : Sell');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : AnsweredBy \n ScriptID : 1500\n AnswerID : 2\n ','ActionType : Buy');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : AnsweredBy\n ScriptID : 1500\n AnswerID : 3\n ','ActionType : QuitDialogue');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','索尼亚',0,'ConditionType : Idle','ActionType : RegenShop\n NPCID : 99\n Period : 300');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克劳尔',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 2002\n X : 19\n Y : 26\n Dir : 3\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克劳尔',0,'ConditionType : EveryTime\n Turn : 950','\n ActionType : RandomSay\n StartScriptID : 1601\n EndScriptID : 1603\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克劳尔',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1600\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克劳尔',0,'ConditionType : AnsweredBy \n ScriptID : 1600\n AnswerID : 1\n ','\n ActionType : Sell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克劳尔',0,'ConditionType : AnsweredBy \n ScriptID : 1600\n AnswerID : 2\n ','\n ActionType : Buy\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克劳尔',0,'ConditionType : AnsweredBy\n ScriptID : 1600\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 : 102\n Period : 300\n ');
###########################################################################################
## 克来夫
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克来夫',0,
'ConditionType : AtFirst',
'\n ActionType : SetPosition\n ZoneID : 2002\n X : 44\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 : 1701\n EndScriptID : 1704\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克来夫',0,
'ConditionType : TalkedBy',
'ActionType : Ask\n ScriptID : 1700\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克来夫',0,
'ConditionType : AnsweredBy \n ScriptID : 1700\n AnswerID : 1\n ',
'\n ActionType : Sell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克来夫',0,
'ConditionType : AnsweredBy \n ScriptID : 1700\n AnswerID : 2\n ',
'\n ActionType : Buy\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克来夫',0,
'ConditionType : AnsweredBy\n ScriptID : 1700\n AnswerID : 3\n ',
'ActionType : QuitDialogue');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克来夫',0,
'ConditionType : Idle',
'\n ActionType : RegenShop\n NPCID : 23\n Period : 300\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','德雷克',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 2003\n X : 31\n Y : 25\n Dir : 1\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','德雷克',0,'ConditionType : EveryTime\n Turn : 689','\n ActionType : RandomSay\n StartScriptID : 1801\n EndScriptID : 1805\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','德雷克',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1800\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','德雷克',0,'ConditionType : AnsweredBy \n ScriptID : 1800\n AnswerID : 1\n ','\n ActionType : Sell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','德雷克',0,'ConditionType : AnsweredBy \n ScriptID : 1800\n AnswerID : 2\n ','\n ActionType : Buy\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','德雷克',0,'ConditionType : AnsweredBy\n ScriptID : 1800\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 : 11\n Period : 300\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','苏坦',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 2003\n X : 21\n Y : 34\n Dir : 1\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','苏坦',0,'ConditionType : EveryTime\n Turn : 724','\n ActionType : RandomSay\n StartScriptID : 1901\n EndScriptID : 1906\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','苏坦',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 1900\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','苏坦',0,'ConditionType : AnsweredBy \n ScriptID : 1900\n AnswerID : 1\n ','\n ActionType : Sell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','苏坦',0,'ConditionType : AnsweredBy \n ScriptID : 1900\n AnswerID : 2\n ','\n ActionType : Buy\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','苏坦',0,'ConditionType : AnsweredBy\n ScriptID : 1900\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 : 12\n Period : 300\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','简森',0,'ConditionType : AtFirst','ActionType : SetPosition\n ZoneID : 2003\n X : 44\n Y : 34\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 : 2001\n EndScriptID : 2006\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','简森',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 2000\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','简森',0,'ConditionType : AnsweredBy \n ScriptID : 2000\n AnswerID : 1\n ','\n ActionType : TeachSkill\n DomainType : GUN\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','简森',0,'ConditionType : AnsweredBy \n ScriptID : 2000\n AnswerID : 2\n ','\n ActionType : Sell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','简森',0,'ConditionType : AnsweredBy \n ScriptID : 2000\n AnswerID : 3\n ','\n ActionType : Buy\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','简森',0,'ConditionType : AnsweredBy\n ScriptID : 2000\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 : 15\n Period : 300\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 13\n X : 155\n Y : 50\n Dir : 1\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : EveryTime\n Turn : 896','\n ActionType : RandomSay\n StartScriptID : 2201\n EndScriptID : 2205\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 2200\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : AnsweredBy \n ScriptID : 2200\n AnswerID : 1\n ','\n ActionType : Sell\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : AnsweredBy \n ScriptID : 2200\n AnswerID : 2\n ','\n ActionType : Buy\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : AnsweredBy \n ScriptID : 2200\n AnswerID : 3\n ','\n ActionType : SearchMotorcycle\n ');
#INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','橇饭靛腐',0,'ConditionType : AnsweredBy \n ScriptID : 2200\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 : 2200\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 : 158\n Period : 300\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AtFirst','\n ActionType : SetPosition\n ZoneID : 2011\n X : 24\n Y : 21\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 : 2301\n EndScriptID : 2306\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 2300\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AnsweredBy\n ScriptID : 2300\n AnswerID : 1\n ','\n ActionType : StashSell\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AnsweredBy\n ScriptID : 2300\n AnswerID : 2\n ','\n ActionType : StashOpen\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AnsweredBy\n ScriptID : 2300\n AnswerID : 3\n ','\n ActionType : Ask\n ScriptID : 2310\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AnsweredBy\n ScriptID : 2300\n AnswerID : 4\n ','\n ActionType : QuitDialogue\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AnsweredBy\n ScriptID : 2310\n AnswerID : 1\n ','\n ActionType : TakeOutGoods\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','克里斯凭',0,'ConditionType : AnsweredBy\n ScriptID : 2310\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 : 2011\n X : 35\n Y : 26\n Dir : 1\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥丽芬',0,'ConditionType : EveryTime\n Turn : 576','\n ActionType : RandomSay\n StartScriptID : 2401\n EndScriptID : 2404\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥丽芬',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 2400\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥丽芬',0,'ConditionType : AnsweredBy \n ScriptID : 2400\n AnswerID : 1\n ','\n ActionType : Repair\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','哥丽芬',0,'ConditionType : AnsweredBy\n ScriptID : 2400\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 : 2011\n X : 42\n Y : 39\n Dir : 1\n ActionType : PrepareShop\n NPCID : 13\n MarketConditionBuy : 25\n MarketConditionSell : 100\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : EveryTime\n Turn : 986','\n ActionType : RandomSay\n StartScriptID : 2501\n EndScriptID : 2507\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : TalkedBy','ActionType : Ask\n ScriptID : 2500\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : AnsweredBy \n ScriptID : 2500\n AnswerID : 1\n ','\n ActionType : Heal\n ');
INSERT INTO Triggers(TriggerType, NPC, QuestID, Conditions, Actions) VALUES ('NPC','辛森',0,'ConditionType : AnsweredBy \n ScriptID : 2500\n AnswerID : 2\n ','\n ActionType : Sell\n ');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -