182 |
$lu_sql = "SELECT libunit_id FROM libunit |
$lu_sql = "SELECT libunit_id FROM libunit |
183 |
WHERE head_staff_id = " |
WHERE head_staff_id = " |
184 |
. $sess_staff_id; |
. $sess_staff_id; |
185 |
$lu_rs = mysql_tryquery($lu_sql); |
$lu_rs = xx_tryquery($lu_sql); |
186 |
|
|
187 |
$lu_string = "ls.libunit_id IN ("; |
$lu_string = "ls.libunit_id IN ("; |
188 |
$first_element = 0; |
$first_element = 0; |
189 |
|
|
190 |
// Concatenate the IN clause |
// Concatenate the IN clause |
191 |
while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { |
while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { |
192 |
$libunit_id = $lu_row["libunit_id"]; |
$libunit_id = $lu_row["libunit_id"]; |
193 |
//printf("libunit id was: %d<BR><BR>", $libunit_id); |
//printf("libunit id was: %d<BR><BR>", $libunit_id); |
194 |
|
|
235 |
// Run the authorized page query if not DBA level |
// Run the authorized page query if not DBA level |
236 |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
237 |
|
|
238 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
239 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
240 |
|
|
241 |
// Collect the access information |
// Collect the access information |
242 |
$auth_page = $row["auth_page"]; |
$auth_page = $row["auth_page"]; |
308 |
. $sess_staff_account |
. $sess_staff_account |
309 |
. "'"; |
. "'"; |
310 |
|
|
311 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
312 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
313 |
|
|
314 |
// Collect the access information |
// Collect the access information |
315 |
$auth_resource = $row["auth_resource"]; |
$auth_resource = $row["auth_resource"]; |
396 |
. $sess_staff_account |
. $sess_staff_account |
397 |
. "'"; |
. "'"; |
398 |
|
|
399 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
400 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
401 |
|
|
402 |
// Collect the access information |
// Collect the access information |
403 |
$auth_resource = $row["auth_resource"]; |
$auth_resource = $row["auth_resource"]; |
499 |
$lu_sql = "SELECT libunit_id FROM libunit |
$lu_sql = "SELECT libunit_id FROM libunit |
500 |
WHERE head_staff_id = " |
WHERE head_staff_id = " |
501 |
. $sess_staff_id; |
. $sess_staff_id; |
502 |
$lu_rs = mysql_tryquery($lu_sql); |
$lu_rs = xx_tryquery($lu_sql); |
503 |
|
|
504 |
$lu_string = "ls.libunit_id IN ("; |
$lu_string = "ls.libunit_id IN ("; |
505 |
$first_element = 0; |
$first_element = 0; |
506 |
|
|
507 |
// Concatenate the IN clause |
// Concatenate the IN clause |
508 |
while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { |
while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { |
509 |
$libunit_id = $lu_row["libunit_id"]; |
$libunit_id = $lu_row["libunit_id"]; |
510 |
//printf("libunit id was: %d<BR><BR>", $libunit_id); |
//printf("libunit id was: %d<BR><BR>", $libunit_id); |
511 |
|
|
551 |
// Run the authorized subject query if not DBA level |
// Run the authorized subject query if not DBA level |
552 |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
553 |
|
|
554 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
555 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
556 |
|
|
557 |
// Collect the access information |
// Collect the access information |
558 |
$auth_subject = $row["auth_subject"]; |
$auth_subject = $row["auth_subject"]; |
589 |
. $omit |
. $omit |
590 |
. " ORDER BY last_name, first_name"; |
. " ORDER BY last_name, first_name"; |
591 |
|
|
592 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
593 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
594 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
595 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
596 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
690 |
$lu_sql = "SELECT libunit_id FROM libunit |
$lu_sql = "SELECT libunit_id FROM libunit |
691 |
WHERE head_staff_id = " |
WHERE head_staff_id = " |
692 |
. $sess_staff_id; |
. $sess_staff_id; |
693 |
$lu_rs = mysql_tryquery($lu_sql); |
$lu_rs = xx_tryquery($lu_sql); |
694 |
|
|
695 |
$lu_string = "ls.libunit_id IN ("; |
$lu_string = "ls.libunit_id IN ("; |
696 |
$first_element = 0; |
$first_element = 0; |
697 |
|
|
698 |
// Concatenate the IN clause |
// Concatenate the IN clause |
699 |
while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { |
while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { |
700 |
$libunit_id = $lu_row["libunit_id"]; |
$libunit_id = $lu_row["libunit_id"]; |
701 |
|
|
702 |
if ($first_element == 0) { |
if ($first_element == 0) { |
743 |
// Run the authorized page query if not DBA level |
// Run the authorized page query if not DBA level |
744 |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
745 |
|
|
746 |
$page_rs = mysql_tryquery($page_sql); |
$page_rs = xx_tryquery($page_sql); |
747 |
|
|
748 |
while ($page_row = mysql_fetch_array ($page_rs, MYSQL_ASSOC)) { |
while ($page_row = xx_fetch_array ($page_rs, xx_ASSOC)) { |
749 |
|
|
750 |
// Collect the page information |
// Collect the page information |
751 |
$page_id = $page_row["page_id"]; |
$page_id = $page_row["page_id"]; |
839 |
$lu_sql = "SELECT libunit_id FROM libunit |
$lu_sql = "SELECT libunit_id FROM libunit |
840 |
WHERE head_staff_id = " |
WHERE head_staff_id = " |
841 |
. $sess_staff_id; |
. $sess_staff_id; |
842 |
$lu_rs = mysql_tryquery($lu_sql); |
$lu_rs = xx_tryquery($lu_sql); |
843 |
|
|
844 |
$lu_string = "ls.libunit_id IN ("; |
$lu_string = "ls.libunit_id IN ("; |
845 |
$first_element = 0; |
$first_element = 0; |
846 |
|
|
847 |
// Concatenate the IN clause |
// Concatenate the IN clause |
848 |
while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { |
while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { |
849 |
$libunit_id = $lu_row["libunit_id"]; |
$libunit_id = $lu_row["libunit_id"]; |
850 |
printf("libunit id was: %d<BR><BR>", $libunit_id); |
printf("libunit id was: %d<BR><BR>", $libunit_id); |
851 |
|
|
892 |
// Run the authorized page query if not DBA level |
// Run the authorized page query if not DBA level |
893 |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
894 |
|
|
895 |
$page_rs = mysql_tryquery($page_sql); |
$page_rs = xx_tryquery($page_sql); |
896 |
|
|
897 |
while ($page_row = mysql_fetch_array ($page_rs, MYSQL_ASSOC)) { |
while ($page_row = xx_fetch_array ($page_rs, xx_ASSOC)) { |
898 |
|
|
899 |
// Collect the page information |
// Collect the page information |
900 |
$page_id = $page_row["page_id"]; |
$page_id = $page_row["page_id"]; |
971 |
$lu_sql = "SELECT libunit_id FROM libunit |
$lu_sql = "SELECT libunit_id FROM libunit |
972 |
WHERE head_staff_id = " |
WHERE head_staff_id = " |
973 |
. $sess_staff_id; |
. $sess_staff_id; |
974 |
$lu_rs = mysql_tryquery($lu_sql); |
$lu_rs = xx_tryquery($lu_sql); |
975 |
|
|
976 |
$lu_string = "ls.libunit_id IN ("; |
$lu_string = "ls.libunit_id IN ("; |
977 |
$first_element = 0; |
$first_element = 0; |
978 |
|
|
979 |
// Concatenate the IN clause |
// Concatenate the IN clause |
980 |
while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { |
while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { |
981 |
$libunit_id = $lu_row["libunit_id"]; |
$libunit_id = $lu_row["libunit_id"]; |
982 |
printf("libunit id was: %d<BR><BR>", $libunit_id); |
printf("libunit id was: %d<BR><BR>", $libunit_id); |
983 |
|
|
1022 |
// Run the authorized page query if not DBA level |
// Run the authorized page query if not DBA level |
1023 |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
if ($sess_access_level >= 20 && $sess_access_level < 1000) { |
1024 |
|
|
1025 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1026 |
|
|
1027 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1028 |
|
|
1029 |
// Collect the page information |
// Collect the page information |
1030 |
$subject_id = $row["subject_id"]; |
$subject_id = $row["subject_id"]; |
1060 |
FROM course |
FROM course |
1061 |
ORDER BY course_concat"; |
ORDER BY course_concat"; |
1062 |
|
|
1063 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1064 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1065 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
1066 |
$course_concat = $row["course_concat"]; |
$course_concat = $row["course_concat"]; |
1067 |
|
|
1103 |
. " ORDER BY coursesub_descr"; |
. " ORDER BY coursesub_descr"; |
1104 |
|
|
1105 |
// Fetch the values |
// Fetch the values |
1106 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1107 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1108 |
$coursesub = $row["coursesub"]; |
$coursesub = $row["coursesub"]; |
1109 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
1110 |
$coursesub_descr = $row["coursesub_descr"]; |
$coursesub_descr = $row["coursesub_descr"]; |
1151 |
$sql .= " ORDER BY coursesub_descr"; |
$sql .= " ORDER BY coursesub_descr"; |
1152 |
|
|
1153 |
// Fetch the values |
// Fetch the values |
1154 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1155 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1156 |
$coursesub = $row["coursesub"]; |
$coursesub = $row["coursesub"]; |
1157 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
1158 |
$coursesub_descr = $row["coursesub_descr"]; |
$coursesub_descr = $row["coursesub_descr"]; |
1191 |
$sql = "SELECT * |
$sql = "SELECT * |
1192 |
FROM faculty |
FROM faculty |
1193 |
ORDER BY faculty_lastname, faculty_firstname, faculty_account"; |
ORDER BY faculty_lastname, faculty_firstname, faculty_account"; |
1194 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1195 |
|
|
1196 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1197 |
$faculty_id = $row["faculty_id"]; |
$faculty_id = $row["faculty_id"]; |
1198 |
$faculty_lastname = $row["faculty_lastname"]; |
$faculty_lastname = $row["faculty_lastname"]; |
1199 |
$faculty_firstname = $row["faculty_firstname"]; |
$faculty_firstname = $row["faculty_firstname"]; |
1234 |
$sql = "SELECT * FROM faculty " |
$sql = "SELECT * FROM faculty " |
1235 |
. $omit |
. $omit |
1236 |
. " ORDER BY faculty_lastname, faculty_firstname"; |
. " ORDER BY faculty_lastname, faculty_firstname"; |
1237 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1238 |
|
|
1239 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1240 |
$faculty_id = $row["faculty_id"]; |
$faculty_id = $row["faculty_id"]; |
1241 |
$faculty_lastname = $row["faculty_lastname"]; |
$faculty_lastname = $row["faculty_lastname"]; |
1242 |
$faculty_firstname = $row["faculty_firstname"]; |
$faculty_firstname = $row["faculty_firstname"]; |
1278 |
$sql = "SELECT * FROM faculty " |
$sql = "SELECT * FROM faculty " |
1279 |
. $limit |
. $limit |
1280 |
. " ORDER BY faculty_lastname, faculty_firstname"; |
. " ORDER BY faculty_lastname, faculty_firstname"; |
1281 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1282 |
|
|
1283 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1284 |
$faculty_id = $row["faculty_id"]; |
$faculty_id = $row["faculty_id"]; |
1285 |
$faculty_lastname = $row["faculty_lastname"]; |
$faculty_lastname = $row["faculty_lastname"]; |
1286 |
$faculty_firstname = $row["faculty_firstname"]; |
$faculty_firstname = $row["faculty_firstname"]; |
1328 |
. $table |
. $table |
1329 |
. " ORDER BY " |
. " ORDER BY " |
1330 |
. $field_display; |
. $field_display; |
1331 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1332 |
|
|
1333 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1334 |
$field_display_item = $row[$field_display]; |
$field_display_item = $row[$field_display]; |
1335 |
if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; |
if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; |
1336 |
$field_value_item = $row[$field_value]; |
$field_value_item = $row[$field_value]; |
1377 |
. $where |
. $where |
1378 |
. " ORDER BY " |
. " ORDER BY " |
1379 |
. $field_display; |
. $field_display; |
1380 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1381 |
|
|
1382 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1383 |
$field_display_item = $row[$field_display]; |
$field_display_item = $row[$field_display]; |
1384 |
if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; |
if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; |
1385 |
$field_value_item = $row[$field_value]; |
$field_value_item = $row[$field_value]; |
1428 |
. $limit |
. $limit |
1429 |
. " ORDER BY " |
. " ORDER BY " |
1430 |
. $field_display; |
. $field_display; |
1431 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1432 |
|
|
1433 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1434 |
$field_display_item = $row[$field_display]; |
$field_display_item = $row[$field_display]; |
1435 |
$field_value_item = $row[$field_value]; |
$field_value_item = $row[$field_value]; |
1436 |
if (strlen($field_display_item) > 50) $field_display_item = substr($field_display_item, 0, 49) . "..."; |
if (strlen($field_display_item) > 50) $field_display_item = substr($field_display_item, 0, 49) . "..."; |
1477 |
// Build the string. Start with the "(N/A)" and the "(ALL)" master subjects. |
// Build the string. Start with the "(N/A)" and the "(ALL)" master subjects. |
1478 |
$masterstring = "(1, 2 "; |
$masterstring = "(1, 2 "; |
1479 |
|
|
1480 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1481 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1482 |
$mastersubject_id = $row["mastersubject_id"]; |
$mastersubject_id = $row["mastersubject_id"]; |
1483 |
$masterstring .= ", " . $mastersubject_id; |
$masterstring .= ", " . $mastersubject_id; |
1484 |
} |
} |
1491 |
AND i.infotype_id > 0 and mi.masterinfotype_id > 0 |
AND i.infotype_id > 0 and mi.masterinfotype_id > 0 |
1492 |
AND i.mastersubject_id IN " . $masterstring . |
AND i.mastersubject_id IN " . $masterstring . |
1493 |
" ORDER BY mi.masterinfotype"; |
" ORDER BY mi.masterinfotype"; |
1494 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1495 |
|
|
1496 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1497 |
$masterinfotype = $row["masterinfotype"]; |
$masterinfotype = $row["masterinfotype"]; |
1498 |
$infotype_id = $row["infotype_id"]; |
$infotype_id = $row["infotype_id"]; |
1499 |
$infotype = $row["infotype"]; |
$infotype = $row["infotype"]; |
1534 |
WHERE ps.page_id = " |
WHERE ps.page_id = " |
1535 |
. $page_id |
. $page_id |
1536 |
. " AND s.staff_id > 1 AND ps.staff_id = s.staff_id ORDER BY last_name, first_name, staff_account"; |
. " AND s.staff_id > 1 AND ps.staff_id = s.staff_id ORDER BY last_name, first_name, staff_account"; |
1537 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1538 |
|
|
1539 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1540 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
1541 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
1542 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
1576 |
WHERE ps.page_id = " |
WHERE ps.page_id = " |
1577 |
. $page_id |
. $page_id |
1578 |
. " AND s.subject_id > 1 AND ps.subject_id = s.subject_id ORDER BY s.subject"; |
. " AND s.subject_id > 1 AND ps.subject_id = s.subject_id ORDER BY s.subject"; |
1579 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1580 |
|
|
1581 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1582 |
$subject_id = $row["subject_id"]; |
$subject_id = $row["subject_id"]; |
1583 |
$subject = $row["subject"]; |
$subject = $row["subject"]; |
1584 |
|
|
1648 |
|
|
1649 |
$sql .=" ORDER BY title, author, resource_id"; |
$sql .=" ORDER BY title, author, resource_id"; |
1650 |
|
|
1651 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1652 |
|
|
1653 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1654 |
$resource_id = $row["resource_id"]; |
$resource_id = $row["resource_id"]; |
1655 |
$title = $row["title"]; |
$title = $row["title"]; |
1656 |
//$author = $row["author"]; |
//$author = $row["author"]; |
1704 |
|
|
1705 |
$sql .= " ORDER BY s.service"; |
$sql .= " ORDER BY s.service"; |
1706 |
|
|
1707 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1708 |
|
|
1709 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1710 |
$service = $row["service"]; |
$service = $row["service"]; |
1711 |
$service_id = $row["service_id"]; |
$service_id = $row["service_id"]; |
1712 |
if (strlen($service) > 50) $service = substr($service, 0, 49) . "..."; |
if (strlen($service) > 50) $service = substr($service, 0, 49) . "..."; |
1738 |
$sql = "SELECT * |
$sql = "SELECT * |
1739 |
FROM staff |
FROM staff |
1740 |
ORDER BY last_name, first_name, staff_account"; |
ORDER BY last_name, first_name, staff_account"; |
1741 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1742 |
|
|
1743 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1744 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
1745 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
1746 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
1779 |
$sql = "SELECT * from staff " |
$sql = "SELECT * from staff " |
1780 |
. $omit |
. $omit |
1781 |
. " ORDER BY last_name, first_name"; |
. " ORDER BY last_name, first_name"; |
1782 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1783 |
|
|
1784 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1785 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
1786 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
1787 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
1818 |
|
|
1819 |
// Build the SQL |
// Build the SQL |
1820 |
$sql = "SELECT * from staff WHERE staff_id > 1 ORDER BY last_name, first_name"; |
$sql = "SELECT * from staff WHERE staff_id > 1 ORDER BY last_name, first_name"; |
1821 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1822 |
|
|
1823 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1824 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
1825 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
1826 |
$staff_id = $row["staff_id"]; |
$staff_id = $row["staff_id"]; |
1860 |
. "'"; |
. "'"; |
1861 |
|
|
1862 |
$faculty_id = 0; |
$faculty_id = 0; |
1863 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1864 |
|
|
1865 |
// Concatenate the NOT IN clause |
// Concatenate the NOT IN clause |
1866 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1867 |
if ($faculty_id == 0) $faculty_id = $row["faculty_id"]; |
if ($faculty_id == 0) $faculty_id = $row["faculty_id"]; |
1868 |
} |
} |
1869 |
|
|
1895 |
. " AND subject_id = " |
. " AND subject_id = " |
1896 |
. $subject_id; |
. $subject_id; |
1897 |
|
|
1898 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1899 |
$rowcount = mysql_num_rows($rs); |
$rowcount = xx_num_rows($rs); |
1900 |
if ($rowcount >= 1){ |
if ($rowcount >= 1){ |
1901 |
$rowcount = 1; |
$rowcount = 1; |
1902 |
} |
} |
1932 |
. $subject_id |
. $subject_id |
1933 |
. " AND infotype_id = 1"; |
. " AND infotype_id = 1"; |
1934 |
|
|
1935 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1936 |
$rowcount = mysql_num_rows($rs); |
$rowcount = xx_num_rows($rs); |
1937 |
if ($rowcount == 1){ |
if ($rowcount == 1){ |
1938 |
$rowcount = 1; |
$rowcount = 1; |
1939 |
} |
} |
1970 |
. $subject_id |
. $subject_id |
1971 |
. " AND infotype_id <> 1"; |
. " AND infotype_id <> 1"; |
1972 |
|
|
1973 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1974 |
$rowcount = mysql_num_rows($rs); |
$rowcount = xx_num_rows($rs); |
1975 |
if ($rowcount == 1){ |
if ($rowcount == 1){ |
1976 |
$rowcount = 1; |
$rowcount = 1; |
1977 |
} |
} |
2013 |
. "=" |
. "=" |
2014 |
. $limit_id; |
. $limit_id; |
2015 |
|
|
2016 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2017 |
$rowcount = mysql_num_rows($rs); |
$rowcount = xx_num_rows($rs); |
2018 |
if ($rowcount >= 1){ |
if ($rowcount >= 1){ |
2019 |
$rowcount = 1; |
$rowcount = 1; |
2020 |
} |
} |
2070 |
. " = " |
. " = " |
2071 |
. $static_value; |
. $static_value; |
2072 |
|
|
2073 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2074 |
|
|
2075 |
// Concatenate the NOT IN clause |
// Concatenate the NOT IN clause |
2076 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2077 |
$in_element = $row[$in_field]; |
$in_element = $row[$in_field]; |
2078 |
|
|
2079 |
if ($first_element == 0) { |
if ($first_element == 0) { |
2112 |
|
|
2113 |
$sql = "SELECT faculty_firstname, faculty_lastname FROM faculty WHERE faculty_id = " |
$sql = "SELECT faculty_firstname, faculty_lastname FROM faculty WHERE faculty_id = " |
2114 |
. $faculty_id; |
. $faculty_id; |
2115 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2116 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2117 |
$faculty_lastname = $row["faculty_lastname"]; |
$faculty_lastname = $row["faculty_lastname"]; |
2118 |
$faculty_firstname = $row["faculty_firstname"]; |
$faculty_firstname = $row["faculty_firstname"]; |
2119 |
|
|
2154 |
. "='" |
. "='" |
2155 |
. $key_value |
. $key_value |
2156 |
. "'"; |
. "'"; |
2157 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2158 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2159 |
if (mysql_num_rows($rs) == 1) $result = $row[$desc_field]; |
if (xx_num_rows($rs) == 1) $result = $row[$desc_field]; |
2160 |
else $result = ""; |
else $result = ""; |
2161 |
|
|
2162 |
return $result; |
return $result; |
2181 |
|
|
2182 |
$sql = "SELECT first_name, last_name FROM staff WHERE staff_id = " |
$sql = "SELECT first_name, last_name FROM staff WHERE staff_id = " |
2183 |
. $staff_id; |
. $staff_id; |
2184 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2185 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2186 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
2187 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
2188 |
|
|
2295 |
} |
} |
2296 |
|
|
2297 |
// Open the query and take a row count |
// Open the query and take a row count |
2298 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2299 |
$count = mysql_num_rows($rs); |
$count = xx_num_rows($rs); |
2300 |
|
|
2301 |
return $count; |
return $count; |
2302 |
} |
} |
2356 |
// Order the display |
// Order the display |
2357 |
$sql .= " ORDER BY coursesub_descr"; |
$sql .= " ORDER BY coursesub_descr"; |
2358 |
|
|
2359 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2360 |
|
|
2361 |
// Initialize row counter |
// Initialize row counter |
2362 |
$rowcount = 0; |
$rowcount = 0; |
2363 |
|
|
2364 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2365 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
2366 |
$coursesub = Trim($row["coursesub"]); |
$coursesub = Trim($row["coursesub"]); |
2367 |
$coursesub_descr = Trim($row["coursesub_descr"]); |
$coursesub_descr = Trim($row["coursesub_descr"]); |
2430 |
// Order the display |
// Order the display |
2431 |
$sql .= " ORDER BY faculty_lastname, faculty_firstname"; |
$sql .= " ORDER BY faculty_lastname, faculty_firstname"; |
2432 |
|
|
2433 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2434 |
|
|
2435 |
// Row counter |
// Row counter |
2436 |
$rowcount = 0; |
$rowcount = 0; |
2437 |
|
|
2438 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2439 |
$faculty_id = $row["faculty_id"]; |
$faculty_id = $row["faculty_id"]; |
2440 |
$faculty_firstname = Trim($row["faculty_firstname"]); |
$faculty_firstname = Trim($row["faculty_firstname"]); |
2441 |
$faculty_lastname = Trim($row["faculty_lastname"]); |
$faculty_lastname = Trim($row["faculty_lastname"]); |
2527 |
// Order the display |
// Order the display |
2528 |
$sql .= " ORDER BY " . $display_field; |
$sql .= " ORDER BY " . $display_field; |
2529 |
|
|
2530 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2531 |
|
|
2532 |
printf("<table width=\"60%%\" border = \"1\" >\n"); |
printf("<table width=\"60%%\" border = \"1\" >\n"); |
2533 |
printf("<tr><td class=\"cellPlain\">Description</td>\n"); |
printf("<tr><td class=\"cellPlain\">Description</td>\n"); |
2535 |
|
|
2536 |
$rowcount = 0; |
$rowcount = 0; |
2537 |
|
|
2538 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2539 |
$field_display_item = $row[$display_field]; |
$field_display_item = $row[$display_field]; |
2540 |
$field_value_item = (int) Trim($row[$key_field]); |
$field_value_item = (int) Trim($row[$key_field]); |
2541 |
|
|
2608 |
// Order the display |
// Order the display |
2609 |
$sql .= " ORDER BY last_name, first_name"; |
$sql .= " ORDER BY last_name, first_name"; |
2610 |
|
|
2611 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2612 |
|
|
2613 |
$rowcount = 0; |
$rowcount = 0; |
2614 |
|
|
2615 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2616 |
$first_name = Trim($row["first_name"]); |
$first_name = Trim($row["first_name"]); |
2617 |
$last_name = Trim($row["last_name"]); |
$last_name = Trim($row["last_name"]); |
2618 |
$staff_account = $row["staff_account"]; |
$staff_account = $row["staff_account"]; |
2678 |
**********************************************************/ |
**********************************************************/ |
2679 |
|
|
2680 |
function statQuery($sql){ |
function statQuery($sql){ |
2681 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2682 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2683 |
|
|
2684 |
// We should be getting only a single row. |
// We should be getting only a single row. |
2685 |
if (mysql_num_rows($rs) == 1) $result = $row["COUNT(*)"]; |
if (xx_num_rows($rs) == 1) $result = $row["COUNT(*)"]; |
2686 |
else $result = "UNKNOWN"; |
else $result = "UNKNOWN"; |
2687 |
|
|
2688 |
return $result; |
return $result; |