Example #1
0
}
if ($acces_j) {
    $statut_j = '';
    $statut_r = '';
} else {
    $statut_j = ',notice_statut';
    $statut_r = "and statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)" . ($_SESSION["user_code"] ? " or (notice_visible_opac_abon=1 and notice_visible_opac=1)" : "") . ")";
}
print "<div id='aut_details'>\n\n\t\t<h3><span>" . $msg["serie_see_title"] . "</span></h3>\n";
print "<div id='aut_details_container'>\n";
if ($id) {
    $id += 0;
    // affichage des informations sur l'éditeur
    print "<div id='aut_see'>\n";
    $ourSerie = new serie($id);
    print pmb_bidi($ourSerie->print_resume());
    $aut_link = new aut_link(AUT_TABLE_SERIES, $id);
    print pmb_bidi($aut_link->get_display());
    print "</div><!-- fermeture #aut_see -->\n";
    // affichage des notices associées
    print "\t<div id='aut_details_liste'>\n\n\t\t\t<h3>{$msg['doc_serie_title']}</h3>\n";
    // comptage des notices associées
    if (!$nbr_lignes) {
        //$requete = "SELECT COUNT(notice_id) FROM notices, notice_statut ";
        //$requete .= " where tparent_id='$id' and (statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)".($_SESSION["user_code"]?" or (notice_visible_opac_abon=1 and notice_visible_opac=1)":"")."))";
        $requete = "SELECT COUNT(*) FROM notices {$acces_j} {$statut_j} where tparent_id={$id} {$statut_r} ";
        $res = mysql_query($requete, $dbh);
        $nbr_lignes = @mysql_result($res, 0, 0);
        //Recherche des types doc
        //$requete="select distinct notices.typdoc FROM notices, notice_statut ";
        //$requete .= " where tparent_id='$id' and (statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)".($_SESSION["user_code"]?" or (notice_visible_opac_abon=1 and notice_visible_opac=1)":"")."))";