Location: PHPKode > scripts > AdRotate > adrotate/dashboard/adrotate-manage-groups-main.php
<?php
/*  
Copyright 2010-2012 Arnan de Gans - AJdG Solutions (email : hide@address.com)
*/
?>
<h3><?php _e('Manage Groups', 'adrotate'); ?></h3>

<form name="groups" id="post" method="post" action="admin.php?page=adrotate-groups">
	<?php wp_nonce_field('adrotate_bulk_groups','adrotate_nonce'); ?>

	<div class="tablenav">
		<div class="alignleft">
			<select name="adrotate_action" id="cat" class="postform">
		        <option value=""><?php _e('Bulk Actions', 'adrotate'); ?></option>
		        <option value="group_delete"><?php _e('Delete Group', 'adrotate'); ?></option>
				<option value="group_delete_banners"><?php _e('Delete Group including ads', 'adrotate'); ?></option>
			</select>
			<input onclick="return confirm('<?php _e('You are about to delete a group', 'adrotate'); ?>\n<?php _e('This action can not be undone!', 'adrotate'); ?>\n<?php _e('OK to continue, CANCEL to stop.', 'adrotate'); ?>')" type="submit" id="post-action-submit" name="adrotate_action_submit" value="<?php _e('Go', 'adrotate'); ?>" class="button-secondary" />
		</div>
	</div>
	
   	<table class="widefat" style="margin-top: .5em">
			<thead>
			<tr>
			<th class="check-column">&nbsp;</th>
			<th width="5%"><center><?php _e('ID', 'adrotate'); ?></center></th>
			<th><?php _e('Name', 'adrotate'); ?></th>
			<th width="5%"><center><?php _e('Ads', 'adrotate'); ?></center></th>
			<th width="5%"><center><?php _e('Impressions', 'adrotate'); ?></center></th>
			<th width="5%"><center><?php _e('Today', 'adrotate'); ?></center></th>
			<th width="5%"><center><?php _e('Clicks', 'adrotate'); ?></center></th>
			<th width="5%"><center><?php _e('Today', 'adrotate'); ?></center></th>
			<th width="15%"><center><?php _e('Code', 'adrotate'); ?></center></th>
			<th width="8%"><center><?php _e('Fallback', 'adrotate'); ?></center></th>
		</tr>
			</thead>
		<tbody>
			
		<?php $groups = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix . "adrotate_groups` WHERE `name` != '' ORDER BY `sortorder` ASC, `id` ASC;");
		if ($groups) {
			foreach($groups as $group) {
				$today 			= gmmktime(0, 0, 0, gmdate("n"), gmdate("j"), gmdate("Y"));
				$stats 			= $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `".$wpdb->prefix."adrotate_stats_tracker` WHERE `group` = '$group->id';");
				$stats_today	= $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `".$wpdb->prefix."adrotate_stats_tracker` WHERE `group` = '$group->id' AND `thetime` = '$today';");

				// Prevent gaps in display
				if($stats->impressions == 0) 		$stats->impressions 		= 0;
				if($stats->clicks == 0) 			$stats->clicks 				= 0;
				if($stats_today->impressions == 0) 	$stats_today->impressions 	= 0;
				if($stats_today->clicks == 0) 		$stats_today->clicks 		= 0;

				$ads_in_group = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."adrotate_linkmeta` WHERE `group` = ".$group->id." AND `block` = 0;");
				$class = ('alternate' != $class) ? 'alternate' : ''; ?>
			    <trclass='<?php echo $class; ?>'>
					<th class="check-column"><input type="checkbox" name="groupcheck[]" value="<?php echo $group->id; ?>" /></th>
					<td><center><?php echo $group->id;?></center></td>
					<td><strong><a class="row-title" href="<?php echo admin_url('/admin.php?page=adrotate-groups&view=edit&group='.$group->id);?>" title="<?php _e('Edit', 'adrotate'); ?>"><?php echo $group->name;?></a></strong><br /><a href="<?php echo admin_url('/admin.php?page=adrotate-groups&view=report&group='.$group->id);?>" title="<?php _e('Report', 'adrotate'); ?>"><?php _e('Report', 'adrotate'); ?></a></td>
					<td><center><?php echo $ads_in_group;?></center></td>
					<td><center><?php echo $stats->impressions;?></center></td>
					<td><center><?php echo $stats_today->impressions;?></center></td>
					<td><center><?php echo $stats->clicks;?></center></td>
					<td><center><?php echo $stats_today->clicks;?></center></td>
					<td><center>[adrotate group="<?php echo $group->id; ?>"]</center></td>
					<td><center><?php if($group->fallback == 0) { echo "Not set"; } else { echo $group->fallback; } ?></center></td>
				</tr>
				<?php unset($stats);?>
 			<?php } ?>
		<?php } else { ?>
		<tr>
			<th class="check-column">&nbsp;</th>
			<td colspan="9"><em><?php _e('No groups created!', 'adrotate'); ?></em></td>
		</tr>
		<?php } ?>
			</tbody>
	</table>
</form>
Return current item: AdRotate