} else {
if (DesignatedLocation()) {
getFloorStats();
compileInfo();
} else {
if (RangeLocation()) {
getFloorStats();
compileInfo();
} else {
loadError();
}
}
}
}
} else {
loadError();
}
// Check if the collection is located in a branch library-----------------------------
function BranchLibrary()
{
global $item, $Locator, $dbconnects;
$sql = "SELECT * FROM lctr_Campus_cn WHERE left_cn = '{$item->lc}'";
if ($subResult = $dbconnects["current"]->query($sql)) {
if ($subResult->num_rows > 0) {
while ($row = $subResult->fetch_array()) {
$item->info = $item->info . $row['message_cn'] . '<br />';
$item->image = $row['ImageCode_cn'];
$item->ref = $row['MapNumber_cn'];
$item->site = $row['Website_cn'];
}
$item->branch = true;
$contentresult = mysql_query($sql, $db);
$atutor_content_row = mysql_fetch_assoc($contentresult);
if (!$atutor_content_row) {
loadError("Not Configured\n");
exit;
}
// echo("atutor_content_row<br/>\n");print_r($atutor_content_row); echo("<hr>\n");
$sql = "SELECT * FROM " . TABLE_PREFIX . "courses\n WHERE course_id='" . $atutor_content_row['course_id'] . "'";
$courseresult = mysql_query($sql, $db);
$atutor_course_row = mysql_fetch_assoc($courseresult);
if (!$atutor_course_row) {
loadError("Course definition missing\n");
exit;
}
// echo("atutor_course_row<br/>\n");print_r($atutor_course_row); echo("<hr>\n");
$sql = "SELECT * FROM " . TABLE_PREFIX . "course_enrollment\n WHERE member_id='" . $member_id . "'";
$enrollresult = mysql_query($sql, $db);
$atutor_course_enrollment_row = mysql_fetch_assoc($enrollresult);
if (!$atutor_course_enrollment_row) {
loadError("Course enrollment missing\n");
exit;
}
// echo("atutor_course_enrollment_row<br/>\n");print_r($atutor_course_enrollment_row); echo("<hr>\n");
$sql = "SELECT * FROM " . TABLE_PREFIX . "members\n WHERE member_id='" . $member_id . "'";
$memberresult = mysql_query($sql, $db);
$atutor_member_row = mysql_fetch_assoc($memberresult);
if (!$atutor_member_row) {
loadError("Course definition missing\n");
exit;
}
// echo("atutor_member_row<br/>\n");print_r($atutor_member_row); echo("<hr>\n");
