Places.php | searchcode

/Places.php

https://github.com/Elieser/choosing-guides
PHP | 310 lines | 261 code | 38 blank | 11 comment | 54 complexity | 8634372a8d98882a4e81800a97c47f1d MD5 | raw file

<?php require_once('Connections/ChoosingGuidesConnection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $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_Places = 10;
$pageNum_Places = 0;

if (isset($_GET['pageNum_Places'])) {
  $pageNum_Places = $_GET['pageNum_Places'];
}

$startRow_Places = $pageNum_Places * $maxRows_Places;


$WebLanguage_Places = "-1";
if (isset($_POST['weblanguage'])) {
  $WebLanguage_Places = $_POST['weblanguage'];
}
else
{
	if (isset($_SESSION['MM_WebLanguageId'])){
	$WebLanguage_Places = $_SESSION['MM_WebLanguageId'];
	}
	}
	
$country_Places = "";
if (isset($_POST['country']) && $_POST['country']!='0') {
  $country_Places = 'AND tblplaces.CountryId='.$_POST['country'];
}
else
{
	if (isset($_SESSION['MM_CountryId']) && $_SESSION['MM_CountryId']!='0'){
	$country_Places = ' AND tblplaces.CountryId='.$_SESSION['MM_CountryId'];
	}
	}


$state_Places = "";
if (isset($_POST['state']) && $_POST['state']!='0') {
  $state_Places = ' AND tblplaces.StateId='.$_POST['state'];
}
else
{
	if (isset($_SESSION['MM_StateId']) && $_SESSION['MM_StateId']!='0'){
	$state_Places = ' AND tblplaces.StateId='.$_SESSION['MM_StateId'];
	}
	}

$location_Places = "";
if (isset($_POST['location']) && $_POST['location']!='0') {
  $location_Places = ' AND tblplaces.LocationId='.$_POST['location'];
}
else
{
	if (isset($_SESSION['MM_LocationId']) && $_SESSION['MM_LocationId']!='0'){
	$location_Places = ' AND tblplaces.LocationId='.$_SESSION['MM_LocationId'];
	}
	}

$word_Places = "";
if (isset($_POST['wordfilter'])) {
  $word_Places = $_POST['wordfilter'];
}
else
{
	if (isset($_SESSION['MM_Word'])){
		$word_Places =$_SESSION['MM_Word'];
	}
}

$sorted_Places = "1";
$SortId=0;
if (isset($_POST['queryorder'])){
	$SortId=$_POST['queryorder'];
}
else
{
	if (isset($_SESSION['MM_SortId'])) {
		$SortId=$_SESSION['MM_SortId'];
	}
	}

	switch ($SortId){ 
	case 0: $sorted_Places = "Rand()";
	break;
	case 1: $sorted_Places = "ClickCounter DESC";
	break;
	case 2: $sorted_Places = "1";
	break;
	case 3: $sorted_Places = "(select count(*) from tblplacescomments where PlaceId=tblplaces.PlaceId) DESC";
	break;
	case 4: $sorted_Places = "(select round(avg(Points),2) from tblplacescomments where PlaceId=tblplaces.PlaceId) DESC";
	break;
	}

mysql_select_db($database_ChoosingGuidesConnection, $ChoosingGuidesConnection);
$query_Places = sprintf("SELECT tblplaces.PlaceId, tblplacesdet.WebLanguageId, tblplaces.CountryId, tblplaces.StateId, tblplaces.LocationId, tblplacesdet.PlaceName, CONVERT(tblplacesdet.PlaceDesc, char(290)) AS PlaceDesc, tblplacespictures.PictureName, tblplacespictures.PicturePath,
(select round(avg(Points),2) from tblplacescomments where PlaceId=tblplaces.PlaceId) as avgPoints,
(select count(*) from tblplacescomments where PlaceId=tblplaces.PlaceId) as countPoints
FROM tblplaces LEFT OUTER JOIN tblplacespictures ON tblplaces.PlaceId = tblplacespictures.PlaceId LEFT OUTER JOIN tblplacesdet ON tblplaces.PlaceId = tblplacesdet.PlaceId WHERE WebLanguageId = %s %s %s %s AND (tblplacesdet.PlaceName like %s or tblplacesdet.PlaceDesc like %s) GROUP BY tblplaces.PlaceId ORDER BY %s", GetSQLValueString($WebLanguage_Places, "int"),$country_Places,$state_Places,$location_Places,GetSQLValueString("%" . $word_Places . "%", "text"),GetSQLValueString("%" . $word_Places . "%", "text"),$sorted_Places);


$query_limit_Places = sprintf("%s LIMIT %d, %d", $query_Places, $startRow_Places, $maxRows_Places);
$Places = mysql_query($query_limit_Places, $ChoosingGuidesConnection) or die(mysql_error());
$row_Places = mysql_fetch_assoc($Places);


/*if (isset($_GET['totalRows_Places'])) {
  $totalRows_Places = $_GET['totalRows_Places'];
} else {*/
  $all_Places = mysql_query($query_Places);
  $totalRows_Places = mysql_num_rows($all_Places);
  $_GET['totalRows_Places']=mysql_num_rows($all_Places);
  
//}
$totalPages_Places = ceil($totalRows_Places/$maxRows_Places)-1;

$queryString_Places = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Places") == false && 
        stristr($param, "totalRows_Places") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Places = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Places = sprintf("&totalRows_Places=%d%s", $totalRows_Places, $queryString_Places);


if ($pageNum_Places > $totalPages_Places) {
 $PrimeraPag = $currentPage."?pageNum_Places=0&totalRows_Places=".$totalRows_Places;
 
  header(sprintf("Location: %s", $PrimeraPag));
}
?>
<!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"><!-- InstanceBegin template="/Templates/GlobalTemplate.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head><link rel="Shortcut Icon" href="images/cg.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Choosing Guides</title>
<!-- InstanceEndEditable -->
<link href="CSS/twoColLiqLtHdr.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<!--[if lte IE 7]>
<style>
.content { margin-right: -1px; } /* this 1px negative margin can be placed on any of the columns in this layout with the same corrective effect. */
ul.nav a { zoom: 1; }  /* the zoom property gives IE the hasLayout trigger it needs to correct extra whiltespace between the links */
</style>
<![endif]-->
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
</head>
<body bgcolor="#D2D2FF">
<div class="container">
  <div class="header">
  <div class="logo">
  <a href="Index.php"><img src="images/LogoChoosingGuides.gif" alt="Logo" name="logo" width="300" height="100" class="logo" id="logo" style="background-color: #8090AB; display:block;" /></a> 
    <!-- end .header -->
    </div>
    <div class="weblanguage">
    <?php 
//if (is_file("Includes/SelectLanguage.php"))
//{
include ("Includes/SelectLanguage.php");
/*}
else
{
	include ("../Includes/SelectLanguage.php");
	}*/
?>

    </div>
  </div>
  <div class="menu">
    <ul id="MenuBar1" class="MenuBarHorizontal">
      <li><a href="#">Guides</a></li>
      <li><a href="#">Travel Agencies</a></li>
      <li><a href="Tours.php">Tours</a></li>
      <li><a href="Places.php">Interesting Places</a></li>
    </ul>
  </div> 
  <div class="content"><!-- InstanceBeginEditable name="Body" -->
  

    
    <?php 
	include ("Includes/filter.php");
	if (mysql_num_rows($all_Places)==0)
	{
	echo "No Results were found ...";	
		}
		else
		{
	?>
    
    <table border="0" align="right">
      <tr>
        <td>Found <?php echo mysql_num_rows($all_Places)?>  Results</td>
        <td width="460">&nbsp;</td>
       
        <td><?php if ($pageNum_Places > 0) { // Show if not first page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, 0, $queryString_Places); ?>"><img src="images/First.gif" /></a>
        <?php } else {?><img src="images/First_disable.gif" /> <?php } // Show if not first page ?></td>
        <td><?php if ($pageNum_Places > 0) { // Show if not first page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, max(0, $pageNum_Places - 1), $queryString_Places); ?>"><img src="images/Previous.gif" /></a>
        <?php } else {?><img src="images/Previous_disable.gif" /> <?php } // Show if not first page ?></td>
        <td><?php echo $pageNum_Places+1 ?> of <?php echo $totalPages_Places+1 ?></td>
        <td><?php if ($pageNum_Places < $totalPages_Places) { // Show if not last page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, min($totalPages_Places, $pageNum_Places + 1), $queryString_Places); ?>"><img src="images/Next.gif" /></a>
            <?php } else {?><img src="images/Next_disable.gif" /> <?php }// Show if not last page ?></td>
        <td><?php if ($pageNum_Places < $totalPages_Places) { // Show if not last page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, $totalPages_Places, $queryString_Places); ?>"><img src="images/Last.gif" /></a>
            <?php } else {?><img src="images/Last_disable.gif" /> <?php }// Show if not last page ?></td>
      </tr>
    </table>
    <?php do { ?>
      <div class="placesList">    <div class="placeImage"> <a href="PlacesDetails.php?place=<?php echo $row_Places['PlaceId']; ?>"><img src="<?php echo $row_Places['PicturePath']; ?>" width="196" height="156" alt="<?php echo $row_Places['PictureName']; ?>" /></a> </div>
        <div class="placeDesc"> 
         <div class="Valoration">
 <div class="stars">
 <?php echo '('.$row_Places['countPoints'].' Votes)  '. $row_Places['avgPoints']?>
<img src="images/Stars.png" width="100" height="20" alt="Stars"  style="background-image:url(images/StarsBack.png); background-position:<?php echo 100+$row_Places['avgPoints']*20 ?>px 0px; margin-left:10px; vertical-align:central"/>
</div>


</div>
        
       

          <h4><a href="PlacesDetails.php?place=<?php echo $row_Places['PlaceId']; ?>"><?php echo $row_Places['PlaceName']; ?></a></h4>
          <p class="placeDesc"><?php echo $row_Places['PlaceDesc']; ?> ...</p>
          
        </div>
      </div>
      <?php } while ($row_Places = mysql_fetch_assoc($Places)); ?>
    
    <p>
    <table border="0" align="right">
      <tr>
        <td><?php if ($pageNum_Places > 0) { // Show if not first page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, 0, $queryString_Places); ?>"><img src="images/First.gif" /></a>
        <?php } else {?><img src="images/First_disable.gif" /> <?php } // Show if not first page ?></td>
        <td><?php if ($pageNum_Places > 0) { // Show if not first page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, max(0, $pageNum_Places - 1), $queryString_Places); ?>"><img src="images/Previous.gif" /></a>
        <?php } else {?><img src="images/Previous_disable.gif" /> <?php } // Show if not first page ?></td>
        <td><?php echo $pageNum_Places+1 ?> of <?php echo $totalPages_Places+1 ?></td>
        <td><?php if ($pageNum_Places < $totalPages_Places) { // Show if not last page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, min($totalPages_Places, $pageNum_Places + 1), $queryString_Places); ?>"><img src="images/Next.gif" /></a>
            <?php } else {?><img src="images/Next_disable.gif" /> <?php }// Show if not last page ?></td>
        <td><?php if ($pageNum_Places < $totalPages_Places) { // Show if not last page ?>
            <a href="<?php printf("%s?pageNum_Places=%d%s", $currentPage, $totalPages_Places, $queryString_Places); ?>"><img src="images/Last.gif" /></a>
            <?php } else {?><img src="images/Last_disable.gif" /> <?php }// Show if not last page ?></td>
      </tr>
    </table>
    </p>
  <!-- InstanceEndEditable --><!-- end .content --></div>
  <div class="sidebar1">
    <p>Barra Lateral aaa</p>
  </div>
  <div class="footer">
    <p>&nbsp;</p>
    <!-- end .footer --></div>
  <!-- end .container --></div>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>
<?php
}
mysql_free_result($Places);
?>