<?php require_once('Connections/dbcon.php'); ?>
<?php require_once('Connections/cohdb.php'); ?>
<?php require_once('Connections/dbcon.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;
}
}

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;
}
}

$currentPage = $_SERVER["PHP_SELF"];


mysql_select_db($database_dbcon, $dbcon);
$query_Recordset2 = "SELECT * FROM events ORDER BY ID DESC";
$Recordset2 = mysql_query($query_Recordset2, $dbcon) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

mysql_select_db($database_dbcon, $dbcon);
$query_Recordset3 = "SELECT * FROM events ORDER BY ID DESC";
$Recordset3 = mysql_query($query_Recordset3, $dbcon) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);

$maxRows_rsDesc = 3;
$pageNum_rsDesc = 0;
if (isset($_GET['pageNum_rsDesc'])) {
  $pageNum_rsDesc = $_GET['pageNum_rsDesc'];
}
$startRow_rsDesc = $pageNum_rsDesc * $maxRows_rsDesc;

mysql_select_db($database_dbcon, $dbcon);
$query_rsDesc = "SELECT * FROM events ORDER BY id DESC";
$query_limit_rsDesc = sprintf("%s LIMIT %d, %d", $query_rsDesc, $startRow_rsDesc, $maxRows_rsDesc);
$rsDesc = mysql_query($query_limit_rsDesc, $dbcon) or die(mysql_error());
$row_rsDesc = mysql_fetch_assoc($rsDesc);

if (isset($_GET['totalRows_rsDesc'])) {
  $totalRows_rsDesc = $_GET['totalRows_rsDesc'];
} else {
  $all_rsDesc = mysql_query($query_rsDesc);
  $totalRows_rsDesc = mysql_num_rows($all_rsDesc);
}
$totalPages_rsDesc = ceil($totalRows_rsDesc/$maxRows_rsDesc)-1;

mysql_select_db($database_cohdb, $cohdb);
$query_Recordset1 = "SELECT * FROM events ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $cohdb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Our Vision</title>
<style type="text/css">
<!--
body {
	background-image: url(images/home_pg_bg.jpg);
	background-repeat: no-repeat;
}
.li {
      color:#CCCCCC;
	  font-family:Tahoma;
	  font-size:14px;
	  text-decoration:none;
	  }
.li2 {
      color: #0099FF;
	  font-family:Tahoma;
	  font-size:12px;
	  text-decoration:none;
	  }
#apDiv1 {
	position:absolute;
	left:192px;
	top:116px;
	width:631px;
	height:242px;
	z-index:1;
}
#apDiv2 {
	position:absolute;
	left:191px;
	top:403px;
	width:638px;
	height:54px;
	z-index:2;
}
#apDiv3 {
	position:absolute;
	left:129px;
	top:2038px;
	width:756px;
	height:379px;
	z-index:3;
}
#apDiv4 {
	position:absolute;
	left:156px;
	top:1597px;
	width:635px;
	height:478px;
	z-index:4;
}
.style6 {
	color: #000000;
	font-size: xx-large;
	font-style: italic;
	font-family: Arial, Helvetica, sans-serif;
}
.style10 {
	font-size: 12px;
	font-family: Tahoma;
}
#apDiv5 {
	position:absolute;
	left:2px;
	top:766px;
	width:143px;
	height:28px;
	z-index:5;
}
.adminlink {color: #CCCCCC}
#apDiv5 a {
	text-decoration: none;
}
#apDiv5 a {
	font-size: 14px;
	color: #CCCCCC;
}
.style11 {
	color: #CCCCCC;
	font-family: Tahoma;
	font-size: 14px;
}
.btmlink {
	font-size: 9px;
	color: #666666;
	text-decoration: none;
}
-->
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script src="SpryAssets/SpryCollapsiblePanel.js" type="text/javascript"></script>
<script type="text/javascript">
function MM_CheckFlashVersion(reqVerStr,msg){
  with(navigator){
    var isIE  = (appVersion.indexOf("MSIE") != -1 && userAgent.indexOf("Opera") == -1);
    var isWin = (appVersion.toLowerCase().indexOf("win") != -1);
    if (!isIE || !isWin){  
      var flashVer = -1;
      if (plugins && plugins.length > 0){
        var desc = plugins["Shockwave Flash"] ? plugins["Shockwave Flash"].description : "";
        desc = plugins["Shockwave Flash 2.0"] ? plugins["Shockwave Flash 2.0"].description : desc;
        if (desc == "") flashVer = -1;
        else{
          var descArr = desc.split(" ");
          var tempArrMajor = descArr[2].split(".");
          var verMajor = tempArrMajor[0];
          var tempArrMinor = (descArr[3] != "") ? descArr[3].split("r") : descArr[4].split("r");
          var verMinor = (tempArrMinor[1] > 0) ? tempArrMinor[1] : 0;
          flashVer =  parseFloat(verMajor + "." + verMinor);
        }
      }
      // WebTV has Flash Player 4 or lower -- too low for video
      else if (userAgent.toLowerCase().indexOf("webtv") != -1) flashVer = 4.0;

      var verArr = reqVerStr.split(",");
      var reqVer = parseFloat(verArr[0] + "." + verArr[2]);
  
      if (flashVer < reqVer){
        if (confirm(msg))
          window.location = "http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash";
      }
    }
  } 
}
</script>
<link href="SpryAssets/SpryCollapsiblePanel.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style12 {font-family: Tahoma}
.style13 {font-size: 14px}
.style14 {font-size: 12px}
.style17 {font-family: Tahoma; font-weight: bold; }
.style18 {font-size: 10px}
#apDiv8 {
	position:absolute;
	width:200px;
	height:115px;
	z-index:6;
	left: 10px;
	top: 2516px;
}
#apDiv6 {	position:absolute;
	width:138px;
	height:190px;
	z-index:7;
	left: 7px;
	top: 568px;
}
#apDiv9 {	position:absolute;
	width:151px;
	height:32px;
	z-index:9;
	left: 384px;
	top: 36px;
}
.style19 {color: #0099FF}
.style20 {
	font-family: Tahoma;
	font-weight: bold;
	font-size: 36px;
	color: #660000;
}
.style21 {color: #660000}
#apDiv7 {
	position:absolute;
	width:200px;
	height:52px;
	z-index:10;
	left: 620px;
	top: 27px;
}
#apDiv10 {
	position:absolute;
	width:172px;
	height:113px;
	z-index:11;
	left: 327px;
	top: 462px;
}
#apDiv11 {
	position:absolute;
	width:636px;
	height:34px;
	z-index:12;
	left: 191px;
	top: 580px;
}
.style22 {
	font-family: Tahoma;
	font-style: italic;
	font-weight: bold;
}
#apDiv12 {
	position:absolute;
	width:637px;
	height:195px;
	z-index:13;
	left: 191px;
	top: 625px;
}
#apDiv13 {
	position:absolute;
	width:638px;
	height:31px;
	z-index:14;
	left: 190px;
	top: 844px;
}
#apDiv14 {
	position:absolute;
	width:638px;
	height:34px;
	z-index:15;
	left: 189px;
	top: 876px;
}
#apDiv15 {
	position:absolute;
	width:642px;
	height:41px;
	z-index:16;
	left: 187px;
	top: 951px;
}
#apDiv16 {
	position:absolute;
	width:200px;
	height:115px;
	z-index:17;
	left: 215px;
	top: 1019px;
}
#apDiv17 {
	position:absolute;
	width:200px;
	height:115px;
	z-index:18;
	left: 516px;
	top: 1019px;
}
#apDiv18 {
	position:absolute;
	width:618px;
	height:373px;
	z-index:19;
	left: 199px;
	top: 1234px;
}
#apDiv19 {
	position:absolute;
	width:196px;
	height:108px;
	z-index:20;
	left: 515px;
	top: 444px;
}
.style23 {font-family: Tahoma; font-style: italic; font-weight: bold; color: #0033FF; }
.style24 {font-family: Tahoma; font-weight: bold; font-size: 36px; color: #0033FF; }
-->
</style>
</head>

<body onload="MM_CheckFlashVersion('8,0,0,0','Content on this page requires a newer version of Adobe Flash Player. Do you want to download it now?');">
<div style="position:absolute; top:150px; width: 142px; height: 410px;">
  <p><a href="index.php" class="li">Home</a></p>
  <p><a href="mission.html" class="li">Our Mission</a></p>
  <p><a href="ds.html" class="li">Doctrinal Statement</a></p>
  <p class="style11"><a href="Newsletters/newsletter.pdf" class="li">Newsletter</a></p>
  <div id="CollapsiblePanel1" class="CollapsiblePanel">
    <div class="CollapsiblePanelTab style12 style13 adminlink" tabindex="0">Programs</div>
    <div class="CollapsiblePanelContent style12 adminlink style14 li"><br />
      &nbsp;<a href="children.html" class="li2">Groundbreakers</a><br />
    &nbsp;<a href="preteen.html" class="li2">Seeds of Hope</a><br />
    &nbsp;<a href="youth.html" class="li2">Disciples of Hope</a><br />
    &nbsp;<a href="dt.html" class="li2">Drama Team</a><br />
    &nbsp;<a href="pt.html" class="li2">Praise Team</a><br />
    &nbsp;<a href="co.html" class="li2">Community Outreach</a><br />
    &nbsp;<a href="se.html" class="li2">Special Event</a><span class="style19">s</span></div>
  </div>
  <p><a href="vision.html" class="li">Our Vision</a><br />
    <br />
  <a href="contact.php" class="li">Contact Us</a></p>
  <p>&nbsp;</p>
</div>

<div id="apDiv1">
  <p align="center" class="style20">&quot;Our Vision&quot; for the Future</p>
  <p align="center" class="style17"><span class="style21"><img src="images/futuresite.jpg" width="308" height="194" /></span></p>
</div>
<div id="apDiv2">
  <h3 align="center"><span class="style23">Teaching the truths of God’s Word and equipping kids  for daily life.</span><br />
    </h3>
</div>
<div id="apDiv3"><img src="images/Elevation-plans.png" width="783" height="423" /><br />
<br />
</div>
<div id="apDiv4">
  <h1 class="style6"><a name="btm" id="btm"></a><img src="images/COH-floor-plans.png" width="755" height="417" align="top" /><br />
  </h1>
</div>
<div class="style10" id="apDiv5"><a href="admin_menu.php">Administration</a></div>
<br>
<div id="apDiv7"><a href="vo.html"><img src="images/volbtn.png" alt="Click here for volounteering opportunities" width="202" height="50" border="0" /></a></div>
<div id="apDiv10">
  <p align="center" class="style10"><strong><u>Teaching God’s  Word</u></strong><br />
    <br />
    Bible study<br />
    Mentoring<br />
    Accountability</p>
  <p align="center" class="style10"><br />
  </p>
</div>
<div id="apDiv19">
  <div align="center"><span class="style10"><strong><u><br />
    Equipping the  Kids</u></strong><br />
      <br />
    Afterschool Tutoring<br />
    Summer Programs<br />
    Private Christian  School<br />
    College or Career Planning</span></div>
</div>
<p></p>

<div id="apDiv8">
  <table width="966" border="0">
    <tr>
      <td><div align="center"><span class="style21"><a href="index.php" class="btmlink">HOME</a> |<a href="mission.html" class="btmlink"> OUR MISSION</a> |<a href="ds.html" class="btmlink"> DOCTRINAL STATEMENT</a> | <a href="newsletter.html" class="btmlink">NEWSLETTER</a> | <a href="children.html" class="btmlink">CHILDREN</a> |<a href="preteen.html" class="btmlink"> PRETEEN</a> | <a href="youth.html" class="btmlink">YOUTH</a> |<a href="dt.html" class="btmlink"> DRAMA TEAM</a> <a href="pt.html">|</a></span><span class="btmlink"><a href="pt.html" class="btmlink"> PRAISE TEAM</a> </span><span class="style21">| <a href="co.html" class="btmlink">COMMUNITY OUTREACH</a> | <a href="se.html" class="btmlink">SPECIAL EVENTS</a> |<a href="vision.html" class="btmlink"> VISION </a>|<a href="contact.php" class="btmlink"> CONTACT US</a></span></div></td>
    </tr>
    <tr>
      <td><p align="center" class="style21"><span class="style18">ALL RIGHTS RESERVED CHILDREN OF HOPE COPYRIGHT 2009<br />
        CREATED BY</span> <a href="http://www.rdjhome.com" class="btmlink">RDJ GRAPHICS</a> </p></td>
    </tr>
  </table>
</div>
<div id="apDiv6"><img src="images/handprints.png" width="132" height="180" /></div>
<div id="apDiv9"><img src="images/handprints1.png" width="147" height="28" /></div>

<div id="apDiv11">
  <div align="center" class="style22">
    <h3>Helping and equipping “The Church”</h3>
  </div>
</div>
<div id="apDiv12">
  <p align="center" class="style10"><strong><u>Helping</u></strong><br />
    <br />
    By  reaching out to children and youth in our community that are unlikely to <br />
    attend  a Sunday or Wednesday night church service.<br />
    By  providing a facility for equipping “The Church”</p>
  <p align="center" class="style10"><br />
    <strong><u>Equipping</u></strong><br />
    <br />
    Local  mission opportunities<br />
    Local  mission training<br />
    Evangelism  training<br />
    Teacher  training</p>
</div>
<div id="apDiv13">
  <h3 align="center" class="style23">Where are we in the  vision?</h3>
</div>
<div id="apDiv14">
  <h4 align="center"><span class="style12">In June of 2005, Children of Hope  purchased <br />
  12.95 acres for their future home.</span></h4>
</div>
<div id="apDiv15">
  <p align="center" class="style24">Groundbreaking 2006</p>
</div>
<div id="apDiv16"><img src="images/Our Vision/vis1.jpg" width="294" height="214" /></div>
<div id="apDiv17"><img src="images/Our Vision/vis2.jpg" width="287" height="214" /></div>
<div id="apDiv18">
  <p align="center"><span class="style12"><span class="style14"><strong>Where do we go from  here?</strong><br />
    <br />
    Final site plan<br />
    <a href="#btm">Final building plans</a><br />
    Estimates on building project<br />
    Choose a contractor<br />
    Pay the contractor<br />
    Pay the building costs<br />
    Move in<br />
    Teach God’s Word</span><br />
    <span class="style14">Pay the monthly bills</span></span></p>
  <p align="center" class="style12"><strong><u>BE APART OF THE  VISION</u></strong><br />
    <span class="style14">Invest in the lives of our  community’s children and youth.</span><br />
    <br />
  <strong>SUPPORT </strong><br />
  <strong>CHILDREN OF HOPE</strong><br />
    Find out  how:  Click on <a href="vo.html">Volunteer Opportunities</a></p>
</div>
<script type="text/javascript">
<!--
var CollapsiblePanel1 = new Spry.Widget.CollapsiblePanel("CollapsiblePanel1", {contentIsOpen:false});
//-->
</script>
</body>
</html>
<?php
mysql_free_result($Recordset1);

mysql_free_result($Recordset2);

mysql_free_result($Recordset3);

mysql_free_result($rsDesc);
?>