Jump to content
  • 1

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


cassiel

Question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  12
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

Make GM Account in your Ragnarok SQL Server

 

  • We need have free in-game account, that stored in `login` table in your MySQL Database.
  • Open this `login` table and wi will see next:
    • `account_id` , `userid` , `user_pass` , `sex` , `email` , `group_id`

Yes, `group_id` is what we need. This column stores numerical arguments, that define users in-game rights.

Simple mask: 0 - Simple User; 1 - Super User; 5 - Premium User; X - ......; 99 - Head Game Master (Administrator)

Also you can check this file. There you can find all information about groups, IDs, permissions and other.

 

Btw, if you want to know anymore, i suggest you start new topic, because this is only (i think) tutorial, w/o support, because many users leave this...

 

If players need any new user-friendly guide, i can make it and explane steps by steps all manipulations ;)

Thanks a lot, Phenomena!

Well, I really need some guides, this is the first time doing this!

I have a few questions. Can I ask you some?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  94
  • Reputation:   4
  • Joined:  10/31/12
  • Last Seen:  

Ofcouse, feel free to ask, in forum support section or in PM.

Edited by Phenomena
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  12
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

Where can I find the correspondents diffs files?

And I can't see any equipment, weapon, etc.

 

All of them are a apple (unknown item).

 

What should I do?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  94
  • Reputation:   4
  • Joined:  10/31/12
  • Last Seen:  

Use ShinsDiffPatcher. Just open in DiffPatcher exe, and follow steps on picture below:

diffing.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  12
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

Something strange is happening!

rv7q.jpg


Something strange is happening!

rv7q.jpg

I really don't know whats happening.

When I created my first server, everything was alright. But now, I've repeated all the steps and i'm still having the same error.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  3
  • Reputation:   0
  • Joined:  03/13/14
  • Last Seen:  

I got the game running i think at 100% since i leveled a sura on 5x xp with no problems.

 

But now i face a problem where i don't have this NPC for eden group quests 100 and above.

 

 Gelkah (moc_para01 37,95) located inside the first room on the left behind the blue access door located in the north east corner of Eden Group.

 

Can anyone help me install this NPC and get all quests running?

 

Thanks in advance.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  281
  • Reputation:   14
  • Joined:  10/14/13
  • Last Seen:  

Something strange is happening!

rv7q.jpg

Something strange is happening!

rv7q.jpg

I really don't know whats happening.

When I created my first server, everything was alright. But now, I've repeated all the steps and i'm still having the same error.

Well i guess, you entered something wrong in your loki.ini...

Btw, can you show to us your loki.ini? Maybe i can help :)

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  12
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

j0ll.jpg

Look. It's everything right.

 

I was looking here for one answer, and someone said that the problem is with the MySQL user and password, but here they are all the same.

Edited by gszklo
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  281
  • Reputation:   14
  • Joined:  10/14/13
  • Last Seen:  

put .exe at the end of your patched RagExe

so it goes like this
 

EXE = 2013-03-20eRagexe_patched.exe

Edited by Ares
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  240
  • Reputation:   40
  • Joined:  04/27/13
  • Last Seen:  

put .exe at the end of your patched RagExe

so it goes like this

 

EXE = 2013-03-20eRagexe_patched.exe

This is correct. But you can also diff 2013 client so that you can run it without using launcher like loki

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   0
  • Joined:  12/22/12
  • Last Seen:  

Hello, i got this problem, please help me. 
 

: Access denied for user 'root'@'localhost' (using password: YES)
[Debug]: at ..\src\login\loginlog_sql.c:110
 
Login-Server has terminated abnormally.
Restarting in 15 seconds, press Ctrl+C to cancel.


############################################

all information user & password i wrote same as the guide.
btw, i'm new in MySql. and, i'm using MySql version latest, not same as the picture shown. Please fix me!

############################################
 

46731_t10.jpg

Edited by ro4peace
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  281
  • Reputation:   14
  • Joined:  10/14/13
  • Last Seen:  

Hello, i got this problem, please help me. 

 

: Access denied for user 'root'@'localhost' (using password: YES)
[Debug]: at ..\src\login\loginlog_sql.c:110
 
Login-Server has terminated abnormally.
Restarting in 15 seconds, press Ctrl+C to cancel.

############################################

all information user & password i wrote same as the guide.

btw, i'm new in MySql. and, i'm using MySql version latest, not same as the picture shown. Please fix me!

############################################

 

46731_t10.jpg

 

Hello!

kindly double check your password in MySql... maybe you entered a wrong password in MySQL that's the reason why it gave you an error like that

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  10
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

RATHENA WORKBENCH!

23:07:00 CREATE TABLE IF NOT EXISTS `skillcooldown` (   `account_id` int(11) unsigned NOT NULL,   `char_id` int(11) unsigned NOT NULL,   `skill` smallint(11) unsigned NOT NULL DEFAULT '0',   `tick` int(11) NOT NULL,   KEY `account_id` (`account_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec

 

 

this is also in

logs MYSQL WORKBENCH!

 


23:09:20 CREATE TABLE IF NOT EXISTS `picklog` (   `id` int(11) NOT NULL auto_increment,   `time` datetime NOT NULL default '0000-00-00 00:00:00',   `char_id` int(11) NOT NULL default '0',   `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','$') NOT NULL default 'P',   `nameid` int(11) NOT NULL default '0',   `amount` int(11) NOT NULL default '1',   `refine` tinyint(3) unsigned NOT NULL default '0',   `card0` int(11) NOT NULL default '0',   `card1` int(11) NOT NULL default '0',   `card2` int(11) NOT NULL default '0',   `card3` int(11) NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   `map` varchar(11) NOT NULL default '',   PRIMARY KEY  (`id`),   INDEX (`type`) ) ENGINE=MyISAM AUTO_INCREMENT=1 Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec

 


why i get this when I pressed the LIGHTNING BUTTON? any1 help me?

Edited by pookedandy
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  4
  • Reputation:   0
  • Joined:  02/14/14
  • Last Seen:  

CAN ANYONE HELP ME THIS IS THE ERROR I ENCOUNTER.. I WILL APPRECIATE ALL YOUR REPLY THANK YOU VERY MUCH...post-24102-0-51802300-1395906071_thumb.jpgpost-24102-0-68955800-1395906113_thumb.jpg

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  18
  • Reputation:   0
  • Joined:  02/12/14
  • Last Seen:  

RATHENA WORKBENCH!
23:07:00 CREATE TABLE IF NOT EXISTS `skillcooldown` (   `account_id` int(11) unsigned NOT NULL,   `char_id` int(11) unsigned NOT NULL,   `skill` smallint(11) unsigned NOT NULL DEFAULT '0',   `tick` int(11) NOT NULL,   KEY `account_id` (`account_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec
 
 
this is also in
logs MYSQL WORKBENCH!
 
23:09:20 CREATE TABLE IF NOT EXISTS `picklog` (   `id` int(11) NOT NULL auto_increment,   `time` datetime NOT NULL default '0000-00-00 00:00:00',   `char_id` int(11) NOT NULL default '0',   `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','$') NOT NULL default 'P',   `nameid` int(11) NOT NULL default '0',   `amount` int(11) NOT NULL default '1',   `refine` tinyint(3) unsigned NOT NULL default '0',   `card0` int(11) NOT NULL default '0',   `card1` int(11) NOT NULL default '0',   `card2` int(11) NOT NULL default '0',   `card3` int(11) NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   `map` varchar(11) NOT NULL default '',   PRIMARY KEY  (`id`),   INDEX (`type`) ) ENGINE=MyISAM AUTO_INCREMENT=1 Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec
 
why i get this when I pressed the LIGHTNING BUTTON? any1 help me?

 

"Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar." I think you just need to do as it says.

CAN ANYONE HELP ME THIS IS THE ERROR I ENCOUNTER.. I WILL APPRECIATE ALL YOUR REPLY THANK YOU VERY MUCH...

Please update your data/luafiles514 folder here: https://subversion.assembla.com/svn/client-side-translation/. What is your client's version?

Edited by ngoclong19
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  03/27/14
  • Last Seen:  

Hello, thanks for the guide, is really usefull and I apreciate it but i have this error n hope someone could help me fix it...

4x0x.png

 

 

I dont know why it sais that table logs.loginlog doenst exist cause i already did the step 12. Also i think my login db has the correct communication user name and password and sex is set to S and the "1" thing is also done so... i dont know what can be causing the error... please help

thanks :3

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  03/26/14
  • Last Seen:  

I've gone through many guides, help threads, and have checked my files many times but I am stuck. I keep getting either rejected from the server, rejected from server (3) or disconnected from server. I have tried client .exe versions 20130807 (ver:45), 20130703 (ver:42), 20130522 (ver:36), and most recently 20120410 (ver:30). Each time i change the version in mmo.h, clientinfo, packet_db and recompile it each time. The server seems to have a similar response to me logging in so maybe someone who knows what it means can help. I want to attach a picture but this is my first time posting on this forum and I hope it works.

 

yXmGXBG.png

 

I originally used xdiffpatcher, then weediff (shin's diff patcher) then NEMO but its always the same problem. One thread said to use skippacketheaderobfuscation and I have it in weediff but it only shows up for clients before 2013. I was able to diff 20120410 with skip obduscation but that didn't work either.

 

Edit:

I was able to log in by making a new account from the login screen (I was using the account I made in mysql which wasn't working)

 

Now I have to solve why I still have korean item names... (I'll look around the forum before begging for help :P)

 

Edit 2:

I seem to have been able to fix the english items after working through a few more diff configurations through NEMO. I'm using 20130807

 

Now I'm trying to figure out how to use the setup.exe or opensetup.exe to make the screen resolution larger or full screen. When ever I try to use it nothing happens or it tells me it can't make the file/ access denied. Could someone please tell me how to use either of those files correctly, I'm kind of at a loss. Otherwise does anyone know what files I should alter manually to get the display the way I want it?

 

Edit 3:

After lots and lots of testing and changing settings I finally was able to change the opensetup.exe settings and have them stick. I am finally playing on a bigger resolution than 640x480... (using resolutions from the 80s and 90s on our screens today sucks, I just wish it had more advanced options like 32bit color :P)

It was quite a simple fix, I just looked at the opensetup changelog and saw where it was hanging up, then i moved the problem files to another location to test it and it remade a new file.

 

These were all the problems I was working with at this time, so I think I can close my entry on this thread. All in all It was pretty stressful to probably spend more than 40 hours this week trying to make the server work properly... (I have no life)

Edited by wiccawest
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  12
  • Reputation:   0
  • Joined:  05/31/13
  • Last Seen:  

Hi,

I have  win7 x64 system.

I use 2013-06-05 client without problems.

After this, ALL patched clients are crashed (I tried lots of different variations); the newest is the 2014-02-12aRagexe in SAME environment.

I use NEMO-master patcher, but tried others also.

The client and the server are updated, but the korean rsu link does not work for a long time.

 

Thus, I suppose that, the problem is in the unpacked clients or in the NEMO patcher.

If I run the client in the XP SP3 environment as Windows suggested, it is not crashed but miss the System/Iteminfo lub, but it exists... (I read this error on Hercules forum before).

If I run the NEMO-master patcher in XP SP2 environment as the Windows suggested, but the patcher can not find  owned Patches directory but it is exists also, of course...

 

Any idea?

Thanks in advance

Edited by venemberke
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  03/26/14
  • Last Seen:  

I also have win7 x64. Try using the latest packet_db version before trying the latest ragexe/diff release.  I'm using the last version I could find that was publicly released (2013-08-07 /version 45) and it took me a week to get it to work.

 

As for using the right configuration diff, I have no idea how to help you. It was a crap shoot and I never saved the setup, sorry.

 

The main things to do to get the 20XX-XX-XXRagexe.exe to work is to look up in your server file db/packet_db.txt for the matching date. Change (packet_db_ver:) at the top of the file. Next find mmo.h in src/common/mmo.h and find the lines

#ifndef PACKETVER
    #define PACKETVER 20XXXXXX

at the top of the file. replace 20XXXXXX with the date of your ragexe file (remove the - between the day month and year).

 

Next go back to the main server folder and open rAthena-10.sln with visual c++ and clear the files then build them again.

 

Go to your client/data/clientinfo.txt and change the number between <version></version> to the number in the packet_db.txt file

 

If you aren't up to that point yet, please gather all the files this guide requires and start from the beginning, because I have no way of explaining that to you :P.

 

I noticed I don't need to use a program like loki or ROLex to launch the .exe and I also had to make a new account through the client by adding _F or _M after the user name you want. No matter how much I tried to use the one I made in MySQL it wouldn't work.

 

Most of the stuff I said I have found many times on this forum except for the personal troubleshooting I had to do which is in bold.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  10
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

What you mean sir you don't need LOKI? so I will not download the LOKI?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  240
  • Reputation:   40
  • Joined:  04/27/13
  • Last Seen:  

If you are using 2013 ragexe client you can diff it using nemo patcher so you can run the client directly without using launcher like loki, thor, rocred and others

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  10
  • Reputation:   0
  • Joined:  03/14/14
  • Last Seen:  

@themon

 

I saw your 2014 client but still no luck , the 2013 offline server is  always error ,4 weeks debugging the errors  and still can't play and no Idea how to create this offline server .. 20x debugging the 2013 client >.< no luck at all...

 

any1 help me.... !

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  240
  • Reputation:   40
  • Joined:  04/27/13
  • Last Seen:  

First download ragnarok from this site http://ratemyserver.net/index.php?page=download_kROLinks

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  04/05/14
  • Last Seen:  

Hiii.. please help me i cannot load xdiff file. 

 


I cannot load diff file in diff patcher ..please help me out /sob

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  03/27/14
  • Last Seen:  

Hello, thanks for the guide, is really usefull and I apreciate it but i have this error n hope someone could help me fix it...

4x0x.png

 

 

I dont know why it sais that table logs.loginlog doenst exist cause i already did the step 12. Also i think my login db has the correct communication user name and password and sex is set to S and the "1" thing is also done so... i dont know what can be causing the error... please help

thanks :3

any help¿ D:

Link to comment
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.   Paste as plain text instead

  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.

×
×
  • Create New...