get_var("SELECT `id` FROM `".$wpdb->prefix."adrotate_groups` WHERE `name` = '' ORDER BY `id` DESC LIMIT 1;"); if($edit_id == 0) { $wpdb->insert($wpdb->prefix.'adrotate_groups', array('name' => '', 'modus' => 0, 'fallback' => '0', 'sortorder' => 0, 'cat' => '', 'cat_loc' => 0, 'cat_par' => 0, 'page' => '', 'page_loc' => 0, 'page_par' => 0, 'geo' => 0, 'wrapper_before' => '', 'wrapper_after' => '', 'gridrows' => 2, 'gridcolumns' => 2, 'admargin' => 0, 'admargin_bottom' => 0, 'admargin_left' => 0, 'admargin_right' => 0, 'adwidth' => '125', 'adheight' => '125', 'adspeed' => 6000)); $edit_id = $wpdb->insert_id; } $group_edit_id = $edit_id; ?> get_row("SELECT * FROM `".$wpdb->prefix."adrotate_groups` WHERE `id` = '$group_edit_id';"); $groups = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."adrotate_groups` WHERE `name` != '' ORDER BY `id` ASC;"); $ads = $wpdb->get_results("SELECT `id`, `title`, `tracker`, `weight`, `crate`, `cbudget`, `irate`, `ibudget`, `type` FROM `".$wpdb->prefix."adrotate` WHERE (`type` != 'empty' AND `type` != 'a_empty') ORDER BY `id` ASC;"); $linkmeta = $wpdb->get_results("SELECT `ad` FROM `".$wpdb->prefix."adrotate_linkmeta` WHERE `group` = '$group_edit_id' AND `user` = 0;"); $meta_array = ''; foreach($linkmeta as $meta) { $meta_array[] = $meta->ad; } if(!is_array($meta_array)) $meta_array = array(); ?>

name == '') { ?>

	id; ?>

	, .	-
	,	-
		-

	[adrotate group="id; ?>"]		<?php echo adrotate_group(id; ?>); ?>

	.


	cat, 0, 0, 0); ?>

	page, 0, 0, 0); ?>

	[adrotate group="id; ?>"]		<?php echo adrotate_group(id; ?>); ?>

	<?php echo stripslashes($edit_group->wrapper_before); ?>	<span style="background-color:#aaa;"> %id%
	<?php echo stripslashes($edit_group->wrapper_after); ?>	</span>

<span style="background-color:#aaa;">

%id%

</span>

get_var("SELECT `stoptime` FROM `".$wpdb->prefix."adrotate_schedule`, `".$wpdb->prefix."adrotate_linkmeta` WHERE `ad` = '".$ad->id."' AND `schedule` = `".$wpdb->prefix."adrotate_schedule`.`id` ORDER BY `stoptime` DESC LIMIT 1;"); $stats = adrotate_stats($ad->id); $errorclass = ''; if($ad->type == 'error') $errorclass = ' row_error'; if($ad->type == 'expired') $errorclass = ' row_inactive'; if($ad->type == '2days') $errorclass = ' row_urgent'; $class = ('alternate' != $class) ? 'alternate' : ''; $class = ($errorclass != '') ? $errorclass : $class; ?>


id, $meta_array)) echo "checked"; ?> />	id; ?> - title)); ?>		tracker == 'Y') { echo $stats['clicks']; } else { ?>--	weight; ?>