select("sleepsecure");
# The server is set to parse .html files as PHP
#
# set some variables
$month = date("Y-m-00");
$today = date("Y-m-d");
$month_h = date("M Y"); # ie, Oct/2003
$TITLE = "Sleep Secure :: Virtual quilt for $month_h";
# get POSTED or GETTED settings and
# set up defaults
if ( isset($_GET['myName']) ):
$myName = urlDecode($_GET['myName']);
elseif ( isset($_REQUEST['myName']) ):
$myName = urlDecode($_REQUEST['myName']);
else:
$myName = "Nancy";
endif;
if ( isset($_GET['getmine']) ):
$getmine = urlDecode($_GET['getmine']);
elseif ( isset($_REQUEST['getmine']) ):
$getmine = urlDecode($_REQUEST['getmine']);
else:
$getmine = $myName;
endif;
# defaults
$defaultIMG = "http://sleepsecure.org/blank.jpg";
$piepagURL = "http://sleepsecure.org/";
$srcURL_1 = $defaultIMG;
$piepagURL_1= $piepagURL;
$srcURL_2 = $defaultIMG;
$piepagURL_2= $piepagURL;
$srcURL_3 = $defaultIMG;
$piepagURL_3= $piepagURL;
$srcURL_4 = $defaultIMG;
$piepagURL_4= $piepagURL;
$srcURL_5 = $defaultIMG;
$piepagURL_5= $piepagURL;
$srcURL_6 = $defaultIMG;
$piepagURL_6= $piepagURL;
$srcURL_7 = $defaultIMG;
$piepagURL_7= $piepagURL;
$srcURL_8 = $defaultIMG;
$piepagURL_8= $piepagURL;
$srcURL_9 = $defaultIMG;
$piepagURL_9= $piepagURL;
function getlastsquares($db, $start, $limit, $getmine) {
$tilesql = "SELECT username,";
$tilesql .= "swatch_CM,swatchX_CM,swatchY_CM, ";
$tilesql .= "swatch_GG,swatchX_GG,swatchY_GG, ";
$tilesql .= "swatch_HR,swatchX_HR,swatchY_HR, ";
$tilesql .= "swatch_PM,swatchX_PM,swatchY_PM, ";
$tilesql .= "swatch_PR,swatchX_PR,swatchY_PR ";
$tilesql .= "FROM tiles ";
# $tilesql .= "WHERE entered > '$month' ";
if($getmine):
$tilesql .= "WHERE username LIKE '$getmine' ";
endif;
$tilesql .= "ORDER BY entered DESC ";
$tilesql .= "LIMIT $start, $limit ";
$quiltarray = $db->get_results($tilesql,ARRAY_N);
$quiltarray['SQL'] = $tilesql;
print "";
return $quiltarray;
}
?>
<?PHP echo $TITLE; ?>
";
?>
