20) {$autbaract="Y";} } else {$autname="Author Unknown";} } $keystring=$autname; $metaautpage=$autname; $bktitle=" Author page for ".$autname; $metautpage="https://a1adultebooks.com/ebooks/a".$aut.".htm"; $ahlink=$metautpage; ?>
99999) {$sh=1;} $page=($sh-1)/20; $page=$page+1; $contstring=$autname." : A1AdultEbooks : Page ".$page; $pagetitle=$autname." : A1AdultEbooks : Page ".$page; print ""; print ""; print ""; print "";
$autbio="";
$autweb="";
$resultau=mysqli_query($linkns, "SELECT * FROM 00authors where aut_number='$aut'");
while($rowau = mysqli_fetch_row($resultau))
{
if ($rowau[1]==$aut)
{
$autseek=$rowau[5];
$pubid=$rowau[2];
$autname=$rowau[5];
$isf4=$rowau[7];
$autbio=$rowau[6];
$autweb=$rowau[44];
$autname=stripslashes($autname);
$autbio=stripslashes($autbio);
$autweb=stripslashes($autweb);
}
}
$autbio=stripslashes($autbio);
$autweb=stripslashes($autweb);
$pubdesc="";
if ($isf4=="Y") { $pubdesc="Published by Fiction4All"; }
else { $pubdesc="Published by the author or their publisher";}
// display author bio etc at top of page
if (strlen($autbio)>10)
{
$prtaut=$autname;
$prtaut=str_replace(" "," ",$prtaut);
print "
|
";
$lcnt=0;
$maxcnt=0;
// now process the products file for category/author etc
$pdbflg="Y";
$numcells=1;
if ($catseq=="A") // alphabetical by title
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' AND pr_aut='$aut' ) ORDER by pr_titlelc");
} // end of list by latest addition first
if ($catseq=="R") // Date added - most recent titles first
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_recno DESC");
} // end of date added
if ($catseq=="D") // best-selling this year
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_yrsold DESC ");
} // end of best-selling this year
if ($catseq=="E") // best-selling all time
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_nosold DESC ");
} // end of best-selling all time
if ($catseq=="L") // word count low high
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_words ");
} // end of word count - low high
if ($catseq=="M") // word count high low
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_words DESC ");
} // end of word count - high low
if ($catseq=="P") // list price low high
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_pubprice ");
} // end of price - low high
if ($catseq=="Q") // list price high low
{
$resultp=mysqli_query($linkns, "SELECT pr_code FROM 00productmeta WHERE ($filterstrg and pr_status='A' and pr_aut='$aut' ) ORDER by pr_pubprice DESC");
} // end of price - high low
$fromaut="Y";
while($rowp = mysqli_fetch_row($resultp))
{
$pfcnt++;
if ($pfcnt>=$sh and $pfcnt<=$shlast)
{
$pr=$rowp[0];
include("../scripts/bookprocmeta.php");
include("../scripts/booklayout2022.php");
print " "; } } print " |
";
if ($noanths=="1")
{
$prtaut=$autname;
$prtaut=str_replace(" "," ",$prtaut);
print " $prtaut Anthology Contributions"; $result=mysqli_query($linkns, "SELECT * FROM gpanthsubs WHERE (gs_autno='$aut' and gs_anthstatus='A' and gs_product!='0' ) "); $numrows = mysqli_num_rows($result); if ($numrows!=0) { print " $prtaut has contributions in the following Gravestone Press anthologies"; $oldpr=0; while($row = mysqli_fetch_row($result)) { $pr=$row[18]; if ($pr!=0) { $resultp=mysqli_query($linkns, "SELECT * FROM 00productmeta WHERE (pr_gpok='Y' and pr_status='A' AND pr_code='$pr') ORDER by pr_pubprice DESC"); while($rowp = mysqli_fetch_row($resultp)) { if ($pr!=$oldpr) { $pr=$rowp[1]; include("../scripts/bookprocmeta.php"); include("../scripts/booklayout2022.php"); print " "; } $oldpr=$pr; } } } } $result=mysqli_query($linkns, "SELECT * FROM ddanthsubs WHERE (gs_autno='$aut' and gs_anthstatus='A' and gs_product!='0' ) "); $numrows = mysqli_num_rows($result); if ($numrows!=0) { print " $prtaut has contributions in the following Double Dragon anthologies"; $oldpr=0; while($row = mysqli_fetch_row($result)) { $pr=$row[18]; if ($pr!=0) { $resultp=mysqli_query($linkns, "SELECT * FROM 00productmeta WHERE (pr_gpok='Y' and pr_status='A' AND pr_code='$pr') ORDER by pr_pubprice DESC"); while($rowp = mysqli_fetch_row($resultp)) { if ($pr!=$oldpr) { $pr=$rowp[1]; include("../scripts/bookprocmeta.php"); include("../scripts/booklayout2022.php"); print " "; } $oldpr=$pr; } } } } $oldanth=0; $result=mysqli_query($linkns, "SELECT * FROM gpanthsubs WHERE (gs_autno='$aut' and gs_anthstatus='A' and gs_product='0') ORDER by gs_anthno "); $numrows = mysqli_num_rows($result); if ($numrows!=0) { print " $prtaut has contributions in these upcoming Gravestone Press anthologies:-"; while($row = mysqli_fetch_row($result)) { if ($oldanth!=$row[5]) { $anthtitle=stripslashes($row[6]); print " $anthtitle"; $oldanth=$row[5]; } } } $oldanth=0; $result=mysqli_query($linkns, "SELECT * FROM ddanthsubs WHERE (gs_autno='$aut' and gs_anthstatus='A' and gs_product='0') ORDER by gs_anthno "); $numrows = mysqli_num_rows($result); if ($numrows!=0) { print " $prtaut has contributions in these upcoming Double Dragon anthologies:-"; while($row = mysqli_fetch_row($result)) { if ($oldanth!=$row[5]) { $anthtitle=stripslashes($row[6]); print " $anthtitle"; $oldanth=$row[5]; } } } } print " |
";
print " ANNOUNCEMENTS FOR THIS AUTHOR "; print ""; } $resultan=mysqli_query($linkns, "SELECT * FROM 00announce WHERE (pa_aut='$autlinkno' and pa_prod='0' ) order by pa_date DESC"); while($rowan = mysqli_fetch_row($resultan)) { $annrec=$rowan[0]; $anntype=$rowan[3]; $anndate=$rowan[4]; $anntitle=stripslashes($rowan[5]); $anndesc=stripslashes($rowan[6]); $annlogo=$rowan[7]; // get type description $resultad=mysqli_query($linkns, "SELECT * FROM 00announcetypes where at_type='$anntype' "); while($rowad = mysqli_fetch_row($resultad)) { $tdesc=stripslashes($rowad[2]); } $atyr=substr($anndate,0,4); $atmth=substr($anndate,4,2); $atday=substr($anndate,6,2); $badge=""; if ($annlogo!="") { $badge="https://fiction4all.com/announcements/$annlogo"; } print " "; if ($badge!="") { print "
"; if ($badge!="") { print "
|