New script to combat the use of Macro

08/29/2012 21:15 zukoo#1
Hello Guys okay? I created a system to combat the use of the macro.

I was studying a way to combat the macro when the player is using.

I always knew that when you're reborn and clicks on an npc, the composition window closes and opens the discussion of the NPC.

So I had a simple idea, for while the player is rebornando every 3 minutes the anti macro open, asking him to enter the number that requires dialogue, if it miss the dialogue will close.

For this you need to look for id = 2000004
he is one of the ids that automatically generates the game.

I will not put here because the script use the id 2000004 for various events modify the missions created by me, with this you'll need to make some changes:

What will you do?

1. Open your navicat, go to the table cq_action
2. Create a new id, the new id must be: 313552
3. Look for id = 2000004 on your table cq_action
4. Copy the id_next, id_nexfail, type, date and stop all this and paste in the id 313552

His edition will look like this:
313552 id_next id_nexfail type data param

Now look again cq_action vai in the id_next = 4007370 & paste this id: 313578

Okay, now you're doing it will copy this code below:

Code:
313553	313558	0	122	0	313552 313552 313552 313552 313552 313552 313552 313552
313554	313556	313555	1080	47301	isexit
313555	313556	0	1080	47301	new
313556	313557	0	1082	47301	120
313557	0	313559	1082	47301	180
313558	0	313554	2012	0	1000 313554 -1
313559	313560	0	101	0	This is an Anti-Macro, hinders the use of MACRO. You want to continue to reborn?
313560	313561	0	102	0	Yes. 313563
313561	104000	0	102	0	No~thank~you. 0
313562	0	0	122	0	313563
313563	313564	0	101	0	System Anti-Macro !
313564	313566	0	101	0	This was created to combat the use of MACRO.
313566	0	0	122	0	313567 313568 313569 313567 313568 313569 313567 313568
313567	104000	0	105	0	3 313570 Enter~Number:~111
313568	104000	0	105	0	3 313571 Enter~Number:~258
313569	104000	0	105	0	3 313572 Enter~Number:~399
313570	313576	313573	2003	0	%accept0 == 111
313571	313576	313573	2003	0	%accept0 == 258
313572	313576	313573	2003	0	%accept0 == 399
313573	313574	0	101	0	You made ​​a mistake when typing the access code!
313574	104000	0	102	0	I'll~talk~to~ADERES. 0
313575	0	0	0	0	0
313576	4007370	4007370	1081	47301	begintime reset
313577	0	0	0	0	0
313578	313576	313579	1080	47301	isexit
313579	313576	313576	1080	47301	new


Now copy the code below and paste it into your cq_task:

Code:
313554 313554
313555 313555
313556 313556
313557 313557
313558 313558
313559 313559
313560 313560
313561 313561
313562 313562
313563 313563
313564 313564
313565 313565
313566 313566
313567 313567
313568 313568
313569 313569
313570 313570
313571 313571
313572 313572
313573 313573
313574 313574
313575 313575
313576 313576
313577 313577
313578 313578
313579 313579
313580 313580
313581 313581
313582 313582
313583 313583
313584 313584
313585 313585
313586 313586
313587 313587
313588 313588
313589 313589
313590 313590
313591 313591
313592 313592

Now give maintenance on your server.


Okay, your anti-macro already working.

Thank you for your attention, I am open for questions and suggestions.

Remember to thank for encouraging me to bring news.
08/29/2012 22:32 hani2012#2
wow this is a great release thx alot zukoo
08/29/2012 23:27 no_1#3
not very usefull as this only pops up the window if your lucky.

people stil getting auto ep and exp and what so ever cause this doesn't stop anything just pops up a window.

Stil nice code can be usefull
08/30/2012 00:12 zukoo#4
Not by chance does not appear, it appears every 3 minutes, and if someone is using macro to compose, automatically closes the composition window.
08/30/2012 03:00 Gekru#5
This is only helpful if they keep clicking on Aderes to compose. They can still use the Crystal in the eud bag as long as they have the stuff needed.
08/30/2012 14:18 PraDevil[ELITE]#6
there's no way to stop this..the only way is just make special expball as a limited item, only can used it X-TIMES per day or make a way to your player to get this thing(leveling), the most important thing is do not sell this thing in shoppingmall or npc, lastly sorry if im wrong :)
08/31/2012 02:05 zukoo#7
A good way to block the use of the macro, is when the player clicks the "x" when the pet is reborn, the composition is closed, instead of re-composition
09/05/2012 01:29 PowerChaos#8
Nice release
but it dit existed already

here is the topic
[Only registered and activated users can see links. Click Here To Register...]


and here is the txt file

it was made for revo Database , but the system stays the same

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

update cq_action set id_nextfail = 4007511 where id = 9508430;


INSERT INTO cq_action 
(id, id_next, id_nextfail, type, data, param)
VALUES
(4007370, 0000, 0000, 1046, 37, ''),
(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);



update cq_npc set task0 = 9539250 where lookface = 12040;
Greetings From PowerChaos
09/05/2012 04:08 zukoo#9
You did not read my script.

It is different from this, that you showed.