';
echo'
| '.$tete.' |
';
echo'';
// variables
$nb = $nb_aff;
$datum = date('Y-m-01');
// connection bdd
$c = @mysql_connect($host,$login_host,$pass_host) or die('connection impossible');
@mysql_select_db($hostname,$c) or die('selection impossible');
// initialisation des variables 2 et
// si la variable 2 n'est pas defini, on la fixe a 1
if (!isset($_GET['page'])) $page = 1;
// sinon on recupere la valeur numerique recue en paramètre
else $page = intval($_GET['page']);
// meme principe pour la variable
if (!isset($_GET['total']))
{
// nombre total de résultats
if($archives != 'on') {
$sql = @mysql_query("select id from ".$prefixe." WHERE valide!='inv'");
}
if($archives == 'on') {
$sql = @mysql_query("select id from ".$prefixe." WHERE valide!='inv' AND date >= '".$datum."'");
}
$total = @mysql_num_rows($sql);
}
else $total = intval($_GET['total']);
// on determine debut du limit
$debut = ($page - 1) * $nb;
//voir pour ordre
// requete sql
if($archives != 'off') {
$sql = "SELECT *, DATE_FORMAT(date, '%d.%m.%Y') as date FROM ".$prefixe." WHERE valide!='inv' AND date >= '".$datum."' ORDER BY id $ordre LIMIT ".intval($debut).",".intval($nb);
} else {
$sql = "SELECT *, DATE_FORMAT(date, '%d.%m.%Y') as date FROM ".$prefixe." WHERE valide!='inv' ORDER BY id $ordre LIMIT ".intval($debut).",".intval($nb);
}
// parcours et affichage des résultats
if($p = @mysql_query($sql,$c)){
while($data = @mysql_fetch_array($p)){
$sql2 = "SELECT * FROM ".$prefixe."_smileys";
// on envoie la requête
$req2 = mysql_query($sql2) or die('Erreur SQL !
'.$sql2.'
'.mysql_error());
while($resultat = mysql_fetch_array($req2)) {
$data['texte'] = str_replace($resultat['code'],'
',$data['texte']);
}
// $couleur = $cadre_color
$data['texte'] = stripslashes($data['texte']);
$data['texte'] = str_replace("']","'>",$data['texte']);
$data['texte'] = str_replace('/]','">',$data['texte']); // pour les anciennes versions
$data['texte'] = str_replace('[b]','
',$data['texte']);
$data['texte'] = str_replace('[/b]','',$data['texte']);
$data['texte'] = str_replace('[i]','
',$data['texte']);
$data['texte'] = str_replace('[/i]','',$data['texte']);
$data['texte'] = str_replace('[u]','
',$data['texte']);
$data['texte'] = str_replace('[/u]','',$data['texte']);
$data['texte'] = str_replace("[color='","
',$data['texte']);
$data['texte'] = str_replace("[size='","',$data['texte']);
$data['texte'] = str_replace("[url='","',$data['texte']);
$data['texte'] = str_replace('[center]','',$data['texte']);
$data['texte'] = str_replace('[/center]','
',$data['texte']);
$data['texte'] = str_replace('[right]','',$data['texte']);
$data['texte'] = str_replace('[/right]','
',$data['texte']);
$data['texte'] = str_replace('[tableau]','',$data['texte']);
$data['texte'] = str_replace('[/tableau]','
',$data['texte']);
$data['texte'] = str_replace('[ligne]','',$data['texte']);
$data['texte'] = str_replace('[/ligne]','
',$data['texte']);
$data['texte'] = str_replace('[case]','',$data['texte']);
$data['texte'] = str_replace('[/case]',' | ',$data['texte']);
$data['texte'] = str_replace("[thc='","
',$data['texte']);
$data['texte'] = str_replace("[thr='"," | ',$data['texte']);
$id = intval($data['id']);
$sql2 = "SELECT id FROM ".$prefixe."_comments WHERE news='$id'";
$req = mysql_query($sql2) or die('Erreur SQL !'.$sql2.'
'.mysql_error());
$res = mysql_num_rows($req);
$id_auteur = $data['name'];
if(!empty($id_auteur)) {
if(intval($id_auteur)) {
$sql2 = "SELECT * FROM ".$prefixe."_admins WHERE id='$id_auteur'";
$req = mysql_query($sql2) or die('Erreur SQL !'.$sql2.'
'.mysql_error());
$result = mysql_fetch_array($req);
$result = $result['login'];
if(!empty($result)) {
$result = stripslashes($result);
} else {
$result = 'Administrateur inconnu';
} }
else {
$result = stripslashes($id_auteur);
}
}
echo'
';
}
echo'';
// calcul du nombre de pages
$nbpages = ceil($total / $nb); // arrondi a l'entier superieur
// on affiche les pages
echo' | ';
for($i = 1;$i <= $nbpages;$i ++){
echo'['.$i.']';
if($i < $nbpages) echo '';
}
if($total < 1) echo'aucune news pour le moment ou pour le mois en cours.';
}
echo' | | ';
if($archives != 'off') {
echo'';
}
if($proposition != 'non') {
echo'';
}
echo'';
if($formulaire == 'oui') {
echo' ';
echo'';
echo'| '.$pied.' | ';
echo' ';
mysql_close();
?>
| 
