'all') $all_sql = "and a.idserie=$idserie "; switch ($coll) { case "acheter": $count_requete_fin=''; $SQL="SELECT a.*, b.display, c.display , d.display from $t_albums a, $t_auteurs b, $t_auteurs c, $t_auteurs d where a.idscenariste=b.idauteur and a.iddessinateur = c.idauteur and a.idcoloriste = d.idauteur and idserie=$idserie order by num, numa, right(a.dl, 4), left(a.dl, 2)"; break; case "albums": $count_requete_fin=''; $SQL="SELECT a.*, b.display, c.display , d.display from $t_albums a, $t_auteurs b, $t_auteurs c, $t_auteurs d where a.idscenariste=b.idauteur and a.iddessinateur = c.idauteur and a.idcoloriste = d.idauteur and idserie=$idserie order by num, numa, right(a.dl, 4), left(a.dl, 2)"; break; case "dedicace": $count_requete_fin=''; $SQL="SELECT a.*, b.display, c.display , d.display , s.titre from $t_albums a, $t_auteurs b, $t_auteurs c, $t_auteurs d , $t_series s where s.idserie=a.idserie and a.idscenariste=b.idauteur and a.iddessinateur = c.idauteur and a.idcoloriste = d.idauteur $all_sql and horsserie <> '' order by s.titre, num, numa, right(a.dl, 4), left(a.dl, 2)"; break; case "parabd": $count_requete_fin=''; $SQL="SELECT a.*, b.display from $t_albums a, $t_auteurs b where a.iddessinateur = b.idauteur and idserie=$idserie order by right(a.dl, 4), left(a.dl, 2)"; break; } if ($idserie == 'all') { entete("Détails pour toutes les dédicaces", "albums"); $requete = mysql_query($SQL); echo << HTML; echo " ".sort_header('Série', 'serie', 'auteur', $tri, $sens)."\n"; echo " #\n"; echo " ".sort_header('Titre', 'titre', 'auteur', $tri, $sens)."\n"; echo " ".sort_header('DL', 'dl', 'auteur', $tri, $sens)."\n"; echo " \n"; $parite = 0; while ($row = mysql_fetch_row ($requete)) { $wnum = ''; $wnuma = ''; $wbroche= ""; $wformat= ""; if ($row[1]) {$wnum = "$row[1]"; } if ($row[18]) {$wnuma = "($row[18])"; } $wpage = ($GLOBALS['GV_auteur'] == 1) ? LinkRef('serie', array($row[3])) : ''; echo " \n"; echo <<$row[33] $wnum$wnuma $row[2] $row[12] HTML; echo " \n"; $parite ^= 1; } echo " \n"; } else { $requete = mysql_query("SELECT * from $t_series where idserie=$idserie"); $row = mysql_fetch_row($requete); $titre = $row[1]; $style = $row[2]; $commentaire = nl2br($row[3]); $planche = $row[4]; $internet = $row[5]; switch ($row[6]) { Case ("0"): $encours = "Série finie"; break; Case ("1"): $encours = "Série en cours"; break; Case ("2"): $encours = "One Shot"; break; } entete("Détails pour $titre", "albums"); if ($planche) { echo "
"; AfficheImage($GLOBALS['PATH_planches'], $planche, 40); switch ($GLOBALS['GV_miniature']) { Case ("0"): $w_filename = $GLOBALS['PATH_planches']."/".$planche; break; Case ("1"): $w_filename = Miniature($planche, $GLOBALS['PATH_planches'], $GLOBALS['THUMB_planches'], $GLOBALS['GV_prefix'], 200, 280); break; Case ("2"): $w_filename = $GLOBALS['THUMB_planches']."/".$GLOBALS['GV_prefix'].$planche; break; } echo "\"une\n"; } else { if (file_exists($GLOBALS['PATH_planches']."/Encours.jpg")) { echo "
"; echo "\"image\n"; } else { echo "
"; } } echo <<$titre

$style

$encours

$commentaire


HTML; } $requete = mysql_query($SQL); DetailSerie($requete, $count_requete_fin); Pied(); ?>