Jump to content
  • 0

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


Saita

Question


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  7
  • Reputation:   0
  • Joined:  02/24/21
  • Last Seen:  

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?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

  • Group:  Forum Manager
  • Topic Count:  282
  • Topics Per Day:  0.06
  • Content Count:  3122
  • Reputation:   1614
  • Joined:  03/26/12
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  211
  • Reputation:   17
  • Joined:  12/23/11
  • Last Seen:  

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  7
  • Reputation:   0
  • Joined:  02/24/21
  • Last Seen:  

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. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...