On 10/15/09 1:21 AM, Francois Piette wrote:
Hello,
I would like to query the wiki database to get a list of users with their last login time.
The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ?
Logins are not logged as such by MediaWiki.
Note that the user_touched cache invalidation timestamp updates on logins, preference changes, notifications, etc, but doesn't necessarily imply an action by the user themselves.
Note also that any particular session doesn't necessarily require going through the login form, as with a saved login token a user may remain logged in for up to a month within the same browser.
-- brion