/* Search Results */

Initializing...
"; print "Connecting to ASUKA's Notebook database..."; MYSQL_connect("localhost","asukanote","eva020") or die("
A_ERROR 415:
Impossible de se connecter à la base. Si le problème persiste, contactez Axel."); Print "OK!"; Print "
Selecting the \"Fanfictions\" section..."; @mysql_select_db("asukanote") or die("
A_ERROR 417:
Unable to select the database, if the problem persists, contact Axel."); //mysql_select_db("Axel") or die("
A_ERROR 417:
Impossible de sélectionner la base. Si le problème persiste, contactez Axel."); Print "OK!

"; //L'ordre d'affichage par défaut $order = "ff.title"; //Le contenu par défaut de la clause FROM $queryfrom = "anfanfic ff,angenre g,anchapter chp,anauthor aut,anauthor_fanfic a_f"; //Le contenu par défaut de la clause WHERE $querywhere = "ff.numgenre=g.numgenre AND chp.numfanfic=ff.numfanfic AND a_f.numfanfic=ff.numfanfic AND aut.numauthor=a_f.numauthor"; //Le contenu par défaut de la clause GROUP BY (utile pour éviter les répétitions) $group = "ff.numfanfic"; //au cas ou le display alphabétique est utilisé if ($alphadisplay != "") { switch($alphadisplay) { case "[A-Z]": break; case "[0-F]": $querywhere = "$querywhere AND ff.title BETWEEN \"0%\" AND \"G%\""; break; case "[G-L]": $querywhere = "$querywhere AND ff.title BETWEEN \"G%\" AND \"M%\""; break; case "[M-R]": $querywhere = "$querywhere AND ff.title BETWEEN \"M%\" AND \"S%\""; break; case "[S-Z]": $querywhere = "$querywhere AND ff.title BETWEEN \"S%\" AND \"Z%\""; break; } } //au cas ou le display auteurs est utilisé if ($authordisplay != "") { switch($authordisplay) { case "[A-Z]": break; case "[0-F]": $querywhere = "$querywhere AND aut.name BETWEEN \"0%\" AND \"G%\""; break; case "[G-L]": $querywhere = "$querywhere AND aut.name BETWEEN \"G%\" AND \"M%\""; break; case "[M-R]": $querywhere = "$querywhere AND aut.name BETWEEN \"M%\" AND \"S%\""; break; case "[S-Z]": $querywhere = "$querywhere AND aut.name BETWEEN \"S%\" AND \"Z%\""; break; } } //au cas où le display genre est utilisé if(($genredisplay != "")and($genredisplay !="All")) { $querywhere = "$querywhere AND g.genre=\"$genredisplay\""; } //au cas où le display new est utilisé if($newsdisplay == "1") { $queryfrom = "$queryfrom,an_new n"; $querywhere = "$querywhere AND n.numfanfic=ff.numfanfic"; } //au cas où le champ titre a été renseigné if ($selection != "") { $querywhere = "$querywhere AND ff.title LIKE \"%$selection%\""; } //au cas ou le champ type est renseigné if (($searchgenre != "All") and ($searchgenre != "")) { $querywhere = "$querywhere AND g.genre=\"$searchgenre\""; } //au cas où le champ searchauteur est renseigné if ($searchauteur != "") { $querywhere = "$querywhere AND aut.name LIKE \"%$searchauteur%\""; } //au cas où le champ searchmail est renseigné if ($searchemail != "") { $querywhere = "$querywhere AND aut.email LIKE \"%$searchemail%\""; } if ($mois == "") $mois = 1; if ($jour == "") $jour = 1; if ($jour > 31) $jour = 31; if ($mois > 12) $mois = 12; $ficdate = "$année-$mois-$jour"; if ($searchdatetype == "before") { $querywhere = "$querywhere AND chp.chapdate <= \"$ficdate\""; } if ($searchdatetype == "after") { $querywhere = "$querywhere AND chp.chapdate >= \"$ficdate\""; } if ($searchsize == "less") { $querywhere = "$querywhere AND chp.size <= \"$kbsize\""; } if ($searchsize == "more") { $querywhere = "$querywhere AND chp.size >= \"$kbsize\""; } if ($searchorder == "date") $order = "chp.chapdate"; if ($searchorder == "size") $order = "chp.size"; if ($searchorder == "auteur") $order = "aut.name"; if ($searchorder == "title") $order = "ff.title"; if ($descorder == "decroiss") { $orderdesc = "DESC"; if ($searchorder == "default") $order = "ff.title DESC, chp.numchap"; } $myquery = "SELECT ff.numfanfic,ff.title,ff.homepage,ff.desceng,g.genre FROM $queryfrom WHERE $querywhere GROUP BY $group ORDER BY $order"; //print "Requête: $myquery
"; print "
Query Status

"; print "Sending Query..."; $queryresult = MYSQL_QUERY($myquery) or die("
A_ERROR 412: Unable to send/execute query. If the problem persists, contact Axel"); print "OK!"; print "
Receiving..."; $numrows = MYSQL_NUM_ROWS($queryresult); if ($numrows == 0) { die ("
A_WARNING 201: Your search criterias don't get any result from the archive. Try again with other options."); } else { print "
ASUKA's Notebook has found $numrows fanfics corresponding to your search criterias."; } Print"

"; print "
Results display

"; $i1=0; while ($i1 < $numrows) { $numfanfic = mysql_result($queryresult,$i1,"ff.numfanfic"); $ficname = mysql_result($queryresult,$i1,"ff.title"); $descenglish = mysql_result($queryresult,$i1,"ff.desceng"); $homepage = mysql_result($queryresult,$i1,"ff.homepage"); $genre = mysql_result($queryresult,$i1,"g.genre"); PRINT" "; //création de la requête pour les auteurs $myqueryauthor="SELECT * FROM anauthor aut,anauthor_fanfic a_f WHERE a_f.numfanfic=$numfanfic AND a_f.numauthor=aut.numauthor"; $queryauthorresult=mysql_query($myqueryauthor) or die("
A_ERROR 412: Impossible d'exécuter la requête. Si le problème persiste, contactez Axel (auteurs)"); $numrowsauth=mysql_num_rows($queryauthorresult); $i2=0; //afficher le ou les auteurs if ($numrowsauth!=0) { print ""; } else { print "$name"; } $i2++; } } //création de la requête pour les chapitres $myquerychapter="SELECT * FROM anchapter chp WHERE chp.numfanfic=$numfanfic"; $querychapterresult=mysql_query($myquerychapter) or die("
A_ERROR 412: Unable to send/execute query. If the problem persists, contact Axel (chapitres)"); $numrowschap=mysql_num_rows($querychapterresult); $i2=0; //on recueille les infos de la première ligne pour tester si c'est un one-shot(numchap=0) ou pas $size=mysql_result($querychapterresult,$i2,"chp.size"); $numchap=mysql_result($querychapterresult,$i2,"chp.numchap"); $chapurl=mysql_result($querychapterresult,$i2,"chp.fileurl"); $chaplabel=mysql_result($querychapterresult,$i2,"chp.label"); $chapdate=mysql_result($querychapterresult,$i2,"chp.chapdate"); print "
$ficname"; while ($i2 < $numrowsauth) { $name=mysql_result($queryauthorresult,$i2,"aut.name"); $email=mysql_result($queryauthorresult,$i2,"aut.email"); if ($email != "") { print "$name
"; //affichage de la homepage de la fic et pas forcément de l'auteur if ($homepage != "") { print "
"; if($numchap==0) { if ($size != 0) { Print "Read ($size Kb)"; } else { Print "Read"; } if ($chapdate != "0000-00-00") { Print " - $chapdate"; } } else { if ($size != 0) { Print "$chaplabel ($size Kb)"; } else { Print "$chaplabel"; } if ($chapdate != "0000-00-00") { Print " - $chapdate
"; } $i2++; while ($i2 < $numrowschap) { $size=mysql_result($querychapterresult,$i2,"chp.size"); $numchap=mysql_result($querychapterresult,$i2,"chp.numchap"); $chapurl=mysql_result($querychapterresult,$i2,"chp.fileurl"); $chaplabel=mysql_result($querychapterresult,$i2,"chp.label"); $chapdate=mysql_result($querychapterresult,$i2,"chp.chapdate"); if ($size != 0) { Print "
$chaplabel ($size Kb)"; } else { Print "
$chaplabel"; } if ($chapdate != "0000-00-00") { Print " - $chapdate
"; } $i2++; } } Print "
"; if($genre != "") { print "Genre: $genre"; } Print "
\"$descenglish\""; print "
$homepage"; } print "

"; $i1++; } ?>