get_row("SELECT `title`, `tracker`, `type` FROM `{$wpdb->prefix}adrotate` WHERE `id` = '{$id}';"); $schedules = $wpdb->get_results("SELECT `{$wpdb->prefix}adrotate_schedule`.`id`, `starttime`, `stoptime`, `maxclicks`, `maximpressions`, COUNT(`clicks`) as `clicks`, COUNT(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_schedule`, `{$wpdb->prefix}adrotate_linkmeta`, `{$wpdb->prefix}adrotate_stats` WHERE `{$wpdb->prefix}adrotate_linkmeta`.`ad` = '{$id}' AND `{$wpdb->prefix}adrotate_linkmeta`.`ad` = `{$wpdb->prefix}adrotate_stats`.`ad` AND `schedule` = `{$wpdb->prefix}adrotate_schedule`.`id` AND `thetime` > `starttime` AND `thetime` < `stoptime` ORDER BY `{$wpdb->prefix}adrotate_schedule`.`id` ASC;"); $stats = adrotate_stats($id, false); $stats_today = adrotate_stats($id, false, adrotate_date_start('day')); $stats_last_month = adrotate_stats($id, false, mktime(0, 0, 0, date("m")-1, 1, date("Y")), mktime(0, 0, 0, date("m"), 0, date("Y"))); $stats_this_month = adrotate_stats($id, false, mktime(0, 0, 0, date("m"), 1, date("Y")), mktime(0, 0, 0, date("m"), date("t"), date("Y"))); $stats_graph_month = adrotate_stats($id, false, $monthstart, $monthend); // Prevent gaps in display if(empty($stats['impressions'])) $stats['impressions'] = 0; if(empty($stats['clicks'])) $stats['clicks'] = 0; if(empty($stats_today['impressions'])) $stats_today['impressions'] = 0; if(empty($stats_today['clicks'])) $stats_today['clicks'] = 0; if(empty($stats_last_month['impressions'])) $stats_last_month['impressions'] = 0; if(empty($stats_last_month['clicks'])) $stats_last_month['clicks'] = 0; if(empty($stats_this_month['impressions'])) $stats_this_month['impressions'] = 0; if(empty($stats_this_month['clicks'])) $stats_this_month['clicks'] = 0; if(empty($stats_graph_month['impressions'])) $stats_graph_month['impressions'] = 0; if(empty($stats_graph_month['clicks'])) $stats_graph_month['clicks'] = 0; // Get Click Through Rate $ctr = adrotate_ctr($stats['clicks'], $stats['impressions']); $ctr_today = adrotate_ctr($stats_today['clicks'], $stats_today['impressions']); $ctr_last_month = adrotate_ctr($stats_last_month['clicks'], $stats_last_month['impressions']); $ctr_this_month = adrotate_ctr($stats_this_month['clicks'], $stats_this_month['impressions']); $ctr_graph_month = adrotate_ctr($stats_graph_month['clicks'], $stats_graph_month['impressions']); ?>

'title); ?>'


	tracker == "Y") { echo $stats_graph_month['clicks']; } else { echo '--'; } ?>	tracker == "Y") { echo $ctr_graph_month.' %'; } else { echo '--'; } ?>

starttime, $schedule->stoptime); if($schedule->maxclicks == 0) $schedule->maxclicks = '∞'; if($schedule->maximpressions == 0) $schedule->maximpressions = '∞'; ?>

		/	/
starttime);?>	stoptime);?>	maxclicks; ?> /	maximpressions; ?> /

- !