How are user shops "stored"? I couldn't find a database table with such information.

[Saita]

Hi. I want to create a rest service where I can fetch information of every user opened shop in the server.
I thought that this information might be stored in the database but I can't seem to find the relevant information.

Now I am assuming this information is kept in memory. Is it possible to access this information from outside rAthena?

How would you suggest I tackle this?

[Akkarin]

55 minutes ago, Saita said:

Is it possible to access this information from outside rAthena?

If you know how to access memory, sure.

If not, then no. Player Vends are stored in memory unless they're AutoTrade Vends, then they're saved to the `vendings` and `vending_items` MySQL tables.

[botka4aet]

Check herc plugin - https://github.com/HerculesWS/StaffPlugins/blob/master/Yommy/Vend_SQL/Vend_SQL.c

Convert it to rathena

Good job!

[Saita]

Actually my problem is somewhat different. 

I wanted to do this in a less invasive manner. 

I am making a website where I want to list the shops from multiple private servers. 

I am reaching out to server admins and pitching the idea. 

Right now, players have to open up their shops manually so it's really difficult to get people to use it. 

If I could come up with some sort of integration that I could send to the server admins and easily fetch the information for my website. 

I thought about making a docker container with a simple app that they could run. I imagined the shop information was in the database so the app would connect to the database and send the info to my website via rest api. 

I believe making a plug-in like suggested would make server owners harder to convince. 

Another idea I had was using a bot to walk around and fetch the shops, but some servers have guard, and this solution kind of sucks. 

I am not sure but maybe it's just not meant to be.