<?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>Drama Team</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:94px;
	width:631px;
	height:302px;
	z-index:1;
}
#apDiv2 {
	position:absolute;
	left:520px;
	top:424px;
	width:302px;
	height:294px;
	z-index:2;
}
#apDiv3 {
	position:absolute;
	left:194px;
	top:325px;
	width:628px;
	height:555px;
	z-index:3;
}
#apDiv4 {
	position:absolute;
	left:354px;
	top:666px;
	width:283px;
	height:52px;
	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: -4px;
	top: 1245px;
}
#apDiv6 {
	position:absolute;
	width:138px;
	height:190px;
	z-index:7;
	left: 9px;
	top: 560px;
}
#apDiv9 {	position:absolute;
	width:151px;
	height:32px;
	z-index:9;
	left: 384px;
	top: 36px;
}
#apDiv7 {
	position:absolute;
	width:515px;
	height:115px;
	z-index:10;
	left: 252px;
	top: 879px;
}
#apDiv10 {
	position:absolute;
	width:515px;
	height:115px;
	z-index:11;
	left: 243px;
	top: 976px;
}
.style19 {
	font-family: Tahoma;
	font-weight: bold;
	font-size: 24px;
	color: #0099FF;
}
.style21 {color: #0099FF}
#apDiv11 {
	position:absolute;
	width:200px;
	height:52px;
	z-index:11;
	top: 25px;
	left: 619px;
}
-->
</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>
  <div id="apDiv10">
    <p align="center"><strong><em>1 Peter 3:15 –  Sanctify in your hearts Christ in Lord; Being ready always to give answer to  every man that asks you, a reason concerning the hope that is in you, yet with  meekness and fear.</em></strong><strong> </strong></p>
  </div>
  <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="style21">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">
  <p class="style19">Children of Hope - Drama Team</p>
  <p class="style10">At  Children of Hope dramas are used to bring the Word alive and illustrate  messages from scriptures. Drama  is an avenue for kids to learn and express the Word through dramatic  interpretation.  The Drama Team is also used  as an outreach to introduce Children of Hope to the community.  Children of Hope’s Drama Team has visited  many local churches, as well as, ventured out of town and to out of state  churches. The  Drama Team is comprised of kids of various ages who have a heart for God and  want to send a message to others about the hope that is within them.  They love to reach out with Godly guidance to  other youth on real life topics they face today. 
    We  have made up skits and done dramatic interpretations to songs that have touched  the hearts and lives of many people including our own.  Some songs include:  “I Can Only Imagine,” “Thank you,” “The  Thief,”  “Smellin’ Coffee,”  “You Raise Me Up,” and “The Healer” just to  name a few of our favorite and most memorable ones.  Our most popular skit was called:  “Ugly Louise.”</p>
  <p align="center" class="style17">&nbsp;</p>
</div>
<div id="apDiv2">
  <h3>&nbsp;</h3>
</div>
<div id="apDiv3">
  <div align="center"><img src="images/Drama Team/drama2.jpg" width="300" height="279" /><img src="images/Drama Team/drama3.jpg" width="300" height="278" /><span class="style6"><img src="images/Drama Team/drama1.jpg" width="300" height="266" /></span></div>
</div>
<div class="style10" id="apDiv5"><a href="admin_menu.php">Administration</a></div>
<br>
<div id="apDiv11"><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>

<div id="apDiv7">
  <p align="center"><span class="style12"><strong>Pictures from our VERY FIRST drama - December  2001</strong><br />
    <strong>Children of Hope kids telling the true story  of the birth of Christ</strong><strong> on the streets  in Morristown’s  Governmental Housing Apartments</strong></span></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);
?>