";
$output .= adrotate_ad_output($banner['id'], 0, $banner['title'], $banner['bannercode'], $banner['tracker'], $image);
$output .= "
";
if($adrotate_config['stats'] == 1 AND $banner['tracker'] == 'Y') {
adrotate_count_impression($banner['id'], 0);
}
} else {
$output .= adrotate_error('ad_expired', array($banner_id));
}
unset($banner);
} else {
$output .= adrotate_error('ad_no_id');
}
return $output;
}
/*-------------------------------------------------------------
Name: adrotate_group
Purpose: Fetch ads in specified group(s) and show a random ad
-------------------------------------------------------------*/
function adrotate_group($group_ids, $opt = null) {
global $wpdb, $adrotate_config;
$output = $group_select = '';
if($group_ids) {
$options = wp_parse_args($opt, array());
$now = current_time('timestamp');
$group_array = (preg_match('/,/is', $group_ids)) ? explode(',', $group_ids) : array($group_ids);
$group_array = array_filter($group_array);
foreach($group_array as $key => $value) {
$group_select .= " `{$wpdb->prefix}adrotate_linkmeta`.`group` = ".$wpdb->prepare('%d', $value)." OR";
}
$group_select = rtrim($group_select, " OR");
$group = $wpdb->get_row($wpdb->prepare("SELECT * FROM `{$wpdb->prefix}adrotate_groups` WHERE `name` != '' AND `id` = %d;", $group_array[0]));
if($group) {
// Get all ads in all selected groups
$ads = $wpdb->get_results(
"SELECT
`{$wpdb->prefix}adrotate`.`id`,
`{$wpdb->prefix}adrotate`.`title`,
`{$wpdb->prefix}adrotate`.`bannercode`,
`{$wpdb->prefix}adrotate`.`image`,
`{$wpdb->prefix}adrotate`.`tracker`,
`{$wpdb->prefix}adrotate_linkmeta`.`group`
FROM
`{$wpdb->prefix}adrotate`,
`{$wpdb->prefix}adrotate_linkmeta`
WHERE
({$group_select})
AND `{$wpdb->prefix}adrotate_linkmeta`.`user` = 0
AND `{$wpdb->prefix}adrotate`.`id` = `{$wpdb->prefix}adrotate_linkmeta`.`ad`
AND (`{$wpdb->prefix}adrotate`.`type` = 'active'
OR `{$wpdb->prefix}adrotate`.`type` = '2days'
OR `{$wpdb->prefix}adrotate`.`type` = '7days')
GROUP BY `{$wpdb->prefix}adrotate`.`id`
ORDER BY `{$wpdb->prefix}adrotate`.`id`;"
, ARRAY_A);
if($ads) {
foreach($ads as $key => $ad) {
if(adrotate_filter_schedule($ad)) {
unset($ads[$key]);
}
}
$array_count = count($ads);
if($array_count > 0) {
$before = $after = '';
$before = str_replace('%id%', $group_array[0], stripslashes(html_entity_decode($group->wrapper_before, ENT_QUOTES)));
$after = str_replace('%id%', $group_array[0], stripslashes(html_entity_decode($group->wrapper_after, ENT_QUOTES)));
$output .= "id."\">";
// Kill dynamic mode for mobile users
if($group->modus == 1 AND wp_is_mobile()) {
$group->modus = 0;
}
if($group->modus == 1) { // Dynamic ads
$i = 1;
// Randomize and trim output
$ads = adrotate_shuffle($ads);
$ads = array_slice($ads, 0, 10, 1);
foreach($ads as $key => $banner) {
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $banner['image']);
$output .= "
";
$output .= $before.adrotate_ad_output($banner['id'], $group->id, $banner['title'], $banner['bannercode'], $banner['tracker'], $image).$after;
$output .= "
";
$i++;
}
} else if($group->modus == 2) { // Block of ads
$block_count = $group->gridcolumns * $group->gridrows;
if($array_count < $block_count) $block_count = $array_count;
$columns = 1;
for($i=1;$i<=$block_count;$i++) {
$array_key = array_rand($ads, 1);
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $ads[$array_key]['image']);
$output .= "
id." a-".$ads[$array_key]['id']."\">";
$output .= $before.adrotate_ad_output($ads[$array_key]['id'], $group->id, $ads[$array_key]['title'], $ads[$array_key]['bannercode'], $ads[$array_key]['tracker'], $image).$after;
$output .= "
";
if($columns == $group->gridcolumns AND $i != $block_count) {
$output .= "
id."\">";
$columns = 1;
} else {
$columns++;
}
if($adrotate_config['stats'] == 1 AND $ads[$array_key]['tracker'] == 'Y') {
adrotate_count_impression($ads[$array_key]['id'], $group->id);
}
unset($ads[$array_key]);
}
} else { // Default (single ad)
$array_key = array_rand($ads, 1);
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $ads[$array_key]['image']);
$output .= "
";
$output .= $before.adrotate_ad_output($ads[$array_key]['id'], $group->id, $ads[$array_key]['title'], $ads[$array_key]['bannercode'], $ads[$array_key]['tracker'], $image).$after;
$output .= "
";
if($adrotate_config['stats'] == 1 AND $ads[$array_key]['tracker'] == 'Y') {
adrotate_count_impression($ads[$array_key]['id'], $group->id);
}
}
$output .= "
id."\">";
$output .= "
id."\">";
$output .= $before.adrotate_ad_output($selected[$banner_id]->id, $group->id, $selected[$banner_id]->title, $selected[$banner_id]->bannercode, $selected[$banner_id]->tracker, $image).$after;
$output .= "
";
if($adrotate_config['stats'] == 1 AND ($selected[$banner_id]->tracker == "Y")) {
adrotate_count_impression($selected[$banner_id]->id, $group->id);
}
$output .= "