Setting the last_visit of a user?!

Thursday 03 November 2005 5:59:38 pm

Hi Clemens

From kernel/classes/datatypes/ezuser/ezuser.php

eZUser::updateLastVisit( $userID );

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Friday 04 November 2005 2:39:24 am

rewrote it, for my own purposes:

function updateLastVisit( $userID , $time)
{
    $userVisitArray = $db->arrayQuery( "SELECT 1 FROM ezuservisit WHERE user_id=$userID" );

    if ( count( $userVisitArray ) == 1 )
    {
        $db->query( "UPDATE ezuservisit SET last_visit_timestamp=current_visit_timestamp, current_visit_timestamp=$time WHERE user_id=$userID" );
    }
    else
    {
        $db->query( "INSERT INTO ezuservisit ( current_visit_timestamp, last_visit_timestamp, user_id ) VALUES ( $time, $time, $userID )" );
    }
 }

Tuesday 08 November 2005 3:53:52 am

well, if you look closely. the updateLastVisit generates the current time. And to make my extension un-dependant of the ezpublish install. I rewrote the function in my extension :).

Thanks.

(ps: now I can set the time to any time i'd like. not just current time)