<?
if(isset($_GET['id']) && ctype_digit($_GET['id']) && strlen($_GET['id'])<="13" && strlen($_GET['id'])>="0"){
			$id=filter_var($_GET['id'], FILTER_VALIDATE_INT);


/*
$expire=time()-2592000; // valable dix minutes
$expires=2592000; 
$cache=($_SERVER['DOCUMENT_ROOT']."/_cache/page-".$id.".html");
if(file_exists($cache)){ $size=filesize($cache);header("Content-Length:$size"); }else{}
header('Expires:' . gmdate('D, d M Y H:i:s', time()+$expires) . ' GMT, +1');
if(file_exists($cache) && filemtime($cache)>$expire && $size!="0"){ 
	ob_start("ob_gzhandler_no_errors");
		header("Last-Modified:".gmdate("D, d M Y H:i:s", filemtime($cache))." GMT, +1");
        readfile($cache); 
}else{
ob_start(); 

*/


	include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_eyar.php");
	include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_vekirin.php"); 

			
			function dateaffichee($time, $mode = 'long' ) {
				setlocale( LC_TIME, "fr" );
				// Recuperation du nom du mois 
				$mi =  strftime( "%m" , strtotime( $time ) );
						switch ($mi){
							case '1' : $mi = 'janvier'; break; 
							case '2' : $mi = 'f&eacute;vrier'; break; 
							case '3' : $mi = 'mars'; break; 
							case '4' : $mi = 'avril'; break; 
							case '5' : $mi = 'mai'; break; 
							case '6' : $mi = 'juin'; break; 
							case '7' : $mi = 'juillet'; break; 
							case '8' : $mi = 'ao&ucirc;t'; break; 
							case '9' : $mi = 'septembre'; break; 
							case '10' : $mi = 'octobre'; break; 
							case '11' : $mi = 'novembre'; break; 
							case '12' : $mi = 'decembre'; break; 
						}
				// Recuperation du nom du jour 
				$w = strftime( "%u" , strtotime( $time ) );
						switch ($w){
							case '1' : $w = 'Lundi'; break; 
							case '2' : $w = 'Mardi'; break; 
							case '3' : $w = 'Mercredi'; break; 
							case '4' : $w = 'Jeudi'; break; 
							case '5' : $w = 'Vendredi'; break; 
							case '6' : $w = 'Samedi'; break; 
							case '7' : $w = 'Dimanche'; break;
						}
				// Recuperation du jour
				$mor1 = strftime( "%e " , strtotime( $time ) );
				// Recupera de l'année
				$mor2 = strftime( "%Y" , strtotime( $time ) );
				        if ( $mode == 'long' ) {
				                // Recupere de l'heure+minute+seconde
				                $mor3 = strftime( "&agrave; %Hh%M" , strtotime( $time ) );
				                //$mor3 = strftime( "&agrave; %Hh %Mm %Ss" , strtotime( $time ) );
				        }else{ 
				                $mor3 = NULL;
				        }
				        return $w.' '.$mor1.' '. $mi. ' '.$mor2. ' '.$mor3;
				        //return $w.' '.$mor1.' '. $mi. ' '.$mor2. ' '.$mor3;
			}  


 /* AND lng='1'  */

	if(isset($id) && strlen($id)>="1"){


			$query=("SELECT * FROM newsarticles WHERE status='1' AND id=".$id."");
 
			$result = mysql_query("$query") 
			or die(mysql_error()); 
			$num_rows = mysql_num_rows($result);
		
		if($num_rows=='1'){
			$id=mysql_result($result,0,"id");
			$title=mysql_result($result,0,"title"); 
			$head=mysql_result($result,0,"head"); 
			$full=mysql_result($result,0,"full"); 
			$category=mysql_result($result,0,"category"); 
			$added=mysql_result($result,0,"added"); 
			$status=mysql_result($result,0,"status"); 
			$redirect=mysql_result($result,0,"redirect"); 
			$showfiles=mysql_result($result,0,"showfiles"); 
  

			if($redirect!=NULL){
				header("HTTP/1.1 301 Moved Permanently");
				header("Location: ".$redirect); 
				exit;
			}


$head=stripslashes($head);
$full=stripslashes($full);


			if($status=='1'){


				include($_SERVER['DOCUMENT_ROOT']."/x_html.php");

				$keywordhead=strip_tags($head);
				//$keywordhead=dateaffichee($added)." - ".htmlspecialchars($keywordhead, ENT_QUOTES); 
				$keywordhead=dateaffichee($added)." - ".substr($keywordhead, 0, 200)."...";

				$xtitle=htmlspecialchars($title);
				$xdescription="$keywordhead";
				$xkeywords="$keywordhead";


function fbimagepresent($id){ 
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
			$query=("SELECT * FROM newsmedia where nid='".$id."' AND type LIKE '%image%' order by rank ASC");
			$result = mysqli_query($conn,$query) or die(mysqli_error($conn)); 
			$num_rows = mysqli_num_rows($result);	 
			if($num_rows=='1'){
				$data = mysqli_fetch_object($result);
					$id=$data->id;
	
					$img="https://www.nazandbegikhani.com/info/images/crop/photo-270X181-".$id.".jpg";
			}
		return $img;
}

$fbimage=fbimagepresent($id); 


				include($_SERVER['DOCUMENT_ROOT']."/x_meta.php"); ?> 
<link rel="stylesheet" type="text/css" media="screen" href="/test/scripts/jquery/css/jquery.lightbox-0.5.css" />
<script type="text/javascript" src="/test/scripts/jquery/js/jquery.js"></script>
<script type="text/javascript" src="/test/scripts/jquery/js/jquery.lightbox-0.5.js"></script>
<script type="text/javascript">
$(function() {
	$('#gallery a').lightBox({fixedNavigation:true});
});
</script>
 
<? echo"<title>".$title." - Nazand Begikhani</title></head><body>";
			include($_SERVER['DOCUMENT_ROOT']."/x_header.php");


function categoryname($category){
	$query=("SELECT * FROM newscats WHERE cid='".$category."'");
	$result = mysql_query($query) or die(mysql_error()); 
	$num_rows = mysql_num_rows($result);
	$cid=mysql_result($result,0,"cid");  
	$cat=mysql_result($result,0,"cat");
	$navnisan=mysql_result($result,0,"navnisan");
	 return $cat;
}


echo"<section class=\"main-section\">
		<div class=\"container\">";

 
echo "<h1>".categoryname($category)."</h1>";

/*
		if($added=="0000-00-00 00:00:00"){
		}else{
			echo "<p style=\"text-align:right;margin:5px;\"><span style=\"color:#000000;opacity:1;font-style:italic;font:11px verdana;margin:0px;padding:0px;margin-bottom:0px;\">mis &agrave; jour le ".dateaffichee($added)."</span></p>";
		}
 */


echo"<div class=\"row\">";
 	 

echo"<div class=\"col-md-8 unicard unicard-framed mgb-30\">

";

 
function category($category){
$query=("SELECT * FROM newscats WHERE cid='".$category."'");
$result = mysql_query($query) or die(mysql_error()); 
$num_rows = mysql_num_rows($result);
$cid=mysql_result($result,0,"cid");  
$cat=mysql_result($result,0,"cat");
$navnisan=mysql_result($result,0,"navnisan");
echo "<a href=\"/info/?id=".$cid."\">".$cat."</a>";
}


	echo"<div id=\"".$rightcolumn."\">";


	echo"<br><br><h2>$title</h2>"; 

 
			function resimler($id){ 
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_eyar.php");
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_vekirin.php");


			$query=("SELECT * FROM newsmedia where nid='$id' AND type LIKE '%image%' order by rank ASC");

//echo $query;
			$result = mysql_query($query) or die(mysql_error()); 
			$num_rows = mysql_num_rows($result);
		
		if($num_rows==true){
			//$filetype=mysql_result($result,0,"type");


					echo"<div id=\"links\" class=\"media\" style=\"float:left;\">
						";
					while ($row=mysql_fetch_array($result)) {
    
echo"<a href=\"/info/images/l/photo-".$row['id'].".jpg\" title=\"".$row['titre']."\" data-toggle=\"lightbox\">";
			echo"<img src=\"/info/images/m/photo-".$row['id'].".jpg\"  class=\"mr-3 rounded img-fluid img-thumbnail\" style=\"height:auto;border:none;margin:0px;margin-right:15px;margin-bottom:10px;\" alt=\"".$row[7]."\" />";
echo"</a>"; 

//echo"<div class=\"media-body\"><p class=\"newsdesc\">".$row['legende']."</p></div>";

					}   
				echo"</div>";
				}
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_girtin.php");
			}

if($showfiles=="1"){
			resimler($id);
}
 

	echo $head; 


function wp($id){
	if($id=="46"){		 
		function distinctwp(){
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_eyar.php");
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_vekirin.php");
				$query=("SELECT distinct d.dwp, u.groupname,u.leader,u.groupdesc FROM delivinfo d, usergroups u WHERE d.dwp=u.wpid ORDER by groupname ASC");
		
		//echo $query;
				$result=mysql_query("$query") or die(mysql_error());
			
				$num_rows=mysql_num_rows($result);
				if($num_rows==true){
echo "<table id=\"liste\"><tr>";
echo "<th>Groupes de travail</th><th>Leader / Objectifs</th></tr>";
$counter="0";
					while($row = mysql_fetch_array($result)){


$titre=html_entity_decode($row['1'], ENT_COMPAT, 'utf-8');
$titre=htmlentities($titre, ENT_COMPAT, 'utf-8');


						$counter=$counter+1;
						echo"<tr><td><a href=\"/modules_de_travail/detail.php?id=".$row['0']."\" title=\"".$titre."\">".$titre."</a></td>";
						echo"<td style=\"vertical-align:top;\">".$row['2'];
/*
if($row['3']==true){
	echo"<div style=\"padding-left:30px;border:1px solid #f4f5f6;background-color:#fafafa\">".$row['3']."</div>";
}
*/
echo"</td></tr>";

					}
echo"</table>";
				}
			mysql_free_result($result);
			}
		echo distinctwp(); 
	}
}
 

echo  wp($id);


//echo "<hr style=\"background-color:#E0E0E0;width:80%;\" />";

	echo $full;


echo "<div style=\"height:30px;\"></div>";


			function fichiers($id){ 
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_eyar.php");
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_vekirin.php");
				//$query=("SELECT * FROM newsmedia where `type` NOT LIKE 'image/%' AND nid='$id' order by titre");

				$query=("SELECT * FROM newsmedia where `type` NOT LIKE 'image/%' AND nid='$id' order BY LENGTH(titre), titre");


//echo $query;
				$plus_photos=mysql_query($query);

				$hucre_sayisi=mysql_num_rows($plus_photos);
			
				if($hucre_sayisi==true){ 
					echo"<div id=\"divpdf\">";

					if($hucre_sayisi=="1"){ 
						echo"<h5>Ci-dessous le fichier li&eacute;:</h5>";
					}else{
						echo"<h5>Ci-dessous les fichiers li&eacute;s:</h5>";
					}


					echo"<ul style=\"background-image:url(/images/backnn.png);\">";
					while ($row=mysql_fetch_array($plus_photos)) {


$filetype=$row['type'];
$filesize=$row['size'];

				if ($filesize>=1024){
					$filesize=round($filesize/1024,2);
					$filesize=round($filesize/1024,2);
					$filesized=$filesize." MB";
				}else{
					if ($filesize>=1){
						$filesized=$filesize." KB";
					}else{
						$filesize=$filesize*1000;
						$filesized="~".$filesize." B";
					}
				}


	switch($filetype){
	case "application/download";
	case "application/pdf";


		$downloadfileurl=($_SERVER['DOCUMENT_ROOT']."/images/mediapdf/".$row['randomid'].".pdf");

		if(file_exists($downloadfileurl)){
			$downloadfileurl=("/images/mediapdf/".$row['randomid'].".pdf");
		}else{
			$downloadfileurl=("/images/mediapdf/fichier.php?id=".$row['randomid']."");
		}


	echo"
<li>
	<div style=\"overflow:auto;\">
		<div style=\"width:50px;float:left;\">
			<a href=\"".$downloadfileurl."\" target=\"_blank\" style=\"border:none;\"><img src=\"/images/icons/pdficon.gif\"></a>
		</div>
		<div style=\"float:left;\">
			<p style=\"margin:0px;padding:0px;\"><a href=\"".$downloadfileurl."\" target=\"_blank\" style=\"font:80% Verdana;\">".$row['titre']."</a></p>
			<p style=\"margin:0px;padding:0px;font:9px Verdana;font-style:italic;\">".$filesized."</p>
		</div>
	</div>
</li>";


	break;
}

/*
fichier.php?id=".$row['randomid']."

*/


	if($filetype!="application/pdf"){	


	switch($filetype){
		case "application/rtf":				$ext="rtf";		break;
		case "application/doc":				$ext="doc";		break;
		case "application/docx":			$ext="docx";	break;
		case "application/dot":				$ext="dot";		break;
		case "application/plain":			$ext="txt";		break;
		case "application/vnd.ms-excel":	$ext="xls";		break;
		case "application/vnd.ms-excel":	$ext="xlsx";	break;
		case "application/msword":			$ext="doc";		break;
		case "text/plain":					$ext="txt";		break;
		case "application/xlsx":			$ext="xlsx";	break;
	} 

	echo"
	<li>
		<div style=\"overflow:auto;\">
			<div style=\"width:50px;float:left;\">
				<img src=\"/images/icons/docicon.gif\" />
			</div>
			<div style=\"float:left;\">
			<p style=\"margin:0px;padding:0px;\"><a href=\"/images/mediadoc/fichier.php?id=".$row['randomid']."\" style=\"font:10px Verdana;\">".$row['titre']."</a></p>
			<p style=\"margin:0px;padding:0px;font:9px Verdana;font-style:italic;\">".$filesized."</p>
			</div>
		</div>
	</li>";


	}


					}  
				echo"</ul>";
				echo"</div>";
				}
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_girtin.php");
			}
			fichiers($id);


echo "</div>";
echo "</div>"; 


echo "<div class=\"col-md-4\">";


function listdecategoriesimg($id){ 
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
			include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
			$query=("SELECT * FROM newsmedia where nid='".$id."' AND type LIKE '%image%' order by rank ASC");
			$result = mysqli_query($conn,$query) or die(mysqli_error($conn)); 
			$num_rows = mysqli_num_rows($result);	 
			if($num_rows=='1'){
				$data = mysqli_fetch_object($result);
					$id=$data->id;
	
					$img="https://www.nazandbegikhani.com/info/images/crop/photo-270X181-".$id.".jpg";
			}
		return $img;
}

function listdecategories($category){ 
	include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_eyar.php");
	include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_vekirin.php");

	$query=("SELECT * FROM newsarticles WHERE status='1' AND category='".$category."' order by classement ASC");

 
	$result=mysql_query($query) or die(mysql_error($query));
	

	$num_rows=mysql_num_rows($result);
	if($num_rows==true){   
		while($row = mysql_fetch_array($result)){ 
echo"
                    <li>
                      <div class=\"unimedia-cell cell-max\">
                        <h4 class=\"unimedia-title fw-normal\"><a href=\"/info/".$row['newsurl'].".html\" class=\"fw-normal\">".$row['title']."</a></h4>
                      </div>
                      <div class=\"unimedia-cell\">
                        <div class=\"unimedia-img\">
                          <a href=\"/info/".$row['newsurl'].".html\" class=\"img-link\">
<img src=\"".listdecategoriesimg($row['id'])."\" alt=\"\"></a>
                        </div>
                      </div>
                    </li>";


		}
 
	}
}


echo"

                <div class=\"unicard unicard-framed pad-20 side-widget\">
                  <h4 class=\"case-u fw-bold fg-primary\">".categoryname($category)."</h4>
                  
                  <!-- post list -->
                  <ul class=\"unimedia-list post-list-sm\">
                  

";

 
	echo listdecategories($category);
 

echo"</ul>
                  <!-- /post list -->";

?>

</div>
                
<?

echo"</div>";


echo "</section>";

 
	include($_SERVER['DOCUMENT_ROOT']."/x_footer.php"); 
	include($_SERVER['DOCUMENT_ROOT']."/test/databases/4/db_girtin.php");
			} 

		}else{
			header("HTTP/1.1 301 Moved Permanently"); 
			header("Location: /info/"); 
		}

	}else{
		header("HTTP/1.1 301 Moved Permanently"); 
		header("Location: /info/"); 
	}

 
/*
	$tampon = ob_get_contents();
	$tampon = str_replace(array("\n", "\r", "\t"), "", $tampon);
	file_put_contents("$cache", $tampon) ; //pour une meilleure organisation, on créera un répertoire cache pour y stocker les fichiers du cache
	ob_end_clean(); // toujours fermer et vider le tampon
header("Refresh: 1; URL=".$_SERVER['REQUEST_URI']);
	}
*/ 


}else{
	header("HTTP/1.1 301 Moved Permanently"); 
	header("Location: /info/"); 
	exit;
}
?>