<?php require_once('Connections/conn_LC.php'); ?>
<?php
//WA Database Search Include
require_once("WADbSearch/HelperPHP.php");
?>
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAevents;
//Searchpage: events_Search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search_x"]) && $_GET["Search_x"] != "")) {
  $WADbSearch1 = new FilterDef;
  $WADbSearch1->initializeQueryBuilder("MYSQL","1");
  //keyword array declarations

  //comparison list additions
  $WADbSearch1->addComparisonFromEdit("date","S_date","AND","=",2);
  $WADbSearch1->addComparisonFromEdit("event","S_event","AND","Includes",0);
  $WADbSearch1->addComparisonFromEdit("eventlink","S_eventlink","AND","Includes",0);
  $WADbSearch1->addComparisonFromEdit("supportdocs","S_supportdocs","AND","Includes",0);
  $WADbSearch1->addComparisonFromEdit("closing","S_closing","AND","Includes",0);
  $WADbSearch1->addComparisonFromEdit("id","S_id","AND","=",1);

  //save the query in a session variable
  if (1 == 1) {
    $_SESSION["WADbSearch1_events_Results"]=$WADbSearch1->whereClause;
  }
}
else     {
  $WADbSearch1 = new FilterDef;
  $WADbSearch1->initializeQueryBuilder("MYSQL","1");
  //get the filter definition from a session variable
  if (1 == 1)     {
    if (isset($_SESSION["WADbSearch1_events_Results"]) && $_SESSION["WADbSearch1_events_Results"] != "")     {
      $WADbSearch1->whereClause = $_SESSION["WADbSearch1_events_Results"];
    }
    else     {
      $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
  }
  else     {
    $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
  }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" ); ?>
<?php
if (!WA_Auth_RulePasses("Logged in to admins")){
	WA_Auth_RestrictAccess("accessdenied.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;
}
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
?>
<?php
$maxRows_WADAevents = 365;
$pageNum_WADAevents = 0;
if (isset($_GET['pageNum_WADAevents'])) {
  $pageNum_WADAevents = $_GET['pageNum_WADAevents'];
}
$startRow_WADAevents = $pageNum_WADAevents * $maxRows_WADAevents;

mysql_select_db($database_conn_LC, $conn_LC);
$query_WADAevents = "SELECT id, date, event, eventlink, supportdocs, closing FROM events";
setQueryBuilderSource($query_WADAevents,$WADbSearch1,false);
$query_limit_WADAevents = sprintf("%s LIMIT %d, %d", $query_WADAevents, $startRow_WADAevents, $maxRows_WADAevents);
$WADAevents = mysql_query($query_limit_WADAevents, $conn_LC) or die(mysql_error());
$row_WADAevents = mysql_fetch_assoc($WADAevents);

if (isset($_GET['totalRows_WADAevents'])) {
  $totalRows_WADAevents = $_GET['totalRows_WADAevents'];
} else {
  $all_WADAevents = mysql_query($query_WADAevents);
  $totalRows_WADAevents = mysql_num_rows($all_WADAevents);
}
$totalPages_WADAevents = ceil($totalRows_WADAevents/$maxRows_WADAevents)-1;
?>
<?php
$queryString_WADAevents = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_WADAevents") == false && 
        stristr($param, "totalRows_WADAevents") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_WADAevents = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_WADAevents = sprintf("&totalRows_WADAevents=%d%s", $totalRows_WADAevents, $queryString_WADAevents);
?>
<?php
//WA AltClass Iterator
class WA_AltClassIterator     {
  var $DisplayIndex;
  var $DisplayArray;
  
  function WA_AltClassIterator($theDisplayArray = array(1)) {
    $this->ClassCounter = 0;
    $this->ClassArray   = $theDisplayArray;
  }
  
  function getClass($incrementClass)  {
    if (sizeof($this->ClassArray) == 0) return "";
  	if ($incrementClass) {
      if ($this->ClassCounter >= sizeof($this->ClassArray)) $this->ClassCounter = 0;
      $this->ClassCounter++;
    }
    if ($this->ClassCounter > 0)
      return $this->ClassArray[$this->ClassCounter-1];
    else
      return $this->ClassArray[0];
  }
}
?><?php
//WA Alternating Class
$WARRT_AltClass1 = new WA_AltClassIterator(explode("|", "WADAResultsRowDark|"));
?>
<html><!-- InstanceBegin template="/Templates/pages.dwt" codeOutsideHTMLIsLocked="false" --><head>
<link rel="shortcut icon" href="favicon.ico" >

<!-- InstanceBeginEditable name="doctitle" -->
<title>Results events</title>
<link href="WA_DataAssist/styles/Traditional_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Arial.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.WADAResultsNavigation {
	padding-top: 5px;
	padding-bottom: 10px;
}
.WADAResultsCount {
	font-size: 11px;
}

.WADAResultsNavTop, .WADAResultsInsertButton {
	clear: none;
}
.WADAResultsNavTop {
	width: 60%;
	float: left;
}
.WADAResultsInsertButton {
	width: 30%;
	float: right;
	text-align: right;
}
.WADAResultsNavButtonCell, .WADAResultsInsertButton {
  padding: 2px;
}
.WADAResultsTable {
  font-size: 11px;
  clear: both;
  padding-top: 1px;
	padding-bottom: 1px;
}

.WADAResultsTableHeader, .WADAResultsTableCell {
    padding: 2px;
	text-align: left;
}

.WADAResultsTableHeader {
	padding-left: 3px;
	padding-right: 3px;
}

.WADAResultsTableCell {
	padding-left: 9px;
	padding-right: 9px;
}

.WADAResultsTableCell {
  border-left: 1px solid #BABDC2;
}

.WADAResultsEditButtons {
  border-left: 1px solid #BABDC2;
  border-right: 1px solid #BABDC2;
}

.WADAResultsRowDark {
  background-color: #DFE4E9;
}
</style>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>

<link href="styles/pagestyle.css" rel="stylesheet" type="text/css">

</head>

<body>
<div id="Layer1" style="position:absolute; width:160px; height:100px; z-index:1; left: 10px; top: 145px;"> 
   <p> <a href="/index.php"><font size="2">Home</font></a> <br>
    <br>
	<font size="2"><a href="/calendar.php">Calendar</a></font><br>
    <br>
    <a href="/lessons.htm"><font size="2">Lessons</font></a> <br>
    <br>
    <a href="/quadrille.htm"><font size="2">Quadrille Teams</font></a><br>
    <br>
    <a href="/boarding.htm"><font size="2">Boarding</font></a><br> 
    <br>   
    <a href="/training.htm"><font size="2">Training</font></a> <br>
    <br>
    <a href="/employment.htm"><font size="2">Employment</font> </a><br>
    <br>
    <a href="/contact.htm"><font size="2">Contact Us</font></a> <br>
    <br>
    <a href="/directions.htm"><font size="2">Directions</font></a> <br>
    <br>
    <a href="/farmhours.htm"><font size="2">Barn Hours</font></a><br>
    <br>
    <a href="photos/index.htm"><font size="2">Photo Album</font></a><br>
    <br>
    <a href="/forsale.php"><font size="2">For Sale/Lease</font></a><br>
    <br>
    <a href="articles/bay_weekly.htm"><font size="2">Articles</font></a><br>
    <br>
    <a href="/groupactivities.htm"><font size="2">Group Activities</font></a><br>
    <br>
    <font size="2"><a href="/summerprog.htm">Summer Riding Program</a></font><br></p>
</div>
<table width="98%" border="0">
  <tr> 
    <td width="10%"><img src="/images/Farmlogo_newName.gif" width="125" height="102"></td>
    <td width="2%">&nbsp;</td>
    <td width="98%"><!-- InstanceBeginEditable name="top" --> 
      <table width="98%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td>&nbsp;</td>
        </tr>
      </table>
      <!-- InstanceEndEditable --></td>
  </tr>
</table> 
<br>
<br>
<table width="98%" border="0">
  <tr>
    <td width="19%">&nbsp;</td>
    <td width="81%"><!-- InstanceBeginEditable name="body" -->
<table width="98%" border="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>


<div class="WADAResultsContainer"> <a name="top"></a>
  <?php if ($totalRows_WADAevents > 0) { // Show if recordset not empty ?>
      <div class="WADAResults">
        <div class="WADAResultsNavigation">
          <div class="WADAResultsCount">Records
            <?php echo ($startRow_WADAevents + 1) ?>
            to
            <?php echo min($startRow_WADAevents + $maxRows_WADAevents, $totalRows_WADAevents) ?>
            of
            <?php echo $totalRows_WADAevents ?>
          </div>
          <div class="WADAResultsNavTop">
            <table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
              <tr valign="middle">
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents > 0) { // Show if not first page ?><span id="First" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, 0, $queryString_WADAevents); ?>">First</a>
                </span><?php } // Show if not first page ?></td>
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents > 0) { // Show if not first page ?><span id="Previous" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, max(0, $pageNum_WADAevents - 1), $queryString_WADAevents); ?>">Previous</a>
                </span><?php } // Show if not first page ?></td>
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents < $totalPages_WADAevents) { // Show if not last page ?><span id="Next" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, min($totalPages_WADAevents, $pageNum_WADAevents + 1), $queryString_WADAevents); ?>">Next</a>
                </span><?php } // Show if not last page ?></td>
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents < $totalPages_WADAevents) { // Show if not last page ?><span id="Last" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, $totalPages_WADAevents, $queryString_WADAevents); ?>">Last</a>
                </span><?php } // Show if not last page ?></td>
              </tr>
            </table>
          </div>
          <div class="WADAResultsInsertButton"> <span id="Insert" class="WADATextButton"><a href="events_Insert.php">Insert</a></span> </div>
        </div>
        <table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <th class="WADAResultsTableHeader">Date and time of event (YYYY-MM-DD HH:MM):</th>
            <th class="WADAResultsTableHeader">Event Title:</th>
            <th class="WADAResultsTableHeader">Link to organizer:</th>
            <th class="WADAResultsTableHeader">Any document that is needed in support of event:</th>
            <th class="WADAResultsTableHeader">Final closing info (Standings, Thank you notes, etc..):</th>
            <th>&nbsp;</th>
          </tr>
          <?php do { ?>
            <tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
              <td class="WADAResultsTableCell"><?php echo($row_WADAevents['date']); ?></td>
              <td class="WADAResultsTableCell"><?php echo($row_WADAevents['event']); ?></td>
              <td class="WADAResultsTableCell"><a href="<?php echo($row_WADAevents['eventlink']); ?>" target="_blank"><?php echo($row_WADAevents['eventlink']); ?></a></td>
              <td class="WADAResultsTableCell"><a href="MiscDocs/<?php echo($row_WADAevents['supportdocs']); ?>" target="_blank"><?php echo($row_WADAevents['supportdocs']); ?></a></td>
              <td class="WADAResultsTableCell"><a href="MiscDocs/<?php echo($row_WADAevents['closing']); ?>"><?php echo($row_WADAevents['closing']); ?></a></td>
              <td class="WADAResultsEditButtons" nowrap="nowrap"><table class="WADAEditButton_Table">
                <tr>
                  <td><span id="View<?php echo(rawurlencode($row_WADAevents['id'])); ?>" class="WADATextButton"><a href="events_Detail.php?id=<?php echo(rawurlencode($row_WADAevents['id'])); ?>">View</a></span></td>
                  <td><span id="Update<?php echo(rawurlencode($row_WADAevents['id'])); ?>" class="WADATextButton"><a href="events_Update.php?id=<?php echo(rawurlencode($row_WADAevents['id'])); ?>">Update</a></span></td>
                  <td><span id="Delete<?php echo(rawurlencode($row_WADAevents['id'])); ?>" class="WADATextButton"><a href="events_Delete.php?id=<?php echo(rawurlencode($row_WADAevents['id'])); ?>">Delete</a></span></td>
                </tr>
              </table></td>
            </tr>
          <?php } while ($row_WADAevents = mysql_fetch_assoc($WADAevents)); ?>
        </table>
        <div class="WADAResultsNavigation">
          <div class="WADAResultsCount">Records
            <?php echo ($startRow_WADAevents + 1) ?>
            to
            <?php echo min($startRow_WADAevents + $maxRows_WADAevents, $totalRows_WADAevents) ?>
            of
            <?php echo $totalRows_WADAevents ?>
          </div>
          <div class="WADAResultsNavBottom">
            <table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
              <tr valign="middle">
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents > 0) { // Show if not first page ?><span id="First1" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, 0, $queryString_WADAevents); ?>">First</a>
                </span><?php } // Show if not first page ?></td>
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents > 0) { // Show if not first page ?><span id="Previous1" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, max(0, $pageNum_WADAevents - 1), $queryString_WADAevents); ?>">Previous</a>
                </span><?php } // Show if not first page ?></td>
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents < $totalPages_WADAevents) { // Show if not last page ?><span id="Next1" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, min($totalPages_WADAevents, $pageNum_WADAevents + 1), $queryString_WADAevents); ?>">Next</a>
                </span><?php } // Show if not last page ?></td>
                <td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAevents < $totalPages_WADAevents) { // Show if not last page ?><span id="Last1" class="WADATextButton">
                  <a href="<?php printf("%s?pageNum_WADAevents=%d%s", $currentPage, $totalPages_WADAevents, $queryString_WADAevents); ?>">Last</a>
                </span><?php } // Show if not last page ?></td>
              </tr>
            </table>
          </div>
        </div>
      </div>
  <?php } // Show if recordset not empty ?>
    <?php if ($totalRows_WADAevents == 0) { // Show if recordset empty ?>
      <div class="WADANoResults">
        <div class="WADANoResultsMessage">No results for your search</div>
        <div> <span id="Insert1" class="WADATextButton"><a href="events_Insert.php">Insert</a></span> </div>
      </div>
    <?php } // Show if recordset empty ?>
</div>
<!-- InstanceEndEditable --></td>
  </tr>
</table>
<div align="right"><font size="1" face="Arial, Helvetica, sans-serif">Site Managed 
  By: <script language="JavaScript">
document.write('<a h'+'ref="m'+'ailt'+'o:'+'%66%6f%6c%6c%6f%77%79%6f%75%72%64%72%65%61%6d%73%66%61%72%6d%40%63%6f%6d%63%61%73%74%2e%6e%65%74">&#70;&#111;&#108;&#108;&#111;&#119;&#32;&#89;&#111;&#117;&#114;&#32;&#68;&#114;&#101;&#97;&#109;&#115;<\/a>');
</script> 

</font> </div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($WADAevents);
?>