Need some help

06/08/2012 21:19 pretzel666#1
Ok so i have the mortal/chaos client and DB , the summon 4 quest it has the map and stuff but not the npc to exchange the crystals with , also i wanna add dif prizes can someone explain to me how to add the npc? and also how to add more prizes too it ? :) thanks
06/09/2012 15:05 karnyge#2
I got the same Db and wouldnt mind knowing the answers either. Good luck KC.
06/10/2012 06:32 buzz2289#3
Quote:
delete from cq_npc where id = 68550000;

INSERT INTO `cq_npc` VALUES ('68550000', '0', '0', '4Summons', '0001', '685500007', '0', '0', '-1', '1000', '0153', '0400', '685510000', '0000','0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
Here is my NPC

Quote:
INSERT INTO `cq_action` VALUES ('685510000', '685510001', '0000', '0101', '0', 'well~hello~there~%user_name,~You~need~5000~Summon ~Shards');
INSERT INTO `cq_action` VALUES ('685510001', '685510002', '0000', '0101', '0', 'to~create~my~wonderful~Stone~.');
INSERT INTO `cq_action` VALUES ('685510002', '685510003', '0000', '0101', '0', 'you~can~find~Summon~Shards~in~IcyLand.');
INSERT INTO `cq_action` VALUES ('685510003', '685510004', '0000', '0102', '0', 'Create~My~Wonder. 685510005');
INSERT INTO `cq_action` VALUES ('685510004', '4000030', '0000', '0102', '0', 'Still~not~enough. 0');
INSERT INTO `cq_action` VALUES ('685510005', '685510006', '685510010', '0502', '1023810', '2000');
INSERT INTO `cq_action` VALUES ('685510006', '685510008', '685510007', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('685510007', '0000', '0000', '0126', '0', 'Please~Leave~1~slot');
INSERT INTO `cq_action` VALUES ('685510008', '685510009', '0000', '0501', '721120', '1 1');
INSERT INTO `cq_action` VALUES ('685510009', '0000', '0000', '0126', '0', 'With~your~Endeavours~you~have~been~given~4~Summon ing~by~the~gods');
INSERT INTO `cq_action` VALUES ('685510010', '0000', '0000', '0126', '0', 'Your~to~low~on~Summon~Shards');
My CQ Action


Quote:
delete from cq_task where id >= 685510000 and id <= 685510005;

INSERT INTO `cq_task` VALUES ('685510000', '685510000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('685510005', '685510005', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
CQ Task

Quote:
UPDATE cq_dropitemrule SET item11= '1023810' where id >= 121 and id <= 140;
UPDATE cq_dropitemrule SET item12= '1023810' where id >= 121 and id <= 140;
UPDATE cq_dropitemrule SET item13= '1023810' where id >= 121 and id <= 140;
UPDATE cq_dropitemrule SET item14= '1023810' where id >= 121 and id <= 140;
CQ DropItem


Quote:
INSERT INTO cq_action VALUES (4460523, 4460524, 4460527, 1001, 0, 'maxeudemon < 4');
INSERT INTO cq_action VALUES (4460524, 4460525, 0, 502, 721550, '');
INSERT INTO cq_action VALUES (4460525, 4460526, 0, 1001, 0, 'maxeudemon = 4');
INSERT INTO cq_action VALUES (4460526, 4460528, 0, 1027, 0, 'self skill156');
INSERT INTO cq_action VALUES (4460527, 0, 0, 126, 0, 'You~already~have~4~Summon.');
INSERT INTO cq_action VALUES (4460528, 4460531, 4460531, 1080, 1021, 'new');
INSERT INTO cq_action VALUES (4460531, 4460532, 4460532, 1081, 1021, 'phase = 17');
INSERT INTO cq_action Values (4460532, 0, 0, 1010, 2011, 'Congratulation!you~now~Able~to~summon~4~demons!.' );
Quote:
delete from cq_itemtype where id >= 1023810 and id <= 1023820;
INSERT INTO `cq_itemtype` VALUES ('1023820', 'SummoningShard', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');



You may need to edit some things to work with your current DB or just use mine.....