[Tutorial] How to Create Ragnarok Offline 2013 client [Tutorial]

[cassiel]

Hello guys!! This is my first time to write a tutorial.
I hope it can help many beginner that don't know how to create your own ragnarok world.
This server setting is just made to play offline. So if you want to make your own private server there are several things you need to learn more on setting ip, opening ports etc, and i'm not going to explain it in here
 
 
Credits goes to:
Nickyzai for kRO client
K3dt for decompiled ragexe
Mleo1 for Loki launcher
Shakto, Yommy, MStream for xDiffPatcher
Michieru, Dastgirpojee for Data folder translation
Magicaltux for Grf Builder

Ai4rei for Open Setup

Okay let's get started, please follow all the steps
correctly!
 
This is all the things you need to create your own
ragnarok world:
1. TortoiseSVN - http://tortoisesvn.net/downloads.html
2. Visual Basic - http://www.microsoft.com/visualstudio/eng/products/visual-studio-express-products
3. MySQL - http://dev.mysql.com/downloads/installer/
4. MySQL Workbench 5.2.47 http://dev.mysql.com/downloads/tools/workbench/
5. rAthena SVN Repository - https://rathena.svn.sourceforge.net/svnroot/rathena/
6. kRO client by nickyzai - http://www.nickyzai.com/?p=kro
7. Loki Launcher by mleo1 - http://hercules.ws/board/topic/1070-loki-launcher/
8. Decompiled ragexe by k3dt - http://k3dt.eu/Ragexe/unpacked/
9. xDiffPatcher v2 - http://www.mediafire.com/?fibc47gzvdshp8o
10. DiffFiles - http://k3dt.eu/Ragexe/unpacked/Diffs/
11. Data folder translation - https://subversion.assembla.com/svn/client-side-translation/
12. Grf Builder - http://www.grfbuilder.com/#download
13. RO Open Setup - http://rathena.org/board/topic/63177-ro-open-setup-v280277-last-updated-20130702/

After you download all that things, do this:
1. Install tortoise
2. Install visual basic
3. Install MySQL (please remember your root password! If you change it but if you did not change then the default root password is ‘root’)
4. Install MySQL Workbench
5. Install kRO client
 
After you install all of that, let’s prepare the
client:
 
1. Open your kRO client and update it until completed.
 
2. Download your ragexe file in this (http://k3dt.eu/Ragexe/unpacked/) In this tutorial i used 2013-07-03aRagexe.exe
 
3. Download your xDiffFiles in this (http://k3dt.eu/Ragexe/unpacked/Diffs/)
in this tutorial I used 2013-07-03aRagexe.exe so I must download the same date for Diff files which is “Diff 2013-07-03 v1”
in order the xDiffPatcher to work.
 
4. Open your xDiffPatcher.exe select your ragexe
file you download before which is I used (2013-07-03aRagexe.exe) and then
select your Diff files which is I used (Diff 2013-07-03 v1) and click LOAD.
 
Now look in “diff option” there are several choice to
pick, I recommended you to check this option:
 

- Disable  Ragexe Filename Check
- Disable HShield
- Disable Packet Encryption
- Enable Multiple GRFs
-@ Bug Fix
- Ignore Missing File Error
- Ignore Missing Palette Error
- Increase Headgear ViewID to 5000
- Increase Zoom
- Load ItemInfo.lua before lub
- Read Data Folder First
- Read msgstringtable.txt
- Read questid2display.txt
- Translate Client In English
- Use Normal Guild Brackets
- Use Ragnarok Icon
- eXtract MsgStringTable.txt
- eXtract txt file strings
 

After you finish check the option click Diff’n’Save!
Move the patched ragexe you made to your kRO client folder

5. Open the loki launcer folder and right-click
loki.ini, change this:
 

 

; Must be on same dir of Loki

Exe = "ragexe.exe"

Into

; Must be on same dir of Loki

Exe = "2013-07-03aRagexe_patched.exe" (I
change into 2013-07-03aRagexe_patched.exe because I patched my
2013-07-03aRagexe.exe. if you use another ragexe please changed into yours)
 

Save it and move all of file in loki launcher folder
into your kRO client folder.

6. Create new folder and name it ‘Data Folder Translation'

right-click on ‘Data Folder Translation’ folder and choose ‘SVN checkout…’
Fill this link https://subversion.a...de-translation/ in “url of repository” and click ok,

this will download your 'data translation folder' from latest revision.  After complete click ok.

 

Open your data translation folder you download before then open folder “data” right click clientinfo.xml and choose edit.

 

Edit into your version, I’m changed it into 38 because I used 2013-07-03aRagexe.exe.
You can find your version in folder Server\trunk\db\packet_db.txt

 

note: If you can’t find clientinfo.xml just open notepad
and copy code below to your notepad and save it as clientinfo.xml
 

<?xml version="1.0"
encoding="euc-kr" ?>
<clientinfo>
<servicetype>korea</servicetype>
<servertype>primary</servertype>
<connection>
<display>Ragnarok</display> 
<balloon>Ragnarok</balloon>    
<desc>Ragnarok</desc>     
<address>127.0.0.1</address>     
<port>6900</port>     
<version>38</version>     
<langtype>0</langtype>     
<registrationweb></registrationweb>     
<aid>
              <admin></admin>        
<yellow></yellow>
      </aid>  
</connection>
</clientinfo>
 

7. Open your grfbuilder click ‘new’ to create grf, name it to rathena and save it, then choose ‘merge dir’ find your data translation folder
you download before. And then choose the folder ‘data’ inside data translation folder then click Ok. wait after complete. click close. Move
the rathena.grf you’ve made to kRO client folder.

 

8. Now change all lua extension to lub extension in your data translation folder you've download
place this script in your data translation folder data/luafiles514 folder And run it.
Script Link:

http://www.mediafire.com/download/jvtac0j8f6m604v/luatolub.bat
 

note: rename 'luatolub.bat.txt' into 'luatolub.bat and double click (to run) it.

 

After you done. Copy the 'data' and 'system' folder inside the data translation foder you've download to your kRO client and replace any same files with that.

 

9. Edit your DATA.ini in your kRO client folder into this:

[Data]
0=rathena.grf
1=data.grf
2=rdata.grf
 

Then save it.

 

note: If you can’t find DATA.ini just open notepad
and copy code up there to your notepad and save it as DATA.ini

 

10. Extract the 'Open Setup' you've download before and move the 'opensetup.exe' into your kRO client folder

Now your kRO client is ready.
 

Now for the Server

1. Create new folder and name it ‘Server’

2. right-click on ‘Server’ folder and choose ‘SVN checkout…’

3. Fill this link (https://rathena.svn.sourceforge.net/svnroot/rathena/)
in “url of repository” and click ok, this will download your server files from latest
rathena server. After complete click ok.

4. Open Server\trunk\conf then rename ‘import-tmpl’ folder into ‘import’

5. Open Server\trunk\conf  open file ‘char_athena.conf’ with notepad and
look for this:

 

// Server Communication username and password.
userid: s1 (change ‘s1’ to whatever you want but here I use ‘username’ as userid for tutorial only)
passwd: p1 (change ‘p1’ to whatever you want but here I  used ‘password’ as password)

 

*note: I suggest you to fill the username and password as I do, to prevent human error, because if you put wrong userid and
passwd the server connection between login and map can’t be establish.
 

//login_ip: 127.0.0.1 (REMOVE THE ‘//’ IN FRONT OF login_ip: 127.0.0.1 so it will look like this login_ip: 127.0.0.1)
 

 

//char_ip: 127.0.0.1 (REMOVE THE ‘//’ IN FRONT OF char_ip: 127.0.0.1 so it will look like this char_ip: 127.0.0.1)
 

Once you done save it.

6. Still in Server Server\trunk\conf now you open file ‘inter_athena.conf’ with notepad and search for all of this:

 

sql.db_username: ragnarok (change ‘ragnarok’ into your MySQL username which is I use default ‘root’)
sql.db_password: ragnarok (change ‘ragnarok’ into your MySQL password which is I use default ‘root’)
sql.db_database: ragnarok (change ‘ragnarok’ into ‘rathena’ because later we make database using name ‘rathena’)

char_server_id: ragnarok (change ‘ragnarok’ into ‘root’)
char_server_pw: ragnarok (change ‘ragnarok’ into ‘root’)
char_server_db: ragnarok (change ‘ragnarok’ into ‘rathena’)

map_server_id: ragnarok (change ‘ragnarok’ into ‘root’)
map_server_pw: ragnarok (change ‘ragnarok’ into ‘root’)
map_server_db: ragnarok (change ‘ragnarok’ into ‘rathena’)

log_db_id: ragnarok (change ‘ragnarok’ into ‘root’)
log_db_pw: ragnarok (change ‘ragnarok’ into ‘root’)
log_db_db: ragnarok (THIS ONE YOU CHANGE INTO ‘logs’ because later we make database ‘logs’
 

Once you’ve done SAVE it.

7. Still in Server Server\trunk\conf now you open file ‘map_athena.conf’ with notepad and search for:

 

// Interserver communication passwords, set in account.txt (or equiv.)
userid: s1 (Change ‘s1’ into ‘username’ because  as I explain on up there before)
passwd: p1 (Change ‘p1’ into ‘password’ because as I explain on up there before)

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
//char_ip: 127.0.0.1 (Remove the ‘//’)

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
//map_ip: 127.0.0.1 (Remove the ‘//’)
 

Done and Save it.

8. Still in Server Server\trunk\conf now you open file ‘subnet_athena.conf’ with notepad and change this:

 

subnet: 255.0.0.0:127.0.0.1:127.0.0.1

 

you must find your subnet by opening ‘command prompt’
(start menu > all programs> accessories> command prompt)

after you open your command prompt, type this ‘-ipconfig’
it will look like this

 

9. Open your MySQL Workbench double click on ‘Local instance MySQL’ as in the picture to open. Input your password which is ‘root’
if you haven’t change it on first time you install it.



10. Click on ‘Create new Schema’ just like on the pic below to create new ‘schema’ and name it ‘rathena’ then click ‘apply’ and
then ‘apply’ and ‘finish’. Now close and reopen your MySQL workbench.



11. repeat the step 10 but name the schema as a ‘logs’ then click ‘apply’ and then ‘apply’ and ‘finish’. Now close and reopen your
MySQL Workbench.

 

12. Enter again to you ‘Local instance MySQL’ just like the step 9 and double click on ‘rathena’ to select it, and then click ‘file’
and choose ‘Open SQL Script’ and go to rAthena\trunk\sql-files and open ‘main.sql’ click OPEN and click the ‘Lightning button’ on picture below. Wait until its done and close your MySQL Workbench and Open it again to refresh.

 

repeat step 12 but now you 'Open SQL Script’ and go to rAthena\trunk\sql-files open 'logs.sql' click OPEN and click the ‘Lightning button’ on picture below. Wait until its done and close your MySQL Workbench and Open it again to refresh.

 

13. After you re-open your MySQL Workbench, double click on ‘rathena’ then double click on ‘table’ and find ‘login’ right click on it and choose ‘Select Rows – Limit 1000’ just like the picture below:



14. Change the ‘s1’ and ‘p1’ on the right table to ‘username’ and ‘password’ by double click on each of them and type it. Just like the
picture below, when you done click ‘apply’ then ‘apply’ and ‘finish’

 

15. Now Open folder Server\trunk\src\common and right-click mmo.h choose edit and search this line

#define PACKETVER YYYYMMDD
 

Change it with the date version you choose for your client before

Example:

#define PACKETVER 20130703
 

(My client ragexe is 2013-07-03aRagexe.exe that’s why I write 20130703)
And save it.

15. Now let’s recompile your server, open Server\trunk\ right-click ‘rAthena-10.sln’ open with Microsoft Visual c++

 

16. Change the ‘debug’ into ‘release’ like the picture below.

 

17. Block (select) char-server.sql, login-server.sql, map-server.sql, mapcache and then right click and choose ‘build selection’ like in the picture below:

 

18. Go to your Server\trunk\db and open file ‘packet_db.txt’ with notepad and add this line in bottom

 

//2013-07-03 Ragexe
packet_ver: 38
0x0369,7,actionrequest,2:6
0x083C,10,useskilltoid,2:4:6
0x0437,5,walktoxy,2
0x035F,6,ticksend,2
0x0930,5,changedir,2:4
0x07E4,6,takeitem,2
0x0362,6,dropitem,2:4
0x07EC,8,movetokafra,2:4
0x0364,8,movefromkafra,2:4
0x0438,10,useskilltopos,2:4:6:8
0x0366,90,useskilltoposinfo,2:4:6:8:10
0x096A,6,getcharnamerequest,2
0x0368,6,solvecharname,2
0x0838,12,searchstoreinfolistitemclick,2:6:10
0x0835,2,searchstoreinfonextpage,0
0x0819,-1,searchstoreinfo,2:4:5:9:13:14:15
0x0811,-1,reqtradebuyingstore,2:4:8:12
0x0202,6,reqclickbuyingstore,2
0x0817,2,reqclosebuyingstore,0
0x0815,-1,reqopenbuyingstore,2:4:8:9:89
0x0365,18,bookingregreq,2:4:6
// 0x0363,8 CZ_JOIN_BATTLE_FIELD
0x0281,-1,itemlistwindowselected,2:4:8:12
0x022D,19,wanttoconnection,2:6:10:14:18
0x0802,26,partyinvite2,2
// 0x0436,4 CZ_GANGSI_RANK
0x0360,26,friendslistadd,2
0x094A,5,hommenu,2:4
0x0873,36,storagepassword,2:4:20
 

If you choose another date of your ragexe you can find your ‘packet’ in this link

http://rathena.org/board/topic/82726-2013-ragexe-and-diff-up-to-date-2013-07-03/
 

Just copy and paste it to your ‘packet_db.txt’ like I did.

19. Now you are ready to start your server, open rAthena\trunk and open file ‘runserver-sql.bat’ wait until all server loaded like the pic
below:



20. Now go to your kRO client Folder and open ‘Loki.exe’ in the login screen you can create account by doing this;

In ID you can fill your ID with _M for male and _F for female



And then input your password, After that you may login to your id without _M or _F anymore.

 

21. Some Screenshoot in the game

 

I think that's all guys. sorry for any mistake and good luck creating your own Ragnarok World

don't forget to clik the button if you found this post useful and thx for reading this bad tutorial

________________________________________________________________________________________________________

Note: only do this step if you found the problem below.

Problem 1:

setup resolution problem: there is missing file in kRO client\system\lua514\ that file name is optioninfo.lub

you may download from here and put on that folder.

 

Problem 2:

'queryNavi_Distance_Map' problem: go to Data Folder Translation\Data\luafiles514\lua files\navigation then deleted the file below:

navi_linkdistance_krpri.lub

navi_linkdistance_krsak.lub

navi_npcdistance_krpri.lua

navi_npcdistance_krsak.lua

_________________________________________________________________________________________________________

edited :

- adding missing step in client

- adding new file Open Setup from Ai4rei

- adding missing step in server (repeat step 12 but now you 'Open SQL Script’ and go to rAthena\trunk\sql-files open 'logs.sql' click OPEN and click the ‘Lightning button’ on picture below. Wait until its done and close your MySQL Workbench and Open it again to refresh.)

- fixing some step in client about grf builder because if change lua to lub first then merge give error query_navi_map but don't worry now the step are correct.

- adding missing step about downloading 'data translation folder' from repository link

- fix some unclear words and fix the repository link.

- deleted fixcamera angle from patch list because for shift right click issue, and add some note about setup resolution problem

- fix xdiff files link

Edited August 5, 2013 by cassiel

[Evelynn]

 

hi sir/maam, can you tell and explain to me of what im going to do with this. my mind is completely blown up. i follow every step already   

 

 

casanova, if you read your console messages, it tells you.

 

Set your map_athena.conf // char_athena.conf server user and password and make sure they match with your database's server username / pw in your login table.

 

By default it's s1 and p1, but in your case, your database server user and pw do not match.

Edited May 30, 2014 by Evelynn

[casanova]

 

hi sir/maam, 

 

how to fix this?., i use the username i put at the database and also from the tutorial which is user:as, pass:as... thanks in advance

Edited May 31, 2014 by casanova

[Airi]

 

 

hi sir/maam, 

 

how to fix this?., i use the username i put at the database and also from the tutorial which is user:as, pass:as... thanks in advance

 

See post #561 

[Eyce]

I'd like to ask about the MySQL used on the tutorial. When I installed mine, it automatically installed the latest version which I awkwardly have no idea on using. Anyway, I've downloaded the MySQL Workbench 5.2.47 but it's asking me to connect to something first before creating a database. It defaulted 127.0.0.1:3306 for the I.P. address and port, and it doesn't work. Can someone enlighten me on how to configure this? Thank you!

[Winz]

I'd like to ask about the MySQL used on the tutorial. When I installed mine, it automatically installed the latest version which I awkwardly have no idea on using. Anyway, I've downloaded the MySQL Workbench 5.2.47 but it's asking me to connect to something first before creating a database. It defaulted 127.0.0.1:3306 for the I.P. address and port, and it doesn't work. Can someone enlighten me on how to configure this? Thank you!

 

Eyce, I'm not sure which version you have installed either. MySQL Server, it said? make sure it's running (open the workbench, then connect to 127.0.0.1:3306 through the administration section)

[Airi]

Well.. can anyone please explain to me, why this is happen?

 

Edited June 4, 2014 by Airi

[adri0071324]

i am also experiencing the same errors

i am also experiencing the same errors please help me

[Jerhia]

@Airi

 

Check Here: http://rathena.org/board/topic/88847-forbidden-to-wear-the-state-cannot-be-worn/

 

@adri0071324

 

Check Here: http://rathena.org/board/topic/82721-2012-04-10aragexe-client-weediff-plugins-please/

[Airi]

honestly.. I don't fully understand what are they talking in there.. 

but it seems they talk about custom item..

well.. I never messing up the database, I just leave it as original. 

so I dunno what I'm supposed to do if already talk about inside the database.. 

 

well, this error only happens sometime though.. 

when I got the new shield it can be equip normally.. (good thing if you are the GM)

I just curious why this error happens to me while I'm never edit my item database. 

[Winz]

Well.. can anyone please explain to me, why this is happen?

 

  

@Airi

 

Check Here: http://rathena.org/board/topic/88847-forbidden-to-wear-the-state-cannot-be-worn/

 

@adri0071324

 

Check Here: http://rathena.org/board/topic/82721-2012-04-10aragexe-client-weediff-plugins-please/

  

honestly.. I don't fully understand what are they talking in there.. 

but it seems they talk about custom item..

well.. I never messing up the database, I just leave it as original. 

so I dunno what I'm supposed to do if already talk about inside the database.. 

 

well, this error only happens sometime though.. 

when I got the new shield it can be equip normally.. (good thing if you are the GM)

I just curious why this error happens to me while I'm never edit my item database.

No, my bad.

Take a look at the item name there. It's colored red. It means you've overused it (the shield is broken, durability: 0). Simply go to a repair NPc or @repair, maybe? Repair npcs are on the forging station of every town

[adri0071324]

@Jerhia You have saved my life .. its working ..

why is that everytime i logged in theres an error message rejected from server

[Jerhia]

Glad to hear that!   

why is that everytime i logged in theres an error message rejected from server

 Check clientinfo.xml inside your data. Make sure the IP you put in there is the same as you put in char_athena.conf and map_athena.conf.

[adri0071324]

what ip my ip on whatismy.org or wan ip or localhost ?

[Jerhia]

For Test Server? If yes then you can use 127.0.0.1

[adri0071324]

@Jerhia

i have another error

 

http://rathena.org/board/topic/95567-db-error-unknown-column-slotchange-in-field-list/?p=258195

[Jerhia]

What server revision are you using?

[raflors]

hello guys, this is my first time to post here, its my 2nd day to reconfigure and i followed all whats in the tutorial at page 1 . same ragexe(2013-07-03), diff, configs as i copied thru the steps at page 1. kaso to no avail ganun padin. i got this following error... i read almost pages 1-10 but it aint fixed my problem...please do help, i already used my day off from work just to configure this hehe. please help....also anyone from manila here?

[SmartCaps]

help does not display the Russian language. 

Put <langtype> 0 </ langtype> -> <langtype> 14 </ langtype> does not go to the server 

sorry for bad english

problem solved 

diff -> selection [Use SSO login packet for all Langtype] and use <langtype> 14 </ langtype>

Edited June 15, 2014 by SmartCaps

[Vietlubu]

I cant access to MySql.

 

My SQL info: 
user: root

pass: (i dont user pass)

db: ragnarok

 

inter_athena.conf

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: 
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: 
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: 
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: 
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

[raflors]

i guess no one's online for help

[hendra814]

hello guys, this is my first time to post here, its my 2nd day to reconfigure and i followed all whats in the tutorial at page 1 . same ragexe(2013-07-03), diff, configs as i copied thru the steps at page 1. kaso to no avail ganun padin. i got this following error... i read almost pages 1-10 but it aint fixed my problem...please do help, i already used my day off from work just to configure this hehe. please help....also anyone from manila here?

update your sql database. 

[raflors]

 

hello guys, this is my first time to post here, its my 2nd day to reconfigure and i followed all whats in the tutorial at page 1 . same ragexe(2013-07-03), diff, configs as i copied thru the steps at page 1. kaso to no avail ganun padin. i got this following error... i read almost pages 1-10 but it aint fixed my problem...please do help, i already used my day off from work just to configure this hehe. please help....also anyone from manila here?

update your sql database. 

 

how?or is there any source for download?

[Jerhia]

hello guys, this is my first time to post here, its my 2nd day to reconfigure and i followed all whats in the tutorial at page 1 . same ragexe(2013-07-03), diff, configs as i copied thru the steps at page 1. kaso to no avail ganun padin. i got this following error... i read almost pages 1-10 but it aint fixed my problem...please do help, i already used my day off from work just to configure this hehe. please help....also anyone from manila here?

 

can you please paste here your inter_athena.conf? 

 

I cant access to MySql.

Access.PNG

 

My SQL info: 

user: root

pass: (i dont user pass)

db: ragnarok

 

inter_athena.conf

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: 
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: 
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: 
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: 
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

 

What do you mean by i dont user pass? You cannot use the SQL ID "root". You need to create another SQL Username/Password in the MySQL Administrator. 

 

inter_athena.conf sample:

// Global SQL settings// overridden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok
sql.db_database: rathenadb
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: rathenadb

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: rathenadb

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: rathenadb
log_codepage:
log_login_db: loginlog

[raflors]

 

hello guys, this is my first time to post here, its my 2nd day to reconfigure and i followed all whats in the tutorial at page 1 . same ragexe(2013-07-03), diff, configs as i copied thru the steps at page 1. kaso to no avail ganun padin. i got this following error... i read almost pages 1-10 but it aint fixed my problem...please do help, i already used my day off from work just to configure this hehe. please help....also anyone from manila here?

 

can you please paste here your inter_athena.conf? 

here..

 

// Athena InterServer configuration.

// Contains settings shared/used by more than 1 server.

// Options for both versions

// Log Inter Connections, etc.?

log_inter: 1

// Inter Log Filename

inter_log_filename: log/inter.log

// Level range for sharing within a party

party_share_level: 15

// SQL version options only

// You can specify the codepage to use in your mySQL tables here.

// (Note that this feature requires MySQL 4.1+)

//default_codepage:

// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1

// Under windows, you want to use 127.0.0.1.  If you see a message like

// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

// and you have localhost, switch it to 127.0.0.1

// Global SQL settings

// overridden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: root

sql.db_password: 1234

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: root

char_server_pw: 1234

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: root

map_server_pw: 1234

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: root

log_db_pw: 1234

log_db_db: logs

log_codepage:

log_login_db: loginlog

// MySQL Reconnect Settings

// - mysql_reconnect_type:

//   1: When MySQL disconnects during runtime, the server tries to reconnect

//      mysql_reconnect_count times and shuts down if unsuccessful.

//   2: When mysql disconnects during runtime, it tries to reconnect indefinitely.

mysql_reconnect_type: 2

mysql_reconnect_count: 1

// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL

// this is meant for people who KNOW their stuff, and for some reason want to change their

// database layout. [CLOWNISIUS]

// ALL MySQL Database Table names

// Char Database Tables

char_db: char

hotkey_db: hotkey

scdata_db: sc_data

cart_db: cart_inventory

inventory_db: inventory

charlog_db: charlog

storage_db: storage

reg_db: global_reg_value

skill_db: skill

interlog_db: interlog

memo_db: memo

guild_db: guild

guild_alliance_db: guild_alliance

guild_castle_db: guild_castle

guild_expulsion_db: guild_expulsion

guild_member_db: guild_member

guild_skill_db: guild_skill

guild_position_db: guild_position

guild_storage_db: guild_storage

party_db: party

pet_db: pet

friend_db: friends

mail_db: mail

auction_db: auction

quest_db: quest

homunculus_db: homunculus

skill_homunculus_db: skill_homunculus

mercenary_db: mercenary

mercenary_owner_db: mercenary_owner

elemental_db: elemental

ragsrvinfo_db: ragsrvinfo

skillcooldown_db: skillcooldown

bonus_script_db: bonus_script

// Map Database Tables

buyingstore_db: buyingstores

buyingstore_items_db: buyingstore_items

item_db_db: item_db

item_db_re_db: item_db_re

item_db2_db: item_db2

//item_db2_db: item_db2_re

item_cash_db_db: item_cash_db

item_cash_db2_db: item_cash_db2

mob_db_db: mob_db

mob_db_re_db: mob_db_re

mob_db2_db: mob_db2

//mob_db2_db: mob_db2_re

mob_skill_db_db: mob_skill_db

mob_skill_db_re_db: mob_skill_db_re

mob_skill_db2_db: mob_skill_db2

//mob_skill_db2_db: mob_skill_db2_re

mapreg_db: mapreg

vending_db: vendings

vending_items_db: vending_items

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)

use_sql_db: no

import: conf/import/inter_conf.txt

 

 

 

 

UPDATE: okay i reinstalled EVERYTHING... now my error is that..whenever i open LOKI launcher, and put the password for melo01...then nothing happens, no ragnarok exe pop up nor log in screen.....

[Jerhia]

Did you upload log.sql in your db sql? Paste here your loki.ini settings and clientinfo.xml. Also, try to right click your server.exe and run as administrator. Or better send your whole configuration to me via PM.

Edited June 20, 2014 by Jerhia