9.5.2 KiteKat repack

[thefear511]

Haven't heard that name in a long time, kitekat used to be a popular 7.x repacks back in 2016. is it the same one?

also my topic wasn't a re-release it was the first guide to setup files with the correct auth and just a simpler telecaster. with @nformatics help.

thx for credit.

[GM2FucK]

Originally Posted by atherounge3

Are you sure you're doing _RU, not _AR?
Are you sure you have windows-1251 in launch arguments?
Are you sure you are starting european sframe (SFrame.exe), not arabic (SFrame_arabic.exe)?

RappelzCmdLauncher.exe SFrame.exe /auth_ip:127.0.0.1 /auth_port:4615 /help_url_w:611 /help_url_h:625 /locale:windows-1251 /country:CN /cash /gift /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631 /use_nprotect:0 /notenc

And put db_string(windows-1251).rdb in resource

Dear Atherounge3! Thank you for your help and participation in this matter! Yes, I have done everything as it should be, but the following helped me solve the issue:
1. I disassembled a third-party client and took the localeinfo.ini file from it.
2. I disassembled the official client and took the db_string file from it. This solved almost all the problems, and I just need to work on the correct translation to get it right.

However, I have another question:
1. The "Guy" race has two types of clothing that appear to have corrupted resource files.
The screenshot shows the issue:

 Spoiler

I tried to fix it by exporting the db_item and converting it to rdb. However, this caused further complications. Some of the costumes are not working properly.
I tried using different resource files, but I did not notice any improvement. Can you please suggest a solution to this problem?

I am using the client from your guide.

[atherounge3]

Originally Posted by GM2FucK

Dear Atherounge3! Thank you for your help and participation in this matter! Yes, I have done everything as it should be, but the following helped me solve the issue:
1. I disassembled a third-party client and took the localeinfo.ini file from it.
2. I disassembled the official client and took the db_string file from it. This solved almost all the problems, and I just need to work on the correct translation to get it right.

However, I have another question:
1. The "Guy" race has two types of clothing that appear to have corrupted resource files.
The screenshot shows the issue:

 Spoiler

I tried to fix it by exporting the db_item and converting it to rdb. However, this caused further complications. Some of the costumes are not working properly.
I tried using different resource files, but I did not notice any improvement. Can you please suggest a solution to this problem?

I am using the client from your guide.

No idea, to be honest. This is common issue in a lot of clients I tried. It's something with character motion and not only gaia, but asura also has such problem with starting clothes. Rest clothes are working pretty well, if you would check

[okba_2007]

which sql server you tested this files in ? 2016 ? 2017 ?

[ActionGod]

Hey friend, it would be great if you released a video for beginners. I'm so glad there are people out there who support the community and share their work. I can't even get the "auth" server to start, I don't know why, it keeps throwing errors.
2025-12-28
DbConnectionPool0: Checking connection to database
08:57:59 ERROR
ODBC: SQLDriverConnect: error:
2025-12-28 08:57:59 ERROR ODBC: 08001:1:17: [Microsoftl [ODBC SQL Server Driver] [DBNETLIB]SQL Server эх ёс•хё€тєх€, шыш фю
ёЄся чряЁх•хэ.
2025-12-28 08:57:59 ERROR ODBC: 01000:2:53: [Microsoft] [ODBC SQL Server Driver] [DBNETLIB]ConnectionOpen (Connect)).
2025-12-28 08:57:59 ERROR DbConnectionPooL: Failed to connect to driver=SQL Server;Server= 127.0.0.1, 1433;Database= Aut
If you'd like to write more detailed instructions on installing this repack, that would be great. Thanks for the repack, sorry, this message was translated using Google Translate.

[atherounge3]

Originally Posted by ActionGod

Hey friend, it would be great if you released a video for beginners. I'm so glad there are people out there who support the community and share their work. I can't even get the "auth" server to start, I don't know why, it keeps throwing errors.
2025-12-28
DbConnectionPool0: Checking connection to database
08:57:59 ERROR
ODBC: SQLDriverConnect: error:
2025-12-28 08:57:59 ERROR ODBC: 08001:1:17: [Microsoftl [ODBC SQL Server Driver] [DBNETLIB]SQL Server эх ёс•хё€тєх€, шыш фю
ёЄся чряЁх•хэ.
2025-12-28 08:57:59 ERROR ODBC: 01000:2:53: [Microsoft] [ODBC SQL Server Driver] [DBNETLIB]ConnectionOpen (Connect)).
2025-12-28 08:57:59 ERROR DbConnectionPooL: Failed to connect to driver=SQL Server;Server= 127.0.0.1, 1433;Database= Aut
If you'd like to write more detailed instructions on installing this repack, that would be great. Thanks for the repack, sorry, this message was translated using Google Translate.

Show your opt and full error log

[osomeloso]

I wanted to test it, but there’s no way to launch the gameserver.
The Auth does connect, though:

 Spoiler

#Database configuration
auth.db.server:192.168.1.100
auth.db.port:1433
auth.db.name:Auth
auth.db.account:sa

auth.db.salt:kitekatsalt
auth.db.cryptedpassword:4556000003003a1d54a7a804f8 3dea18fb22243e217f66fa0622e2f9e21969e67ebc06060612 074e1606

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#Where clients will connect (this is default values)
auth.clients.ip:0.0.0.0
auth.clients.port:4615

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:192.168.1.147
auth.gameserver.port:4502

#Upload configuration, use "upload" folder for guild icons
upload.dir=C:\inetpub\wwwroot\gicon
upload.clients.ip=0.0.0.0
upload.clients.port=4617

#Use port 5000 for the guild icon mini webserver
upload.iconserver.ip=0.0.0.0
upload.iconserver.port:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:192.168.1.147
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Account WITH(NOLOCK) WHERE account = ? AND password = ?;

#Configure security password query. If this query return at least one row, the security password is accepted
#sql.db_securitynocheck.query:SELECT securty_no FROM Accounts WHERE login_name = ? AND securty_no = ?;
#You can also use a stored procedure
#sql.db_securitynocheck.query:{CALL smp_new_check_security(?, ?)}

#Logging level
core.log.level:debug
core.log.consolelevel:info
auth.clients.maxpublicserveridx:5

Or at least that’s what it seems — I had never used this auth emulator before.

rzauth

 Spoiler

2026-01-08 00:51:32 Info ConfigInfo0: N upload.iconserver.port:5000
2026-01-08 00:51:32 Info DbConnectionPool0: Checking connection to database
2026-01-08 00:51:32 Info ODBC: SQLDriverConnect: additional info:
2026-01-08 00:51:32 Info ODBC: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'Auth'.
2026-01-08 00:51:32 Info ODBC: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
2026-01-08 00:51:32 Info DbConnectionPool0: Connection ok
2026-01-08 00:51:32 Info SessionServer<AuthServer::ClientSession>: Starting server auth.clients on 0.0.0.0:4615
2026-01-08 00:51:32 Info SessionServer<AuthServer::BillingInterface>: Starting server auth.billing on 127.0.0.1:4503
2026-01-08 00:51:32 Info SessionServer<AuthServer::GameServerSession>: Starting server auth.gameserver on 192.168.1.147:4502
2026-01-08 00:51:32 Info SessionServer<UploadServer::GameServerSession>: Starting server upload.gameserver on 192.168.1.147:4616
2026-01-08 00:51:32 Info SessionServer<UploadServer::ClientSession>: Starting server upload.clients on 0.0.0.0:4617
2026-01-08 00:51:32 Info SessionServer<UploadServer::IconServerSession>: Starting server upload.iconserver on 0.0.0.0:5000
2026-01-08 00:51:32 Info SessionServer<AdminServer::AdminInterface>: Starting server admin.telnet on 127.0.0.1:4501
2026-01-08 00:51:32 Info SocketSession0: Connected to Log server 127.0.0.1:4516

gameserver op

 Spoiler

S:app.name:KitekatGS
N:auth.server_idx:2
S:auth.server_name:KitekatServer
S:db.c.name:Arcadia952
S:db.c._password:4556000003003a1d54a7a804f83dea18f b22243e217f66fa0622e2f9e21969e67ebc06060612074e160 6
S:db.c.account:sa
S:db.c.server:192.168.1.100
S:db.user._password:4556000003003a1d54a7a804f83dea 18fb22243e217f66fa0622e2f9e21969e67ebc06060612074e 1606
S:db.user.account:sa
S:db.user.name:Telecaster952
S:db.user.server:192.168.1.100
N:game.AdultServer:0
S:game.allowed_special_char:@.
S:console._password:4556000003003a1d54a7a804f83dea 18fb22243e217f66fa0622e2f9e21969e67ebc06060612074e 1606
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:40
F:game.exp_rate:30
F:game.gold_drop_rate:40
F:game.mod:0.200000
F:game.item_drop_rate:32
N:game.local_flag:4
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:1251
N:game.ServiceServer:1
S:game.guild_icon_base_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.resource:Resource
S:game.server_screenshot_url:
N:game.update.version:17
S:game.url_list:guild.url|
N:game.version:20181211

S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:io.ip_address:192.168.122.76
N:io.port:44391
T:game.enhance_fail_type:2
S:io.user_count_ip_mask:192.168.1.147
S:log.ip:192.168.1.147
S:log.working:1
S:io.upload.ip:192.168.1.147
S:io.upload.port:5617
S:upload.server_name:RevolutionUpload
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
N:console.port:44453
T:game.min_global_chat_usable_level:80
S:console.allow_ip:192.168.1.147
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:5000
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:5
N:game.summon_exp_penalty_level:10
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:0
T:log.chat.working:1
N:game.ignore_client_binary:0
N:game.security_solution_type:0
N:game.premium_for_everybody:1
N:game.antiweaponswap:1
N:game.devildom_no_req:1

[ThunderNikk]

S:io.ip_address:192.168.122.76
N:io.port:44391

192.168.1.147

Multiple networks? Why not local host and avoid the confusion?

[osomeloso]

What is the password for the admin user? ty!!
Solved
All my issues were resolved by creating the example user in the database itself and only changing the database IP (which is not necessary if you install the database on the same PC as the rest), and setting the remaining addresses to 127.0.0.1.
Thanks to both of you for your help.

[atherounge3]

Originally Posted by osomeloso

What is the password for the admin user? ty!!
Solved
All my issues were resolved by creating the example user in the database itself and only changing the database IP (which is not necessary if you install the database on the same PC as the rest), and setting the remaining addresses to 127.0.0.1.
Thanks to both of you for your help.

Just change to yours lol
It's md5 hash with left salt which you define in auth opt

[r4nd0mncknm]

Thank you very much for your repack—especially for the DESUtil tool, which I couldn't find anywhere else...

May I ask why you don't use PrincessAurora as your authentication server?

[atherounge3]

Originally Posted by r4nd0mncknm

Thank you very much for your repack—especially for the DESUtil tool, which I couldn't find anywhere else...

May I ask why you don't use PrincessAurora as your authentication server?

Glandu is much better + more configurations. Aurora is like beta version of glandus

Aurora can't use stored procedure for authentification and you can't debug it (unless you build it yourself using source)

[osomeloso]

The job level system isn’t working. My character is level 25, but I can’t raise the noob job level above 7, and I can’t level up the basic skills like summoning a pet or taming.

[atherounge3]

Originally Posted by osomeloso

The job level system isn’t working. My character is level 25, but I can’t raise the noob job level above 7, and I can’t level up the basic skills like summoning a pet or taming.

Welcome to **** 9.5.2 system, you can't do anything against that. The job level is hardcoded and limited to your character level / 2

But idk 25 / 2 = 12.5, which would be 12, so you most likely should be able to do so? No idea. Levelup yourself more

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