How to get notes from postgress database

[uajka]

Hello
I'd like to take notes directly from database.
I use pgadmin III and when put
"select * from notecaddy_data where player_id = 4; I get result :

"52-2,20,37,-23,63,-59,-86,286,294,-1444,-1521,-1591,-1999,-2569,2600,-2616,-2639,-2874,-2965,-2974,-2988,-5851,9452,-9464,9490,-9514,9554,-9581,9582,-9590,-9611,-9608,9621,-9638,9631,9665,-9677,-9682,9694,9706,9717,9732,-9751,9772,9813,9830,9852,-9848,-99 (...)"
What is it?


How to get notes which notecaddy created ?

Best Regards

[sreticentv]

This is described in more detail here NoteCaddy note creation information - Assaultware Wiki

[uajka]

I checked that one.
"One row is created for each player and the full data is stored as a single piece of text"
Where exactly is stored (which column?), because i checked table notecaddy_data and don't see any text

[sreticentv]

"52-2,20,37,-23,63,-59,-86,286,294,-1444,-1521,-1591,-1999,-2569,2600,-2616,-2639,-2874,-2965,-2974,-2988,-5851,9452,-9464,9490,-9514,9554,-9581,9582,-9590,-9611,-9608,9621,-9638,9631,9665,-9677,-9682,9694,9706,9717,9732,-9751,9772,9813,9830,9852,-9848,-99 (...)"

This is text. Maybe not human readable but it is technically text

[uajka]

Yes, technically.
Any chance to transform it to the same form I can see in hm2? Any help on that?
for example "misses cb out of position"

[sreticentv]

You'd have to write a program to do that. A big part of the source code to make such a program is listed in that wiki page. If you're not clear about anything there I can try to help but I can't think of how better to help than to publish the source code of how to do it