FireSpy for user

"; return; } $q = "SELECT * FROM ".TBL_WEB_HITS." WHERE username='".$_GET['user']."' ORDER BY `timestamp` DESC"; if (isset($_GET['limit'])){ $limit = $_GET['limit']; if ($limit<1) $limit=1; if ($limit>20) $limit=20; $q .= " LIMIT ". $limit; } echo ""; $results = $database->query($q); if(!$results || (mysql_numrows($results) < 1)){ echo "ERROR: Must have a valid username"; return; } while ($data = mysql_fetch_assoc($results)){ echo ""; } echo "

"; if ($data['title']=="") $data['title']=$data['url']; if (strlen($data['title']) > 50) $data['title'] = substr($data['title'],0,47). '...'; $time = time()-$data['timestamp']; $timestr = ""; if ($time>60*60*24) $timestr = sprintf("%d",$time/(60*60*24))." days ago"; elseif ($time>60*60) $timestr = sprintf("%d",$time/(60*60))." hours ago"; elseif ($time>60) $timestr = sprintf("%d",$time/60)." minutes ago"; else $timestr = sprintf("%d",$time)." seconds ago"; echo "".$data['title']."

".$timestr."

"; ?>