adm_frendlink.php

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

<?php
/***********************************************
	adm_frendlink.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_frendlink.php';

if ((!$editsubmit)&&(!$listsubmit))     //未发送表单
{
	if ($action == 'add')  //添加页面
    	{
       		$name = "";
   	   	$note = "";
       		$url = "";
       		$url = "";
 	   	$display = 'edit';
 	}
	elseif ($action == 'chg')     //修改页面
    	{
 		$query = $db->query("SELECT * FROM $table_weblinks WHERE id=$id");
 		if($dbq_rec = $db->fetch_array($query))
        	{
    			$name = $dbq_rec['name'];
   			$note = $dbq_rec['note'];
    			$url = $dbq_rec['url'];
            		$logo = $dbq_rec['logo'];
    			$linkselect = ($dbq_rec['type']=='link')?'selected':'';
    			$allyselect = ($dbq_rec['type']=='ally')?'selected':'';
 		}
		$display = 'edit';
    	}
	else                                //列表页面
	{
 		$query = $db->query("SELECT COUNT(*) FROM $table_weblinks");
 		$recnum = $db->result($query, 0);
 		$reclist = array();
 		$query = $db->query("SELECT * FROM $table_weblinks ORDER BY type,id ");
 		while($dbq_rec = $db->fetch_array($query))
        	{
   			$dbq_rec['type']=($dbq_rec['type']=='link')?'LINK':'ALLY';
   			$reclist[] = $dbq_rec;
 		}
 		$display = 'list';
	}
}
elseif ($editsubmit)            //发送表单处理
{
	if($action == 'add')              //添加记录
	{
        	$sqlstr="INSERT INTO $table_weblinks(name,note,url,logo,type) VALUES('$name','$note','$url','$logo','$type')";
        	if($query = $db->query($sqlstr))
        		gotourl($language['editsuccess'],$file_name);
        	else
        		gotourl($language['db_err']."<br>".$sqlstr);
 	}
 	elseif($action == 'chg')          //修改记录
 	{
    		$sqlstr="UPDATE $table_weblinks SET name='$name',note='$note',url='$url',logo='$logo',type='$type' WHERE id = $id";
        	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_weblinks WHERE id IN ($ids)");
 		gotourl($language['delsuccess'],$file_name);
		exit;
 	}
  	$query=@$db->query("select * from $table_weblinks order by type,id");
	 while($dbq_rec=$db->fetch_array($query))
	 {
	 	$id=$dbq_rec[id];
	 	$sqlstr="update $table_weblinks set name='$upd_name[$id]',note='$upd_note[$id]',logo='$upd_logo[$id]',url='$upd_url[$id]' where id=$id";
		@$db->query($sqlstr);	
	 }
  	gotourl($language['editsuccess'],$file_name);
}

include template('frendlink');
?>