Logs and Statistics

Quick Stats

'; echo "Since ".date("F j, Y \\a\\t g:i:sa, T", mysql_result(mysql_query("SELECT MIN(time) FROM requestlog;"), 0, 0)).":"; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(*) FROM musictags;"), 0, 0)." songs available
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(*) FROM requestlog;"), 0, 0)." total songs served
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(DISTINCT sha1) FROM requestlog;"), 0, 0)." different songs served
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(*) FROM requestlog WHERE zip=0;"), 0, 0)." songs streamed in the web player
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(*) FROM requestlog WHERE zip=1;"), 0, 0)." downloaded in zip files
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(*) FROM requestlog WHERE zip=1 AND leaderid=-1;"), 0, 0)." total zip files downloaded
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(DISTINCT ip) FROM requestlog;"), 0, 0)." different IP addresses
    • "; echo "
  • ".mysql_result(mysql_query("SELECT COUNT(DISTINCT useragent) FROM requestlog;"), 0, 0)." different user agents
    • "; echo "It is now ".date("F j, Y \\a\\t g:i:sa, T").".
    "; echo '

    Top 10 Artists

    '; $query = mysql_query("SELECT COUNT(artist), artist FROM requestlog GROUP BY artist ORDER BY COUNT(artist) DESC LIMIT 10;"); while($result = mysql_fetch_assoc($query)) { echo "
  • ".$result["COUNT(artist)"].": ".$result["artist"]."
    • "; } echo "
    "; echo '

    Top 10 User Agents

    '; $query = mysql_query("SELECT COUNT(DISTINCT ip), useragent FROM requestlog GROUP BY useragent ORDER BY COUNT(DISTINCT ip) DESC LIMIT 10;"); while($result = mysql_fetch_assoc($query)) { echo "
  • ".$result["COUNT(DISTINCT ip)"].": ".htmlentities($result["useragent"])."
    • "; } echo "
    "; echo '

    Requests by IP Address Ordered by Most Recent IP Request

    '; function linkTerm($term, $type) { if($term == "") { return " "; } return "".$term.""; } $ipsResult = mysql_query("SELECT ip, MAX(time), COUNT(*) FROM requestlog GROUP BY ip ORDER BY MAX(time) DESC;"); while($row = mysql_fetch_assoc($ipsResult)) { echo ""; echo ""; $requestResult = mysql_query("SELECT * FROM requestlog WHERE ip = '".mysql_real_escape_string($row["ip"])."' AND leaderid = -1 ORDER BY time DESC"); while($listen = mysql_fetch_assoc($requestResult)) { if($listen["zip"]) { echo ""; $subRequestResult = mysql_query("SELECT * FROM requestlog WHERE leaderid = ".$listen["id"]." ORDER BY time DESC"); do { echo ""; } while($listen = mysql_fetch_assoc($subRequestResult)); } else { echo ""; } } echo "
    ".$row["ip"]." (".htmlentities(@gethostbyaddr($row["ip"])).") ".$row["COUNT(*)"]." total downloads
    ".date("M j, Y g:i:sa T", $listen["time"])."Zip File".$listen["useragent"]."
    ".linkTerm($listen["artist"], "artist")."".linkTerm($listen["album"], "album")."".linkTerm($listen["title"], "title")."".linkTerm($listen["sha1"], "sha1")."
    ".date("M j, Y g:i:sa T", $listen["time"])."".linkTerm($listen["artist"], "artist")."".linkTerm($listen["album"], "album")."".linkTerm($listen["title"], "title")."".linkTerm($listen["sha1"], "sha1")."".htmlentities($listen["useragent"])."
    "; echo "

    "; } ?>

    ZX2C4 Music is © Copyright 2004-2012 Jason A. Donenfeld. All Rights Reserved.