|
Welcome
to the International Trade / Import -Export Portal, the most content rich
international trade site on the WWW.
Bookmark this page for future reference |
|
||||
The International Trade--Import-Export Portal has won awards and recognition from some of the most distinguished sites on the Internet. Click here to take a look. |
|
||||||
|
|
|
|
$numofbanners=1;
#----------------------------------
#------------- click --------------
#----------------------------------
function func_click() {
global $id;
$query=mysql_query("select click_url, clicks from ba_banner_campaign where banner_id=$id");
if ($query && mysql_num_rows($query)) {
$k=mysql_fetch_row($query);
$click=$k[1]+1;
$update=mysql_query("update ba_banner_campaign set clicks=$click where banner_id=$id");
Header("Location: $k[0]");
}
}
#----------------------------------
#------------- display ------------
#----------------------------------
function func_display() {
global $tpl,$used,$group;
$banner_group_id=$group;
if (!$group) { $group=10; }
$tpl->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();
}
?>
$numofbanners=1;
#----------------------------------
#------------- click --------------
#----------------------------------
function func_click() {
global $id;
$query=mysql_query("select click_url, clicks from ba_banner_campaign where banner_id=$id");
if ($query && mysql_num_rows($query)) {
$k=mysql_fetch_row($query);
$click=$k[1]+1;
$update=mysql_query("update ba_banner_campaign set clicks=$click where banner_id=$id");
Header("Location: $k[0]");
}
}
#----------------------------------
#------------- display ------------
#----------------------------------
function func_display() {
global $tpl,$used,$group;
$banner_group_id=$group;
if (!$group) { $group=10; }
$tpl->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();
}
?>
|
The
Federation of International Trade Associations
|
|
|
Copyright © Federation of International Trade Associations 1999 |
|