Need some help

[pretzel666]

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

[karnyge]

I got the same Db and wouldnt mind knowing the answers either. Good luck KC.

[buzz2289]

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

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

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

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

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!.' );

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.....