[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

[alvinjade]

fixed

Edited August 17, 2014 by alvinjade

[Outtasight]

I followed all the tutorial step-by-step. My server logs normally. But the problem is when I create the character. Shortly after creating the character, I click to enter the game and returns me the message: "Rejected From Server (3)"

 

Check your server windows (the ones that appear when you run the starting .bat file) and see what it says. I had the same problem, turn out something went wrong with the account I created for my GM in the database. Creating a new account with _M/_F solved it for me.

[qwertyu08]

Sir how to download the visual basic for windows 8.1 i cant find the compatible visual basic for my operating system thanks for the help and more power to all.

[shididiX21]

The guide is great. it actually worked and i got my server up running as well as the client. problem with me now is that i still got some of those korean characters and how do i exactly change the server from Renewal to pre-renewal?

[qwertyu08]

Got My Problem in running runserver_sql.bat

Edited August 14, 2014 by qwertyu08

[xSavageBeastx]

Thanks. Wonderful tutorial. Used to have my own online server 6 years ago and now I pretty much forgot everything about it. However, this was simple enough to help me get an Offline one going again. There were areas where I had to improvise though and do a little research on "Google" in order to make it work. It seems you have a few steps missing or areas that needed a tiny bit more clarity. 

Thanks again.

[xroute66x]

Am I the only one with this problem? :s

 

Does anyone know how to solve it?

Thanks

[alvinjade]

1.) the game is running fine but i noticed an error in the mapserver..

how do i fix this?

Edited August 23, 2014 by alvinjade

[elvenour]

I have an error just like this after executing loki launcher

 

or in korean (i dont know the meaning of it)

 

Im doing http://rathena.org/b...lient-tutorial/

as my guide.

 

Im using 2013-08-07 as my client.

 

My server runs fine.

 

What should i do?

 

Edited August 18, 2014 by elvenour

[reykobai21]

can any1 give me a working link of the xDiffFiles.. it seems the one on the first page isnt working... thanks

[mharcpogi]

how can i see the list of the account of my server? can you tell it, i want to edit the acc lvl xD

[simplexjay2]

Check if the one I posted above is the same as yours. Because I'm using r17704 and 2013-08-07a client also.

Jerhia Can i have your Grf and 2013-08-7 Diff list

[kunichiruu18]

i didn't get this step

 

 ----> 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

 

 

where can i find server\trunk\db\packet_db.txt?

 

please reply i really didn't get that step

[Hurt]

help me.. i want to install RO Offline again, i followed the tutorial step by step and i found this problem

 

 

 

i cant download iteminfo.lua, someone please reupload thats file thanks

Edited October 10, 2014 by Hurt

[Hazze1990]

Hi guys i need some help. I used this guide and i have a problem with the client.

[marry23]

hi guy pls help this is TUT for online or offline only ??? reply plssss

[actaeon123]

pls help. Rejected from server.

s aid has an incorrect version=0 in clientinfo. Server compiled for 42.

 

pls see the uploaded image for more details. I followed all of the steps properly though

 

[marry23]

@acaeon123 how can u change ur lua to lub ? i cant understand it ..  can teach me how to change it i have error it says " ITS SUCH NO FILE ON LUA somthing2 .. can u post a image ??? plsss help me 

[trungkingcb]

Plz, where i can download the later server rathena. Plzz help me, I am newbie

[cassiel]

wow its been so long since im back to this thread

 

im sorry guys for not responding to all of you

 

since this guide is old now. i hope you find another guide which is newer than this

 

requesting admin to lock this thread since im no longer support this thread

Edited October 31, 2014 by cassiel

[Jesusse]

cassiel, on 31 Oct 2014 - 09:13 AM, said:

wow its been so long since im back to this thread

im sorry guys for not responding to all of you

since this guide is old now. i hope you find another guide which is newer than this

requesting admin to lock this thread since im no longer support this thread

Hi cassiel cant you upload screen again plz all screen is down or you have the tutorial in pdf or word can you send me plz^^ [email protected] thanks

[harley]

This is my error.. what will i do?thanks

[aeronhyuwell]

pls link the visual studio 2013 free download 

[ejz372]

Can someone please help me. I did everything on the tutorial guide and for some reason I still can't connect. Here is the picture of the error I'm getting.

 

   

[imnoob]

bro/sis i try to make client now. but got problem.
im follow this link http://rathenaguides...agnarok_14.html
my rAthena svn server (map log and char) is running good but i cant login.

can u or someone help me ??

this attach the pic :

Edited April 17, 2015 by imnoob