Update player job using SQL

[Kasperzi]

Hello community,

Can anyone help me with updating the player job using SQL?
For example, you have PHPMyAdmin or Heidi SQL and run SQL script to update player job from “police” to “medic” using SQL. (only using SQL not being on the server).

Like real-time update or at least user relog to get it to work.

Want to create a panel where you can get all users and update jobs using PHP & SQL.

Any help is appreciated.

Thanks.

[J0eri]

If you wanna make all police medic:

UPDATE your_table_name SET job = 'medic' WHERE job = 'police'

If you wanna make someone a job:

UPDATE your_table_name SET job = 'medic' WHERE steam_id = 'steam:123456789'

Change out your_table_name with the name of your table.

[Kasperzi]

Hi J0eri,

Thanks for the reply.

I tried that and it set in the column but not in-game.
It doesn’t need to be “real-time” but it won’t update the user. After few seconds it will get the user back to his previous job.

[J0eri]

Probably there is code inside your server that syncs it again then. So when a user logs out it saves the job that the gameserver knows. So or you need to change that code or you first need to tell them to logoff then change it end let them log back in.

[Kasperzi]

Hmm, I’ll try that option. When user is not playing to change and then when he connects will he have that job.