📄 banners.php

📁 在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php
// $Id: banners.php,v 1.11 2004/12/26 19:12:03 onokazu Exp $
//  ------------------------------------------------------------------------ //
//                XOOPS - PHP Content Management System                      //
//                    Copyright (c) 2000 XOOPS.org                           //
//                       <http://www.xoops.org/>                             //
//  ------------------------------------------------------------------------ //
//  This program is free software; you can redistribute it and/or modify     //
//  it under the terms of the GNU General Public License as published by     //
//  the Free Software Foundation; either version 2 of the License, or        //
//  (at your option) any later version.                                      //
//                                                                           //
//  You may not change or alter any portion of this comment or credits       //
//  of supporting developers from this source code or any supporting         //
//  source code which is considered copyrighted (c) material of the          //
//  original comment or credit authors.                                      //
//                                                                           //
//  This program is distributed in the hope that it will be useful,          //
//  but WITHOUT ANY WARRANTY; without even the implied warranty of           //
//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            //
//  GNU General Public License for more details.                             //
//                                                                           //
//  You should have received a copy of the GNU General Public License        //
//  along with this program; if not, write to the Free Software              //
//  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA //
//  ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu)                                          //
// URL: http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/ //
// Project: The XOOPS Project                                                //
// ------------------------------------------------------------------------- //

if (!is_object($xoopsUser) || !is_object($xoopsModule) || !$xoopsUser->isAdmin($xoopsModule->mid()) ) {
	exit("Access Denied");
} else {
/*********************************************************/
/* Banners Administration Functions                      */
/*********************************************************/
function BannersAdmin()
{
    global $xoopsConfig, $xoopsModule;
	$xoopsDB =& Database::getInstance();
	xoops_cp_header();
	// Banners List
	echo "<a name='top'></a>";
	echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
	echo "<div style='text-align:center'><b>"._AM_CURACTBNR."</b></div><br />
	<table width='100%' border='0'><tr>
	<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>
	<td align='center'>"._AM_FUNCTION."</td></tr><tr align='center'>";
	$result = $xoopsDB->query("SELECT bid, cid, imptotal, impmade, clicks, date FROM ".$xoopsDB->prefix("banner")." ORDER BY bid");
	$myts =& MyTextSanitizer::getInstance();
	while(list($bid, $cid, $imptotal, $impmade, $clicks, $date) = $xoopsDB->fetchRow($result)) {
		$result2 = $xoopsDB->query("SELECT cid, name FROM ".$xoopsDB->prefix("bannerclient")." WHERE cid=$cid");
	    list($cid, $name) = $xoopsDB->fetchRow($result2);
		$name = $myts->makeTboxData4Show($name);
	    if ( $impmade == 0 ) {
			$percent = 0;
	    } else {
			$percent = substr(100 * $clicks / $impmade, 0, 5);
	    }
	    if ( $imptotal == 0 ) {
			$left = ""._AM_UNLIMIT."";
	    } 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>
	    <td align='center'><a href='admin.php?fct=banners&amp;op=BannerEdit&amp;bid=$bid'>"._AM_EDIT."</a> | <a href='admin.php?fct=banners&amp;op=BannerDelete&amp;bid=$bid&amp;ok=0'>"._AM_DELETE."</a></td><tr>";
	}
	echo "</td></tr></table>";
	echo "</td></tr></table>";
	echo "<br />";
	// Finished Banners List
	echo "<a name='top'></a>";
	echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
	echo "<div style='text-align:center'><b>"._AM_FINISHBNR."</b></div><br />
	<table width='100%' border='0'><tr>
	<td align='center'>"._AM_BANNERID."</td>
	<td align='center'>"._AM_IMPD."</td>
	<td align='center'>"._AM_CLICKS."</td>
	<td align='center'>"._AM_NCLICKS."</td>
	<td align='center'>"._AM_STARTDATE."</td>
	<td align='center'>"._AM_ENDDATE."</td>
	<td align='center'>"._AM_CLINAME."</td>
	<td align='center'>"._AM_FUNCTION."</td></tr>
	<tr>";
	$result = $xoopsDB->query("SELECT bid, cid, impressions, clicks, datestart, dateend FROM ".$xoopsDB->prefix("bannerfinish")." ORDER BY bid");
	while(list($bid, $cid, $impressions, $clicks, $datestart, $dateend) = $xoopsDB->fetchRow($result)) {
		$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 / $impressions, 0, 5);
	    echo "
	    <td align='center'>$bid</td>
	    <td align='center'>$impressions</td>
	    <td align='center'>$clicks</td>
	    <td align='center'>$percent%</td>
	    <td align='center'>".formatTimestamp($datestart,"m")."</td>
	    <td align='center'>".formatTimestamp($dateend,"m")."</td>
	    <td align='center'>$name</td>
	    <td align='center'><a href='admin.php?fct=banners&amp;op=BannerFinishDelete&amp;bid=$bid'>"._AM_DELETE."</a></td><tr>";
	}
	echo "</td></tr></table>";
	echo "</td></tr></table>";
	echo "<br />";
	// Clients List
	echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
	echo "
	<div style='text-align:center'><b>"._AM_ADVCLI."</b></div><br />
	<table width='100%' border='0'><tr align='center'>
	<td align='center'>"._AM_BANNERID."</td>
	<td align='center'>"._AM_CLINAME."</td>
	<td align='center'>"._AM_ACTIVEBNR."</td>
	<td align='center'>"._AM_CONTNAME."</td>
	<td align='center'>"._AM_CONTMAIL."</td>
	<td align='center'>"._AM_FUNCTION."</td></tr><tr align='center'>";
	$result = $xoopsDB->query("SELECT cid, name, contact, email FROM ".$xoopsDB->prefix("bannerclient")." ORDER BY cid");
	while(list($cid, $name, $contact, $email) = $xoopsDB->fetchRow($result)) {
		$name = $myts->makeTboxData4Show($name);
		$contact = $myts->makeTboxData4Show($contact);
	    $result2 = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("banner")." WHERE cid=$cid");
	    list($numrows) = $xoopsDB->fetchRow($result2);
	    echo "
	    <td align='center'>$cid</td>
	    <td align='center'>$name</td>
	    <td align='center'>$numrows</td>
	    <td align='center'>$contact</td>
	    <td align='center'>$email</td>
	    <td align='center'><a href='admin.php?fct=banners&amp;op=BannerClientEdit&amp;cid=$cid'>"._AM_EDIT."</a> | <a href='admin.php?fct=banners&amp;op=BannerClientDelete&amp;cid=$cid'>"._AM_DELETE."</a></td><tr>";
	}
	echo "</td></tr></table>";
	echo "</td></tr></table>";
	echo "<br />";
	// Add Banner
    $result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("bannerclient"));
    list($numrows) = $xoopsDB->fetchRow($result);
    	if ( $numrows > 0 ) {
			echo"<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
			echo"
			<h4>"._AM_ADDNWBNR."</h4>
			<form action='admin.php' method='post'>
			"._AM_CLINAMET."
			<select name='cid'>";
			$result = $xoopsDB->query("SELECT cid, name FROM ".$xoopsDB->prefix("bannerclient"));
			while(list($cid, $name) = $xoopsDB->fetchRow($result)) {
				$name = $myts->makeTboxData4Show($name);
	    		echo "<option value='$cid'>$name</option>";

			}
			echo "
			</select><br />
			"._AM_IMPPURCHT."<input type='text' name='imptotal' size='12' maxlength='11' /> 0 = "._AM_UNLIMIT."<br />
			"._AM_IMGURLT."<input type='text' name='imageurl' size='50' maxlength='255' /><br />
			"._AM_CLICKURLT."<input type='text' name='clickurl' size='50' maxlength='255' /><br />
			"._AM_USEHTML." <input type='checkbox' name='htmlbanner' value='1'>
			<br />
			"._AM_CODEHTML."
			<br />
			<textarea name='htmlcode' rows='6'>$htmlcode</textarea>
			<br />
			<input type='hidden' name='fct' value='banners' />
			<input type='hidden' name='op' value='BannersAdd' />
			<input type='submit' value='"._AM_ADDBNR."' />
			</form>";
			echo"</td></tr></table>";
    	}
	// Add Client
	echo "<br />";
	echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"odd\">";
	echo "
	<h4>"._AM_ADDNWCLI."</h4>
	<form action='admin.php' method='post'>
	"._AM_CLINAMET."<input type='text' name='name' size='30' maxlength='60' /><br />
	"._AM_CONTNAMET."<input type='text' name='contact' size='30' maxlength='60' /><br />
	"._AM_CONTMAILT."<input type='text' name='email' size='30' maxlength='60' /><br />
	"._AM_CLILOGINT."<input type='text' name='login' size='12' maxlength='10' /><br />
	"._AM_CLIPASST."<input type='text' name='passwd' size='12' maxlength='10' /><br />
	"._AM_EXTINFO."<br /><textarea name='extrainfo' cols='60' rows='10' /></textarea><br />
	<input type='hidden' name='op' value='BannerAddClient' />
	<input type='hidden' name='fct' value='banners' />
	<input type='submit' value='"._AM_ADDCLI."' />
	</form>";
	echo "</td></tr></table>";
	xoops_cp_footer();
}

function BannersAdd($name, $cid, $imageurl, $clickurl, $imptotal=0, $htmlbanner, $htmlcode)
{
	$xoopsDB =& Database::getInstance();
	$myts =& MyTextSanitizer::getInstance();
	$nowtime = time();
	$htmlcode = $myts->makeTareaData4Save($htmlcode);
	$newid = $xoopsDB->genId($xoopsDB->prefix("banner")."_bid_seq");
		if ( !isset($imptotal) || $imptotal == "" ) {
			$imptotal = 0;
		}
    $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("banner")." (bid, cid, imptotal, impmade, clicks, imageurl, clickurl, date, htmlbanner, htmlcode) VALUES ($newid, $cid, $imptotal, 1, 0, '$imageurl', '$clickurl', $nowtime, $htmlbanner, '$htmlcode')");
    redirect_header("admin.php?fct=banners&amp;op=BannersAdmin#top",1,_AM_DBUPDATED);
	exit();
}

function BannerAddClient($name, $contact, $email, $login, $passwd, $extrainfo)
{
	$xoopsDB =& Database::getInstance();
	$myts =& MyTextSanitizer::getInstance();
	$name = $myts->makeTboxData4Save($name);
	$contact = $myts->makeTboxData4Save($contact);
	$extrainfo = $myts->makeTareaData4Save($extrainfo);
	$newid = $xoopsDB->genId($xoopsDB->prefix("bannerclient")."_cid_seq");
    $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("bannerclient")." (cid, name, contact, email, login, passwd, extrainfo) VALUES ($newid, '$name', '$contact', '$email', '$login', '$passwd', '$extrainfo')");
    redirect_header("admin.php?fct=banners&amp;op=BannersAdmin#top",1,_AM_DBUPDATED);
	exit();
}

function BannerFinishDelete($bid)
{
	xoops_cp_header();
	xoops_confirm(array('op' => 'BannerFinishDelete2', 'bid' => $bid, 'fct' => 'banners'), 'admin.php', _AM_SUREDELE);
	xoops_cp_footer();
}

function BannerFinishDelete2($bid)
{
 	global $xoopsDB;
    if ($bid > 0) {
    	$sql = sprintf("DELETE FROM %s WHERE bid = %u", $xoopsDB->prefix("bannerfinish"), $bid);
    	$xoopsDB->query($sql);
	}
    redirect_header("admin.php?fct=banners&amp;op=BannersAdmin#top",1,_AM_DBUPDATED);
	exit();
}

function BannerDelete($bid, $ok=0)
12 下一页
💿 文件大小 3473 K
👤 上传用户 susanxuwenjun
📂 所属分类其他
🏷️ 相关标签

#XOOPS #2.09 #2.091 #2.092
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -