--- branches/paul/admin/include/app_controls.php 2004/03/18 19:58:18 68 +++ branches/paul_xx/admin/include/app_controls.php 2004/03/18 20:01:09 69 @@ -182,13 +182,13 @@ $lu_sql = "SELECT libunit_id FROM libunit WHERE head_staff_id = " . $sess_staff_id; - $lu_rs = mysql_tryquery($lu_sql); + $lu_rs = xx_tryquery($lu_sql); $lu_string = "ls.libunit_id IN ("; $first_element = 0; // Concatenate the IN clause - while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { + while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { $libunit_id = $lu_row["libunit_id"]; //printf("libunit id was: %d

", $libunit_id); @@ -235,8 +235,8 @@ // Run the authorized page query if not DBA level if ($sess_access_level >= 20 && $sess_access_level < 1000) { - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); // Collect the access information $auth_page = $row["auth_page"]; @@ -308,8 +308,8 @@ . $sess_staff_account . "'"; - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); // Collect the access information $auth_resource = $row["auth_resource"]; @@ -396,8 +396,8 @@ . $sess_staff_account . "'"; - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); // Collect the access information $auth_resource = $row["auth_resource"]; @@ -499,13 +499,13 @@ $lu_sql = "SELECT libunit_id FROM libunit WHERE head_staff_id = " . $sess_staff_id; - $lu_rs = mysql_tryquery($lu_sql); + $lu_rs = xx_tryquery($lu_sql); $lu_string = "ls.libunit_id IN ("; $first_element = 0; // Concatenate the IN clause - while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { + while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { $libunit_id = $lu_row["libunit_id"]; //printf("libunit id was: %d

", $libunit_id); @@ -551,8 +551,8 @@ // Run the authorized subject query if not DBA level if ($sess_access_level >= 20 && $sess_access_level < 1000) { - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); // Collect the access information $auth_subject = $row["auth_subject"]; @@ -589,8 +589,8 @@ . $omit . " ORDER BY last_name, first_name"; - $rs = mysql_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + $rs = xx_tryquery($sql); + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $last_name = $row["last_name"]; $first_name = $row["first_name"]; $staff_id = $row["staff_id"]; @@ -690,13 +690,13 @@ $lu_sql = "SELECT libunit_id FROM libunit WHERE head_staff_id = " . $sess_staff_id; - $lu_rs = mysql_tryquery($lu_sql); + $lu_rs = xx_tryquery($lu_sql); $lu_string = "ls.libunit_id IN ("; $first_element = 0; // Concatenate the IN clause - while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { + while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { $libunit_id = $lu_row["libunit_id"]; if ($first_element == 0) { @@ -743,9 +743,9 @@ // Run the authorized page query if not DBA level if ($sess_access_level >= 20 && $sess_access_level < 1000) { - $page_rs = mysql_tryquery($page_sql); + $page_rs = xx_tryquery($page_sql); - while ($page_row = mysql_fetch_array ($page_rs, MYSQL_ASSOC)) { + while ($page_row = xx_fetch_array ($page_rs, xx_ASSOC)) { // Collect the page information $page_id = $page_row["page_id"]; @@ -839,13 +839,13 @@ $lu_sql = "SELECT libunit_id FROM libunit WHERE head_staff_id = " . $sess_staff_id; - $lu_rs = mysql_tryquery($lu_sql); + $lu_rs = xx_tryquery($lu_sql); $lu_string = "ls.libunit_id IN ("; $first_element = 0; // Concatenate the IN clause - while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { + while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { $libunit_id = $lu_row["libunit_id"]; printf("libunit id was: %d

", $libunit_id); @@ -892,9 +892,9 @@ // Run the authorized page query if not DBA level if ($sess_access_level >= 20 && $sess_access_level < 1000) { - $page_rs = mysql_tryquery($page_sql); + $page_rs = xx_tryquery($page_sql); - while ($page_row = mysql_fetch_array ($page_rs, MYSQL_ASSOC)) { + while ($page_row = xx_fetch_array ($page_rs, xx_ASSOC)) { // Collect the page information $page_id = $page_row["page_id"]; @@ -971,13 +971,13 @@ $lu_sql = "SELECT libunit_id FROM libunit WHERE head_staff_id = " . $sess_staff_id; - $lu_rs = mysql_tryquery($lu_sql); + $lu_rs = xx_tryquery($lu_sql); $lu_string = "ls.libunit_id IN ("; $first_element = 0; // Concatenate the IN clause - while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) { + while ($lu_row = xx_fetch_array ($lu_rs, xx_ASSOC)) { $libunit_id = $lu_row["libunit_id"]; printf("libunit id was: %d

", $libunit_id); @@ -1022,9 +1022,9 @@ // Run the authorized page query if not DBA level if ($sess_access_level >= 20 && $sess_access_level < 1000) { - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { // Collect the page information $subject_id = $row["subject_id"]; @@ -1060,8 +1060,8 @@ FROM course ORDER BY course_concat"; - $rs = mysql_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + $rs = xx_tryquery($sql); + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $page_id = $row["page_id"]; $course_concat = $row["course_concat"]; @@ -1103,8 +1103,8 @@ . " ORDER BY coursesub_descr"; // Fetch the values - $rs = mysql_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + $rs = xx_tryquery($sql); + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $coursesub = $row["coursesub"]; $coursesub_id = $row["coursesub_id"]; $coursesub_descr = $row["coursesub_descr"]; @@ -1151,8 +1151,8 @@ $sql .= " ORDER BY coursesub_descr"; // Fetch the values - $rs = mysql_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + $rs = xx_tryquery($sql); + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $coursesub = $row["coursesub"]; $coursesub_id = $row["coursesub_id"]; $coursesub_descr = $row["coursesub_descr"]; @@ -1191,9 +1191,9 @@ $sql = "SELECT * FROM faculty ORDER BY faculty_lastname, faculty_firstname, faculty_account"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $faculty_id = $row["faculty_id"]; $faculty_lastname = $row["faculty_lastname"]; $faculty_firstname = $row["faculty_firstname"]; @@ -1234,9 +1234,9 @@ $sql = "SELECT * FROM faculty " . $omit . " ORDER BY faculty_lastname, faculty_firstname"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $faculty_id = $row["faculty_id"]; $faculty_lastname = $row["faculty_lastname"]; $faculty_firstname = $row["faculty_firstname"]; @@ -1278,9 +1278,9 @@ $sql = "SELECT * FROM faculty " . $limit . " ORDER BY faculty_lastname, faculty_firstname"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $faculty_id = $row["faculty_id"]; $faculty_lastname = $row["faculty_lastname"]; $faculty_firstname = $row["faculty_firstname"]; @@ -1328,9 +1328,9 @@ . $table . " ORDER BY " . $field_display; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $field_display_item = $row[$field_display]; if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; $field_value_item = $row[$field_value]; @@ -1377,9 +1377,9 @@ . $where . " ORDER BY " . $field_display; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $field_display_item = $row[$field_display]; if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; $field_value_item = $row[$field_value]; @@ -1428,9 +1428,9 @@ . $limit . " ORDER BY " . $field_display; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $field_display_item = $row[$field_display]; $field_value_item = $row[$field_value]; if (strlen($field_display_item) > 50) $field_display_item = substr($field_display_item, 0, 49) . "..."; @@ -1477,8 +1477,8 @@ // Build the string. Start with the "(N/A)" and the "(ALL)" master subjects. $masterstring = "(1, 2 "; - $rs = mysql_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + $rs = xx_tryquery($sql); + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $mastersubject_id = $row["mastersubject_id"]; $masterstring .= ", " . $mastersubject_id; } @@ -1491,9 +1491,9 @@ AND i.infotype_id > 0 and mi.masterinfotype_id > 0 AND i.mastersubject_id IN " . $masterstring . " ORDER BY mi.masterinfotype"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $masterinfotype = $row["masterinfotype"]; $infotype_id = $row["infotype_id"]; $infotype = $row["infotype"]; @@ -1534,9 +1534,9 @@ WHERE ps.page_id = " . $page_id . " AND s.staff_id > 1 AND ps.staff_id = s.staff_id ORDER BY last_name, first_name, staff_account"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $staff_id = $row["staff_id"]; $last_name = $row["last_name"]; $first_name = $row["first_name"]; @@ -1576,9 +1576,9 @@ WHERE ps.page_id = " . $page_id . " AND s.subject_id > 1 AND ps.subject_id = s.subject_id ORDER BY s.subject"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $subject_id = $row["subject_id"]; $subject = $row["subject"]; @@ -1648,9 +1648,9 @@ $sql .=" ORDER BY title, author, resource_id"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $resource_id = $row["resource_id"]; $title = $row["title"]; //$author = $row["author"]; @@ -1704,9 +1704,9 @@ $sql .= " ORDER BY s.service"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $service = $row["service"]; $service_id = $row["service_id"]; if (strlen($service) > 50) $service = substr($service, 0, 49) . "..."; @@ -1738,9 +1738,9 @@ $sql = "SELECT * FROM staff ORDER BY last_name, first_name, staff_account"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $staff_id = $row["staff_id"]; $last_name = $row["last_name"]; $first_name = $row["first_name"]; @@ -1779,9 +1779,9 @@ $sql = "SELECT * from staff " . $omit . " ORDER BY last_name, first_name"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $last_name = $row["last_name"]; $first_name = $row["first_name"]; $staff_id = $row["staff_id"]; @@ -1818,9 +1818,9 @@ // Build the SQL $sql = "SELECT * from staff WHERE staff_id > 1 ORDER BY last_name, first_name"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $last_name = $row["last_name"]; $first_name = $row["first_name"]; $staff_id = $row["staff_id"]; @@ -1860,10 +1860,10 @@ . "'"; $faculty_id = 0; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); // Concatenate the NOT IN clause - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { if ($faculty_id == 0) $faculty_id = $row["faculty_id"]; } @@ -1895,8 +1895,8 @@ . " AND subject_id = " . $subject_id; - $rs = mysql_tryquery($sql); - $rowcount = mysql_num_rows($rs); + $rs = xx_tryquery($sql); + $rowcount = xx_num_rows($rs); if ($rowcount >= 1){ $rowcount = 1; } @@ -1932,8 +1932,8 @@ . $subject_id . " AND infotype_id = 1"; - $rs = mysql_tryquery($sql); - $rowcount = mysql_num_rows($rs); + $rs = xx_tryquery($sql); + $rowcount = xx_num_rows($rs); if ($rowcount == 1){ $rowcount = 1; } @@ -1970,8 +1970,8 @@ . $subject_id . " AND infotype_id <> 1"; - $rs = mysql_tryquery($sql); - $rowcount = mysql_num_rows($rs); + $rs = xx_tryquery($sql); + $rowcount = xx_num_rows($rs); if ($rowcount == 1){ $rowcount = 1; } @@ -2013,8 +2013,8 @@ . "=" . $limit_id; - $rs = mysql_tryquery($sql); - $rowcount = mysql_num_rows($rs); + $rs = xx_tryquery($sql); + $rowcount = xx_num_rows($rs); if ($rowcount >= 1){ $rowcount = 1; } @@ -2070,10 +2070,10 @@ . " = " . $static_value; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); // Concatenate the NOT IN clause - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $in_element = $row[$in_field]; if ($first_element == 0) { @@ -2112,8 +2112,8 @@ $sql = "SELECT faculty_firstname, faculty_lastname FROM faculty WHERE faculty_id = " . $faculty_id; - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); $faculty_lastname = $row["faculty_lastname"]; $faculty_firstname = $row["faculty_firstname"]; @@ -2154,9 +2154,9 @@ . "='" . $key_value . "'"; - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); - if (mysql_num_rows($rs) == 1) $result = $row[$desc_field]; + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); + if (xx_num_rows($rs) == 1) $result = $row[$desc_field]; else $result = ""; return $result; @@ -2181,8 +2181,8 @@ $sql = "SELECT first_name, last_name FROM staff WHERE staff_id = " . $staff_id; - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); $last_name = $row["last_name"]; $first_name = $row["first_name"]; @@ -2295,8 +2295,8 @@ } // Open the query and take a row count - $rs = mysql_tryquery($sql); - $count = mysql_num_rows($rs); + $rs = xx_tryquery($sql); + $count = xx_num_rows($rs); return $count; } @@ -2356,12 +2356,12 @@ // Order the display $sql .= " ORDER BY coursesub_descr"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); // Initialize row counter $rowcount = 0; - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $coursesub_id = $row["coursesub_id"]; $coursesub = Trim($row["coursesub"]); $coursesub_descr = Trim($row["coursesub_descr"]); @@ -2430,12 +2430,12 @@ // Order the display $sql .= " ORDER BY faculty_lastname, faculty_firstname"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); // Row counter $rowcount = 0; - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $faculty_id = $row["faculty_id"]; $faculty_firstname = Trim($row["faculty_firstname"]); $faculty_lastname = Trim($row["faculty_lastname"]); @@ -2527,7 +2527,7 @@ // Order the display $sql .= " ORDER BY " . $display_field; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); printf("\n"); printf("\n"); @@ -2535,7 +2535,7 @@ $rowcount = 0; - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $field_display_item = $row[$display_field]; $field_value_item = (int) Trim($row[$key_field]); @@ -2608,11 +2608,11 @@ // Order the display $sql .= " ORDER BY last_name, first_name"; - $rs = mysql_tryquery($sql); + $rs = xx_tryquery($sql); $rowcount = 0; - while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { + while ($row = xx_fetch_array ($rs, xx_ASSOC)) { $first_name = Trim($row["first_name"]); $last_name = Trim($row["last_name"]); $staff_account = $row["staff_account"]; @@ -2678,11 +2678,11 @@ **********************************************************/ function statQuery($sql){ - $rs = mysql_tryquery($sql); - $row = mysql_fetch_array ($rs, MYSQL_ASSOC); + $rs = xx_tryquery($sql); + $row = xx_fetch_array ($rs, xx_ASSOC); // We should be getting only a single row. - if (mysql_num_rows($rs) == 1) $result = $row["COUNT(*)"]; + if (xx_num_rows($rs) == 1) $result = $row["COUNT(*)"]; else $result = "UNKNOWN"; return $result;
Description