E
Evil Puncker
Guest
hi guys, we used to have a 'online' column in players table, now we got the player_id in the players_online table, how do I make this query work with the new table?
instead of "where online = 1;" I need the SQL equivalent of "where player_id is present in the players_online table"
db.query("UPDATEplayers
SETonlinetimetoday
=players.onlinetimetoday+60,onlinetimeall
=players.onlinetimeall+60 WHEREonline
= 1;")
instead of "where online = 1;" I need the SQL equivalent of "where player_id is present in the players_online table"