<?

// aggiunto da Luca
/*
include("nt/dbconfig.php");

$db = mysql_connect($db_host, $db_user, $db_password);
if ($db == FALSE) die ("Errore nella connessione. Verificare i parametri nel file dbconfig.php");

mysql_select_db($db_name, $db)
 or die ("Errore nella selezione del database. Verificare i parametri nel file dbconfig.php");
    
include("nt/counter.php");

contatore("old_dossier",$db);

mysql_close($db);
*/
// inizio vecchio codice

if (!$_COOKIE['Ad']) {
  $adMagazine = true;
  setcookie("Ad", "ok", time()+36000); 
}

$TABLE_CAT = 'CAT';
$first_cat = 0;

include('libraries/dyn/connection.php');
include('libraries/dyn/utilities.php');
include('include/dossier_header.php');

$SQL_DOSSIER_HEAD   = " SELECT 
                          a.*, 
                          DATE_FORMAT(a.date,'%d/%m/%Y') data_inserimento,
                          c.name name_cat,
                          c.id id_cat,
                          c.father father
                        FROM 
                          ARTICLES a, 
                          CAT c 
                        WHERE 
                          c.father  = 110      AND 
                          c.id      = a.id_cat AND 
                          a.visible = 1        AND 
                          status    = 'on'     AND 
                          a.date   <= now() 
                        ORDER BY 
                          c.vr_sx_menu_order ASC, 
                          a.date DESC 
                        LIMIT 4
                      ";

$QUERY_DOSSIER_HEAD = mysql_query($SQL_DOSSIER_HEAD) or die ();
$already_view = array();


$x = 0;
while ( $LAST_DOSSIER  = @mysql_fetch_array($QUERY_DOSSIER_HEAD) ) {
  
  $first_cat = (int)$LAST_DOSSIER['id_cat'];
  
  if ( $x>0 && $article[$x-1]['id_cat'] != $LAST_DOSSIER['id_cat'] ) {
    break;
  }  
  
  $article[$x]['id_article']   = $LAST_DOSSIER['id_article'];
  $article[$x]['title']        = $LAST_DOSSIER['title'];
  $article[$x]['name_cat']     = $LAST_DOSSIER['name_cat'];
  $article[$x]['id_cat']       = $LAST_DOSSIER['id_cat'];
  $article[$x]['father']       = $LAST_DOSSIER['father'];
  $article[$x]['big_image']    = $LAST_DOSSIER['big_image'];
  $article[$x]['description']  = $LAST_DOSSIER['description'];
  $article[$x]['date_insert']  = $LAST_DOSSIER['data_inserimento'];

  $SQL_GALLERY   = "SELECT * FROM GALLERY WHERE id_article=".(int)$article[$x]['id_article']." AND status=\"on\" limit 1";
  $QUERY_GALLERY = @mysql_query($SQL_GALLERY);
  $GALLERY       = @mysql_fetch_array($QUERY_GALLERY);
  $article[$x]['gallery']     = $GALLERY;
  $article[$x]['id_gallery']  = $GALLERY['id_gallery'];

  $SQL_ATTACH    = "SELECT count(*) tot_vid FROM ARTICLES_ATTACH WHERE attach_name LIKE '%.wmv' AND article_id=".(int)$article[$x]['id_article'];
  $QUERY_ATTACH  = mysql_query($SQL_ATTACH) or die ();
  $ATTACH        = @mysql_fetch_array($QUERY_ATTACH);
  $tot_vid       = $ATTACH['tot_vid'];
  $article[$x]['tot_vid'] = $tot_vid;

  $already_view[]  = (int)$article[$x]['id_article'];
  
  
  if ( strlen(trim($LAST_DOSSIER['big_image'])<4) ) {
    $article[$x]['big_image'] = $nhome."images/dossier_null.jpg";
  } else { 
    $article[$x]['big_image'] = $nhome."articles/big_images/".$LAST_DOSSIER['big_image'];
  }
  
  $x++;
}

$SQL_DOSSIER_BODY   = " SELECT 
                          a.*, 
                          DATE_FORMAT(a.date,'%d/%m/%Y') data_inserimento,
                          c.name name_cat,
                          c.id id_cat,
                          c.father father
                        FROM 
                          ARTICLES a, 
                          CAT c 
                        WHERE 
                          c.id <> $first_cat   AND 
                          c.father  = 110      AND 
                          c.id      = a.id_cat AND 
                          a.visible = 1        AND 
                          status    = 'on'     AND ";

while ( list( $k,$v ) = each($already_view) ) {
  $SQL_DOSSIER_BODY  .= " a.id_article <> $v AND ";
}

$SQL_DOSSIER_BODY  .= " 
                          a.date   <= now() 
                        
                      ";

$SQL_DOSSIER_BODY  .= " GROUP BY c.id ";
$SQL_DOSSIER_BODY  .= " ORDER BY c.vr_sx_menu_order ASC, a.date DESC ";


$QUERY_DOSSIER_BODY  = mysql_query($SQL_DOSSIER_BODY) or die ();

$x = 0;
while ( $DOSSIER_BODY  = @mysql_fetch_array($QUERY_DOSSIER_BODY) ) {
  $article_body[$x]['id_article']   = $DOSSIER_BODY['id_article'];
  $article_body[$x]['title']        = $DOSSIER_BODY['title'];
  $article_body[$x]['name_cat']     = $DOSSIER_BODY['name_cat'];
  $article_body[$x]['id_cat']       = $DOSSIER_BODY['id_cat'];
  $article_body[$x]['father']       = $DOSSIER_BODY['father'];
  $article_body[$x]['thumb']        = $DOSSIER_BODY['thumb'];
  $article_body[$x]['image']        = $DOSSIER_BODY['image'];
  $article_body[$x]['big_image']    = $DOSSIER_BODY['big_image'];
  $article_body[$x]['id_article']   = $DOSSIER_BODY['id_article'];
  $article_body[$x]['description']  = $DOSSIER_BODY['description'];
  $article_body[$x]['date_insert']  = $DOSSIER_BODY['data_inserimento'];

  if ( strlen(trim($DOSSIER_BODY['thumb']))<4 ) {
    $article_body[$x]['thumb'] = $nhome."images/dossier_null_small.jpg";
  } else { 
    $article_body[$x]['thumb'] = $nhome."articles/thumbs/".$DOSSIER_BODY['thumb'];
  }
  
  $x++;
}


?>
<table width="770" border="0" align="center" cellpadding="0" cellspacing="0" class="unnamed1">
  <tr>
    <td valign="top" style="background-color:#b7b7b7;border:1px solid gray" >
      <div style="background-color:#333333;padding:5px;">
        <a href="navcat.php?idcat=<?=$article[0]['id_cat']?>&amp;father=<?=$article[0]['father']?>" style="font-size:20px;color:white;font-weight:bold;">DOSSIER <?=@uppercase_chars($article[0]['name_cat'])?></a>
      </div>
      <div style="float:left;width:370px;background-color:#999999;">
        <a href="article_det.php?id=<?=$article[0]['id_article']?>"><img src="<?=$article[0]['big_image']?>" alt="# <?=$article_body[$x]['id_article']?> #" style="width:350px;height:260px;margin:5px;border:1px solid black;" /></a> 
      </div>
      <div style="float:left;width:370px;padding:10px;">
      
<?
  while ( list ($k,$v) = @each($article) ) {
?>
        <div style="text-align:justify;">
          <a href="article_det.php?id=<?=$v['id_article']?>" style="font-size:16px;font-weight:bold;color:#000000;"><b><?=$v['title']?></b></a> <font style="font-size:10px;"></font>
<?
  if ( $k==0 ) { echo "<br><font style=\"font-size:12px;\">".abbrevia($v['description'],200)."</font>"; }

  if ($v['tot_vid']>0) {
?>
  <br /><a href="article_det.php?id=<?=$v['id_article']?>"><img src="images/icone/video.gif" alt="" style="margin-top:3px;margin-left:3px;background-color:white;border:1px solid gray;" /></a>
<?
  }
  
  if ($v['gallery']) {
?>
  <a href="#" class="gallery" onclick="window.open ('/gallery.php?idg=<?=$v['id_gallery']?>','Terranauta','status=0,menubar=0,resizable=0,width=550,height=700');"  style="color:#238700;">GALLERIA&nbsp;FOTOGRAFICA</a><br />
<?
  }
?>
        </div><br />
<?
  }
?>      
      
        <div align="right" ><a href="navcat.php?idcat=<?=$article[0]['id_cat']?>&amp;father=<?=$article[0]['father']?>" class="std" style="font-weight:bold;">GLI ALTRI ARTICOLI...</a></div>
      </div>
      <br style="clear:both;" />

<?
  $y = 0;
  while ( list ($k,$v) = @each($article_body) ) {
    $y++;
    if ( $y%2==0 ) {
      $html_break = "<br style=\"clear:both;\" />";
      $align = "right";
    } else  {
      $html_break = "";
      $align = "left";
    }
?>
      <div style="float:<?=$align?>;width:370px;height:100px;">
        <div style="background-color:#333333;padding:5px;">
          <a href="navcat.php?idcat=<?=$v['id_cat']?>&amp;father=<?=$v['father']?>" style="font-size:14px;color:white;font-weight:bold;">DOSSIER <?=@uppercase_chars($v['name_cat'])?></a>
        </div>
        <div style="padding:8px;">
          <a href="article_det.php?id=<?=$v['id_article']?>" class="std" ><img align="left" src="<?=$v['thumb']?>" alt="Dossier <?=strtoupper($v['name_cat'])?>" style="border:1px solid black;width:86px;height:52px;" /></a>
          <a href="article_det.php?id=<?=$v['id_article']?>" class="std" style="font-size:12px;" ><?=abbrevia(strip_tags($v['title']),200)?></a>
        </div>
      </div>
      <?=$html_break?>
<?
  }
?>
      
    </td>
  </tr>
  <tr>
    <td colspan="4" valign="top">
<? mysql_close(); ?>
<? include('include/home_footer.php'); ?>