eBot v2.0.1.4 | Auto Events | vSro

[Muhab Ashraf]

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)

•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 eBot-vSro

•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 :).
(You can donate via this link)
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 shit 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.

[MentaL]

[karemsame]

Good Job , Keep it up.

- - - Updated - - -

but it's not epvp members :P :D

[MeTaD]

I like it, keep it up!

[NourAyman]

Source code included ?
There are some people are working on tiwan files here xD

[Muhab Ashraf]

There are some people are working on tiwan files here xD

I may create a tiwan version later.

[MikroTekken]

Nice Muhab Keep it up

[B1QB0SS]

open source?

[Muhab Ashraf]

open source?

Full source boss.

[Fantans]

http://prntscr.com/5mu8nh error when open. version 0 and 1

[Muhab Ashraf]

http://prntscr.com/5mu8nh error when open. version 0 and 1

Can u translate this please ?
And make sure you have got Net Framework 4.5

[Fantans]

Dont've framework 4.5, downloading and post test.

You can add in "Instruction" that need framework 4.5

[egyhunter]

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)

[Fantans]

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

[MikroTekken]

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

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

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 

[egyhunter]

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