I Have Three Npcs u would Need open ur Navicate then open click on my then click on query
1.Pally Gear Selling Npc
delete from cq_action where id >= 50000200 and id <= 50000219; delete from cq_npc where id = 1552 ; delete from cq_task where id = 50000200; delete from cq_task where id = 50000203; delete from cq_task where id = 50000205; INSERT INTO `cq_npc` VALUES ('1552', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0287', '0468', '50000200', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000200, 50000201, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~Elite~Paladin ~gear?'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000201, 50000202, 0000, 0102, 0, 'I~would~like~one~Elite~Paladin~gear~for~10k~EPs. 50000203'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000202, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000203, 50000205, 50000204, 0508, 0, '15 0 50'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000204, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000205, 50000206, 50000208, 1001, 0, 'e_money < 10000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000206, 50000207, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~Elite~Paladin~ gear.~Come~back~when~you~do.'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000207, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000209, 50000210, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000200,0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000210, 50000211, 0000, 1001, 0, 'e_money += -10000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000211, 50000212, 0000, 0101, 0, 'Thank~You~for~buying~an~Elite~Paladin~gear.~Hope~ to~see~you~again.'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000212, 4000033, 0000, 0102, 0, 'Thanks 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000208, 50000214, 0000, 0501, 113003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000214, 50000215, 0000, 0501, 123003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000215, 50000216, 0000, 0501, 133003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000216, 50000217, 0000, 0501, 143003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000217, 50000218, 0000, 0501, 163003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000218, 50000209, 0000, 0501, 490003, ''); INSERT INTO `cq_task` VALUES ('50000205', '50000205', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('50000200', '50000200', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('50000203', '50000203', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
SpecialExpBalls Seller:
delete from cq_action where id >= 50000000 and id <= 50000012; delete from cq_npc where id = 1550 ; delete from cq_task where id = 50000000; delete from cq_task where id = 50000003; delete from cq_task where id = 50000005; INSERT INTO `cq_npc` VALUES ('1550', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0304', '0450', '50000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000000, 50000001, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~some~Special~ Expball~Packs?'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000001, 50000002, 0000, 0102, 0, 'I~would~like~few~Special~Expballs~for~20k~EPs. 50000003'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000002, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000003, 50000005, 50000004, 0508, 0, '1 0 50'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000004, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000005, 50000006, 50000008, 1001, 0, 'e_money < 20000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000006, 50000007, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~Special~Expbal ls.~Come~back~when~you~do.'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000007, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000008, 50000009, 0000, 0501, 724041, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000009, 50000010, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000000,0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000010, 50000011, 0000, 1001, 0, 'e_money += -20000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000011, 50000012, 0000, 0101, 0, 'Thank~You~for~buying~an~Special~Expball.~Hope~to~ see~you~again.'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000012, 4000033, 0000, 0102, 0, 'Thanks 0'); INSERT INTO `cq_task` VALUES ('50000005', '50000005', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('50000000', '50000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('50000003', '50000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
Treble ExpPot Seller:
delete from cq_action where id >= 50000100 and id <= 50000112;
delete from cq_npc where id = 1551 ;
delete from cq_task where id = 50000100;
delete from cq_task where id = 50000103;
delete from cq_task where id = 50000105;
INSERT INTO `cq_npc` VALUES ('1551', '0', '0', 'X3Peppy', '0002', '15500', '0', '0', '-1', '1000', '0304', '0472', '50000100', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000100, 50000101, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~some~3x~Exp~P otions?');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000101, 50000102, 0000, 0102, 0, 'I~would~like~one~3x~Exp~Potion~for~10k~EPs. 50000103');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000102, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000103, 50000105, 50000104, 0508, 0, '1 0 50');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000104, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000105, 50000106, 50000108, 1001, 0, 'e_money < 10000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000106, 50000107, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~3x~Exp~Potion. ~Come~back~when~you~do.');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000107, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000108, 50000109, 0000, 0501, 810009, '');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000109, 50000110, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000100,0');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000110, 50000111, 0000, 1001, 0, 'e_money += -10000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000111, 50000112, 0000, 0101, 0, 'Thank~You~for~buying~an~3x~Exp~Potion.~Hope~to~se e~you~again.');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000112, 4000033, 0000, 0102, 0, 'Thanks 0');
INSERT INTO `cq_task` VALUES ('50000105', '50000105', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000100', '50000100', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000103', '50000103', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
Credits go to CommandCom






