I need an SQL query that would allow me to look up and edit the stats on a player account. Bear in mind that the player accounts must be stored in a table called "accounts". I also need an SQL query that sets the admin level of all disabled accounts to 0, (disabled = 1 means disabled) and also in the table "accounts" with columns "AdminLevel" and "Disabled". Thank you in advance.

The first thing you're asking for would require me to know your variable/enum structure.

I can't fully understand you as I am not a professional in MySQL, but what variable/enum structure do you need ?
Can't it be done within the table "accounts" (that stores the players' accounts). Thank you for the other one !

I can't fully understand you as I am not a professional in MySQL, but what variable/enum structure do you need ?
Can't it be done within the table "accounts" (that stores the players' accounts). Thank you for the other one !

The table is where the data is stored, but I don't know the table structure. So, I couldn't give you working loading code. I can give you the query to GET the information, but you'll need to do the loading for yourself...

It would be:

Code:

"SELECT * FROM `accounts` WHERE `username` = '%s'"

Obviously you'll have to put that into a format line so you can replace the %s with a username during runtime. Also, if "username" isn't a valid field in your table, change it to whatever is the valid field to store someone's username.