<?php require_once('Connections/mydb.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;
}
}

require_once('lang_fields_switch_inc.php');

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_RsSearchResults = 10;
$pageNum_RsSearchResults = 0;
if (isset($_GET['pageNum_RsSearchResults'])) {
  $pageNum_RsSearchResults = $_GET['pageNum_RsSearchResults'];
}
$startRow_RsSearchResults = $pageNum_RsSearchResults * $maxRows_RsSearchResults;

$colname_RsSearchResults = "-1";
if (isset($_GET['search'])) {
  $colname_RsSearchResults = $_GET['search'];
}
mysql_select_db($database_mydb, $mydb);
$query_RsSearchResults = sprintf("
								 (SELECT IDmenuitems AS id, menuitems_title_1 AS title, CONCAT(menu.menu_title_1, ' > ', menuitems_groups.menuitems_groups_title_1) AS cat, 'menuitems' AS type FROM menuitems INNER JOIN menu ON (menuitems.IDmenu=menu.IDmenu) LEFT JOIN menuitems_groups ON (menuitems.IDmenuitems_groups=menuitems_groups.IDmenuitems_groups) WHERE IDmenuitems_link = NULL AND menuitems_active = 1 AND (menuitems_title_1 LIKE %s OR menuitems_content_1 LIKE %s))
								 UNION
								 (SELECT IDnews AS id, news_title_1 AS title, 'Novità ed Eventi' AS cat, 'news' AS type FROM news WHERE news_active = 1 AND (news_title_1 LIKE %s OR news_content_1 LIKE %s))
								 UNION
								 (SELECT IDnotizie AS id, notizie_titolo_1 AS title, notizie_cat.notizie_cat_title_1 AS cat, 'notizie' AS type FROM notizie INNER JOIN notizie_cat ON (notizie.IDnotizie_cat=notizie_cat.IDnotizie_cat) WHERE notizie_attivo = 1 AND (notizie_titolo_1 LIKE %s OR notizie_content_1 LIKE %s))
								 ORDER BY id DESC
								 ", GetSQLValueString("%".$colname_RsSearchResults."%", "text"), GetSQLValueString("%".$colname_RsSearchResults."%", "text"), GetSQLValueString("%".$colname_RsSearchResults."%", "text"), GetSQLValueString("%".$colname_RsSearchResults."%", "text"), GetSQLValueString("%".$colname_RsSearchResults."%", "text"), GetSQLValueString("%".$colname_RsSearchResults."%", "text"));
$query_RsSearchResults = lang_fields_switch($query_RsSearchResults);
$query_limit_RsSearchResults = sprintf("%s LIMIT %d, %d", $query_RsSearchResults, $startRow_RsSearchResults, $maxRows_RsSearchResults);
$RsSearchResults = mysql_query($query_limit_RsSearchResults, $mydb) or die(mysql_error());
$row_RsSearchResults = mysql_fetch_assoc($RsSearchResults);

if (isset($_GET['totalRows_RsSearchResults'])) {
  $totalRows_RsSearchResults = $_GET['totalRows_RsSearchResults'];
} else {
  $all_RsSearchResults = mysql_query($query_RsSearchResults);
  $totalRows_RsSearchResults = mysql_num_rows($all_RsSearchResults);
}
$totalPages_RsSearchResults = ceil($totalRows_RsSearchResults/$maxRows_RsSearchResults)-1;

$queryString_RsSearchResults = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_RsSearchResults") == false && 
        stristr($param, "totalRows_RsSearchResults") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_RsSearchResults = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_RsSearchResults = sprintf("&totalRows_RsSearchResults=%d%s", $totalRows_RsSearchResults, $queryString_RsSearchResults);
?>
<!DOCTYPE html>

<html>

	<head>
		<title>DIMMS Control S.p.A.</title>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<meta name="keywords" content="" />
		<meta name="description" content="" />
		<meta name="robots" content="NOODP" />
		<meta name="title" content="" />
		<script type="text/javascript"src="http://www.googletagservices.com/tag/js/gpt.js"></script>

		<link href="styles/css_fonts.css" type="text/css" rel="stylesheet"/>
		<link href="styles/application-min.css" type="text/css" rel="stylesheet"/>
		<!--[if IE]>
			<link rel="stylesheet" type="text/css" href="styles/ie.css?v3.5.0"/>
		<![endif]-->
		<!--[if IE 6]>
			<link rel="stylesheet" type="text/css" href="styles/ie6.css?v3.5.0"/>
		<![endif]-->
		<!--[if IE 7]>
			<link rel="stylesheet" type="text/css" href="styles/ie7.css?v3.5.0"/>
		<![endif]-->
		<!--[if IE 8]>
			<link rel="stylesheet" type="text/css" href="styles/ie8.css?v3.5.0"/>
		<![endif]-->
		<script type="text/javascript" src="http://nexus.ensighten.com/viraus/Bootstrap.js"></script>
		<script type="text/javascript" src="scripts/jquery-min.js?v3.5.0"></script>
	</head>

	<body class="generic-body" data-usessl="true">

		<noscript>
			<div id="warning-banner">
				<div class="warning-inner ui-helper-clearfix">
					<p>Abbiamo rilevato che il tuo browser non è abilitato all'utilizzo di JavaScript 1.5. Di conseguenza il sito non può funzionare come previsto. Cnsigliamo di abilitare i JavaScript nel browser in uso.</p>
				</div>
			</div>
		</noscript>

		<!-- Start Main Body -->
		<div id="bodyWide" class="outer-velocity">
			<!--start bodyCenter-->
			<div id="bodyCenter" data-widgetclass="Skyscraper" class="widgetSkyScraper">
				<div id="bodyMain">

					<!-- INIZIO HEADER -->
					<?php include('header_1.php'); ?>
					<!-- FINE HEADER -->

					<div id="centralPane" class="clearBoth">
						<div class="layout-right-content">
							<div id="greyPageBar">
								<div class="pageTitle">Ricerca contenuti</div>
							</div>
							<div id="breadcrumb">
								<ul>
									<li><a href="index_1.php"><span>Home</span></a></li>
									<li><span>Ricerca contenuti</span></li>
									<li class="last"><?php if (isset($_GET['search'])) { ?><?php echo $_GET['search'];  ?><?php } else { ?>...<?php }; ?></li>
								</ul>
							</div>

							<!-- INIZIO HEADER -->
							<?php include('menu_sx_1.php'); ?>
							<!-- FINE HEADER -->

							<div id="rightContentPane">
								<div id="pageName">
									<!--<h1></h1>-->
								</div>
								<div id="content">
									<div class="widget_tabs">
										<div id="domestic">
											<div class="free-text">
												<form action="" method="get">
													<label for="search">Testo da ricercare: </label><input name="search" type="text" value="<?php echo ((isset($_GET['search'])) ? $_GET['search'] : ''); ?>" size="75"><input name="Cerca" type="submit" value="Esegui ricerca">
												</form>
												<?php if (isset($_GET['search'])) { ?>
												<h1>Occorrenze di <strong><?php echo $_GET['search'];  ?></strong> trovate:</h1>
													<?php if ($totalRows_RsSearchResults==0) { ?>
														<p>Nessuna occorrenza trovata. Riprova con un altro termine.</p>
													<?php } else { ?>
														<!-- blocco navigazione superiore -start-->
														<table width="100%" border="0" cellspacing="0" cellpadding="0" style="background-color:#f8f8f8; border:none">
															<tr>
																<td nowrap style="border-left:none; border-right:none">
																	<div class="items-nav">Occorrenze visualizzate: da <strong><?php echo ($startRow_RsSearchResults + 1) ?></strong> a <strong><?php echo min($startRow_RsSearchResults + $maxRows_RsSearchResults, $totalRows_RsSearchResults) ?></strong> di <strong><?php echo $totalRows_RsSearchResults ?></strong></div>
																</td>
																<td align="center" width="100%" style="border-left:none; border-right:none">
																	<ul class="buttons-nav" style="margin:0;padding:0;list-style-type:none;text-align:center;">
																		<?php if ($pageNum_RsSearchResults > 0) { // Show if not first page ?>
																			<li style="display:inline;">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, 0, $queryString_RsSearchResults); ?>"><< prima</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not first page ?>
																		<?php if ($pageNum_RsSearchResults > 0) { // Show if not first page ?>
																			<li style="display:inline">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, max(0, $pageNum_RsSearchResults - 1), $queryString_RsSearchResults); ?>">< precedente</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not first page ?>
																		<?php if ($pageNum_RsSearchResults < $totalPages_RsSearchResults) { // Show if not last page ?>
																			<li style="display:inline">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, min($totalPages_RsSearchResults, $pageNum_RsSearchResults + 1), $queryString_RsSearchResults); ?>">> successiva</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not last page ?>
																		<?php if ($pageNum_RsSearchResults < $totalPages_RsSearchResults) { // Show if not last page ?>
																			<li style="display:inline">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, $totalPages_RsSearchResults, $queryString_RsSearchResults); ?>">>> ultima</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not last page ?>
																	</ul>
																</td>
																<td align="right" nowrap style="border-left:none; border-right:none">
																	<div class="info-nav">Pagina corrente: <strong><?php echo $pageNum_RsSearchResults+1; ?></strong> / <strong><?php echo $totalPages_RsSearchResults+1; ?></strong></div>
																</td>
															</tr>
														</table>
														<!-- blocco navigazione superiore -end-->

														<!-- lista occorrenze trovate -start-->
														<table width="100%" border="1" cellspacing="0" cellpadding="0">
															<?php do { ?>
																<tr>
																	<td nowrap>
																		<strong><?php echo $row_RsSearchResults['cat']; ?></strong>
																	</td>
																	<td width="100%">
																		<?php echo $row_RsSearchResults['title']; ?>
																	</td>
																	<td>
																		<?php if ($row_RsSearchResults['type']=='menuitems') { ?>
																			<a href="item_<?php echo ((isset($_SESSION['lang'])) ? $_SESSION['lang'] : '1'); ?>.php?IDsubitem=<?php echo $row_RsSearchResults['id']; ?>">Dettaglio</a>
																		<?php } else if ($row_RsSearchResults['type']=='news') { ?>
																			<a href="news_<?php echo ((isset($_SESSION['lang'])) ? $_SESSION['lang'] : '1'); ?>.php?IDnews=<?php echo $row_RsSearchResults['id']; ?>">Dettaglio</a>
																		<?php } else if ($row_RsSearchResults['type']=='notizie') { ?>
																			<a href="info_<?php echo ((isset($_SESSION['lang'])) ? $_SESSION['lang'] : '1'); ?>.php?IDnotizie=<?php echo $row_RsSearchResults['id']; ?>">Dettaglio</a>
																		<?php }; ?>
																	</td>
																</tr>
															<?php } while ($row_RsSearchResults = mysql_fetch_assoc($RsSearchResults)); ?>
														</table>
														<!-- lista occorrenze trovate  -end-->

														<!-- blocco navigazione inferiore -start-->
														<table width="100%" border="0" cellspacing="0" cellpadding="0" style="background-color:#f8f8f8; border:none">
															<tr>
																<td nowrap style="border-left:none; border-right:none">
																	<div class="items-nav">Occorrenze visualizzate: da <strong><?php echo ($startRow_RsSearchResults + 1) ?></strong> a <strong><?php echo min($startRow_RsSearchResults + $maxRows_RsSearchResults, $totalRows_RsSearchResults) ?></strong> di <strong><?php echo $totalRows_RsSearchResults ?></strong></div>
																</td>
																<td align="center" width="100%" style="border-left:none; border-right:none">
																	<ul class="buttons-nav" style="margin:0;padding:0;list-style-type:none;text-align:center;">
																		<?php if ($pageNum_RsSearchResults > 0) { // Show if not first page ?>
																			<li style="display:inline;">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, 0, $queryString_RsSearchResults); ?>"><< prima</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not first page ?>
																		<?php if ($pageNum_RsSearchResults > 0) { // Show if not first page ?>
																			<li style="display:inline">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, max(0, $pageNum_RsSearchResults - 1), $queryString_RsSearchResults); ?>">< precedente</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not first page ?>
																		<?php if ($pageNum_RsSearchResults < $totalPages_RsSearchResults) { // Show if not last page ?>
																			<li style="display:inline">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, min($totalPages_RsSearchResults, $pageNum_RsSearchResults + 1), $queryString_RsSearchResults); ?>">> successiva</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not last page ?>
																		<?php if ($pageNum_RsSearchResults < $totalPages_RsSearchResults) { // Show if not last page ?>
																			<li style="display:inline">
																				<a href="<?php printf("%s?pageNum_RsSearchResults=%d%s", $currentPage, $totalPages_RsSearchResults, $queryString_RsSearchResults); ?>">>> ultima</a>&nbsp;|&nbsp;
																			</li>
																		<?php } // Show if not last page ?>
																	</ul>
																</td>
																<td align="right" nowrap style="border-left:none; border-right:none">
																	<div class="info-nav">Pagina corrente: <strong><?php echo $pageNum_RsSearchResults+1; ?></strong> di <strong><?php echo $totalPages_RsSearchResults+1; ?></strong></div>
																</td>
															</tr>
														</table>
														<!-- blocco navigazione inferiore -end-->

													<?php }; ?>
												<?php }; ?>
											</div>
										</div>
									</div>
								</div>
							</div>
							<div class="clearBoth"></div>
						</div>
					</div>
					<div class="clearBoth"></div>

				</div>
				<div class="clearBoth"></div>
				<!--end bodyCenter-->
			</div>
		</div>
<!-- End Main Body -->
		
		<!-- INIZIO FOOTER -->
		<?php include('footer_1.php'); ?>
		<!-- FINE FOOTER -->

		<script type="text/javascript" src="scripts/application-min.js"></script>

	</body>

</html>
<?php
mysql_free_result($RsSearchResults);
?>