Hi, Over the past 2 Weeks I have successfully written a forum system which is almost complete and is just lacking a few features.
Both of these things require me to be able to check how much time has passed:
Firstly, I need to display which users are online in the last 15mins based on click. This will not count guests but only logged in users. I have a column in my users profile table called ‘last_click’ which will be updated with a timestamp when a user clicks on anything from the forum home, site home to another users profile or even editing settings.
Secondly, I also have saved a timestamp when the user registered (as well as a column just for date) so that cron jobs can check the users every 30mins and delete any accounts which have not been email validated within 7 days.
So basically, one I need to check within last 15mins and one that checks for registered in more than 7 days but hasn’t been validated (not less than 7 days, at least 7 days)
Thanks in advance