adm_menu.php

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

<?php
/**********************************************
	adm_menu.php

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/08/20
	Modified : 2004/04/17
***********************************************/
require "./common.php";

/*
require  '../config.php';      //配置文件
require  '../include/db_mysql.php';    //MYSQL数据库操作类
require  '../include/admin.php';       //系统管理支持函数库
require  '../include/function.php';    //基本函数库
define(IMGDIR,'images');
define('IN_SITE', TRUE);
$subflag='admin';

$tables = array('banners','basket','bulletins','delivery','favorite','groups','guide','icons','language','members',
			   'menuitems','orders','orderstatus','parameters','paravals','paravars','pm','products','recommend','review',
                	   'searchindex','settings','sorts','styles','stylevars','updatesql','votekeys','votes','weblinks');

foreach($tables as $tablename) {
	${'table_'.$tablename} = $tablepre.$tablename;
}
unset($tablename);

// ========= 连接数据库 =======================================================
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $pconnect);
$db->select_db($dbname);
unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);

$query=$db->query("SELECT * FROM $table_settings");
if($dbq_rec=$db->fetch_array($query))
{
	$version=$dbq_rec['version'];
    	$siteurl=$dbq_rec['siteurl'];
    	$releasedate=$dbq_rec['releasedate'];
    	$LANGID=$dbq_rec['langid'];
    	$STYLEID = $dbq_rec['styleid'];
    	$timeformat=$dbq_rec['timeformat'];
    	$dateformat=$dbq_rec['dateformat'];
}
unset($query);unset($dbq_rec);

$query = $db->query("SELECT langdir FROM $table_language WHERE langid = $LANGID");
$dbq_rec = $db->fetch_array($query);
$LANGDIR = '../'.$dbq_rec['langdir'];
require language('admin');                       //取主语言包文件
unset($dbq_rec);unset($query);

$timestamp=time();
*/
function showwin($id,$title,$flag)
{
    // $flag = 0  --  close   1 -- open
	global $db,$table_menuitems;
    	$str="<tr class='m_title'><td>&nbsp;";
    	if($flag == 0)
    		$str.="<a href='adm_menu.php?action=single&id=$id&flag=1'><img border='0' src='".IMGDIR."/+.gif'></a>";
    	else
    		$str.="<a href='adm_menu.php?action=single&id=$id&flag=0'><img border='0' src='".IMGDIR."/-.gif'></a>";
    	$str.="&nbsp;".$title."</td></tr>";
    	$str.="<tr class='line_1'><td align='center'>";
    	if($flag == 1)
    	{
        	$query1=$db->query("SELECT * FROM $table_menuitems WHERE supid = $id AND id <> $id ORDER BY id");
        	while($dbq_rec1=$db->fetch_array($query1))
    		{
        		$str.="<table border='0' cellpadding='0' cellspacing='0' width='70%' align='center'>";
            		$str.="<tr><td height='20'><img border='0' src='".IMGDIR."/item.gif'>&nbsp;<a href='".$dbq_rec1['url']."' target='rbottom'>";
            		$str.=$dbq_rec1['title']."</a></td></tr>";
            		$str.="</table>";
        	}
    	}
	$str.="</td></tr>";
	return $str;
}

if($action == 'single')
{
	$id=intval($id);
	$sqlstr="UPDATE $table_menuitems SET flag = $flag WHERE id=$id";
    	$query=$db->query($sqlstr);
}
elseif ($action == 'all')
{
    	$flag=daddslashes($flag);
    	$sqlstr="UPDATE $table_menuitems SET flag = $flag";
    	$query=$db->query($sqlstr);
}

$itemlist=array();
$query=$db->query("SELECT * FROM $table_menuitems WHERE id = supid ORDER BY id");
while($dbq_rec=$db->fetch_array($query))
{
	$itemlist[]=$dbq_rec;
}

include template('menu');
?>