[Release]Combating Macro in the Compose

sandolkakos · 01/17/2010, 08:59

Hi guys, i am here to post the script that i made to Combat the Players that are using MACRO in the Compose.
Look the Image in Attachments.

Tha Language is in Portuguese - Brazil.
Use Google Translator to modify to your Language.
I hope that this can help all server owners.

Caution with the Delete Commands, that have in this script.

PLEASE MODERATOR, can make this Thread one Sticky Thread?

CQ_ACTION:

Code:

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");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007361, 4007362, 0, 101, 0, "Mas o que e isto? Voce quer combinar seus dois Pets em um?");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007362, 4007363, 0, 101, 0, "Nao sei se voce sabe, mas o secundario sera sacrificado.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007363, 4007364, 0, 101, 0, "Porem com isto, o primario ficara mais forte a cada vez que voce fizer composicao nele.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007364, 4007367, 0, 102, 0, "Eu~quero~fazer~Composicao~em~meu~Pet. 4007370");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007365, 4007366, 0, 101, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007366, 4007367, 0, 102, 0, "Eu~quero~fazer~Composicao~em~meu~Pet. 4007370");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007367, 4000001, 0, 102, 0, "Agora~nao~obrigado. 0");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007500, 4007501, 4007508, 1080, 20081, "isexit");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007501, 4007505, 4007502, 1081, 20081, "phase >= 2");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007502, 4007503, 4007503, 1081, 20081, "phase == 1");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007503, 4007504, 0, 1081, 20081, "phase = 2");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007504, 0, 0, 126, 0, "Voce ja errou o Codigo por 2 vezes consecutivas. Se voce errar mais 1 vez, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007505, 4007506, 0, 1080, 20081, "delete");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007506, 1000028, 4007507, 1080, 20080, "isexit");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007507, 1000028, 0, 1080, 20080, "new");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007508, 4007509, 0, 1080, 20081, "new");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007509, 4007510, 0, 1081, 20081, "phase = 1");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007510, 0, 0, 126, 0, "Voce errou o Codigo. Se voce errar mais 2 vezes, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007511, 4007512, 4007360, 1080, 20080, "isexit");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007512, 4007513, 4007514, 1082, 20080, "900");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007513, 4007360, 0, 1080, 20080, "delete");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007514, 4007515, 0, 130, 0, "Aguarde completar os 15 Minutos para tentar Novamente.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007515, 4007516, 0, 130, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007516, 4007517, 0, 130, 0, "Atencao: Voce ERROU o codigo de Protecao contra o uso de MACRO por 3 vezes. E foi Punido. Agora deve esperar 15 minutos, para fazer Composicao Novamente.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007517, 4007518, 0, 130, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007518, 4007519, 0, 130, 0, "Sistema desenvolvido pela Universal Games Online. www.universalgamesonline.com.br");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007519, 0, 0, 131, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007520, 4007521, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007521, 4007522, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007522, 4007523, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007523, 4000001, 0, 105, 0, "2 4007525 Digite~o~Numero:~11");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007524, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007525, 4007526, 4007500, 2003, 0, "%accept0 == 11");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007526, 4007527, 4007361, 1080, 20081, "isexit");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007527, 4007361, 0, 1080, 20081, "delete");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007528, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007529, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007530, 4007531, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007531, 4007532, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007532, 4007533, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007533, 4000001, 0, 105, 0, "2 4007535 Digite~o~Numero:~22");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007534, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007535, 4007526, 4007500, 2003, 0, "%accept0 == 22");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007536, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007540, 4007541, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007541, 4007542, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007542, 4007543, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007543, 4000001, 0, 105, 0, "2 4007545 Digite~o~Numero:~33");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007544, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007545, 4007526, 4007500, 2003, 0, "%accept0 == 33");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007546, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007550, 4007551, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007551, 4007552, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007552, 4007553, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007553, 4000001, 0, 105, 0, "2 4007555 Digite~o~Numero:~44");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007554, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007555, 4007526, 4007500, 2003, 0, "%accept0 == 44");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007556, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007560, 4007561, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007561, 4007562, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007562, 4007563, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007563, 4000001, 0, 105, 0, "2 4007565 Digite~o~Numero:~55");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007564, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007565, 4007526, 4007500, 2003, 0, "%accept0 == 55");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007566, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007570, 4007571, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007571, 4007572, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007572, 4007573, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007573, 4000001, 0, 105, 0, "2 4007575 Digite~o~Numero:~66");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007574, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007575, 4007526, 4007500, 2003, 0, "%accept0 == 66");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007576, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007580, 4007581, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007581, 4007582, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007582, 4007583, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007583, 4000001, 0, 105, 0, "2 4007585 Digite~o~Numero:~77");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007584, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007585, 4007526, 4007500, 2003, 0, "%accept0 == 77");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007586, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007590, 4007591, 0, 101, 0, "Sistema Anti-Macro !");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007591, 4007592, 0, 101, 0, "Isto foi criado para Combater o uso de MACRO.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007592, 4007593, 0, 101, 0, "Se errar por 3 vezes consecutivas, NAO PODERA REBORNAR por 15 Minutos.");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007593, 4000001, 0, 105, 0, "2 4007595 Digite~o~Numero:~88");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007594, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007595, 4007526, 4007500, 2003, 0, "%accept0 == 88");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007596, 0, 0, 0, 0, "");

INSERT INTO cq_action
  (id, id_next, id_nextfail, type, data, param)
VALUES
  (4007597, 0, 0, 0, 0, "");

CQ_TASK

Quote:

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);

mama020153 · 01/17/2010, 09:03

Good Job.

rexes13 · 01/17/2010, 09:28

Nice job dude...keep up...

zukoo · 01/17/2010, 11:28

aahahahahha
I had done this on my server, just when starting to use the macro eudemons!
_______________

just put random questions with answers, it is much more simple and not a pain for the rebirth of my players ...
imagine that it is annoying for a player to play nice to type it every time it is reborn?
what counsel is asking questions with random answers.
At least on my server no one ever complained to the system, ant-composing

rexes13 · 01/17/2010, 13:00

Quote:

Originally Posted by zukoo

aahahahahha
I had done this on my server, just when starting to use the macro eudemons!
_______________

just put random questions with answers, it is much more simple and not a pain for the rebirth of my players ...
imagine that it is annoying for a player to play nice to type it every time it is reborn?
what counsel is asking questions with random answers.
At least on my server no one ever complained to the system, ant-composing

I think that there is no need to laugh at it..just say a thanks or dont tease the releaser...

zukoo · 01/17/2010, 14:42

Quote:

Originally Posted by rexes13

I think that there is no need to laugh at it..just say a thanks or dont tease the releaser...

I actually gave a opniao so, it would take less time and patience of the players putting random questions.

DEADP00L · 01/17/2010, 21:38

Zukoo if you cant say something nice..dont say anything. There is no need to "brag" about what you have and dont have. THe poster was nice enough to release it for the general people. He is contributing to the community. Is your criticism doing the same? I think not

King_Arthur · 01/18/2010, 03:42

I condensed the code into 4 queries instead of who knows how many. I then ran the code through systran for English and manually translated the rest to be as close to the original intended verbiage as possible. I haven't actually tested the code so take care if trying to use this as systran can mess things up time to time.

Code:

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, 'System developed for the Universal Games Online. www.universalgamesonline.com.br'),
(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, '');

DEADP00L · 01/18/2010, 05:25

someone test this to make sure it works and i will be more than happy to sticky it. Better safe than sorry

zukoo · 01/18/2010, 06:11

see, I'm not criticizing I would launch my query, I appreciate very sandolkakos, love it, it helps a lot to me and the staff of foum this query it is very useful, I thought it was funny because I was already halfway my query i came here and saw ... but nothing personal.
And now I do not but I put my ja he put one that has the same goal.

Understand? I do not want to generate intrigue or anything so I came to tell my bad English.

Sandolkakos Thanks, and sorry for seeming inconvenience.

Knight^Hawk · 01/18/2010, 09:25

missed some code i think cuz it comes up with the type 2 numbers window n then it closes when u type em in

Maribela · 01/18/2010, 11:32

after the Locating the npc asks the codes, then do not come out of this, repeat the action does not work leaving the npc

brasil
apos a intalaçao o npc pede os codigos,depois nao sai disso,repete a açao nao deixando o npc trabalhar

sandolkakos · 01/18/2010, 23:37

Quote:

Originally Posted by Maribela

after the Locating the npc asks the codes, then do not come out of this, repeat the action does not work leaving the npc

brasil
apos a intalaçao o npc pede os codigos,depois nao sai disso,repete a açao nao deixando o npc trabalhar

sorry, i have forgot the cq_task

now in First Post have the Code to cq_task, ok

Maribela · 01/19/2010, 10:58

sandolkakos

see it, gave me this error
veja isso,deu este erro para mim

King_Arthur · 01/19/2010, 15:31

Quote:

Originally Posted by Maribela

sandolkakos

see it, gave me this error
veja isso,deu este erro para mim

Run this first

Code:

delete from cq_task where id >= 4007525 and id <= 4007595;