Read BLOB data

[SpiderOT]

Hello,

could someone tell me how to read blob data with lua?
like from player_items field "attributes"
would be great if someone can give example with lua or just the sql query xD
Thanks

 

[SpiderOT]

Bump ^^

 

[SzukamLaya]

Slawkens (TFS developer) sad last time that its no way to read those attr from lua level.
You must wait some time if u really want to read it, but maybe you can do it another way...
What do u want to exactly do?

 

[Gurrha]

hey Spider try something whit
SELECT `attributes` LIKE CONVERT( `attributes` USING latin1 ) FROM player_items

 

[SpiderOT]

it is hard to edit it, read it shouldn't be that hard xD and i will use it for anti dupe system also might release it
Gurrha : it just give list with 1 or 0

 

[Cykotitan]

yup, the attributes are binary/bitwise?. if you learn how are they saved, this could be easier and you might even be able to write a Lua function for parsing the bits

 

[SpiderOT]

Format by Stian

uint16_t fields
for each fields:
uint16_t slen
string key = position in read + 1 to position in read + slen
uint8_t type (1 for string (same method as the two fields over here), 2 for int (32bit), 3 for float (32bit) and 4 for bool (1bit))
<type> attribute = position in read to position in read + size

but i have no idea what is it xD

 

[Gurrha]

yea spider sry i saw that when i made try
but hey if you find out will you realese the anti dupe system?