$msg[334] !!cle!!
!!nav_bar!!
";
function list_serie($cb, $empr_list, $nav_bar) {
global $serie_list_tmpl;
$serie_list_tmpl = str_replace("!!cle!!", $cb, $serie_list_tmpl);
$serie_list_tmpl = str_replace("!!list!!", $empr_list, $serie_list_tmpl);
$serie_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $serie_list_tmpl);
serie::search_form();
print pmb_bidi($serie_list_tmpl);
}
// on récupére le nombre de lignes qui vont bien
if(!$nbr_lignes) {
if(!$user_input) {
$requete = "SELECT count(1) FROM series ";
if ($last_param)
$requete = "SELECT count(1) FROM series ".$tri_param." ".$limit_param;
} else {
$aq=new analyse_query(stripslashes($user_input));
if ($aq->error) {
serie::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("series","serie_name","serie_index","serie_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) {
$serie_list_tmpl=str_replace( "",$nbr_lignes.' ',$serie_list_tmpl);
$serie_list = "
| ".$msg[103]." |
".$msg["count_notices_assoc"]." |
";
// on lance la vraie requête
if(!$user_input) {
$requete = "SELECT * FROM series ORDER BY serie_name LIMIT $debut,$nb_per_page ";
if ($last_param) $requete = "SELECT * FROM series ".$tri_param." ".$limit_param;
} else {
$members=$aq->get_query_members("series","serie_name","serie_index","serie_id");
$requete="select *,".$members["select"]." as pert from series where ".$members["where"]." group by serie_id order by pert desc, serie_index limit $debut,$nb_per_page";
}
$res = @mysql_query($requete, $dbh);
$parity=1;
$url_base = "$PHP_SELF?categ=series&sub=reach&user_input=".rawurlencode(stripslashes($user_input)) ;
while(($serie=mysql_fetch_object($res))) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$notice_count_sql = "SELECT count(*) FROM notices WHERE tparent_id = ".$serie->serie_id;
$notice_count = mysql_result(mysql_query($notice_count_sql), 0, 0);
$tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" ";
$serie_list.= "
| serie_id&user_input=".rawurlencode(stripslashes($user_input))."&nbr_lignes=$nbr_lignes&page=$page';\">
$serie->serie_name
| ";
if($notice_count && $notice_count!=0)
$serie_list.= "serie_id'\">".$notice_count." | ";
else $serie_list.= " | ";
$serie_list.= "
";
}
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_serie($user_input, $serie_list, $nav_bar);
} else {
// la requête n'a produit aucun résultat
serie::search_form();
error_message($msg[152], str_replace('!!titre_cle!!', stripslashes($user_input), $msg[335]), 0, './autorites.php?categ=series&sub=&id=');
}