";
echo"
";
function categoryname($category){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT * FROM newscats WHERE cid='".$category."'");
$result = mysqli_query($conn,$query) or die(mysqli_error($conn));
$num_rows = mysqli_num_rows($result);
$data=mysqli_fetch_object($result);
$cid=$data->cid;
$cat=$data->cat;
$navnisan=$data->navnisan;
return $cat;
}
function listdecategories($category){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT * FROM newsarticles WHERE status='1' AND category='".$category."'");
$result=mysqli_query($conn,$query) or die(mysqli_error($conn));
$num_rows=mysqli_num_rows($result);
if($num_rows==true){
echo"";
}
}
echo listdecategories($category);
function category($category){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT * FROM newscats WHERE cid='".$category."'");
$result = mysqli_query($conn,$query) or die(mysqli_error());
$num_rows = mysqli_num_rows($result);
$cid=mysqli_result($result,0,"cid");
$cat=mysqli_result($result,0,"cat");
$navnisan=mysqli_result($result,0,"navnisan");
return "".$cat."";
}
/*
echo "";
*/
echo"
";
include($_SERVER['DOCUMENT_ROOT']."/x_footer.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/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;
}
?>";
if($category!='1'){
echo $head;
}
function resimler($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 ordre ASC");
//echo $query;
$result = mysqli_query($conn,$query) or die(mysqli_error());
$num_rows = mysqli_num_rows($result);
if($num_rows==true){
//$filetype=mysqli_result($result,0,"type");
echo"
";
}
mysqli_free_result($result);
}
echo distinctwp();
}
}
echo wp($id);
//echo "
"; echo $full; echo ""; function fichiers($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 `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=mysqli_query($query); $hucre_sayisi=mysqli_num_rows($plus_photos); if($hucre_sayisi==true){ echo"
";
echo "";
echo'";
echo"
";
}
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_girtin.php");
}
if($showfiles=="1"){
resimler($id);
}
function wp($id){
if($id=="46"){
function distinctwp(){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/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=mysqli_query("$query") or die(mysqli_error());
$num_rows=mysqli_num_rows($result);
if($num_rows==true){
echo "- ';
while ($row=mysqli_fetch_array($result)) {
/*
$filetype=$row['type'];
switch($filetype){
case "image/pjpeg";
case "image/jpeg";
case "image/gif";
case "image/tiff";
case "image/png";
break;
}*/
echo"
".$row['titre']."
"; echo"![\"".$row[7]."\"](\"/info/images/s/actualite_".$row['id'].".jpg\")
";
echo"".$row['legende']."
";
}
echo"
![\"".$row[7]."\"](\"/info/images/m/actualite_".$row['id'].".jpg\")
";
echo"| Groupes de travail | Leader / Objectifs |
|---|---|
| ".$titre." | "; echo"".$row['2'];
if($row['3']==true){
echo" ".$row['3']." ";
}
echo" |
"; echo $full; echo ""; function fichiers($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 `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=mysqli_query($query); $hucre_sayisi=mysqli_num_rows($plus_photos); if($hucre_sayisi==true){ echo"
";
if($hucre_sayisi=="1"){
echo"
";
}
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_girtin.php");
}
fichiers($id);
echo "Ci-dessous le fichier lié:
"; }else{ echo"Ci-dessous les fichiers liés:
"; } echo"- ";
while ($row=mysqli_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";
echo"
-
![](\"/images/icons/pdficon.gif\")
".$filesized."
";
break;
}
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"
-
![](\"/images/icons/docicon.gif\")
".$filesized."
";
}
}
echo"