"User last visit" field in user list menu?

gabriele · Last edited by gabriele on Fri Mar 04, 2005 3:46 pm; edited 1 time in total

Hi all! Is it possible to have in the user list page a "user last visit" field? I saw the user_lastvisit field in the SQL database but I can't do it by myself... Embarassed

Thanks!! Gabriele

MrMastah

Yes! Exactly what I want too! Can anyone explain how to do it? Please?

//Mastah

Jeruvy

I would suggest this is a good idea and it should be posted in requests and ideas.

safecracker4hire

Hi gabriele;
Open modules/Members_List/index.php

FIND

Code::

$template->assign_vars(array(
	'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
	'L_USERNAME' => $lang['Username'],
	'L_EMAIL' => $lang['Email'],
	'L_WEBSITE' => $lang['Website'],
	'L_FROM' => $lang['Location'],
	'L_ORDER' => $lang['Order'],
	'L_PRIVATE_MESSAGE' => $lang['Private_Message'],
	'L_SORT' => $lang['Sort'],
	'L_SUBMIT' => $lang['Sort'],
	'L_AIM' => $lang['AIM'],
	'L_YIM' => $lang['YIM'],
	'L_MSNM' => $lang['MSNM'],
	'L_ICQ' => $lang['ICQ'],
	'L_JOINED' => $lang['Joined'],
	'L_POSTS' => $lang['Posts'],
	'L_PM' => $lang['Private_Message'],

ADD AFTER

Code::

	'L_LASTVISIT' => $lang['Last_Visit'],

FIND

Code::

$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

CHANGE TO

Code::

$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

Code::

		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

ADD AFTER

Code::

                $lastvisit = date('M d, Y @ g:ia', $row['user_lastvisit']);

Right under that you will see

Code::

		$template->assign_block_vars('memberrow', array(
			'ROW_NUMBER' => $i + 1 + $start,
			'ROW_COLOR' => '#' . $row_color,
			'ROW_CLASS' => $row_class,
			'USERNAME' => $username,
			'FROM' => $from,
			'JOINED' => $joined,
			'POSTS' => $posts,
			'AVATAR_IMG' => $poster_avatar,
			'PROFILE_IMG' => $profile_img,
			'PROFILE' => $profile,
			'SEARCH_IMG' => $search_img,
			'SEARCH' => $search,
			'PM_IMG' => $pm_img,
			'PM' => $pm,
			'EMAIL_IMG' => $email_img,
			'EMAIL' => $email,
			'WWW_IMG' => $www_img,
			'WWW' => $www,
			'ICQ_STATUS_IMG' => $icq_status_img,
			'ICQ_IMG' => $icq_img,
			'ICQ' => $icq,
			'AIM_IMG' => $aim_img,
			'AIM' => $aim,
			'MSN_IMG' => $msn_img,
			'MSN' => $msn,
			'YIM_IMG' => $yim_img,
			'YIM' => $yim,

ADD AFTER

Code::

			'LASTVISIT' => $lastvisit,

SAVE AND CLOSE /modules/Members_List/index.php

OPEN themes/{YOUR THEME}/template/memberslist.html
FIND

Code::

  <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
    <tr>
      <th height="25" class="thCornerL" nowrap="nowrap">#</th>
      <th class="thTop" nowrap="nowrap" align="center"> </th>
      <th class="thTop" nowrap="nowrap" align="center">{L_USERNAME}</th>
      <th class="thTop" nowrap="nowrap" align="center">{L_EMAIL}</th>
      <th class="thTop" nowrap="nowrap" align="center">{L_FROM}</th>
      <th class="thTop" nowrap="nowrap" align="center">{L_JOINED}</th>

ADD AFTER

Code::

      <th class="thTop" nowrap="nowrap" align="center">{L_LASTVISIT}</th>

FIND

Code::

    <!-- BEGIN memberrow -->
    <tr>
      <td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"> {memberrow.ROW_NUMBER} </span></td>
      <td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.PM_IMG} </td>
      <td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"><a href="{memberrow.U_VIEWPROFILE}" 

class="gen">{memberrow.USERNAME}</a></span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"> {memberrow.EMAIL_IMG} </td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.FROM}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gensmall">{memberrow.JOINED}</span></td>

ADD AFTER

Code::

      <td class="{memberrow.ROW_CLASS}" align="left"><span class="gensmall">{memberrow.LASTVISIT}</span></td>

FIND

Code::

      <td class="catbottom" colspan="8" height="28"> </td>

CHANGE TO

Code::

      <td class="catbottom" colspan="9" height="28"> </td>

SAVE AND CLOSE themes/{YOUR THEME}/template/memberslist.html

OPEN langauge/english/forums.php with a UTF-8 compliant editor, such as Notepad2!!
FIND

Code::

    // Memberslist 
    'Select_sort_method' => 'Select sort method',
    'Sort' => 'Sort',
    'Sort_Top_Ten' => 'Top Ten Posters',
    'Sort_Joined' => 'Joined Date',
    'Sort_Username' => 'Username',
    'Sort_Location' => 'Location',
    'Sort_Posts' => 'Posts',
    'Sort_Email' => 'Email',
    'Sort_Website' => 'Website',
    'Sort_Ascending' => 'Ascending',
    'Sort_Descending' => 'Descending',
    'Order' => 'Order',

ADD AFTER

Code::

    'Last_Visit' => 'Last Visit',

SAVE AND CLOSE language/english/forums.php

This was originally a post on my site where I was helping a member with the same request --> www.kylestubbins.com/i...c&t=13

gabriele

Hi!! Thank you (as usual!) for your replies... It is what I was looking for.
I made other changes in modules\Members_List\index.php to make the list sortable by Last Visit.
[Probably it was, and I missed some steps (as usual... Embarassed

)]

changed

Quote::

'S_MODE_SELECT' => select_box('mode', $mode, array('joindate'=>'Joined date', 'username'=>'Username', 'location'=>'Location', 'posts'=>'Posts', 'website'=>'Website',))

with

Quote::

'S_MODE_SELECT' => select_box('mode', $mode, array('joindate'=>'Joined date', 'username'=>'Username', 'location'=>'Location', 'posts'=>'Posts', 'website'=>'Website', 'lastvisit'=>'Lastvisit'))

And under

Quote::

case 'website':
$order_by = "user_website $sort_order LIMIT $start, " . $members_per_page;
break;

added:

Quote::

case 'lastvisit':
$order_by = "user_lastvisit $sort_order LIMIT $start, " . $members_per_page;
break;

Thanks again!!
Ciao!!

G

NEMINI · Diamond Supporter Offline Joined: Apr 22, 2004 Posts: 4551

good idea, but how do I add a time offset? that field is GMT and my site isn't. Thanks. Optimally this field should be offset by whatever the user has set in their account.

safecracker4hire

I haven't tried it, but will be glad to test it out when I get home this evening...

It should be a simple matter of calculating the users time zone.

Code::

$tz = $userinfo['user_timezone'];
$lastvisit = date('M d, Y @ g:ia', $row['user_lastvisit'] + (3600 * $tz));

NEMINI · Diamond Supporter Offline Joined: Apr 22, 2004 Posts: 4551

seems to be working so far, it should work at the very least until someones DST kicks in lol.

safecracker4hire

This would probably be better for time conversion.

PHP:

$lastvisit = formatDateTime($row['user_lastvisit'], _DATESTRING);

Which uses the core time class. _DATESTRING is defined in /language/english/main.php.

PHP:

define('_DATESTRING','%A, %B %d, %Y (%H:%M:%S)');

Katrina

Ok I want to do this but with a custom field that I made. I'm by no means good with php, so I spent hours last night trying to find a variable for it with no avail. In my db I have the field I want labeled as "gw_name".

winock

is there also a possibility to display only a special group, what i meaning is i have to show only a group with translators. thinking in the members account section to use the field my occupation for the mother language and the field my interests for the other languages....

its verry important for me Praying

onebuckwild

ok, for some reason the last visit colum shows the total post and the website shows the last visited date. If I post the original mytheme/templete/memberslist.php it all shows in the right place with out the last visit colum but the drop down will sort by last visit. So im thinking the problem is in the page. I tried it with my hl2 theme and cpgnuke theme with the same results. I will start over at home later and try the mod of that page again to see if I did something but wanted to see if anyone else had this problem that could let me know what I did to make things easier. thanks

onebuckwild

found the problem, had one of the lines on that page in the wrong place and that put them all out of order. thanks anyway

designSumpf

I have had a similar problem and had to realize, that (sometimes?) the user_lastvisit is older then the user_session_time (is this relevant?). And I'm not so interested in the date, but in the number of days a user was not loged in.

Code::

$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, LEAST(DATEDIFF(NOW(), FROM_UNIXTIME(user_session_time)), DATEDIFF(NOW(), FROM_UNIXTIME(user_lastvisit))) AS lastvisit

HEairsoft · Nice poster Offline Joined: Jul 26, 2005 Posts: 58

Don't Like 24 hour time format? Use this:

PHP:

$lastvisit = formatDateTime($row['user_lastvisit'], "%b %d, %Y @ %r");

Ex: Aug 10, 2006 @ 11:46:38 PM

Use all the symbols you want by checking out the strftime manual