'Sort By' Options in "Who's Online" (online.php)

ok, I wrote this (very small) hack in online.php because I'd rather view the list
sorted by the Last Active time (latest first) than by the sorted by username a-z.
And, sometimes I want to view the list sorted by location - which gives
a very clear and nice picture of where people are currently crowding.

I went on and also added an option to sort by IP address - which allows me
to see if there are users from the same IP at the same time, etc.

This works exactly the same as the Forum Display sorting (where you can
click on "Threads" or "Replies" and the display listing gets sorted by that
field, and the sort/opposite sort arrow 'jumps' next to it).

Installation:

Open online.php and find:

 $allusers= $DB_site->query("SELECT user.username,

ABOVE it ADD:

 if ($order!='asc') {
   $sqlorder='DESC';
 } else {
   $sqlorder='ASC';
 }
 if (!$sortby) {
 	$sortby = "username";
 }
 switch ($sortby) {
 	case username:
 		$sqlsort = "user.username";
 		break;
 	case location:
 		$sqlsort = "session.location";
 		break;
 	case time:
 		$sqlsort = "session.lastactivity";
 		break;
 	case host:
 		$sqlsort = "session.host";
 		break;
 }
 
 $sorturl="online.php?s=$session[sessionhash]";
 $oppositesort=iif($order=='asc','desc','asc');
 
 eval("\$sortarrow[$sortby] = \"".gettemplate('whosonline_sortarrow')."\";");

still in online.php, find:

ORDER BY user.username

REPLACE this with:

ORDER BY $sqlsort $sqlorder

Save and upload.

Templates:

ADD NEW templated called whosonline_sortarrow and place in it (remove spaces in { imagesfolder }):

<a href="$sorturl&order=$oppositesort&sortby=$sortby"><img src="{ imagesfolder }/sort$oppositesort.gif" border="0" alt="Reverse Sort Order" align="absmiddle"></a>

save.

OPEN template whosonline

Find (without the spaces in {}):

	<td bgcolor="{ tableheadbgcolor }"><smallfont color="{ tableheadtextcolor }"><b>User Name</b></smallfont></td>
	<td bgcolor="{ tableheadbgcolor }"><smallfont color="{ tableheadtextcolor }"><b>Location</b></smallfont></td>
	<td bgcolor="{ tableheadbgcolor }"><smallfont color="{ tableheadtextcolor }"><b>Last Active</b></smallfont></td>

REPLACE it with (removes spaces in {}):

	<td bgcolor="{ tableheadbgcolor }"><a href="$sorturl&order=asc&sortby=username"><smallfont color="{ tableheadtextcolor }"><b>User Name</b></smallfont></a> $sortarrow[username]</td>
	<td bgcolor="{ tableheadbgcolor }"><a href="$sorturl&order=asc&sortby=location"><smallfont color="{ tableheadtextcolor }"><b>Location</b></smallfont></a> $sortarrow[location]</td>
	<td bgcolor="{ tableheadbgcolor }"><a href="$sorturl&order=desc&sortby=time"><smallfont color="{ tableheadtextcolor }"><b>Last Active</b></smallfont></a> $sortarrow[time]</td>

save.

OPEN template whosonline_ip.

REPLACE the ENTIRE content of the template with (removes spaces in {}):

<td bgcolor="{ tableheadbgcolor }"><a href="$sorturl&order=asc&sortby=host"><smallfont color="{ tableheadtextcolor }"><b>IP</b></smallfont></a> $sortarrow[host]</td>

Save.

That's it.

Cheers,

Bira

[Princeton]

kewl ...thank you.

[SirSteve]

Excellent! Thanks!

[Chris Blount]

Great hack but I notice that each time the who's online refreshes, it defaults to the names being in reverse alphabetical order. Is there a way to get them back to alphabetical order by default like they were before the hack?

[Kars10]

Works nice!!
Thanx 4 this great Hack!! :-)

[inetd]

/me install this hack

Good add-on to Who's Online, bira! :tup:

[Brad]

Very nice bira. ive had it installed before and it went well under my new 2.2.7 forums.

however im hoping someone can give me a solution for a tiny problem. you see. if you click the link to sort by Last Active, it will sort by user name once WOL is re-loaded.

try it on my forums (guest can view my who's online page) http://www.kousetsu.net/kan/online.php?s=


anyone got any ideas? :ermm:

[BigCheeze]

Thanks! Works great!!!

[Bison]

Installed!

[julius]

Installed.
Thanhs.

[gmarik]

Fine, fine

/me likes it