phpBB.de

Code: Alles auswählen

function users_today($who)
{
	global $db;

         $sql = "SELECT count( user_id ) AS users_today
		FROM " . USERS_TABLE ."
                 WHERE YEAR( NOW( ) ) = YEAR( FROM_UNIXTIME( user_lastvisit ) )
                 AND DAYOFYEAR( NOW( ) ) - DAYOFYEAR( FROM_UNIXTIME( user_lastvisit ) ) = 0
                 UNION
                 SELECT count( session_id )
                 FROM " . SESSIONS_TABLE . "
                 WHERE YEAR( NOW( ) ) = YEAR( FROM_UNIXTIME( session_start ) )
                 AND DAYOFYEAR( NOW( ) ) - DAYOFYEAR( FROM_UNIXTIME( session_start ) ) = 0
                 AND session_user_id = - 1";
         if ($result = $db->sql_query($sql))
         {
                 $i = 0;
                 while ($row = $db->sql_fetchrow($result))
                 {
			$users_today[$i] = $row['users_today'];
                         $i++;
                 }
                 if ($who == 'users')
                 {
                 	return $users_today[0];
                 }
                 else
                 {
                 	return $users_today[1];
                 }
         }
}

Code: Alles auswählen

$userzahl = users_today('users');