Example is WarriorNana/MagePeppy!
We take NewbieGift for the Example!
Here it is (Query):
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, 'Hey~man!~I~think~you~want~to~buy~a~Newbie~Gift... ');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000101, 50000102, 0000, 0102, 0, 'Hehe.~Ya~I~want~to~buy~a~Newbie~Gift~for~350k~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, 'Uhmm...~Sorry,~but~you~need~to~have~enough~place~ in~your~Inventory!');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000105, 50000106, 50000108, 1001, 0, 'e_money < 350000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000106, 50000107, 0000, 0101, 0, 'If~you~want~to~buy~it,~you~have~to~give~me~350k~E Ps.~Look!~You~havent!');
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,729012,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 += -350000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000111, 50000112, 0000, 0101, 0, 'Nice~from~you~to~buy~a~Newbie~Gift~from~me!~Credi ts~go~to~netlog_stefan!');
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');
now how to make it:
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~[Item Name]?');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000101, 50000102, 0000, 0102, 0, 'I~would~like~one~[Item Name]~for~[Item Price (In EPs, like 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 < [Item-Price (No "k". make full like 50000)]');
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~[Item Name]. ~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,[Item-ID],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 += -[Item-Price (No "k". make full like 50000)]');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000111, 50000112, 0000, 0101, 0, 'Thank~You~for~buying~[ItemName].~Hope~to~se e~you~again.');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000112, 4000033, 0000, 0102, 0, 'Thank~you~very~much!~Credits~go~to~netlog_stefan! 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');
Remember: NO SPACE!
Take the "~" for space
of course you can change textes without hexediting within the " ' "-things!
ahmed please take it to your guide!
thanks will be nice
CREDITS GO TO ME






