[ApoziX]

I got an rp script and I want to create online status, I got the mysql row "Online"

But I dont know how to put it In script

I want it to update the row "Online" onplayerconnect to 1 And onplayerdisconnect to 0

How can I do it?

[Banditul18]

SQL update query

[ApoziX]

Quote:

Originally Posted by Banditul18 SQL update query

PHP код:

OnPlayerConnect 
new query[250];
    mysql_format(MysqlCon, query, sizeof(query), "UPDATE `users` SET `Online`=1 WHERE `uid`=%s",
    PlayerName(playerid));
    mysql_tquery(MysqlCon, query, "", ""); 


Like That?

[Calisthenics]

When the player connects, you only know their name. Let them login and on success, update `Online` column.

Also string specifier requires apostrophes '%s' or when escaping input '%e'

[ApoziX]

Quote:

Originally Posted by Calisthenics When the player connects, you only know their name. Let them login and on success, update `Online` column. Also string specifier requires apostrophes '%s' or when escaping input '%e'

Thank you for the advice