guide.php

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

<?php
/**********************************************
        guide.php  
        
	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright:
	Writed   : 2003/11/04
	Modified : 2003/11/15
***********************************************/
require "./include/base.php";

if($page == "view")
{
	$id=intval($id);
	$query = $db->query("SELECT * FROM $table_guide WHERE id = $id");
    	$dbq_rec=$db->fetch_array($query);
    	$title=$dbq_rec['subject'];
    	$nav .= SEPARATER."<a href='guide.php'>".$language['head_guide']."</a>".SEPARATER.$dbq_rec['subject'];
    	$query = $db->query("SELECT * FROM $table_guide WHERE supid = $id and id <> supid ORDER BY sid");
    	$list=array();
    	while($dbq_rec = $db->fetch_array($query))
    	{
     		$dbq_rec['message']=str_replace('  ', '&nbsp; ', nl2br($dbq_rec['message']));
     		//$dbq_rec['message']=nl2br($dbq_rec['message']);
     		$list[]=$dbq_rec;
    	}
}
else
{
	$list = array();
	$query = $db->query("SELECT * FROM $table_guide WHERE id=supid ORDER BY sid");

	while($dbq_rec = $db->fetch_array($query)) {

    	$line = "";
    	$line.="<tr><td class='header'>".$dbq_rec['subject']."</td></tr>";
    	$line.="<tr><td bgcolor='".ALTBG1."' class='smalltxt'>";

   	$sql="SELECT * FROM $table_guide WHERE supid=".$dbq_rec['id']." and id<>supid order by sid";
    	$query1=$db->query($sql);
    	while($dbq_rec1 = $db->fetch_array($query1))
    	{

     	$line.="·<a href='guide.php?id=".$dbq_rec['id']."&page=view#".$dbq_rec1['id']."'>".$dbq_rec1[subject]."</a><br>";
    	}
    	$line.="</td></tr>";
        $line.="<tr bgcolor='".ALTBG2."'><td height=6></td></tr>";
    	$dbq_rec['line']=$line;
    	$list[] = $dbq_rec;

	}
    	$nav .= SEPARATER.$language['head_guide'];

}

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

include template('guide');

?>