9.5.2 KiteKat repack

[atherounge3]

Originally Posted by key_strike

artherouge3 happy new year and thank you so much for this.

Managed to setup the server on (windows) and am running the game on Linux and for whatever reason the music is not playing. Will fiddle some more to see if I can fix this in wine but if this is a know issue let me know so I don't waste more time trying to fix it.

The only thing I have run into now is that I see the bronze/silver/gold orbs are not present in the client also not the orb traders. Is this known? Is this due to the client not being correct or tampering with item drops on the server? If the later is there a way to remove the orbs (or other missing items) from the drop table of mobs?

Edit: Think I found the data

Used the below sql query to find the item_id's:
*Note needed to remove 'code' from [ ] due to forum seeing this as beginning of code structure.

SELECT [ItemResource].[id] AS item_id ,code,[value]
FROM [Arcadia952].[dbo].[StringResource]
JOIN [Arcadia952].[dbo].[ItemResource] AS ItemResource ON [Arcadia952].[dbo].[StringResource].code = [ItemResource].[name_id]
WHERE [value] LIKE '%Orb<Boss Token>'

This gave me the 3 items id's (2011305,2011306,2011307) and then ran the below SQL query to pull any drop table containing 1 or more of these items.

SELECT [id],[sub_id],[drop_item_id_00],[drop_percentage_00],[drop_min_count_00],[drop_max_count_00],[drop_min_level_00],[drop_max_level_00]
      ,[drop_item_id_01],[drop_percentage_01],[drop_min_count_01],[drop_max_count_01],[drop_min_level_01],[drop_max_level_01]
      ,[drop_item_id_02],[drop_percentage_02],[drop_min_count_02],[drop_max_count_02],[drop_min_level_02],[drop_max_level_02]
      ,[drop_item_id_03],[drop_percentage_03],[drop_min_count_03],[drop_max_count_03],[drop_min_level_03],[drop_max_level_03]
      ,[drop_item_id_04],[drop_percentage_04],[drop_min_count_04],[drop_max_count_04],[drop_min_level_04],[drop_max_level_04]
      ,[drop_item_id_05],[drop_percentage_05],[drop_min_count_05],[drop_max_count_05],[drop_min_level_05],[drop_max_level_05]
      ,[drop_item_id_06],[drop_percentage_06],[drop_min_count_06],[drop_max_count_06],[drop_min_level_06],[drop_max_level_06]
      ,[drop_item_id_07],[drop_percentage_07],[drop_min_count_07],[drop_max_count_07],[drop_min_level_07],[drop_max_level_07]
      ,[drop_item_id_08],[drop_percentage_08],[drop_min_count_08],[drop_max_count_08],[drop_min_level_08],[drop_max_level_08]
      ,[drop_item_id_09],[drop_percentage_09],[drop_min_count_09],[drop_max_count_09],[drop_min_level_09],[drop_max_level_09]
  FROM [Arcadia952].[dbo].[MonsterDropTableResource]
  WHERE [drop_item_id_00] = 2011305 OR [drop_item_id_01] = 2011305 OR [drop_item_id_02] = 2011305 OR [drop_item_id_03] = 2011305 OR [drop_item_id_04] = 2011305 OR [drop_item_id_05] = 2011305 OR [drop_item_id_06] = 2011305 OR [drop_item_id_07] = 2011305 OR [drop_item_id_08] = 2011305 OR [drop_item_id_09] = 2011305 OR
        [drop_item_id_00] = 2011306 OR [drop_item_id_01] = 2011306 OR [drop_item_id_02] = 2011306 OR [drop_item_id_03] = 2011306 OR [drop_item_id_04] = 2011306 OR [drop_item_id_05] = 2011306 OR [drop_item_id_06] = 2011306 OR [drop_item_id_07] = 2011306 OR [drop_item_id_08] = 2011306 OR [drop_item_id_09] = 2011306 OR
        [drop_item_id_00] = 2011307 OR [drop_item_id_01] = 2011307 OR [drop_item_id_02] = 2011307 OR [drop_item_id_03] = 2011307 OR [drop_item_id_04] = 2011307 OR [drop_item_id_05] = 2011307 OR [drop_item_id_06] = 2011307 OR [drop_item_id_07] = 2011307 OR [drop_item_id_08] = 2011307 OR [drop_item_id_09] = 2011307

I see three option:
* change the item id
* change the drop percentage
* change the item min/max count

personally think the percentage is the way to go but will dig into it tomorrow. too late at the moment.

Well, i'm using linux myself and ig you just need to set up directx from official wine sources. Use winetricks. Or perhaps you most likely would want to use lutris which has everything built-in

What about orbs I have no idea what you're talking about, but seems like here is something inside of monsters drop? I will check

[key_strike]

Originally Posted by atherounge3

Well, i'm using linux myself and ig you just need to set up directx from official wine sources. Use winetricks. Or perhaps you most likely would want to use lutris which has everything built-in

What about orbs I have no idea what you're talking about, but seems like here is something inside of monsters drop? I will check

Thank you for the reply. Yes I have the game setup and its working fine in wine but there is no music. I can hear the sounds (button clicks, ambient sounds and special effects) but not the music. None of .ogg files in the resource folder. And BGM it not muted either. Though it was muted initially so I suspect its a game client issue.

just show as a blank box in the inventory and you cannot do anything with it. You cant move it, can't select or delete it. Its a bit of an annoyance but don't worry about it. I will figure it out.

[Ne0@NCarbon]

Hi,

Could you explain how do you setup and run client with wine please ?

thanks

[key_strike]

Originally Posted by Ne0@NCarbon

Hi,

Could you explain how do you setup and run client with wine please ?

thanks

Hey Ne0@NCarbon,

Just setup a clean prefix and installed the Directx9 overrides and ogg codecs.
My Rappelz is saved in my 'home/user/rappelz' directory and I created a bash script that launches the game. Below is the command.

WINEPREFIX=/home/user/.local/share/wineprefixes/rappelz wine RappelzCmdLauncher.exe SFrame.exe /auth_ip:192.168.56.102 /auth_port:4615 /help_url_w:611 /help_url_h:625 /locale:windows-1250 /country:CN /cash /gift /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631 /use_nprotect:0 /notenc

What I tried so far with no luck:
- delete the rappelz_v1.opt file and have it regenerated
- rename the resources/*ogg music files to match the case of the files in [dbo].[SoundResource].
- mute and unmute the BGM music and change the volume
- Test the ogg files plays in Linux directly and they play fine

For anyone else who want to get rid of Boss Orb drops you can use the below SQL query to set drops to 0

UPDATE [Arcadia952].[dbo].[MonsterDropTableResource]
SET [drop_percentage_03] = 0.00000000
WHERE [drop_item_id_03] = 2011305 OR [drop_item_id_03] = 2011306 OR [drop_item_id_03] = 2011307

[Ne0@NCarbon]

Thanks for your reply.
I tried both 32 and WOW64 prefixes with no luck, but i think my main problem come from Wayland ...
Do you use X11 instead ?
I think i will try with a game distro like Bazzite or CachyOS

[key_strike]

Originally Posted by Ne0@NCarbon

Thanks for your reply.
I tried both 32 and WOW64 prefixes with no luck, but i think my main problem come from Wayland ...
Do you use X11 instead ?
I think i will try with a game distro like Bazzite or CachyOS

Cool Thank you. Yes using Manjaro and KDE desktop which forces Wayland now.
Endless issues since this changed but mostly graphics related since I still have a nvidia470 compatible graphics card.

Had to ditch that and use integrated graphics which sucks and only have a max of 1024x768 res.
Tried Ubuntu and its even worse. Researched Bazzite which also does not support my dinosaur GPU.

If CachyOS has X11 then I think I will switch to it. Let me know how your testing goes.

On another topic I think I may need to remove the Orbs from the client monster drop table as well.

Does anyone know how to patch the client or have the package unpacker/repacker?

[アルカード]

I used Arch/Hyprland/Wayland on Thinkpad T470s

i used lutris for my linux system and this were my prefix and i had no issues.

where is my client located

WINEPREFIX=/home/alucard/Downloads/rappelz winetricks allfonts

and for args

/auth_ip:127.0.0.1 /auth_port:4615 /network.max_msg_process:1 /help_url_w:620 /help_url_h:633 /locale:Windows-1250 /country:EN /use_nprotect:0 /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:887 /cash_url_h:640 /allow_double_exec:1 /notenc

[key_strike]

/auth_ip:127.0.0.1 /auth_port:4615 /network.max_msg_process:1 /help_url_w:620 /help_url_h:633 /locale:Windows-1250 /country:EN /use_nprotect:0 /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:887 /cash_url_h:640 /allow_double_exec:1 /notenc

When using the client included in the KiteKat repack and changing the launch parameter from /country:CN to /country:EN it returns with a game guard error:

err code [150]: Game Guard files do not exist or have been altered.

What client are you using?

[アルカード]

For 952 I used CN too,had no issues too

[key_strike]

Originally Posted by アルカード

For 952 I used CN too,had no issues too

Sweet. Are you able to share the client you are using or a link to where it can be found? The older links to the 952 clients in the forums are dead. I only have the KiteKat repacked client.

[Ne0@NCarbon]

Got it working finally, thanks all.
I have had a problem with nvidia optimus between the radeon in ryzen cpu and the rtx but solved now.
Microsoft sql exist for linux, does some of you tried to run auth, gs, etc servers with wine ?

[atherounge3]

Originally Posted by Ne0@NCarbon

Got it working finally, thanks all.
I have had a problem with nvidia optimus between the radeon in ryzen cpu and the rtx but solved now.
Microsoft sql exist for linux, does some of you tried to run auth, gs, etc servers with wine ?

Glandu2 did that, but I prefer VM to avoid brainfuck. Just don't let this VM to connect to the internet and you're free from shitcrosoft spyware (Or at least nullroute all their domains)
Then use local to connect (As you can see in the server opt example it's 192.168.xx IP here, I used it in my VM and exposed this IP to my host, so I can connect to GS in VM through wine on my main machine)

[key_strike]

Originally Posted by Ne0@NCarbon

Got it working finally, thanks all.
I have had a problem with nvidia optimus between the radeon in ryzen cpu and the rtx but solved now.
Microsoft sql exist for linux, does some of you tried to run auth, gs, etc servers with wine ?

I tried running the auth server in wine but kept running into SQL connections issue despite the SQL server being up. I suspect its the ODBC driver in was not correct or the auth client could not find correct. I spent a week on it before I finally gave up. I never even tried the game server.

Interesting to hear that some people did get it working. If all the auth and gameserver can work in linux that would be great. The next step would be getting it working in a docker container. This will greatly remove the complexity of starting a rappelz server.

[atherounge3]

Originally Posted by key_strike

I tried running the auth server in wine but kept running into SQL connections issue despite the SQL server being up. I suspect its the ODBC driver in was not correct or the auth client could not find correct. I spent a week on it before I finally gave up. I never even tried the game server.

Interesting to hear that some people did get it working. If all the auth and gameserver can work in linux that would be great. The next step would be getting it working in a docker container. This will greatly remove the complexity of starting a rappelz server.

You don't need wine for auth. Just build it for linux, lol. Source is publicly available

[key_strike]

You don't need wine for auth. Just build it for linux, lol. Source is publicly available

That's is true but that is a challenge for another day.

Something that been annoying me in the later releases of Rappelz is the hard coded requirement that restricts you job level to half your character level. So I spent some time adding the option to upgrade you job level at any of the job supporters in town. Its a bit buggy at the moment but gets the job done. It just requires you go to the character screen and log back in to see the changes.