function getPreviewBlock($iBannerID)
{
$sPreview = MsgBox(_t('_Empty'));
if ($_GET['action'] == 'preview' && $iBannerID > 0) {
$aBannerInfo = db_arr("SELECT * FROM `sys_banners` WHERE `ID` = '{$iBannerID}'");
$sBannerTitle = process_line_output($aBannerInfo['Title']);
$sBannerPut = banner_put($aBannerInfo['ID'], 0);
$sPreview = <<<EOF
<table cellspacing=1 cellpadding=1 width=90% height=200 align=center style="border: 1px solid #ccc;">
\t{$sBannerTitle}
\t<tr><td align=center bgcolor=white>{$sBannerPut}</td></tr>
</table>
EOF;
$sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('design_box_content.html', array('content' => $sPreview));
return DesignBoxContent(_t('_Preview'), $sResult, 1);
}
}
if (!$demo_mode && (int) $_GET['banner_id'] && $_GET['action'] == "delete") {
$banner_id = (int) $_GET['banner_id'];
db_res("DELETE FROM `Banners` WHERE ID = {$banner_id}");
}
// Get banner info from database.
$q_str = "SELECT * FROM `Banners` ORDER BY `ID` DESC";
$banners_res = db_res($q_str);
$_page['header'] = "Banners";
$_page['header_text'] = "Manage banners";
TopCodeAdmin();
ContentBlockHead("Preview:");
if ($_GET['action'] == 'preview' && $_GET['banner_id']) {
$bann_arr = db_arr("SELECT * FROM `Banners` WHERE `ID` = {$_GET['banner_id']}");
echo "<br><table cellspacing=1 cellpadding=1 width=90% height=200 align=center style=\"border: 1px solid #cccccc\">\n";
echo process_line_output($bann_arr['Title']);
echo "<tr><td align=center bgcolor=white>" . banner_put($bann_arr['ID'], 0) . "</td></tr>";
echo "</table><br>\n";
}
ContentBlockFoot();
ContentBlockHead("Banners");
if (!mysql_num_rows($banners_res)) {
echo "<center>No banners available.</center>";
} else {
echo "<table cellspacing=1 cellpadding=2 border=0 class=small1 width=100%>\n";
while ($banns_arr = mysql_fetch_array($banners_res)) {
$imp = db_arr("SELECT COUNT(*) FROM `BannersShows` WHERE `ID` = {$banns_arr['ID']}");
$clicks = db_arr("SELECT COUNT(*) FROM `BannersClicks` WHERE `ID` = {$banns_arr['ID']}");
if (!$banns_arr['Active']) {
$class = 'table_err';
} else {
$class = 'panel';
