The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
WhoIsOnline: Sort Ip Address
Hi guys,
I?m not sure that I?m posting in the right subforum i just want to show a small "workaround" for sorting (desc/asc) ip addresses in the online.php (whoisonline). By default, it?s not possible to sort the ip address column. You can modify the sort parameter to host (in a prepared hyperlink) but you won?t by able to get a great result Just have a deeper look into the online.php file: Code:
switch ($sortfield) { case 'location': $sqlsort = 'session.location'; break; case 'time': $sqlsort = 'session.lastactivity'; break; case 'host': $sqlsort = 'session.host'; break; default: $sqlsort = 'user.username'; $sortfield = 'username'; } Just change the line to: Code:
$sqlsort = 'inet_aton(session.host)'; Then you will be able to sort the column ip addresses by a prepared link. Now we want to implement a "gui" functionality by clicking on the column header. Just go to your vbulletin templates, search for "whosonline"! Replace line: Code:
<vb:if condition="$show['ip']"><th><span class="blocksubhead">{vb:rawphrase ip_address}</span></th></vb:if> Code:
<th><a class="blocksubhead" href="{vb:raw sorturl}{vb:if !$show['sorturlnoargs'], '&'}<vb:if condition="$sortarrow['host']">order={vb:raw sortarrow.oppositesort}&</vb:if>sort=host&pp={vb:raw perpage}&page={vb:raw pagenumber}">{vb:rawphrase ip_address} {vb:raw sortarrow.host}</a></th> Greetings, steve |
#2
|
|||
|
|||
Thanks for the useful tip
|
#3
|
||||
|
||||
Great little tip there, thanks.
|
#4
|
||||
|
||||
Good tip! Thanks.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|