extend Recent Login Code

sarahmx · #1 (**permalink**) 02-08-10, 06:42 AM

Hi..

I'm a php newbie...

this code below is to show recent login member in xoops cms

is there anyway to extend this code to show when actually did the user login..
example minutes/seconds/hours/days ago

PHP Code:


			
$hours = 24;
$kira=0;
$time = ( intval( $hours ) > 0 ) ? time() - ( intval( $hours ) * 3600 ) : ( time() - 24*3600 );
global $xoopsDB;


echo "<table><tr>";
$sql = "SELECT distinct uid, uname, user_avatar, last_login FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (0) AND last_login >= '" . $time . "' ORDER BY last_login DESC";
$result = $xoopsDB->query($sql);

while (list($uid, $uname,$user_avatar,$poster,$last_login) = $xoopsDB->fetchRow($result) ) {
$kira++;
if ($user_avatar == 'blank.gif')
{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/blank_avatar.gif' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a></td>";
}

else

{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/".$user_avatar."' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a></td>";
}

if($kira == 4)

 {

  $count=0;

  echo "</tr><tr>";

 }}

echo "</tr></table>";

Jcbones · #2 (**permalink**) 02-08-10, 06:19 PM

I'm assuming $last_login is a timestamp column in the database.

PHP Code:


			
<?php
/***************************************************************************************************
        *    Copyright (C) 2009  JCBones.                                                                            *
        *                                                                                                                            *
        *    This program is free software: you can redistribute it and/or modify                            *
        *    it under the terms of the GNU General Public License as published by                    *
        *    the Free Software Foundation, either version 3 of the License, or                            *
        *    any later version.                                                                                                *
        *                                                                                                                            *
        *    This program is distributed in the hope that it will be useful,                                    *
        *    but WITHOUT ANY WARRANTY; without even the implied warranty of                    *
        *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            *
        *    GNU General Public License for more details.                                                        *
        *                                                                                                                            *
        *    You should have received a copy of the GNU General Public License                        *
        *    along with this program.  If not, see <http://www.gnu.org/licenses/>.                        *
        *                FUNCTION TIMEDIFFERENCE.                                                                *
        *    set real dates for start and end, otherwise *nix the strtotime() lines.                        *
        *    $return 'days' will return days/hours/minutes/seconds.                                            *
        *    $return 'hours' will return hours/minutes/seconds.                                                    *
        *    $return 'minutes' will return minutes/seconds.                                                        *
        *    $return 'seconds' will return seconds.                                                                    *
        *                                                                                                                            *
        ***************************************************************************************************/
function timeDifference($start,$end,$return='days') {
    //change times to Unix timestamp.
    //$start = strtotime($start);
    //$end = strtotime($end);
    //subtract dates
    $difference = max($end, $start) - min($end,$start);
    $time = NULL;
    //calculate time difference.
    switch($return) {
        case 'days':
             $days = floor($difference/86400);
                $difference = $difference % 86400;
                    $time .= $days . ' Days, ';
        case 'hours':
            $hours = floor($difference/3600);
                $difference = $difference % 3600;
                    $time .= $hours . ' Hours, ';
        case 'minutes':
            $minutes = floor($difference/60);
                $difference = $difference % 60;
                    $time .= $minutes . ' Minutes, ';
        case 'seconds':
            $seconds = $difference;
                $time .= $seconds . ' Seconds';
    }
    
    return $time;   
    
}

$now = time();
$hours = 24;
$kira=0;
$time = ( intval( $hours ) > 0 ) ? time() - ( intval( $hours ) * 3600 ) : ( time() - 24*3600 );
global $xoopsDB;


echo "<table><tr>";
$sql = "SELECT distinct uid, uname, user_avatar, last_login FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (0) AND last_login >= '" . $time . "' ORDER BY last_login DESC";
$result = $xoopsDB->query($sql);

while (list($uid, $uname,$user_avatar,$poster,$last_login) = $xoopsDB->fetchRow($result) ) {
//Put this variable in the echo statements where you would like them to show up.
$sinceLastLogin = 'Last Login was: ' . timeDifference($last_login,$now,'days') . ' ago.';
$kira++;
if ($user_avatar == 'blank.gif')
{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/blank_avatar.gif' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a></td>";
}

else

{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/".$user_avatar."' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a></td>";
}

if($kira == 4)

 {

  $count=0;

  echo "</tr><tr>";

 }}

echo "</tr></table>";  
?>

This should fix you up, Please read the comments, and put the variable where you would like it in the echo statement(s).

sarahmx · #3 (**permalink**) 02-09-10, 12:18 AM

Thanks JCbones...this is almost working :-)

Quote:

I'm assuming $last_login is a timestamp column in the database.

hmm..no :-(

its int(10) with attributes: unsigned

the value in the database is save something like this :1259899647
and in user profile page it is display something like: 2010/2/9 13:06

what do i need to change ...?

if i didn't change the database this is what the result look like

Quote:

14649 Days, 5 Hours, 7 Minutes, 26 Seconds ago.

the time is wrong..cause i just log in as in the db and my profile page shows - 2010/2/9 13:06

actually what i wanted is the last login time is updated from seconds to minutes to hours etc ...not display all in one line

Jcbones · #4 (**permalink**) 02-09-10, 10:37 AM

Quote:

actually what i wanted is the last login time is updated from seconds to minutes to hours etc ...not display all in one line

??? Not sure what you mean by this.

I figured that your database was holding that value, it is a unix timestamp (seconds since Jan 01, 1970). I fixed the function to return time values based on that.

So, I'll explain the code for you.

time(); is a php function that returns a unix timestamp.
$last_login from your database also holds a unix timestamp.

time() - $last_login will give you the number of seconds from your last login, to this very moment.

Subtract 86400 seconds per day, 3600 seconds per hour, 60 seconds per minute, and your left with the remaining seconds. That is all that this function does.

If you will give me the layout you would like to accomplish, I will help you to get it integrated.

Jc.

sarahmx · #5 (**permalink**) 02-09-10, 07:23 PM

thanks jcbones..for your explanantion

my code is just for 24 hours right?..so the record will update every 24 hours right?

i want it something like this...

http://www.freeimagehosting.net/uploads/e28724047f.jpg

earlier should be ago..and in my code there is avatar

is this do-able ?

Jcbones · #6 (**permalink**) 02-09-10, 08:12 PM

See what this does for you.

PHP Code:


			
<?php
function timeDifference($start,$end,$return='days') {
    //change times to Unix timestamp.
    //$start = strtotime($start);
    //$end = strtotime($end);
    //subtract dates
    $difference = max($end, $start) - min($end,$start);
    $time = NULL;
    //calculate time difference.
    switch($return) {
        case 'days':
             $days = floor($difference/86400);
                $difference = $difference % 86400;
                    $time .= $days . ' Days, ';
        case 'hours':
            $hours = floor($difference/3600);
                $difference = $difference % 3600;
                    $time .= $hours . ' Hours, ';
        case 'minutes':
            $minutes = floor($difference/60);
                $difference = $difference % 60;
                    $time .= $minutes . ' Minutes, ';     
    }
    
    return $time;   
    
}

$now = time();
$hours = 24;
$kira=0;
$time = ( intval( $hours ) > 0 ) ? time() - ( intval( $hours ) * 3600 ) : ( time() - 24*3600 );
global $xoopsDB;


echo "<table><tr>";
$sql = "SELECT distinct uid, uname, user_avatar, last_login FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (0) AND last_login >= '" . $time . "' ORDER BY last_login DESC";
$result = $xoopsDB->query($sql);

while (list($uid, $uname,$user_avatar,$poster,$last_login) = $xoopsDB->fetchRow($result) ) {
//Put this variable in the echo statements where you would like them to show up.
$sinceLastLogin = '[ ' . timeDifference($last_login,$now,'hours') . ' earlier ]';
$kira++;
if ($user_avatar == 'blank.gif')
{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/blank_avatar.gif' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a>$sinceLastLogin</td>";
}

else

{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/".$user_avatar."' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a>$sinceLastLogin</td>";
}

if($kira == 4)

 {

  $count=0;

  echo "</tr><tr>";

 }}

echo "</tr></table>";  
?>

sarahmx · #7 (**permalink**) 02-10-10, 02:48 AM

Thank you JC Bones

the code show...

Quote:

351607 Hours, 42 Minutes, earlier

i refresh the page the minutes are updating...which is exactly what i wanted

hours is obviously wrong

Jcbones · #8 (**permalink**) 02-10-10, 05:20 PM

Sarahmx,

I would like to do some testing, as you stated, the hours are way off. Try this, and paste what the timestamps are.

PHP Code:


			
<?php
function timeDifference($start,$end,$return='days') {
    //change times to Unix timestamp.
    //$start = strtotime($start);
    //$end = strtotime($end);
    //subtract dates
echo 'Start Timestamp: ' . $start . '<br/>End Timestamp: ' . $end . '<br/>';
    $difference = max($end, $start) - min($end,$start);
    $time = NULL;
    //calculate time difference.
    switch($return) {
        case 'days':
             $days = floor($difference/86400);
                $difference = $difference % 86400;
                    $time .= $days . ' Days, ';
        case 'hours':
            $hours = floor($difference/3600);
                $difference = $difference % 3600;
                    $time .= $hours . ' Hours, ';
        case 'minutes':
            $minutes = floor($difference/60);
                $difference = $difference % 60;
                    $time .= $minutes . ' Minutes, ';     
    }
    
    return $time;   
    
}

$now = time();
$hours = 24;
$kira=0;
$time = ( intval( $hours ) > 0 ) ? time() - ( intval( $hours ) * 3600 ) : ( time() - 24*3600 );
global $xoopsDB;


echo "<table><tr>";
$sql = "SELECT distinct uid, uname, user_avatar, last_login FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (0) AND last_login >= '" . $time . "' ORDER BY last_login DESC";
$result = $xoopsDB->query($sql);

while (list($uid, $uname,$user_avatar,$poster,$last_login) = $xoopsDB->fetchRow($result) ) {
//Put this variable in the echo statements where you would like them to show up.
$sinceLastLogin = '[ ' . timeDifference($last_login,$now,'hours') . ' earlier ]';
$kira++;
if ($user_avatar == 'blank.gif')
{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/blank_avatar.gif' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a>$sinceLastLogin</td>";
}

else

{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/".$user_avatar."' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a>$sinceLastLogin</td>";
}

if($kira == 4)

 {

  $count=0;

  echo "</tr><tr>";

 }}

echo "</tr></table>";  
?>

sarahmx · #9 (**permalink**) 02-10-10, 05:39 PM

it display

Quote:

Start Timestamp:
End Timestamp: 1265841320

sarahmx[ 351622 Hours, 35 Minutes, earlier ]

i just log-in i think minute is wrong too..i just login seconds ago but it shows 35 minutes earlier ?

i checked the last login fields show the correct time when i last login
2010/2/11 6:38

Jcbones · #10 (**permalink**) 02-10-10, 08:46 PM

OK, the problem is that we are not getting that last login field from the database. You can see that the Start Timestamp does not have a value set.

The reason I suspect is these lines:

PHP Code:


			
SELECT distinct uid, uname, user_avatar, last_login FROM

PHP Code:


			
list($uid, $uname,$user_avatar,$poster,$last_login)

Does not match, you have an extra variable there "$poster", which is probably holding your $last_login value. To test this, we should echo that out. Try this script here.

PHP Code:


			
<?php
function timeDifference($start,$end,$return='days') {
    //change times to Unix timestamp.
    //$start = strtotime($start);
    //$end = strtotime($end);
    //subtract dates
echo 'Start Timestamp: ' . $start . '<br/>End Timestamp: ' . $end . '<br/>';
    $difference = max($end, $start) - min($end,$start);
    $time = NULL;
    //calculate time difference.
    switch($return) {
        case 'days':
             $days = floor($difference/86400);
                $difference = $difference % 86400;
                    $time .= $days . ' Days, ';
        case 'hours':
            $hours = floor($difference/3600);
                $difference = $difference % 3600;
                    $time .= $hours . ' Hours, ';
        case 'minutes':
            $minutes = floor($difference/60);
                $difference = $difference % 60;
                    $time .= $minutes . ' Minutes, ';     
    }
    
    return $time;   
    
}

$now = time();
$hours = 24;
$kira=0;
$time = ( intval( $hours ) > 0 ) ? time() - ( intval( $hours ) * 3600 ) : ( time() - 24*3600 );
global $xoopsDB;


echo "<table><tr>";
$sql = "SELECT distinct uid, uname, user_avatar, last_login FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (0) AND last_login >= '" . $time . "' ORDER BY last_login DESC";
$result = $xoopsDB->query($sql);

while (list($uid, $uname,$user_avatar,$poster,$last_login) = $xoopsDB->fetchRow($result) ) {
//Put this variable in the echo statements where you would like them to show up.
$sinceLastLogin = '[ ' . timeDifference($poster,$now,'hours') . ' earlier ]';
$kira++;
if ($user_avatar == 'blank.gif')
{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/blank_avatar.gif' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a>$sinceLastLogin</td>";
}

else

{
echo "<td style='padding:5px;text-align:center'><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'><img src='".XOOPS_URL."/uploads/".$user_avatar."' title='".$uname."' border='0' alt='".$uname."' height='48' width='48'></a><br /><a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a>$sinceLastLogin</td>";
}

if($kira == 4)

 {

  $count=0;

  echo "</tr><tr>";

 }}

echo "</tr></table>";  
?>