Location: PHPKode > scripts > AdRotate > adrotate/dashboard/adrotate-manage-groups-edit.php
<?php
/*  
Copyright 2010-2012 Arnan de Gans - AJdG Solutions (email : hide@address.com)
*/
?>
<?php if(!$group_edit_id) { ?>
<h3><?php _e('New group', 'adrotate'); ?></h3>
	<?php
	$action = "group_new";
	$query = "SELECT `id` FROM `".$wpdb->prefix."adrotate_groups` WHERE `name` = '' ORDER BY `id` DESC LIMIT 1;";
	$edit_id = $wpdb->get_var($query);
	if($edit_id == 0) {
	    $wpdb->insert($wpdb->prefix."adrotate_groups", array('name' => '', 'fallback' => 0, 'sortorder' => 0, 'cat' => '', 'cat_loc' => 0, 'page' => '', 'page_loc' => 0));
	    $edit_id = $wpdb->insert_id;
	}
	$group_edit_id = $edit_id;
	?>
<?php } else { ?>
<h3><?php _e('Edit Group', 'adrotate'); ?></h3>
<?php 
	$action = "group_edit";
}

$edit_group = $wpdb->get_row($wpdb->prepare("SELECT * FROM `".$wpdb->prefix."adrotate_groups` WHERE `id` = '%s';", $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` FROM `".$wpdb->prefix."adrotate` WHERE `type` = 'active' ORDER BY `id` ASC;");
$linkmeta	= $wpdb->get_results("SELECT `ad` FROM `".$wpdb->prefix."adrotate_linkmeta` WHERE `group` = '".$edit_group->id."' AND `block` = 0 AND `user` = 0;");
foreach($linkmeta as $meta) {
	$meta_array[] = $meta->ad;
}
if(!is_array($meta_array)) $meta_array = array();
?>

<form name="editgroup" id="post" method="post" action="admin.php?page=adrotate-groups">
	<?php wp_nonce_field('adrotate_save_group','adrotate_nonce'); ?>
	<input type="hidden" name="adrotate_id" value="<?php echo $edit_group->id;?>" />
	<input type="hidden" name="adrotate_action" value="<?php echo $action;?>" />

   	<table class="widefat" style="margin-top: .5em">

			<thead>
			<tr>
			<th colspan="4"><?php _e('The basics (required)', 'adrotate'); ?></th>
		</tr>
			</thead>

		<tbody>
	    <tr>
			<th width="15%"><?php _e('ID:', 'adrotate'); ?></th>
			<td colspan="3"><?php echo $edit_group->id; ?></td>
		</tr>
	    <tr>
			<th width="15%"><?php _e('Name:', 'adrotate'); ?></th>
			<td colspan="3">
				<label for="adrotate_groupname"><input tabindex="1" name="adrotate_groupname" type="text" class="search-input" size="80" value="<?php echo $edit_group->name; ?>" autocomplete="off" /></label>
			</td>
		</tr>
		<?php if($edit_group->name != '') { ?>
      	<tr>
	        <th><?php _e('This group is in the block(s):', 'adrotate'); ?></th>
	        <td colspan="3"><p><?php echo adrotate_group_is_in_blocks($edit_group->id); ?></p></td>
      	</tr>
		<?php } ?>
		</tbody>

			<thead>
			<tr>
			<th colspan="4"><?php _e('Advanced (optional)', 'adrotate'); ?></th>
		</tr>
			</thead>

		<tbody>
	    <tr>
			<th><?php _e('Fallback group?', 'adrotate'); ?></th>
			<td colspan="3">
				<label for="adrotate_fallback">
				<select tabindex="2" name="adrotate_fallback">
		        <option value="0"><?php _e('No', 'adrotate'); ?></option>
			<?php if ($groups) { ?>
				<?php foreach($groups as $group) { ?>
			        <option value="<?php echo $group->id;?>" <?php if($edit_group->fallback == $group->id) { echo 'selected'; } ?>><?php echo $group->id;?> - <?php echo $group->name;?></option>
	 			<?php } ?>
			<?php } ?>
				</select> <em><?php _e('You need atleast two groups to use this feature!', 'adrotate'); ?></em>
				</label>
			</td>
		</tr>
      	<tr>
	        <th valign="top"><?php _e('Include ads in categories?', 'adrotate'); ?></th>
	        <td colspan="3">
	        <label for="adrotate_cat_location">
		        <select tabindex="2" name="adrotate_cat_location">
		        	<option value="0" <?php if($edit_group->cat_loc == 0) { echo 'selected'; } ?>><?php _e('Do not use this feature', 'adrotate'); ?></option>
		        	<option value="1" <?php if($edit_group->cat_loc == 1) { echo 'selected'; } ?>><?php _e('Before the post content', 'adrotate'); ?></option>
		        	<option value="2" <?php if($edit_group->cat_loc == 2) { echo 'selected'; } ?>><?php _e('After the post content', 'adrotate'); ?></option>
		        	<option value="3" <?php if($edit_group->cat_loc == 3) { echo 'selected'; } ?>><?php _e('Before and after the content', 'adrotate'); ?></option>
		        </select> 
	        </td>
      	</tr>
      	<tr>
	        <th valign="top"><?php _e('Which categories?', 'adrotate'); ?></th>
	        <td colspan="3">
	        <label for="adrotate_categories">
		        <select multiple="true" tabindex="2" name="adrotate_categories[]">
		        <?php echo adrotate_dropdown_categories($edit_group->cat, 0, 0, 0); ?>
		        </select> <em><?php _e('Click the categories you want the adverts to show in. Hold down CTRL (CMD for Apple OS X) to select multiple.', 'adrotate'); ?></em>
	        </label>
	        </td>
      	</tr>
      	<tr>
	        <th valign="top"><?php _e('Include ads in pages?', 'adrotate'); ?></th>
	        <td colspan="3">
	        <label for="adrotate_page_location">
		        <select tabindex="2" name="adrotate_page_location">
		        	<option value="0" <?php if($edit_group->page_loc == 0) { echo 'selected'; } ?>><?php _e('Do not use this feature', 'adrotate'); ?></option>
		        	<option value="1" <?php if($edit_group->page_loc == 1) { echo 'selected'; } ?>><?php _e('Before the page content', 'adrotate'); ?></option>
		        	<option value="2" <?php if($edit_group->page_loc == 2) { echo 'selected'; } ?>><?php _e('After the page content', 'adrotate'); ?></option>
		        	<option value="3" <?php if($edit_group->page_loc == 3) { echo 'selected'; } ?>><?php _e('Before and after the content', 'adrotate'); ?></option>
		        </select>
			</label>
	        </td>
      	</tr>
      	<tr>
	        <th valign="top"><?php _e('Which pages?', 'adrotate'); ?></th>
	        <td colspan="3">
	        <label for="adrotate_pages">
		        <select multiple="true" tabindex="2" name="adrotate_pages[]">
		        <?php echo adrotate_dropdown_pages($edit_group->page, 0, 0, 0); ?>
		        </select> <em><?php _e('Click the pages you want the adverts to show in. Hold down CTRL (CMD for Apple OS X) to select multiple.', 'adrotate'); ?></em>
	        </label>
	        </td>
      	</tr>
      	<tr>
	        <th><?php _e('Sortorder:', 'adrotate'); ?></th>
	        <td colspan="3">
		        <label for="adrotate_sortorder"><input tabindex="23" name="adrotate_sortorder" type="text" size="5" class="search-input" autocomplete="off" value="<?php echo $edit_group->sortorder;?>" /> <em><?php _e('For administrative purposes set a sortorder.', 'adrotate'); ?> <?php _e('Leave empty or 0 to skip this. Will default to group id.', 'adrotate'); ?></em></label>
			</td>
      	</tr>
		</tbody>

		<thead>
		<tr>
			<th colspan="4"><?php _e('Usage', 'adrotate'); ?></th>
		</tr>
		</thead>

		<tbody>
      	<tr>
	        <th width="15%"><?php _e('In a post or page:', 'adrotate'); ?></th>
	        <td width="35%"><p>[adrotate group="<?php echo $edit_group->id; ?>"]</p></td>
	        <th width="15%"><?php _e('Directly in a theme:', 'adrotate'); ?></th>
	        <td width="35%"><p>&lt;?php echo adrotate_group(<?php echo $edit_group->id; ?>); ?&gt;</p></td>
      	</tr>
      	</tbody>
	</table>

	<p class="submit">
		<input tabindex="3" type="submit" name="adrotate_group_submit" class="button-primary" value="<?php _e('Save', 'adrotate'); ?>" />
		<a href="admin.php?page=adrotate-groups&view=manage" class="button"><?php _e('Cancel', 'adrotate'); ?></a>
	</p>

	<h3><?php _e('Select Ads', 'adrotate'); ?></h3>

   	<table class="widefat" style="margin-top: .5em">
			<thead>
			<tr>
			<th colspan="2"><?php _e('Choose the ads to use in this group', 'adrotate'); ?></th>
			<th width="5%"><center><?php _e('Impressions', 'adrotate'); ?></center></th>
			<th width="5%"><center><?php _e('Clicks', 'adrotate'); ?></center></th>
			<th width="5%"><center><?php _e('Weight', 'adrotate'); ?></center></th>
			<th width="15%"><?php _e('Visible until', 'adrotate'); ?></th>
		</tr>
			</thead>

		<tbody>
		<?php if($ads) {
			foreach($ads as $ad) {
				$stats = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `".$wpdb->prefix."adrotate_stats_tracker` WHERE `ad` = '".$ad->id."';");
				$stoptime = $wpdb->get_var("SELECT `stoptime` FROM `".$wpdb->prefix."adrotate_schedule` WHERE `ad` = '".$ad->id."' ORDER BY `stoptime` DESC LIMIT 1;");						

				// Prevent gaps in display
				if($stats->impressions == 0) { 
					$impressions = 0;
				} else {
					$impressions = $stats->impressions;
				}
				
				if($ad->tracker == 'Y') {
					if($stats->clicks == 0) { 
						$clicks = 0;
					} else { 
						$clicks = $stats->clicks;
					}
				} else {
					$clicks = '--';
				}

				$class = ('alternate' != $class) ? 'alternate' : ''; ?>
			    <tr class='<?php echo $class; ?>'>
					<th width="2%"><input type="checkbox" name="adselect[]" value="<?php echo $ad->id; ?>" <?php if(in_array($ad->id, $meta_array)) echo "checked"; ?> /></th>
					<td><?php echo $ad->id; ?> - <strong><?php echo $ad->title; ?></strong></td>
					<td><center><?php echo $impressions; ?></center></td>
					<td><center><?php echo $clicks; ?></center></td>
					<td><center><?php echo $ad->weight; ?></center></td>
					<td><span style="color: <?php echo adrotate_prepare_color($stoptime);?>;"><?php echo date_i18n("F d, Y", $stoptime); ?></span></td>
				</tr>
			<?php unset($stats);?>
 			<?php } ?>
		<?php } else { ?>
		<tr>
			<th class="check-column">&nbsp;</th>
			<td colspan="5"><em><?php _e('No ads created!', 'adrotate'); ?></em></td>
		</tr>
		<?php } ?>
		</tbody>					
		</table>

	<p class="submit">
		<input tabindex="3" type="submit" name="adrotate_group_submit" class="button-primary" value="<?php _e('Save', 'adrotate'); ?>" />
		<a href="admin.php?page=adrotate-groups&view=manage" class="button"><?php _e('Cancel', 'adrotate'); ?></a>
	</p>

</form>
Return current item: AdRotate