<?php require_once('Connections/events.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form_hikereg")) {
  $insertSQL = sprintf("INSERT INTO rollerhike (ParticipantName, EmailAddress, MailingAddress, City, `state`, Zip, Phone, Birthdate, Sex, TshirtSize, Waiver) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['ParticipantName'], "text"),
                       GetSQLValueString($_POST['EmailAddress'], "text"),
                       GetSQLValueString($_POST['MailingAddress'], "text"),
                       GetSQLValueString($_POST['City'], "text"),
                       GetSQLValueString($_POST['state'], "text"),
                       GetSQLValueString($_POST['Zip'], "text"),
                       GetSQLValueString($_POST['Phone'], "text"),
                       GetSQLValueString($_POST['Birthdate'], "text"),
                       GetSQLValueString($_POST['Sex'], "text"),
                       GetSQLValueString($_POST['TshirtSize'], "text"),
                       GetSQLValueString($_POST['Waiver'], "text"));

  mysql_select_db($database_events, $events);
  $Result1 = mysql_query($insertSQL, $events) or die(mysql_error());

  $insertGoTo = "https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=pam%401life2live%2eorg&item_name=Tyler_Roller_Coaster_Hike&amount=25%2e00&no_shipping=1&no_note=1&tax=0&currency_code=USD&lc=US&bn=PP%2dDonationsBF&charset=UTF%2d8";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_events, $events);
$query_hikereg = "SELECT * FROM rollerhike";
$hikereg = mysql_query($query_hikereg, $events) or die(mysql_error());
$row_hikereg = mysql_fetch_assoc($hikereg);
$totalRows_hikereg = mysql_num_rows($hikereg);

mysql_select_db($database_events, $events);
$query_hikecoord = "SELECT * FROM `access`";
$hikecoord = mysql_query($query_hikecoord, $events) or die(mysql_error());
$row_hikecoord = mysql_fetch_assoc($hikecoord);
$totalRows_hikecoord = mysql_num_rows($hikecoord);
?><?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['username'])) {
  $loginUsername=$_POST['username'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "hike_registration_gettable.php";
  $MM_redirectLoginFailed = "hike_registration_form.php";
  $MM_redirecttoReferrer = true;
  mysql_select_db($database_events, $events);
  
  $LoginRS__query=sprintf("SELECT username, password FROM `access` WHERE username=%s AND password=%s",
    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $events) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && true) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<html><!-- InstanceBegin template="/Templates/maintemplate.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>1L2L &ndash; remember tyler's smile</title>
<!-- InstanceEndEditable -->
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-1423634-6";
urchinTracker();
</script>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">
<!--
body {
	background-image: url(images/mastheadbkg2.jpg);
	background-repeat: repeat-x;
	background-color: #DDDDDD;
}
.mousetype {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 10px;
	line-height: 12px;
	color: #333333;
}
.bodycopy {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 12px;
	line-height: 16px;
	color: #333333;
	margin-right: 6px;
	margin-left: 6px;
}
.headcatalog {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 18px;
	color: 00447C;
	padding-left: 6px;
}
.head {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 24px;
	color: #00447C;
	padding-left: 6px;
}
a:link {
	color: #333333;
}
.style4 {color: #00447C}
.price {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #00447C;
	padding-left: 6px;
	padding-right: 6px;
	font-weight: bold;
}
.bodycopyunderline {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 12px;
	line-height: 16px;
	color: #333333;
	margin-right: 6px;
	margin-left: 6px;
	text-decoration: underline;
}
.none {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 12px;
	line-height: 16px;
	color: #333333;
}
.head_events {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 16px;
	color: 00447C;
	padding-left: 0px;
}
.bodycopy2 {
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 12px;
	line-height: 16px;
	color: #333333;
	margin-right: 6px;
	margin-left: 0px;
}
-->
</style>
<!-- InstanceBeginEditable name="head" --><style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style5 {color: #FFFFFF}
-->
</style>

<script type="text/javascript">
<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
<!-- InstanceEndEditable -->
<script type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/homer.gif','images/getinvolvedr.gif','images/donater.gif','images/shopr.gif','images/abouttylerr.gif','images/contactr.gif','images/thankyour.gif','images/mediar.gif','images/eventsr.gif')">
<!-- ImageReady Slices (1L2L Website 4.0 imgrdy.psd - Slices: 1, 2, abouttylerr, contactr, donater, getinvolvedr, homer, masthead, shopr, textbottom, thankyour) -->
<!-- InstanceBeginEditable name="mainarea" -->
<table id="Table_01" width="750" height="545" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td height="149" colspan="3" valign="top"><img src="images/1l2l_masthead.gif" width="585" height="149" border="0"></td>
  </tr>
  <tr>
    <td width="24" height="19"><img src="images/1.gif" alt="" width="24" height="18" align="top"></td>
    <td colspan="2" valign="top"><a href="index.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('home','','images/homer.gif',1)"><img src="images/home.gif" name="home" width="42" height="17" border="0"></a><a href="getinvolved.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('get','','images/getinvolvedr.gif',1)"><img src="images/getinvolved.gif" name="get" width="88" height="17" border="0"></a><a href="donate.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('donate','','images/donater.gif',1)"><img src="images/donate.gif" name="donate" width="52" height="17" border="0"></a><a href="shop.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('shop','','images/shopr.gif',1)"><img src="images/shop.gif" name="shop" width="38" height="17" border="0"></a><a href="abouttyler.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('about','','images/abouttylerr.gif',1)"><img src="images/abouttyler.gif" name="about" width="86" height="17" border="0"></a><a href="contact.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('contact','','images/contactr.gif',1)"><img src="images/contact.gif" name="contact" width="60" height="17" border="0"></a><a href="thankyou.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('thank you','','images/thankyour.gif',1)"><img src="images/thankyou.gif" name="thank you" width="72" height="17" border="0"></a><a href="media.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('media','','images/mediar.gif',1)"><img src="images/media.gif" name="media" width="43" height="17" border="0"></a><a href="events.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('events','','images/eventsr.gif',1)"><img src="images/events.gif" name="events" width="53" height="17" border="0"></a><img src="/images/2.gif" width="192" height="17"></td>
  </tr>
  <tr>
    <td height="8" colspan="3" valign="top" bgcolor="#FFFFFF"><img src="images/spacer.gif" width="750" height="7" alt=""></td>
  </tr>
  
  <tr>
    <td rowspan="3"><img src="images/spacer.gif" width="24" height="372" alt=""></td>
    <td width="534" rowspan="2" valign="top"><table width="534" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
      <!--DWLayoutTable-->
      <tr>
        <td width="6" rowspan="2" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td height="145" colspan="5" valign="top"><p class="bodycopy"><span class="head"><br>
            Tyler&rsquo;s &ldquo;Roller Coaster&rdquo; Hike</span></p>
          <p class="headcatalog">Hike Turnout Exceeded Expectations!</p>            
          <p class="bodycopy">Hike registration began one month ago. We had 250 participants register online and 100 came out and registered the morning of the event. The 1L2L team was very excited to culminate our efforts with this hike. Emotions were high and everyone had a great time. </p>
          <p class="bodycopy">We want to thank everyone that participated and volunteered for  the hike. You have made it possible for us to exceed our goal of raising $50,000 for the Habit for Humanity.</p>
          <p class="bodycopy">&nbsp;</p>
          <p class="bodycopy">&nbsp;</p>          </td>
        </tr>
      
      <tr>
        <td height="191" colspan="5" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
      </tr>
      <tr>
        <td height="38" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
        <form action="<?php echo $loginFormAction; ?>" method="POST" name="hikecoordinate" target="_blank">
          <td width="96" nowrap class="mousetype style5"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td width="133" class="mousetype style5"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td width="57" class="mousetype style5"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td width="133" class="mousetype style5"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td width="109" class="mousetype style5"><!--DWLayoutEmptyCell-->&nbsp;</td>
        </form>
      </tr>
      
      <tr>
        <td height="109" colspan="6" valign="top" bgcolor="#DDDDDD"><p>&nbsp;</p>
              <p align="center" class="mousetype"><a href="index.html">HOME</a> | <a href="getinvolved.html">GET INVOLVED</a> | <a href="donate.html">DONATE</a> | <a href="shop.html">SHOP</a> | <a href="abouttyler.html">ABOUT TYLER</a> | <a href="contact.html">CONTACT</a> | <a href="thankyou.html">THANK YOU</a> | <a href="media.html">MEDIA</a> | <a href="events.html">EVENTS</a><br />
                  <br />
            &copy;2007 1Life2Live</p>
          <p align="center" class="mousetype">Website and 1L2L Branding by <a href="http://www.crainassociates.com">Crain Associates</a></p>          </td>
        </tr>
      <tr>
        <td height="45" bgcolor="#DDDDDD"></td>
          <td colspan="5" bgcolor="#DDDDDD"></td>
        </tr>
    </table></td>
    <td width="191" height="381" valign="top" bgcolor="#DDDDDD"><img src="images/progress_diagram.gif" width="192" height="380"></td>
  </tr>
  <tr>
    <td height="492">&nbsp;</td>
  </tr>
  
  
  <tr>
    <td height="41">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<!-- InstanceEndEditable -->
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-1423634-5";
urchinTracker();
</script>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($hikereg);

mysql_free_result($hikecoord);
?>