I figured out how to do this.please add feature to sort by username.
$WHVArray = $db->fetchAll("SELECT user_id FROM xf_user as user WHERE last_activity BETWEEN '$datemin' AND '$date' $bannedExcluded $userPrivacy ORDER BY last_activity DESC");
thanks @viper357I figured out how to do this.
Edit the following file from the add-on:
library >> XenTrCom >> WhoHasVisited >> Model >> XWhoHasVisited.php
Look for this code (it's on line 40 of my file)...
Code:$WHVArray = $db->fetchAll("SELECT user_id FROM xf_user as user WHERE last_activity BETWEEN '$datemin' AND '$date' $bannedExcluded $userPrivacy ORDER BY last_activity DESC");
At the end of the line, change......
ORDER BY last_activity DESC");
to
ORDER BY username");
Did you use widget framework?
Than there is an optionin the widget for the order of display.
But you have arrange all other widgets accordingly.
View attachment 136402
Any idea of how to get it to display in standard, 12 hour time? It's currently set to military time (24 hours).
Any idea of how to get it to display in standard, 12 hour time? It's currently set to military time (24 hours).
Bump for similar answer please!
{xen:date {$XWhoHasVisited.user.last_activity}, 'H:i'}
Well - this is bizarre. I still can't find it - even under options. But it's working on the live forum - viewable for all.It's under Options. On mine, it's near the top. "Xen-TR.com Who Has Visited"
![]()
We use essential cookies to make this site work, and optional cookies to enhance your experience.