[HELP]Delete anti macro composing system

[lukmandzul]

how to delete anti macro system composing in my server

[magewarior2]

go to cq_npc and change the starting ID

[lukmandzul]

starting ID?? like this ----> ID=200 change to ID=00

[magewarior2]

yes if id "00" is the composing screen.

also, add the id into cq_task.

(normally it would be already in there)


i guess its an id around the 800000 not sure ...

my tip for you is: try it, and test it.

[lukmandzul]

I'm so afraid if it affect my database .. so can I delete all the script below ..

 Spoiler

delete from cq_action where id >= 4007360 and id <= 4007367;
delete from cq_action where id >= 4007500 and id <= 4007597;

update cq_action set id_nextfail = 4007511 where id = 9508430;

INSERT INTO cq_action
(id, id_next, id_nextfail, type, data, param)
VALUES
(4007360, 0, 0, 122, 0, '4007520 4007530 4007540 4007550 4007560 4007570 4007580 4007590'),
(4007361, 4007362, 0, 101, 0, 'What do you want to do? Compose two pets into one?'),
(4007362, 4007363, 0, 101, 0, 'In case you do not know, the secondary one gets sacrificed.'),
(4007363, 4007364, 0, 101, 0, 'To put this simply, the primary pets gets stonger each time you compose it.'),
(4007364, 4007367, 0, 102, 0, 'I~want~to~Compose~my~Pet. 4007370'),
(4007365, 4007366, 0, 101, 0, ''),
(4007366, 4007367, 0, 102, 0, 'I~want~to~Compose~my~Pet. 4007370'),
(4007367, 4000001, 0, 102, 0, 'No~thanks. 0'),
(4007500, 4007501, 4007508, 1080, 20081, 'isexit'),
(4007501, 4007505, 4007502, 1081, 20081, 'phase >= 2'),
(4007502, 4007503, 4007503, 1081, 20081, 'phase == 1'),
(4007503, 4007504, 0, 1081, 20081, 'phase = 2'),
(4007504, 0, 0, 126, 0, 'You entered the code wrong 2 consecutive times. If you answer wrong 1 more time, YOU CANNOT COMPOSE for 15 minutes.'),
(4007505, 4007506, 0, 1080, 20081, 'delete'),
(4007506, 1000028, 4007507, 1080, 20080, 'isexit'),
(4007507, 1000028, 0, 1080, 20080, 'new'),
(4007508, 4007509, 0, 1080, 20081, 'new'),
(4007509, 4007510, 0, 1081, 20081, 'phase = 1'),
(4007510, 0, 0, 126, 0, 'You entered the code wrong. If you answer wrong 2 more times, YOU CANNOT COMPOSE for 15 minutes.'),
(4007511, 4007512, 4007360, 1080, 20080, 'isexit'),
(4007512, 4007513, 4007514, 1082, 20080, '900'),
(4007513, 4007360, 0, 1080, 20080, 'delete'),
(4007514, 4007515, 0, 130, 0, 'Wait the full 15 minutes to try again'),
(4007515, 4007516, 0, 130, 0, ''),
(4007516, 4007517, 0, 130, 0, 'Attention: You entered the Anti-Macro code wrong 3 times. You were punished. Now you must wait 15 minutes to compose again.'),
(4007517, 4007518, 0, 130, 0, ''),
(4007518, 4007519, 0, 130, 0, 'Anti-Macro System for Eudemons-online'),
(4007519, 0, 0, 131, 0, ''),
(4007520, 4007521, 0, 101, 0, 'Anti-Macro System!'),
(4007521, 4007522, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007522, 4007523, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007523, 4000001, 0, 105, 0, '2 4007525 Type~the~Digit:~11'),
(4007524, 0, 0, 0, 0, ''),
(4007525, 4007526, 4007500, 2003, 0, '%accept0 == 11'),
(4007526, 4007527, 4007361, 1080, 20081, 'isexit'),
(4007527, 4007361, 0, 1080, 20081, 'delete'),
(4007528, 0, 0, 0, 0, ''),
(4007529, 0, 0, 0, 0, ''),
(4007530, 4007531, 0, 101, 0, 'Anti-Macro System!'),
(4007531, 4007532, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007532, 4007533, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007533, 4000001, 0, 105, 0, '2 4007535 Type~the~Digit:~22'),
(4007534, 0, 0, 0, 0, ''),
(4007535, 4007526, 4007500, 2003, 0, '%accept0 == 22'),
(4007536, 0, 0, 0, 0, ''),
(4007540, 4007541, 0, 101, 0, 'Anti-Macro System!'),
(4007541, 4007542, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007542, 4007543, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007543, 4000001, 0, 105, 0, '2 4007545 Type~the~Digit:~33'),
(4007544, 0, 0, 0, 0, ''),
(4007545, 4007526, 4007500, 2003, 0, '%accept0 == 33'),
(4007546, 0, 0, 0, 0, ''),
(4007550, 4007551, 0, 101, 0, 'Anti-Macro System!'),
(4007551, 4007552, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007552, 4007553, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007553, 4000001, 0, 105, 0, '2 4007555 Type~the~Digit:~44'),
(4007554, 0, 0, 0, 0, ''),
(4007555, 4007526, 4007500, 2003, 0, '%accept0 == 44'),
(4007556, 0, 0, 0, 0, ''),
(4007560, 4007561, 0, 101, 0, 'Anti-Macro System!'),
(4007561, 4007562, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007562, 4007563, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007563, 4000001, 0, 105, 0, '2 4007565 Type~the~Digit:~55'),
(4007564, 0, 0, 0, 0, ''),
(4007565, 4007526, 4007500, 2003, 0, '%accept0 == 55'),
(4007566, 0, 0, 0, 0, ''),
(4007570, 4007571, 0, 101, 0, 'Anti-Macro System!'),
(4007571, 4007572, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007572, 4007573, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007573, 4000001, 0, 105, 0, '2 4007575 Type~the~Digit:~66'),
(4007574, 0, 0, 0, 0, ''),
(4007575, 4007526, 4007500, 2003, 0, '%accept0 == 66'),
(4007576, 0, 0, 0, 0, ''),
(4007580, 4007581, 0, 101, 0, 'Anti-Macro System!'),
(4007581, 4007582, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007582, 4007583, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007583, 4000001, 0, 105, 0, '2 4007585 Type~the~Digit:~77'),
(4007584, 0, 0, 0, 0, ''),
(4007585, 4007526, 4007500, 2003, 0, '%accept0 == 77'),
(4007586, 0, 0, 0, 0, ''),
(4007590, 4007591, 0, 101, 0, 'Anti-Macro System!'),
(4007591, 4007592, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007592, 4007593, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007593, 4000001, 0, 105, 0, '2 4007595 Type~the~Digit:~88'),
(4007594, 0, 0, 0, 0, ''),
(4007595, 4007526, 4007500, 2003, 0, '%accept0 == 88'),
(4007596, 0, 0, 0, 0, ''),
(4007597, 0, 0, 0, 0, '');

INSERT INTO cq_task
(id, id_next, id_nextfail, itemname1, itemname2, money, profession, sex, min_pk, max_pk, team, metempsychosis, query, marriage, client_active)
VALUES
(4007525, 4007525, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007535, 4007535, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007545, 4007545, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007555, 4007555, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007565, 4007565, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007575, 4007575, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007585, 4007585, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007595, 4007595, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0);

[magewarior2]

Originally Posted by lukmandzul

I'm so afraid if it affect my database .. so can I delete all the script below ..

just change the "next_id" so you do not destroy a thing ..

[lukmandzul]

Originally Posted by magewarior2

just change the "next_id" so you do not destroy a thing ..

cq_action or cq_task, i'm really confused about it

[Soul[PM]]

delete from cq_action where id >= 4007360 and id <= 4007367;
delete from cq_action where id >= 4007500 and id <= 4007597;
if you want delete full system use this

but if you want change it to other thing you must try it and test it as magewarior2 did say .....and before making any thing make sure to make backup to your DB & Client

[lukmandzul]

now i'm find a thread like me -->

thx to all epvper member for reply my thread..