<?php
  include '../../lib/common.php';
  include '../../lib/db.php';
  include '../../lib/BarChart.php';
  
  // get current month and year
  list($month,$year) = explode('/', date('m/Y'));
  
  // determine which query to execute
  if (isset($\_GET[\text{'}day\text{'}]))\; \{$// initialize arrays 
      num_days = date("t", mktime(0, 0, 0, $month,\; 1,$year));
      for ($i\; =\; 1;$i < $num\_days\; +\; 1;$i++)
      {
          $data[$i] = 0;
          $labels[$i] = $i;$colors[$i]\; =\; array(\text{'}r\text{'}\; =>\; 0xCC,\; \text{'}g\text{'}\; =>\; 0x33,\; \text{'}b\text{'}\; =>\; 0x33);\; \}$// retrieve total hits
      query = sprintf('
          SELECT
              DAY(ACCESS_TIME) AS ATIME, COUNT(IP_ADDRESS) AS TOTAL
          FROM
              \%sSITE_ACCESS
          WHERE
              DATE(ACCESS_TIME) BETWEEN
                  "\%d-%02d-01" AND
                  "\%d-%02d-01" + INTERVAL 1 MONTH - INTERVAL 1 DAY
          GROUP BY
              ATIME
          ORDER BY 
              ATIME ASC',
          DB_TBL_PREFIX,
          $year,$month,
          $year,$month);
          
      $result\; =\; mysql\_query($query, $GLOBALS[\text{'}DB\text{'}]);\; while\; ($row = mysql_fetch_assoc($result))\; \{$data[$row[\text{'}ATIME\text{'}]]\; =$row['TOTAL'];
      }
      mysql_free_result($result);\; \}\; else\; if\; (isset($_GET['month']))
  {
      // initialize arrays 
      for ($i\; =\; 1;$i < 13; $i++)\; \{$data[$i]\; =\; 0;$labels[$i]\; =\; date("M",\; mktime(0,0,0,$i));
          $colors[$i] = array('r' => 0xCC, 'g' => 0x33, 'b' => 0x33);
      }        
  
      // retrieve total hits
      $query\; =\; sprintf(\text{'}\; SELECT\; MONTH(ACCESS\_TIME)\; AS\; ATIME,\; COUNT(IP\_ADDRESS)\; AS\; TOTAL\; FROM$\%sSITE_ACCESS
          WHERE  
              DATE(ACCESS_TIME) BETWEEN
                  "\%d-01-01" AND
                  "\%d-12-31"
              GROUP
                  BY ATIME
              ORDER BY
                  ATIME ASC',
              DB_TBL_PREFIX,
              year,
              $year);$result = mysql_query($query,$GLOBALS['DB']);
  
      while ($row\; =\; mysql\_fetch\_assoc($result))
      {
          $data[$row['ATIME']] = $row[\text{'}TOTAL\text{'}];\; \}\; mysql\_free\_result($result);
  }
  else
  {
      die();
  }
  
  // present bar chart
  $chart\; =\; new\; BarChart(500,\; 200);$chart->graphData($data,$colors, $labels);$chart->flushImage();
  ?>