<?
	$Query = "SELECT n.Name, n.Description, n.Keywords, n.Content, n.Resource, c.Name, n.Icon, n.DisplayOrder ";
	$Query .= "FROM node n, content c ";
	$Query .= "WHERE n.ID=$inputNode AND n.Content = c.ID";
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	$DatabaseRow = mysql_fetch_row($DatabaseResult);

	$node_Name = $DatabaseRow[0];
	$node_Description = $DatabaseRow[1];
	$node_Keywords = $DatabaseRow[2];
	$node_Content = $DatabaseRow[3];
	$node_Resource = $DatabaseRow[4];
	$node_Content_Name = $DatabaseRow[5];
	$node_Icon = $DatabaseRow[6];
	$node_Display_Order = $DatabaseRow[7];
		

	/* 
	** display form for editing node
	*/
	print("<FORM ACTION=\"$ScriptName\" METHOD=\"get\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"sid\" VALUE=\"$sid\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"SCREEN\" VALUE=\"edit\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"ACTION\" VALUE=\"UPDATE_NODE\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"pathway\" VALUE=\"$pathway\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"inputNode\" VALUE=\"$inputNode\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"inputContent\" VALUE=\"$node_Content\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"inputContentName\" VALUE=\"$node_Content_Name\">\n");
	
	print("Name of Node");
	print("<INPUT TYPE=TEXT NAME=\"inputName\" VALUE=\"$node_Name\" SIZE=\"36\"><BR>\n");
	print("<BR>\n");

	print("Descriptive Text");
	print("<TEXTAREA NAME=\"inputDescription\" COLS=50 ROWS=5 WRAP=\"virtual\">$node_Description</TEXTAREA><BR>\n");
	print("<BR>\n");

	print("Keywords");
	print("<TEXTAREA NAME=\"inputKeywords\" COLS=50 ROWS=2 WRAP=\"virtual\">$node_Keywords</TEXTAREA><BR>\n");
	print("<BR>\n");

	// get list of images in directory of icons
	
	print("Icon");
	print("<SELECT NAME=\"inputIcon\">\n");
	print("<OPTION VALUE=\"0\"");
	if ($node_Icon == 0)
	{
		print(" SELECTED");
	}
	print(">None\n");
	
	$Icon_Directory = dir($Icon_URL);
		
	while ($current_Image = $Icon_Directory->read())
	{
		if ($current_Image != "." && $current_Image != "..")
		{
			print("<OPTION VALUE=\"$current_Image\"");
			if ($node_Icon == $current_Image)
			{
				print(" SELECTED");	
			}
			print(">$current_Image\n");
		}
	}
	print("</SELECT><BR>\n");
	print("<BR>\n");
		
	print("Display Order");
	print("<INPUT TYPE=TEXT NAME=\"inputDisplayOrder\" VALUE=\"$node_Display_Order\" SIZE=\"4\"><BR>\n");
	print("<BR>\n");
	
	print("Resource");
	print("<INPUT TYPE=TEXT NAME=\"inputResource\" VALUE=\"$node_Resource\" SIZE=\"36\"><BR>\n");
	print("<BR>\n");
	
	
	if ($node_Content_Name == 'Story')
	{
		// get additional story information from the story table
		
		$Query = "SELECT Author, Date, Body ";
		$Query .= "FROM story ";
		$Query .= "WHERE Node=$inputNode ";
		
		$DatabaseResult = mysql_query($Query, $DatabaseLink);
	
		$numRows = mysql_NumRows($DatabaseResult);

		if($numRows > 0)
		{
			$DatabaseRow = mysql_fetch_row($DatabaseResult);
			$Author = $DatabaseRow[0];
			$Date = $DatabaseRow[1];
			$Body = $DatabaseRow[2];
		
			print("Author");
			print("<INPUT TYPE=TEXT NAME=\"inputAuthor\" VALUE=\"$Author\" SIZE=\"36\"><BR>\n");
			print("<BR>\n");
			
			include("$Application_Root/modules/include/date_selector");
			$DateYear = intval(strtok($Date, "-"));
        	$DateMonth = intval(strtok("-"));
        	$DateDay = intval(strtok("-"));
        	$Date = mktime(0, 0, 0, $DateMonth, $DateDay, $DateYear);
       		DateSelector(inputDate, $Date);
			print("<BR>\n");
			print("<BR>\n");
			
			print("Story <BR>\n");
			print("<TEXTAREA NAME=\"inputBody\" COLS=50 ROWS=20 WRAP=\"virtual\">$Body</TEXTAREA><BR>\n");
			print("<BR>\n");
	
		
		}
		else
		{
			print("<P>Error:  Story not found in database.<BR><BR>\n");
		}	
	}
	
	print("<INPUT TYPE=SUBMIT VALUE=\"Update Node\"><BR>\n");
	print("</FORM>\n");

?>