コード例 #1
0
ファイル: classes.php プロジェクト: moto485/Simple-Stats
 private function upgrade()
 {
     $v = isset($this->options['db_version']) ? $this->options['db_version'] : 0;
     $visits_table = $this->tables['visits'];
     if ($v && $v < 2) {
         // upgrade from db version 1 to 2 - platform and browser columns have changed to integer values
         $ua = new SimpleStatsUA();
         foreach ($ua->get_all_browser_names() as $id => $name) {
             $this->query("UPDATE `{$visits_table}` SET `browser` = '{$id}' WHERE `browser` = '{$name}'");
         }
         $this->query("UPDATE `{$visits_table}` SET `browser` = '1' WHERE `browser` = 'Crawler'");
         $this->query("UPDATE `{$visits_table}` SET `browser` = CEIL(`browser`)");
         // fixes any we missed
         $this->query("ALTER TABLE `{$visits_table}` MODIFY `browser` TINYINT UNSIGNED NOT NULL DEFAULT '0'");
         foreach ($ua->get_all_platform_names() as $id => $name) {
             $this->query("UPDATE `{$visits_table}` SET `platform` = '{$id}' WHERE `platform` = '{$name}'");
         }
         $this->query("UPDATE `{$visits_table}` SET `platform` = CEIL(`platform`)");
         $this->query("ALTER TABLE `{$visits_table}` MODIFY `platform` TINYINT UNSIGNED NOT NULL DEFAULT '0'");
         $this->query("ALTER TABLE `{$visits_table}` ADD KEY `ua`(`browser`, `platform`)");
         $this->query("ALTER TABLE `{$visits_table}` ADD KEY `country`(`country`)");
     }
     if ($v && $v < 3) {
         // save password as hash
         if (!empty($this->options['password'])) {
             $this->update_option('password', $this->hash(trim($this->options['password'])));
         }
     }
     if ($v && $v < 4) {
         // bump referrer field size
         $this->query("ALTER TABLE `{$visits_table}` MODIFY `referrer` VARCHAR(512) NOT NULL DEFAULT ''");
     }
     if ($v && $v < 5) {
         // bump ip field size to allow ipv6 addresses
         $this->query("ALTER TABLE `{$visits_table}` MODIFY `remote_ip` VARCHAR(39) NOT NULL DEFAULT ''");
     }
     if ($v && $v < 6) {
         // change structure of last_aggregated - used to be yyyymm?, now array with keys yr and mo
         $parts = $this->options['last_aggregated'] ? str_split($this->options['last_aggregated'], 4) : array(0, 0);
         $this->update_option('last_aggregated', array('yr' => intval($parts[0]), 'mo' => intval($parts[1])));
     }
 }
コード例 #2
0
ファイル: paths.php プロジェクト: moto485/Simple-Stats
function render_page()
{
    global $ss;
    scripts_i18n();
    page_head();
    echo '<div id="main">';
    echo '<h2>' . __('Latest visitors') . '</h2>';
    $page_size = 20;
    $offset = isset($_GET['offset']) ? abs(intval($_GET['offset'])) : 0;
    $query = "SELECT * FROM `{$ss->tables['visits']}` ORDER BY `date` DESC, `start_time` DESC LIMIT {$offset},{$page_size}";
    $visits = array();
    if ($result = $ss->query($query)) {
        while ($assoc = @mysql_fetch_assoc($result)) {
            $visits[] = $assoc;
        }
    }
    $ua = new SimpleStatsUA();
    echo '<table id="paths" class="center wide" data-offset="' . $offset . '" data-page_size="' . $page_size . '"><thead>';
    echo '<tr><th colspan="2" class="left">' . __('IP Address') . '/' . __('Pages');
    echo '<th>' . __('Time');
    echo '<th>' . __('Browser');
    echo '<th>' . __('Operating system');
    echo '<th>' . __('Country');
    echo '<tbody>';
    foreach ($visits as $visit) {
        $start_ts = strtotime($visit['date'] . ' ' . $visit['start_time']);
        $hits = explode("\n", $visit['resource']);
        $dy_label = strftime('%d %b', $start_ts);
        $start_ts = date('H:i', $start_ts);
        $full_ua = $ss->options['log_user_agents'] && !empty($visit['user_agent']) ? $visit['user_agent'] : '';
        if ($visit['browser'] == 0) {
            $browser_name = '';
        } elseif ($visit['browser'] == 1) {
            $browser_name = __('(Robot)');
        } else {
            $browser_name = $ua->browser_name_from_id($visit['browser']);
        }
        $robot_class = $visit['browser'] == 1 ? ' bot' : '';
        $title = $full_ua ? ' title="' . htmlspecialchars($full_ua) . '"' : '';
        echo "<tr class='visit-header{$robot_class}'>";
        echo '<td colspan="2" class="left">' . htmlspecialchars($visit['remote_ip']);
        echo '<td>' . $dy_label . '</td>';
        echo "<td class='ua'{$title}>" . htmlspecialchars($browser_name) . ' ' . htmlspecialchars($visit['version']);
        echo '<td>' . htmlspecialchars($ua->platform_name_from_id($visit['platform']));
        echo '<td>' . htmlspecialchars(country_name($visit['country'])) . '</tr>';
        $row = 0;
        foreach ($hits as $hit) {
            if (empty($hit)) {
                continue;
            }
            @(list($time, $resource) = explode(' ', $hit, 2));
            // dump the seconds part of the time
            $time = substr($time, 0, 5);
            $r = htmlspecialchars($resource);
            echo '<tr class="hit">';
            echo '<td colspan="2" class="left"><a href="' . $r . '" class="goto">&rarr;</a> ' . filter_link(array('resource' => $resource), $resource) . "<td>{$time}";
            if ($row == 0 && !empty($visit['referrer'])) {
                echo '<td colspan="3" class="right">';
                if (!empty($visit['search_terms'])) {
                    echo filter_link(array('search_terms' => $visit['search_terms']), $visit['search_terms']);
                } else {
                    echo filter_link(array('domain' => $visit['domain']), $visit['domain']);
                }
                echo ' <a href="' . htmlspecialchars($visit['referrer']) . '" rel="external noreferrer" class="goto ext">&rarr;</a>';
            } else {
                echo '<td colspan="3">&nbsp;';
            }
            echo '</tr>';
            $row++;
        }
    }
    echo '</table>';
    echo '<nav class="center wide hide-if-no-js"><a class="ajax" style="display:block; padding: 5px" id="load-more">— ' . __('more') . ' —</a></nav>';
    echo '</div>';
    page_foot();
}
コード例 #3
0
 function __construct()
 {
     $ss = new SimpleStats();
     if (!$ss->is_installed() || !$ss->options['stats_enabled'] || isset($_COOKIE['simple_stats']) && $_COOKIE['simple_stats'] == $ss->hash($ss->options['username'] . $ss->options['password'])) {
         return;
     }
     $data = array();
     $data['remote_ip'] = substr($this->determine_remote_ip(), 0, 39);
     // check whether to ignore this hit
     if (in_array($data['remote_ip'], $ss->options['ignored_ips'])) {
         return;
     }
     $data['resource'] = substr($ss->utf8_encode($this->determine_resource()), 0, 255);
     $ua = new SimpleStatsUA();
     $browser = $ua->parse_user_agent($_SERVER['HTTP_USER_AGENT']);
     $data['platform'] = $browser['platform'];
     $data['browser'] = $browser['browser'];
     $data['version'] = substr($this->parse_version($browser['version']), 0, 15);
     // check whether to ignore this hit
     if ($data['browser'] == 1 && $ss->options['log_bots'] == false) {
         return;
     }
     // use DateTime instead of messing with the default timezone which could affect the calling application
     $tz = new DateTimeZone($ss->options['tz']);
     $datetime = new DateTime('now', $tz);
     $date = $data['date'] = $datetime->format('Y-m-d');
     $time = $datetime->format('H:i:s');
     // attempt to update table
     $table = $ss->tables['visits'];
     if ($ss->options['log_user_agents']) {
         $data['user_agent'] = $ss->esc(substr($_SERVER['HTTP_USER_AGENT'], 0, 255));
     }
     $resource = $ss->esc($time . ' ' . $data['resource']);
     $ip = $ss->esc($data['remote_ip']);
     $query = "UPDATE `{$table}` SET hits = hits + 1, resource = CONCAT( resource, '{$resource}', '\\n' ), `end_time` = '{$time}' WHERE `date` = '{$date}' AND remote_ip = '{$ip}'";
     if ($ss->options['log_user_agents']) {
         $query .= " AND user_agent = '{$data['user_agent']}'";
     } else {
         foreach (array('browser', 'version', 'platform') as $key) {
             $v = $ss->esc($data[$key]);
             $query .= " AND {$key} = '{$v}'";
         }
     }
     $query .= " AND TIMEDIFF( '{$time}', start_time ) < '00:30:00' LIMIT 1";
     $rows = $ss->query($query);
     if ($rows == 0) {
         // this information is only needed for new visitors
         $data['country'] = $this->determine_country($data['remote_ip']);
         // always 2 chars, no need to truncate
         $data['language'] = substr($this->determine_language(), 0, 255);
         $data['referrer'] = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
         $url = parse_url($data['referrer']);
         $data['referrer'] = substr($ss->utf8_encode($data['referrer']), 0, 511);
         $data['domain'] = isset($url['host']) ? substr(preg_replace('/^www\\./', '', $url['host']), 0, 255) : '';
         $data['search_terms'] = substr($ss->utf8_encode($this->determine_search_terms($url)), 0, 255);
         // this isn't actually used at present, but storing local timestamps without a GMT reference is asking for trouble
         $data['offset'] = $datetime->getOffset() / 60;
         // store in minutes
         $query = "INSERT INTO `{$table}` ( ";
         foreach (array_keys($data) as $key) {
             if ($key == 'resource') {
                 continue;
             }
             $query .= "{$key}, ";
         }
         $query .= 'hits, resource, start_time, end_time ) VALUES ( ';
         foreach ($data as $key => $value) {
             $value = $ss->esc($value);
             if ($key == 'resource') {
                 continue;
             }
             $query .= "'{$value}', ";
         }
         $query .= "'1', CONCAT( '{$resource}', '\\n' ), '{$time}', '{$time}' )";
         $ss->query($query);
     }
     $ss->close();
 }