📄 banners.php
字号:
{
global $xoopsConfig, $xoopsModule;
$xoopsDB =& Database::getInstance();
if ( $ok == 1 ) {
$sql = sprintf("DELETE FROM %s WHERE bid = %u", $xoopsDB->prefix("banner"), $bid);
$xoopsDB->query($sql);
redirect_header("admin.php?fct=banners&op=BannersAdmin#top",1,_AM_DBUPDATED);
exit();
} else {
$myts =& MyTextSanitizer::getInstance();
xoops_cp_header();
$result=$xoopsDB->query("SELECT cid, imptotal, impmade, clicks, imageurl, clickurl, htmlbanner, htmlcode FROM ".$xoopsDB->prefix("banner")." where bid=$bid");
list($cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $htmlbanner, $htmlcode) = $xoopsDB->fetchRow($result);
echo"<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
echo "<h4>"._AM_DELEBNR."</h4>";
if ($htmlbanner){
echo $myts->displayTarea($htmlcode,1);
}else{
if(strtolower(substr($imageurl,strrpos($imageurl,".")))==".swf") {
echo "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/ swflash.cab#version=6,0,40,0\"; width=\"468\" height=\"60\">";
echo "<param name=movie value=\"$imageurl\">";
echo "<param name=quality value=high>";
echo "<embed src=\"$imageurl\" quality=high pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\"; type=\"application/x-shockwave-flash\" width=\"468\" height=\"60\">";
echo "</embed>";
echo "</object>";
} else {
echo "<img src='$imageurl' alt='' />";
}
}
echo "<a href='$clickurl'>$clickurl</a><br /><br />
<table width='100%' border='0'><tr align='center'>
<td align='center'>"._AM_BANNERID."</td>
<td align='center'>"._AM_IMPRESION."</td>
<td align='center'>"._AM_IMPLEFT."</td>
<td align='center'>"._AM_CLICKS."</td>
<td align='center'>"._AM_NCLICKS."</td>
<td align='center'>"._AM_CLINAME."</td></tr><tr align='center'>";
$result2 = $xoopsDB->query("SELECT cid, name FROM ".$xoopsDB->prefix("bannerclient")." WHERE cid=$cid");
list($cid, $name) = $xoopsDB->fetchRow($result2);
$name = $myts->makeTboxData4Show($name);
$percent = substr(100 * $clicks / $impmade, 0, 5);
if ( $imptotal == 0 ) {
$left = 'unlimited';
} else {
$left = $imptotal-$impmade;
}
echo "
<td align='center'>$bid</td>
<td align='center'>$impmade</td>
<td align='center'>$left</td>
<td align='center'>$clicks</td>
<td align='center'>$percent%</td>
<td align='center'>$name</td>
</tr></table><br />";
xoops_confirm(array('fct' => 'banners', 'op' => 'BannerDelete', 'bid' => $bid, 'ok' => 1), 'admin.php', _AM_SUREDELE);
echo"</td></tr></table>";
xoops_cp_footer();
}
}
function BannerEdit($bid)
{
global $xoopsConfig, $xoopsModule;
xoops_cp_header();
$xoopsDB =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$result=$xoopsDB->query("SELECT cid, imptotal, impmade, clicks, imageurl, clickurl, htmlbanner, htmlcode FROM ".$xoopsDB->prefix("banner")." where bid=$bid");
list($cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $htmlbanner, $htmlcode) = $xoopsDB->fetchRow($result);
echo"<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
//echo"<h4>"._AM_EDITBNR."</h4>
//<img src='$imageurl' border='1' /><br /><br />
//<form action='admin.php' method='post'>
echo"<h4>"._AM_EDITBNR."</h4>";
if ($htmlbanner){
echo $myts->displayTarea($htmlcode,0);
}else{
if(strtolower(substr($imageurl,strrpos($imageurl,".")))==".swf") {
echo "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/ swflash.cab#version=6,0,40,0\"; width=\"468\" height=\"60\">";
echo "<param name=movie value=\"$imageurl\">";
echo "<param name=quality value=high>";
echo "<embed src=\"$imageurl\" quality=high pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\"; type=\"application/x-shockwave-flash\" width=\"468\" height=\"60\">";
echo "</embed>";
echo "</object>";
} else {
echo "<img src='$imageurl' alt='' />";
}
}
echo "<form action='admin.php' method='post'>
"._AM_CLINAMET."
<select name='cid'>\n";
$result = $xoopsDB->query("SELECT cid, name FROM ".$xoopsDB->prefix("bannerclient")." where cid=$cid");
list($cid, $name) = $xoopsDB->fetchRow($result);
$name = $myts->makeTboxData4Show($name);
echo "<option value='$cid' selected='selected'>$name</option>";
$result = $xoopsDB->query("SELECT cid, name FROM ".$xoopsDB->prefix("bannerclient"));
while(list($ccid, $name) = $xoopsDB->fetchRow($result)) {
$name = $myts->makeTboxData4Show($name);
if ( $cid != $ccid ) {
echo "<option value='$ccid'>$name</option>";
}
}
echo "</select><br />";
if ( $imptotal == 0 ) {
$impressions = ""._AM_UNLIMIT."";
} else {
$impressions = $imptotal;
}
echo "
"._AM_ADDIMPT."<input type='text' name='impadded' size='12' maxlength='11' /> "._AM_PURCHT."<b>$impressions</b> "._AM_MADET."<b>$impmade</b><br />
"._AM_IMGURLT."<input type='text' name='imageurl' size='50' maxlength='200' value=\"$imageurl\"><br />
"._AM_CLICKURLT."<input type='text' name='clickurl' size='50' maxlength='200' value='$clickurl' /><br />
"._AM_USEHTML;
if ($htmlbanner){
echo " <input type='checkbox' name='htmlbanner' value='1' checked>";
}else{
echo " <input type='checkbox' name='htmlbanner' value='1'>";
}
echo "
<br />
"._AM_CODEHTML."
<br />
<textarea name='htmlcode' rows='6'>".$myts->makeTboxData4Edit($htmlcode)."</textarea>
<br />
<input type='hidden' name='bid' value='$bid' />
<input type='hidden' name='imptotal' value='$imptotal' />
<input type='hidden' name='fct' value='banners' />
<input type='hidden' name='op' value='BannerChange' />
<input type='submit' value='"._AM_CHGBNR."' />
</form>";
echo"</td></tr></table>";
xoops_cp_footer();
}
function BannerChange($bid, $cid, $imptotal, $impadded, $imageurl, $clickurl, $htmlbanner, $htmlcode )
{
global $xoopsDB;
$imp = $imptotal+$impadded;
$xoopsDB->query("UPDATE ".$xoopsDB->prefix("banner")." SET cid=$cid, imptotal=$imp, imageurl='$imageurl', clickurl='$clickurl', htmlbanner='$htmlbanner', htmlcode='$htmlcode' WHERE bid=$bid");
redirect_header("admin.php?fct=banners&op=BannersAdmin#top",1,_AM_DBUPDATED);
exit();
}
function BannerClientDelete($cid, $ok=0)
{
global $xoopsConfig, $xoopsModule;
$xoopsDB =& Database::getInstance();
if ( $ok == 1 ) {
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix("banner"), $cid);
$xoopsDB->query($sql);
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix("bannerclient"), $cid);
$xoopsDB->query($sql);
redirect_header("admin.php?fct=banners&op=BannersAdmin#top",1,_AM_DBUPDATED);
exit();
} else {
$myts =& MyTextSanitizer::getInstance();
xoops_cp_header();
$result = $xoopsDB->query("SELECT cid, name FROM ".$xoopsDB->prefix("bannerclient")." WHERE cid=$cid");
list($cid, $name) = $xoopsDB->fetchRow($result);
$name = $myts->makeTboxData4Show($name);
echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
echo "
<h4>"._AM_DELEADC."</h4>
".sprintf(_AM_SUREDELCLI,$name)."<br /><br />";
$result2 = $xoopsDB->query("SELECT imageurl, clickurl, htmlbanner, htmlcode FROM ".$xoopsDB->prefix("banner")." WHERE cid=$cid");
$numrows = $xoopsDB->getRowsNum($result2);
if ( $numrows == 0 ) {
echo ""._AM_NOBNRRUN."<br /><br />";
} else {
echo "<font color='#ff0000'><b>"._AM_WARNING."</b></font><br />
"._AM_ACTBNRRUN."<br /><br />";
}
while(list($imageurl, $clickurl, $htmlbanner, $htmlcode) = $xoopsDB->fetchRow($result2)) {
$bannerobject = "";
if ($htmlbanner){
$bannerobject = $myts->displayTarea($htmlcode,1);
}else{
$bannerobject = '<div><a href="'.$clickurl.'" target="_blank">';
if(strtolower(substr($imageurl,strrpos($imageurl,".")))==".swf") {
$bannerobject = $bannerobject
.'<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" width="468" height="60">'
.'<param name=movie value="'.$imageurl.'">'
.'<param name=quality value=high>'
.'<embed src="'.$imageurl.'" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"; type="application/x-shockwave-flash" width="468" height="60">'
.'</embed>'
.'</object>';
} else {
$bannerobject = $bannerobject.'<img src="'.$imageurl.'" alt="" />';
}
$bannerobject = $bannerobject.'</a></div>';
}
echo $bannerobject."
<a href='$clickurl'>$clickurl</a><br /><br />";
}
}
xoops_confirm(array('fct' => 'banners', 'op' => 'BannerClientDelete', 'cid' => $cid, 'ok' => 1), 'admin.php', _AM_SUREDELBNR);
echo "</td></tr></table>";
xoops_cp_footer();
}
function BannerClientEdit($cid)
{
global $xoopsConfig, $xoopsModule;
$xoopsDB =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
xoops_cp_header();
$result = $xoopsDB->query("SELECT name, contact, email, login, passwd, extrainfo FROM ".$xoopsDB->prefix("bannerclient")." WHERE cid=$cid");
list($name, $contact, $email, $login, $passwd, $extrainfo) = $xoopsDB->fetchRow($result);
$name = $myts->makeTboxData4Edit($name);
$contact = $myts->makeTboxData4Show($contact);
$extrainfo = $myts->makeTareaData4Show($extrainfo);
echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
echo "
<h4>"._AM_EDITADVCLI."</h4>
<form action='admin.php' method='post'>
"._AM_CLINAMET."<input type='text' name='name' value='$name' size='30' maxlength='60' /><br />
"._AM_CONTNAMET."<input type='text' name='contact' value='$contact' size='30' maxlength='60' /><br />
"._AM_CONTMAILT ."<input type='text' name='email' size='30' maxlength='60' value='$email' /><br />
"._AM_CLILOGINT."<input type='text' name='login' size='12' maxlength='10' value='$login' /><br />
"._AM_CLIPASST."<input type='text' name='passwd' size='12' maxlength='10' value='$passwd' /><br />
"._AM_EXTINFO."<br /><textarea name='extrainfo' cols='60' rows='10' />$extrainfo</textarea><br />
<input type='hidden' name='cid' value='$cid' />
<input type='hidden' name='op' value='BannerClientChange' />
<input type='hidden' name='fct' value='banners' />
<input type='submit' value='"._AM_CHGCLI."' />";
echo "</td></tr></table>";
xoops_cp_footer();
}
function BannerClientChange($cid, $name, $contact, $email, $extrainfo, $login, $passwd)
{
$xoopsDB =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$name = $myts->makeTboxData4Save($name);
$contact = $myts->makeTboxData4Save($contact);
$extrainfo = $myts->makeTareaData4Save($extrainfo);
$xoopsDB->query("UPDATE ".$xoopsDB->prefix("bannerclient")." SET name='$name', contact='$contact', email='$email', login='$login', passwd='$passwd', extrainfo='$extrainfo' where cid=$cid");
redirect_header("admin.php?fct=banners&op=BannersAdmin#top",1,_AM_DBUPDATED);
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -