[Help Thread] Please post your questions here.

Quote:

Originally Posted by Marschall83 According to my post before I have some questions which are more specific. Is there a overview which changes in server database must have a rdb resource file in client resource folder too (e.g. drop rates are server only I think)? I have a working client with no file in the folder resources. Why does it work?* *My explanation: the basic database scheme is hard coded in the client (maybe in the data files). Client resource files overwrite this hard codes schemes. You see I don`t understand the relationship between database and client changes. I found no guide which sorts this out (you can only search 1 your old threads). Thanks in advance.

If my experience with downgrading servers files can help just add me on discord and i show you few tips and tricks if u are interested

Quote:

Originally Posted by Marschall83 Is there a overview which changes in server database must have a rdb resource file in client resource folder too (e.g. drop rates are server only I think)?

Not really most people just start with dumping a client and exploring what files are in the dump.

Quote:

Originally Posted by Marschall83 I have a working client with no file in the folder resources. Why does it work?*

The client originally comes with only music files in the resource folder the rest are packed like archives in the data files. That's why it works.

Resourced files are like overrides and they take priority over what is in the data files thus a client can be edited without packing back into the data files.

There are some tools out that developers have worked on that also allow edited files to be packed back into the data files. Datacore defines these archives by reading data.000 which is the data.xxx index file.

Quote:

Originally Posted by Marschall83 *My explanation: the basic database scheme is hard coded in the client (maybe in the data files). Client resource files overwrite this hard codes schemes.

I think my answer above sheds a lot of light on this to support your explanation as being exactly what you thought it was.

Quote:

Originally Posted by Marschall83 You see I don`t understand the relationship between database and client changes. I found no guide which sorts this out (you can only search 1 your old threads).

The database controls the client, but the client needs the database table defined within it so that there are no mismatches and glitches caused by such mismatches.

A model file stored in a database monster resource as one model but defined in a client RDB as another may make the player see a different creature. Then he tries to tame said creature but the database tells them they dont have the right card.

Now there is a taming issue. Blah blah blah

Not everything needs to be defined in both. Item drops and and stuff like that will never be client side controlled. But an incomplete item resource could lead you to seeing non located items. An incomplete string resource leads to empty strings.

I think that,s enough wind out of me for this question if you have more I will try to help out.

Quote:

Originally Posted by アルカード If my experience with downgrading servers files can help just add me on discord and i show you few tips and tricks if u are interested

Thanks for your offer, I'll come back to that. I first want to get familiar with the basics.

Thanks @[Only registered and activated users can see links. Click Here To Register...] for your explanation.
I dumped the data files from my client and analysed the result. After that I try to overwrite the StringResource (changed a mob name in database) and create a hashed file (db_string.rdb) for the client resource folder. But this didn`t work. In game I see the old mob name.

Where is the point to start debugging this?

I use an older tool to create Rappelz rdb files. The newer tools (like [Only registered and activated users can see links. Click Here To Register...]) seems to work with epic 8 and above only. Is there a dedicated rdb tool for epic 5/6 (I`m working with epic 6.2 server files)?
Maybe the hashed rdb files are just crap and aren`t accepted by the client (but no error message occures).

Thanks in advance.

Quote:

Originally Posted by Marschall83 Thanks for your offer, I'll come back to that. I first want to get familiar with the basics. Thanks @[Only registered and activated users can see links. Click Here To Register...] for your explanation. I dumped the data files from my client and analysed the result. After that I try to overwrite the StringResource (changed a mob name in database) and create a hashed file (db_string.rdb) for the client resource folder. But this didn`t work. In game I see the old mob name. Where is the point to start debugging this? I use an older tool to create Rappelz rdb files. The newer tools (like [Only registered and activated users can see links. Click Here To Register...]) seems to work with epic 8 and above only. Is there a dedicated rdb tool for epic 5/6 (I`m working with epic 6.2 server files)? Maybe the hashed rdb files are just crap and aren`t accepted by the client (but no error message occures). Thanks in advance.

if you are using English client u need to use this db_string(ascii).rdb before u hash it


u need do ascii with other rdb too and other files too,if u are using english client

Quote:

Originally Posted by Marschall83 I use an older tool to create Rappelz rdb files. The newer tools (like [Only registered and activated users can see links. Click Here To Register...]) seems to work with epic 8 and above only. Is there a dedicated rdb tool for epic 5/6 (I`m working with epic 6.2 server files)? Maybe the hashed rdb files are just crap and aren`t accepted by the client (but no error message occures). Thanks in advance.

Grimoire is compatible with all client epics just as Glandu2 RDB Tool. You simply have to make epic 5/6 structure files for them.

I get error 10061
when I try to login to my server from another computer (connected through LAN)

I know that this is a common problem but I tried all solutions that I can find regarding opts and ports

my opts
auth

gameserver

Did you open all your ports (except 1433 leave this closed) in Windows advanced firewall for both incoming and outgoing requests on the server host computer.

Your .bat file is set to IP 25.11.164.155 Port 9881

Quote:

Originally Posted by SilentWisdom Grimoire is compatible with all client epics just as Glandu2 RDB Tool. You simply have to make epic 5/6 structure files for them.

Good advice, I will try it.

Quote:

Originally Posted by アルカード if you are using English client u need to use this db_string(ascii).rdb before u hash it u need do ascii with other rdb too and other files too,if u are using english client

Yes I use an english client. Thanks for this hint. The name change of this mob works now.
I tried the same with monster ressource, but now all mobs are gone :D (at least the hashed file name must be right).

Is there a chance to debug why my database/db_monster.rdb is broken or do I have to restore and try and error?

Quote:

Originally Posted by Boody19 I get error 10061 when I try to login to my server from another computer (connected through LAN) I know that this is a common problem but I tried all solutions that I can find regarding opts and ports my opts auth  Spoiler Code: S:app.name:Auth S:auth.allowed_special_char:@. N:auth.check_adult_server:0 N:auth.max_client_per_ip:9999 N:auth.max_daily_client_per_ip:9999999 N:auth.user_rate_mod:20 N:auth.version:201507080 S:io.ip_address:25.11.164.155 S:db.auth._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d S:db.auth.account:sa S:db.auth.md5_key:2011 S:db.auth.name:Auth S:db.auth.server:127.0.0.1 N:io.auth.port:9881 S:db.auth.port:1433 S:db.billing.account:sa S:db.billing.name:BILLING S:db.billing.server:127.0.0.1 N:db.auth.use_md5:1 N:db.auth.use_md5_for_security_no:1 N:game.user_limit_server_001:400 S:log.ip:127.0.0.1 N:billing.allow_login_without_billing:0 N:billing.check_server_keep_alive_timeout:0 N:billing.server_keep_alive_interval:6000 N:billing.server_keep_alive_timeout:3000 N:billing.use:1 N:billing.user_keep_alive_interval:60000 N:billing.user_keep_alive_timeout:3000 N:console.port:4516 S:console.allow_ip:127.0.0.1 S:console.ip:127.0.0.1 S:console._password: gameserver  Spoiler Code: S:app.name:RevolutionGS N:auth.server_idx:1 S:auth.server_name:Family #S:auth.server_name:Under maintenance S:db.c.name:Arcadia S:db.c._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d S:db.c.account:sa S:db.c.server:127.0.0.1 S:db.user._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d S:db.user.account:sa S:db.user.name:Telecaster S:db.user.server:127.0.0.1 N:game.AdultServer:0 S:game.allowed_special_char:@. S:console._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d F:game.ally_pcbang_bonus_rate:0.1 F:game.ally_pcbang_chaos_bonus_rate:0.1 N:game.cash_usable_server:1 F:game.chaos_drop_rate:1.000000 N:game.ela_count:0 F:game.exp_rate:30000 F:game.gold_drop_rate:4900000 F:game.mod:0.200000 F:game.item_drop_rate:3200000 N:game.local_flag:8192 N:io.use_message_statistics:0 N:game.pcbang_bonus_server:0 F:game.premium_pcbang_bonus_rate:1.000000 F:game.premium_pcbang_chaos_bonus_rate:0.100000 N:game.max_level:200 N:game.PKServer:1 F:game.pvp_damage_rate_for_player:0.01 F:game.pvp_damage_rate_for_summon:0.035 N:game.use_auto_trap:0 N:game.use_auto_jail:0 N:game.use_delete_security:0 N:game.use_guild_donation_point:0 N:game.use_play_point:0 N:game.use_security:0 N:CodePage:1256 N:game.ServiceServer:1 S:game.guild_icon_base_url:http://guilds.rappelz.ae/gicons/ S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html S:game.resource:Resource S:game.server_screenshot_url:https://room.rappelz.ae/Launcher/AR/server.html N:game.update.version:17 S:game.url_list:guild.url|http://guilds.rappelz.ae/gicons/|guild_test_download.url|gicons/|web_download|guilds.rappelz.ae|web_download_port|0|shop.url|http://room.rappelz.ae/shop.html|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|127.0.0.1|guild_icon_upload.port|4615 N:game.version:20180117 S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment S:io.ip_address:25.11.164.155 S:io.auth.ip:127.0.0.1 S:io.port:34391 T:game.enhance_fail_type:2 S:io.user_count_ip_mask:127.0.0.1 S:log.ip:127.0.0.1 S:log.working:1 S:io.upload.ip:127.0.0.1 S:io.upload.port:4617 S:upload.server_name:RevolutionUpload N:game.disable_trade:0 N:game.disable_booth:0 N:db.user.thread:4 S:console.port:44452 T:game.min_global_chat_usable_level:80 S:console.allow_ip:127.0.0.1 N:game.PKPenaltyLevel:10 N:game.use_account_authority_db:1 N:game.use_time_based_event_db:0 N:game.term_for_time_based_event_db:0 N:game.use_time_based_event_script:0 N:game.term_for_time_based_event_script:0 N:game.item_expert_cube :1 N:game.item_expert_grade:0 N:game.gold_drop_base:50000 F:game.gold_drop_percent:0.75 N:game.min_speed:1 N:game.amplify_level:0 N:game.amplify_hp:0 N:game.exception_arabic:0 N:game.exception_921:0 F:game.card_drop_rate:1.0 N:game.enhance_chance:1 N:game.enhance_chance_min:1 N:game.enhance_chance_max:10 N:game.enhance_destroy_level:8 F:game.quest_bonus_rate:4.0 N:game.quest_bonus_level:130.0 N:game.HardcoreServer:0 N:game.check_area:0 F:game.party_exp_rate_0:25 F:game.party_exp_rate_1:25 F:game.party_exp_rate_2:27 F:game.party_exp_rate_3:29 F:game.party_exp_rate_4:29 F:game.party_exp_rate_5:30 F:game.party_exp_rate_6:30 N:game.party_exp_penalty_level:200 N:game.summon_exp_penalty_level:200 F:game.killed_drop:0.03 I:game.crime_state:1 I:game.crime_party:1 F:game.killed_exp_percentage:1.0 F:game.kill_immoral_percentage:1.0 F:game.monster_regen_boss:5 F:game.monster_regen:5 N:game.max_characters_per_account:8 T:game.log.working:1 T:log.chat.working:1 N:game.ignore_client_binary:0 N:game.security_solution_type:0

Replace 25.11.164.155 with your local IP address, don't use 127.0.0.1

According to this [Only registered and activated users can see links. Click Here To Register...] I tried Grimoire and the tool rMOD. A configured the lua file matching my database table.

Now there are some questions.

• What is the lua counterpart to SQL datatypes smallint and tinyint?
• Why do this tools create different file size from the same database table (orginal db_monster.rdb about 6 MB, Grimoire about 7MB and rMOD about 24 MB)?
• I changed the column datatypes of the table from smallint and tinyint to int (but using the original db_monster.rdb from the client). This seems to work. Can I do this or is this not recommended?

Thanks in advance

Quote:

Originally Posted by Marschall83 According to this [Only registered and activated users can see links. Click Here To Register...] I tried Grimoire and the tool rMOD. A configured the lua file matching my database table. Now there are some questions. What is the lua counterpart to SQL datatypes smallint and tinyint? Why do this tools create different file size from the same database table (orginal db_monster.rdb about 6 MB, Grimoire about 7MB and rMOD about 24 MB)? I changed the column datatypes of the table from smallint and tinyint to int (but using the original db_monster.rdb from the client). This seems to work. Can I do this or is this not recommended? Thanks in advance

Hm, there is no direct lua counterpart to this.

But if you mean for rdb-tools:
Smallint = int16
Tinyint = int8

The tools handle the rdb-creation differently I guess, so it always depends on their coding.
But for this you should ask glandu2 or SilentWisdom then. ^^

I would not recommend to change all datatypes in database,
since many are also coded into GS (so it would not make any difference, or would maybe bug around).
But for some it is okay.

Quote:

Originally Posted by Marschall83 According to this [Only registered and activated users can see links. Click Here To Register...] I tried Grimoire and the tool rMOD. A configured the lua file matching my database table. Now there are some questions. What is the lua counterpart to SQL datatypes smallint and tinyint? Why do this tools create different file size from the same database table (orginal db_monster.rdb about 6 MB, Grimoire about 7MB and rMOD about 24 MB)? I changed the column datatypes of the table from smallint and tinyint to int (but using the original db_monster.rdb from the client). This seems to work. Can I do this or is this not recommended? Thanks in advance

• Instead of comparing lua types to db types, you should start with learning DB <> Primitives (a primitive being short, int, long etc)
• Please do not use rMOD, Grimoire replaced it. Furthermore Grimoire and Glandu2 tools given the same data set input (dbo.MonsterResource/db_monster.rdb) should produce identical results excepting the header (his and mine use different signatures in the 120 byte blank space.
• Like @[Only registered and activated users can see links. Click Here To Register...] said, never make changes to your table structures unless you're absolutely sure what you're doing. In many cases table reads use ordinal positions for columns instead of names. Thusly you can easily put an incorrect value in a table read and introduce small to extreme bugs.

If you need help with constructing or editing Grimoire structs (Daedalus) I suggest you visit the [Only registered and activated users can see links. Click Here To Register...] and check under 'Usage' section and inside the Daedalus spoiler.

If you have any further questions regarding Grimoire please feel free to message me directly on my disc iSmokeDrow#3102 (<--- remember its case sensitive!!!)

Thanks InkDevil and SilentWisdom.
The link to the Daedalus usage was helpful.

My situation is a little bit weird but I think it helps to understand my questions:
I took the 6.2 server files from epvp (I think Pyroks premade 6.3 with unicorns/nightmares which should appear in 6.3). I connect with the ancient 6.2 client (nemesis), because I wasn`t able to find another 6.2 client without gameguard. This combination works but there are graphic bugs with unicorns and nightmares (like I mentioned in [Only registered and activated users can see links. Click Here To Register...]; i will make screenshots soon).

My goal is to replace unicorns with red pixies in fairy woods (for example) to get the original 6.2 mobs.

So I think there is a little mismatch of the server and client files. The problem is that I can`t create a working db_monster.rdb from database (no mobs visible ingame) and I can`t read the client db_monster.rdb into the database (errors in Grimoire/rMOD). Btw I use an US Client and the ...(asci).rdb names for hashing.

Quote:

Originally Posted by InkDevil I would not recommend to change all datatypes in database,

Quote:

Originally Posted by SilentWisdom Like @InkDevil said, never make changes to your table structures unless you're absolutely sure what you're doing. In many cases table reads use ordinal positions for columns instead of names. Thusly you can easily put an incorrect value in a table read and introduce small to extreme bugs.

Ok, got it :).

I will try Glandu2`s tool and adjust the structure lua files (I think tinyint should be BYTE in lua and smallint = INT16; INT8 isn`t available).

Quote:

Originally Posted by Marschall83 Btw I use an US Client and the ...(asci).rdb names for hashing.

(ascii)

So you are also launching ascii in your .bat and not code page?

We would like to thank everyone that provided any kind of help for people in this thread .