catalog.php

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

<?
function getsortselect($selectedid=0,$inputdata=0)
{
	global $db,$table_sorts;
	$forumlist = '';
	$forums = array();
	$query = $db->query("SELECT sortid, class, sortname, supsortid, largesortid FROM $table_sorts ORDER BY displayorder");
	while($forum = $db->fetch_array($query)) {
			$forum['sortname'] = strip_tags($forum['sortname']);
			$forums[$forum['sortid']] = $forum;
	}

	foreach($forums as $sortid1 => $forum1) {
		if($forum1['class'] == 'group') {
			$forumlist .=($inputdata==0)? '<option value="">'.$forum1['sortname'].'</option>':"";
			foreach($forums as $sortid2 => $forum2) {
				if($forum2['supsortid'] == $sortid1 && $forum2['class'] == 'sort') {
					$isselected = ($sortid2 == $selectedid)?"selected":"";
					$forumlist .= '<option '.$isselected.' value="'.$sortid2.'">&nbsp;&nbsp;>-+ '.$forum2['sortname'].'</option>';
					foreach($forums as $sortid3 => $forum3) {
						if($forum3['supsortid'] == $sortid2 && $forum3['class'] == 'sub') {
							$isselected = ($sortid3 == $selectedid)?"selected":"";
							$forumlist .= '<option '.$isselected.' value="'.$sortid3.'">&nbsp; &nbsp; &nbsp;├ '.$forum3['sortname'].'</option>';
						}
					}
				}
			}
		}
	}

	return $forumlist;
}
function getsortlist($query='') 
{ 
        global $db,$table_sorts; 
        $forumlist = array(); 
        $forums = array(); 
        if (empty($sqlstr)) $query = $db->query("SELECT sortid, class, sortname, supsortid, largesortid FROM $table_sorts ORDER BY displayorder"); 
        while($forum = $db->fetch_array($query)) { 
                        $forum['sortname'] = strip_tags($forum['sortname']); 
                        $forums[$forum['sortid']] = $forum; 
        } 

        foreach($forums as $sortid1 => $forum1) { 
                if($forum1['class'] == 'group') { 
                        $forumlist[] =$forum1; 
                        foreach($forums as $sortid2 => $forum2) { 
                                if($forum2['supsortid'] == $sortid1 && $forum2['class'] == 'sort') { 
//                                        $forumlist[] =$forum2; 
                                        $sub_line=""; 
                                        foreach($forums as $sortid3 => $forum3) { 
                                                if($forum3['supsortid'] == $sortid2 && $forum3['class'] == 'sub' && (!$forum3['largesortid']|| ($forum3['largesortid']))) { 
                                                        $sub_line .="<a class=sort href='productdisplay.php?sortid=$forum3[sortid]'>".$forum3['sortname']."</a>&nbsp;&nbsp;"; 
                                                } 
                                        } 
                                        $forum2['subline']=$sub_line; 
                                        $forumlist[]=$forum2; 
                                } 
                        } 
                } 
        } 

        return $forumlist; 
}
function getnav($sortid=0)
{
	global $db,$table_sorts;
	$sql="SELECT a.sortid,a.sortname,a.class,a.supsortid,
		b.sortid as supsortid,b.sortname as supsortname,b.class as supclass,
		c.sortid as supsupsortid,c.sortname as supsupsortname
		from $table_sorts a,$table_sorts b,$table_sorts c
		where a.supsortid=b.sortid
		and a.sortid=$sortid
		and b.supsortid = c.sortid";
	$query=$db->query($sql);
	$nav='';
	if ($dbq_rec=$db->fetch_array($query))
	{
 		if ($dbq_rec['class']==0)
   			$nav=$dbq_rec['sortname'];
 		elseif($dbq_rec['class']==1)
   			$nav=$dbq_rec['sortname'];
 		elseif($dbq_rec['class']==2)
   			$nav="<a   href='./productdisplay.php?sortid=".$dbq_rec['supsortid']."'>".$dbq_rec['supsortname']."</a>".SEPARATER.$dbq_rec['sortname'];
 		elseif($dbq_rec['class']==3)
        	{
   			$nav="<a  href='./productdisplay.php?sortid=".$dbq_rec['supsupsortid']."'>".$dbq_rec['supsupsortname']."</a>";
   			$nav.=SEPARATER."<a   href='./productdisplay.php?sortid=".$dbq_rec['supsortid']."'>".$dbq_rec['supsortname']."</a>".SEPARATER.$dbq_rec['sortname'];
   		}
	}
	return $nav;
}


function getcondition($sortid=0)
{
	global $db,$table_sorts;
	$condition='';
	if ($sortid==0) return $condition;
	$sql="SELECT a.sortid,a.sortname,a.class,a.supsortid,
		b.sortname as supsortname,b.class as supclass,
		c.sortname as supsupsortname
		from $table_sorts a,$table_sorts b,$table_sorts c
		where a.supsortid=b.sortid
		and (a.sortid=$sortid or b.sortid=$sortid or c.sortid=$sortid)
		and b.supsortid = c.sortid";
		$query=$db->query($sql);

 	$ids = $comma = "";
	while($dbq_rec=$db->fetch_array($query))
	{
  		$ids .= $comma.$dbq_rec['sortid'];
  		$comma=", ";
	}
	$condition="sortid IN ($ids)";
	if($ids=='') $condition='';
	return $condition;
}
?>