if($id==""){
Header ("Location: index.html");
}
include "forumstuff.html";
$IsNew=false;
$sSQL = "Select * from $sTable where id = $id";
mysql_select_db($sDB);
$nPost=mysql_query( $sSQL );
$nRows = mysql_num_rows($nPost);
if($nRows<1){
include "header.inc";
?> echo $lNoPost; ?>
}
else{
$objRead = mysql_fetch_object($nPost);
$rTopic = $objRead->topic;
$eTopic = eregi_replace("|", "", $rTopic);
$rThread = $objRead->thread;
$rName = $objRead->name;
$qName = $rName;
$rEmail = $objRead->email;
$rBody = $objRead->body;
$rHost = $objRead->host;
$rDate = date_format($objRead->datestamp);
$rBody = nl2br($rBody);
if($rEmail!=""){
$rEmail=eregi_replace("@", "@", $rEmail);
if(!eregi("^re: ", $rTopic)){
$sRETopic = $EmailPrefix."RE: $eTopic";
}
else{
$sRETopic = $EmailPrefix."$eTopic";
}
$rName = "$rName";
}
$sTitle = "$rTopic";
include "header.inc";
?>
| echo "$lPostTopic $rTopic"; ?> |
echo "$lPostName $rName"; ?> ( echo $rHost; ?>)
echo "$lPostDate $rDate"; ?>
echo $rBody ?>
|
|
|
// Navigation
$PrevTopic=0;
$PrevThread=0;
$PrevPost=0;
$NextTopic=0;
$NextThread=0;
$NextPost=0;
$NavSQL="Select id,thread from $sTable where thread<$rThread order by thread desc, id limit 1";
mysql_select_db ($sDB);
$nNav = mysql_query ($NavSQL );
$nRows = mysql_num_rows($nNav);
if($nRows>0){
$obj = mysql_fetch_object($nNav);
$PrevTopic = $obj->id;
$PrevThread = $obj->thread;
}
$NavSQL="Select id,thread from $sTable where thread>$rThread order by thread, id limit 1";
mysql_select_db($sDB);
$nNav = mysql_query($NavSQL);
$nRows = mysql_num_rows($nNav);
if($nRows>0){
$obj = mysql_fetch_object($nNav);
$NextTopic = $obj->id;
$NextThread = $obj->thread;
}
$NavSQL="Select id from $sTable where id<$id and thread=$rThread order by id desc limit 1";
mysql_select_db($sDB);
$nNav = mysql_query( $NavSQL );
$nRows = mysql_num_rows($nNav);
if($nRows>0){
$obj = mysql_fetch_object($nNav);
$PrevPost = $obj->id;
}
elseif($PrevThread<>0){
$NavSQL="Select id from $sTable where thread=$PrevThread order by id desc limit 1";
mysql_select_db( $sDB );
$nNav = mysql_query( $NavSQL );
$nRows = mysql_num_rows($nNav);
if($nRows>0){
$obj = mysql_fetch_object($nNav);
$PrevPost = $obj->id;
}
}
$NavSQL="Select id from $sTable where id>$id and thread=$rThread order by id limit 1";
mysql_select_db($sDB);
$nNav = mysql_query( $NavSQL );
$nRows = mysql_num_rows($nNav);
if($nRows>0){
$obj = mysql_fetch_object($nNav);
$NextPost = $obj->id;
}
elseif($NextThread<>0){
$NavSQL="Select id from $sTable where thread=$NextThread order by id limit 1";
$nNav = mysql_query( $NavSQL );
$nRows = mysql_num_rows($nNav);
if($nRows>0){
$obj = mysql_fetch_object($nNav);
$NextPost = $obj->id;
}
}
if($PrevTopic!=0){
echo " $lPrevTopic |";
}
else{
echo " $lPrevTopic |";
}
if($PrevPost!=0){
echo " $lPrevPost ";
}
else{
echo " $lPrevPost ";
}
if($NextPost!=0){
echo "| $lNextPost ";
}
else{
echo "| $lNextPost ";
}
if($NextTopic!=0){
echo "| $lNextTopic ";
}
else{
echo "| $lNextTopic ";
}
?>
|
|
echo $spacer; ?>
$sSQL = "Select id,topic,name,datestamp,thread from $sTable where thread = $rThread order by thread desc, id";
?>
if($nTopics>0){
$nRows = mysql_num_rows($nTopics);
if($nRows>0){
?> echo $lComThread; ?>
include "threads.inc";
?>
}
}
?>
include "form.inc";
?>
}
?>
include "footer.inc"; ?>