Execute("select dayofmonth(banners_history_date) as name, banners_shown as value, banners_clicked as dvalue from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . (int)$banner_id . "' and to_days(now()) - to_days(banners_history_date) < " . zen_db_input($days) . " order by banners_history_date"); while (!$banner_stats->EOF) { $stats[] = array($banner_stats->fields['name'], $banner_stats->fields['value'], $banner_stats->fields['dvalue']); $banner_stats->MoveNext(); } if (sizeof($stats) < 1) $stats = array(array(date('j'), 0, 0)); $graph = new PHPlot(200, 220, 'images/graphs/banner_infobox-' . $banner_id . '.' . $banner_extension); $graph->SetFileFormat($banner_extension); $graph->SetIsInline(1); $graph->SetPrintImage(0); $graph->draw_vert_ticks = 0; $graph->SetSkipBottomTick(1); $graph->SetDrawXDataLabels(0); $graph->SetDrawYGrid(0); $graph->SetPlotType('bars'); $graph->SetDrawDataLabels(1); $graph->SetLabelScalePosition(1); $graph->SetMarginsPixels(15,15,15,30); $graph->SetTitleFontSize('4'); $graph->SetTitle(TEXT_BANNERS_LAST_3_DAYS); $graph->SetDataValues($stats); $graph->SetDataColors(array('blue','red'),array('blue', 'red')); $graph->DrawGraph(); $graph->PrintImage();