here.\n"; echo "\n"; exit; } $db = mysql_connect("localhost", "pubuser", "aftged"); mysql_select_db("PubForums",$db); $main=mysql_query("select title, url from main where num='$num'",$db); if ($maininfo = mysql_fetch_row($main)) { do { $title=$maininfo[0]; $url=$maininfo[1]; } while ($maininfo = mysql_fetch_row($main)); } $title=stripslashes($title); echo "$title\n"; ?>

$title

\n"; echo "

\n"; if($url) echo "
Visit $url
\n"; echo "
\n"; if (empty($ofs)) { $ofs=0; } /* set up database */ mysql_pconnect( "localhost", "pubuser", "aftged"); $Database = "PubForums"; /**************************************************************** recursive function that spits out all descendent messages ****************************************************************/ function showMessages($parentID) { global $Database; global $num; global $ofs; global $Limiter; $dateToUse = Date( "U"); echo "\n"; } /**************************************************************** print out a form for adding a message with parent id given ****************************************************************/ function postForm($parentID, $useTitle, $num) { echo "

\n"; printf( "

\n"); printf( ""); printf( ""); printf( ""); printf( "\n"); printf( ""); printf( "\n"); printf( ""); printf( "\n"); printf( ""); printf( "\n"); printf( "\n"); printf( "\n"); printf( "
Title
Name
E-mail
"); printf( "
\n"); printf( "
\n"); } /****************************************************** perform actions ******************************************************/ if($ACTION != "") { if($ACTION == "POST") { $inputTitle = ereg_replace( "'", "''", $inputTitle); $inputPoster = ereg_replace( "'", "''", $inputPoster); $inputemail = ereg_replace( "'", "''", $inputemail); $inputBody = nl2br($inputBody); $inputBody = addslashes($inputBody); $Query = "INSERT INTO bbsMessage "; $Query .= "VALUES(0, '$inputTitle', "; $Query .= "'$inputPoster', "; $Query .= "now(), $inputParent, "; $Query .= "'$inputBody', '$inputemail', '$num')"; $result = mysql($Database,$Query); } } /****************************************************** Show Message or show list of messages ******************************************************/ if($messageID > 0) { $Query = "SELECT * FROM bbsMessage "; $Query = $Query . "WHERE ID=$messageID "; $result = mysql($Database,$Query); $numRows = mysql_NumRows($result); $RowCount = 0; if($RowCount < $numRows) { $messageID = mysql_result($result,$RowCount, "ID"); $messageTitle = mysql_result($result,$RowCount, "Title"); $messagePoster = mysql_result($result,$RowCount, "Poster"); $messageCreated = mysql_result($result,$RowCount, "Created"); $messageParent = mysql_result($result,$RowCount, "Parent"); $messageBody = mysql_result($result,$RowCount, "Body"); $messageemail = mysql_result($result,$RowCount, "email"); $yr = substr($messageCreated, 2, 2); $mo = substr($messageCreated, 5, 2); $dy = substr($messageCreated, 8, 2); $tme = substr($messageCreated, 11, 5); echo "

\n"; printf( "

\n"); printf( "\n"); printf( "\n"); } else { printf( "$messagePoster\n"); } printf( "\n"); $messageBody=stripslashes($messageBody); printf( "\n"); printf( "
Title$messageTitle
Name"); if (empty($messageemail)) { printf( "$messagePoster
Posted$mo/$dy/$yr at $tme
$messageBody
\n"); echo "

Post a Reply!\n"; postForm($messageID, "RE: $messageTitle", $num); } echo "Display message list
"; } else { /* call recursive function */ showMessages(0); if (39 < $ofs) { $ofp=$ofs-40; echo "Newer 40 messages...\n";} else { echo "\n";} if ($Limiter==40) { echo "Older 40 messages...\n";} else { echo "\n";} postForm(0, "", $num); } ?> Forum provided by AudibleFaith.com.