--- 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("
Description | \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;