📄 banner_view.php
字号:
<?php
session_start();
header("Cache-control: private");
$banner_id = $_POST["banner_id"];
require 'config.php';
if($_SESSION['username'] == $admin_username && $_SESSION['password'] == $admin_password) {
$connection = mysql_connect($DBhost,$DBuser,$DBpass) or die("Couldn't make connection: ". mysql_error());
$db = mysql_select_db("$DBName", $connection) or die("Couldn't select database: ". mysql_error());
if($banner_id != null && $banner_id != "") {
$query = " SELECT banner_name, banner_description, banner_timer, banner_target, banner_uimpressions, banner_uclicks
FROM ad_banners
WHERE id=".$banner_id;
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
if($row = mysql_fetch_array($result)){
$banner_name = $row['banner_name'];
$banner_description = $row['banner_description'];
$seconds = $row['banner_timer'];
$target_window = $row['banner_target'];
$uimpressions = $row['banner_uimpressions'];
$uclicks = $row['banner_uclicks'];
}
}
print '<head>
<title>View Banner</title>
<link href="banner_styles.css" rel="stylesheet" type="text/css">
</head>
<body marginheight="30" topmargin="30">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#ACC366" bgcolor="#2C78C5">
<tr bgcolor="#ACC366">
<td width="872" bgcolor="#ACC366"><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#ACC366">
<tr>
<td><span class="heading style1 style2"><span class="style1 style2">View Banner Ad Group</span></span></td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td><table width="100%" border="1" cellpadding="10" cellspacing="0" bordercolor="#ACC366">
<tr>
<td colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr><form name="banner_form" action="banner_view.php" method="post" onsubmit="return validate();">
<td width="29%"><span class="bodytext">Select banner ad group to view </span></td>
<td width="71%"><span class="bodytext">';
if($banner_id != null && $banner_id != "") {
print '<select size="1" name="banner_id" class="formtext" onChange="submit();">
<option value="'.$banner_id.'">'.$banner_name.'</option>';
} else {
print '<select size="1" name="banner_id" class="formtext" onChange="submit();">
<option value="">Select Banner</option>';
}
$query = " SELECT id, banner_name
FROM ad_banners
ORDER BY banner_name";
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
while($row = mysql_fetch_array($result)){
$bannerID = $row['id'];
$bannerName = $row['banner_name'];
print '<option value="'.$bannerID.'">'.$bannerName.'</option>';
}
print '</span></td></form>
</tr>
</table>
</td>
</tr>';
if($banner_name != null && $banner_name != "") {
print '<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Group Name</span></td>
<td><span class="style1"><span class="bodytext">'.$banner_name.'
</span></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Group Description</span></td>
<td><span class="style1"><span class="bodytext">'.$banner_description.'
</span></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Seconds Per Ad </span></td>
<td><span class="style1"><span class="bodytext">'.$seconds.'
</span></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">URL Target Window</span></td>
<td><span class="style1"><span class="bodytext">'.$target_window.'
</span></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Unique Impressions</span></td>
<td><span class="style1"><span class="bodytext">'.$uimpressions.' </span>
</span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Unique Clicks </span></td>
<td><span class="style1"><span class="bodytext">'.$uclicks.' </span>
</span></td>
</tr>
<tr bgcolor="#2C78C5">
<td colspan="2"><br>
<form action="banner_edit.php" method="post">
<div align="center">
<input type="hidden" name="banner_id" value="'.$banner_id.'">
<input type="submit" name="Submit" value="Edit banner group" class="buttontext">
</div>
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br>';
} else {
print '</table></td>
</tr>
</table>';
}
if($banner_id != "") {
$campaignQuery = " SELECT ad_campaigns.id, ad_campaigns.name, ad_companies.company_name,
startdate, enddate, filename, link, weight
FROM ad_campaigns, ad_banners, ad_companies, ad_images
WHERE ad_campaigns.company_id = ad_companies.id
AND ad_campaigns.banner_id = ad_banners.id
AND ad_images.campaign_id = ad_campaigns.id
AND ad_campaigns.active = 'Y'
AND ad_banners.id = ".$banner_id;
$result = mysql_query($campaignQuery,$connection) or die("Couldn't execute query: ". mysql_error());
while($row = mysql_fetch_array($result)){
$campaign_id = $row['id'];
$campaign_name = $row['name'];
$company_name = $row['company_name'];
$startdate = $row['startdate'];
$enddate = $row['enddate'];
$imgFilename = $row['filename'];
$link = $row['link'];
$weight = $row['weight'];
$isSWF = false;
if(strpos($imgFilename, ".swf") > 0) {
$isSWF = true;
}
$path1 = $imgPath."/".$imgFilename;
print '<br><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#ACC366" bgcolor="#2C78C5">
<tr bgcolor="#ACC366">
<td width="872" bgcolor="#ACC366"><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#ACC366">
<tr>
<td><span class="heading">Current Banner (ID: '.$campaign_id.')</span</td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td><table width="100%" border="1" cellpadding="10" cellspacing="0" bordercolor="#ACC366">
<tr>
<td width="116"><span class="bodytext">Banner Name</span></td>
<td width="304"><span class="bodytext">'.$campaign_name.'</span></td>
<td width="94"><span class="bodytext">Advertiser</span></td>
<td width="327"><span class="bodytext">'.$company_name.'</span></td>
</tr>
<tr>
<td width="116"><span class="bodytext">Start Date</span></td>
<td><span class="bodytext">'.$startdate.'</span></td>
<td><span class="bodytext">End Date</span></td>
<td><span class="bodytext">'.$enddate.'</span></td>
</tr>
<tr>
<td width="116"><SPAN class=bodytext><span class="bodytext">Link</span></SPAN></td>
<td><span class="bodytext">'.$link.'</span></SPAN></td>
<td width="94"><SPAN class=bodytext><span class="bodytext">Weight</span></SPAN></td>
<td><span class="bodytext">'.$weight.'</span></SPAN></td>
</tr>
<tr>
<td colspan="4" align="center"><p>';
if($isSWF) {
$rndCache = rand();
print '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="300" height="100" id="bannerSWF" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="'.$path1.'?'.$rndCache.'" />
<param name="quality" value="high" />
<param name="bgcolor" value="#2C78C5" />
<embed src="'.$path1.'?'.$rndCache.'" quality="high" bgcolor="#2C78C5" width="300" height="100" name="bannerSWF" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>';
} else {
print '<img src="'.$path1.'">';
}
print '</p></td>
</tr>
<tr>
<td colspan="4"><br>
<form action="campaign_edit2.php?campaign_id='.$campaign_id.'" method="post">
<div align="center">
<input type="submit" name="Submit" value="Edit banner" class="buttontext">
</div>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table><br>';
}
$campaignQuery = " SELECT ad_campaigns.id, ad_campaigns.name, ad_companies.company_name,
startdate, enddate, filename, link
FROM ad_campaigns, ad_banners, ad_companies, ad_images
WHERE ad_campaigns.company_id = ad_companies.id
AND ad_campaigns.banner_id = ad_banners.id
AND ad_images.campaign_id = ad_campaigns.id
AND ad_campaigns.active = 'N'
AND ad_banners.id = ".$banner_id;
$result = mysql_query($campaignQuery,$connection) or die("Couldn't execute query: ". mysql_error());
while($row = mysql_fetch_array($result)){
$campaign_id = $row['id'];
$campaign_name = $row['name'];
$company_name = $row['company_name'];
$startdate = $row['startdate'];
$enddate = $row['enddate'];
$imgFilename = $row['filename'];
$link = $row['link'];
$isSWF = false;
if(strpos($imgFilename, ".swf") > 0) {
$isSWF = true;
}
$path1 = $imgPath."/".$imgFilename;
print '<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#ACC366" bgcolor="#2C78C5">
<tr bgcolor="#ACC366">
<td width="872" bgcolor="#ACC366"><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#ACC366">
<tr>
<td><span class="heading">Inactive Banner</span></td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#ACC366">
<tr>
<td width="116"><span class="bodytext">Banner Name</span></td>
<td width="304"><span class="bodytext">'.$campaign_name.'</span></td>
<td width="94"><span class="bodytext">Advertiser</span></td>
<td width="327"><span class="bodytext">'.$company_name.'</span></td>
</tr>
<tr>
<td width="116"><span class="bodytext">Start Date</span></td>
<td><span class="bodytext">'.$startdate.'</span></td>
<td><span class="bodytext">End Date</span></td>
<td><span class="bodytext">'.$enddate.'</span></td>
</tr>
<tr>
<td width="116"><span class="bodytext">Link</span></td>
<td><span class="bodytext">'.$link.'</span></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="4" align="center"><p>';
if($isSWF) {
$rndCache = rand();
print '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="300" height="100" id="bannerSWF" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="'.$path1.'?'.$rndCache.'" />
<param name="quality" value="high" />
<param name="bgcolor" value="#ffffff" />
<embed src="'.$path1.'?'.$rndCache.'" quality="high" bgcolor="#ffffff" name="bannerSWF" width="300" height="100" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>';
} else {
print '<img src="'.$path1.'">';
}
print '</p></td>
</tr>
<tr>
<td colspan="4">
<form action="campaign_edit2.php?campaign_id='.$campaign_id.'" method="post">
<div align="center">
<input type="submit" name="Submit" value="Edit banner" class="buttontext">
</div>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table><br>';
}
}
mysql_close($connection);
} else {
print "Session has expired. Please log in again";
}
print '</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -