Show Last Visited on Member List

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

Hack: Show Last Visited on Member List
PHP-Nuke Version: 7.5
Patchset: 2.8
Theme: fisubsilversh
Other Mods: Approve Membership Module 6.0
Files to Modify:
- modules/Member_List/index.php
- themes/fisubsilversh/forums/memberlist_body.tpl

I wanted an easy way to see not just who last signed up on my nuke sites but also to see, very quickly, who the most active users from a last visited standpoint, or to see who activated their accounts but never logged in. I was dissappointed in the various blocks out there which promised the same thing, but for some reason only worked if the user physically logged off. Since most users tend to stay logged in, they were skewing the information.

Updates to Make to: modules/Member_List/index.php

Code:

####Find####
$cellcount = "8";

####Replace With####
$cellcount = "9";

####Find####
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar

####Replace With####
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_lastvisit

####Find####
$username = $row['username'];

####After Add####
$lastvisit = $row['user_lastvisit'];
$lastvisit = date("D M j G:i Y", $lastvisit);

####Find####
'USERNAME' => $username,

####After Add####
'LASTVISIT' => $lastvisit,

Updates to Make to: themes/fisubsilversh/forums/memberlist_body.tpl

Code:

####Find####
<th>{L_WEBSITE}</th>

####After Add####
<th>Last Visit</th>

####Find####
<td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.WWW_IMG} </td>

####After Add####
<td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.LASTVISIT} </td>

Note that strange dates like the following are an indication that the user activated their account but never logged in afterwards.

Code:

Wed Dec 31 17:00 1969

Regards,
montego

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

Hack: Show Last Visited on Member List
PHP-Nuke Version: 7.5
Patchset: 2.9
Theme: FiSubNuke
Other Mods: None
Files to Modify:
- modules/Member_List/index.php
- themes/FiSubNuke/forums/memberlist_body.tpl

I wanted an easy way to see not just who last signed up on my nuke sites but also to see, very quickly, who the most active users from a last visited standpoint, or to see who activated their accounts but never logged in. I was dissappointed in the various blocks out there which promised the same thing, but for some reason only worked if the user physically logged off. Since most users tend to stay logged in, they were skewing the information.

Updates to Make to: modules/Member_List/index.php

Code:

####Find####
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar

####Replace With####
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_lastvisit

####Find####
$username = $row['username'];

####After Add####
$lastvisit = $row['user_lastvisit'];
$lastvisit = date("D M j G:i Y", $lastvisit);

####Find####
'USERNAME' => $username,

####After Add####
'LASTVISIT' => $lastvisit,

Updates to Make to: themes/FiSubNuke/forums/memberlist_body.tpl

Code:

####Find####
<th>{L_WEBSITE}</th>

####After Add####
<th>Last Visit</th>

####Find####
<td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.WWW_IMG} </td>

####After Add####
<td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.LASTVISIT} </td>

####Find####
<td class="cat" colspan="8">

####Replace With####
<td class="cat" colspan="9">

Note that strange dates like the following are an indication that the user activated their account but never logged in afterwards.

Code:

Wed Dec 31 17:00 1969

Regards,
montego