<?php

$User_ID = $_COOKIE["User_ID"];

if (strlen($User_ID)>0) { ?>

<html><head><title>Dream Loom</title>

<link type="text/css" rel="stylesheet" href="style.css"> 
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function checkAll(field)
{
for (i = 0; i < field.length; i++)
        field[i].checked = true ;
}

function uncheckAll(field)
{
for (i = 0; i < field.length; i++)
    field[i].checked = false ;
}

function checkRandom(field)
{
for (i = 0; i < field.length; i++)
	var which = Math.round(Math.random()*1);
	if (which == 1) 
	    field[i].checked = true ;
	else 
		field[i].checked = false ;
}

//  End -->
</script>

</head>

<body>
<?php
	//$db = mysql_connect("127.0.0.1", "root", "523i12");	//connect to DB
	$db = mysql_connect("localhost", "newalexandria", "523i12"); //connect to DB
	mysql_select_db("newalexandria",$db);	//make active

	$sql = "SELECT * FROM users ";
	if (count($_GET['Sel_User_ID']) > 0) {
		$sql = $sql."WHERE User_ID = ".$_GET['Sel_User_ID'][0]." ";
		for ($i = 1; $i < count($_GET['Sel_User_ID']); $i++) {
			$sql = $sql."OR User_ID = ".$_GET['Sel_User_ID'][$i]." ";
		}
	}
	$sql = $sql."ORDER BY Name";
	
//	echo $sql;
	$result = mysql_query($sql);
	
    if (mysql_affected_rows()>0) { 
   		if (count($_GET['Sel_User_ID']) == 0) {
    ?>
			<h3>Choose Dream Sources</h3>
			<FORM name="dreamers" ACTION="dream-build.php" METHOD="GET">
			<?php
				while ($curRow = mysql_fetch_array($result)) {
					echo '<input type="checkbox" name="Sel_User_ID[]" value="'.$curRow['User_ID'].'">: '.$curRow['Name'].'<BR />';
				}
				echo '<br />';
//				echo '<input type="submit" name="go" value="Use all their dreams">';
				echo '<input type="submit" name="go" value="Pick Dreams">';
echo '<BR /><input type="button" name="CheckAll" value="All" onClick="checkAll(document.dreamers.elements)">';
echo '<input type="button" name="UnCheckAll" value="None"
onClick="uncheckAll(document.dreamers.elements)">';
echo '<input type="button" name="Random" value="Random"
onClick="checkRandom(document.dreamers.elements)">';
				 echo '</form>';
				  
		} else { ?>
			<h3>Dream Sources</h3>
			<FORM name="dreamers" ACTION="dream.php" METHOD="GET">
			<?php
				while ($curRow = mysql_fetch_array($result)) {
					echo $curRow['Name'].'<BR /><input type="hidden" name="Sel_User_ID[]" value="'.$curRow['User_ID'].'">';
				 }
		}
	}
	$sql = "SELECT D.Dream_ID, F.words, U.Name FROM usersdreams UD INNER JOIN dreams D ON UD.Dream_ID = D.Dream_ID INNER JOIN fragments F ON D.Name_Fragment_ID = F.Fragment_ID INNER JOIN users U on U.User_ID = UD.User_ID ";
	if (count($_GET['Sel_User_ID']) > 0) {
		$sql = $sql."WHERE U.User_ID = ".$_GET['Sel_User_ID'][0]." ";
		for ($i = 1; $i < count($_GET['Sel_User_ID']); $i++) {
			$sql = $sql."OR U.User_ID = ".$_GET['Sel_User_ID'][$i]." ";
		}
	}
	$sql = $sql."ORDER BY U.Name, F.words";
	
//	echo $sql;
	$result = mysql_query($sql);
	
	if (count($_GET['Sel_User_ID']) > 0) {
		    ?>
			<h3>Choose Dreams</h3>
			<?php
				$UID = "";
				while ($curRow = mysql_fetch_array($result)) {
					if ( $UID <> $curRow['Name'] ) {
						$UID = $curRow['Name'];
						echo '<B>'.$UID.'</B><BR>';
					}
					echo '<input type="checkbox" name="Sel_Dream_ID[]" value="'.$curRow['Dream_ID'].'">: '.$curRow['words'].'<BR />';
				 }
				 echo '<br /><input type="submit" value="Go">';
echo '<BR /><input type="button" name="CheckAll" value="All" onClick="checkAll(document.dreamers.elements)">';
echo '<input type="button" name="UnCheckAll" value="None"
onClick="uncheckAll(document.dreamers.elements)">';
echo '<input type="button" name="random" value="Random"
onClick="checkRandom(document.dreamers.elements)">';
				 echo '</form>';
	}
				?>




<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-1203790-1";
urchinTracker();
</script></body></html>


<?php 
// email graphic for help linked to apology page for hidden email.  
//'lick for frustration' linked to db - rest assured your click has had incremental impact upon a register in our database.

} else { 
	Header("Location: index.php");
}
?>