Show online visitors in a Block (Drupal 7)

Estimated reading time of this article: 4 minutes

You want to see the number of online anonymous visitors. This can easily be done with a PHP snippet in block. The PHP Filter module must be enabled.

Additionally, the location is shown if found. Crawlers are shown separately.

<?php/* Code based on http://www.phpcodester.com/2011/04/drupal-7-block-for-whos-online-with-guests/ */if (user_access('access content')) {    $spiders = array('google', 'fatlens', 'yahoo', 'altavista', 'yandex', 'baidu', 'bing', 'thefind', 'bot', 'spider', 'crawl');    $now = $_SERVER['REQUEST_TIME'];    $interval = $now -  3600 * 6 /*variable_get('user_block_seconds_online', 3600 * 6)*/;    $output = "<div class = "visitor-ips">";    $max_users = 12; //variable_get('user_block_max_list_count', 10);    /*$authenticated_count = db_query("SELECT COUNT(DISTINCT s.uid) FROM {sessions} s WHERE s.timestamp >= :timestamp AND s.uid > 0", array(':timestamp' => $interval))->fetchField();    if ($authenticated_count && $max_users) {        $output.="<h3>Registered Users</h3>";        $items = db_query_range('SELECT u.uid, u.name, MAX(s.timestamp) AS max_timestamp FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid WHERE s.timestamp >= :interval AND s.uid > 0 GROUP BY u.uid, u.name ORDER BY max_timestamp DESC', 0, $max_users, array(':interval' => $interval))->fetchAll();        $output .= theme('user_list', array('users' => $items));    }*/    $guest_count = db_query("SELECT COUNT(DISTINCT s.hostname) FROM {accesslog} s WHERE s.timestamp >= :timestamp", array(':timestamp' => $interval))->fetchField();    $output .= "$guest_count visitor(s)";    $output .= ' since ' . date('H:i d.m', $interval) /*. ' (' . date('H:i d.m', $now) . ')' . " ($interval)"*/;    $sData = array();        $gData = array();    if ($guest_count && $max_users) {        $items = db_query_range('SELECT s.hostname, MAX(s.timestamp) AS max_timestamp FROM {accesslog} s WHERE s.timestamp >= :interval GROUP BY s.hostname ORDER BY max_timestamp DESC', 0, $max_users, array(':interval' => $interval))->fetchAll();        foreach ($items as $item) {                        $ip = $item->hostname;            $host = preg_replace('/[^a-zA-Z\.]/', '', gethostbyaddr($ip));            if ($host == "...") $host = "Unknown Hostname";            $spider = 0;            foreach ($spiders as $spider) {                if (strpos($host, $spider) !== false){                    $spider=1;                                        //$item['spider'] = 1;                    break;                }            }            if ($spider == 1) {                $sData[]=array('ip' => $ip, 'host' => $host, 'timestamp' => $item->max_timestamp);            } else {                $gData[]=array('ip'=>$ip, 'host'=>$host, 'timestamp' => $item->max_timestamp);            }        }    }    if (isset($gData) && count($gData)>0){        // $output .= "<h3>Guests</h3>";        $output .= "<ul>";        foreach ($gData as $d){            $output .= "<li>" . check_plain($d['host']) . ', ' . check_plain($d['ip']);            $loc = unserialize(file_get_contents('http://www.geoplugin.net/php.gp?ip='.$d['ip']));            if ($loc['geoplugin_city'].$loc['geoplugin_region']!=''){                $output .= ", " . check_plain($loc['geoplugin_city']) . ", " . check_plain($loc['geoplugin_region']);            }            if ($loc['geoplugin_countryName'] != ''){                $output .= ", " . check_plain($loc['geoplugin_countryName']);            }            $output .= ', ' . date('H:i', $d['timestamp']);            $output .= "</li>";        }        $output .= "</ul>";    }    if (isset($sData) && count($sData)>0){        $output .= "Spiders:";        $output .= "<ul>";        foreach ($sData as $d) {            $output .= "<li>" . check_plain($d['host']) . ", " . check_plain($d['ip']) . ', ' . date('H:i', $d['timestamp']) . "</li>";        }        $output .= "</ul>";    }        $output .= " </div>";    return $output;}?>