<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
$format = "M Y";


$sql = "SELECT * FROM ads ORDER BY postdate DESC limit 10000";
$q = $connect->query($sql);
 $total=0;
while($row = $q->fetch_array()){
   $date = intval($row['postdate']);
 $ads[date($format,$date)] +=1;

}

foreach($ads as $k=>$v){
    $ads_data .= ',["'.$k.'",'.$v.']';
     $total+=$v;
}


$tplbody = file_get_contents('index_tpl.html');
$tplbody = str_replace("{ads_data}", $ads_data, $tplbody);
$tplbody = str_replace("{ads_total}", $total, $tplbody);
echo $tplbody;

function datemaker($time,$days = 0){
    $time+=($days*86400);
    return date("m/d/Y",$time);
}

function unix($time2){
    $time = explode('/',$time2);
    //$time3 = str_replace('/', '-', $time2);
    return array("day"=>$time[1],"month"=>$time[0],"year"=>$time[2],"unix"=>strtotime($time2),"format"=>$time2);
}

function format(){
    global $to;global $from;
    $diff = ($to["unix"]-$from["unix"]);
    if($diff <= 86400){$format = "H:00";}
    else if(86400*30*3 <= $diff){$format = 'M y';}
    else if(86400*31 >= $diff){$format = 'D jS M';}
    else{$format = 'm/d/Y';}
    return $format;
}


?>