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

<?php
include($_SERVER['DOCUMENT_ROOT'].'/include/db.php');

function tooltip($id, $text, $full, $href) { ?>
    <div id="<?php echo $id;?>" class="jstip"><?php echo $full; ?></div>
    <a onmouseout="jstip(event,'<?php echo $id;?>')" onmouseover="jstip(event,'<?php echo $id;?>')" onclick="return false;"
    <?php if($href && preg_match('/(http:\/\/[^ ]*)/i', $full, $matches)) {
        $url = $matches[0];
        echo ' href="'.$matches[0].'"';
    } ?>><?php echo $text;?></a><?php
}

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 tooltip("d$l", 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 != '') {
              tooltip("h$l", "$ip", "$host $port", false);
            } else {
              tooltip("h$l", "$ip", "$ip $port", false);
            } ?>
          </td>
          <td>
            <?php $uagent = base64_decode($uagent);
            if(strlen($uagent) > 30) {
              tooltip("b$l", cut($uagent, 25), htmlspecialchars($uagent), false);
            } else {
              echo htmlspecialchars($uagent);
            } ?>
          </td>
          <td>
            <?php $referer = base64_decode($referer);
            if(strlen($referer) > 35) {
              tooltip("r$l", 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);
            if(strlen($clipboard) > 45) {
              tooltip("c$l", cut($clipboard, 40), htmlspecialchars($clipboard), true);
            } else {
              echo htmlspecialchars($clipboard);
            } ?>
          </td>
        </tr><?php
        $key = dba_nextkey($id);
    }
    dba_close($id);
}

function toplist($title, $table, $count) {
    $id = dba_open($table, 'w', '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;
    while($key != false) {
        $total++;
        $val = dba_fetch($key, $id);
        $items[$key] = $val;
        arsort($items);
        if(count($items) > $count)
            array_pop($items);
        $key = dba_nextkey($id);
    }
    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 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;
      }
      .jstip {
         float: left;
         clear: both;
         visibility: hidden;
         border: solid black 1px;
         padding: 2px;
         position: absolute;
         z-index: 100;
         background-color: #ffeecc;
         font-size: 0.8em;
      }
      .error {
         background-color: #ff6666;
      }
   </style>
   <script type="text/javascript">
//<!--
var support = false;
if (document.getElementById || document.all) {
  support = true;
  suffix = 'px';
} else if (navigator.appName.indexOf('Netscape') != -1
            && parseInt(navigator.appVersion) == 4) {
  support = true;
  suffix = '';
}

function jstip(ev, id) {
  if (!support)
    return;

  if (document.getElementById) {
    tipstyle = document.getElementById(id).style;
    tipentity = document.getElementById(id);
  } else if (document.all) {
    tipstyle = document.all[id].style;
    tipentity = document.all[id];
  } else {
    tipstyle = document.layers[id];
    tipentity = document.layers[id];
  }

  if (tipstyle.visibility == 'visible' || tipstyle.visibility == 'show') {
    tipstyle.visibility = 'hidden';
    return;
  }

  if (ev.pageY) {
    tipx = ev.pageX;
    tipy = ev.pageY;
  } else if (ev.clientY && document.documentElement.scrollTop) {
    tipx = ev.clientX + document.documentElement.scrollLeft;
    tipy = ev.clientY + document.documentElement.scrollTop;
  } else if (ev.clientY) {
    tipx = ev.clientX + document.body.scrollLeft;
    tipy = ev.clientY + document.body.scrollTop;
  } else {
    tipx = tipy = 0;
  }

  if (tipentity.offsetWidth)
    tipwidth = tipentity.offsetWidth;
  else if (tipentity.clip.width)
    tipwidth = tipentity.clip.width;
  else
    tipwidth = 100;

  if (window.innerWidth)
    winwidth = window.innerWidth;
  else if (document.body.clientWidth)
    winwidth = document.body.clientWidth;
  else
    winwidth = 800;

  tipx -= tipwidth / 3;
  tipy += 15;

  if (tipwidth + tipx > winwidth)
    tipx = winwidth - tipwidth - 2;
  else if (tipx < 2)
    tipx = 2;

  tipstyle.left = tipx + suffix;
  tipstyle.top = tipy + suffix;
  tipstyle.visibility = 'visible';
}
//-->
   </script>
</head>
<body>

  <h1><span style="background-color: transparent;
              right-margin: 10px; clear: both;">
    <img src="/gnaa.png" width="108" height="40"
         alt="GNAA" />
  </span> GNAA Last Measure Statistics </h1> 

  <div style="float: left;">
    <?php toplist('User', $_SERVER['DOCUMENT_ROOT'].'/db/user.db', 40); ?>
  </div>

  <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 toplist('Browser', $_SERVER['DOCUMENT_ROOT'].'/db/uagent.db', 20); ?>

  <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 <?php echo date('Y-m-d H:i:s'); ?> </p>

</body>
</html>