<?php

require('config.php');
require('utility.php');
require('facebook-platform/facebook-platform/php/facebook.php');

session_start();

$_SESSION['url_pagina']=$_SERVER['PHP_SELF'];

$_SESSION['page']='home';

//CONNESSIONE AL DB
$connection = mysql_connect($db_host, $db_user, $db_password)
or die("Impossibile connettersi al database.\n");
mysql_select_db($db_name, $connection)
or die("Impossibile aprire il database.\n");
//CONNESSIONE AL DB

//QUERY NEWS SLIDE

$sql_news_slide="SELECT nw.id, "
                    ."nw.titolo, "
                    ."rs.nome, "
                    ."nw.breve, "
                    ."nw.descr, "
                    ."nw.tipo_news_motorizz, "
                    ."date_format(nw.inizio,'%e %b') inizio, "
                    ."substr(nw.descr,1,240) descr "
                    ."FROM cms_news nw, cms_ristoranti rs "
                    ."where tipo_news_motorizz in ('N','A','S') "
                    ."and stato='V' "
                    ."and slide='S' "
                    ."and rs.id = nw.locale "
                    ."ORDER BY nw.inizio DESC LIMIT 0,6";

$sql_result_news_slide=mysql_query($sql_news_slide, $connection) or die(mysql_error());

//QUERY NEWS SLIDE

//QUERY NEWS PRINCIPALE

$sql_news_principale="SELECT nw.id, "
                    ."nw.titolo, "
                    ."rs.nome, "
                    ."nw.breve, "
                    ."nw.tipo_news_motorizz, "
                    ."date_format(nw.inizio,'%e %b') inizio, "
                    ."substr(nw.descr,1,240) descr "
                    ."FROM cms_news nw, cms_ristoranti rs "
                    ."where tipo_news_motorizz in ('N','A','S') "
                    ."and stato='V' "
                    ."and slide='N' "
                    ."and rs.id = nw.locale "
                    ."ORDER BY nw.inizio DESC LIMIT 0,1";

$sql_result_news_principale=mysql_query($sql_news_principale, $connection) or die(mysql_error());

$sql_news_principale_utente="SELECT id, "
                    ."ragione_sociale "
                    ."FROM utenti "
                    ."where id= (select userid_post from cms_news where tipo_news_motorizz in ('N','A','S') and stato='V' and slide='N' ORDER BY inizio DESC LIMIT 0,1) ";

$sql_result_news_principale_utente=mysql_query($sql_news_principale_utente, $connection) or die(mysql_error());

//QUERY NEWS PRINCIPALE

//QUERY NEWS 2

$sql_news_due=  "SELECT nw.id, "
               ."nw.titolo, "
               ."rs.nome, "
               ."nw.breve, "
               ."nw.descr, "
               ."ut.ragione_sociale, "
               ."nw.tipo_news_motorizz, "
               ."date_format(nw.inizio,'%e %b') inizio "
               ."FROM cms_news nw, utenti ut, cms_ristoranti rs "
               ."where tipo_news_motorizz in ('N','A','S') "
               ."and stato='V' "
               ."and ut.id=nw.userid_post "
               ."and slide='N' "
               ."and rs.id = nw.locale "
               ."ORDER BY nw.inizio DESC LIMIT 1,2";

$sql_result_news_due=mysql_query($sql_news_due, $connection) or die(mysql_error());

//QUERY NEWS 2

//QUERY NEWS 3

$sql_news_tre=  "SELECT nw.id, "
               ."nw.titolo, "
               ."rs.nome, "
               ."nw.breve, "
               ."ut.ragione_sociale, "
               ."nw.descr, "
               ."nw.tipo_news_motorizz, "
               ."date_format(nw.inizio,'%e %b') inizio "
               ."FROM cms_news nw, utenti ut, cms_ristoranti rs "
               ."where tipo_news_motorizz in ('N','A','S') "
               ."and stato='V' "
               ."and ut.id=nw.userid_post "
               ."and slide='N' "
               ."and rs.id = nw.locale "
               ."ORDER BY nw.inizio DESC LIMIT 3,2";

$sql_result_news_tre=mysql_query($sql_news_tre, $connection) or die(mysql_error());

//QUERY NEWS 3

//QUERY TEST DRIVE

$sql_test_drive="SELECT nw.id, "
               ."nw.titolo, "
               ."nw.breve, "
               ."ut.ragione_sociale, "
               ."nw.descr, "
               ."nw.tipo_news_motorizz, "
               ."date_format(nw.inizio,'%e %b') inizio "
               ."FROM cms_news nw, utenti ut "
               ."WHERE tipo_news_motorizz = 'P' "
               ."and stato='V' "
               ."and ut.id=nw.userid_post "
               ."and slide='N' "
               ."ORDER BY nw.inizio DESC LIMIT 0,4";

$sql_result_test_drive=mysql_query($sql_test_drive, $connection) or die(mysql_error());

//QUERY TEST DRIVE

?>
<!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" xml:lang="it" lang="it" xmlns:fb="http://www.facebook.com/2008/fbml">
<head>
<LINK REL="shortcut icon" HREF="http://www.gtevoluzione.it/favicon.ico">
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1" />
<title>GTevoluzione - Sport Car Magazine</title>
<meta name="Description" content="Magazine con focus sulle auto sportive: News, Anteprime, Test Drive,  ricerca e confronto dinamico dei dati disponibili nel database."/>

<link rel="canonical" href="http://www.gtevoluzione.it/" />

<?php
analitycs();
?>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js"></script>
<script type="text/javascript" src="/js/home/galleryview-2.1.1/jquery.galleryview-2.1.1.js"></script>
<script type="text/javascript" src="/js/home/galleryview-2.1.1/jquery.timers-1.2.js"></script>
<script type="text/javascript" src="/js/home/galleryview-2.1.1/jquery.easing.1.3.js"></script>
<link rel="stylesheet" href="style.css" type="text/css" />

<script type="text/javascript">
    $(document).ready(function(){
        $('#photos').galleryView({
            panel_width: 630,
            panel_height: 350,
    frame_width: 30,
    frame_height: 30,
    overlay_color: '#222',
    overlay_text_color: 'white',
    caption_text_color: '#222',
    background_color: 'transparent',
    border: 'none',
    nav_theme: 'light',
    easing: 'easeInOutQuad',
    pause_on_hover: false,
    transition_speed: 1000,
    transition_interval: 8000,
    overlay_position: 'bottom',
	filmstrip_position: 'bottom'
        });
    });
</script>
<meta name="y_key" content="fad71bfb8a06b2d8"/>
<meta name="msvalidate.01" content="C74BDDF6CA629D929F71C8FE086CCCB4" />
<meta name="google-site-verification" content="o8MbZKVJ4syKHyL3Gj9x4TMVF6XP0IzeXNnrIaaMknw" />
</head>
<body>

<table align="center" border="0" cellpadding="0" cellspacing="0">
 <tr>
  <td colspan="2">

   <div id="HEADER_LOGIN">
   <?php
   header_login2();
   ?>
   </div>
  </td>
 </tr>
 <tr>
  <td>

   <div id="BANNER_UP">
   <?php
   banner_up_home();
   ?>
   </div>

  </td>
 </tr>
 <tr>
  <td>

   <div id="HEADER_UP">
   <table border="0" cellpadding="0" cellspacing="0">
    <tr>
     <td colspan="8">
      <img border="0" alt="" src="img/Banner-1-900x68px.png"/>
     </td>
    </tr>
   </table>
   </div>

   <div id="HEADER_DOWN">
   <?php
   header_down();
   ?>
   </div>


  </td>
 </tr>
 <tr>
  <td>
   <table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#FFFFFF">
    <tr>
     <td>


       <div id="CONTENT_SX">
      <table class="TEXT_SMALL" width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
       <tr>
        <td colspan="2">
         &nbsp;
        </td>
       </tr>

       <tr align="center">
        <td colspan="2">


<ul id="photos">
          <?php
          while ($ValoriRigaSlide = mysql_fetch_array($sql_result_news_slide))
          {
           if($ValoriRigaSlide[tipo_news_motorizz]=='N' OR $ValoriRigaNewsPrincipale[tipo_news_motorizz]=='S')
           {
            //$link='vista_news.php';
            $link='news';
           }
           else
           {
            //$link='vista_anteprima.php';
            $link='anteprima';
           }
          $product_title_url = gen_seo_friendly_titles($ValoriRigaSlide[titolo]);
          ?>
  <li>
    <span class="panel-overlay" style="font-size: 20px; font-family: verdana;"><a href='http://www.gtevoluzione.it/<?php print $link; ?>/<?php print $ValoriRigaSlide[id]; ?>/<?php print gen_seo_friendly_titles(strtr($ValoriRigaSlide[nome],"&","e")) ?>/<?php print $product_title_url ?>.html'><?php echo $ValoriRigaSlide[titolo]; ?></a><br /><font style="font-size: 16px; font-family: verdana;"><?php echo $ValoriRigaSlide[breve]; ?></font></span>
    <img alt="<?php print $ValoriRigaSlide[titolo]; ?>" src="img/news_foto_16_9/<?php echo $ValoriRigaSlide[id]; ?>_16-9.jpg" />
  </li>
<?php
}
?>
</ul>


        </td>
       </tr>

       <tr>
        <td colspan="2">
         &nbsp;
        </td>
       </tr>
       <tr align="center">
        <td colspan="2">
         <h2 class="classeh2news"><span style="display: none;">News e anteprima del settore automobilistico.</span></h2>
        </td>
       </tr>
       <tr>
        <td>
         &nbsp;
        </td>
       </tr>
       <tr>
        <td valign="top" align="center">
         <table width="265px" align="center">
          <tr>
           <td align="left">
            <table width="228px" class="TEXT_SMALL" align="center">
             <tr>
              <td align="center">
              <?php
              $ValoriRigaNewsPrincipale = mysql_fetch_array($sql_result_news_principale);
              $ValoriRigaNewsPrincipaleUtente = mysql_fetch_array($sql_result_news_principale_utente);
           if($ValoriRigaNewsPrincipale[tipo_news_motorizz]=='N' OR $ValoriRigaNewsPrincipale[tipo_news_motorizz]=='S')
           {
            //$link='vista_news.php';
            $link='news';
           }
           else
           {
            //$link='vista_anteprima.php';
            $link='anteprima';
           }


               $product_title_url = gen_seo_friendly_titles($ValoriRigaNewsPrincipale[titolo]);
               ?>
               <img alt="<?php echo $ValoriRigaNewsPrincipale[titolo]; ?>" width="228" height="168" border="0" src="img/news_foto_4_3/<?php echo $ValoriRigaNewsPrincipale[id] ?>_4-3.jpg"/>
              </td>
             </tr>
             <tr>
              <td align="left">
               <b><a href='http://www.gtevoluzione.it/<?php print $link; ?>/<?php print $ValoriRigaNewsPrincipale[id]; ?>/<?php print gen_seo_friendly_titles(strtr($ValoriRigaNewsPrincipale[nome],"&","e")) ?>/<?php print $product_title_url ?>.html' ><?php echo $ValoriRigaNewsPrincipale[titolo]; ?></a></b>
              </td>
             </tr>
             <tr>
              <td align="left">
               <i><?php echo stripslashes($ValoriRigaNewsPrincipale[breve]); ?></i>
              </td>
             </tr>
             <tr>
              <td align="left">
               <?php echo $ValoriRigaNewsPrincipale[inizio]; ?> di <?php echo $ValoriRigaNewsPrincipaleUtente[ragione_sociale]; ?></td>
             </tr>
             <tr>
              <td align="left" class="TEXT_SMALL">
               <?php echo stripslashes(strip_tags($ValoriRigaNewsPrincipale[descr])); ?>...
              </td>
             </tr>
            </table>
           </td>
          </tr>
         </table>
        </td>
        <td valign="top" align="center">
         <table width="435px" align="center">
          <tr>
          <?php
          while ($ValoriRigaNewsDue = mysql_fetch_array($sql_result_news_due))
          {
           if($ValoriRigaNewsDue[tipo_news_motorizz]=='N' OR $ValoriRigaNewsDue[tipo_news_motorizz]=='S')
           {
            //$link='vista_news.php';
            $link='news';
           }
           else
           {
            //$link='vista_anteprima.php';
            $link='anteprima';
           }
           $product_title_url = gen_seo_friendly_titles($ValoriRigaNewsDue[titolo]);
          ?>
           <td>
            <table class="TEXT_SMALL">
             <tr>
              <td>
               <img alt="<?php echo $ValoriRigaNewsDue[titolo]; ?>" width="193" height="105" border="0" src="img/news_foto_16_9/<?php echo $ValoriRigaNewsDue[id] ?>_16-9.jpg"/>
              </td>
             </tr>
             <tr>
              <td align="left">
               <a href='http://www.gtevoluzione.it/<?php print $link; ?>/<?php print $ValoriRigaNewsDue[id]; ?>/<?php print gen_seo_friendly_titles(strtr($ValoriRigaNewsDue[nome],"&","e")) ?>/<?php print $product_title_url ?>.html'><b><?php echo $ValoriRigaNewsDue[titolo]; ?></b></a>
              </td>
             </tr>
             <tr>
              <td align="left">
               <i><?php echo stripslashes($ValoriRigaNewsDue[breve]); ?></i>
              </td>
             </tr>
             <tr>
              <td align="left">
               <?php echo $ValoriRigaNewsDue[inizio]; ?> di <?php echo $ValoriRigaNewsDue[ragione_sociale]; ?>
              </td>
             </tr>
            </table>
           </td>
          <?php
          }
          ?>
          </tr>
          <tr>
          <?php
          while ($ValoriRigaNewsTre = mysql_fetch_array($sql_result_news_tre))
          {
           if($ValoriRigaNewsTre[tipo_news_motorizz]=='N' OR $ValoriRigaNewsTre[tipo_news_motorizz]=='S')
           {
            //$link='vista_news.php';
            $link='news';
           }
           else
           {
            //$link='vista_anteprima.php';
            $link='anteprima';
           }
           $product_title_url = gen_seo_friendly_titles($ValoriRigaNewsTre[titolo]);
          ?>
           <td valign="top">
            <table class="TEXT_SMALL">
             <tr>
              <td>
               <img alt="<?php echo $ValoriRigaNewsTre[titolo]; ?>" width="193" height="105" border="0" src="img/news_foto_16_9/<?php echo $ValoriRigaNewsTre[id] ?>_16-9.jpg"/>
              </td>
             </tr>
             <tr>
              <td align="left">
               <a href='http://www.gtevoluzione.it/<?php print $link; ?>/<?php print $ValoriRigaNewsTre[id]; ?>/<?php print gen_seo_friendly_titles(strtr($ValoriRigaNewsTre[nome],"&","e")) ?>/<?php print $product_title_url ?>.html'><b><?php echo $ValoriRigaNewsTre[titolo]; ?></b></a>
              </td>
             </tr>
             <tr>
              <td align="left">
               <i><?php echo stripslashes($ValoriRigaNewsTre[breve]); ?></i>
              </td>
             </tr>
             <tr>
              <td align="left">
               <?php echo $ValoriRigaNewsTre[inizio]; ?> di <?php echo $ValoriRigaNewsTre[ragione_sociale]; ?>
              </td>
             </tr>
            </table>
           </td>
          <?php
          }
          ?>
          </tr>
         </table>
        </td>
       </tr>
       <tr>
        <td colspan="2">
         <table width="100%" align="center" cellpadding="14">
          <tr>
           <td align="left"><B>   Visualizza tutti gli articoli di: </B>
            <a href="http://www.gtevoluzione.it/news/">News</a>,
            <a href="http://www.gtevoluzione.it/anteprima/">Anteprime</a>
           </td>
          </tr>
         </table>
        </td>
       </tr>
      </table>

      <!--******TEST_DRIVE******-->
      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
       <tr>
        <td>
         &nbsp;
        </td>
       </tr>
       <tr>
        <td align="center" colspan="2">
         <h2 class="classeh2testdrive"><span style="display: none;">Test Drive del settore automobilistico.</span></h2>
        </td>
       </tr>
       <tr>
        <td>
         &nbsp;
        </td>
       </tr>
       <tr>
        <td>
         <table width="688px" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
          <?php
          while ($ValoriRigaTestDrive = mysql_fetch_array($sql_result_test_drive))
          {
          $product_title_url = gen_seo_friendly_titles($ValoriRigaTestDrive[titolo]);
          ?>
           <td valign="top">
            <table width="150px" border="0" align="center" cellpadding="0" cellspacing="0">
             <tr>
              <td align="center">
               <table class="TEXT_VERY_SMALL">
                <tr>
                 <td>
                  <img alt="<?php echo $ValoriRigaTestDrive[titolo]; ?>" width="145" height="79" border="0" src="img/news_foto_16_9/<?php echo $ValoriRigaTestDrive[id] ?>_16-9.jpg"/>
                 </td>
                </tr>
                <tr>
                 <td align="left">
                  <a href='http://www.gtevoluzione.it/testdrive/<?php print $ValoriRigaTestDrive[id]; ?>/<?php print $product_title_url ?>.html'><b><?php echo $ValoriRigaTestDrive[titolo]; ?></b></a>
                 </td>
                </tr>
                <tr>
                 <td align="left">
                  <i><?php echo $ValoriRigaTestDrive[breve]; ?></i>
                 </td>
                </tr>
                <tr>
                 <td align="left">
                  <?php echo $ValoriRigaTestDrive[inizio]; ?> di <?php echo $ValoriRigaTestDrive[ragione_sociale]; ?>
                 </td>
                </tr>
               </table>
              </td>
             </tr>
       <tr>
        <td>
         &nbsp;
        </td>
       </tr>
            </table>
           </td>
          <?php
          }
          ?>
          </tr>
         </table>
        </td>
       </tr>
      </table>
      <!--******TEST_DRIVE_FINE******-->

       </div>

     </td>
     <td valign="top">

       <div id="CONTENT_DX">
       <?php
        content_dx_home();
       ?>
       </div>

     </td>
    </tr>
   </table>
  </td>
 </tr>
 <tr>
  <td>

   <div id="FOOTER">
   <?php
   footer();
   ?>
   </div>

  </td>
 </tr>
</table>

</body>
</html>