Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Seach users - additional params

Quote Reply
Seach users - additional params
I'd like to be able to search on the following:


1. Users who've registered but never logged in, within a given date range (say all users registered prior to XYX date).

2. Users who've registered, but were only seen once.

3. Users who haven't been seen since a given date.


Then I'd like to purge the user base along the same lines. And I wonder how many users would such a search reveal in the first two categories here?

Large user registration numbers are nice, but I don't need mine inflated by ghosts.
Quote Reply
Re: [ArmyAirForces] Seach users - additional params In reply to
In Reply To:
1. Users who've registered but never logged in, within a given date range (say all users registered prior to XYX date).
You can determine users who have never logged in and haven't been seen since a certain date by entering some date ('yyyy/mm/dd' format) on the Date Registered and Last Logon fields on the search page. Unfortunately, this won't bring up users who have _never_ logged in, but you might be able to get around this by setting the user_last_logon column to not null - it shouldn't break anything to do so. Unfortunately, there is a small bug in this search - if you open up admin/GForum/HTML/User.pm, and look for the second occurance of user_registered-opt, it needs to be changed to user_payment_expiry-opt.

In Reply To:
2. Users who've registered, but were only seen once.
Unfortunately, Gossamer Forum has no way to get this data - it only knows the registered date, the last login, and the last seen time, but doesn't know how many times the user has logged in.

In Reply To:
3. Users who haven't been seen since a given date.
Simply perform a search with Last Login containing something like: '2002/7/1' and the dropdown set to "Before" to search for anyone who hasn't logged in since July 1st, 2002.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com