//ajout d'un avis echo $avis_tpl_form; break; default: case 'liste': if ($log_ok && $allow_avis && $allow_avis_ajout) { echo "<p align='right'><a href=\"avis.php?todo=add¬iceid={$noticeid}&login={$user_code}\">" . $msg[avis_lien_ajout] . "</a></p>"; } //affichage de la liste des avis //moyenne des notes $sql = "select avg(note) as m from avis where valide=1 and num_notice='" . $noticeid . "' group by num_notice"; $r = pmb_mysql_query($sql, $dbh); $loc = pmb_mysql_fetch_object($r); $moyenne = number_format($loc->m, 1, ',', ''); $c_notice = new notice_affichage($noticeid, ""); $etoiles_moyenne = $c_notice->stars(); //liste des témoignages $requete = "select note,sujet,commentaire,DATE_FORMAT(dateajout,'" . $msg['format_date'] . "') as ladate,empr_login,empr_nom, empr_prenom\n\t\t\t\tfrom avis\n\t\t\t\tleft join empr on id_empr=num_empr\n\t\t\t\twhere valide=1 and num_notice='" . $noticeid . "'\n\t\t\t\torder by dateajout desc"; $r = pmb_mysql_query($requete, $dbh); if (pmb_mysql_num_rows($r)) { echo "<div class='row'>\n\t\t\t\t\t<div class='left'><b>" . $msg['avis_titre_tous'] . ":</b> " . $msg['avis_note'] . ": {$moyenne}</div>\n\t\t\t\t\t<div class='right'>{$etoiles_moyenne}</div> \n\t\t\t\t\t</div>"; $cpt_star = 4; while ($loc = pmb_mysql_fetch_object($r)) { $etoiles = ""; for ($i = 1; $i <= $loc->note; $i++) { $etoiles .= "<img border=0 src='" . get_url_icon('star.png') . "' align='absmiddle'>"; } for ($j = round($loc->note); $j <= $cpt_star; $j++) { $etoiles .= "<img border=0 src='" . get_url_icon('star_unlight.png') . "' align='absmiddle'>"; } echo "<hr /><div class='row'>\n\t\t\t\t\t<div class='left'><b>{$loc->sujet}</b>, " . $loc->ladate;