<?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>News Letter</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:482px;
	top:375px;
	width:343px;
	height:272px;
	z-index:2;
}
#apDiv3 {
	position:absolute;
	left:193px;
	top:428px;
	width:281px;
	height:286px;
	z-index:3;
}
#apDiv4 {
	position:absolute;
	left:193px;
	top:374px;
	width:283px;
	height:52px;
	z-index:4;
}
#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}
.style18 {font-size: 10px}
#apDiv8 {
	position:absolute;
	width:200px;
	height:115px;
	z-index:6;
	left: 1px;
	top: 849px;
}
#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}
#apDiv7 {
	position:absolute;
	width:200px;
	height:54px;
	z-index:10;
	left: 755px;
	top: 25px;
}
-->
</style>
<script src="Scripts/AC_ActiveX.js" type="text/javascript"></script>
</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="newsletter.html" 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="omp.html" class="li">Our Ministry Partners</a><br />
    <br />
  <a href="contact.php" class="li">Contact Us</a></p>
  <p>&nbsp;</p>
</div>

<div id="apDiv1">
  
<embed src="newsletter.pdf" width="780" height="730">
</div>

  </p>
</div>
<div class="li" id="apDiv5"><a href="admin_menu.php" class="li">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>
<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>
<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);
?>