0) || ( $linkFile != "" ) ) { // then we have some xrefs to combine
$xrefs = "
See also ...
";
// add xrefs if needed
for ($i = 0; $i < $n; ++$i) {
$refa = mysql_fetch_array($xref_records);
$ref = $refa["term"];
$searchURL = './src/php/glossarySearch.php';
$xrefs .= createImageHTML( './src/images/link.gif', $ref, 'onClick="ContentLoader.loadSnippet( \'./src/php/glossarySearch.php?checkBoxValue=Y&term1=' . $ref. '\', \'mainMiddleContent\', \'add\' );"' );
}
// add in the linkfile if there is one
if ( $linkFile != "" ) { // then we have a link file, so add it to the returned string
$xrefs .= createImageHTML( './src/images/link.gif', $linkFile, 'onClick="ContentLoader.loadSnippet( \'' . $linkFile. '\', \'mainMiddleContent\', \'append\' );"' );
}
$xrefs .= "
";
}
return $xrefs;
}
// jde, 15/08/17, added term so we can check if it points to itself
function format_xrefs($id, $term) {
// $xref_query = "select term from xrefs where id = $id order by term";
$xref_query = "select term from topic where term like '%$term%'";
$xref_records = dbQuery($xref_query);
$xrefs = "";
$n = mysql_num_rows($xref_records);
if ($n > 0) {
$xrefs = "
See also
";
for ($i = 0; $i < $n; ++$i) {
$refa = mysql_fetch_array($xref_records);
$ref = $refa["term"];
//echo $ref . '!' .$term;
if ( strtolower($ref) != strtolower($term) ) // ignore pointing back to self
$xrefs .= "
";
}
return $xrefs;
}
// jde, 06/08/17, removed $term from param list
// Dev 20th Aug modified to make sure we have essentially different terms, added the index from array of returns terms
function formatDefinition($definition_array, $i, $n) {
$q = ($n > 1) ? " ($i)" : "";
$returnedTerm = $definition_array["term"];
$returnedTermPlusCount = $returnedTerm . $i; // added i so we should always have diferent terms
$returnString = startClosedDivHTML( $returnedTermPlusCount, $returnedTerm, $definition_array["description"] );
$xrefs = formatXrefsAndLinks( $definition_array["id"], $definition_array["link"] );
// $xrefs = format_xrefs( $definition_array["id"], $returnedTerm );
$returnString .= $xrefs;
$returnString .= endDivHTML( );
return $returnString;
}
function makeDefinitions($term, $definition_records, $n) {
$definition = '
' . $term . '
';
for ($i = 1; $i <= $n; ++$i) {
$definition .= formatDefinition(mysql_fetch_array($definition_records), $i, $n); // jde, 06/08/17, removed $term from param list
}
$definition .= "
";
return $definition;
}
function extractDefinition($term, $definition_records, $user, $history) {
$n = mysql_num_rows($definition_records);
if ($n === 0)
return "
No definition for $term was found
";
else {
addOneToCount($term);
add_to_history($term, $user, $history);
return makeDefinitions($term, $definition_records, $n);
}
}
function getDefinition( $term, $user, $history ) {
$term = mysql_escape_string($term);
$definition_query = "select id, term, description, link from topic ";
$definition_query .= ( getCheckBoxValue() == 'Y' ) ? " where term = '$term'" : "where term like '%$term%'";
return extractDefinition($term, dbQuery($definition_query), $user, $history);
}
function doDefinition($term, $user, $history) {
//var_dump('doDefinition', $term, $user, $history);
return $term == "" ? "
No data for $term was found
" : getDefinition( $term, $user, $history );
}
// routine just gets the data from the db without any xref data
function buildTermDescription( $searchTerm, $exactValueWanted, $user, $history ) {
//var_dump($searchTerm, $exactValueWanted);
$description = '';
if ( $searchTerm != "" ) {
$searchTextQuery = $exactValueWanted ? "(`term` = '$searchTerm')" : "(`term` like '%$searchTerm%')";
// now build the actual query
$query = "select id, term, description, link from topic where ";
$query .= $searchTextQuery;
//echo $query;
$records = dbQuery( $query );
$n = mysql_num_rows($records);
//echo "norecs=" . $n;
if ($n == 0)
return "
' . $searchTerm;
$description_array = mysql_fetch_array($records);
for ($i = 1; $i <= $n; ++$i) {
$returnedslideTitle = $description_array["term"];
//echo $i . ' '. $description_array["id"];
$returnedslideTitlePlusCount = $returnedslideTitle . $i; // added i so we should always have diferent slideTitles
$description .= startClosedDivHTML( $returnedslideTitlePlusCount, $returnedslideTitle, $description_array["description"] );
$description .= endDivHTML();
}
$description .= "
";
}
} else {
$description = '
No link data found for ' . $searchTerm . '
';
}
return $description;
}
// Modified Dev 22/10/09 Now does a search of the slideText as well as the slideTitle for the searchTerm
// Added Dev 19th Aug 2009
// routine just gets the data from the slides table
function buildSlideDescription( $slideTitle, $exactValueWanted, $user, $history ) {
$description = '';
if ( $slideTitle != "" ) {
$slideTextQuery = $exactValueWanted ? "(`slidetext` = '$slideTitle')" : "(`slidetext` like '%$slideTitle%')";
// now build the actual query
$query = "select concat(modulePath, '/Slide', s.id, '.PNG') as slidePicture, slideTitle, slidetext ";
$query .= "from slideInfo as s, pptInfo as p ";
$query .= "where (s.pptId = p.pptId) and $slideTextQuery";
$query .= "order by p.pptId, s.id;";
//echo $query;
$slideText_records = dbQuery($query);
//var_dump( $slideText_records );
$n = mysql_num_rows($slideText_records);
if ($n == 0)
return "