<?php

	/* 
	** get information about bulletin board from database
	*/
	
	$Query = "SELECT d.Title, n.Resource, d.Parent, Date_format(d.Created, \"%H:%i, %m/%d/%Y\"), d.Body, d.ID, u.FirstName, u.LastName, u.Email ";	
	$Query .= "FROM node n, discussion d, user u ";
	$Query .= "WHERE n.ID=d.Node AND n.ID=$node AND d.Parent=0 AND u.ID=d.Creator";
	
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	
	$numRows = mysql_NumRows($DatabaseResult);

	if($numRows > 0)
	{
		$DatabaseRow = mysql_fetch_row($DatabaseResult);
		$MessageTitle = $DatabaseRow[0];
		$Resource = $DatabaseRow[1];
		$Parent = $DatabaseRow[2];
		$Created = $DatabaseRow[3];
		$Body = $DatabaseRow[4];
		$MessageID = $DatabaseRow[5];
		$Creator = $DatabaseRow[6] . " " . $DatabaseRow[7];
		$CreatorEmail = $DatabaseRow[8];
		
		$BBSTitle = $MessageTitle;
		$BBSID = $MessageID;
		
		print("<H1>$MessageTitle</H1>\n");
		print("<P>\n");
		print("Discussion started by $Creator ");
		if (MESSAGES_SHOW_EMAIL)
		{	
			print("<A HREF=\"mailto:$CreatorEmail\">$CreatorEmail</A> ");
		}
		
		print("at $Created:\n");
		
		if ($Parent==0)
		{
			print("<P>\n");
			print("$Body\n");
			
			print("<P>\n");
			print("<A HREF=\"$Resource\">$Resource</A>\n");
		}
		
		
		// show current message if it's not the root one
		
		if (isset($message))
		{
			$Query = "SELECT d.Creator, Date_format(d.Created, \"%H:%i, %m/%d/%Y\"), d.Title, d.Body, u.FirstName, u.LastName, u.Email ";
			$Query .= "FROM discussion d LEFT JOIN user u ";
			$Query .= "ON d.Creator=u.ID ";
			$Query .= "WHERE d.ID=$message ";
			
			$DatabaseResult = mysql_query($Query, $DatabaseLink);
	
			$numRows = mysql_NumRows($DatabaseResult);
		
			if($numRows > 0)
			{
				$DatabaseRow = mysql_fetch_row($DatabaseResult);
				
				$MessageCreator = $DatabaseRow[0];
				if ($MessageCreator)
				{
					$MessageCreator = $DatabaseRow[4] . " " . $DatabaseRow[5];
					$MessageCreatorEmail = $DatabaseRow[6];
				}
				else
				{
					$MessageCreator = "Anonymous";
					$MessageCreatorEmail = "";
				}
				
				$MessageCreated = $DatabaseRow[1];
				
				$MessageTitle = $DatabaseRow[2];
				$MessageBody = $DatabaseRow[3];
			
				print("<H2>$MessageTitle</H2>\n");
				print("$MessageCreator ");
			
				if (MESSAGES_SHOW_EMAIL)
				{
					print("<A HREF=\"mailto:$MessageCreatorEmail\">$MessageCreatorEmail</A> ");
				}
				
				print("at $MessageCreated\n");
				
				print("<P>\n");
				print("$MessageBody\n");
			}
			
		}
		
		
		// show messages 
		
		$Query = "SELECT d.ID, d.Creator, Date_format(d.Created, \"%H:%i, %m/%d/%Y\"), d.Title, u.FirstName, u.LastName, u.Email ";
		$Query .= "FROM discussion d LEFT JOIN user u ";
		$Query .= "ON d.Creator=u.ID ";
		$Query .= "WHERE d.Parent=$MessageID ";
		$Query .= "ORDER BY Created ";
		
		$DatabaseResult = mysql_query($Query, $DatabaseLink);
		
		$numRows = mysql_NumRows($DatabaseResult);
	
		if($numRows > 0)
		{
			print("<UL>\n");
			
			while ($DatabaseRow = mysql_fetch_row($DatabaseResult))
			{
				$MessageID = $DatabaseRow[0];
				$MessageCreator = $DatabaseRow[1];
				if ($MessageCreator)
				{
					$MessageCreator = $DatabaseRow[4] . " " . $DatabaseRow[5];
					$MessageCreatorEmail = $DatabaseRow[6];
				}
				else
				{
					$MessageCreator = "Anonymous";
					$MessageCreatorEmail = "";
				}
				
				$MessageCreated = $DatabaseRow[2];
						
				$MessageTitle = $DatabaseRow[3];
				
				// show message title as a link to the thread
				
				print("<LI>");
				if ($message == $MessageID)
				{
					print("<B>");
				}
				else
				{
					print("<A HREF=\"".ScreenURL("thread")."&SCREEN=bbs&sid=$sid&node=$node&message=$MessageID\">");
				}
				
				print("$MessageTitle");
				
				if ($message == $MessageID)
				{
					print("</B>");
				}
				else
				{
					print("</A>");
				}
				
				print("<BR>\n");
				print("$MessageCreator ");
				
				if (MESSAGES_SHOW_EMAIL)
				{
					print("<A HREF=\"mailto:$MessageCreatorEmail\">$MessageCreatorEmail</A> ");
				}
				
				print("at $MessageCreated\n");
			}
		
			print("</UL>\n");
		}
			
		
		
		
		// display form for replying to current thread
		
		if (($UserInfo["ID"] > 0) || MESSAGES_ENABLE_PUBLIC)
		{
			print("<H2>Add a message to this bulletin board:</H2>");
			print("<FORM ACTION=\"$ScriptName\" METHOD=\"post\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"sid\" VALUE=\"$sid\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"SCREEN\" VALUE=\"bbs\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"node\" VALUE=\"$node\">\n");
			if (isset($message))
			{
				print("<INPUT TYPE=HIDDEN NAME=\"message\" VALUE=\"$message\">\n");
			}			
			print("<INPUT TYPE=HIDDEN NAME=\"parent\" VALUE=\"$BBSID\">\n");
			
			print("<INPUT TYPE=HIDDEN NAME=\"ACTION\" VALUE=\"ADD_THREAD\">\n");
			
			$Query = "SELECT ID ";
			$Query .= "FROM content ";
			$Query .= "WHERE Name='Bulletin Board';";
			$DatabaseResult = mysql_query($Query, $DatabaseLink);
			if ($DatabaseRow = mysql_fetch_row($DatabaseResult))
			{
				$content_ID = $DatabaseRow[0];
				print("<INPUT TYPE=\"hidden\" NAME=\"inputContent\" VALUE=\"$content_ID\">");
			}
			else
			{
				print("Error: threaded discussion type isn't in database");
			}
			
			print("<INPUT TYPE=\"TEXT\" NAME=\"inputTitle\" VALUE=\"Re:$BBSTitle\">\n");
			
			print("<TEXTAREA NAME=\"inputBody\" COLS=50 ROWS=5 WRAP=\"virtual\"></TEXTAREA><BR>\n");
			print("<BR>\n");
			
			if (($UserInfo["ID"] > 0) && MESSAGES_ENABLE_ANONYMOUS)
			{
				print("<INPUT TYPE=\"CHECKBOX\" NAME=\"Anonymous\" VALUE=\"Yes\">Post Anonymously\n");
			}
			
			print("<P>\n");
			print("<INPUT TYPE=SUBMIT VALUE=\"Reply\"><BR>\n");
			print("</FORM>\n");
		}
					
	}
	else
	{
		print("Error.  Couldn't find thread.");
	}
	
	
?>