get_results("SELECT * FROM `".$wpdb->prefix . "adrotate_groups` WHERE `name` != '' ORDER BY `sortorder` ASC, `id` ASC;"); if($groups) { $class = ''; $modus = array(); foreach($groups as $group) { $stats = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `".$wpdb->prefix."adrotate_stats` WHERE `group` = '$group->id';", ARRAY_A); $stats_today = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `".$wpdb->prefix."adrotate_stats` WHERE `group` = '$group->id' AND `thetime` = '$today';", ARRAY_A); // 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($group->adspeed > 0) $adspeed = $group->adspeed / 1000; if($group->modus == 0) $modus[] = __('Default', 'adrotate'); if($group->modus == 1) $modus[] = __('Dynamic', 'adrotate').' ('.$adspeed.' '. __('second rotation', 'adrotate').')'; if($group->modus == 2) $modus[] = __('Block', 'adrotate').' ('.$group->gridrows.' x '.$group->gridcolumns.' '. __('grid', 'adrotate').')'; if($group->cat_loc > 0 OR $group->page_loc > 0) $modus[] = __('Post Injection', 'adrotate'); if($group->geo == 1) $modus[] = __('Geolocation', 'adrotate'); $ads_in_group = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."adrotate_linkmeta` WHERE `group` = ".$group->id.";"); $class = ('alternate' != $class) ? 'alternate' : ''; ?>
 
id;?>
 name;?> - '.__('Mode', 'adrotate').': '.implode(', ', $modus); ?>
[adrotate group="id; ?>"]
 
.