
Lots
of interesting things have happened so far this year thanks to the
members of AIGA NY.
include("../includes/db.html");
// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
if(ereg("staging",$_SERVER['HTTP_HOST'])) {
$regstatus="(regstatus='0' or regstatus='1' or regstatus='2' or regstatus='3' or regstatus='4')"; }
else {
$regstatus="(regstatus='0' or regstatus='1' or regstatus='4')"; }
// CURRENT PASSED
if(date(n)<"8") { $startdate=(date(Y)-1)."-08-01 00:00:00"; } else {
$startdate=(date(Y))."-07-31 23:59:59";
}
$result = mysql_query("select * from inventory where itemtype='1' and $regstatus and enddate'".$startdate."' order by startdate desc");
if($_SERVER['HTTP_HOST']=="staging.aigany.org") { $staging="/".$_SERVER['HTTP_HOST']; };
if(mysql_num_rows($result)>="1") {
$aboveseason="1";
?>
require $_SERVER['DOCUMENT_ROOT'].$staging."/includes/eventlist.html"; ?>
}
// PREVIOUS
if(date(n)>="8") { ?>
if($aboveseason) { $enddate="'".(date(Y))."-07-31 23:59:59"."'"; } else { $enddate="NOW()"; }
$startdate=(date(Y)-1)."-08-01 00:00:00";
$result = mysql_query("select * from inventory where itemtype='1' and $regstatus and enddate<".$enddate." and startdate>'".$startdate."' order by startdate desc");
if($_SERVER['HTTP_HOST']=="staging.aigany.org") { $staging="/".$_SERVER['HTTP_HOST']; }
require $_SERVER['DOCUMENT_ROOT'].$staging."/includes/eventlist.html"; ?>
} ?>
|
|
| if($_SERVER['HTTP_HOST']=="staging.aigany.org") {
$staging="/".$_SERVER['HTTP_HOST']; };
require $_SERVER['DOCUMENT_ROOT'].$staging."/includes/calendar.html"; ?> |
|
if($_SERVER['HTTP_HOST']=="staging.aigany.org") { $staging="/".$_SERVER['HTTP_HOST']; };
require $_SERVER['DOCUMENT_ROOT'].$staging."/includes/cart.html"; ?>
| if($_SERVER['HTTP_HOST']=="staging.aigany.org") {
$staging="/".$_SERVER['HTTP_HOST']; };
require $_SERVER['DOCUMENT_ROOT'].$staging."/includes/features.html"; ?> |
|