adm_guide.php

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

<?php
/*
	adm_guide.php -

	Version  : 1.0.0
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/10/20
	Modified : 2003/12/19
*/

require "./common.php";
$file_name='adm_guide.php';

if (!$editsubmit)           //未发送表单
{
	if ($action == 'addsort')             //添加页面
    {
 		$dis_subject = '';
 		$dis_message = '';
 		$dis_sid = 0;
 		$issort=1;
   		$display = 'edit';
 	}
	elseif($action == 'addlist')
    {
  		$dis_subject = '';
  		$dis_message = '';
  		$dis_sid = 0;
  		$query = $db->query("SELECT COUNT(*) FROM $table_guide WHERE id=supid");
  		$guidenum = $db->result($query, 0);
  		if($guidenum < 1)
        	gotourl($language['guide_alt_addsort'],$file_name);
  		$optionlist='';
  		$query = $db->query("SELECT * FROM $table_guide where id=supid ORDER BY id DESC");
 	 	while($dbq_rec = $db->fetch_array($query))
        {
   			$optionlist.="<option value='".$dbq_rec['id']."'>".$dbq_rec['subject']."</option>";
  		}
  		$display='edit';
	}
	elseif ($action == 'chg')        //修改页面
    {
 		$query = $db->query("SELECT * FROM $table_guide WHERE id=$id");
 		if($dbq_rec = $db->fetch_array($query))
        {
    		$dis_subject = $dbq_rec['subject'];
    		$dis_message = $dbq_rec['message'];
    		$dis_sid = $dbq_rec['sid'];
    		$supid = $dbq_rec['supid'];
 		}
 		if ($supid == $id)
 		{
        	$issort = 1;}
 		else
 		{
        	$query1 = $db->query("SELECT * FROM $table_guide where id=supid ORDER BY id DESC");
  			while($dbq_rec1 = $db->fetch_array($query1))
            {
    			$isslect=($dbq_rec1['id'] == $supid)?"selected":"";
    			$optionlist.="<option ".$isslect." value='".$dbq_rec1['id']."'>".$dbq_rec1['subject']."</option>";
  			}
 		}
 		$display = 'edit';
 	}
	elseif ($action == 'del')       //删除记录
    {
  		$query = $db->query("SELECT count(*) FROM $table_guide WHERE supid = $id");
  		$num=$db->result($query,0);
  		if($num > 1)
        	gotourl($language['guide_alt_delsort'],$file_name);
  		else
        	$sqlstr="DELETE FROM $table_guide WHERE id = $id";
  		if($query = $db->query($sqlstr))
        	gotourl($language['delsuccess'],$file_name);
        else
        	gotourl($language['db_err'].":<br>".$sqlstr);
    }
	else                                //列表页面
	{
        $guidelist = array();
 		$query = $db->query("SELECT * FROM $table_guide where id=supid ORDER BY sid");
 		while($dbq_rec = $db->fetch_array($query))
        {
            $id = $dbq_rec['id'];
            $dbq_rec['class'] = 0;
   			$guidelist[] = $dbq_rec;
            $query1=$db->query("SELECT * FROM $table_guide WHERE supid = $id AND id <> $id ORDER BY sid");
            while($dbq_rec1=$db->fetch_array($query1))
            {
            	$dbq_rec1['class'] = 1;
                $guidelist[] = $dbq_rec1;
            }
 		}
 		$display = 'list';
	}
}
elseif ($editsubmit)                   //发送表单处理
{
	if($action == 'addsort')              //添加记录
 	{
    	$sqlstr="INSERT INTO $table_guide(subject,message,sid) VALUES('$subject','$message',$sid)";
  		if(!($query = $db->query($sqlstr)))
        	gotourl($language['db_err'].":<br>".$sqlstr);
  		$id=$db->insert_id();
        $sqlstr="UPDATE $table_guide SET supid = $id where id = $id";
        if($query = $db->query($sqlstr))
  			gotourl($language['editsuccess'],$file_name);
        else
          	gotourl($language['db_err'].":<br>".$sqlstr);
 	}
 	elseif($action == 'addlist')
 	{
        $sqlstr="INSERT INTO $table_guide(subject,message,supid,sid) VALUES('$subject','$message',$supid,$sid)";
        if($query = $db->query($sqlstr))
           	gotourl($language['editsuccess'],$file_name);
        else
          	gotourl($language['db_err'].":<br>".$sqlstr);
	}
 	elseif($action == 'chg')          //修改记录
 	{
  		if(!$supid) $supid=$id;
        $sqlstr="UPDATE $table_guide SET subject='$subject',message='$message',sid=$sid,supid=$supid WHERE id = $id";
        if($query = $db->query($sqlstr))
           	gotourl($language['editsuccess'],$file_name);
        else
          	gotourl($language['db_err'].":<br>".$sqlstr);
 	}
}

include template('guide');
?>