<?

	/* 
	** get information about vote options from database
	*/
	$Query = "SELECT n.Name, n.Description, n.Resource, vo.Opt, vo.ID ";
	$Query .= "FROM node n, vote_option vo ";
	$Query .= "WHERE n.ID=vo.Node AND n.ID=$node ";
	$Query .= "ORDER BY vo.ID ";
	
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	
	$numRows = mysql_NumRows($DatabaseResult);

	if($numRows > 0)
	{
		$DatabaseRow = mysql_fetch_row($DatabaseResult);
		$Name = $DatabaseRow[0];
		$Description = $DatabaseRow[1];
		$Resource = $DatabaseRow[2];
		
		/* 
		** get vote count for each option from database
		*/
		
		$Query2 = "SELECT Answer, COUNT(*) ";
		$Query2 .= "FROM user_vote ";
		$Query2 .= "WHERE Vote=$node ";
		$Query2 .= "GROUP BY Answer ";
		
		$DatabaseResult2 = mysql_query($Query2, $DatabaseLink);
		
		$numRows2 = mysql_NumRows($DatabaseResult2);
		if ($numRows2)
		{
			$DatabaseRow2 = mysql_fetch_row($DatabaseResult2);
		}
							
		$index = 0;
		$index2 = 0;
		$total_votes = 0;
		
		/* 
		** set up an array with each option name, id, and count
		*/
		
		while($DatabaseRow)
		{
			$Options[$index][0] = $DatabaseRow[3];
			$Options[$index][1] = $DatabaseRow[4];
			
			if ($DatabaseRow2)
			{
				if ($DatabaseRow2[0] == $Options[$index][1])
				{
					$Options[$index][2] = $DatabaseRow2[1];
					$total_votes += $Options[$index][2];
					$DatabaseRow2 = mysql_fetch_row($DatabaseResult2);
				}
				else
				{
					$Options[$index][2] = 0;
				}
			}
			else
			{
				$Options[$index][2] = 0;
			}
									
			$DatabaseRow = mysql_fetch_row($DatabaseResult);
			$index++;	
		}
	}
	
	/* 
	** display vote name, description, and resource
	*/
	
	print("<H1>$Name</H1>\n");
	print("<P>\n");
	print("$Description\n");
	if ($Resource != "")
	{
		print("<P>\n");
		print("<A HREF=\"$Resource\" TARGET=\"new\">$Resource</A>\n");
	}
		
	/* 
	** if user is logged in and has not yet voted, display form for casting a vote
	*/

	if ($UserInfo["ID"] > 0 )
	{
		$ID = $UserInfo["ID"];
		$Query = "SELECT User ";
		$Query .= "FROM user_vote ";
		$Query .= "WHERE Vote=$node AND User=" . $UserInfo["ID"];
		
		$DatabaseResult = mysql_query($Query, $DatabaseLink);
	
		$numRows = mysql_NumRows($DatabaseResult);
	
		if($numRows == 0)
		{
			print("<FORM ACTION=\"$ScriptName\" METHOD=\"get\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"sid\" VALUE=\"$sid\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"SCREEN\" VALUE=\"vote\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"ACTION\" VALUE=\"CAST_VOTE\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"pathway\" VALUE=\"$pathway\">\n");
			print("<INPUT TYPE=HIDDEN NAME=\"node\" VALUE=\"$node\">\n");
			
			for ($i=0; $i<$index; $i++)
			{
				print("<INPUT TYPE=\"radio\" NAME=\"VoteOption\" VALUE=\"");
				print($Options[$i][1]);
				print("\">");
				print($Options[$i][0]);
				print("<BR>\n");		
			}
			
			print("<BR><INPUT TYPE=\"submit\" VALUE=\"Cast Vote\">\n");
			print("</FORM>\n");
		}
		else
		{
			print("<P>You have voted.<BR>\n");
		}
	}
	else
	{
		print("<P>You must be logged in to vote.<BR>\n");
	}
	
	/* 
	** display results of vote so far
	*/
	
	print("<P>\n");
	print("<B>Results:</B>\n");
	
	if ($total_votes > 0 )
	{
		print("<TABLE BORDER=\"0\" CELLPADDING=\"0\" CELLSPACING=\"5\">\n");
		
		for ($i=0; $i<$index; $i++)
		{
			print("<TR ALIGN=\"left\" VALIGN=\"top\">\n");
			print("<TD>\n");
			print($Options[$i][0]);
			print("</TD>\n");
			print("<TD>\n");
			$percent = $Options[$i][2]/$total_votes * 100;
			$width = $percent * 5;
			print("<IMG SRC=\"images/votebar.jpg\" HEIGHT=\"50\" WIDTH=\"$width\">");
			printf("%2.1f", $percent);
			print("%\n");
			print("</TD>\n");
			print("</TR>\n");		
		}
		
		print("</TABLE>\n");
		print("Total Votes Cast: $total_votes\n");
	}
	else
	{
		print("<BR>\n");
		print("No votes cast yet.\n");
	}
?>