function show_notifications()
{
if (!extension_loaded("SimpleXML")) {
echo '<div class="box plain">';
echo '<div class="notify">';
echo '<a href="javascript:;" class="close">×</a>';
echo '<h3>SimpleXML Not Loaded</h3>';
echo '<p>mAdserve has detected that the SimpleXML PHP Module is not installed on this machine. mAdserve will not work properly if you do not install this module. For more information on SimpleXML, <a href="http://php.net/manual/book.simplexml.php">click here</a>.</strong></p>';
echo '</div> <!-- .notify -->';
echo '</div>';
}
if (!check_cron_active()) {
echo '<div class="box plain">';
echo '<div class="notify">';
echo '<a href="javascript:;" class="close">×</a>';
echo '<h3>Cron Job Not Installed</h3>';
echo '<p>mAdserve has detected that the required daily cron-job has not not been installed yet. Please note that you will not be able to add impression caps to your campaigns until you install the cron job. For more information on how to activate the cron job, <a href="http://help.madserve.org/cron.php" target="_blank">click here</a>. <strong>Please note that once you intall the cron job, it will take up to 24 hours for this message to disappear.</strong></p>';
echo '</div> <!-- .notify -->';
echo '</div>';
}
}
function build_query()
{
global $request_settings;
global $zone_detail;
if (isset($request_settings['geo_country']) && !empty($request_settings['geo_country']) && isset($request_settings['geo_region']) && !empty($request_settings['geo_region'])) {
$query_part['geo'] = " OR (c1.targeting_type='geo' AND (c1.targeting_code='" . $request_settings['geo_country'] . "' OR c1.targeting_code='" . $request_settings['geo_country'] . "_" . $request_settings['geo_region'] . "')))";
} else {
if (isset($request_settings['geo_country']) && !empty($request_settings['geo_country'])) {
$query_part['geo'] = " OR (c1.targeting_type='geo' AND c1.targeting_code='" . $request_settings['geo_country'] . "'))";
} else {
$query_part['geo'] = ')';
}
}
if (isset($request_settings['channel']) && is_numeric($request_settings['channel'])) {
$query_part['channel'] = "AND (md_campaigns.channel_target=1 OR (c2.targeting_type='channel' AND c2.targeting_code='" . $request_settings['channel'] . "'))";
} else {
$query_part['channel'] = '';
}
$query_part['placement'] = "AND (md_campaigns.publication_target=1 OR (c3.targeting_type='placement' AND c3.targeting_code='" . $zone_detail['entry_id'] . "'))";
$query_part['misc'] = "AND md_campaigns.campaign_status=1 AND md_campaigns.campaign_start<='" . date("Y-m-d") . "' AND md_campaigns.campaign_end>'" . date("Y-m-d") . "'";
switch ($request_settings['main_device']) {
case 'IPHONE':
$query_part['device'] = 'AND (md_campaigns.device_target=1 OR md_campaigns.target_iphone=1)';
break;
case 'IPOD':
$query_part['device'] = 'AND (md_campaigns.device_target=1 OR md_campaigns.target_ipod=1)';
break;
case 'IPAD':
$query_part['device'] = 'AND (md_campaigns.device_target=1 OR md_campaigns.target_ipad=1)';
break;
case 'ANDROID':
$query_part['device'] = 'AND (md_campaigns.device_target=1 OR md_campaigns.target_android=1)';
break;
default:
$query_part['device'] = 'AND (md_campaigns.device_target=1 OR md_campaigns.target_other=1)';
break;
}
if ($request_settings['main_device'] != 'OTHER' && $request_settings['main_device'] != 'NOMOBILE') {
switch ($request_settings['main_device']) {
case 'IPHONE':
case 'IPOD':
case 'IPAD':
if (isset($request_settings['device_os']) && !empty($request_settings['device_os'])) {
$query_part['osversion'] = "AND ((md_campaigns.ios_version_min<=" . $request_settings['device_os'] . " OR md_campaigns.ios_version_min='') AND (md_campaigns.ios_version_max>=" . $request_settings['device_os'] . " OR md_campaigns.ios_version_max=''))";
} else {
$query_part['osversion'] = "AND (md_campaigns.ios_version_min='' AND md_campaigns.ios_version_max='')";
}
break;
case 'ANDROID':
if (isset($request_settings['device_os']) && !empty($request_settings['device_os'])) {
$query_part['osversion'] = "AND ((md_campaigns.android_version_min<=" . $request_settings['device_os'] . " OR md_campaigns.android_version_min='') AND (md_campaigns.android_version_max>=" . $request_settings['device_os'] . " OR md_campaigns.android_version_max=''))";
} else {
$query_part['osversion'] = "AND (md_campaigns.android_version_min='' AND md_campaigns.android_version_max='')";
}
break;
}
} else {
$query_part['osversion'] = "";
}
switch ($zone_detail['zone_type']) {
case 'banner':
$query_part['adunit'] = "AND (md_campaigns.campaign_type='network' OR (md_ad_units.adv_status=1 AND md_ad_units.adv_width<=" . $zone_detail['zone_width'] . " AND md_ad_units.adv_height<=" . $zone_detail['zone_height'] . "))";
break;
case 'interstitial':
if (MAD_INTERSTITIALS_EXACTMATCH) {
$query_part['adunit'] = "AND (md_campaigns.campaign_type='network' OR (md_ad_units.adv_status=1 AND md_ad_units.adv_width=320 AND md_ad_units.adv_height=480))";
} else {
$query_part['adunit'] = "AND (md_campaigns.campaign_type='network' OR (md_ad_units.adv_status=1 AND md_ad_units.adv_width<=320 AND md_ad_units.adv_height<=480))";
}
break;
}
$query_part['limit'] = "AND (md_campaign_limit.total_amount_left='' OR md_campaign_limit.total_amount_left>=1)";
if (MAD_IGNORE_DAILYLIMIT_NOCRON && !check_cron_active()) {
$query_part['limit'] = "AND ((md_campaign_limit.total_amount_left='' OR md_campaign_limit.total_amount_left>=1) OR (md_campaign_limit.cap_type=1))";
}
$request_settings['campaign_query'] = "select md_campaigns.campaign_id, md_campaigns.campaign_priority, md_campaigns.campaign_type, md_campaigns.campaign_networkid from md_campaigns LEFT JOIN md_campaign_targeting c1 ON md_campaigns.campaign_id = c1.campaign_id LEFT JOIN md_campaign_targeting c2 ON md_campaigns.campaign_id = c2.campaign_id LEFT JOIN md_campaign_targeting c3 ON md_campaigns.campaign_id = c3.campaign_id LEFT JOIN md_ad_units ON md_campaigns.campaign_id = md_ad_units.campaign_id LEFT JOIN md_campaign_limit ON md_campaigns.campaign_id = md_campaign_limit.campaign_id where (md_campaigns.country_target=1" . $query_part['geo'] . " " . $query_part['channel'] . " " . $query_part['placement'] . " " . $query_part['misc'] . " " . $query_part['device'] . " " . $query_part['osversion'] . " " . $query_part['adunit'] . " " . $query_part['limit'] . " group by md_campaigns.campaign_id";
return true;
}
<p>We'll help you get up and running with mAdserve in no time!</p>
<div class="progress-bar secondary">
<div class="bar" style="width: <?php
echo get_setup_percentage();
?>
%;"><?php
echo get_setup_percentage();
?>
%</div>
</div>
<ul class="bullet secondary">
<li><a <?php
if (check_cron_active()) {
?>
style="text-decoration:line-through;"<?php
}
?>
target="_blank" href="http://help.madserve.org/cron.php">Set Up Daily Cron Job</a></li>
<li><a <?php
if (check_setup('networks')) {
?>
style="text-decoration:line-through;"<?php
}
?>
href="ad_networks.php">Setup Ad Networks</a></li>
<li><a <?php
if (check_setup('publication')) {
?>
