<?php require_once('Connections/Ted.php'); ?>
<?php
$maxRows_rsNews = 1;
$pageNum_rsNews = 0;
if (isset($_GET['pageNum_rsNews'])) {
  $pageNum_rsNews = $_GET['pageNum_rsNews'];
}
$startRow_rsNews = $pageNum_rsNews * $maxRows_rsNews;

$colname_rsNews = "1";
if (isset($_GET['1'])) {
  $colname_rsNews = (get_magic_quotes_gpc()) ? $_GET['1'] : addslashes($_GET['1']);
}
mysql_select_db($database_Ted, $Ted);
$query_rsNews = sprintf("SELECT * FROM homepage WHERE id = %s ORDER BY id ASC", $colname_rsNews);
$query_limit_rsNews = sprintf("%s LIMIT %d, %d", $query_rsNews, $startRow_rsNews, $maxRows_rsNews);
$rsNews = mysql_query($query_limit_rsNews, $Ted) or die(mysql_error());
$row_rsNews = mysql_fetch_assoc($rsNews);

if (isset($_GET['totalRows_rsNews'])) {
  $totalRows_rsNews = $_GET['totalRows_rsNews'];
} else {
  $all_rsNews = mysql_query($query_rsNews);
  $totalRows_rsNews = mysql_num_rows($all_rsNews);
}
$totalPages_rsNews = ceil($totalRows_rsNews/$maxRows_rsNews)-1;

mysql_select_db($database_Ted, $Ted);
$query_reSocial = "SELECT * FROM social_events ORDER BY `date` DESC";
$reSocial = mysql_query($query_reSocial, $Ted) or die(mysql_error());
$row_reSocial = mysql_fetch_assoc($reSocial);
$totalRows_reSocial = mysql_num_rows($reSocial);

mysql_select_db($database_Ted, $Ted);
$query_rsgalleryRandom = "SELECT filename, title FROM team_gallery WHERE teamID = 9910 ORDER BY RAND()";
$rsgalleryRandom = mysql_query($query_rsgalleryRandom, $Ted) or die(mysql_error());
$row_rsgalleryRandom = mysql_fetch_assoc($rsgalleryRandom);
$totalRows_rsgalleryRandom = mysql_num_rows($rsgalleryRandom);

mysql_select_db($database_Ted, $Ted);
$query_rsTraining = "SELECT * FROM training ORDER BY id ASC";
$rsTraining = mysql_query($query_rsTraining, $Ted) or die(mysql_error());
$row_rsTraining = mysql_fetch_assoc($rsTraining);
$totalRows_rsTraining = mysql_num_rows($rsTraining);

mysql_select_db($database_Ted, $Ted);
$query_rsReporter = "SELECT newsheading, news FROM homepage WHERE id = 5";
$rsReporter = mysql_query($query_rsReporter, $Ted) or die(mysql_error());
$row_rsReporter = mysql_fetch_assoc($rsReporter);
$totalRows_rsReporter = mysql_num_rows($rsReporter);

mysql_select_db($database_Ted, $Ted);
$query_rsAdvert1 = "SELECT * FROM adverts WHERE ID = 1 ORDER BY ID ASC";
$rsAdvert1 = mysql_query($query_rsAdvert1, $Ted) or die(mysql_error());
$row_rsAdvert1 = mysql_fetch_assoc($rsAdvert1);
$totalRows_rsAdvert1 = mysql_num_rows($rsAdvert1);

mysql_select_db($database_Ted, $Ted);
$query_rsAdvert2 = "SELECT * FROM adverts WHERE ID = 2 ORDER BY ID ASC";
$rsAdvert2 = mysql_query($query_rsAdvert2, $Ted) or die(mysql_error());
$row_rsAdvert2 = mysql_fetch_assoc($rsAdvert2);
$totalRows_rsAdvert2 = mysql_num_rows($rsAdvert2);

mysql_select_db($database_Ted, $Ted);
$query_rsAdvert3 = "SELECT * FROM adverts WHERE ID = 3 ORDER BY ID ASC";
$rsAdvert3 = mysql_query($query_rsAdvert3, $Ted) or die(mysql_error());
$row_rsAdvert3 = mysql_fetch_assoc($rsAdvert3);
$totalRows_rsAdvert3 = mysql_num_rows($rsAdvert3);

mysql_select_db($database_Ted, $Ted);
$query_rsAdvert4 = "SELECT * FROM adverts WHERE ID = 4 ORDER BY ID ASC";
$rsAdvert4 = mysql_query($query_rsAdvert4, $Ted) or die(mysql_error());
$row_rsAdvert4 = mysql_fetch_assoc($rsAdvert4);
$totalRows_rsAdvert4 = mysql_num_rows($rsAdvert4);

mysql_select_db($database_Ted, $Ted);
$query_rsAdvert5 = "SELECT * FROM adverts WHERE ID = 5 ORDER BY ID ASC";
$rsAdvert5 = mysql_query($query_rsAdvert5, $Ted) or die(mysql_error());
$row_rsAdvert5 = mysql_fetch_assoc($rsAdvert5);
$totalRows_rsAdvert5 = mysql_num_rows($rsAdvert5);

mysql_select_db($database_Ted, $Ted);
$query_rsAdvert6 = "SELECT * FROM adverts WHERE ID = 6 ORDER BY ID ASC";
$rsAdvert6 = mysql_query($query_rsAdvert6, $Ted) or die(mysql_error());
$row_rsAdvert6 = mysql_fetch_assoc($rsAdvert6);
$totalRows_rsAdvert6 = mysql_num_rows($rsAdvert6);

mysql_select_db($database_Ted, $Ted);
$query_rsJoin = "SELECT * FROM homepage WHERE id = 6";
$rsJoin = mysql_query($query_rsJoin, $Ted) or die(mysql_error());
$row_rsJoin = mysql_fetch_assoc($rsJoin);
$totalRows_rsJoin = mysql_num_rows($rsJoin);

mysql_select_db($database_Ted, $Ted);
$query_rsClubCaptain = "SELECT * FROM homepage WHERE id = 7";
$rsClubCaptain = mysql_query($query_rsClubCaptain, $Ted) or die(mysql_error());
$row_rsClubCaptain = mysql_fetch_assoc($rsClubCaptain);
$totalRows_rsClubCaptain = mysql_num_rows($rsClubCaptain);

mysql_select_db($database_Ted, $Ted);
$query_rsJuniors = "SELECT * FROM homepage WHERE id = 2";
$rsJuniors = mysql_query($query_rsJuniors, $Ted) or die(mysql_error());
$row_rsJuniors = mysql_fetch_assoc($rsJuniors);
$totalRows_rsJuniors = mysql_num_rows($rsJuniors);

function makeStamp($theString) {
  if (ereg("([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})", $theString, $strReg)) {
    $theStamp = mktime($strReg[4],$strReg[5],$strReg[6],$strReg[2],$strReg[3],$strReg[1]);
  } else if (ereg("([0-9]{4})-([0-9]{2})-([0-9]{2})", $theString, $strReg)) {
    $theStamp = mktime(0,0,0,$strReg[2],$strReg[3],$strReg[1]);
  } else if (ereg("([0-9]{2}):([0-9]{2}):([0-9]{2})", $theString, $strReg)) {
    $theStamp = mktime($strReg[1],$strReg[2],$strReg[3],0,0,0);
  }
  return $theStamp;
}

function makeDateTime($theString, $theFormat) {
  $theDate=date($theFormat, makeStamp($theString));
  return $theDate;
} 
?>
<?php require_once('ScriptLibrary/thumbs.php'); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>  Teddington Hockey Club</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
	background-attachment: fixed;
	background-color: #FFFFFF;
	background-image: url(images/hock_01.gif);
	background-repeat: no-repeat;
	background-position: 50px 100px;
}
-->
</style>
<link href="ted.css" rel="stylesheet" type="text/css">
<!--#include virtual="menu_studio/head_menu_studio.inc" -->
<? include ("menu_studio/head_menu_studio.inc") ?>
<style type="text/css">
<!--
.style7 {font-size: 18px}
-->
</style>
</head>
<body bgcolor="#FFFFFF" background="hockey.jpg">
<table width="805" height="100" border="0" align="left" cellpadding="0" cellspacing="0">
   <tr>
    <td><table width="805" height="100" border="0" align="left" cellpadding="0" cellspacing="0" dwcopytype="CopyTableRow">
      <tr>
        <td width="805" align="center" valign="top"><table width="805" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="805" align="center" valign="top"><table width="805" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td><img src="images/dot.gif" width="5" height="5"></td>
              <td align="left" valign="top"><table width="803" height="58" align="center" cellpadding="10" cellspacing="0" bgcolor="#000000">
                  <tr>
                    <td align="left" valign="top" bgcolor="#3A2217"><table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
                        <tr>
                          <td width="328"><font color="#FFCCCC" size="+2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FBE3F2">Teddington Hockey Club<br>
                          </font></strong></font><font color="#FBE3F2" size="1" face="Verdana, Arial, Helvetica, sans-serif">Since 1871</font><font color="#FFCCCC" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong> </strong></font></td>
                          <td width="435" align="left" valign="top"><img src="images/dot.gif" width="400" height="10" align="left"><img src="images/smalltree.gif" width="41" height="50" border="0" align="right" usemap="#backdoor"></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td align="left" valign="top">&nbsp;</td>
            </tr>
        </table></td>
  </tr>
        </table>
		</td>
      </tr>
    </table>
      <map name="backdoorMap">
        <area shape="rect" coords="22,38,34,54" href="admin/admin.php">
      </map>
     <img src="images/dot.gif" width="10" height="3"></td>
  </tr>
  <tr> 
    <td></td>
  </tr>
  <tr> 
    <td width="805" align="left" valign="top"><table width="810" height="259" border="0" align="left" cellpadding="5" cellspacing="0">
      <tr align="left" valign="bottom">
        <td width="209" height="260" rowspan="2" valign="top" class="style2 style7">Error: Page not found </td>
        <td width="265" height="29" valign="top" class="style4">You may wish to try one of the following links:</td>
        <td width="301" height="260" rowspan="2">&nbsp;          </td>
      </tr>
      <tr align="left" valign="bottom">
        <td valign="top"><p><a href="http://www.teddingtonhc.com">Teddington Homepage<br>
              </a><span class="style4">Go to the Teddington Hockey club Homepage<br>
              <br>
              <a href="http://www.fixs.co.uk/view/clubsteams.asp?ClubID=13">Fixture live</a><br>
              Go to the fixturesite live site </span><span class="style4"><br>
              </span><span class="style4"><br>
              <a href="mailto:Eventsinfo@teddingtonhc.com">Broken link?</a><br>
          Send us an e-mail.</span></p>
          </td>
      </tr>
    </table></td>
  </tr>
  <tr> 
    <td width="805" align="left" valign="top"> <table width="800" height="136" border="0" align="left" cellpadding="5" cellspacing="0">
        <tr> 
          <td width="302">&nbsp; </td>
          <td width="302" align="left" valign="top">&nbsp; </td>
          <td width="302" align="left" valign="top">&nbsp; </td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td align="left" valign="top">&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="800" border="0" align="left" cellpadding="5" cellspacing="0">
        <tr> 
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td> <table width="805" border="0" align="left" cellpadding="3" cellspacing="0">
        <tr>
          <td><table width="800" height="20" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#4B2424">
              <tr> 
                <td bgcolor="#b0778f"><img src="images/dot.gif" width="10" height="5"><font color="#FBE3F2" size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="mailto:info@teddingtonhc.com">info@teddingtonhc.com</a></font></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<map name="backdoor">
  <area shape="rect" coords="22,38,34,54" href="admin/admin.php">
</map>
</body>
</html>
<?php
mysql_free_result($rsNews);

mysql_free_result($reSocial);

mysql_free_result($rsgalleryRandom);

mysql_free_result($rsTraining);

mysql_free_result($rsReporter);

mysql_free_result($rsAdvert1);

mysql_free_result($rsAdvert2);

mysql_free_result($rsAdvert3);

mysql_free_result($rsAdvert4);

mysql_free_result($rsAdvert5);

mysql_free_result($rsAdvert6);

mysql_free_result($rsJoin);

mysql_free_result($rsClubCaptain);

mysql_free_result($rsJuniors);
?>