$libelleResult !!cle!!

!!list!!
!!nav_bar!!
"; // on récupére le nombre de lignes qui vont bien if(!$nbr_lignes) { if(!$user_input) { $requete = "SELECT count(1) FROM authors ".$id_type; if ($last_param) $requete = "SELECT count(1) FROM authors ".$tri_param." ".$limit_param; } else { $aq=new analyse_query(stripslashes($user_input),0,0,1,1); if ($aq->error) { auteur::search_form($type_autorite); error_message($msg["searcher_syntax_error"],sprintf($msg["searcher_syntax_error_desc"],$aq->current_car,$aq->input_html,$aq->error_message)); exit; } $requete=$aq->get_query_count("authors","concat(author_name,', ',author_rejete)","index_author","author_id"); $requete.= $val_type; } $res = mysql_query($requete, $dbh); $nbr_lignes = mysql_result($res, 0, 0); } else $aq=new analyse_query(stripslashes($user_input),0,0,1,1); if(!$page) $page=1; $debut =($page-1)*$nb_per_page; if($nbr_lignes) { $authors_list_tmpl=str_replace( "",$nbr_lignes.' ',$authors_list_tmpl); $url_base = "./autorites.php?categ=auteurs&sub=reach&user_input=".rawurlencode(stripslashes($user_input)); $author_list = " ".$msg[103]." ".$msg["count_notices_assoc"]." "; $num_auth_present=false; $req="SELECT id_authority_source FROM authorities_sources WHERE authority_type='author' AND TRIM(authority_number) !='' LIMIT 1"; $res_aut=mysql_query($req,$dbh); if($res_aut && mysql_num_rows($res_aut)){ $author_list=str_replace("","".$msg["authorities_number"]."",$author_list); $num_auth_present=true; } // on lance la vraie requête if(!$user_input) { $requete = "SELECT * FROM authors ".$id_type; $requete .= "ORDER BY index_author LIMIT $debut,$nb_per_page "; if ($last_param) $requete = "SELECT * FROM authors ".$tri_param." ".$limit_param; } else { $members=$aq->get_query_members("authors","concat(author_name,', ',author_rejete)","index_author","author_id"); $requete = "select *, ".$members["select"]." as pert from authors where ".$members["where"]." ".$val_type." group by author_id order by pert desc, index_author limit $debut,$nb_per_page"; } $res = @mysql_query($requete, $dbh); $parity=1; while(($author=mysql_fetch_object($res))) { $aut = new auteur($author->author_id,1); $author_entry=$aut->isbd_entry; $link_auteur = "./autorites.php?categ=auteurs&sub=author_form&id=$author->author_id&user_input=".rawurlencode(stripslashes($user_input))."&nbr_lignes=$nbr_lignes&page=$page"; if($author->author_see) { // auteur avec renvoi // récupération des données de l'auteur cible $see = new auteur($author->author_see,1); $author_voir=$see->isbd_entry; /*$temp_requete = "SELECT * FROM authors WHERE author_id=$author->author_see LIMIT 1 "; $temp_res = mysql_query($temp_requete, $dbh); $see = mysql_fetch_object($temp_res); if($see->author_rejete) $author_voir = $see->author_name.', '.$see->author_rejete; else $author_voir = $see->author_name; if($see->author_date) $author_voir .= " ($see->author_date)";*/ $author_voir = "$author_voir"; $author_entry .= ". - $msg[210] : ".$author_voir; } $notice_count_sql = "SELECT count(distinct responsability_notice) FROM responsability WHERE responsability_author = ".$author->author_id; $notice_count = mysql_result(mysql_query($notice_count_sql), 0, 0); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" "; $author_list .= " $author_entry "; //Numéros d'autorite if($num_auth_present){ $requete="SELECT authority_number,origin_authorities_name, origin_authorities_country FROM authorities_sources JOIN origin_authorities ON num_origin_authority=id_origin_authorities WHERE authority_type='author' AND num_authority='".$author->author_id."' AND TRIM(authority_number) !='' GROUP BY authority_number,origin_authorities_name,origin_authorities_country ORDER BY authority_favorite DESC, origin_authorities_name"; $res_aut=mysql_query($requete,$dbh); if($res_aut && mysql_num_rows($res_aut)){ $author_list .= ""; $first=true; while ($aut = mysql_fetch_object($res_aut)) { if(!$first)$author_list .=", "; $author_list .=htmlentities($aut->authority_number,ENT_QUOTES,$charset); if($tmp=trim($aut->origin_authorities_name)){ $author_list .=htmlentities(" (".$aut->origin_authorities_name.")",ENT_QUOTES,$charset); } $first=false; } $author_list .= ""; }else{ $author_list .= " "; } } if($notice_count && $notice_count!=0) $author_list .= "author_id';\">".($notice_count).""; else $author_list .= " "; $author_list .= ""; } // fin while mysql_free_result($res); $url_base = $url_base."&type_autorite=".$type_autorite; if (!$last_param) $nav_bar = aff_pagination ($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true) ; else $nav_bar = ""; // affichage du résultat list_authors($user_input, $author_list, $nav_bar,$type_autorite); } else { // la requête n'a produit aucun résultat auteur::search_form($type_autorite); error_message($msg[211], str_replace('!!author_cle!!', stripslashes($user_input), $msg[212]), 0, './autorites.php?categ=auteurs&sub=&id='); } function list_authors($cle, $author_list, $nav_bar,$type_autorite) { global $authors_list_tmpl; global $charset ; $authors_list_tmpl = str_replace("!!cle!!", htmlentities(stripslashes($cle),ENT_QUOTES, $charset), $authors_list_tmpl); $authors_list_tmpl = str_replace("!!list!!", $author_list, $authors_list_tmpl); $authors_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $authors_list_tmpl); auteur::search_form($type_autorite); print pmb_bidi($authors_list_tmpl); }