Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

eBot v2.0.1.4 | Auto Events | vSro

Junior Spellweaver
Joined
Feb 19, 2014
Messages
105
Reaction score
28
Hello ragezone members :),


Beforehand introducing my program and its features, i want to summarize the general use of it and point out why P-sro scene needs a program like this.


In the light of the recent p-sro servers we realized how the Auto-Events are important to bring huge amount of players since it provides a real-proper in game content-schedule and stuff. But then, you have to work tons of hours to for coding something like that.
At this point, i wanted to code an Event-Bot, aka eBot, which is going to make your life much more easier.




(Tested on vSro only)

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

Muhab Ashraf - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums



Instruction:

To be able to use the program without any problems follow this steps.

1-Create 'eBot' database.
2-Restore 'eBot' database (You can find eBot.bak inside bot folder).
3-Correct databases names inside 'eBot' stored procedures.
4-You have to load objcommon data. There is two ways to do that.
a-Load data via sql (That loads data from _RefObjCommon table at sql directly).
b-Load data via txt files (You have to add itemdata_xxx.txt,chardata_xxx.txt & teleportbuilding.txt lines into objcommon.txt inside bot folder & replace each tab space with a comma ','. (Don't add empty lines and Fix all errors which appears on Bot log).
5-Add your trivia questions and answers into Questions.txt inside bot folder (Split between each question and answer with '|', Each line for only 1 question and answer.)
Note: Load data via sql still loads Trivia questions from questions.txt.
6-When you lunch the bot you have to Log in to the server and Load Data (No username or password needed, It takes 2~4 minutes to load data successfully).
7-Now your program can work without any problem ;).

Note: Net Framework 4.5 needed.

•Current Events:

Automatic Trivia Event.
Automatic Kill The GM Event.
Automatic Hide & Seek Event.
Automatic Lucky Party Number Event.
Automatic Uniques Event.
Automatic Last Man Standing Event.

eBot is not just an Auto Events bot, It also record your server Uniques kills and Globals history (You can check _Globals & _Uniques tables for that).

•Upcoming Events:

Automatic Alchemy Event.
Automatic PvP Event.

•Download Links:

You can find download link here

•Important Notes:

1-If you find any bug or feel like suggesting regarding the program in order to improve it, replay here or just send me message on skype.
2-Donations will keep the program alive and motivate for more events :).
3-Program is completely trustable there is no data send to server except your server ip.
4-Program doesn't run 2 events at the same time.

Contacts:

Skype: mohabkhamess
(Please just come up with your request/expectation with one full sentence not like hi-why-where poop lol)

Change Log:
v2.0.0.8
*Fixed a lot related to sql queries management in the bot.

v2.0.0.0~v2.0.0.7
*Fixed some bugs.
*Wrote a proper error handle on both bot and server side.
*Added method to load objcommon data via sql.
*Added a delay for trivia event means if there is no answer for 5 minutes event ends.
*Fixed LMS event so it can't start with 1 player.
*Added Minimum & Maximum player control for LMS event.
*A proper time system for events.
 
Last edited:
Initiate Mage
Joined
Jan 2, 2012
Messages
43
Reaction score
40
Re: eBot v2.0.0.0 | Auto Events | vSro

I like it, keep it up!
 
(⌐■_■)
Joined
Feb 2, 2012
Messages
681
Reaction score
102
Re: eBot v2.0.0.0 | Auto Events | vSro

Source code included ?
There are some people are working on tiwan files here xD
 
very nice
Joined
Jul 5, 2013
Messages
518
Reaction score
80
Re: eBot v2.0.0.0 | Auto Events | vSro

open source?
 
Initiate Mage
Joined
Nov 12, 2008
Messages
71
Reaction score
0
Re: eBot v2.0.0.0 | Auto Events | vSro

error when open. version 0 and 1
 
Initiate Mage
Joined
Nov 12, 2008
Messages
71
Reaction score
0
Re: eBot v2.0.0.0 | Auto Events | vSro

Dont've framework 4.5, downloading and post test.

You can add in "Instruction" that need framework 4.5
 
Initiate Mage
Joined
Jun 13, 2014
Messages
14
Reaction score
1
Re: eBot v2.0.0.0 | Auto Events | vSro

i'm sure it will never work :3
[4:02:17 AM] Failed to excute query: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
 
Initiate Mage
Joined
Nov 12, 2008
Messages
71
Reaction score
0
Re: eBot v2.0.0.0 | Auto Events | vSro

i'm sure it will never work :3
[4:02:17 AM] Failed to excute query: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

You need allow tcp ip in sql server and remote conection or use in localserver with .\SQLEXPRESS
 
Junior Spellweaver
Joined
Aug 15, 2014
Messages
145
Reaction score
5
Re: eBot v2.0.0.0 | Auto Events | vSro

4-Add itemdata_xxx.txt,chardata_xxx.txt & teleportbuilding.txt lines into objcommon.txt inside bot folder & replace each tab space with ','. (Don't add empty lines and Fix all errors which appears on Bot log)

can you tell me what you mean replace each tab space with ','
you mean like this
Replace it

PHP:
1    25011    ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1    ??? ?    xxx    SN_ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1    SN_ITEM_ETC_ARCHEMY_MATERIAL_TT_DESC    0    0    3    3    11    4    180000    3    0    1    1    1    255    3    1    0    0    0    0    9933    0    0    0    99    1987    -1    100    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_archemy_bag.bsr    item\etc\material_leaf.ddj    xxx    xxx    250    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    1    ITEM_ETC_ARCHEMY_ELEMENT_EARTH_10    4    ITEM_ETC_ARCHEMY_ELEMENT_WATER_10    4    ITEM_ETC_ARCHEMY_ELEMENT_FIRE_10    2    ITEM_ETC_ARCHEMY_ELEMENT_WIND_10    2    ??????(???)    150    ????    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
To this
PHP:
1','25011','ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1','??? ?','xxx','SN_ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1','SN_ITEM_ETC_ARCHEMY_MATERIAL_TT_DESC','0','0','3','3','11','4','180000','3','0','1','1','1','255','3','1','0','0','0','0','9933','0','0','0','99','1987','-1','100','-1','0','-1','0','-1','0','-1','0','0','0','0','0','0','0','100','0','0','0','xxx','item\etc\drop_archemy_bag.bsr','item\etc\material_leaf.ddj','xxx','xxx','250','2','0','0','1','0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0','0','0','0','0','0','0','0','0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','1','ITEM_ETC_ARCHEMY_ELEMENT_EARTH_10','4','ITEM_ETC_ARCHEMY_ELEMENT_WATER_10','4','ITEM_ETC_ARCHEMY_ELEMENT_FIRE_10','2','ITEM_ETC_ARCHEMY_ELEMENT_WIND_10','2','??????(???)','150','????','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','0','0
 
Initiate Mage
Joined
Jun 13, 2014
Messages
14
Reaction score
1
Re: eBot v2.0.0.0 | Auto Events | vSro

You need allow tcp ip in sql server and remote conection or use in localserver with .\SQLEXPRESS

hahaha why should i then ?
to allow you to connect to my databases via the sended infos by the bot ? xD Awesome :3
 
Junior Spellweaver
Joined
Oct 2, 2011
Messages
113
Reaction score
23
Re: eBot v2.0.0.0 | Auto Events | vSro

can you tell me what you mean replace each tab space with ','
you mean like this
Replace it

PHP:
1    25011    ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1    ??? ?    xxx    SN_ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1    SN_ITEM_ETC_ARCHEMY_MATERIAL_TT_DESC    0    0    3    3    11    4    180000    3    0    1    1    1    255    3    1    0    0    0    0    9933    0    0    0    99    1987    -1    100    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_archemy_bag.bsr    item\etc\material_leaf.ddj    xxx    xxx    250    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    1    ITEM_ETC_ARCHEMY_ELEMENT_EARTH_10    4    ITEM_ETC_ARCHEMY_ELEMENT_WATER_10    4    ITEM_ETC_ARCHEMY_ELEMENT_FIRE_10    2    ITEM_ETC_ARCHEMY_ELEMENT_WIND_10    2    ??????(???)    150    ????    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
To this
PHP:
1','25011','ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1','??? ?','xxx','SN_ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1','SN_ITEM_ETC_ARCHEMY_MATERIAL_TT_DESC','0','0','3','3','11','4','180000','3','0','1','1','1','255','3','1','0','0','0','0','9933','0','0','0','99','1987','-1','100','-1','0','-1','0','-1','0','-1','0','0','0','0','0','0','0','100','0','0','0','xxx','item\etc\drop_archemy_bag.bsr','item\etc\material_leaf.ddj','xxx','xxx','250','2','0','0','1','0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0','0','0','0','0','0','0','0','0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','1','ITEM_ETC_ARCHEMY_ELEMENT_EARTH_10','4','ITEM_ETC_ARCHEMY_ELEMENT_WATER_10','4','ITEM_ETC_ARCHEMY_ELEMENT_FIRE_10','2','ITEM_ETC_ARCHEMY_ELEMENT_WIND_10','2','??????(???)','150','????','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','-1','xxx','0','0


no i think it should be like this
PHP:
1,25011,ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1,??? ?,xxx,SN_ITEM_ETC_ARCHEMY_MATERIAL_SD_UNEG1,SN_ITEM_ETC_ARCHEMY_MATERIAL_TT_DESC,0,0,3,3,11,4,180000,3,0,1,1,1,255,3,1,0,0,0,0,9933,0,0,0,99,1987,-1,100,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,xxx,item\etc\drop_archemy_bag.bsr,item\etc\material_leaf.ddj,xxx,xxx,250,2,0,0,1,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1,ITEM_ETC_ARCHEMY_ELEMENT_EARTH_10,4,ITEM_ETC_ARCHEMY_ELEMENT_WATER_10,4,ITEM_ETC_ARCHEMY_ELEMENT_FIRE_10,2,ITEM_ETC_ARCHEMY_ELEMENT_WIND_10,2,??????(???),150,????,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,-1,xxx,0,0
 
Initiate Mage
Joined
Nov 12, 2008
Messages
71
Reaction score
0
Re: eBot v2.0.0.0 | Auto Events | vSro

Chat dont working



Trivia dont work, i send global and pm and dont win



RefObjItem.txt
Copy all of your db.
9kQjZVq - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums

D2HmfZy - eBot v2.0.1.4 | Auto Events | vSro - RaGEZONE Forums


And replace all
 

Attachments

You must be registered for see attachments list
Last edited:
Junior Spellweaver
Joined
Oct 2, 2011
Messages
113
Reaction score
23
Re: eBot v2.0.0.0 | Auto Events | vSro

i have a problem here

after character spawns i get this error
and every time the bot trying to an event i got this error

[7:38:00 AM] Failed to send packet to server : An established connection was aborted by the software in your host machine
 
Initiate Mage
Joined
Nov 12, 2008
Messages
71
Reaction score
0
Re: eBot v2.0.0.0 | Auto Events | vSro

i have a problem here

after character spawns i get this error
and every time the bot trying to an event i got this error

u need refobjcommon.txt with item of your db
 
Back
Top