i'm looking for this hack

[Broekie]

just one reminder: last visit isn't the same as last activity....
for as far as I've researched it I came to the conclusion that last visit must be the last time they logged in. If they use cookies they can keep visiting your board without logging in again for a long time
But, then again, there isn't a searchfield in your admin cp for last activity

I wrote these .php scripts to check the lastactivity.
I know, the scripts could be much better, but hey, it works

It are two scripts. lastactivity1.php uses ORDER BY USERNAME and lastactivity2.php uses ORDER BY LASTACTIVITY

Just download, and replace these thingies:
servername: hostname or ip of server (probably localhost)
dbusername: the mysql user name
dbpassword: well duh
dbname: the name of the database

If you don't know this info, you can look it up at the config.php in the admin dir of your board.

Then just upload it to anyplace on your server, and load it in your browser


btw, the result is a table with 2 columns and <the number of members of your forum> rows
Column 1 contains the username, column 2 contains the date and time of the last activity.
If you want to use this to look for inactive users, use lastactivity2.php and start at the bottom of the file. Check the date and mail the user when you decide that his/her last activity is to long ago.