<?php require_once('Connections/valorecitta.php'); ?>
<?php require_once('Connections/valorecitta.php'); ?>
<?php
// Require the MXI classes
require_once ('includes/mxi/MXI.php');

// Load the tNG classes
require_once('includes/tng/tNG.inc.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"];

$currentPage = $_SERVER["PHP_SELF"];

$colname_tipo = "-1";
if (isset($_GET['non_so_che_variabile_mettere'])) {
  $colname_tipo = $_GET['non_so_che_variabile_mettere'];
}
mysql_select_db($database_valorecitta, $valorecitta);
$query_tipo = sprintf("SELECT * FROM a_tipologia WHERE id = %s", GetSQLValueString($colname_tipo, "int"));
$tipo = mysql_query($query_tipo, $valorecitta) or die(mysql_error());
$row_tipo = mysql_fetch_assoc($tipo);
$totalRows_tipo = mysql_num_rows($tipo);

$maxRows_archivio = 10;
$pageNum_archivio = 0;
if (isset($_GET['pageNum_archivio'])) {
  $pageNum_archivio = $_GET['pageNum_archivio'];
}
$startRow_archivio = $pageNum_archivio * $maxRows_archivio;

$colname_archivio = "-1";
if (isset($_GET['non_so_che_variabile_mettere'])) {
  $colname_archivio = $_GET['non_so_che_variabile_mettere'];
}
mysql_select_db($database_valorecitta, $valorecitta);
$query_archivio = sprintf("SELECT * FROM a_portfolio WHERE tipologia = %s ORDER BY ordinamento ASC", GetSQLValueString($colname_archivio, "int"));
$query_limit_archivio = sprintf("%s LIMIT %d, %d", $query_archivio, $startRow_archivio, $maxRows_archivio);
$archivio = mysql_query($query_limit_archivio, $valorecitta) or die(mysql_error());
$row_archivio = mysql_fetch_assoc($archivio);

if (isset($_GET['totalRows_archivio'])) {
  $totalRows_archivio = $_GET['totalRows_archivio'];
} else {
  $all_archivio = mysql_query($query_archivio);
  $totalRows_archivio = mysql_num_rows($all_archivio);
}
$totalPages_archivio = ceil($totalRows_archivio/$maxRows_archivio)-1;

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

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

// Show Dynamic Thumbnail
$objDynamicThumb1 = new tNG_DynamicThumbnail("", "KT_thumbnail1");
$objDynamicThumb1->setFolder("img_2009/public/");
$objDynamicThumb1->setRenameRule("{archivio.immagine}");
$objDynamicThumb1->setResize(901, 0, true);
$objDynamicThumb1->setWatermark(false);
?><!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>SOLUZIONI di Simone Medri | <?php echo $row_tipo['tipo']; ?></title>
<link href="css_2009/css.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="BubbleTooltips.js"></script>
<script type="text/javascript">
window.onload=function(){enableTooltips()};
</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>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>

<body>
<?php
  mxi_includes_start("testata.php");
  require(basename("testata.php"));
  mxi_includes_end();
?>
<div id="centrale">
 
      <?php if ($pageNum_archivio > 0) { // Show if not first page ?>
            <a href="<?php printf("%s?pageNum_archivio=%d%s", $currentPage, max(0, $pageNum_archivio - 1), $queryString_archivio); ?>" title="Pagina precedente"><img src="img_2009/indietro.gif" alt="indietro" border="0" /></a>
            <?php } // Show if not first page ?>
<?php if ($pageNum_archivio < $totalPages_archivio) { // Show if not last page ?>
            <a href="<?php printf("%s?pageNum_archivio=%d%s", $currentPage, min($totalPages_archivio, $pageNum_archivio + 1), $queryString_archivio); ?>" title="Pagina successiva">&nbsp;&nbsp;&nbsp;<img src="img_2009/avanti.gif" alt="avanti" border="0" /></a>
            <?php } // Show if not last page ?>
            <br />
      
  <br />
<?php do { ?>

  <br />
  <img src="<?php echo $objDynamicThumb1->Execute(); ?>" border="0" /><br />
  <div id="tabella_testa"></div>
      <div id="tabella_centro"> <span class="titolo<?php echo $row_archivio['tipologia']; ?>"><strong><?php echo $row_archivio['titolo']; ?></strong></span><br />
          <br />
          <?php echo $row_archivio['testo']; ?>
          <?php if ($row_archivio['link'] <> "") { ?>
        <br />
          <br />
        <a href="<?php echo $row_archivio['link']; ?>" target="_blank" title="<?php echo $row_archivio['titolo']; ?>" ><img src="img_2009/avanti.gif" alt="avanti" border="0" /></a><br />
        <? } ?>
      </div>
      <div id="tabella_basso"></div>
      <br />
  <?php } while ($row_archivio = mysql_fetch_assoc($archivio)); ?>
</div><?php
  mxi_includes_start("piede.php");
  require(basename("piede.php"));
  mxi_includes_end();
?>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-4487739-1");
pageTracker._initData();
pageTracker._trackPageview();
</script></body>
</html>
<?php
mysql_free_result($tipo);

mysql_free_result($archivio);
?>