$libelleResult !!cle!!
!!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 = "$PHP_SELF?categ=auteurs&sub=reach&user_input=".rawurlencode(stripslashes($user_input));
$author_list = "
| ".$msg[103]." |
".$msg["count_notices_assoc"]." |
";
// 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
$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
| ";
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);
}