users last visit and total post?

Posted: Wed Feb 07, 2007 2:49 pm

im trying to find out how i can retrieve the users last visit time, and also the users total post count.

registered · Posted: Wed Feb 07, 2007 5:53 pm

These are on the nuke_users table as properties user_posts and user_lastvisit.

registered · Posted: Wed Feb 07, 2007 6:10 pm

Be aware that user_lastvisit is apparently only updated when the user visits the phpBB forums. I was going to write a script to delete members who stopped visiting the site after x months, and was going to use that field. But then a member who submits news stories on a regular basis came up on the list of people to delete. After scratching my head for a while, I determined that was something that was added for phpBB. Nuke doesn't really use it. Maybe that is good enough for what you want though.

Regular Joined: Mar 14, 2005 Posts: 91

That would be useful to have it work throughout the whole site.
Could probably do this by adding something like this to the header.php

Code:




if (is_user($user) && $name != 'Forums')


{


  $cookie = cookiedecode($user);


  $user_id = intval($cookie[0]);


  $sql = "UPDATE ".$user_prefix."_users SET user_lastvisit='".time()."' WHERE user_id='$user_id'";


  if (!$db->sql_query($sql))


  {


      // error updating


  }





}

registered · Posted: Thu Feb 08, 2007 10:30 pm

Note that this could affect the usage of the forums, as phpBB uses that to determine which posts it counts as "new"

Posted: Thu Feb 08, 2007 11:37 pm

Probably be best to just add a new field then Smile

Posted: Sun Feb 11, 2007 10:14 pm

If you're looking for code to use, Protector used a field called 'last_seen_blocker' which stored the last seen time as a timestamp. That's what I use for some of my scripts

Posted: Mon Feb 12, 2007 3:46 pm

well my site basically revolves around the forums, so user_lastvisit will work fine for me. but im still new to php, and i was wondering how i go about getting the user_posts and user_lastvisit properties from the nuke_users table.

i just want to add on to the user info block to say:

last visit: last visit date here
total post: total post count here

sorry for being a newb lol. thanks guys.

Posted: Tue Feb 13, 2007 4:12 am

okay with some patience i got it figured out, but the user_lastvisit shows up like 1171318172. any ideas?

Posted: Tue Feb 13, 2007 9:40 am

It is a unix timestamp (basically the number of seconds since an epoch date). There are many PHP functions that accept timestamps and do math on them.

Posted: Tue Feb 13, 2007 1:47 pm

okay i got it all figured out. thanks for the help everyone.

Posted: Tue Apr 17, 2007 9:29 am

t_henson wrote:

okay i got it all figured out. thanks for the help everyone.

care to share?

Also, I noticed your Gallery is not working on your website. Just an FYI...