function generateCitations($result, $rowsFound, $query, $queryURL, $showQuery, $showLinks, $rowOffset, $showRows, $previousOffset, $nextOffset, $wrapResults, $nothingChecked, $citeStyle, $citeOrder, $citeType, $orderBy, $headerMsg, $userID, $viewType)
{
global $contentTypeCharset;
// these variables are defined in 'ini.inc.php'
global $defaultCiteStyle;
global $client;
global $userOptionsArray;
// get all user options for the current user:
// (note that '$userOptionsArray' is made globally available)
$userOptionsArray = getUserOptions($userID);
// function 'getUserOptions()' is defined in 'include.inc.php'
// if the query has results ...
if ($rowsFound > 0) {
// Save the current Citation view query to a session variable:
// saveSessionVariable("lastCitationViewQuery", $query);
// fetch the name of the citation style file that's associated with the style given in '$citeStyle':
$citeStyleFile = getStyleFile($citeStyle);
// function 'getStyleFile()' is defined in 'include.inc.php'
if (empty($citeStyleFile)) {
$citeStyle = $defaultCiteStyle;
// if the given cite style could not be found, we'll use the default cite style which is defined by the '$defaultCiteStyle' variable in 'ini.inc.php'
$citeStyleFile = getStyleFile($citeStyle);
}
// include the found citation style file *once*:
include_once "cite/" . $citeStyleFile;
// fetch the name of the citation format file that's associated with the format given in '$citeType':
$citeFormatFile = getFormatFile($citeType, "cite");
// function 'getFormatFile()' is defined in 'include.inc.php()'
if (empty($citeFormatFile)) {
if (preg_match("/^cli/i", $client)) {
// if the query originated from a command line client such as the refbase CLI clients ("cli-refbase-1.1", "cli-refbase_import-1.0")
$citeType = "ASCII";
} else {
$citeType = "html";
}
$citeFormatFile = getFormatFile($citeType, "cite");
}
// include the found citation format file *once*:
include_once "cite/" . $citeFormatFile;
$citationData = citeRecords($result, $rowsFound, $query, $queryURL, $showQuery, $showLinks, $rowOffset, $showRows, $previousOffset, $nextOffset, $wrapResults, $citeStyle, $citeOrder, $citeType, $orderBy, $headerMsg, $userID, $viewType);
if (preg_match("/^RTF\$/i", $citeType)) {
$citeContentType = "application/rtf";
$citeFileName = "citations.rtf";
} elseif (preg_match("/^PDF\$/i", $citeType)) {
$citeContentType = "application/pdf";
$citeFileName = "citations.pdf";
} elseif (preg_match("/^LaTeX\$/i", $citeType)) {
$citeContentType = "application/x-latex";
$citeFileName = "citations.tex";
} elseif (preg_match("/^LaTeX \\.bbl\$/i", $citeType)) {
$citeContentType = "application/x-latex";
$citeFileName = "citations.bbl";
} elseif (preg_match("/^Markdown\$/i", $citeType)) {
$citeContentType = "text/plain";
$citeFileName = "citations.txt";
} elseif (preg_match("/^ASCII\$/i", $citeType)) {
$citeContentType = "text/plain";
$citeFileName = "citations.txt";
} else {
$citeContentType = "text/html";
$citeFileName = "citations.html";
}
if (!preg_match("/^html\$/i", $citeType)) {
// set the appropriate mimetype & set the character encoding to the one given in '$contentTypeCharset' (which is defined in 'ini.inc.php'):
setHeaderContentType($citeContentType, $contentTypeCharset);
}
// function 'setHeaderContentType()' is defined in 'include.inc.php'
if (preg_match("/^application/i", $citeContentType)) {
// instruct the browser to download the resulting output as file:
header('Content-Disposition: attachment; filename="' . $citeFileName . '"');
}
// Note that this doesn't seem to work with all browsers (notably not with Safari & OmniWeb on MacOSX Panther, but it does work with Mozilla & Camino as well as Safari on Tiger)
echo $citationData;
} else {
$nothingFoundFeedback = nothingFound($nothingChecked);
echo $nothingFoundFeedback;
}
}
$query = "SELECT checklist.checklistId, checklist.title, checklist.description,\n\t\t\t\tchecklist.categoryId, categories.category \n\t\t\t\tFROM checklist, categories \n\t\t\t\tWHERE checklist.categoryId=categories.categoryId \n\t\t\t\tORDER BY categories.category ASC";
$result = mysql_query($query) or die("Error in query");
} else {
$query = "SELECT checklist.checklistId, checklist.title, checklist.description,\n\t\t\t\tchecklist.categoryId, categories.category \n\t\t\t\tFROM checklist, categories \n\t\t\t\tWHERE checklist.categoryId=categories.categoryId AND checklist.categoryId='{$categoryId}' \n\t\t\t\tORDER BY categories.category ASC";
$result = mysql_query($query) or die("Error in query");
}
if (mysql_num_rows($result) > 0) {
echo "<p>Select checklist for report.</p>\n";
echo "<table class='datatable'>\n";
echo "\t<thead>\n";
echo "\t\t<td>Category</td>\n";
echo "\t\t<td>Title</td>\n";
echo "\t\t<td>Description</td>\n";
echo "\t</thead>\n";
while ($row = mysql_fetch_row($result)) {
echo "\t<tr>\n";
echo "\t\t<td>" . stripslashes($row[4]) . "</td>\n";
echo ' <td><a href="checklistReport.php?checklistId=' . $row[0] . '&checklistTitle=' . urlencode($row[1]) . '">' . stripslashes($row[1]) . "</a></td>\n";
echo "\t\t<td>" . stripslashes($row[2]) . "</td>\n";
echo "\t</tr>\n";
}
echo "</table>\n";
} else {
$message = "You have not defined any checklists yet.";
$prompt = "Would you like to create a new checklist?";
$yeslink = "newchecklist.php";
nothingFound($message, $prompt, $yeslink);
}
mysql_free_result($result);
mysql_close($connection);
include_once 'footer.php';
