adm_banner.php

这个版本只是修正了一些BUG

<?php
/*********************************************
	adm_baner.php

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/08/20
	Modified : 2004/03/30
**********************************************/
require "./common.php";
$file_name='adm_banner.php';

if ((!$editsubmit)&&(!$listsubmit))     //未发送表单
{
	if ($action == 'add')  //添加页面
    	{
 		$bsiteurl='';
 		$imgselect='selected';
 		$flashselect='';
 		$display = 'edit';
 	}
	elseif ($action == 'chg')     //修改页面
    	{
 		$query = $db->query("SELECT * FROM $table_banners WHERE bid=$bid");
 		if($dbq_rec = $db->fetch_array($query))
        	{
    			$subject = $dbq_rec['subject'];
   			$bsiteurl = $dbq_rec['siteurl'];
    			$fileurl = $dbq_rec['fileurl'];
    			$imgselect = ($dbq_rec['type']=='img')?'selected':'';
    			$flashselect = ($dbq_rec['type']=='flash')?'selected':'';
 		}
		$display = 'edit';
    	}
	else                                //列表页面
	{
 		$query = $db->query("SELECT COUNT(*) FROM $table_banners");
 		$recnum = $db->result($query, 0);
 		$reclist = array();
 		$query = $db->query("SELECT * FROM $table_banners ORDER BY bid ");
 		while($dbq_rec = $db->fetch_array($query))
        	{
   			$dbq_rec['type']=($dbq_rec['type']=='img')?'IMAGE':'FLASH';
   			$reclist[] = $dbq_rec;
 		}
 		$display = 'list';
	}
}
elseif ($editsubmit)            //发送表单处理
{
	if($action == 'add')              //添加记录
	{
        	$sqlstr="INSERT INTO $table_banners(subject,type,fileurl,siteurl) VALUES('$subject','$type','$fileurl','$bsiteurl')";
        	if($query = $db->query($sqlstr))
        		gotourl($language['editsuccess'],$file_name);
        	else
        		gotourl($language['db_err']."<br>".$sqlstr);
 	}
 	elseif($action == 'chg')          //修改记录
 	{
    		$sqlstr="UPDATE $table_banners SET subject='$subject',type='$type',fileurl='$fileurl',siteurl='$bsiteurl' WHERE bid = $bid";
        	if($query = $db->query($sqlstr))
        		gotourl($language['editsuccess'],$file_name);
        	else
        		gotourl($language['db_err']."<br>".$sqlstr);
 	}
}
elseif ($listsubmit)             //删除记录
{
	if(is_array($delete))
    	{
  		$ids = $comma = "";
  		foreach($delete as $id)
        	{
    			$ids .= "$comma'$id'";
			$comma = ", ";
   		}
   		@$db->query("DELETE FROM $table_banners WHERE bid IN ($ids)",1);
 		gotourl($language['delsuccess'],$file_name);
 		exit;
	}
 	$query=@$db->query("select * from $table_banners order by bid");
	 while($dbq_rec=$db->fetch_array($query))
	 {
	 	$id=$dbq_rec[bid];
	 	$sqlstr="update $table_banners set fileurl='$upd_fileurl[$id]',siteurl='$upd_siteurl[$id]',subject='$upd_subject[$id]' where bid=$id";
		@$db->query($sqlstr,1);	
	 }
  	gotourl($language['editsuccess'],$file_name);
}

include template('banner');
?>