| \n";
print "The search engine wasn't able to understand your query $sstr. \n";
if($t == "k")
{
print "Check that quotes around exact phrases are paired correctly.";
}
else if($t == "b")
{
print "Make sure that the logic in your query is correct:\n";
print " the parentheses are nested correctly and match\n";
print "any phrases are in quotes\n";
print "the allowed operators are 'and', 'or', and 'not'\n";
print "* is the wildcard character\n";
print "Some properly formed queries: \n";
print "cats and dogs
\n";
print "cat* or (dog* and horse)
\n";
print "(cat or dog) and (black not white)
\n";
print "'house cat' not tiger*
\n";
}
print " |
\n";
printfoot();
exit();
}
# if no areas were chosen and a0 wasn't set, set $a0 to 1
$query2 = "select catid from category where parentid < 0";
$result2 = mysqli_query($dblink,$query2);
$aflag = 0;
while($crow = mysqli_fetch_row($result2))
{
$id = $crow[0];
if(${"a" . $id})
{
$aflag = 1;
}
}
if($aflag == 0 && (!$am) && (!$ar))
{
$a0 = 1;
}
$query .= "( $wc ) && available = 1 order by $orderby";
$result = mysqli_query($dblink,$query);
# put the category matches into $coutput; only display them on the
# first page
$catquery = "select catid from category where ";
$catvarnames = array("catname");
$catwc = $stosql->getSQL($catvarnames, $join, $rel, $pre, $post);
$catquery .= "$catwc order by catname";
$catresult = mysqli_query($dblink,$catquery);
$rcount = 0;
$routput = array();
# filter out results so that only results in the specified categories
# are shown; add them to $routput, which is printed later
while($dbrow = mysqli_fetch_object($result))
{
$show = 0;
# for cats, key is catid for top level categories
$topcat = getTopCat($dbrow->linkid, 0);
$topvar = "a" . $topcat;
$topparent = getTopCat($dbrow->linkid, 1);
if($a0 == 1)
{
$show = 1;
}
else if($topparent == -1 && $am == 1)
{
$show = 1;
}
else if($topparent == -2 && $ar == 1)
{
$show = 1;
}
else if(${$topvar} == 1)
{
$show = 1;
}
if($show)
{
$routput[$rcount] = "";
$routput[$rcount] .= formatLink($dbrow, 1, $c);
$routput[$rcount] .= "| \n";
$rintroline = "matches were found for $sstr in ";
$catintroline = $rintroline;
$fields = "";
$areas = "";
if($f0)
{
$rintroline .= "all fields";
}
else
{
for($i = 0; $i < count($dispvarnames); $i++)
{
if($varnames[$i] != "alturls")
{
$fields .= "$dispvarnames[$i], ";
}
}
$fields = preg_replace("/,\s*$/", "", $fields);
$rintroline .= "field(s) $fields";
}
$rintroline .= " and in ";
if($a0)
{
$rintroline .= " all sections";
$catintroline .= " all sections";
}
else
{
$query2 = "select catid, catname from category where parentid = '-1' order by catname";
$result2 = mysqli_query($dblink,$query2);
$j = 0;
while($dbrow = mysqli_fetch_object($result2))
{
$catids[$j++] = $dbrow;
}
if($am == 1)
{
$areas .= "Main Library, ";
}
if($ar == 1)
{
$areas .= "Reading Room, ";
}
for($i = 0; $i < count($catids); $i++)
{
$topvar = "a" . $catids[$i]->catid;
if(${$topvar})
{
$areas .= $catids[$i]->catname . ", ";
}
}
$areas = preg_replace("/,\s*$/", "", $areas);
$rintroline .= "section(s) $areas";
$catintroline .= "section(s) $areas";
}
$rintroline .= ". \n";
$catintroline .= ". \n";
if($rcount < 1)
{
print "Try searching for more general terms or using 'or' instead of 'and' in a boolean query.\n";
}
else
{
if($q)
{
$rblock = $q;
}
if(!$r)
{
$rstart = 0;
}
else
{
$rstart = $r;
}
if(!$s)
{
$rstop = $rstart + $rblock - 1;
}
else if($s > count($routput))
{
$rstop = count($routput) - 1;
}
else
{
$rstop = $s;
}
$stop = $rstop;
if($stop > count($routput) - 1)
{
$stop = count($routput) - 1;
}
if($q == "all")
{
$rstart = 0;
$rstop = count($routput);
$stop = $rstop - 1;
}
if($rstart == 0)
{
$coutput = getCatMatchOutput($catresult);
if(count($coutput) > 0)
{
print " \n" . count($coutput) . " category $catintroline \n";
for($i = 0; $i < count($coutput); $i++)
{
print "$coutput[$i]
\n";
}
print " \n
\n\n";
}
}
print "$rcount link matches $rintroline\n";
print " Link matches " . ($rstart + 1) . " - " . ($stop + 1) . "\n \n";
for($j = $rstart; $j <= $rstop && $j < count($routput); $j++)
{
print $routput[$j];
}
print " ";
$qsarray = modifyQS($QUERY_STRING, -1, $rstart, $rstop, count($routput), $rblock);
$querystring = $qsarray[0];
$nextnum = $qsarray[1];
if($r > 0 && $q != "all")
{
$nextnum++;
print "| ";
print "<- previous $nextnum results\n";
print " | \n";
}
$qsarray = modifyQS($QUERY_STRING, 1, $rstart, $rstop, count($routput), $rblock);
$querystring = $qsarray[0];
$nextnum = $qsarray[1];
if($nextnum >= 0 && $stop != count($routput) - 1 && $q != "all")
{
$nextnum++;
print "";
print "next $nextnum results ->\n";
print " | \n";
}
print "
\n";
}
print " |
\n";
printfoot();
exit();
}
function modifyQS($querystring, $unit, $rstart, $rstop, $rnum, $rblock)
{
if($unit > 0)
{
$rstop += $rblock;
}
else if($unit < 0)
{
$rstop = $rstart - 1;
}
$rstart += $rblock * $unit;
if($rstart < 0)
{
$rstart = 0;
}
else if($rstart > $rnum - 1)
{
$rstart = $rnum - 1;
}
if($rstop < 0)
{
$rstop = 0;
}
else if($rstop > $rnum - 1)
{
$rstop = $rnum - 1;
}
if(preg_match("/\&r=\d+/", $querystring))
{
$querystring = preg_replace("/\&r=\d+/", "\&r=$rstart", $querystring);
}
else if($querystring == "")
{
$querystring = "r=$rstart";
}
else
{
$querystring .= "&r=$rstart";
}
if(preg_match("/s=\d+/", $querystring))
{
$querystring = preg_replace("/s=\d+/", "s=$rstop", $querystring);
}
else if($querystring == "")
{
$querystring = "s=$rstop";
}
else
{
$querystring .= "&s=$rstop";
}
return array($querystring, $rstop-$rstart);
}
function getCatMatchOutput($catresult)
{
extract($GLOBALS);
$a0 = (isset($_REQUEST['a0'])) ? $_REQUEST['a0'] : $a0;
$am = (isset($_REQUEST['am'])) ? $_REQUEST['am'] : $am;
$ar = (isset($_REQUEST['ar'])) ? $_REQUEST['ar'] : $ar;
$lo = (isset($_REQUEST['lo'])) ? $_REQUEST['lo'] : $lo;
$sl = (isset($_REQUEST['sl'])) ? $_REQUEST['sl'] : $sl;
$coutput = array();
while($catrow = mysqli_fetch_object($catresult))
{
$catid = $catrow->catid;
$categories = parentCats($catid);
$catline = "";
$show = 0;
# for cats, key is catid for top level categories
$topcat = $categories[0]->catid;
$topvar = "a" . $topcat;
$topparent = $categories[0]->parentid;
if($a0 == 1)
{
$show = 1;
}
else if($topparent == -1 && $am == 1)
{
$show = 1;
}
else if($topparent == -2 && $ar == 1)
{
$show = 1;
}
else if(${$topvar} == 1)
{
$show = 1;
}
if($show)
{
if($categories[0]->parentid == -1)
{
$catline .= "