$type";
$mytype=$type;
$unixdate= time(void);
$frenchdate=frenchdate($unixdate);
$unixhier= $unixdate - (24 * 3600);
$frenchhier = frenchdate($unixhier);
$unixavanthier = $unixdate - (48 * 3600);
$frenchavanthier = frenchdate($unixavanthier);
$fortnite=fortnite($unixdate);
$myagenda="";
$currentdate= date("Ymd");
$currentdate2=$currentdate ."000000";
#echo $currentdate2;
#echo $currentdate;
$md_date = date("md");
$year = date("Y");
$hier=hier($unixdate);
$douze=douzeheures($unixdate);
$demain =demain($unixdate);
$demain = substr($demain,0,9);
$avanthier=avanthier($unixdate);
$lastweek=lastweek($unixdate);
$lastweek2=$lastweek . "000000";
$lastmonth=lastmonth($unixdate);
$lastmonth= substr($lastmonth,0,9);
$nextmonth=nextmonth($unixdate);
#echo "lm: $lastmonth";
if(!$lastid){$lastid=10000;}
#echo " $frenchdate";
$sql7="SELECT *,UNIX_TIMESTAMP(date) as madate from news
WHERE code =1
AND type <> 'Flash Info'
AND type LIKE '%$type%'
AND section LIKE '%$section%'
AND auteur LIKE '%$auteur%'
AND langue LIKE 'fr'
AND city LIKE '%$mycity%'
AND date LIKE '$mydate%'
ORDER by id DESC
LIMIT 100
";
$result7 = @mysqli_query($mysqli,$sql7);
while ($row7 = mysqli_fetch_assoc($result7)){
$une[]=$row7[0];
$stamp=$row7[2];
$city=$row7[1];
#$city=format($city);
$city=ucfirst($city);
$fenchdate=frenchdate($row7[madate]);
$datetime=datetime($row7[madate]);
$eventdate=$row7[21];
$organization= $row7[4];
$organization= stripslashes($organization);
$organization=ucfirst($organization);
#$headline = preg_replace('/[\r\n]+/s', ' ', $headline);
$id=$row7[0];
$dir=substr($id,0,2);
$auteur=$row7[5];
$auteur=stripslashes($auteur);
$auteur2=$row7[5];
$type=$row7[9];
#$type=strtoupper($type);
$type=ucwords($type);
$auteur=ltrim($auteur);
$auteur=htmlentities($auteur);
#$auteur=stripslashes($auteur);
$media=$row7[media];
$video=$row7[video];
$pdf=$row7[pdf];
$clip=$row7[audio];
$count=$row7[count];
$email=$row7[email];
$photo=$row7[image];
#echo $photo;
$section=$row7[section];
$forum = $row7[forum];
$index++;
$title=$row7[3];
# $title=format($title);
$title=stripslashes($title);
#$title = preg_replace("/&([a-z])[a-z]+;/i","$1",$title);
$headline=$row7[8];
$headline=substr($headline,0,300);
# $headline = format($headline);
$friendly=$row7['friendly_url'];
$friendly=$friendly . "-" . $id;
$alaune .="
";
$sql33="SELECT * FROM PHOTOS
WHERE article_id='$id'
LIMIT 1
";
$result33 = mysqli_query($mysqli,$sql33);
$row33=mysqli_fetch_assoc($result33);
$photo=$row33['photo_nom'];
if($photo){
$path="thumbs/$dir/$id/$photo";
#echo "p: $path";
$alaune .= "\n![](\"$path\") | ";
}
$alaune .= "\n $title\n";
$alaune .= "$headline...";
$alaune .= "
$city: $type de $auteur: - le $datetime ";
if($pdf){
$pdf = explode(",",$pdf);
$mypdf=$pdf[0];
$alaune .= "![](\"images/pdf.gif\") ";
}
if($video){
$video = explode(",",$video);
for($n=0; $n < count($video); $n++) {
$myvideo= $video[$n];
#$alaune .= "![](\"images/camera.gif\") ";
}
}
$alaune .="
|
\n\n ";
if($index==200){break;}
}
?>