source: trollforge/lastmeasure/stats/index.php @ 773

<?php
include('../include/db.php');
include('../include/tooltips.php');

function print_cell($text, $full, $href) {
    if($href && preg_match('/(http:\/\/[^ ]*)/i', $full, $matches)) {
        $url = $matches[0];
        tooltip($text, $full, $url);
    } else {
        tooltip($text, $full, '');
    }
}

function cut($str, $count) {
    $l = strlen($str);
    if($l >= $count) {
        $n = $count / 2;
        $s1 = trim(substr($str, 0, $n));
        $s2 = trim(substr($str, $l - $n));
        $str = "$s1...$s2";
    }
    $str = htmlspecialchars($str);
    $str = str_replace(" ", "&nbsp;", $str);
    return $str;
}

function print_hits() {
    $id = dba_open($_SERVER['DOCUMENT_ROOT'].'/db/hit.db', 'w', 'db4');
    if(!$id) {
        ?><tr><td colspan="6" class="error">Failed to open database!</td></tr><?php
        return;
    }
    $key = dba_firstkey($id);
    if($key == false) {
        ?><tr><td colspan="6" class="error">No hits found!</td></tr><?php
        return;
    }
    for($l = 0; $l < 20 && $key != false; $l++) {
        $val = dba_fetch($key, $id);
        list($ip, $port, $host, $uagent,
             $referer, $user, $clipboard) = explode(' ', $val);
        $date = key2date($key);
        ?>
        <tr style="background-color: <?php echo ($l % 2) ? '#cef' : '#ecf'; ?>">
          <td>
            <?php print_cell(date('H:i:s', $date), date('D, d M Y H:i:s', $date), false); ?>
          </td>
          <td>
            <?php if($host == '') {
              $host = gethostbyaddr($ip);
              $host = gethostbyaddr($ip);
              $val = "$ip $port $host $uagent $referer $user $clipboard";
              dba_replace($key, $val, $id);
            }
            if($host != '') {
              print_cell("$ip", "$host $port", false);
            } else {
              print_cell("$ip", "$ip $port", false);
            } ?>
          </td>
          <td>
            <?php $uagent = base64_decode($uagent);
            if(strlen($uagent) > 30) {
              print_cell(cut($uagent, 25), htmlspecialchars($uagent), false);
            } else {
              echo htmlspecialchars($uagent);
            } ?>
          </td>
          <td>
            <?php $referer = base64_decode($referer);
            if(strlen($referer) > 35) {
              print_cell(cut($referer, 30), htmlspecialchars($referer), true);
            } else {
              echo '<a href="'.htmlspecialchars($referer).'">'.htmlspecialchars($referer).'</a>';
            } ?>
          </td>
          <td>
            <?php
              $user = base64_decode($user);
              echo htmlspecialchars($user);
            ?>
          </td>
          <td>
            <?php $clipboard = base64_decode($clipboard);
            print_cell(cut($clipboard, 40), htmlspecialchars($clipboard), true); ?>
          </td>
        </tr><?php
        $key = dba_nextkey($id);
    }
    dba_close($id);
}

function toplist($title, $table, $count) {
    $id = dba_open($table, 'r', 'db4');
    if(!$id) {
        ?><tr><td colspan="2" class="error">Failed to open database!</td></tr><?php
        return;
    }
    $key = dba_firstkey($id);
    if($key == false) {
        ?><tr><td colspan="2" class="error">No hits found!</td></tr><?php
        return;
    }
    $items = array();
    $total = 0;
    $smallest = 0;
    while($key != false) {
        $total++;
        $val = dba_fetch($key, $id);
        if(count($items) == $count) {
            /* Our list is already full; if the new entry is big
             * enough, add it, sort the list and remove the last item. */
            if($val > $smallest) {
                $items[$key] = $val;
                arsort($items);
                array_pop($items);
                $smallest = $items[$count - 1];
            }
        } else {
            /* Our list is not complete yet. Just add an item. */
            $items[$key] = $val;
        }
        $key = dba_nextkey($id);
    }
    arsort($items);
    if($count > $total) $count = $total;
    $l = 0; ?>
    <table style="border: solid black 1px; margin: 5px;">
      <tr style="background-color: #8af;">
        <td><?php echo $title;?> (<?php echo "$count of $total";?>)</td>
        <td>Count</td>
      </tr> <?php
    foreach($items as $key => $val) { ?>
        <tr style="background-color: <?php echo ($l % 2) ? '#cef' : '#ecf'; ?>">
          <td><?php echo base64_decode($key); ?></td>
          <td><?php echo $val; ?></td>
        </tr><?php
        $l++;
    } ?>
    </table><?php
    dba_close($id);
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
       "http://www.w3.org/TR/xhtml1/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   <title>GNAA Last Measure Live! Static Statistics</title>
   <link rel="icon" type="image/x-icon" href="/favicon.ico" />
   <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" />
   <style type="text/css">
      body,td {
         font-family: sans-serif, Verdana, Arial, Helvetica;
         font-size: 0.9em;
      }
      .error {
         background-color: #ff6666;
      }
      <?php tooltip_css(); ?>
   </style>
   <script type="text/javascript">
      <?php tooltip_js(); ?>
   </script>
</head>
<body>

  <h2><span style="background-color: transparent;
              margin-right: 10px; clear: both;">
    <img src="/gnaa.png" width="108" height="40"
         alt="GNAA" />
  </span> GNAA Last Measure Live! Static Statistics | <a href="live.php">Web 2.0 Statistics</a></h2>
  <div style="float: left;">
    <?php toplist('User', $_SERVER['DOCUMENT_ROOT'].'/db/user.db', 40); ?>
  </div>

  <?php tooltip_finish(); ?>

  <table style="border: solid black 1px; margin: 5px;">
    <tr style="background-color: #8af;">
      <td>Date</td>
      <td>Host</td>
      <td>Browser</td>
      <td>Referer</td>
      <td>User</td>
      <td>Clipboard</td>
    </tr>
    <?php print_hits(); ?>
  </table>

  <?php tooltip_finish(); ?>

  <?php toplist('Browser', $_SERVER['DOCUMENT_ROOT'].'/db/uagent.db', 20); ?>

  <?php tooltip_finish(); ?>

  <hr />

  <div style="float: right;">
    <p>
      <a href="http://validator.w3.org/check?uri=referer"><img
          src="http://www.w3.org/Icons/valid-xhtml11" style="border: 0px;"
          alt="Valid XHTML 1.1" height="31" width="88" /></a>
    </p>
  </div>

  <p> Generated by Last Measure Unified X <?php echo date('Y-m-d H:i:s'); ?> </p>

</body>
</html>