$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 "; } $alaune .= "\n
 $title\n"; $alaune .= "$headline..."; $alaune .= "
$city: $type de $auteur: - le $datetime "; if($pdf){ $pdf = explode(",",$pdf); $mypdf=$pdf[0]; $alaune .= " "; } if($video){ $video = explode(",",$video); for($n=0; $n < count($video); $n++) { $myvideo= $video[$n]; #$alaune .= " "; } } $alaune .="
\n\n "; if($index==200){break;} } ?>