<?
     /***************************************************************/ 
     /*Function:showMessages v1.0                                   */ 
     /*Code: PHP 3                                                  */ 
     /*Author: Vicky Atkinson based on code by Leon Atkinson        */ 
     /*Creates shows messages responding to the given message       */ 
     /*Input: ID of message to find responses to and ID of current  */
     /*       message                                               */ 
     /*Output: HTML list of links to responses with current message */
     /*        not a link                                           */ 
     /***************************************************************/ 


function show_messages($parentID, $currentID)
{
	global $DatabaseLink;
	global $sid;
	global $node;
	
	$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=$parentID ";
	$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 ($currentID == $MessageID)
			{
				print("<B>");
			}
			else
			{
				print("<A HREF=\"".ScreenURL("thread")."&SCREEN=thread&sid=$sid&node=$node&message=$MessageID\">");
			}
			
			print("$MessageTitle");
			
			if ($currentID == $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");
	
			show_messages($MessageID, $currentID);
		}
	
		print("</UL>\n");
	}
}

?>