FUDforum: FUDforum 3.0+ » User Manager Sorting

Home » FUDforum Development » FUDforum 3.0+ » User Manager Sorting

Show: Today's Messages :: Polls :: Message Navigator

Re: User Manager Sorting [message #166366 is a reply to message #166364]

Fri, 25 November 2011 16:31

jm2morri

Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...

Karma:

Senior Member

A quick followup after a bit more digging on my side. I used this

SELECT login, FROM_UNIXTIME(last_login) FROM fud_users ORDER BY last_login DESC LIMIT 100;

and it seems to work OK. It lists users based on last login. A user that is created because of message imported using NNTP has a login date in 1969 so it works pretty well I think.

Also, for newbies the prefix of "fud_users" above may be "fudyyy_users" where yyy is a number. You can tell by clicking on the "insert table name" drop down box in SQL manager and you'll quickly see the prefix on every table. Took me a minute to remember that.

Cheers,

James.

Report message to a moderator

[Message index]

		User Manager Sorting By: jm2morri on Thu, 24 November 2011 10:42
		Re: User Manager Sorting By: naudefj on Thu, 24 November 2011 12:01
		Re: User Manager Sorting By: jm2morri on Thu, 24 November 2011 12:03
		Re: User Manager Sorting By: naudefj on Fri, 25 November 2011 08:38
		Re: User Manager Sorting By: jm2morri on Fri, 25 November 2011 16:25
		Re: User Manager Sorting By: jm2morri on Fri, 25 November 2011 16:31

Previous Topic:	Static Page Manager (answered)
Next Topic:	SQL Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 09:19:55 GMT 2024

Total time taken to generate the page: 0.04000 seconds