<?php require_once('../Connections/conection.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;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_rsFotos = 16;
$pageNum_rsFotos = 0;
if (isset($_GET['pageNum_rsFotos'])) {
  $pageNum_rsFotos = $_GET['pageNum_rsFotos'];
}
$startRow_rsFotos = $pageNum_rsFotos * $maxRows_rsFotos;

$colname_rsFotos = "-1";
if (isset($_GET['IDAlbum'])) {
  $colname_rsFotos = $_GET['IDAlbum'];
}
mysql_select_db($database_conection, $conection);
$query_rsFotos = sprintf("SELECT * FROM Fotos WHERE IDAlbum = %s", GetSQLValueString($colname_rsFotos, "text"));
$query_limit_rsFotos = sprintf("%s LIMIT %d, %d", $query_rsFotos, $startRow_rsFotos, $maxRows_rsFotos);
$rsFotos = mysql_query($query_limit_rsFotos, $conection) or die(mysql_error());
$row_rsFotos = mysql_fetch_assoc($rsFotos);

if (isset($_GET['totalRows_rsFotos'])) {
  $totalRows_rsFotos = $_GET['totalRows_rsFotos'];
} else {
  $all_rsFotos = mysql_query($query_rsFotos);
  $totalRows_rsFotos = mysql_num_rows($all_rsFotos);
}
$totalPages_rsFotos = ceil($totalRows_rsFotos/$maxRows_rsFotos)-1;

$colname_rsAlbum = "-1";
if (isset($_GET['IDAlbum'])) {
  $colname_rsAlbum = $_GET['IDAlbum'];
}
mysql_select_db($database_conection, $conection);
$query_rsAlbum = sprintf("SELECT * FROM Albuns WHERE IDAlbum = %s", GetSQLValueString($colname_rsAlbum, "int"));
$rsAlbum = mysql_query($query_rsAlbum, $conection) or die(mysql_error());
$row_rsAlbum = mysql_fetch_assoc($rsAlbum);
$totalRows_rsAlbum = mysql_num_rows($rsAlbum);

$maxRows_rsAlbuns = 10;
$pageNum_rsAlbuns = 0;
if (isset($_GET['pageNum_rsAlbuns'])) {
  $pageNum_rsAlbuns = $_GET['pageNum_rsAlbuns'];
}
$startRow_rsAlbuns = $pageNum_rsAlbuns * $maxRows_rsAlbuns;

mysql_select_db($database_conection, $conection);
$query_rsAlbuns = "SELECT * FROM Albuns ORDER BY IDAlbum ASC";
$query_limit_rsAlbuns = sprintf("%s LIMIT %d, %d", $query_rsAlbuns, $startRow_rsAlbuns, $maxRows_rsAlbuns);
$rsAlbuns = mysql_query($query_limit_rsAlbuns, $conection) or die(mysql_error());
$row_rsAlbuns = mysql_fetch_assoc($rsAlbuns);

if (isset($_GET['totalRows_rsAlbuns'])) {
  $totalRows_rsAlbuns = $_GET['totalRows_rsAlbuns'];
} else {
  $all_rsAlbuns = mysql_query($query_rsAlbuns);
  $totalRows_rsAlbuns = mysql_num_rows($all_rsAlbuns);
}
$totalPages_rsAlbuns = ceil($totalRows_rsAlbuns/$maxRows_rsAlbuns)-1;

$queryString_rsAlbuns = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rsAlbuns") == false && 
        stristr($param, "totalRows_rsAlbuns") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rsAlbuns = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rsAlbuns = sprintf("&totalRows_rsAlbuns=%d%s", $totalRows_rsAlbuns, $queryString_rsAlbuns);

$queryString_rsFotos = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rsFotos") == false && 
        stristr($param, "totalRows_rsFotos") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rsFotos = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rsFotos = sprintf("&totalRows_rsFotos=%d%s", $totalRows_rsFotos, $queryString_rsFotos);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>::: Água Cajamar - Transporte de Água Potavel :::</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="layout.css" rel="stylesheet" type="text/css" />
<script src="js/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="js/cufon-yui.js" type="text/javascript"></script>
<script src="js/cufon-replace.js" type="text/javascript"></script>
<script src="js/Zurich_BT_400.font.js" type="text/javascript"></script>
<!--[if lt IE 7]>
	<link href="ie_style.css" rel="stylesheet" type="text/css" />
   <script type="text/javascript" src="js/ie_png.js"></script>
   <script type="text/javascript">
       ie_png.fix('.png, .slogan img, .bg1, .bg2, .bg3');
   </script>
<![endif]-->
<style type="text/css">
body {
	background-image: url();
	background-repeat: no-repeat;
}
.bdTab {	border: 1px solid #463305;
	margin: 30px;
}
.highslide {	cursor: url(highslide/graphics/zoomin.cur) , pointer;
	outline: none;
	text-decoration: none;
	padding: 40px;
}
.highslide-caption {	display: none;
	border-top: none;
	font-size: 1em;
	padding: 5px;
	color: white;
	background: #111;
}
.highslide-image {	border-width: 2px;
	border-style: solid;
	border-color: black black #202020 black;
	background: gray;
}
.style1 {	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 24px;
	margin-left: 30px;
}
.style2 {color: #FFFFFF}
.style3 {	font-family: Geneva, Arial, Helvetica, sans-serif;
	color: #FFFFFF;
	font-size: 10px;
}
.style4 {	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-size: 10px;
}
</style>
</head>

<body id="page1">
<div id="main">
  <!-- header -->
 
  <div id="header">
    <div class="header-bg">
      <div class="container">
      	<!-- .logo -->
      	<div class="logo"><img src="images/logo.png" alt="" width="350" height="150" /></div>
      	<!-- /.logo --><!-- .nav -->
<ul class="nav">
        	<li><a href="index.html" class="v">Início</a></li>
          <li><a href="empresa.html" class="current">Empresa</a></li>
          <li><a href="clientes.html" class="v">Clientes</a></li>
          <li><a href="localizacao.html">Localização</a></li>
          <li><a href="contato.html">Contato</a></li>
        </ul>
        <!-- /.nav -->
        <!-- .slogan -->
        <div class="slogan">
        	<img src="images/slogan.png" alt="" />
        </div>
        <!-- /.slogan -->
        <!-- .extra-nav -->
        <ul class="extra-nav">
        	<li><a href="index.html"><img src="images/icon1.gif" alt="" /></a></li>
          <li><a href="empresa.html"><img src="images/icon2.gif" alt="" /></a></li>
          <li class="last"><a href="contato.html"><img src="images/icon3.gif" alt="" /></a></li>
        </ul>
      <!-- /.extra-nav --></div>
      <p>&nbsp;</p>
    </div>
  </div>
  <!-- aside -->
  <div class="aside"></div>
  <!-- content -->
  <div id="content">
  	<div class="container">
    	<!-- .box -->
    	<div class="box">
      	<div class="right-bot-corner">
        	<div class="left-bot-corner">
        	  <div align="center">
        	    <table width="951" height="139" border="0" align="center">
        	      <tr>
        	        <td width="945"><img src="Imagens/empresa.jpg" alt="" width="948" height="630" /></td>
       	          </tr>
       	        </table>
      	    </div>
            </div>
        </div>
      </div>
    	<!-- /.box -->
    </div>
  </div>
  <!-- footer -->
  <div id="footer">
  	<div class="container">
    	<ul class="nav">
      	<li></li>
   	  </ul>
     <div class="v">&copy; 2012 - aguacajamar.com.br - Todos os direitos reservados </div>
     <div class="vlinks"><a href="http://www.webdesign.org"> design</a> by<a href="mailto:webmaycon@gmail.com"> Maycon</a></div>
    </div>
  </div>
</div>
<script type="text/javascript"> Cufon.now(); </script>
</body>
</html>
<?php
mysql_free_result($rsFotos);

mysql_free_result($rsAlbum);

mysql_free_result($rsAlbuns);
?>