Register for your free account! | Forgot your password?

You last visited: Today at 04:14

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release]Anti-Compose Bot NPC

Discussion on [Release]Anti-Compose Bot NPC within the EO PServer Guides & Releases forum part of the EO PServer Hosting category.

Reply
 
Old   #1
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
[Release]Anti-Compose Bot NPC

Intro
I said I would do this release a few days ago but kept putting it off so here it is.

Release Function:
This release will make the main compose NPC of EO (Market-Aderes) randomly decide to move to locations near him. This should prevent the Auto-Compose Bot that has made some things unfair for other players.

Future Updates:
I will be working on an app that you will assign NPC ID values to which in turn it will assign the random move script to this NPC. There will also be a maintenance app that will change the random locations of the NPC spawn to ones within the NPC location.

Rar File Contents:
RandomMoveComposer(App):
Update Application that will run an SQL script on your database
MySQL Devart Library Extensions

200(EudComposer-Aderes)(Spreadsheet):
Spreadsheet for the EudComposer containing cq_action/task/npc and locations

ReadMe:
I have included a console app that will run the SQL script for a local server you will need the following:
Code:
[B][U]Account[/U][/B]
Login: test
Password: test
Host: 127.0.0.1

[B][U]Database[/U][/B]
Name: my

[B][U]Tables[/U][/B]
name:
cq_action
cq_task
cq_npc
I have also included an editble version of this NPC in a spreadsheet most of it's just sum values so all you have to do is change 1 ID and it will change the rest. (highlighted by the gray box).
There are a list of 12 different locations the NPC will randomly move to from time to time you can add more or edit these how ever you wish.

You can turn the spreadsheet into a working SQL by replacing the following (using ctrl+h)
Quote:
[TAB]@' -> '
[TAB]@[TAB] -> ,'
[TAB]$' -> '
[TAB]$[TAB] -> [SPACE]
[TAB]* -> ),
*[TAB] -> (
[TAB] -> ,
Make sure to do it in that order or you can make some problems for yourself.
This is pretty much how I code everything makes things much more faster and easier to edit when you come back to it.

If need be I can post a full guide on the concepts of using Excel to code your database edits for EO.

SQL Script
Code:
delete from cq_action
where
id >= 4007360 and id <= 4007382;

delete from cq_task
where
id >= 4007360 and id <= 4007382;

delete from cq_npc
where
id = 200;

insert into cq_action
values
(4007360,4007361,0,101,0,'Hi %user_name what would you like to do?'),
(4007361,4007362,0,102,0,'[Compose~Pet] 4007364'),
(4007362,4007363,0,104,0,'0 0 0'),
(4007363,0,0,120,0,''),
(4007364,0,0,1046,37,''),
(4007365,4007366,4007370,121,0,'1 3'),
(4007366,0,0,122,0,'4007367 4007368 4007369'),
(4007367,0,0,122,0,'4007370 4007371 4007372 4007373'),
(4007368,0,0,122,0,'4007374 4007375 4007376 4007377'),
(4007369,0,0,122,0,'4007378 4007379 4007380 4007381'),
(4007370,4007360,4007365,121,0,'2 3'),
(4007371,4007360,0,301,200,'1000 315 448'),
(4007372,4007360,0,301,200,'1000 316 443'),
(4007373,4007360,0,301,200,'1000 312 440'),
(4007374,4007360,0,301,200,'1000 320 444'),
(4007375,4007360,0,301,200,'1000 323 450'),
(4007376,4007360,0,301,200,'1000 319 454'),
(4007377,4007360,0,301,200,'1000 313 452'),
(4007378,4007360,0,301,200,'1000 317 455'),
(4007379,4007360,0,301,200,'1000 320 453'),
(4007380,4007360,0,301,200,'1000 309 453'),
(4007381,4007360,0,301,200,'1000 312 456'),
(4007382,4007360,0,301,200,'1000 316 455');

insert into cq_task
(id,id_next)
values
(4007365,4007365),
(4007367,4007367),
(4007370,4007370),
(4007374,4007374),
(4007378,4007378),
(4007368,4007368),
(4007371,4007371),
(4007375,4007375),
(4007379,4007379),
(4007369,4007369),
(4007372,4007372),
(4007376,4007376),
(4007380,4007380),
(4007373,4007373),
(4007377,4007377),
(4007381,4007381),
(4007364,4007364);

insert into cq_npc
(id,name,type,lookface,mapid,cellx,celly,task0,data2,data3,sort,size_front,size_back,size_left,size_right)
values
(200,'Composer',29,12040,1000,315,448,4007365,5,5,1,3,3,3,3);
Attached Files
File Type: rar RandomMoveComposer(App).rar (167.1 KB, 435 views)
File Type: rar 200(EudComposer-Aderes)(SpreaSheet).rar (11.0 KB, 283 views)
funhacker is offline  
Thanks
18 Users
Old 09/19/2009, 04:16   #2
 
elite*gold: 0
Join Date: Sep 2008
Posts: 979
Received Thanks: 645
I wonder how this works, however, one thing is, writing tracers for the NPC by fetching it's X and Y coordinates won't be hard, it works for now, kind of annoying for any composer.
Necron33 is offline  
Old 09/19/2009, 12:07   #3
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
Quote:
Originally Posted by Necron33 View Post
I wonder how this works, however, one thing is, writing tracers for the NPC by fetching it's X and Y coordinates won't be hard, it works for now, kind of annoying for any composer.
This is just a basic version of how you can do this. The one that will be in acme will be much more advanced code that not many people would understand how to edit for their needs. This wont be too anoying for a everyday composer as the window for composing stays up until you close it. This will just stop people from starting a auto-compose bot and keep it going as you need to buy more compose items.
funhacker is offline  
Thanks
1 User
Old 09/19/2009, 16:13   #4
 
badboy r4c3r's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 95
Received Thanks: 18
so how do i use this i open then i get (Name) has encountered a problem a need to close, any certain things we should know

ahhh just got it, lol i dont have test and test as user and password , i have changed to something totaly different

could some 1 post the sql files plz, as changing my user and pass back to test and test would be inconvenient.

Quote:
If need be I can post a full guide on the concepts of using Excel to code your database edits for EO.
yes please beacuse i cant seem to make a working sql from what u posted. ill check again when i get back
badboy r4c3r is offline  
Old 09/19/2009, 19:23   #5
 
King_Arthur's Avatar
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
Quote:
Originally Posted by badboy r4c3r View Post
so how do i use this i open then i get (Name) has encountered a problem a need to close, any certain things we should know

ahhh just got it, lol i dont have test and test as user and password , i have changed to something totaly different

could some 1 post the sql files plz, as changing my user and pass back to test and test would be inconvenient.
You don't need to change any users and passwords. He has told you what you need to make for this to work:
Code:
Account
Login: test
Password: test
Host: 127.0.0.1

Database
Name: my

Tables
name:
cq_action
cq_task
cq_npc
So in simplest form you could do:
Code:
GRANT ALL PRIVILEGES my.* to 'test'@'localhost' IDENTIFIED BY 'test';
King_Arthur is offline  
Old 09/19/2009, 21:21   #6
 
badboy r4c3r's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 95
Received Thanks: 18
Quote:
Originally Posted by King_Arthur View Post
You don't need to change any users and passwords. He has told you what you need to make for this to work:
Code:
Account
Login: test
Password: test
Host: 127.0.0.1

Database
Name: my

Tables
name:
cq_action
cq_task
cq_npc
So in simplest form you could do:
Code:
GRANT ALL PRIVILEGES my.* to 'test'@'localhost' IDENTIFIED BY 'test';
ok i made a user test and pass test and granted all privileges but the app still give error
Do i have to move the files to a certain place or does that matter.
l
badboy r4c3r is offline  
Old 09/19/2009, 21:34   #7
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
Code:
delete from cq_action
where
id >= 4007360 and id <= 4007382;

delete from cq_task
where
id >= 4007360 and id <= 4007382;

delete from cq_npc
where
id = 200;

insert into cq_action
values
(4007360,4007361,0,101,0,'Hi %user_name what would you like to do?'),
(4007361,4007362,0,102,0,'[Compose~Pet] 4007364'),
(4007362,4007363,0,104,0,'0 0 0'),
(4007363,0,0,120,0,''),
(4007364,0,0,1046,37,''),
(4007365,4007366,4007370,121,0,'1 3'),
(4007366,0,0,122,0,'4007367 4007368 4007369'),
(4007367,0,0,122,0,'4007370 4007371 4007372 4007373'),
(4007368,0,0,122,0,'4007374 4007375 4007376 4007377'),
(4007369,0,0,122,0,'4007378 4007379 4007380 4007381'),
(4007370,4007360,4007365,121,0,'2 3'),
(4007371,4007360,0,301,200,'1000 315 448'),
(4007372,4007360,0,301,200,'1000 316 443'),
(4007373,4007360,0,301,200,'1000 312 440'),
(4007374,4007360,0,301,200,'1000 320 444'),
(4007375,4007360,0,301,200,'1000 323 450'),
(4007376,4007360,0,301,200,'1000 319 454'),
(4007377,4007360,0,301,200,'1000 313 452'),
(4007378,4007360,0,301,200,'1000 317 455'),
(4007379,4007360,0,301,200,'1000 320 453'),
(4007380,4007360,0,301,200,'1000 309 453'),
(4007381,4007360,0,301,200,'1000 312 456'),
(4007382,4007360,0,301,200,'1000 316 455');

insert into cq_task
(id,id_next)
values
(4007365,4007365),
(4007367,4007367),
(4007370,4007370),
(4007374,4007374),
(4007378,4007378),
(4007368,4007368),
(4007371,4007371),
(4007375,4007375),
(4007379,4007379),
(4007369,4007369),
(4007372,4007372),
(4007376,4007376),
(4007380,4007380),
(4007373,4007373),
(4007377,4007377),
(4007381,4007381),
(4007364,4007364);

insert into cq_npc
(id,name,type,lookface,mapid,cellx,celly,task0,data2,data3,sort,size_front,size_back,size_left,size_right)
values
(200,'Composer',29,12040,1000,315,448,4007365,5,5,1,3,3,3,3);
funhacker is offline  
Thanks
1 User
Old 09/20/2009, 14:21   #8
 
badboy r4c3r's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 95
Received Thanks: 18
well after using this sql my composers dont work.
badboy r4c3r is offline  
Old 09/20/2009, 19:52   #9
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
Quote:
Originally Posted by badboy r4c3r View Post
well after using this sql my composers dont work.
It is possible you do not have your cq_task setup like I do. Set values for min pk *** etc all to the common values it makes scripts like these much easier.
funhacker is offline  
Thanks
1 User
Old 09/23/2009, 16:16   #10
 
zuikislol's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 939
Received Thanks: 209
funhacker, could you please post a full guide how to set all this prgram up, because i dont unmderstand any of it, you havent explained where i have to extract any of those rar files you uploaded, so please just make a step by step little guide so everyone can understand it, thanks
zuikislol is offline  
Old 09/23/2009, 19:29   #11
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
Application:

1. Download
2. Check This list:
Quote:
Originally Posted by funhacker
ReadMe:
I have included a console app that will run the SQL script for a local server you will need the following:
Code:
Account
Login: test
Password: test
Host: 127.0.0.1

Database
Name: my

Tables
name:
cq_action
cq_task
cq_npc
3. Double click app
4. There is no 4 you just finished.

Excel file:
1. Read the Readme in my post:
Quote:
Originally Posted by funhacker
I have also included an editble version of this NPC in a spreadsheet most of it's just sum values so all you have to do is change 1 ID and it will change the rest. (highlighted by the gray box).
There are a list of 12 different locations the NPC will randomly move to from time to time you can add more or edit these how ever you wish.

You can turn the spreadsheet into a working SQL by replacing the following (using ctrl+h)
Quote:
[TAB]@' -> '
[TAB]@[TAB] -> ,'
[TAB]$' -> '
[TAB]$[TAB] -> [SPACE]
[TAB]* -> ),
*[TAB] -> (
[TAB] -> ,
Make sure to do it in that order or you can make some problems for yourself.
This is pretty much how I code everything makes things much more faster and easier to edit when you come back to it.
2. There is no 2 you are done.

SQLFile:
1. Highlight SQL Script in code box in my post:
Quote:
Originally Posted by funhacker
Code:
delete from cq_action
where
id >= 4007360 and id <= 4007382;

delete from cq_task
where
id >= 4007360 and id <= 4007382;

delete from cq_npc
where
id = 200;

insert into cq_action
values
(4007360,4007361,0,101,0,'Hi %user_name what would you like to do?'),
(4007361,4007362,0,102,0,'[Compose~Pet] 4007364'),
(4007362,4007363,0,104,0,'0 0 0'),
(4007363,0,0,120,0,''),
(4007364,0,0,1046,37,''),
(4007365,4007366,4007370,121,0,'1 3'),
(4007366,0,0,122,0,'4007367 4007368 4007369'),
(4007367,0,0,122,0,'4007370 4007371 4007372 4007373'),
(4007368,0,0,122,0,'4007374 4007375 4007376 4007377'),
(4007369,0,0,122,0,'4007378 4007379 4007380 4007381'),
(4007370,4007360,4007365,121,0,'2 3'),
(4007371,4007360,0,301,200,'1000 315 448'),
(4007372,4007360,0,301,200,'1000 316 443'),
(4007373,4007360,0,301,200,'1000 312 440'),
(4007374,4007360,0,301,200,'1000 320 444'),
(4007375,4007360,0,301,200,'1000 323 450'),
(4007376,4007360,0,301,200,'1000 319 454'),
(4007377,4007360,0,301,200,'1000 313 452'),
(4007378,4007360,0,301,200,'1000 317 455'),
(4007379,4007360,0,301,200,'1000 320 453'),
(4007380,4007360,0,301,200,'1000 309 453'),
(4007381,4007360,0,301,200,'1000 312 456'),
(4007382,4007360,0,301,200,'1000 316 455');

insert into cq_task
(id,id_next)
values
(4007365,4007365),
(4007367,4007367),
(4007370,4007370),
(4007374,4007374),
(4007378,4007378),
(4007368,4007368),
(4007371,4007371),
(4007375,4007375),
(4007379,4007379),
(4007369,4007369),
(4007372,4007372),
(4007376,4007376),
(4007380,4007380),
(4007373,4007373),
(4007377,4007377),
(4007381,4007381),
(4007364,4007364);

insert into cq_npc
(id,name,type,lookface,mapid,cellx,celly,task0,data2,data3,sort,size_front,size_back,size_left,size_right)
values
(200,'Composer',29,12040,1000,315,448,4007365,5,5,1,3,3,3,3);
2.Press ctrl+c
3.Open Navicat (or any GUI MySQL application)
4.Double Click your server connection.
5.Double click your Database.
6.Open Query/Console for Database
7.Press ctrl+v.
8.Press Enter/Run(If using query)
9.There is no 9 you are done.
funhacker is offline  
Thanks
3 Users
Old 09/23/2009, 20:08   #12
 
zuikislol's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 939
Received Thanks: 209
thank you

im sorry again funhacker but still dont get it, yoiu have made both of your guides as understandable as for you but not for me, me compared to you, im the noob here, so please make another short guide, my problems is: i have run the sql script everything if fine, all i need to know is where i have to put the RandomMoveComposer(App) and the 200(EudComposer-Aderes)(Spreadsheet) and what do i have to do with them, then do i have to make a user in my databse as test with password test? and if i've missed something for me to add then please tell me, thank you
zuikislol is offline  
Old 09/24/2009, 15:57   #13
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
Each upload is a Different option. If you have ran the SQL Script there is no need to use the other files. The application there atm is just a program that will run the script for you. The excel file is for advanced users that wish to see how to make SQL files much easier and to edit the existing one without alot of work.
funhacker is offline  
Old 09/24/2009, 18:24   #14
 
zuikislol's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 939
Received Thanks: 209
so what u're saying is that i dont need anything else i just had to run the sql script? and how will that stop the auto composing bot?

well the auto composing bot still works, so what have i done worng, i have only run the script, and made a user test,test, bd:my, tables action, task, nps, after i runned your script the composer didnt work, so i have to add the missing numbers in the cq_task, now the composer works and the auto compose bot work, what im i missing?
zuikislol is offline  
Old 09/24/2009, 20:56   #15
 
funhacker's Avatar
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,741
First thing you are missing is this:

Second thing the NPC will not move first time it is clicked this has more of an affect whilst on an active server with a few people using the composer at a time it will make your composer move locations only a few cells at a time. This means when the compose bot goes to start it will fail because the NPC is in the a different spot.
funhacker is offline  
Reply


Similar Threads Similar Threads
[RELEASE] CHANGING YOUR EUDEMON COMPOSE RATE USING QUERY
07/13/2017 - EO PServer Guides & Releases - 19 Replies
i though many of people here having a problem when trying to changing their eudemon compose rate one by one in cq_eudemon_rbn_rqr..so i made a simple query to changing it easily by using a query..so here we go..firsty..u must have a standard compose sql..so i have upload the standard compose rate query for download if u like(my standard compose rate). Then use this query to changing your composing rate.. UPDATE `cq_eudemon_rbn_rqr` SET max = max + 20; UPDATE `cq_eudemon_rbn_rqr` SET...
[Release]Combating Macro in the Compose
04/30/2010 - EO PServer Guides & Releases - 22 Replies
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?
[RELEASE]Standard Rate Compose Sql File
11/13/2009 - EO PServer Guides & Releases - 5 Replies
Just Click here to download... StandardComposeRateFile
[Release]Enchant,Bless And Compose NPC
11/10/2009 - CO2 PServer Guides & Releases - 13 Replies
Go In Client.cs And Search For: if (CurrentNPC == 1010) Under Add: if (CurrentNPC == 278) { SendPacket(General.MyPackets.NPCSay("This machine here can compose, bless and enchant your items. Appearently it can only compose, because it is broken.")); SendPacket(General.MyPackets.NPCLink("Compose ", 1));
[RELEASE] Compose +1 to +12 in 1 NPC
07/06/2009 - CO2 PServer Guides & Releases - 2 Replies
in Client, seacrh for #region NPC Talk and put this code under CurrentNPC = NPCID; if (CurrentNPC == 1554) { SendPacket(General.MyPackets.NPCSay("I can compose, bless and enchant your items, which do you want?")); SendPacket(General.MyPackets.NPCLink("Compose +1 - +9", 1)); SendPacket(General.MyPackets.NPCLink("Enchant ", 2)); ...



All times are GMT +1. The time now is 04:14.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.