|
|
| define(array(main => "banner.tpl"));
$sql = "UPDATE ba_banner_campaign SET active = 0 WHERE campaign_end_date < curdate() ";
mysql_query($sql);
$sql = "SELECT banner_id FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$ba_last_banner = mysql_result($result,0,0);
} else {
$ba_last_banner = 0;
}
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.banner_id > $ba_last_banner
AND A.maximum_exposures >= A.exposure_count
AND A.campaign_start_date <= curdate()
AND A.active = 1 ORDER BY A.banner_id";
$result = mysql_query($sql);
if (!$result || mysql_num_rows($result)==0) {
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.campaign_start_date <= curdate()
AND A.maximum_exposures >= A.exposure_count
AND A.active = 1 ORDER BY A.banner_id";
$result=mysql_query($sql);
}
if (!$result || !mysql_num_rows($result)) {
if ($group != 10) {
$group=10;
func_display();
}
exit;
}
$l = mysql_fetch_array($result);
$tpl->assign(array(ID => "$l[banner_id]",
TEXT => "$l[text_below_banner]",
SRC => "$l[url_to_banner_image]"));
mysql_query("update ba_banner_campaign set exposure_count = exposure_count + 1
where banner_id = $l[banner_id]");
$sql = "DELETE FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
mysql_query($sql);
$sql = "INSERT INTO ba_last_banner VALUES ($l[banner_id], $banner_group_id)";
mysql_query($sql);
$tpl->parse(MAIN,main);
$tpl->FastPrint();
}
include "class.FastTemplate.php3";
include "auth.php3";
$tpl=new FastTemplate("./templates");
if ($action) {
eval("func_${action}();");
} else {
func_display();
}
?> |
| define(array(main => "banner.tpl"));
$sql = "UPDATE ba_banner_campaign SET active = 0 WHERE campaign_end_date < curdate() ";
mysql_query($sql);
$sql = "SELECT banner_id FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$ba_last_banner = mysql_result($result,0,0);
} else {
$ba_last_banner = 0;
}
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.banner_id > $ba_last_banner
AND A.maximum_exposures >= A.exposure_count
AND A.campaign_start_date <= curdate()
AND A.active = 1 ORDER BY A.banner_id";
$result = mysql_query($sql);
if (!$result || mysql_num_rows($result)==0) {
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.campaign_start_date <= curdate()
AND A.maximum_exposures >= A.exposure_count
AND A.active = 1 ORDER BY A.banner_id";
$result=mysql_query($sql);
}
if (!$result || !mysql_num_rows($result)) {
if ($group != 10) {
$group=10;
func_display();
}
exit;
}
$l = mysql_fetch_array($result);
$tpl->assign(array(ID => "$l[banner_id]",
TEXT => "$l[text_below_banner]",
SRC => "$l[url_to_banner_image]"));
mysql_query("update ba_banner_campaign set exposure_count = exposure_count + 1
where banner_id = $l[banner_id]");
$sql = "DELETE FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
mysql_query($sql);
$sql = "INSERT INTO ba_last_banner VALUES ($l[banner_id], $banner_group_id)";
mysql_query($sql);
$tpl->parse(MAIN,main);
$tpl->FastPrint();
}
include "class.FastTemplate.php3";
include "auth.php3";
$tpl=new FastTemplate("./templates");
if ($action) {
eval("func_${action}();");
} else {
func_display();
}
?> |
| define(array(main => "banner.tpl"));
$sql = "UPDATE ba_banner_campaign SET active = 0 WHERE campaign_end_date < curdate() ";
mysql_query($sql);
$sql = "SELECT banner_id FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$ba_last_banner = mysql_result($result,0,0);
} else {
$ba_last_banner = 0;
}
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.banner_id > $ba_last_banner
AND A.maximum_exposures >= A.exposure_count
AND A.campaign_start_date <= curdate()
AND A.active = 1 ORDER BY A.banner_id";
$result = mysql_query($sql);
if (!$result || mysql_num_rows($result)==0) {
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.campaign_start_date <= curdate()
AND A.maximum_exposures >= A.exposure_count
AND A.active = 1 ORDER BY A.banner_id";
$result=mysql_query($sql);
}
if (!$result || !mysql_num_rows($result)) {
if ($group != 10) {
$group=10;
func_display();
}
exit;
}
$l = mysql_fetch_array($result);
$tpl->assign(array(ID => "$l[banner_id]",
TEXT => "$l[text_below_banner]",
SRC => "$l[url_to_banner_image]"));
mysql_query("update ba_banner_campaign set exposure_count = exposure_count + 1
where banner_id = $l[banner_id]");
$sql = "DELETE FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
mysql_query($sql);
$sql = "INSERT INTO ba_last_banner VALUES ($l[banner_id], $banner_group_id)";
mysql_query($sql);
$tpl->parse(MAIN,main);
$tpl->FastPrint();
}
include "class.FastTemplate.php3";
include "auth.php3";
$tpl=new FastTemplate("./templates");
if ($action) {
eval("func_${action}();");
} else {
func_display();
}
?> |
| define(array(main => "banner.tpl"));
$sql = "UPDATE ba_banner_campaign SET active = 0 WHERE campaign_end_date < curdate() ";
mysql_query($sql);
$sql = "SELECT banner_id FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$ba_last_banner = mysql_result($result,0,0);
} else {
$ba_last_banner = 0;
}
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.banner_id > $ba_last_banner
AND A.maximum_exposures >= A.exposure_count
AND A.campaign_start_date <= curdate()
AND A.active = 1 ORDER BY A.banner_id";
$result = mysql_query($sql);
if (!$result || mysql_num_rows($result)==0) {
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.campaign_start_date <= curdate()
AND A.maximum_exposures >= A.exposure_count
AND A.active = 1 ORDER BY A.banner_id";
$result=mysql_query($sql);
}
if (!$result || !mysql_num_rows($result)) {
if ($group != 10) {
$group=10;
func_display();
}
exit;
}
$l = mysql_fetch_array($result);
$tpl->assign(array(ID => "$l[banner_id]",
TEXT => "$l[text_below_banner]",
SRC => "$l[url_to_banner_image]"));
mysql_query("update ba_banner_campaign set exposure_count = exposure_count + 1
where banner_id = $l[banner_id]");
$sql = "DELETE FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
mysql_query($sql);
$sql = "INSERT INTO ba_last_banner VALUES ($l[banner_id], $banner_group_id)";
mysql_query($sql);
$tpl->parse(MAIN,main);
$tpl->FastPrint();
}
include "class.FastTemplate.php3";
include "auth.php3";
$tpl=new FastTemplate("./templates");
if ($action) {
eval("func_${action}();");
} else {
func_display();
}
?> |
| define(array(main => "banner.tpl"));
$sql = "UPDATE ba_banner_campaign SET active = 0 WHERE campaign_end_date < curdate() ";
mysql_query($sql);
$sql = "SELECT banner_id FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$ba_last_banner = mysql_result($result,0,0);
} else {
$ba_last_banner = 0;
}
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.banner_id > $ba_last_banner
AND A.maximum_exposures >= A.exposure_count
AND A.campaign_start_date <= curdate()
AND A.active = 1 ORDER BY A.banner_id";
$result = mysql_query($sql);
if (!$result || mysql_num_rows($result)==0) {
$sql = "SELECT A.banner_id, A.url_to_banner_image, A.click_url, A.exposure_count, A.text_below_banner
FROM ba_banner_campaign A, ba_banner_campaign_group B
WHERE A.banner_id = B.banner_id
AND B.banner_group_id = $banner_group_id
AND A.campaign_start_date <= curdate()
AND A.maximum_exposures >= A.exposure_count
AND A.active = 1 ORDER BY A.banner_id";
$result=mysql_query($sql);
}
if (!$result || !mysql_num_rows($result)) {
if ($group != 10) {
$group=10;
func_display();
}
exit;
}
$l = mysql_fetch_array($result);
$tpl->assign(array(ID => "$l[banner_id]",
TEXT => "$l[text_below_banner]",
SRC => "$l[url_to_banner_image]"));
mysql_query("update ba_banner_campaign set exposure_count = exposure_count + 1
where banner_id = $l[banner_id]");
$sql = "DELETE FROM ba_last_banner WHERE banner_group_id = $banner_group_id";
mysql_query($sql);
$sql = "INSERT INTO ba_last_banner VALUES ($l[banner_id], $banner_group_id)";
mysql_query($sql);
$tpl->parse(MAIN,main);
$tpl->FastPrint();
}
include "class.FastTemplate.php3";
include "auth.php3";
$tpl=new FastTemplate("./templates");
if ($action) {
eval("func_${action}();");
} else {
func_display();
}
?> |
|
|
|
