<?php

	/* 
	** get information about discussion 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];
		
		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 in this thread
		
		include("$Application_Root/modules/include/show_messages");
		show_messages($MessageID, $message);
		
		
		// display form for replying to current thread
		
		if (($UserInfo["ID"] > 0) || MESSAGES_ENABLE_PUBLIC)
		{
			print("<H2>Respond to this message:</H2>");
			print("<FORM ACTION=\"$ScriptName\" METHOD=\"post\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"sid\" VALUE=\"$sid\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"SCREEN\" VALUE=\"thread\">\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=\"$message\">\n");
			}			
			else
			{
				print("<INPUT TYPE=HIDDEN NAME=\"parent\" VALUE=\"$MessageID\">\n");
			}
			print("<INPUT TYPE=HIDDEN NAME=\"ACTION\" VALUE=\"ADD_THREAD\">\n");
			
			$Query = "SELECT ID ";
			$Query .= "FROM content ";
			$Query .= "WHERE Name='Threaded Discussion';";
			$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:$MessageTitle\">\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.");
	}
	
	
?>