Jump to content
  • 0
Patskie

[Guide] How to setup hercules

Question

There is an existing server installation guide made by Diconfrost VaNz on this topic but this is outdated. So let me give ample time to share my experience on how to install Hercules SVN on your local machine.

 

1. To obtain hercules, refer to Ind's topic

2. Go to conf/char-server.conf and look for the code below : 

// Server Communication username and password.userid: s1passwd: p1

 

Set s1 and p1 to anything you want but take note of them as you will use them later on when you move to SQL portion of this installation.

 

In my case, i will use patskie since it is my screen name.

// Server Communication username and password.userid: patskiepasswd: patskie

 

3. Set your server name? Find this line also on your conf/char-server.conf. Change it to whatever you want : 

// Server name, use alternative character such as ASCII 160 for spaces.// NOTE: Do not use spaces or any of these characters which are not allowed in //       Windows filenames /:*?"<>|//       ... or else guild emblems won't work client-side!server_name: Hercules

 

4. Remove // on the following code : 

//login_ip: 127.0.0.1

 

//char_ip: 127.0.0.1

Note : 127.0.0.1 means localhost, local machine.

 

5. Save and exit

6. Now go to conf/map-server.conf

7. Same to what you have did in conf/char-server.conf :

//--------------------------------------------------------------//                     Configuration Info//--------------------------------------------------------------// Interserver communication passwords, set in account.txt (or equiv.)userid: patskiepasswd: patskie

 

8. Remove // on the following code :

//char_ip: 127.0.0.1

 

//map_ip: 127.0.0.1

 

9. Once you're done. Save and exit.

10. Now go to conf/inter-server.conf

11. Set the following code :

// Global SQL settings// overriden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: rootsql.db_password: ragnaroksql.db_database: herculessql.codepage:// MySQL Character SQL serverchar_server_ip: 127.0.0.1char_server_port: 3306char_server_id: rootchar_server_pw: ragnarokchar_server_db: hercules// MySQL Map SQL Servermap_server_ip: 127.0.0.1map_server_port: 3306map_server_id: rootmap_server_pw: ragnarokmap_server_db: hercules// MySQL Log SQL Databaselog_db_ip: 127.0.0.1log_db_port: 3306log_db_id: rootlog_db_pw: ragnaroklog_db_db: loglog_codepage:log_login_db: loginlog

Note : Use 127.0.0.1 as ip because you will run these server on your local machine. Use root as the database id because by default MySQL workbench uses root as username. And finally ragnarok as database password which is configurable by users. Set map, char an sql database to hercules and set log database to loginlog 

 

12. Once done, Save and exit

13. Now go to src/common/mmo.h and find the following code :

#ifndef PACKETVER	#define PACKETVER 20120418#endif

Change to : 

#ifndef PACKETVER	#define PACKETVER 20100730#endif

Note : You can change 20120418 (2012-04-18) to whatever client-date you want. In my case i will use 2010-07-30 client (20100730).

 

14. Save and exit.

15. Now let's go to mysql part.

16. Download MySQL workbench here. Why workbench? More convenient to use.

17. Once you are finished downloading and installing. Download WAMP server here because workbench will not start functioning if you do not have WAMP server

18. Once you are finished downloading and installing wampserver. Run it

19. Open mysql workbench

20. Add user and password into it. Follow this guide. Make sure you set username as root and password as ragnarok because this is the credentials located on your conf/inter-server.conf

21. Create a server instance and connection. Just click New Connection for creating connection and click New Server Instance for creating a new server instance everything there are self explanatory

22. More likely you must have the following : ( Check image below )

post-449-0-53815600-1370176262_thumb.png

23. At the left portion of the application. You can see schemas. Right click on one of them (test schema) and click on create schema

24. Set the name of the schema to hercules because that is the credential we put in our inter-server

25. Create also a schema log 

26. Double click hercules schema

27. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/main.sql, open it and execute ( you can find execute button at the upper portion of the text editor of mysql workbench it looks like a thunder xD )

28. Double click log schema

29. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/logs.sql, open it and execute ( you can find execute button at the upper portion of the text editor of mysql workbench it looks like a thunder xD )

30. Once everything is set double click again hercules schema

31. Execute the following code 

SELECT * FROM login;

32. Change userid, user_pass to the credentials you have put on both char-server and map-server.conf

33. Click apply.

34. Once done, go back to your server files and compile everything using Microsoft Visual Studio 2009 or 2010 or 2012 

 

Note : 

Microsoft Visual Studio 2009 = Hercules-9

Microsoft Visual Studio 2010 = Hercules-10

Microsoft Visual Studio 2012 = Hercules-12

 

35. Open it via C++

36. In my case i am using MVS 2010, Highlight char-server, login-server, map-server, mapcache at the left portion of the application. Right click on it and click Build Selection

37. Check image for successful compilation, Once done exit the application

post-449-0-76531700-1370177311_thumb.png

38. Now you're done! Run run-server.bat on main folder

 

 

I hope this guide help other people who find it difficult to install hercules svn on your local machine. Actually this guide is not hard. I just divided the guide into small chunks so that people will understand more. If you think that any portion of installation is not included in my guide or maybe in some way not good or not correct then feel free to post it.

 

Additional Notes : 

- If you want other people to connect then you must port forward your router, or you can use other application like hamachi

- If any error occur feel free to post it here. Make sure you will post it in a detailed manner. Post screenshot if possible

- I include a diff client for 2010-07-30 since i use it in this guide

2010-07-30-DIFF.rar

Edited by Patskie

Share this post


Link to post
Share on other sites

107 answers to this question

Recommended Posts

  • 0

"31. Execute the following code

 

SELECT * FROM login"

 

This part really makes no sense to me, can I have a clarification?  It is very vague,  I see no place to "execute" code from what looks like command line.

 

It's just a small script line to bring up the login db log in order to edit the server username and password. Another option to edit this is to do the following:

 

1. You should have 2 Main Databases named 'logs' and/or 'Hercules'  (According to guide, it should be hercules)

`logs` is the smaller database with logs for atcommand, npclog, etc

`Hercules` is the HUGE database for ipbans, login, mail, etc.

 

2. Click Hercules, Click table, then Click the dropdown arrow on table to suspend the 40+ databases and scroll down to 'login'

Open it with a right click and select 1000 something something, I don't remember.... The login should have the following format:

 

Accound ID     ||   user_id     ||     user_pass    || sex   ||   email || 

----------------------------------------------------------------------------------------------------------

3. You need to edit the user id and password that matches your conf folder. If they do not match you will get the famous mysql connection lost connection using the password:YES!

 

 

~Hope that helped. I don't have Workbench on my mac and I'm just visualizing it in my head! 

Edited by Inochi

Share this post


Link to post
Share on other sites
  • 0

Yes as long as the Hercules provided the until that date 2009,2010,2013 then go for it. but in my opinion i would go for 2010 majority of people go for it.

Share this post


Link to post
Share on other sites
  • 0

 

 

 

why i cant see the new quest in renewal like dewata,bifrost etc

Maybe you set your server to pre-re 

 

 

>Keep it up! nice guide, appreciate it.. a + for you sir! Thank you.&nb

sp; :)

Thanks. Hope to have time creating a guide on linux :)

 

sir, just a follow up question.. how to set the server to Pre-Renewal? or I wan't the casting time use the Pre-Re formula.

thanks in advance!  ;)

Just comment out #define tags 

 

Link : https://github.com/HerculesWS/Hercules/blob/master/src/config/renewal.h

 

// Copyright © Hercules Dev Team, licensed under GNU GPL.

// See the LICENSE file

// Portions Copyright © Athena Dev Teams

#ifndef CONFIG_RENEWAL_H

CONFIG_RENEWAL_H

 

/**

* Hercules configuration file (http://herc.ws)

* For detailed guidance on these check http://herc.ws/wiki/SRC/config/

**/

 

/**

* @INFO: This file holds general-purpose renewal settings, for class-specific ones check /src/config/classes folder

**/

 

/**

* Renewal full toggle switch.

*

* Uncomment this line to disable all of the below settings at once.

* Note: in UNIX builds, this can be easily done without touching this

* line, by passing --disable-renewal to the configure script:

* ./configure --disable-renewal

*/

DISABLE_RENEWAL

 

 

#ifndef DISABLE_RENEWAL // Do not change this line

 

/// game renewal server mode

/// (disable by commenting the line)

///

/// leave this line to enable renewal specific support such as renewal formulas

RENEWAL

 

/// renewal cast time

/// (disable by commenting the line)

///

/// leave this line to enable renewal casting time algorithms

/// cast time is decreased by DEX * 2 + INT while 20% of the cast time is not reduced by stats.

/// example:

/// on a skill whos cast time is 10s, only 8s may be reduced. the other 2s are part of a

/// "fixed cast time" which can only be reduced by specialist items and skills

RENEWAL_CAST

 

/// renewal drop rate algorithms

/// (disable by commenting the line)

///

/// leave this line to enable renewal item drop rate algorithms

/// while enabled a special modified based on the difference between the player and monster level is applied

/// based on the http://irowiki.org/wiki/Drop_System#Level_Factor table

#define RENEWAL_DROP

 

/// renewal exp rate algorithms

/// (disable by commenting the line)

///

/// leave this line to enable renewal item exp rate algorithms

/// while enabled a special modified based on the difference between the player and monster level is applied

RENEWAL_EXP

 

/// renewal level modifier on damage

/// (disable by commenting the line)

///

// leave this line to enable renewal base level modifier on skill damage (selected skills only)

#define RENEWAL_LVDMG

 

/// renewal enchant deadly poison algorithm

///

/// leave this line to enable the renewed EDP algorithm

/// under renewal mode:

/// - damage is NOT increased by 400%

/// - it does NOT affect grimtooth

/// - weapon and status ATK are increased

/// - some skill's damage ratio has modified

RENEWAL_EDP

 

/// renewal ASPD [malufett]

///

/// leave this line to enable renewal ASPD

/// - shield penalty is applied

/// - AGI has a greater factor in ASPD increase

/// - there is a change in how skills/items give ASPD

/// - some skill/item ASPD bonuses won't stack

RENEWAL_ASPD

 

#endif // DISABLE_RENEWAL

#undef DISABLE_RENEWAL

 

#endif // CONFIG_RENEWAL_H

 

Like this sir Pat?

Share this post


Link to post
Share on other sites
  • 0

@@Super Arki

 

Renewal 

/// game renewal server mode/// (disable by commenting the line)////// leave this line to enable renewal specific support such as renewal formulas#define RENEWAL

Pre-Renewal

/// game renewal server mode/// (disable by commenting the line)////// leave this line to enable renewal specific support such as renewal formulas//#define RENEWAL
Edited by Naori

Share this post


Link to post
Share on other sites
  • 0

@@jogradz Try use alternative. Such as, phpmyadmin, navicat premium

ok, so how do i use it? sorry, i need a little bit more explanation... since i'm really new to this and i would really like to learn... so if i use this how do i get back to setting up my offline?

Share this post


Link to post
Share on other sites
  • 0

hi, when i uninstalled wamp char, login and mapserver gives me error cannot connect to mysql server, i mean, why does other releases don't even need mysql service running to play? and when I check my hercules/save there is no account.txt file

Share this post


Link to post
Share on other sites
  • 0

hi, when i uninstalled wamp char, login and mapserver gives me error cannot connect to mysql server, i mean, why does other releases don't even need mysql service running to play? and when I check my hercules/save there is no account.txt file

 

Good day @@Gunburn,

 

You need Wamp so that your RO will be able to communicate to your RO's Database.. any changes to your RO Server like Creation of new character, character items obtain etc. will stored to the MySQL database and the Wamp is responsible for doing it.

Anyway you're wondering why the Old RO one's don't use Wamp.. I guess it's the Old RO Text Version you mean that does not need Wamp. 

 

Hope it helps.

May you have a great week.  :)

Share this post


Link to post
Share on other sites
  • 0

Hi Mr. Patskie how about giving a links to download so it will be easier... coz' i don't know where can i download Microsoft Visual Studio 2010, sorry im new here...

Share this post


Link to post
Share on other sites
  • 0

Hi Mr. Patskie how about giving a links to download so it will be easier... coz' i don't know where can i download Microsoft Visual Studio 2010, sorry im new here...

We live in the google age bro

Share this post


Link to post
Share on other sites
  • 0

[ignore post - Compiling the four files were missing from the hercules I've downloaded and went to download the latest hercules-master files]

Edited by SuoChan

Share this post


Link to post
Share on other sites
  • 0

for everyone stuck on number 20. you don't need to use mysql work bench, there are also other programs you can use. there is HeidiSQL, as well as the old mysql gui tools.

 

Mysql GUI Tools

 

HeidiSQL

Edited by lilcooldude69

Share this post


Link to post
Share on other sites
  • 0

it wont let me compile... it gives me "failed" msg when i compile it.

what microsoft visual studio compatible with my laptop? download link please

 

15mmio8.png

Share this post


Link to post
Share on other sites
  • 0

There is an existing server installation guide made by Diconfrost VaNz on this topic but this is outdated. So let me give ample time to share my experience on how to install Hercules SVN on your local machine.

 

1. To obtain hercules, refer to Ind's topic

2. Go to conf/char-server.conf and look for the code below : 

// Server Communication username and password.userid: s1passwd: p1

 

Set s1 and p1 to anything you want but take note of them as you will use them later on when you move to SQL portion of this installation.

 

In my case, i will use patskie since it is my screen name.

// Server Communication username and password.userid: patskiepasswd: patskie

 

3. Set your server name? Find this line also on your conf/char-server.conf. Change it to whatever you want : 

// Server name, use alternative character such as ASCII 160 for spaces.// NOTE: Do not use spaces or any of these characters which are not allowed in //       Windows filenames /:*?"<>|//       ... or else guild emblems won't work client-side!server_name: Hercules

 

4. Remove // on the following code : 

//login_ip: 127.0.0.1

 

//char_ip: 127.0.0.1

Note : 127.0.0.1 means localhost, local machine.

 

5. Save and exit

6. Now go to conf/map-server.conf

7. Same to what you have did in conf/char-server.conf :

//--------------------------------------------------------------//                     Configuration Info//--------------------------------------------------------------// Interserver communication passwords, set in account.txt (or equiv.)userid: patskiepasswd: patskie

 

8. Remove // on the following code :

//char_ip: 127.0.0.1

 

//map_ip: 127.0.0.1

 

9. Once you're done. Save and exit.

10. Now go to conf/inter-server.conf

11. Set the following code :

// Global SQL settings// overriden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: rootsql.db_password: ragnaroksql.db_database: herculessql.codepage:// MySQL Character SQL serverchar_server_ip: 127.0.0.1char_server_port: 3306char_server_id: rootchar_server_pw: ragnarokchar_server_db: hercules// MySQL Map SQL Servermap_server_ip: 127.0.0.1map_server_port: 3306map_server_id: rootmap_server_pw: ragnarokmap_server_db: hercules// MySQL Log SQL Databaselog_db_ip: 127.0.0.1log_db_port: 3306log_db_id: rootlog_db_pw: ragnaroklog_db_db: loglog_codepage:log_login_db: loginlog

Note : Use 127.0.0.1 as ip because you will run these server on your local machine. Use root as the database id because by default MySQL workbench uses root as username. And finally ragnarok as database password which is configurable by users. Set map, char an sql database to hercules and set log database to loginlog 

 

12. Once done, Save and exit

13. Now go to src/common/mmo.h and find the following code :

#ifndef PACKETVER	#define PACKETVER 20120418#endif

Change to : 

#ifndef PACKETVER	#define PACKETVER 20100730#endif

Note : You can change 20120418 (2012-04-18) to whatever client-date you want. In my case i will use 2010-07-30 client (20100730).

 

14. Save and exit.

15. Now let's go to mysql part.

16. Download MySQL workbench here. Why workbench? More convenient to use.

17. Once you are finished downloading and installing. Download WAMP server here because workbench will not start functioning if you do not have WAMP server

18. Once you are finished downloading and installing wampserver. Run it

19. Open mysql workbench

20. Add user and password into it. Follow this guide. Make sure you set username as root and password as ragnarok because this is the credentials located on your conf/inter-server.conf

21. Create a server instance and connection. Just click New Connection for creating connection and click New Server Instance for creating a new server instance everything there are self explanatory

22. More likely you must have the following : ( Check image below )

attachicon.gifUntitled.png

23. At the left portion of the application. You can see schemas. Right click on one of them (test schema) and click on create schema

24. Set the name of the schema to hercules because that is the credential we put in our inter-server

25. Create also a schema log 

26. Double click hercules schema

27. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/main.sql, open it and execute ( you can find execute button at the upper portion of the text editor of mysql workbench it looks like a thunder xD )

28. Double click log schema

29. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/logs.sql, open it and execute ( you can find execute button at the upper portion of the text editor of mysql workbench it looks like a thunder xD )

30. Once everything is set double click again hercules schema

31. Execute the following code 

SELECT * FROM login;

32. Change userid, user_pass to the credentials you have put on both char-server and map-server.conf

33. Click apply.

34. Once done, go back to your server files and compile everything using Microsoft Visual Studio 2009 or 2010 or 2012 

 

Note : 

Microsoft Visual Studio 2009 = Hercules-9

Microsoft Visual Studio 2010 = Hercules-10

Microsoft Visual Studio 2012 = Hercules-12

 

35. Open it via C++

36. In my case i am using MVS 2010, Highlight char-server, login-server, map-server, mapcache at the left portion of the application. Right click on it and click Build Selection

37. Check image for successful compilation, Once done exit the application

attachicon.gifUntitled.png

38. Now you're done! Run run-server.bat on main folder

 

 

I hope this guide help other people who find it difficult to install hercules svn on your local machine. Actually this guide is not hard. I just divided the guide into small chunks so that people will understand more. If you think that any portion of installation is not included in my guide or maybe in some way not good or not correct then feel free to post it.

 

Additional Notes : 

- If you want other people to connect then you must port forward your router, or you can use other application like hamachi

- If any error occur feel free to post it here. Make sure you will post it in a detailed manner. Post screenshot if possible

- I include a diff client for 2010-07-30 since i use it in this guide

attachicon.gif2010-07-30-DIFF.rar

 

can you please update the guide if you can? i followed the steps but some files either missing or in different folder...

The file was already modified days ago.

 

conf/common/inter-server.conf

conf/global/sql_connections.conf

 

can you tell why i cant find the step on his guide about the inter-server.conf? how do i follow his step? it says do the same thing as char & map server.conf  :sob:

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.