14.08.2018, 14:14
I was wondering how do you demote someone offline, I'm using MySQL r41-2 and I need to know how can you check if someone exists on the database? are there any tutorials regarding this ?
INSERT INTO accounts( `adminlevel`) VALUES(`%d`) WHERE `pname` = `%e`, newAdminLevel, NameOfPlayer
Yeah thanks, but what about detecting the player on the database?, like, "This user is not registered in our database", what are the right checks ?
|
You command should run a query on your database
Код:
INSERT INTO accounts( `adminlevel`) VALUES(`%d`) WHERE `pname` = `%e`, newAdminLevel, NameOfPlayer |
UPDATE acounts SET adminlevel = %i WHERE name = '%s'
If you decide to help atleast make sure the information you give its correct. Its not INSERT INTO, it suppose to be UPDATE
Код:
UPDATE acounts SET adminlevel = %i WHERE name = '%s' Edit: coool method works aswell |