> 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.

If you use some other form of authentication you can probably get what you want.  Doesn't Active Directory log more than you need to know about users?  Try using, looking at, or writing an Auth extension. -Courtney -----Original Message----- From: mediawiki-l-bounces(a)lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Francois Piette Sent: Wednesday, October 21, 2009 2:49 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Last login time Hello Brion, OK. Maybe there is a hook somewhere to plug in some extension to do that login ? Indeed. Same question as above : is there a hook somewhere to plug in an extension that would log the user validation ? Even if the browser "remember" (cookie) that a user is already authenticated, that must be surely verified within the wiki. At this could be the place to log each access. Thanks, -- francois.piette(a)overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l