\n\n')" type="submit" id="post-action-submit" name="adrotate_action_submit" value="" class="button-secondary" />
get_results("SELECT * FROM `".$wpdb->prefix."adrotate_groups` WHERE `name` != '' ORDER BY `id` ASC;"); if(count($groups) > 0) { $class = ''; foreach($groups as $group) { if($adrotate_config['stats'] == 1) { $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); 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; } $modus = array(); 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'); $ads_in_group = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."adrotate_linkmeta` WHERE `group` = ".$group->id.";"); $class = ('alternate' != $class) ? 'alternate' : ''; // Errors if($group->modus == 2 AND $group->gridrows == 1 AND $group->gridcolumns == 1) $class = 'row_yellow'; if($group->cat_loc > 0 AND strlen($group->cat) == 0) $class = 'row_yellow'; if($group->page_loc > 0 AND strlen($group->page) == 0) $class = 'row_yellow'; ?>
 
id; ?>
">name); ?> - ">".__("Mode", 'adrotate').": ".implode(', ', $modus); ?>