0) {
$sql = "DELETE FROM tmp_fragmentsusers WHERE User_ID = ".$GLOBALS['User_ID'];
$result = mysql_query($sql);
}
//echo count($_GET['Dream_ID'])."
".count($_GET['Sel_User_ID'])."
";
$sql = "SELECT UD.Dream_ID, F.Fragment_ID, F.words, DF.sort FROM dreamsfragments DF INNER JOIN fragments F ON DF.Fragment_ID = F.Fragment_ID INNER JOIN usersdreams UD ON UD.Dream_ID = DF.Dream_ID ";
if (count($_GET['Sel_Dream_ID']) > 0) {
$sql = $sql."WHERE UD.Dream_ID = ".$_GET['Sel_Dream_ID'][0]." ";
for ($i = 1; $i < count($_GET['Sel_Dream_ID']); $i++) {
$sql = $sql."OR UD.Dream_ID = ".$_GET['Sel_Dream_ID'][$i]." ";
}
} elseif (count($_GET['Sel_User_ID']) > 0) {
$sql = $sql."WHERE UD.User_ID = ".$_GET['Sel_User_ID'][0]." ";
for ($i = 1; $i < count($_GET['Sel_User_ID']); $i++) {
$sql = $sql."OR UD.User_ID = ".$_GET['Sel_User_ID'][$i]." ";
}
}
$sql = $sql."ORDER BY RAND() LIMIT ";
$result = mysql_query($sql."4");
// echo $sql."
";
function sentence ($last) // Build a sentence
{
$totalqts = 4;
$nmbr = rand(2,$totalqts);
//$sql = "SELECT * FROM fragments WHERE Dream_ID = 2 ORDER BY RAND() LIMIT ".$nmbr;
$sql = "SELECT UD.Dream_ID, F.Fragment_ID, F.words, DF.sort FROM dreamsfragments DF INNER JOIN fragments F ON DF.Fragment_ID = F.Fragment_ID INNER JOIN usersdreams UD ON UD.Dream_ID = DF.Dream_ID ";
if (count($_GET['Sel_Dream_ID']) > 0) {
$sql = $sql."WHERE UD.Dream_ID = ".$_GET['Sel_Dream_ID'][0]." ";
for ($i = 1; $i < count($_GET['Sel_Dream_ID']); $i++) {
$sql = $sql."OR UD.Dream_ID = ".$_GET['Sel_Dream_ID'][$i]." ";
}
} elseif (count($_GET['Sel_User_ID']) > 0) {
$sql = $sql."WHERE UD.User_ID = ".$_GET['Sel_User_ID'][0]." ";
for ($i = 1; $i < count($_GET['Sel_User_ID']); $i++) {
$sql = $sql."OR UD.User_ID = ".$_GET['Sel_User_ID'][$i]." ";
}
}
$sql = $sql."ORDER BY RAND() LIMIT ".$nmbr;
// echo $sql."
"; // SQL DEBUG
// echo $sql;
$result = mysql_query($sql);
if (mysql_affected_rows()>0) {
$strOut = "";
$rows = mysql_affected_rows();
for ($i=1; $i<=$rows; $i++) {
$curRow = mysql_fetch_array($result);
if (substr($curRow['words'], (strlen($curRow['words'])-1), 1)=="?") {
$punctuation = "?";
$curRow['words'] = substr($curRow['words'], 0, (strlen($curRow['words'])-1));
} elseif (substr($curRow['words'], (strlen($curRow['words'])-1), 1)=="!") {
$punctuation = "!";
$curRow['words'] = substr($curRow['words'], 0, (strlen($curRow['words'])-1));
} else {
$punctuation = ".";
}
$strOut = $strOut.strtolower(substr($curRow['words'], 0, 1)).substr($curRow['words'], 1, (strlen($curRow['words'])-1))." ";
// Get the next Sort value to insert
$sql = "SELECT COALESCE(MAX(sort)+1, 1) sort FROM tmp_fragmentsusers WHERE User_ID = ".$GLOBALS['User_ID'];
$sortRow = mysql_fetch_array(mysql_query($sql));
$sort = $sortRow['sort'];
// Set fragment type
if (( $last==1 ) && ( $i==$rows )) {
$type = "B";
} elseif ( $i==$rows ) {
$type = "P";
} else {
$type = "";
}
// Create the tmp User->Fragment relationship
$sql = "INSERT INTO tmp_fragmentsusers (Fragment_ID, User_ID, sort, type) VALUES (".$curRow['Fragment_ID'].", ".$GLOBALS['User_ID'].", ".$sort.", '".$type."')";
$result2 = mysql_query($sql);
// echo $sql."
";
}
$strOut = rtrim($strOut);
$strOut = ucfirst($strOut).$punctuation;
return $strOut;
} else {
return "Hiccup ";
}
/*
// Get the next Sort value to insert
$sql = "SELECT COALESCE(MAX(sort)+1, 1) sort FROM usersdreams WHERE User_ID = ".$GLOBALS['User_ID'];
$curRow = mysql_fetch_array(mysql_query($sql));
$sort = $curRow['sort'];
// Create the User->Fragment relationship
$sql = "INSERT INTO tmp_fragmentsusers (Fragment_ID, User_ID, sort) VALUES (".$Fragment_ID.", ".$GLOBALS['User_ID'].", ".$sort.")";
$result = mysql_query($sql);
*/
}
function paragraph () // Build a paragraph
{
$totalqts = 7;
$nmbr = rand(1,$totalqts);
$strOut = "";
for ($i=1; $i<=$nmbr; $i++) {
// Print the sentences; if it's the last sentence, the the function that
$strOut = $strOut.sentence( (($i==$nmbr) ? 1 : 0) )." "; //.(($i==$nmbr) ? 1 : 0);
}
$strOut = rtrim($strOut)."
";
return $strOut;
}
// $sql = "SELECT * FROM fragments WHERE Dream_ID = 2 ORDER BY sort";
?>
Dream Loom
More, Please
Remember this one
Choose different sources
0) {
$curRow = mysql_fetch_array($result);
echo "
".$curRow['title']."
";
echo "
".$curRow['words'];
while ($curRow = mysql_fetch_array($result)) {
echo " ".$curRow['words'];
if ($curRow['type']=="P") {
echo ". ";
} elseif ($curRow['type']=="B") {
echo ".
";
}
}
}
?>
View a different dream
back