| User Manager Sorting [message #166352] |
Thu, 24 November 2011 10:42  |
jm2morri
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
|
Senior Member |
|
|
Hello everyone,
Today I wanted to go and take a look at who was recently logging into my forums lately. I've never done that before but I figured there should be a way. So I went to the admin pages and then to the User Manager. I did a blank search and the start of the list of users came up. So far so good. Like most places, if you click on the column header I expected it to resort the data on that column. So I click on "last online" column and it does resort. But it only resorts the data displayed on the page, not the entire list of users.
This seems like a bug to me. Resorting should resort the entire data set, not just the part of the set that is currently displayed. Or maybe I'm doing something wrong.
Cheers,
James.
|
|
|
|
|
|
|
|
|
|
|
|
| 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: 0
|
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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]