source: trollforge/lastmeasure/stats/get.php @ 618

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

$items = Array();
$timestamp = $_GET["timestamp"];
// when 0, select last 20.  when 1+, select since timestamp.
$id = dba_open('../db/hit.db', 'r', 'db4');
if (!$id) {
  return "[ {\"ip\":\"ERROR: unable to read from database\",\"timestamp\":\"\",\"ua\":\"\",\"ref\":\"\",\"user\":\"\",\"clip\":\"\"}]";
}
$key = dba_firstkey($id);
if ($key == false) {
  return "[ {\"ip\":\"ERROR: no hits found in database\",\"timestamp\":\"\",\"ua\":\"\",\"ref\":\"\",\"user\":\"\",\"clip\":\"\"}]";
}
while (1) {
  $n++;
  $date = key2date($key);
  if (($n > 20) || ($timestamp >= $date)) { 
    break;
  }  
  $val = dba_fetch($key, $id);
  list($ip, $port, $host, $uagent,
       $referer, $user, $clipboard) = explode(' ', $val);
  $uagent = base64_decode($uagent);
  $uagent = htmlspecialchars($uagent);
  $referer = base64_decode($referer);
  $referer = htmlspecialchars($referer);
  $user = base64_decode($user);
  $user = htmlspecialchars($user);
  $clipboard = base64_decode($clipboard);
  $clipboard = htmlspecialchars($clipboard);
  $date = date('D, d M Y H:i:s', $date);
  $data = array("ip" => $ip,
                "timestamp" => $date,
                "ua" => $uagent,
                "ref" => $referer,
                "user" => $user,
                "clip" => $clipboard,
                );
  $rv = "{";
  $lines = array();
  foreach ($data as $key => $val) {
    $txt = '"' . $key . '":"' . $val . '"';
    array_push($lines, $txt);
  }
  $rv .= join($lines, ',');
  $rv .= "}";
  array_push($items, $rv);
  $key = dba_nextkey($id);
}
dba_close($id);
$items = array_reverse($items);
print "[ " . join($items, ", ") . " ]";
?>