$msg[173] !!cle!!

!!list!!
!!nav_bar!!
"; function list_collection($coll, $collection_list, $nav_bar) { global $collection_list_tmpl; global $charset; $collection_list_tmpl = str_replace("!!cle!!", $coll, $collection_list_tmpl); $collection_list_tmpl = str_replace("!!list!!", $collection_list, $collection_list_tmpl); $collection_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $collection_list_tmpl); collection::search_form(); print pmb_bidi($collection_list_tmpl); } // on récupére le nombre de lignes qui vont bien if(!$nbr_lignes) { if(!$user_input) { $requete = "SELECT count(1) FROM collections $tri_param "; if ($last_param) $requete = "SELECT count(1) FROM collections ".$tri_param." ".$limit_param; } else { $aq=new analyse_query(stripslashes($user_input)); if ($aq->error) { collection::search_form(); 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("collections","collection_name","index_coll","collection_id"); } $res = mysql_query($requete, $dbh); $nbr_lignes = mysql_result($res, 0, 0); } else $aq=new analyse_query(stripslashes($user_input)); if(!$page) $page=1; $debut =($page-1)*$nb_per_page; if($nbr_lignes) { $collection_list_tmpl=str_replace( "",$nbr_lignes.' ',$collection_list_tmpl); $collection_list .= " ".$msg[103]." ".$msg[165]." ".$msg["count_notices_assoc"]." "; // on lance la vraie requête if(!$user_input) { $requete = "SELECT * FROM collections A left join publishers B on ed_id=collection_parent "; $requete .= " $tri_param LIMIT $debut,$nb_per_page "; if ($last_param) $requete = "SELECT * FROM collections A left join publishers B on ed_id=collection_parent ".$tri_param." ".$limit_param; } else { $members=$aq->get_query_members("collections","collection_name","index_coll","collection_id"); $requete="select collections.*, publishers.*, ".$members["select"]." as pert from collections left join publishers on ed_id=collection_parent where ".$members["where"]." group by collection_id order by pert desc,index_coll,index_publisher limit $debut,$nb_per_page"; } $res = @mysql_query($requete, $dbh); $parity=1; $url_base = "$PHP_SELF?categ=collections&sub=reach&user_input=".rawurlencode(stripslashes($user_input)) ; while(($coll=mysql_fetch_object($res))) { if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $notice_count_sql = "SELECT count(*) FROM notices WHERE coll_id = ".$coll->collection_id; $notice_count = mysql_result(mysql_query($notice_count_sql), 0, 0); $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" "; $collection_list.= " collection_id&user_input=".rawurlencode(stripslashes($user_input))."&nbr_lignes=$nbr_lignes&page=$page';\"> ".htmlentities($coll->collection_name,ENT_QUOTES, $charset); if($coll->collection_parent) $collection_list .= " ($coll->ed_name)"; $collection_list .= " ".htmlentities($coll->collection_issn,ENT_QUOTES, $charset).""; if($notice_count && $notice_count!=0) $collection_list .= "collection_id'\">".$notice_count.""; else $collection_list .= " "; $collection_list .= ""; } // fin while mysql_free_result($res); 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_collection($user_input, $collection_list, $nav_bar); } else { // la requête n'a produit aucun résultat collection::search_form(); error_message($msg[175], str_replace('!!cle!!', stripslashes($user_input), $msg[174]), 0, './autorites.php?categ=collections&sub=&id='); }