Jump to content

query based of online or offline?


Recommended Posts

Hey i have something im trying work out, i have a tier of ranks, and each rank is earned by being online(well thats what i want) the way i was trying go about it is on my hourly cron have it set so those online go up a rank and those offline go down a rank, BUT i dont know how to properly run that query. i tried this

$db->query("UPDATE users SET rank=rank+1 WHERE laston >= time()-15*60");


i think its because this "time()" but im not really sure how to pull this off ????:confused:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...