</tr> <tr> <td colspan="2" class="txt"><?php $formate = stripslashes($titre1[1]); $formate = substr($formate, 0, 150); echo "{$formate} ..."; ?> </td> </tr> <tr> <td width="90%" height="26"><?php taille($titre1[4], $titre1[3]); ?> détail de l'article</a></td> <td valign="top" width="20" align="right"><img src="../zimages/<?php $nom = imagelu($titre1[3], $id_user); echo "{$nom}"; ?> " width="20" height="24"></td> </tr> </table> </td> </tr> <tr> <td class="lelien" colspan="2"> <?php actifs($id_user); ?> <table width="100%" border="0" cellspacing="4" name="tab04"> <tr> <td class="titrtabl" width="24%">date de création</td>
function listing($id_user, $service, $page) { /* -- $n varible qui defini le nombre de ligne qui s'affichent dans le listing -- */ if ($id_user) { //Si l'utilisateur est connécté $affichage = DatabaseOperation::query("select * from perso where id_user={$id_user}"); $na = mysql_fetch_array($affichage); } if (!$na[nbligne]) { $nb = 20; } else { $nb = $na[nbligne]; } /* --- choix de l'order en fonction du choix utilisateur et definition si po encore inscrit --- */ if (!$na[date]) { $order = "desc"; } else { if ($na[date] == 1) { $order = ""; } else { if ($na[date] == 2) { $order = "desc"; } } } if ($id_user) { //Si l'utilisateur est connecté /* systeme d'exclusion ou non des infos deja lu */ if (!$na[lu]) { $result2 = "SELECT * FROM modes, articles left join lu on (articles.num_article = lu.id_art) and (lu.id_user = {$id_user}) WHERE lu.id_art is null and (modes.id_user = {$id_user})"; } else { if ($na[lu] == 1) { $result2 = "SELECT * FROM articles, modes WHERE (modes.id_user = {$id_user}) "; } else { if ($na[lu] == 2) { $result2 = "SELECT * FROM modes, articles left join lu on (articles.num_article = lu.id_art) and (lu.id_user = {$id_user}) WHERE lu.id_art is null and (modes.id_user = {$id_user})"; } } } /* retrouver le niveau du user dans la table mode et sortir les articles en fonction de ce nivo modes */ $result2 .= "and (articles.id_art_serv = modes.id_service)"; $result2 .= "and (articles.nivo_conf <= modes.serv_conf)"; /* ---- defini la page service sur laquelle on se trouve ---- */ $result2 .= "and (articles.id_art_serv = '{$service}')"; //$result2 .= "and (articles.homepage = '4') "; $result2 .= "and (articles.publica != '')"; $result2 .= "and (articles.diffusion = '')"; /* rajouter dans l'order l'ordre souhaité par l'utilisateur */ $result2 .= "order by date_modif {$order} "; } else { /* systeme d'exclusion ou non des infos deja lu */ /* if(!$na[lu]){$result2 ="SELECT * FROM modes, articles left join lu on (articles.num_article = lu.id_art) and (lu.id_user = $id_user) WHERE lu.id_art is null and (modes.id_user = $id_user)";} else if($na[lu]==1){$result2 ="SELECT * FROM articles, modes WHERE (modes.id_user = $id_user) ";} else if($na[lu]==2){$result2 ="SELECT * FROM modes, articles left join lu on (articles.num_article = lu.id_art) and (lu.id_user = $id_user) WHERE lu.id_art is null and (modes.id_user = $id_user)";} $result2 .= "and (articles.id_art_serv = modes.id_service)"; $result2 .= "and (articles.nivo_conf <= modes.serv_conf)"; $result2 .= "and (articles.id_art_serv = '$service')"; //$result2 .= "and (articles.homepage = '4') "; $result2 .= "and (articles.publica != '')"; $result2 .= "and (articles.diffusion = '')"; $result2 .= "order by date_modif $order "; */ $date_limite = date("Y-m-d", mktime(0, 0, 0, date("m") - 4, date("d"), date("Y"))); $result2 = "SELECT * FROM articles WHERE "; /* retrouver le niveau du user dans la table mode et sortir les articles en fonction de ce nivo modes */ //$test .= " and (articles.id_art_serv = modes.id_service)"; $result2 .= " (articles.nivo_conf = '1')"; // $test .= " and (articles.homepage = '$homepage') "; /* ---- defini la page service sur laquelle on se trouve ---- */ $result2 .= " and (articles.id_art_serv = '{$service}') "; $result2 .= " and (articles.publica != '') "; $result2 .= " and (articles.diffusion = '') "; $result2 .= "and (articles.date_modif > '{$date_limite} 00:00:00' ) "; /* --- on rajoute la fonction du non lu pour ordonner si on le souhaite --- */ $result2 .= "order by articles.nivo_conf desc, date_modif DESC limit 0,1"; } if (empty($page)) { $page = 1; } $requete = DatabaseOperation::query("{$result2}"); $total = mysql_num_rows($requete); $debut = ($page - 1) * $nb; $result2 .= "LIMIT {$debut},{$nb}"; if ($requete = @DatabaseOperation::query("{$result2}")) { while ($rows = mysql_fetch_array($requete)) { echo "<tr bgcolor=\"#FFFFCC\">"; /* ------------ formatage date ------------- */ $date = $rows[date_crea]; $jour = substr($date, 8, 2); $mois = substr($date, 5, 2); $annee = substr($date, 0, 4); $date = $jour . "/" . $mois . "/" . $annee; $titreart = stripslashes($rows[titre_art]); $auteurart = stripslashes($rows[auteur]); $sujetart = stripslashes($rows[sujet]); echo "<td class=\"txttabl\" width=\"22%\">{$date}</td>"; echo "<td class=\"txttabl\" width=\"24%\">{$titreart}</td>"; echo "<td class=\"txttabl\" width=\"24%\">"; $ab = DatabaseOperation::query("select * from salaries where id_user='******'"); $ligne = mysql_fetch_array($ab); echo "{$ligne['nom']} {$ligne['prenom']}</td>"; echo "<td class=\"txttabl\" width=\"24%\">{$sujetart}<br>"; taille($rows[taille], $rows[num_article]); echo "détail de l'article</a></td>"; echo "<td align=\"center\" bgcolor=\"#FFFFFF\"><img src=\"../zimages/"; $nomimg = imagelu($rows[num_article], $id_user); echo "{$nomimg}"; echo "\" width=\"20\" height=\"24\"></td>"; } } echo "</tr>"; echo "</table>"; echo "<table width=\"100%\" border=\"0\" cellspacing=\"4\">"; echo "<tr>"; echo "<td width=80% align=center>"; $nbpages = ceil($total / $nb); for ($i = 1; $i <= $nbpages; $i++) { echo "<a href=\"{$PHP_SELF}?page={$i}&service={$service}\"><font size=1 color=#000000><b>"; if ($page == $i) { echo "<font color=#FF6600><b> page{$i} </b></font></a>\n"; } else { echo "<font color=#000000><b> page{$i} </b></font></a>\n"; } if ($i < $nbpages) { echo " - "; } } echo "</td>"; }