Stuck on script

[JDB]

How do you get promote.lua to work while player is offline or online?

 

[Cykotitan]

check if the player is online, if not - check whether he/she exists in database and then update him using a query if he/she does.

 

[JDB]

Yes I know that, but what query do I need to exucute to do so?

 

[zakius]

NOT IN (SELECT name FROM players) can be useful to check if player with this name exists, don't know if tfs have own function to check if player is online or just uses sql query.