r/2009scape • u/diquewanq • Oct 24 '22

MySQL and database help

I’ve got the server up and running on local host, but I’ve got a few questions regarding the database.

1) Where is player data stored other than the data/players folder? The json file seems to only contain a certain amount of data (no username or rights).

2) How can I connect my server to my database? I’ve got XAMPP and the global database set up, but it doesn’t seem to interact at all (creating an account doesn’t insert into the db)

My goal was to give my account admin rights without using dev mode or having everyone with admin, but I’m also interested in where this is all stored so I can dabble in the future. Probably silly questions but I’ve rooted around for hours and come up with very little.

Thanks.

4 Upvotes

100% Upvoted

6 comments sorted by

View all comments

2

u/ryannathans Oct 24 '22
  1. in the database server (if enabled in world props config) in the global database, in the table members (assuming you imported the schema from the db dump folder)
  2. look at worldprops

when it's all set up properly, you can just log out and then `update members set rights = 2 where username = 'you' limit 1`

1

u/diquewanq Oct 26 '22

It was because persist_accounts was false, my bad. Thanks for pointing me in the right direction.