Search for item inside a house, binary map map_store

[Stellow]

Hello, how do I search for specific item if I am using binary saving method for houses? Table map_store, there are two coluns, house_id, and data (blob).

 

[Stellow]

Bump

 

[Stellow]

bump

 

[Lordfire]

Unblob/parse the data field and search in there. What have you tried to do already?

 

[StreamSide]

u mean in game (real time) or wat?

 

[Stellow]

u mean in game (real time) or wat?

I want to select an item by id thru database.

Unblob/parse the data field and search in there. What have you tried to do already?

I tried to unblob it, coulnt read a file. Anyway, there is no command in databse to search for a information inside a blob file, isnt there?

 

[StreamSide]

I want to select an item by id thru database.

I tried to unblob it, coulnt read a file. Anyway, there is no command in databse to search for a information inside a blob file, isnt there?

what about blob extractor ?

 

[Lordfire]

I tried to unblob it, coulnt read a file. Anyway, there is no command in databse to search for a information inside a blob file, isnt there?

No, not really. Blob columns are meant to be manipulated solely by applications, not the database.

 

[Stellow]

what about blob extractor ?

can work, but i am looking to search an item in the whole database, in the many blobs there are in my database.