user Table - Last visit / activity fields

[King Kovifor]

To turn it into a date, you must use vbdate(). There are comparisons with the numbers. Let me look at my information and give you a good explaination.

To find a time in a specified time you would create a variable and assign it a time like in vBulletin... Something like this:

$last_month = time() - 60*60*24*60

The explainaion of the last numbers is:
seconds x minutes x hours x days)

Then in your query, you use something like this...

WHERE time > $last month

... in your WHERE clause.

That'll fit you into the last month value. To find the date you want (say when a post was made or so), you'd use vbdate(). I really haven't used it so I couldn't explain it and it's arguments.