9.5.2 KiteKat repack

[atherounge3]

Originally Posted by key_strike

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.

Just do a table key-value pairs of joblevel/jobpoints and do set_value
sv("jp")
sv("jlv")

You wont need any relog

[key_strike]

Originally Posted by atherounge3

Just do a table key-value pairs of joblevel/jobpoints and do set_value
sv("jp")
sv("jlv")

You wont need any relog

I tried using sv instead of set_value that but it does not make a difference. Its weird as only the jvl does not update in the UI. The jp updates just fine. Beside the UI everything works as expected. the Job support does see your actual jlv and allows you to class transfer. A minor annoyance vs not being able to do it at all.

I have attached the files I modified if you are curious.
- NPC_Job_change.lua: added NPC_JobChange_levelup_joblvl() and NPC_JobChange_change_joblvl() functions. Also added dialog option
- NPC_Tutorial.lua: added dialog option to training island job supporter
- Fraun/extra_things.lua; extended and moved the job_classification_table to DB folder
- Datatables/DB_levelresources.lua: exported the levelresources and added in its own array.

[atherounge3]

Originally Posted by key_strike

I tried using sv instead of set_value that but it does not make a difference. Its weird as only the jvl does not update in the UI. The jp updates just fine. Beside the UI everything works as expected. the Job support does see your actual jlv and allows you to class transfer. A minor annoyance vs not being able to do it at all.

I have attached the files I modified if you are curious.
- NPC_Job_change.lua: added NPC_JobChange_levelup_joblvl() and NPC_JobChange_change_joblvl() functions. Also added dialog option
- NPC_Tutorial.lua: added dialog option to training island job supporter
- Fraun/extra_things.lua; extended and moved the job_classification_table to DB folder
- Datatables/DB_levelresources.lua: exported the levelresources and added in its own array.

If you will change level then it would refresh job level as well. So perhaps you can record exp (as a string obviously)
e.g.:

local currExp = "" .. tostring(gv("exp")) .. ""

    sv("jlv", 30)
    sv("lv", gv("lv") - 1)
    sv("exp", currExp)

Perhaps may work. Why to string? Because lua has limits. At some point it would change numbers to scientific notation, like 3.5e+016 so idk if this even would work, but worth a try

sv("lv", gv("lv") - 1) would change your EXP progress back to 0, but would refresh everything

[mdarte]

Hello everyone, thanks a lot for this release, the server is running up and nicely, I been making small adjustment as I go, and I'm having a blast playing the game localy, but one problem I have no idea how to fix.

Some Gaia armor are breaking the character model, happens to gaia NPCs aswell


Anyone would know how to fix this?

[atherounge3]

Originally Posted by mdarte

Hello everyone, thanks a lot for this release, the server is running up and nicely, I been making small adjustment as I go, and I'm having a blast playing the game localy, but one problem I have no idea how to fix.

Some Gaia armor are breaking the character model, happens to gaia NPCs aswell


Anyone would know how to fix this?

Some weird ****, idk. Seems like nx3 / naf / motion issues. I will try later to fix, but if you would find a fix earlier let me know

[atherounge3]

Uplaoded new repack version. Links were updated.

Changelog:
Fixed animations
Added new monsters/pets from 9.6
Fixed motions
Added new NPC in Horizon, with some management
Added some scripts, including antimacro system (idk, id if works flawless, test it)
Updated levelupmypets script, now it levelups pets up to 180lvl
Added some strings
Fixed global chat issue
Jerked off databases a little bit
Now MonsterResource has id as a key (means all monsters duplicates were removed) and local flag set to 0 for every monster in the game
Added sql types of backups (In case if you have older sql version, I set it to SQL Server 2017)
Now here are 4 batch files to start the game, with 3 different most used languages (Like a guide for you how to start the game with specific 'X' language)


Also I've put a source of Herlock which supports 9.5.2 SFrame, but it needs some modifications:
1) Change packets to original ones
2) Change MAX_RANDOM_OPTION_NUMBER to 10
3) Change pPtr->GetHandle() to pPtr->GetSID() in the DB_UpdateGuildMemberPoint push construction
(Perhaps here is something else (most likely), so I didn't even bother for now. Perhaps, later I would include fixed source-built herlock in the repack. But now we have what we have.
IF you're feeling yourself smart enough, then just replicate behavior of original 9.5.2 binary, since you have pdb file. Not much hard, if you are considering yourself a developer. At least you can search in the internet for the info.

IMPORTANT INFO
The origin of this source is unknown. Here is arabic guy claiming that this source was made by him, but he is unable to prove that and considering his "releases", he is totally uncapable of doing such gameserver upgrade. So if somebody knows origin of that Herlock, let me know. I'll add credits to this wonderful guy.

Also, as I remember, I made a patch to one of original precompiled binaries. But can't remember what exactly I patched and which binary I patched. And I don't have previous ones, so... If you have and don't trust, just replace them. Nothing would be changed. Compare hashsums, idk... Your choice. Any way...-===>


Credits to:

@
For european game client (I dumped his server one and took working nx3/naf from it, so now gaian characters are looking better)

@
For his repack, from which I took motions and packed rdb tool with prepared structs

@
For writing his script for Job Level


Link itself, if you're too lazy ass to scroll in the beginning:

[Ne0@NCarbon]

Thanks for this release.

I try this GS and it crash, it return too much argument for the smp.update_state.
The smp is the same as other 9.5.2 so it's a gs problem.

One little thing about stringresource, the rdb to sql give you 3 column but gs expect 4, and he doesn't query sql properly so the column need to be in the right order.
You have to add in first position a column named 'name" nvarchar(64) not null then 'group_id' then 'code' then 'value' from rdb, after that you have to fill all the new column 'name' with 'value_name'
If you don't do that, when taming, gs return SVRmonsterID instead of the mob name

[Ne0@NCarbon]

Here a small addon, it's the lua for the event "boss hunters".
You have to load this lua in server_init.lua in function on_server_init

[key_strike]

Originally Posted by atherounge3

If you will change level then it would refresh job level as well.

Ah! you are genius this fixes this behavior. It now refreshes in the UI as well. Thank you!

[atherounge3]

Originally Posted by Ne0@NCarbon

Thanks for this release.

I try this GS and it crash, it return too much argument for the smp.update_state.
The smp is the same as other 9.5.2 so it's a gs problem.

One little thing about stringresource, the rdb to sql give you 3 column but gs expect 4, and he doesn't query sql properly so the column need to be in the right order.
You have to add in first position a column named 'name" nvarchar(64) not null then 'group_id' then 'code' then 'value' from rdb, after that you have to fill all the new column 'name' with 'value_name'
If you don't do that, when taming, gs return SVRmonsterID instead of the mob name

Well, I made a view for StringResource, which only do is SELECT * FROM StringResource_EN, so perhaps you can just modify it and add name as empty column, would be easier solution (Or you make ur own database)
E.g.: SELECT ' ' as name, * FROM dbo.StringResource_EN

Not sure about smp.update_state so give me exact way to reproduce that bug so I will take a look later. May be you are using GS patched by me and I somehow ****** it up, that's pretty possible. Because I can't remember what I even tried to patch (was tooo long time ago)

[Ne0@NCarbon]

Originally Posted by atherounge3

Well, I made a view for StringResource, which only do is SELECT * FROM StringResource_EN, so perhaps you can just modify it and add name as empty column, would be easier solution (Or you make ur own database)
E.g.: SELECT ' ' as name, * FROM dbo.StringResource_EN

Not sure about smp.update_state so give me exact way to reproduce that bug so I will take a look later. May be you are using GS patched by me and I somehow ****** it up, that's pretty possible. Because I can't remember what I even tried to patch (was tooo long time ago)

Yes the view is one solution, in any case, being French, I have to redo the stringresource table so I do it at the same time

For the GS which crash, it's the one in the root of the game_bin folder,
sha256sum CaptainHerlockServer.exe
01d4cc553e6cdc8eeabc29614a5375fae964ad8a500c8ec3f1 1edca82059a706 CaptainHerlockServer.exe

Step to reproduce is just login game and logout after some seconds to force update your state in telecaster.

GameLog : 2026/01/16 20:07:59 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateState(dbo.smp_update_state: @IN_SID: 4) : Trop d'arguments sont spécifiés pour la procédure ou la fonction smp_update_state.

[atherounge3]

Originally Posted by Ne0@NCarbon

Yes the view is one solution, in any case, being French, I have to redo the stringresource table so I do it at the same time

For the GS which crash, it's the one in the root of the game_bin folder,
sha256sum CaptainHerlockServer.exe
01d4cc553e6cdc8eeabc29614a5375fae964ad8a500c8ec3f1 1edca82059a706 CaptainHerlockServer.exe

Step to reproduce is just login game and logout after some seconds to force update your state in telecaster.

GameLog : 2026/01/16 20:07:59 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateState(dbo.smp_update_state: @IN_SID: 4) : Trop d'arguments sont spécifiés pour la procédure ou la fonction smp_update_state.

I mean I made it as view just to make it easier for you to change server language. So you won't need to copypaste tables. Which is also would reduce database size


Try to change procedure to this:

-- start of smp_update_state
ALTER PROCEDURE [dbo].[smp_update_state]
@!IN_SID				INT,
@!IN_OWNER_ID			INT,
@!IN_SUMMON_ID			INT,
@!IN_CODE				INT,
@!IN_LEVEL				BIGINT,
@!IN_DURATION			INT,
@!IN_REMAIN_TIME			INT,
@!IN_BASE_DAMAGE			INT,
@!IN_REMAIN_FIRE_TIME	INT,
@!IN_STATE_VALUE			INT,
@!IN_STATE_STRING_VALUE	NVARCHAR(32),
@!IN_ENABLE				INT
AS
SET NOCOUNT ON

UPDATE dbo.State SET
code =					@!IN_CODE,
owner_id =			@!IN_OWNER_ID,
summon_id =			@!IN_SUMMON_ID,
[level] =				@!IN_LEVEL,
duration =				@!IN_DURATION,
remain_time =			@!IN_REMAIN_TIME,
base_damage =			@!IN_BASE_DAMAGE,
remain_fire_time =		@!IN_REMAIN_FIRE_TIME,
state_value	=			@!IN_STATE_VALUE,
state_string_value =	@!IN_STATE_STRING_VALUE,
enable =				@!IN_ENABLE
WHERE sid = @!IN_SID

RETURN @!@!ERROR

-- end of smp_update_state

(Remove ! after the @. I added it because website replaces it to mentioning some users)

[Ne0@NCarbon]

I try but it failed because state table doesn't have the state_string_value column
Should i alter the state table ?

Originally Posted by Ne0@NCarbon

I try but it failed because state table doesn't have the state_string_value column
Should i alter the state table ?

After altering state table and update the smp, no luck still crash for the same reason

[atherounge3]

Originally Posted by Ne0@NCarbon

I try but it failed because state table doesn't have the state_string_value column
Should i alter the state table ?



After altering state table and update the smp, no luck still crash for the same reason

Tried both gameservers?

Well, what are your buffs? Possibly you have buff level overflow?

[Ne0@NCarbon]

Originally Posted by atherounge3

Tried both gameservers?

Well, what are your buffs? Possibly you have buff level overflow?

The same GS, the one with the SHA256 i post.
When I test i take the buffs delivered by Mandy Shop.
If i use 952OriginalCaptainHerlockServer it works without crashing with same buffs.