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);

 

[Engradiel]

Thanks Bro. Know I have other doubt:

How I read abilities now?

 

[tobi132]

Thanks Bro. Know I have other doubt: View attachment 87048

How I read abilities now?

Same way you read attributes that I posted. Just different format, but also BLOB, so usage is same.

 

[Engradiel]

Same way you read attributes that I posted. Just different format, but also BLOB, so usage is same.

But I use gesior acc not myacc

 

[Gesior.pl]

But I use gesior acc not myacc

Copy this file contents from MyAAC:

https://raw.githubusercontent.com/slawkens/myaac/refs/heads/master/system/libs/pot/OTS_Buffer.php

to Gesior2012 subfolder classes with filename ots_buffer.php (lowercase name of PHP class) and then you use OTS_Buffer class anywhere in Gesior2012 code ex. code like in @tobi132 post:

T

PHP Post in thread 'How I read player_items.attributes?'

Mar 21, 2024

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);

• tobi132

• 

 

[Engradiel]

Yeah, but not works





Look that Roleta Reward is attributes information (description) and is reading.
But abilities column not works...

Post automatically merged: Oct 3, 2024

Now i changed the folder to classes like gesior suggest:

Post automatically merged: Oct 3, 2024

When I use this page broke: