  |
|||||||||
The following articles are available: |
|||||||||
0) :
$i = 0;
WHILE ($i < $number_preprints) :
$article_id = mysql_result($result_preprints,$i,"preprint_id");
$title = mysql_result($result_preprints,$i,"title");
$author_apa = mysql_result($result_preprints,$i,"author_apa");
$journal = mysql_result($result_preprints,$i,"Journal");
$date_submission = mysql_result($result_preprints,$i,"date_submission");
$date_acceptance = mysql_result($result_preprints,$i,"date_acceptance");
$date_publication = mysql_result($result_preprints,$i,"date_publication");
$citation_start = $author_apa;
$citation_start .= " (";
IF ($date_publication != "0000-00-00") :
$status = "Published";
$date = $date_publication;
$citation_start .= substr ($date_publication, 0, 4);
$citation_end = $journal;
$citation_end .= ".";
ELSEIF ($date_acceptance != "0000-00-00") :
$status = "Accepted";
$date = $date_acceptance;
$citation_start .= "In Press";
$citation_end = $journal;
$citation_end .= ", Accepted ";
$citation_end .= $date_acceptance;
$citation_end .= ".";
ELSEIF ($date_submission != "0000-00-00") :
$status = "Submitted";
$date = $date_submission;
$citation_start .= "Submitted";
$citation_end = "Submitted";
IF ($journal != "") :
$citation_end .= " to ";
$citation_end .= $journal;
ENDIF;
$citation_end .= " on ";
$citation_end .= $date_submission;
$citation_end .= ".";
ELSE :
$status = "In Prep";
$date = "" ;
$citation_start .= "In Prep";
$citation_end = "";
ENDIF;
$citation_start .= ")";
PRINT "$citation_start. $title. $citation_end\n"; $i++; ENDWHILE; ENDIF; $result_reprints = MYSQL_QUERY($query_reprints); /* How many of these users are there? */ $number_reprints = MYSQL_NUMROWS($result_reprints); /* Print these results to the screen in a nice format */ IF ($number_reprints > 0) : $i = 0; WHILE ($i < $number_reprints) : $article_id = mysql_result($result_reprints,$i,"preprint_id"); $title = mysql_result($result_reprints,$i,"title"); $author_apa = mysql_result($result_reprints,$i,"author_apa"); $journal = mysql_result($result_reprints,$i,"Journal"); $date_submission = mysql_result($result_reprints,$i,"date_submission"); $date_acceptance = mysql_result($result_reprints,$i,"date_acceptance"); $date_publication = mysql_result($result_reprints,$i,"date_publication"); $citation_start = $author_apa; $citation_start .= " ("; IF ($date_publication != "0000-00-00") : $status = "Published"; $date = $date_publication; $citation_start .= substr ($date_publication, 0, 4); $citation_end = $journal; $citation_end .= "."; ELSEIF ($date_acceptance != "0000-00-00") : $status = "Accepted"; $date = $date_acceptance; $citation_start .= "In Press"; $citation_end = $journal; $citation_end .= ", Accepted "; $citation_end .= $date_acceptance; $citation_end .= "."; ELSEIF ($date_submission != "0000-00-00") : $status = "Submitted"; $date = $date_submission; $citation_start .= "Submitted"; $citation_end = "Submitted"; IF ($journal != "") : $citation_end .= " to "; $citation_end .= $journal; ENDIF; $citation_end .= " on "; $citation_end .= $date_submission; $citation_end .= "."; ELSE : $status = "In Prep"; $date = "" ; $citation_start .= "In Prep"; $citation_end = ""; ENDIF; $citation_start .= ")"; PRINT " $citation_start. $title. $citation_end\n"; $i++; ENDWHILE; ENDIF; $total_articles = $number_preprints + $number_reprints; IF ($total_articles == 0) : PRINT " Sorry, I currently have no articles available for download. |
|||||||||
      |
|||||||||
|
|||||||||
