[Which client version is pre-re ItemDB (and others?) based on?]

Hi all,

Which client version should we be looking at for pre-re item/mob/skill db?
Like what is it based on?

I would like to check a few things in the Item DB against a known pre-re client version hopefully the most up to date one to compare the effects/stats from the descriptions.
I recall that they used txt files possibly, but that it was at least before 2010 possibly 2019 client?
Full installs were not made for the last several as they just had players patch to get up to date.

Also can someone please provide a working download link to such a client? (I'm not after latest kRO renewal to then simply patch with English translation project as I already have that I would like to actually compare the info from item descriptions against what we have).
All the links from RMS from years ago are gone/dead links.

I have been making some scripts to load the rAthena item db and system/iteminfo.lua to compare data, it even pulls out and "Unbolloxs" the text.

Example if anyone in future is interested in how to Unbollox the text, I'm using Node.js btw.

const iconv = require('iconv-lite')
iconv.skipDecodeWarning = true // See: https://github.com/ashtuchkin/iconv-lite/wiki/Use-Buffers-when-decoding

function unbolloxLuaString(input) {
    return iconv.decode(iconv.decode(Buffer.from(input), 'iso8859-1'), 'cp949')
}

Thanks in advance.

Edit: Please move to General / General support.
 

[Weird ID in inventory table.]

Aye. but the only char_id's I have are 1 to 20.
The account_id's are from 200000 though.

I did do a truncate on the char table, could be why but I would have expected that to reset the auto increment column char_id.

In hind site maybe it is possible that I neglected to turn off the server during the truncate on those tables and it delay saved stuff from old characters I was testing with that I thought were logged off :S
Still odd that the records are "orphaned" but I guess that is by design since MyISAM does not support foreign keys~

Thanks for the explanation though sikiro.
I guess it should be safe to delete the erroneous records.

 

[Weird ID in inventory table.]

Hey, weird char_id such as 150001 showing up in inventory and picklog.

SELECT * FROM inventory WHERE char_id NOT IN (SELECT char_id FROM `char`)

Just wondering what those are is it some special kind of identifier?

 

Thanks.

[Packet Obfuscation ?]

Hey sorry, due to IRL,
I have not yet been able to update the code to see.

But I plan to try again soon :).

Let us know if you find anything too.

[Packet Obfuscation ?]

This happens for me as well.
Still trying to figure out why.

Will re-enable the obfuscation and see how things play out.
Certainly it is the right port in the client info.

 

Error shows in client after selecting character to play as.

 

 

Last known commit that worked for me was.
e820ef9090a02e8483ef672147e159210dd09c16

I'll work my way back up the list of commits that are on master to see when it happens :).

 

[Marketwatch for Private Server]

Write your self I think.

I'm thinking of making one too.
But I think some source mods would be needed to update the merchants table and logs a little bit more maybe.

Or some sort of extra fee for vendors to register their shop on the site.

Maybe d3.js for some charts/graphs or something too :).

[Error alt + W]

Ah thanks for investigating the cause of the matter  Anacondaqq :).

If we add this back in will it fix? Is there a pull request on git?

[Error alt + W]

Hi please post if you find a server side fix. Thanks Azura Skyy, ill check those threads also :).

I did a client side mod because I could understand that easier than server side...

Sorry about the size of it (copy pasted from my spreadsheet of changes/fixes)

Spoiler

Alt+W / opening cart items does not work				Find the string in client side data/msgstringtable.txt
Vending is Prohibited in this map.				Line 2381, so search for a push 2380
2013 clients appear to be impacted.
				00595D7C - A1 B0BFCA00 - mov eax,[00CABFB0] : [00000000]
				00595D81 - 8B 0D D875C900 - mov ecx,[00C975D8] : [0B0A9170]
				00595D87 - 6A 28 - push 28
				00595D89 - 50 - push eax
				00595D8A - E8 A1E52000 - call 007A4330
				00595D8F - 85 C0 - test eax,eax
Patch the jne to a nop nop				00595D91 - 75 38 - jne 00595DCB
				00595D93 - 50 - push eax
				00595D94 - 50 - push eax
				00595D95 - 50 - push eax
				00595D96 - 50 - push eax
				00595D97 - 6A 03 - push 03
				00595D99 - B9 F89FB000 - mov ecx,00B09FF8 : [0097811C]
				00595D9E - E8 6D5B0000 - call 0059B910
				00595DA3 - 6A 00 - push 00
				00595DA5 - 6A 00 - push 00
				00595DA7 - 68 FF000000 - push 000000FF
				00595DAC - 68 4C090000 - push 0000094C
				00595DB1 - E8 BAD00800 - call 00622E70
				00595DB6 - 83 C4 04 - add esp,04
				00595DB9 - 50 - push eax
				00595DBA - 6A 01 - push 01
				00595DBC - B9 F89FB000 - mov ecx,00B09FF8 : [0097811C]
				00595DC1 - E8 4A5B0000 - call 0059B910
				00595DC6 - E9 BA490000 - jmp 0059A785
				00595DCB - 39 BE BC030000 - cmp [esi+000003BC],edi

 

[2013 08 07 client problem....]

Same issue with 2013-12-23c

[Client crash when making new grf/adding items.]

How did you solve this problem? I am encountering it too.
I might try wiping everything and starting again soon.