缱绻深情.sql

关于如何制作*.ini文件以及游戏地图中任务制定以及地图编制的相关教程

#缱绻深情(部分情节)

#delete from cq_npc where id>=3726 AND id<=3731;
#delete from cq_itemtype where id>=722050 AND id<=722054;
#delete from cq_monstertype where id>=4003 AND id<=4007;
#delete from cq_action where id>=7573700 AND id<=7574500;
#delete from cq_task where id>=7573700 AND id<=7574500;
#delete from cq_generator where id>=1200 AND id<=1209;

INSERT INTO cq_npc VALUES
 (3726,0,0,'紫璃夫人',0002,7871,-1,1002,435,351,7573700,0000,0000,0000,0000,0000,0000,0000,0,0,0,0,'无',0000,00,00,0000,00,NULL);

INSERT INTO cq_itemtype VALUES
 (722053,'慰灵符',0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,00,00,0,0),
 (722054,'夜叉心脏',0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,00,00,0,0);


INSERT INTO cq_task VALUES
 (7573700,7573700,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573730,7573730,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573740,7573740,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573756,7573756,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573760,7573760,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7574150,7574150,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573780,7573780,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573790,7573790,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573800,7573800,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0),
 (7573805,7573805,0000,NULL,NULL,0,0,0,0,1000,0000,0000,0,-1,0);

INSERT INTO cq_action VALUES 
 (7573700,7573701,7573710,1001,0,'level < 70'),
 (7573701,7573702,0,101,0,'    神州战事将起，妾身的夫君身属羽林军，为国为民自然义不'),
 (7573702,7573703,0,101,0,'容辞。可是妾身却十分担心他的安危，听说城外有只鬼灵能断人'),
 (7573703,7573704,0,101,0,'祸福，禳灾解难，也不知是真是假。阁下尚未到达70级，恐怕是'),
 (7573704,7573705,0,101,0,'帮不了我的忙！'),
 (7573705,610113,0,102,0,'吉人自有天相 0'),

 (7573710,7573712,7573711,1073,0,'stc(18,2) == 2'),
 (7573711,7573750,7573716,503,722054,''),
 (7573712,7573713,7573745,1073,0,'stc(18,1) >= 2'),
 (7573713,7573714,7573745,1073,0,'stc(18,1) >= 6'),
 (7573714,7573725,7573715,1073,0,'stc(18,1) == 6'),
 (7573715,7573720,0,1073,0,'stc(18,1) >= 7'),

 (7573716,7573717,7573770,1073,0,'stc(18,2) == 1'),
 (7573717,7573725,7573766,1073,0,'stc(18,1) == 6'),


 (7573720,7573721,0,101,0,'    啊，原来是大侠到此，此前多谢您出手相助，才能保得我夫'),
 (7573721,7573722,0,101,0,'君的平安。此后我一直缠绵病榻，实在是无力亲自拜访大侠，以'),
 (7573722,7573723,0,101,0,'表谢意。如今偶然相遇，不如请到寒舍一叙。'),
 (7573723,610113,0,102,0,'我身有要事，多有不便。 0'),


 (7573725,7573726,0,101,0,'    大侠这一趟可顺利吗？鬼灵可曾说起我夫君的下落？但愿他'),
 (7573726,7573727,0,101,0,'平安无事，在军中没有受多少辛苦。战场凶险，一想起来我就老'),
 (7573727,7573728,0,101,0,'是心神不定。'),
 (7573728,610113,0,102,0,'安校尉已经平安 7573730'),

 (7573730,7573731,0,101,0,'    果真如此？果然是菩萨保佑，也要谢谢鬼灵。下一次我必定'),
 (7573731,7573732,0,101,0,'携带水果香烛，亲身前往城外拜祭它。还有这位大侠，为了妾身'),
 (7573732,7573733,0,101,0,'的夫君，不辞鞍马劳顿，这儿有小小谢礼8万银两，不成敬意。'),
 (7573733,610113,0,102,0,'夫人客气了 7573740'),

 (7573740,7573741,0,1001,0,'money += 80000'),
 (7573741,7573742,0,1001,0,'exp += 1500000'),
 (7573742,7573743,0,1010,2005,'恭喜你获得8万的钱和150万的经验！'),
 (7573743,7573744,0,1074,0,'stc(18,1) += 1 1'),
 (7573744,0,0,1027,0,'self zf2-e026'),


 (7573745,7573746,0,101,0,'    大侠可曾向那鬼灵问得我夫君的消息？他随军远征边关，征'),
 (7573746,7573747,0,101,0,'剿妖魔，这修罗沙场上，万一有个不测可如何是好，真叫妾身忐'),
 (7573747,7573748,0,101,0,'忑不安。'),
 (7573748,610113,0,102,0,'还不曾问得 0'),


 (7573750,7573751,7573766,503,722054,''),
 (7573751,7573752,0,101,0,'    大侠既然已经平安归来，那一定是带回我夫君的消息了。他'),
 (7573752,7573753,0,101,0,'此时身在何地，一切可安好？这么长时间也不托人捎信回来，难'),
 (7573753,7573754,0,101,0,'道有什么难言的隐情？'),
 (7573754,7573755,0,102,0,'我给你带回了解药 7573756'),
 (7573755,610113,0,102,0,'我什么都不知道。 0'),

 (7573756,7573757,0,101,0,'    多谢大侠费心了，这些是我的小小心意2万的银两，大侠还请'),
 (7573757,7573758,0,101,0,'收下。多得大侠相助，妾身还能以此病体等夫君归来。'),
 (7573758,610113,0,102,0,'万勿如此客气 7573760'),

 (7573760,7573761,0,502,722054,''),
 (7573761,7573762,0,1001,0,'money += 20000'),
 (7573762,7573763,0,1001,0,'exp += 500000'),
 (7573763,7573764,0,1010,2005,'恭喜你获得金钱2万、经验50万'),
 (7573764,7573765,0,1074,0,'stc(18,2) += 1 1'),
 (7573765,0,0,1027,0,'self zf2-e026'),


 (7573766,7573767,0,101,0,'    鬼灵就在城外坐标669，422处，魔界夜叉用自身瘴气锁住了'),
 (7573767,7573768,0,101,0,'鬼灵的气脉，若不除去他们，鬼灵绝无法开口。劳烦大侠费心，'),
 (7573768,7573769,0,101,0,'也请将魔界夜叉的心脏带回一个，供我解毒之用。'),
 (7573769,610113,0,102,0,'此事包在我身上 7574150'),

 (7574150,7574151,0,1073,0,'stc(18,1) == 1'),
 (7574151,0,7574152,503,722053,''),
 (7574152,7574153,0,501,722053,''),
 (7574153,0,0,1010,2005,'得到慰灵符。'),


 (7573770,7573771,0,101,0,'    这位侠客请留步，看您英气勃勃，一定身负绝世修为，若能'),
 (7573771,7573772,0,101,0,'得大侠相助，妾身心愿必能达成，纵是身在九泉之下也将不胜感'),
 (7573772,7573773,0,101,0,'激。'),
 (7573773,7573774,0,102,0,'在下义不容辞 7573780'),
 (7573774,610113,0,102,0,'你认错了，我可不是大侠 0'),

 (7573780,7573781,0,101,0,'    妾身夫君名讳安期生，是羽林军的校尉，数月前随军征讨妖'),
 (7573781,7573782,0,101,0,'魔，自此沓无音信。妾身十分担心，听说城外有一只鬼灵，只要'),
 (7573782,7573783,0,101,0,'供上慰灵玉符，它就能开口断人吉凶生死，昨日我便去见它。'),
 (7573783,7573784,0,102,0,'那又如何？ 7573790'),
 (7573784,610113,0,102,0,'关我何事！ 0'),

 (7573790,7573791,0,101,0,'    没想到魔界夜叉因为那只鬼灵泄露天机，已将它团团守住，'),
 (7573791,7573792,0,101,0,'妾身一时不备也被夜叉的毒爪抓伤，治伤的药师说，只有魔界夜'),
 (7573792,7573793,0,101,0,'叉的心脏才能解毒，而妾身也想请大侠前去问卜鬼灵。'),
 (7573793,7573794,0,102,0,'我会帮你达成心愿 7573800'),
 (7573794,610113,0,102,0,'我身有要事，无法离开 0'),

 (7573800,7573801,0,101,0,'    鬼灵就在城外坐标699，422处，魔界夜叉用自身瘴气锁住了'),
 (7573801,7573802,0,101,0,'鬼灵的气脉，若不除去他们，鬼灵绝无法开口。劳烦大侠费心，'),
 (7573802,7573803,0,101,0,'也请将魔界夜叉的心脏带回一个，供我解毒之用。'),
 (7573803,610113,0,102,0,'此事包在我身上 7573805'),

 (7573805,7573806,7574140,508,1,''),
 (7573806,7573807,0,501,722053,''),
 (7573807,7573808,0,1010,2005,'得到慰灵符。'),
 (7573808,7573809,0,1074,0,'stc(18,1) += 1 1'),
 (7573809,0,0,1074,0,'stc(18,2) += 1 1'),
 (7574140,7574141,0,101,0,'    你先整理完包裹再来找我吧'),
 (7574141,610113,0,102,0,'谢谢提醒 0');