PHP How I read player_items.attributes?

[Engradiel]

When I use this in php:

$test = $SQL->query('SELECT attributes FROM `player_items` WHERE player_id = 13352 and pid = 1 and itemtype = 2496')->fetch();         
print $test['attributes'];

How Can I decrypt this information?

 

[Evil Hero]

You can find the necessary information in those functions

forgottenserver/src/item.cpp at master · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

and here are the header attributes (numbers)

forgottenserver/src/item.h at master · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

The header is always a size of uint8_t followed by the attribute itself which can vary between types of uint int or string
With the provided links you should be able to replicate everything needed

 

[Engradiel]

But I can read it on php.
Using it:

SELECT CONVERT(attributes USING utf8) FROM player_items

Shows. But other table that I want seems different format.

 

[Fjorda]

Souls of Elysium | RPG (https://mortalis.soerpg.com/characterprofile.php?name=Eva)
I accomplished this here (hover over the equipment), and on many other OT sites I've worked on.

First, as Evil Hero suggested, you need to see how your server is deserializing the attribute data.
Second, build a lib with all your unpacking functions, such as unpacking int8, uint8, int16 etc.. and getString(). (there are many open-source options you can look into)
Third, Build a lib that mimics the deserialization code from the game server. If you follow the code correctly, you will arrive at the expected result.

 

[tobi132]

If you use myaac, then you can use this class

myaac/system/libs/pot/OTS_Buffer.php at master · slawkens/myaac

A free and open-source Automatic Account Creator (AAC) written in PHP - slawkens/myaac

github.com

usage:

$buffer = new OTS_Buffer($test['attributes ']);

Then use the functions to read the data:

$buffer->getChar();
$buffer->getShort();
$buffer->getLong();
$buffer->getString();

$buffer->skip($x);