Pardon me, but I can see your Minty bits

I must admit I was a little bummed when I couldn’t find a built-in way to expose data from Mint as something that Flash could eat.

Not a huge deal, data freedom is but a class away. The code below returns a JSON object of hourly visitor stats (total and unique) for the past 24 hours.

JSON format:
site_stats=[[hour-in-24hour-format,unique-visitors,total-visitors],…]

<?php
class mint_for_chumby {
    /*
    getJSONPast24
    -------------
    Returns a JSON object of the compiled statsfor the past 24 hours
    */
    function getJSONPast24() {
        $current_hour = 
            mktime(
                date('H'), 0, 0, date('m'), date('d'), date('Y')
            );

        echo "site_stats=[";

        //Cycle backwards through the past 24 hours
        for($hour_offset = 23; $hour_offset >= 0; $hour_offset--) {
            if($hour_offset < 23) {
                echo ",";
            }

            $this->getJSONForHour($current_hour, $hour_offset);
        }

        echo "]";
    }

    /*
    getJSONForHour
    --------------
    Takes a unix timestamp (rounded to the hour) and an hour offset, 
    and returns total number of hits for that hour
    */
    function getJSONForHour($current_hour, $past_hour_offset) {

        //Time range
        $start_time = $current_hour - ($past_hour_offset * 3600);
        $end_time = $current_hour - (($past_hour_offset - 1) * 3600);

        $total_visits = 0;
        $unique_visits = 0;
        $hour = date("H",$start_time);

        //Pull data from db, group sessions together to form uniques
        $query =  "SELECT COUNT(session_checksum) as repeat ";
        $query .= "FROM mint_visit ";
        $query .= "WHERE (dt > {$start_time} and dt < {$end_time}) ";
        $query .= "GROUP BY session_checksum";
        $stats_for_hour = mysql_query($query);

        while($stats_row = mysql_fetch_array($stats_for_hour)) {
            $unique_visits++;
            $total_visits += $stats_row['repeat'];
        }

        echo "[{$hour},{$unique_visits},{$total_visits}]";

    }
}
?>

Just call it with:

$mint_funcs = new mint_for_chumby();
$mint_funcs->getJSONPast24();