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!

Eathena Update

Newbie Spellweaver
Joined
Aug 11, 2004
Messages
98
Reaction score
0
Ok, I saw the post where a person was complaining about how old these post are. So I decided to post this. Please note that I do not take any credit for this and all of this can be found at eathena's official site:


Ok. Eathena has upgraded to SVN server files, which is pretty good. They update it everyday or so and I find it alot better than rc5. Currently, the latest server files are:



and



These have already been compiled and all you need to do is edit the files and run them. Txt is very straight forward and easy. Mysql is alittle more complex.

BowieBowie's sql guide

1. Download eAthena SQL

2. Extract it to anywhere you want but not in your desktop.

3. Go to Conf folder, open grf-files.txt and edit the patch to where your RO folder is but default is C:\Program Files\Gravity\RO\

4. Files we need to edit are char_athena.conf, login_athena.conf and map_athena.conf.
Use Notepad to edit .conf files.

char_athena.conf
-Edit userid: s1 and user_pass: p1 for Server Account.
Just change s1 and p1 to any name you want that we need it later for MySQL.
It's for to prevent ppl to hack your computer.
-Remove // for login_ip:, char_ip: and change 127.0.0.1 to your Internet IP (IP for letting ppl to connect to your server) but if you just want to test out, then just use 127.0.0.1, which is Local IP/Computer IP.
-Now we are done with char_athena.conf so, just SAVE and exit.

login_athena.conf
-Remove // for login_ip: and change 127.0.0.1 to your Internet IP (read char_athena.conf)
-Look for new_account: and change the value to 0 to disable using _M/_F registration.
-SAVE and exit.

map_athena.conf
-Edit userid: s1 and user_pass: p1 that need to be same as you edited in char_athena.conf.
-Remove // for char_ip:, map_ip: and change 127.0.0.1 to your Internet IP (read char_athena.conf)
-SAVE and exit.

5. Everything should be done now for eAthena Server side so, time to set up MySQL.

-MYSQL-
1. Download MySQL 4.0.24, MySQL Control Center 0.9.4 and MySQL Administrator 1.0.19. I don't suggest to use 1.0.20 for MySQL Administrator.




2. Install MySQL 4.0.24 in C:\mysql\ , which should be by default so, just click Next to install without changing anything.

3. Install MySQL Control Center 0.9.4 and MySQL Administrator 1.0.19 in anywhere you want.

4. Go to C:\mysql\bin\ and start winmysqladmin.exe. It will ask you to enter Username and Password but just click Cancel.
It will minimize to a tray icon so, check buttom right corner and open it... you will see the light is turned to Green

It should automatics install MySQL Service and auto-start at computer start up or reboot.
Now just click the X to exit.

5. If MySQL Servive is running, then you can start MySQL Administrator and it will prompt up a window. Just fill in Host Name and Username and leave other field as it is but to make sure everything is correct, it should look like this...
---------------------------
Stored Connection: just leave it empty
Server Host: localhost
Username: root
Password: leave it empty because there is no password
Port: 3306
---------------------------
Click OK and you should be in MySQL Administrator now.

Go to User Administration and look to your left and little below, which you should see root. Click the user root and check to your right and fill in Password: and Confirm Password: fields with a new password for root.
Now click Apply changes to save the settings.

Click New User and enter this...
-----------------------------
MySQL User: ragnarok
Password: ragnarok
Confirm Password: ragnarok
-----------------------------
When you are done, then just click Apply changes and exit MySQL Administrator.

6. Start MySQL Control Center and it will prompt up Register Server Window at first time.
Fill in this...
---------------------------
Name: ragnarok
Host Name: localhost
User Name: root
Password: use the root password you created in "MySQL Administrator"
---------------------------
Click Add when you are done.

You will see Ragnarok Server to your left so, double click it to expands and double click Databases to expand. You should have mysql and test databases but it's nothing you need to pay in mind.

Right-click Databases, choose New Database, type in ragnarok and click OK. Do the same again and add log. We should have log and ragnarok databases now.
Right-click ragnarok database and choose Connect so the cylinder thing turn Green. Do the same with log database.

Click the SQL icon in meny (make sure ragnarok database is highlighted first by clicking it once) and it will prompt up a Query Window.

We need to execute main.sql, mail.sql and log.sql (execute upgrade .sql files too) so, click the File -> Open in meny and look for the main.sql, which should be in sql-files folder in eAthena Server and other .sql files.

Open main.sql in Query Window and you will see this ! icon turn red in meny so, you can execute by clicking this icon.
Wait until it's all executed, then do the same with mail.sql, log.sql and some upgrade .sql files.
When you are done, you should have all tables installed so, just close the Query Window

Double-click ragnarok database to expand and right-click Tables and choose Refresh. Now double-click Tables to expand so you can see all tables.

Double-click login table and you will have 15 Server Accounts from 1-15 but we only need the first one (account_id 1) so, edit the first line. Just double-click the cell you want to edit and it will auto save when you click this cell again, other cell or outside.
userid: s1 and user_pass: p1, we need to change it to same as in your char_athena.conf and map_athena.conf

Login table store/save all players accounts so, we can add a GM account while we are there.
Right-click within login table to bring up a meny and choose Insert Record. Enter 704554 as your account_id or any number that is higher. For user_id and user_pass, enter anything you want, which you use to login ingame. Sex is for gender.
-----------------
M = Male
F = Female
S = Server
----------------
In Email column... just enter your e-mail if you want to be able to delete character.
In Level column... enter 99 or any GM level you want to be.
Click X to close login table.

Look a bit down until you see User Administration and then double-click it to expand.
Right-click @localhost and choose Edit User. Now fill in this...
---------------------------
Username: ragnarok
Host: localhost
Password: ragnarok
---------------------------
Look a bit to your right and check in ragnarok database and check in All Privileges... do the same with log database. When done, just click Add and you should have ragnarok@localhost.

7. Now we are done with MySQL and everything should run fine.
 
Back
Top