/[libdata]/branches/paul/admin/include/app_controls.php

This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!

Diff of /branches/paul/admin/include/app_controls.php

Parent Directory | Revision Log | View Patch Patch

-revision 66 by dpavlin,
Thu Jan 15 16:10:00 2004 UTC
+revision 67 by dpavlin,
Thu Mar 18 19:24:54 2004 UTC
 Line 1
  <?php
  /**********************************************************
  Function Library: app_controls.php
- Original Author: Paul Bramscher <brams006@tc.umn.edu>
+ Original Author: Paul Bramscher <brams006@umn.edu>
- Last Modified: 09.29.2003
+ Last Modified: 03.15.2004
  ***********************************************************
  Comments:
  Functions here are generally related to drawing of HTML
 Line 19 
 authPage
  authResourceDelete
  authResourceEdit
  authSubject
- commaList
- displayKeys
- displayRelatedPages
  dropDownAccountOmit
  dropDownAuthCourses
  dropDownAuthPages
-Line 44 
 dropDownStaffOmit
+Line 41 
 dropDownStaffOmit
  dropDownStaffSelected
  existsResSub
  existsResSubNA
+ existsResSubNOTNA
  existsRow
  getNotIn
- locationList
  lookupFaculty
  lookupField
  lookupStaff
- radioField
+ msgTableClose
+ msgTableOpen
  recordCount
  selectCoursesub
  selectFaculty
-Line 104 
 function adminReturn($sess_access_level)
+Line 102 
 function adminReturn($sess_access_level)
  /**********************************************************
- Function: authPage($con, $page_id, $sess_access_level, $sess_staff_id)
+ Function: authPage($page_id, $sess_access_level, $sess_staff_id)
  Author: Paul Bramscher
- Last Modified: 01.15.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $page_id                Page to test authorization
  $sess_access_level      Access level of the current user
                          session.
-Line 141 
 by the manager of the new unit and not y
+Line 138 
 by the manager of the new unit and not y
  etc...
  **********************************************************/
- function authPage($con, $page_id, $sess_access_level, $sess_staff_id){
+ function authPage($page_id, $sess_access_level, $sess_staff_id){
          /* Access Table Definitions
          +-----------+--------------+---------+
-Line 180 
 function authPage($con, $page_id, $sess_
+Line 177 
 function authPage($con, $page_id, $sess_
          // User is a manager.  Must be page coordinator, co-maintainer, or manager of
          // the coordinator's unit.
          else if ($sess_access_level == 100) {
                          // Determine libunit
                          $lu_sql = "SELECT libunit_id FROM libunit
                                  WHERE head_staff_id = "
                                  . $sess_staff_id;
-                         $lu_rs = mysql_query($lu_sql, $con);
+                         $lu_rs = mysql_tryquery($lu_sql);
                          $lu_string = "ls.libunit_id IN (";
                          $first_element = 0;
                          // Concatenate the IN clause
-                         while ($lu_row = mysql_fetch_array ($lu_rs)) {
+                         while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) {
                                  $libunit_id = $lu_row["libunit_id"];
                                  //printf("libunit id was: %d<BR><BR>", $libunit_id);
-Line 239 
 function authPage($con, $page_id, $sess_
+Line 235 
 function authPage($con, $page_id, $sess_
          // Run the authorized page query if not DBA level
          if ($sess_access_level >= 20 && $sess_access_level < 1000) {
-                 $rs = mysql_query($sql, $con);
+                 $rs = mysql_tryquery($sql);
-                 $row = mysql_fetch_array ($rs);
+                 $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
                  // Collect the access information
                  $auth_page = $row["auth_page"];
-Line 254 
 function authPage($con, $page_id, $sess_
+Line 250 
 function authPage($con, $page_id, $sess_
  /**********************************************************
- Function: authResourceDelete($con, $resource_id, $sess_access_level,
+ Function: authResourceDelete($resource_id, $sess_access_level,
          $sess_staff_account)
  Author: Paul Bramscher
- Last Modified: 08.26.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $resource_id            Resource to test authorization
  $sess_access_level      Access level of the current user
                          session.
-Line 278 
 supplied resource.  The following rules
+Line 273 
 supplied resource.  The following rules
  (2) Any staffperson with access greater than guest and less than
  manager may delete only those resource s/he has created.
  **********************************************************/
- function authResourceDelete($con, $resource_id, $sess_access_level,
+ function authResourceDelete($resource_id, $sess_access_level,
          $sess_staff_account) {
          /* Access Table Definitions
-Line 313 
 function authResourceDelete($con, $resou
+Line 308 
 function authResourceDelete($con, $resou
                          . $sess_staff_account
                          . "'";
-                 $rs = mysql_query($sql, $con);
+                 $rs = mysql_tryquery($sql);
-                 $row = mysql_fetch_array ($rs);
+                 $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
                  // Collect the access information
                  $auth_resource = $row["auth_resource"];
-Line 332 
 function authResourceDelete($con, $resou
+Line 327 
 function authResourceDelete($con, $resou
          uncomment the previous portion and delete this.
          Note: 08.21.2003 - PFB. Open editing of resources by any author is now verboten.
-         // Author or higher access.  Great edit/delete access for everything.
+         // Author or higher access.  Grant edit/delete access for everything.
          if ($sess_access_level >= "10" ) {
                  $auth_resource = 1;
          }
          */
-         // Every other access level.  No resources at all!
-         else {
-                 $auth_resource = 0;
-         }
          return $auth_resource;
-Line 350 
 function authResourceDelete($con, $resou
+Line 339 
 function authResourceDelete($con, $resou
  /**********************************************************
- Function: authResourceEdit($con, $resource_id, $sess_access_level,
+ Function: authResourceEdit($resource_id, $sess_access_level,
          $sess_staff_account)
  Author: Paul Bramscher
- Last Modified: 08.26.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $resource_id            Resource to test authorization
  $sess_access_level      Access level of the current user
                          session.
-Line 372 
 supplied resource.  The following rules
+Line 360 
 supplied resource.  The following rules
  (1) Authors and above may edit all resources
  **********************************************************/
- function authResourceEdit($con, $resource_id, $sess_access_level,
+ function authResourceEdit($resource_id, $sess_access_level,
          $sess_staff_account) {
          /* Access Table Definitions
-Line 408 
 function authResourceEdit($con, $resourc
+Line 396 
 function authResourceEdit($con, $resourc
                          . $sess_staff_account
                          . "'";
-                 $rs = mysql_query($sql, $con);
+                 $rs = mysql_tryquery($sql);
-                 $row = mysql_fetch_array ($rs);
+                 $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
                  // Collect the access information
                  $auth_resource = $row["auth_resource"];
-Line 435 
 function authResourceEdit($con, $resourc
+Line 423 
 function authResourceEdit($con, $resourc
          if ($sess_access_level >= 10 ) {
                  $auth_resource = 1;
          }
-         // Every other access level.  No resources at all!
-         else {
-                 $auth_resource = 0;
-         }
-         // Testing
-         // printf("sql was: %s<BR>", $sql);
-         // printf("sess acl: %s<BR>", $sess_access_level);
-         // printf("sess_staff_account: %s<BR>", $sess_staff_account);
-         // printf("auth res: %s<br>", $auth_resource);
          return $auth_resource;
-Line 454 
 function authResourceEdit($con, $resourc
+Line 430 
 function authResourceEdit($con, $resourc
  /**********************************************************
- Function: authSubject($con, $sess_access_level, $sess_staff_id,
+ Function: authSubject($sess_access_level, $sess_staff_id,
          $subject_id)
  Author: Paul Bramscher
- Last Modified: 01.22.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $sess_access_level      Access level of the current user
                          session.
  $sess_staff_id          staff id of the current user
-Line 482 
 which they are assigned.
+Line 457 
 which they are assigned.
  **********************************************************/
- function authSubject($con, $sess_access_level, $sess_staff_id,
+ function authSubject($sess_access_level, $sess_staff_id,
          $subject_id){
          /* Access Table Definitions
-Line 524 
 function authSubject($con, $sess_access_
+Line 499 
 function authSubject($con, $sess_access_
                          $lu_sql = "SELECT libunit_id FROM libunit
                                  WHERE head_staff_id = "
                                  . $sess_staff_id;
-                         $lu_rs = mysql_query($lu_sql, $con);
+                         $lu_rs = mysql_tryquery($lu_sql);
                          $lu_string = "ls.libunit_id IN (";
                          $first_element = 0;
                          // Concatenate the IN clause
-                         while ($lu_row = mysql_fetch_array ($lu_rs)) {
+                         while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) {
                                  $libunit_id = $lu_row["libunit_id"];
                                  //printf("libunit id was: %d<BR><BR>", $libunit_id);
-Line 573 
 function authSubject($con, $sess_access_
+Line 548 
 function authSubject($con, $sess_access_
                  $auth_subject = 0;
          }
-         // Testing
-         // printf("sql was: %s<BR>", $sql);
          // Run the authorized subject query if not DBA level
          if ($sess_access_level >= 20 && $sess_access_level < 1000) {
-                 $rs = mysql_query($sql, $con);
+                 $rs = mysql_tryquery($sql);
-                 $row = mysql_fetch_array ($rs);
+                 $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
                  // Collect the access information
                  $auth_subject = $row["auth_subject"];
-Line 594 
 function authSubject($con, $sess_access_
+Line 566 
 function authSubject($con, $sess_access_
  /**********************************************************
- Function: commaList($con, $displayField, $sql)
+ Function: dropDownAccountOmit($omit)
  Author: Paul Bramscher
- Last Modified: 07.02.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
- $displayField           Field to display
- $sql                    SQL to execute
- ***********************************************************
- Outgoing:
- None
- ***********************************************************
- Purpose:
- Performs a lookup similar to lookupField, but instead of
- returning the descriptive value for an ID field, it returns
- a comma-separated list of results.
- **********************************************************/
- function commaList($con, $displayField, $sql){
-         $rs = mysql_query($sql, $con);
-         $first = 1;
-         while ($row = mysql_fetch_array ($rs)) {
-                 $result = $row[$displayField];
-                 if ($first == 1) {
-                         $first = 0;
-                         printf("%s", $result);
-                 }
-                 else printf(", %s", $result);
-         }
- }
- /**********************************************************
- Function: displayKeys($con, $table, $field_display,
- $field_value, $limit)
- Author: Paul Bramscher
- Last Modified: 7.26.2001
- ***********************************************************
- Incoming:
- $con                    Database connection string
- $table                  Table in database to search
- $field_display          Select displayed to user
- $field_value            Actual value of the HTML tag
- $limit                  Field to limit $field_display by
- ***********************************************************
- Outgoing:
- None
- ***********************************************************
- Purpose:
- Does a simple text dump to show descriptive values and
- their associated primary keys in a small table.  If
- $limit is defined, then limit the result set to display
- only $field_display which matches a like cause.
- **********************************************************/
- function displayKeys($con, $table, $field_display,
-         $field_value, $limit){
-         // Build the sql
-         $sql = "SELECT " . $field_display . ", "
-                 . $field_value . " FROM " . $table;
-         if (strlen($limit) > 1){
-                 $sql .= " WHERE "
-                         . $field_display
-                         . " LIKE '%"
-                         . $limit
-                         . "%'";
-         }
-         // Order the display
-         $sql .= " ORDER BY " . $field_display;
-         $rs = mysql_query($sql, $con);
-         printf("<td><b>Description</b></td>");
-         printf("<td><b>Key</b></td></tr>");
-         while ($row = mysql_fetch_array ($rs)) {
-                 $field_display_item = $row[$field_display];
-                 $field_value_item = $row[$field_value];
-                 printf("<tr><td>"
-                         . $field_display_item
-                         . "</td><td>"
-                         . $field_value_item
-                         . "</td></tr>");
-         };
- }
- /**********************************************************
- Function: displayRelatedPages($con, $subject_id)
- Author: Paul Bramscher
- Last Modified: 06.17.2003
- ***********************************************************
- Incoming:
- $con                    Database connection string
- $subject_id             Subject of the RQS page
- ***********************************************************
- Outgoing:
- None
- ***********************************************************
- Purpose:
- Displays any PageScribe pages associated with the supplied
- subject id.
- **********************************************************/
- function displayRelatedPages($con, $subject_id){
-         $sql = "SELECT p.page_id, p.page_title
-                 FROM page p, sub_page sp
-                 WHERE sp.subject_id = "
-                         . $subject_id
-                         . " AND sp.page_id = p.page_id ORDER BY p.page_title";
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
-                 $page_id = $row["page_id"];
-                 $page_title = $row["page_title"];
-                 // Pull out any HTML
-                 $page_title = strip_tags($page_title);
-                 printf("<a href=\"page.phtml?page_id=%s\">%s</a><BR>\n", $page_id, $page_title);
-         };
- }
- /**********************************************************
- Function: dropDownAccountOmit($con, $omit)
- Author: Paul Bramscher
- Last Modified: 04.01.2003
- ***********************************************************
- Incoming:
- $con                    Database connection string
  $omit                   String of staff's to omit
  ***********************************************************
  Outgoing:
-Line 738 
 it returns the staff_account.  This was
+Line 584 
 it returns the staff_account.  This was
  which a relational tie with the staff table is not desirable
  after the value is inserted.  For example, historical statistics.
  **********************************************************/
- function dropDownAccountOmit($con, $omit){
+ function dropDownAccountOmit($omit){
-         $sql = "SELECT * from staff " . $omit .
+         $sql = "SELECT * from staff "
-         " ORDER BY last_name, first_name";
+                 . $omit
+                 . " ORDER BY last_name, first_name";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $last_name = $row["last_name"];
                  $first_name = $row["first_name"];
                  $staff_id = $row["staff_id"];
-Line 752 
 function dropDownAccountOmit($con, $omit
+Line 599 
 function dropDownAccountOmit($con, $omit
                  // Make it look more friendly
                  if ($staff_id == 1) $staff = "(N/A)";
                  else $staff = $last_name . ", " . $first_name . " (" . $staff_account . ")";
-                 printf("<option value = \"" . $staff_account
+                 printf("<option value = \""
-                         . "\" >" . $staff . "</option>\n");
+                         . $staff_account
+                         . "\" >"
+                         . $staff
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownAuthCourses($con, $sess_access_level, $sess_staff_id)
+ Function: dropDownAuthCourses($sess_access_level, $sess_staff_id)
  Author: Paul Bramscher
- Last Modified: 01.07.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $sess_access_level      Access level of the current user
                          session.
  $sess_staff_id          staff id of the current user
-Line 799 
 accessed by the manager of the new unit
+Line 648 
 accessed by the manager of the new unit
  etc...
  **********************************************************/
- function dropDownAuthCourses($con, $sess_access_level, $sess_staff_id){
+ function dropDownAuthCourses($sess_access_level, $sess_staff_id){
          /* Access Table Definitions
          +-----------+--------------+---------+
-Line 841 
 function dropDownAuthCourses($con, $sess
+Line 690 
 function dropDownAuthCourses($con, $sess
                          $lu_sql = "SELECT libunit_id FROM libunit
                                  WHERE head_staff_id = "
                                  . $sess_staff_id;
-                         $lu_rs = mysql_query($lu_sql, $con);
+                         $lu_rs = mysql_tryquery($lu_sql);
                          $lu_string = "ls.libunit_id IN (";
                          $first_element = 0;
                          // Concatenate the IN clause
-                         while ($lu_row = mysql_fetch_array ($lu_rs)) {
+                         while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) {
                                  $libunit_id = $lu_row["libunit_id"];
                                  if ($first_element == 0) {
-Line 882 
 function dropDownAuthCourses($con, $sess
+Line 731 
 function dropDownAuthCourses($con, $sess
                  // DBA.  Access everything.
                  case "1000" :
-                         dropDownCourses($con);
+                         dropDownCourses();
                          break;
                  // Every other access level.  No pages at all!
-Line 894 
 function dropDownAuthCourses($con, $sess
+Line 743 
 function dropDownAuthCourses($con, $sess
          // Run the authorized page query if not DBA level
          if ($sess_access_level >= 20 && $sess_access_level < 1000) {
-                 $page_rs = mysql_query($page_sql, $con);
+                 $page_rs = mysql_tryquery($page_sql);
-                 while ($page_row = mysql_fetch_array ($page_rs)) {
+                 while ($page_row = mysql_fetch_array ($page_rs, MYSQL_ASSOC)) {
                          // Collect the page information
                          $page_id = $page_row["page_id"];
-Line 914 
 function dropDownAuthCourses($con, $sess
+Line 763 
 function dropDownAuthCourses($con, $sess
  /**********************************************************
- Function: dropDownAuthPages($con, $sess_access_level, $sess_staff_id)
+ Function: dropDownAuthPages($sess_access_level, $sess_staff_id)
  Author: Paul Bramscher
- Last Modified: 01.07.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $sess_access_level      Access level of the current user
                          session.
  $sess_staff_id          staff id of the current user
-Line 950 
 by the manager of the new unit and not y
+Line 798 
 by the manager of the new unit and not y
  etc...
  **********************************************************/
- function dropDownAuthPages($con, $sess_access_level, $sess_staff_id){
+ function dropDownAuthPages($sess_access_level, $sess_staff_id){
          /* Access Table Definitions
          +-----------+--------------+---------+
-Line 991 
 function dropDownAuthPages($con, $sess_a
+Line 839 
 function dropDownAuthPages($con, $sess_a
                          $lu_sql = "SELECT libunit_id FROM libunit
                                  WHERE head_staff_id = "
                                  . $sess_staff_id;
-                         $lu_rs = mysql_query($lu_sql, $con);
+                         $lu_rs = mysql_tryquery($lu_sql);
                          $lu_string = "ls.libunit_id IN (";
                          $first_element = 0;
                          // Concatenate the IN clause
-                         while ($lu_row = mysql_fetch_array ($lu_rs)) {
+                         while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) {
                                  $libunit_id = $lu_row["libunit_id"];
                                  printf("libunit id was: %d<BR><BR>", $libunit_id);
-Line 1032 
 function dropDownAuthPages($con, $sess_a
+Line 880 
 function dropDownAuthPages($con, $sess_a
                  // DBA.  Access everything.
                  case "1000" :
-                         dropDownFieldOmit($con, "page", "page_title", "page_id", " WHERE pagetype_id = 2");
+                         dropDownFieldOmit("page", "page_title", "page_id", " WHERE pagetype_id = 2");
                          break;
                  // Every other access level.  No pages at all!
-Line 1044 
 function dropDownAuthPages($con, $sess_a
+Line 892 
 function dropDownAuthPages($con, $sess_a
          // Run the authorized page query if not DBA level
          if ($sess_access_level >= 20 && $sess_access_level < 1000) {
-                 $page_rs = mysql_query($page_sql, $con);
+                 $page_rs = mysql_tryquery($page_sql);
-                 while ($page_row = mysql_fetch_array ($page_rs)) {
+                 while ($page_row = mysql_fetch_array ($page_rs, MYSQL_ASSOC)) {
                          // Collect the page information
                          $page_id = $page_row["page_id"];
-Line 1058 
 function dropDownAuthPages($con, $sess_a
+Line 906 
 function dropDownAuthPages($con, $sess_a
                          printf("<option value=\"%d\">%s</option>\n", $page_id, $page_title);
                  }
-         // printf("sql was: %s<BR>", $page_sql);
          }
  }
  /**********************************************************
- Function: dropDownAuthSubjects($con, $sess_access_level, $sess_staff_id)
+ Function: dropDownAuthSubjects($sess_access_level, $sess_staff_id)
  Author: Paul Bramscher
- Last Modified: 01.22.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $sess_access_level      Access level of the current user
                          session.
  $sess_staff_id          staff id of the current user
-Line 1090 
 user has authorization to edit.  The fol
+Line 934 
 user has authorization to edit.  The fol
  (3) Any staffperson can manage subjects to which s/he is assigned.
  **********************************************************/
- function dropDownAuthSubjects($con, $sess_access_level, $sess_staff_id){
+ function dropDownAuthSubjects($sess_access_level, $sess_staff_id){
          /* Access Table Definitions
          +-----------+--------------+---------+
-Line 1127 
 function dropDownAuthSubjects($con, $ses
+Line 971 
 function dropDownAuthSubjects($con, $ses
                          $lu_sql = "SELECT libunit_id FROM libunit
                                  WHERE head_staff_id = "
                                  . $sess_staff_id;
-                         $lu_rs = mysql_query($lu_sql, $con);
+                         $lu_rs = mysql_tryquery($lu_sql);
                          $lu_string = "ls.libunit_id IN (";
                          $first_element = 0;
                          // Concatenate the IN clause
-                         while ($lu_row = mysql_fetch_array ($lu_rs)) {
+                         while ($lu_row = mysql_fetch_array ($lu_rs, MYSQL_ASSOC)) {
                                  $libunit_id = $lu_row["libunit_id"];
                                  printf("libunit id was: %d<BR><BR>", $libunit_id);
-Line 1166 
 function dropDownAuthSubjects($con, $ses
+Line 1010 
 function dropDownAuthSubjects($con, $ses
                  // DBA.  Access everything.
                  case "1000" :
-                         dropDownFieldOmit($con, "subject", "subject", "subject_id", "WHERE SUBJECT_ID > 1");
+                         dropDownFieldOmit("subject", "subject", "subject_id", "WHERE SUBJECT_ID > 1");
                          break;
                  // Every other access level.  No pages at all!
-Line 1178 
 function dropDownAuthSubjects($con, $ses
+Line 1022 
 function dropDownAuthSubjects($con, $ses
          // Run the authorized page query if not DBA level
          if ($sess_access_level >= 20 && $sess_access_level < 1000) {
-                 $rs = mysql_query($sql, $con);
+                 $rs = mysql_tryquery($sql);
-                 while ($row = mysql_fetch_array ($rs)) {
+                 while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                          // Collect the page information
                          $subject_id = $row["subject_id"];
-Line 1190 
 function dropDownAuthSubjects($con, $ses
+Line 1034 
 function dropDownAuthSubjects($con, $ses
                          printf("<option value=\"%d\">%s</option>\n", $subject_id, $subject);
                  }
-         printf("sql was: %s<BR>", $sql);
          }
  }
  /**********************************************************
- Function: dropDownCourses($con)
+ Function: dropDownCourses()
  Author: Paul Bramscher
- Last Modified: 11.26.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
+ None
  ***********************************************************
  Outgoing:
  None
-Line 1213 
 Purpose:
+Line 1054 
 Purpose:
  Populates a drop-down box on an HTML form with courseScribe
  courses, listed by course name and designator.
  **********************************************************/
- function dropDownCourses($con) {
+ function dropDownCourses() {
          $sql = "SELECT page_id, course_concat
                  FROM course
                  ORDER BY course_concat";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $page_id = $row["page_id"];
                  $course_concat = $row["course_concat"];
                  if (strlen($course_concat) > 45) $course_concat = substr($course_concat, 0, 45) . "...";
-                 printf("<option value = \"" . $page_id
+                 printf("<option value = \""
-                         . "\" >" . $course_concat . "</option>\n");
+                         . $page_id
+                         . "\" >"
+                         . $course_concat
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownCoursesubOmit($con, $omit)
+ Function: dropDownCoursesubOmit($omit)
  Author: Paul Bramscher
- Last Modified: 06.04.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $omit                   String of coursesub's to omit
  ***********************************************************
  Outgoing:
-Line 1248 
 Purpose:
+Line 1091 
 Purpose:
  Populates a drop-down box on an HTML form with select
  statements.  $omit limits output.
  **********************************************************/
- function dropDownCoursesubOmit($con, $omit){
+ function dropDownCoursesubOmit($omit){
-         $sql = "SELECT coursesub, coursesub_descr, coursesub_id, cip_code FROM
+         $sql = "SELECT
-                 coursesub "
+                 coursesub,
+                 coursesub_descr,
+                 coursesub_id,
+                 cip_code
+                 FROM coursesub "
                  . $omit
                  . " ORDER BY coursesub_descr";
          // Fetch the values
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $coursesub = $row["coursesub"];
                  $coursesub_id = $row["coursesub_id"];
                  $coursesub_descr = $row["coursesub_descr"];
                  $cip_code = $row["cip_code"];
                  // Limit length
-                 if (strlen($coursesub_descr) > 30) $coursesub_descr = substr($coursesub_descr, 0, 30) . "...";
+                 if (strlen($coursesub_descr) > 30)
+                         $coursesub_descr = substr($coursesub_descr, 0, 30) . "...";
-                 printf("<option value = \"%s\">%s | %s [%s]</option>", $coursesub_id, $coursesub, $coursesub_descr, $cip_code);
+                 printf("<option value = \"%s\">%s | %s [%s]</option>",
+                         $coursesub_id, $coursesub, $coursesub_descr, $cip_code);
          }
  }
  /**********************************************************
- Function: dropDownCoursesubSelected($con, $limit, $preselected)
+ Function: dropDownCoursesubSelected($limit, $preselected)
  Author: Paul Bramscher
- Last Modified: 08.18.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $limit                  Additional limit on the box
  $preselected            Pre-selected course subject
  ***********************************************************
-Line 1288 
 Purpose:
+Line 1136 
 Purpose:
  Populates a drop-down box on an HTML form with select
  statements.  $limit limits output.
  **********************************************************/
- function dropDownCoursesubSelected($con, $limit, $preselected){
+ function dropDownCoursesubSelected($limit, $preselected){
          $sql = "SELECT
                  coursesub,
-Line 1303 
 function dropDownCoursesubSelected($con,
+Line 1151 
 function dropDownCoursesubSelected($con,
          $sql .= " ORDER BY coursesub_descr";
          // Fetch the values
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $coursesub = $row["coursesub"];
                  $coursesub_id = $row["coursesub_id"];
                  $coursesub_descr = $row["coursesub_descr"];
                  $cip_code = $row["cip_code"];
                  // Limit length
-                 if (strlen($coursesub_descr) > 25) $coursesub_descr = substr($coursesub_descr, 0, 30) . "...";
+                 if (strlen($coursesub_descr) > 25)
+                         $coursesub_descr = substr($coursesub_descr, 0, 30) . "...";
                  printf("<option value = \"%d\"", $coursesub_id);
                  if ($coursesub_id == $preselected) printf(" selected ");
-Line 1322 
 function dropDownCoursesubSelected($con,
+Line 1171 
 function dropDownCoursesubSelected($con,
  /**********************************************************
- Function: dropDownFaculty($con)
+ Function: dropDownFaculty()
  Author: Paul Bramscher
- Last Modified: 12.02.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
+ None
  ***********************************************************
  Outgoing:
  None
-Line 1335 
 None
+Line 1184 
 None
  Purpose:
  Populates a drop-down box on an HTML form with select
  options of faculty members.  They are displayed and ordered
- in the following format: "last name, first name (x500id)".
+ in the following format: "last name, first name (staff account)".
  **********************************************************/
- function dropDownFaculty($con){
+ function dropDownFaculty(){
          // Build the SQL.
          $sql = "SELECT *
                  FROM faculty
                  ORDER BY faculty_lastname, faculty_firstname, faculty_account";
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $faculty_id = $row["faculty_id"];
                  $faculty_lastname = $row["faculty_lastname"];
                  $faculty_firstname = $row["faculty_firstname"];
-Line 1357 
 function dropDownFaculty($con){
+Line 1206 
 function dropDownFaculty($con){
                          if (strlen($faculty_account) > 0) $faculty .= " (" . $faculty_account . ")";
                  }
-                 printf("<option value = \"" . $faculty_id
+                 printf("<option value = \""
-                         . "\" >" . $faculty . "</option>\n");
+                         . $faculty_id
+                         . "\" >"
+                         . $faculty
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownFacultyOmit($con, $omit)
+ Function: dropDownFacultyOmit($omit)
  Author: Paul Bramscher
- Last Modified: 12.12.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $omit                   String of human's to omit
  ***********************************************************
  Outgoing:
-Line 1379 
 Purpose:
+Line 1230 
 Purpose:
  Populates a drop-down box on an HTML form with select
  statements.  $omit limits output.
  **********************************************************/
- function dropDownFacultyOmit($con, $omit){
+ function dropDownFacultyOmit($omit){
          $sql = "SELECT * FROM faculty "
                  . $omit
                  . " ORDER BY faculty_lastname, faculty_firstname";
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         while ($row = mysql_fetch_array ($rs)) {
                  $faculty_id = $row["faculty_id"];
                  $faculty_lastname = $row["faculty_lastname"];
                  $faculty_firstname = $row["faculty_firstname"];
-Line 1398 
 function dropDownFacultyOmit($con, $omit
+Line 1249 
 function dropDownFacultyOmit($con, $omit
                          if (strlen($faculty_account) > 0) $faculty .= " (" . $faculty_account . ")";
                  }
-                 printf("<option value = \"" . $faculty_id
+                 printf("<option value = \""
-                         . "\" >" . $faculty . "</option>\n");
+                         . $faculty_id
+                         . "\" >"
+                         . $faculty
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownFacultySelected($con, $limit, $preselected)
+ Function: dropDownFacultySelected($limit, $preselected)
  Author: Paul Bramscher
- Last Modified: 12.12.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $limit                  Any WHERE clause
  $preselected            Incoming faculty person to preselect
  ***********************************************************
-Line 1421 
 Purpose:
+Line 1274 
 Purpose:
  Populates a drop-down box on an HTML form with select
  statements.  $omit limits output.
  **********************************************************/
- function dropDownFacultySelected($con, $limit, $preselected){
+ function dropDownFacultySelected($limit, $preselected){
          $sql = "SELECT * FROM faculty "
                  . $limit
                  . " ORDER BY faculty_lastname, faculty_firstname";
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         while ($row = mysql_fetch_array ($rs)) {
                  $faculty_id = $row["faculty_id"];
                  $faculty_lastname = $row["faculty_lastname"];
                  $faculty_firstname = $row["faculty_firstname"];
-Line 1447 
 function dropDownFacultySelected($con, $
+Line 1300 
 function dropDownFacultySelected($con, $
  /**********************************************************
- Function: dropDownField($con, $table, $field_display,
+ Function: dropDownField($table, $field_display,
  $field_value)
  Author: Paul Bramscher
- Last Modified: 7.26.2000
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $table                  Table in database to search
  $field_display          Select displayed to user
  $field_value            Actual value of the HTML tag
-Line 1466 
 Populates a drop-down box on an HTML for
+Line 1318 
 Populates a drop-down box on an HTML for
  options.  They are ordered by the $field_display field.
  Typically, $field_value is the primary key field.
  **********************************************************/
- function dropDownField($con, $table, $field_display, $field_value){
+ function dropDownField($table, $field_display, $field_value){
          $sql = "SELECT "
                  . $field_display
-Line 1476 
 function dropDownField($con, $table, $fi
+Line 1328 
 function dropDownField($con, $table, $fi
                  . $table
                  . " ORDER BY "
                  . $field_display;
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_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];
-                 printf("<option value = \"" . $field_value_item
+                 printf("<option value = \""
-                         . "\" >" . $field_display_item . "</option>\n");
+                         . $field_value_item
+                         . "\" >"
+                         . $field_display_item
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownFieldOmit($con, $table, $field_display,
+ Function: dropDownFieldOmit($table, $field_display,
  $field_value, $where)
  Author: Paul Bramscher
- Last Modified: 8.14.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $table                  Table in database to search
  $field_display          Select displayed to user
  $field_value            Actual value of the HTML tag
-Line 1510 
 options.  They are ordered by the $field
+Line 1364 
 options.  They are ordered by the $field
  Typically, $field_value is the primary key field.  $where
  can be used to filter out results.
  **********************************************************/
- function dropDownFieldOmit($con, $table, $field_display,
+ function dropDownFieldOmit($table, $field_display,
          $field_value, $where){
          $sql = "SELECT "
-Line 1523 
 function dropDownFieldOmit($con, $table,
+Line 1377 
 function dropDownFieldOmit($con, $table,
                  . $where
                  . " ORDER BY "
                  . $field_display;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_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];
-                 printf("<option value = \"" . $field_value_item
+                 printf("<option value = \""
-                         . "\" >" . $field_display_item . "</option>\n");
+                         . $field_value_item
+                         . "\" >"
+                         . $field_display_item
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownFieldSelected($con, $table, $field_display,
+ Function: dropDownFieldSelected($table, $field_display,
  $field_value, $limit, $preselected)
  Author: Paul Bramscher
- Last Modified: 12.04.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $table                  Table in database to search
  $field_display          Select displayed to user
  $field_value            Actual value of the HTML tag
-Line 1558 
 Typically, $field_value is the primary k
+Line 1415 
 Typically, $field_value is the primary k
  parameter $preselected determines which (single) selection
  is selected.
  **********************************************************/
- function dropDownFieldSelected($con, $table, $field_display,
+ function dropDownFieldSelected($table, $field_display,
          $field_value, $limit, $preselected){
          $sql = "SELECT "
-Line 1571 
 function dropDownFieldSelected($con, $ta
+Line 1428 
 function dropDownFieldSelected($con, $ta
                  . $limit
                  . " ORDER BY "
                  . $field_display;
+         $rs = mysql_tryquery($sql);
-         // Debugging
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         //printf("sql was: %s<BR>", $sql);
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
                  $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) . "...";
-Line 1589 
 function dropDownFieldSelected($con, $ta
+Line 1443 
 function dropDownFieldSelected($con, $ta
  /**********************************************************
- Function: dropDownInfotype($con, $infotype_id, $subject_id)
+ Function: dropDownInfotype($infotype_id, $subject_id)
  Author: Paul Bramscher
- Last Modified: 12.04.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $subject_id             Subject on which to limit the list
  ***********************************************************
  Outgoing:
-Line 1605 
 Populates a drop-down box on an HTML for
+Line 1458 
 Populates a drop-down box on an HTML for
  options of information types including general and
  master subject-specific.
  **********************************************************/
- function dropDownInfotype($con, $infotype_id, $subject_id){
+ function dropDownInfotype($infotype_id, $subject_id){
          // Initialize
          $selected_infotype_id = $infotype_id;
-Line 1616 
 function dropDownInfotype($con, $infotyp
+Line 1469 
 function dropDownInfotype($con, $infotyp
          on subject.
          */
-         $sql = "SELECT sm.mastersubject_id FROM sub_mastersubject sm WHERE sm.subject_id = "
+         $sql = "SELECT sm.mastersubject_id
+                 FROM sub_mastersubject sm
+                 WHERE sm.subject_id = "
                  . $subject_id;
-         // Debugging
-         //printf("sql was: %s<BR>", $sql);
          // Build the string.  Start with the "(N/A)" and the "(ALL)" master subjects.
          $masterstring = "(1, 2 ";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $mastersubject_id = $row["mastersubject_id"];
                  $masterstring .= ", " . $mastersubject_id;
          }
-Line 1634 
 function dropDownInfotype($con, $infotyp
+Line 1486 
 function dropDownInfotype($con, $infotyp
          // Build the list of infotypes appropriate to all of the mastersubjects found
          $sql = "SELECT i.infotype, i.infotype_id, mi.masterinfotype
-         FROM infotype i, masterinfotype mi
+                 FROM infotype i, masterinfotype mi
-         WHERE i.masterinfotype_id = mi.masterinfotype_id
+                 WHERE i.masterinfotype_id = mi.masterinfotype_id
-         AND i.infotype_id > 0 and mi.masterinfotype_id > 0
+                 AND i.infotype_id > 0 and mi.masterinfotype_id > 0
-         AND i.mastersubject_id IN " . $masterstring .
+                 AND i.mastersubject_id IN " . $masterstring .
-         " ORDER BY mi.masterinfotype";
+                 " ORDER BY mi.masterinfotype";
-         printf("sql was: %s<br>", $sql);
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         while ($row = mysql_fetch_array ($rs)) {
                  $masterinfotype = $row["masterinfotype"];
                  $infotype_id = $row["infotype_id"];
                  $infotype = $row["infotype"];
                  // Make it look more friendly
                  $useroutput = $masterinfotype . " -> " . $infotype;
-Line 1659 
 function dropDownInfotype($con, $infotyp
+Line 1509 
 function dropDownInfotype($con, $infotyp
  /**********************************************************
- Function: dropDownPageStaff($con, $page_id)
+ Function: dropDownPageStaff($page_id)
  Author: Paul Bramscher
- Last Modified: 10.23.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $page_id                PageScribe page involved
  ***********************************************************
  Outgoing:
-Line 1677 
 in the following format: "last name, fir
+Line 1526 
 in the following format: "last name, fir
  The staff displayed are those associated as PageScribe
  maintainers.
  **********************************************************/
- function dropDownPageStaff($con, $page_id){
+ function dropDownPageStaff($page_id){
          // Build the SQL.
          $sql = "SELECT s.first_name, s.last_name, s.staff_id, s.staff_account
-Line 1685 
 function dropDownPageStaff($con, $page_i
+Line 1534 
 function dropDownPageStaff($con, $page_i
                  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 = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $staff_id = $row["staff_id"];
                  $last_name = $row["last_name"];
                  $first_name = $row["first_name"];
-Line 1695 
 function dropDownPageStaff($con, $page_i
+Line 1544 
 function dropDownPageStaff($con, $page_i
                  // Make it look more friendly
                  $staff = $last_name . ", " . $first_name . " (" . $staff_account . ")";
-                 printf("<option value = \"" . $staff_id
+                 printf("<option value = \""
-                         . "\" >" . $staff . "</option>\n");
+                         . $staff_id
+                         . "\" >"
+                         . $staff
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownPageSubject($con, $page_id)
+ Function: dropDownPageSubject($page_id)
  Author: Paul Bramscher
- Last Modified: 06.17.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $page_id                PageScribe page involved
  ***********************************************************
  Outgoing:
-Line 1717 
 Purpose:
+Line 1568 
 Purpose:
  Populates a drop-down box on an HTML form with select
  options of associated RQS subjects for the supplied page id.
  **********************************************************/
- function dropDownPageSubject($con, $page_id){
+ function dropDownPageSubject($page_id){
          // Build the SQL.
          $sql = "SELECT s.subject_id, s.subject
-Line 1725 
 function dropDownPageSubject($con, $page
+Line 1576 
 function dropDownPageSubject($con, $page
                  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 = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $subject_id = $row["subject_id"];
                  $subject = $row["subject"];
-                 printf("<option value = \"" . $subject_id
+                 printf("<option value = \""
-                         . "\" >" . $subject . "</option>\n");
+                         . $subject_id
+                         . "\" >"
+                         . $subject
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownResource($con, $key_id, $letter, $masterinfotype_id, $feature_id)
+ Function: dropDownResource($key_id, $letter, $masterinfotype_id, $feature_id)
  Author: Paul Bramscher
- Last Modified: 05.28.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $key_id                 "0" for a new resource, otherwise
                          indicates a pre-selected resource
  $limit                  Starting with letter A-Z or freetext.
-Line 1767 
 the query checks against all titles star
+Line 1620 
 the query checks against all titles star
  Otherwise it checks against all titles or annotations
  containing that string.
  **********************************************************/
- function dropDownResource($con, $key_id, $limit, $masterinfotype_id, $feature_id){
+ function dropDownResource($key_id, $limit, $masterinfotype_id, $feature_id){
          // Clean up the limit string
          if (strlen($limit) > 0) $limit = textSearchmySQL($limit);
-Line 1795 
 function dropDownResource($con, $key_id,
+Line 1648 
 function dropDownResource($con, $key_id,
          $sql .=" ORDER BY title, author, resource_id";
-         // Debugging
+         $rs = mysql_tryquery($sql);
-         // printf("sql was: %s<BR>", $sql);
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
                  $resource_id = $row["resource_id"];
                  $title = $row["title"];
                  //$author = $row["author"];
-Line 1824 
 function dropDownResource($con, $key_id,
+Line 1675 
 function dropDownResource($con, $key_id,
  /**********************************************************
- Function: dropDownServiceLimit($con, $servicetype_id)
+ Function: dropDownServiceLimit($servicetype_id)
  Author: Paul Bramscher
- Last Modified: 06.16.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $servicetype_id         Service type to limit the picklist
  ***********************************************************
  Outgoing:
-Line 1840 
 Populates a drop-down box on an HTML for
+Line 1690 
 Populates a drop-down box on an HTML for
  options for library services, limited to a supplied service
  type id.
  **********************************************************/
- function dropDownServiceLimit($con, $servicetype_id){
+ function dropDownServiceLimit($servicetype_id){
          $sql = "SELECT DISTINCT s.service, s.service_id FROM service s
                  LEFT JOIN serv_servtype ss using (service_id)
-                 LEFT JOIN servicetype v on ss.servicetype_id = v.servicetype_id";
+                 LEFT JOIN servicetype v on ss.servicetype_id = v.servicetype_id
+                 WHERE s.service_id > 1";
                  if ($servicetype_id > 0) {
-                         $sql .= " WHERE ss.servicetype_id = "
+                         $sql .= " AND ss.servicetype_id = "
                                  . $servicetype_id;
                  }
                  $sql .= " ORDER BY s.service";
-         // Debugging
+         $rs = mysql_tryquery($sql);
-         // printf("sql was: %s<BR>", $sql);
-         $rs = mysql_query($sql, $con);
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         while ($row = mysql_fetch_array ($rs)) {
                  $service = $row["service"];
                  $service_id = $row["service_id"];
                  if (strlen($service) > 50) $service = substr($service, 0, 49) . "...";
-Line 1868 
 function dropDownServiceLimit($con, $ser
+Line 1717 
 function dropDownServiceLimit($con, $ser
  /**********************************************************
- Function: dropDownStaff($con)
+ Function: dropDownStaff()
  Author: Paul Bramscher
- Last Modified: 6.7.2001
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
+ None
  ***********************************************************
  Outgoing:
  None
-Line 1883 
 Populates a drop-down box on an HTML for
+Line 1732 
 Populates a drop-down box on an HTML for
  options of staff members.  They are displayed and ordered
  in the following format: "last name, first name (x500id)".
  **********************************************************/
- function dropDownStaff($con){
+ function dropDownStaff(){
          // Build the SQL
          $sql = "SELECT *
                  FROM staff
                  ORDER BY last_name, first_name, staff_account";
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $staff_id = $row["staff_id"];
                  $last_name = $row["last_name"];
                  $first_name = $row["first_name"];
-Line 1900 
 function dropDownStaff($con){
+Line 1749 
 function dropDownStaff($con){
                  // Make it look more friendly
                  if ($staff_id == 1) $staff = "(N/A)";
                  else $staff = $last_name . ", " . $first_name . " (" . $staff_account . ")";
-                 printf("<option value = \"" . $staff_id
+                 printf("<option value = \""
-                         . "\" >" . $staff . "</option>\n");
+                         . $staff_id
+                         . "\" >"
+                         . $staff
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownStaffOmit($con, $omit)
+ Function: dropDownStaffOmit($omit)
  Author: Paul Bramscher
- Last Modified: 10.08.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $omit                   String of staff's to omit
  ***********************************************************
  Outgoing:
-Line 1922 
 Purpose:
+Line 1773 
 Purpose:
  Populates a drop-down box on an HTML form with select
  statements.  $omit limits output.
  **********************************************************/
- function dropDownStaffOmit($con, $omit){
+ function dropDownStaffOmit($omit){
          // Build the SQL
          $sql = "SELECT * from staff "
                  . $omit
                  . " ORDER BY last_name, first_name";
+         $rs = mysql_tryquery($sql);
-         $rs = mysql_query($sql, $con);
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
-         while ($row = mysql_fetch_array ($rs)) {
                  $last_name = $row["last_name"];
                  $first_name = $row["first_name"];
                  $staff_id = $row["staff_id"];
-Line 1939 
 function dropDownStaffOmit($con, $omit){
+Line 1790 
 function dropDownStaffOmit($con, $omit){
                  // Make it look more friendly
                  if ($staff_id == 1) $staff = "(N/A)";
                  else $staff = $last_name . ", " . $first_name . " (" . $staff_account . ")";
-                 printf("<option value = \"" . $staff_id
+                 printf("<option value = \""
-                         . "\" >" . $staff . "</option>\n");
+                         . $staff_id
+                         . "\" >"
+                         . $staff
+                         . "</option>\n");
          };
  }
  /**********************************************************
- Function: dropDownStaffSelected($con, $selected_id)
+ Function: dropDownStaffSelected($selected_id)
  Author: Paul Bramscher
- Last Modified: 6.12.2001
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $selected_id            Selected staff id
  ***********************************************************
  Outgoing:
-Line 1961 
 Purpose:
+Line 1814 
 Purpose:
  Populates a drop-down box on an HTML form with select
  statements.  Selected id represents the preselected staff.
  **********************************************************/
- function dropDownStaffSelected($con, $selected_id){
+ function dropDownStaffSelected($selected_id){
          // Build the SQL
          $sql = "SELECT * from staff WHERE staff_id > 1 ORDER BY last_name, first_name";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $last_name = $row["last_name"];
                  $first_name = $row["first_name"];
                  $staff_id = $row["staff_id"];
-Line 1980 
 function dropDownStaffSelected($con, $se
+Line 1834 
 function dropDownStaffSelected($con, $se
  /**********************************************************
  Function: existsFaculty
  Author: Paul Bramscher
- Last Modified: 06.24.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                            Database connection string
  $faculty_firstname              Faculty first name
  $faculty_lastname               Faculty last name
  ***********************************************************
-Line 1994 
 Purpose:
+Line 1847 
 Purpose:
  This function checks to see whether a match against the
  supplied faculty first and last name already exists.
  **********************************************************/
- function existsFaculty($con, $faculty_firstname, $faculty_lastname){
+ function existsFaculty($faculty_firstname, $faculty_lastname){
          // Build the sql
          $faculty_firstname = textInmySQL($faculty_firstname);
-Line 2007 
 function existsFaculty($con, $faculty_fi
+Line 1860 
 function existsFaculty($con, $faculty_fi
                  . "'";
          $faculty_id = 0;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          // Concatenate the NOT IN clause
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  if ($faculty_id == 0) $faculty_id = $row["faculty_id"];
          }
-Line 2021 
 function existsFaculty($con, $faculty_fi
+Line 1874 
 function existsFaculty($con, $faculty_fi
  /**********************************************************
  Function: existsResSub
  Author: Paul Bramscher
- Last Modified: 12.09.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                            Database connection string
  $resource_id                    Record ID
  $subject_id                     Subject ID
  ***********************************************************
-Line 2035 
 Purpose:
+Line 1887 
 Purpose:
  This function checks to see whether a resource has already
  been attached to a given subject id.
  **********************************************************/
- function existsResSub($con, $resource_id, $subject_id){
+ function existsResSub($resource_id, $subject_id){
          // Build the sql
          $sql = "SELECT * FROM res_sub_infotype WHERE resource_id = "
-Line 2043 
 function existsResSub($con, $resource_id
+Line 1895 
 function existsResSub($con, $resource_id
                  . " AND subject_id = "
                  . $subject_id;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          $rowcount = mysql_num_rows($rs);
          if ($rowcount >= 1){
                  $rowcount = 1;
-Line 2057 
 function existsResSub($con, $resource_id
+Line 1909 
 function existsResSub($con, $resource_id
  /**********************************************************
  Function: existsResSubNA
  Author: Paul Bramscher
- Last Modified: 05.27.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                            Database connection string
  $resource_id                    Record ID
  $subject_id                     Subject ID
  ***********************************************************
-Line 2072 
 This function is similar to existsResSub
+Line 1923 
 This function is similar to existsResSub
  specifically to see whether the (N/A) type information type
  is currently assigned to the resource-subject combination.
  **********************************************************/
- function existsResSubNA($con, $resource_id, $subject_id){
+ function existsResSubNA($resource_id, $subject_id){
          // Build the sql
          $sql = "SELECT * FROM res_sub_infotype WHERE resource_id = "
-Line 2081 
 function existsResSubNA($con, $resource_
+Line 1932 
 function existsResSubNA($con, $resource_
                  . $subject_id
                  . " AND infotype_id = 1";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
+         $rowcount = mysql_num_rows($rs);
+         if ($rowcount == 1){
+                 $rowcount = 1;
+         }
+         else $rowcount = 0;
+         return $rowcount;
+ }
+ /**********************************************************
+ Function: existsResSubNOTNA
+ Author: Paul Bramscher
+ Last Modified: 03.02.2004
+ ***********************************************************
+ Incoming:
+ $resource_id                    Record ID
+ $subject_id                     Subject ID
+ ***********************************************************
+ Outgoing:
+ "1" if an association already exists, "0" if not
+ ***********************************************************
+ Purpose:
+ This function is similar to existsResSubNA, but it checks to
+ see if the combination of resource/subject appears in the
+ res_sub_infotype table under a heading other than N/A for
+ the infotype.
+ **********************************************************/
+ function existsResSubNOTNA($resource_id, $subject_id){
+         // Build the sql
+         $sql = "SELECT * FROM res_sub_infotype WHERE resource_id = "
+                 . $resource_id
+                 . " AND subject_id = "
+                 . $subject_id
+                 . " AND infotype_id <> 1";
+         $rs = mysql_tryquery($sql);
          $rowcount = mysql_num_rows($rs);
          if ($rowcount == 1){
                  $rowcount = 1;
-Line 2095 
 function existsResSubNA($con, $resource_
+Line 1984 
 function existsResSubNA($con, $resource_
  /**********************************************************
  Function: existsRow
  Author: Paul Bramscher
- Last Modified: 12.09.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $table                  Table to search
  $key_field              Field against which to search
  $key_id                 Limit for the where clause
-Line 2111 
 Useful in performing delete and other op
+Line 1999 
 Useful in performing delete and other op
  sure that a row entity exists matching the supplied key
  before going any further.
  **********************************************************/
- function existsRow($con, $table, $key_field, $limit_id){
+ function existsRow($table, $key_field, $limit_id){
          // Cast as integer to avoid future problems
          $limit_id = (int) $limit_id;
-Line 2125 
 function existsRow($con, $table, $key_fi
+Line 2013 
 function existsRow($con, $table, $key_fi
                  . "="
                  . $limit_id;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          $rowcount = mysql_num_rows($rs);
          if ($rowcount >= 1){
                  $rowcount = 1;
-Line 2139 
 function existsRow($con, $table, $key_fi
+Line 2027 
 function existsRow($con, $table, $key_fi
  /**********************************************************
  Function: getNotIn
  Author: Paul Bramscher
- Last Modified: 12.09.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $in_field               Name of ID field to return
  $static_field           Name of the "other" ID field in the
                          bridging table
-Line 2166 
 selections.  The remaining (available) s
+Line 2053 
 selections.  The remaining (available) s
  exclude the current ones.  Thus, this function builds the
  NOT IN portion of the SQL WHERE clause.
  **********************************************************/
- function getNotIn($con, $in_field, $static_field,
+ function getNotIn($in_field, $static_field,
          $static_value, $table) {
          // Initialze
-Line 2183 
 function getNotIn($con, $in_field, $stat
+Line 2070 
 function getNotIn($con, $in_field, $stat
                  . " = "
                  . $static_value;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          // Concatenate the NOT IN clause
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $in_element = $row[$in_field];
                  if ($first_element == 0) {
-Line 2208 
 function getNotIn($con, $in_field, $stat
+Line 2095 
 function getNotIn($con, $in_field, $stat
  /**********************************************************
- Function: locationList($con, $resource_id)
+ Function: lookupFaculty($faculty_id)
  Author: Paul Bramscher
- Last Modified: 07.02.2002
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
- $resource_id            Resource ID to check locations on
- ***********************************************************
- Outgoing:
- None
- ***********************************************************
- Purpose:
- Looks up location(s) for this resource
- **********************************************************/
- function locationList($con, $resource_id){
-         // Initialize
-         $locations = "";
-         $first = 1;
-         $sql = "SELECT location FROM location l, res_loc rl WHERE rl.resource_id = "
-                 . $resource_id
-                 . " AND rl.location_id = l.location_id ORDER BY location";
-         $rs = mysql_query($sql, $con);
-         while ($row = mysql_fetch_array ($rs)) {
-                 $location = $row["location"];
-                 if ($first == 1) {
-                         $first = 0;
-                         $locations = $location;
-                 }
-                 else $locations .= "; " . $location;
-         }
-         return $locations;
- }
- /**********************************************************
- Function: lookupFaculty($con, $faculty_id)
- Author: Paul Bramscher
- Last Modified: 12.03.2002
- ***********************************************************
- Incoming:
- $con                    Database connection string
  $faculty_id             Faculty ID number to retrieve
  ***********************************************************
  Outgoing:
-Line 2261 
 Faculty name in {First Name} {Last Name}
+Line 2108 
 Faculty name in {First Name} {Last Name}
  Purpose:
  Performs a lookup on faculty ID to retrieve name.
  **********************************************************/
- function lookupFaculty($con, $faculty_id){
+ function lookupFaculty($faculty_id){
          $sql = "SELECT faculty_firstname, faculty_lastname FROM faculty WHERE faculty_id = "
                  . $faculty_id;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         $row = mysql_fetch_array ($rs);
+         $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
          $faculty_lastname = $row["faculty_lastname"];
          $faculty_firstname = $row["faculty_firstname"];
          $faculty_name .= $faculty_firstname . " " . $faculty_lastname;
-         // Debugging
-         //printf("sql was: %s<BR>", $sql);
          return $faculty_name;
  }
  /**********************************************************
- Function: lookupField($con, $table, $key_field, $key_value,
+ Function: lookupField($table, $key_field, $key_value,
  $desc_field)
  Author: Paul Bramscher
- Last Modified: 9.14.2000
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $table                  Table in database to search
  $key_field              Name of field on which to lookup
  $key_value              Value to attempt lookup with
-Line 2298 
 Purpose:
+Line 2142 
 Purpose:
  Performs a lookup, typically on an ID field, to retrieve a
  user-friendly descriptive name to the page.
  **********************************************************/
- function lookupField($con, $table, $key_field, $key_value,
+ function lookupField($table, $key_field, $key_value,
          $desc_field){
          $sql = "SELECT "
-Line 2310 
 function lookupField($con, $table, $key_
+Line 2154 
 function lookupField($con, $table, $key_
                  . "='"
                  . $key_value
                  . "'";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         $row = mysql_fetch_array ($rs);
+         $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
          if (mysql_num_rows($rs) == 1) $result = $row[$desc_field];
          else $result = "";
-Line 2320 
 function lookupField($con, $table, $key_
+Line 2164 
 function lookupField($con, $table, $key_
  /**********************************************************
- Function: lookupStaff($con, $staff_id)
+ Function: lookupStaff($staff_id)
  Author: Paul Bramscher
- Last Modified: 7.22.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $staff_id               Staff ID number to retrieve
  ***********************************************************
  Outgoing:
-Line 2334 
 Staff name in {First Name} {Last Name} f
+Line 2177 
 Staff name in {First Name} {Last Name} f
  Purpose:
  Performs a lookup on staff ID to retrieve name.
  **********************************************************/
- function lookupStaff($con, $staff_id){
+ function lookupStaff($staff_id){
          $sql = "SELECT first_name, last_name FROM staff WHERE staff_id = "
                  . $staff_id;
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         $row = mysql_fetch_array ($rs);
+         $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
          $last_name = $row["last_name"];
          $first_name = $row["first_name"];
          $staff_name .= $first_name . " " . $last_name;
-         // Debugging
-         //printf("sql was: %s<BR>", $sql);
          return $staff_name;
  }
  /**********************************************************
- Function: radioField($con, $table, $field_display,
+ Function: msgTableClose()
- $field_value, $position)
  Author: Paul Bramscher
- Last Modified: 12.04.2002
+ Last Modified: 03.15.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
+ None
- $table                  Table in database to search
- $field_display          Select displayed to user
- $field_value            Actual value of the HTML tag
- $position               Either "V" vertical or "H"
-                         horizontal to indicate display of
-                         radio buttons
  ***********************************************************
  Outgoing:
  None
  ***********************************************************
  Purpose:
- Populates radio boxes on an HTML form with values from a
+ Closes the message box table.
- table.  They are ordered by $field_display in either
- horizontal or vertical fashion.  Each checkbox in the set
- is named $field_display.
  **********************************************************/
- function radioField($con, $table, $field_display,
+ function msgTableClose () {
- $field_value, $positon){
+         printf("</td></tr></table>\n");
+         printf("</center>\n");
-         $rd_sql = "SELECT "
-                 . $field_display
-                 . ", "
-                 . $field_value
-                 . " FROM "
-                 . $table
-                 . " ORDER BY "
-                 . $field_display;
-         $rd_rs = mysql_query($rd_sql, $con);
-         while ($rd_row = mysql_fetch_array ($rd_rs)) {
-                 $field_display_item = $rd_row[$field_display];
-                 $field_value_item = $rd_row[$field_value];
-                 printf("<input type='radio' name='"
-                         . $field_display
-                         . " value =\""
-                         . $field_value_item
-                         . "\" > "
-                         . $field_display_item
-                         . " ");
-                 if ($position =="V"){
-                         printf("<BR>\n");
-                 }
-         };
  }
  /**********************************************************
- Function: recordCount($con, $table, $limit_field,
+ Function: msgTableOpen ($colspan, $header)
+ Author: Paul Bramscher
+ Last Modified: 03.15.2004
+ ***********************************************************
+ Incoming:
+ $colspan                        Columns to span the first
+                                 row.
+ $header                         Message to appear in the
+                                 first table header row.
+ ***********************************************************
+ Outgoing:
+ None
+ ***********************************************************
+ Purpose:
+ Starts the drawing of a message box table.
+ **********************************************************/
+ function msgTableOpen ($colspan, $header) {
+         // Table
+         printf("<center>\n");
+         printf("<table width=\"50%%\" class=\"backLight\" border=\"1\" cellpadding=\"4\">\n");
+         // Row header
+         printf("<tr><td class=\"cellPlain\" colspan=\"%d\" >\n", $colspan);
+         printf("%s", $header);
+         printf("</td></tr>\n");
+         // Initial cell
+         printf("<tr><td>\n");
+ }
+ /**********************************************************
+ Function: recordCount($table, $limit_field,
          $limit_where, $type)
  Author: Paul Bramscher
- Last Modified: 01.15.2004
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $table                  Table in database to query
  $limit_field            Field to limit
  $limit_where            Criteria upon which to limit
-Line 2427 
 printf statement elsewhere "This operati
+Line 2268 
 printf statement elsewhere "This operati
  N record(s).  Do you wish to proceed?"  This function
  returns a value for N.
  **********************************************************/
- function recordCount($con, $table, $limit_field,
+ function recordCount($table, $limit_field,
          $limit_where, $type) {
          // Guard against single quotes
-Line 2454 
 function recordCount($con, $table, $limi
+Line 2295 
 function recordCount($con, $table, $limi
          }
          // Open the query and take a row count
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          $count = mysql_num_rows($rs);
          return $count;
-Line 2462 
 function recordCount($con, $table, $limi
+Line 2303 
 function recordCount($con, $table, $limi
  /**********************************************************
- Function: selectCoursesub($con, $limit)
+ Function: selectCoursesub($limit)
  Author: Paul Bramscher
- Last Modified: 07.02.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $limit                  String to limit the results by
  ***********************************************************
  Outgoing:
-Line 2477 
 Purpose:
+Line 2317 
 Purpose:
  Draws a table with all course subjects for basic
  command add/edit/ delete selection.
  **********************************************************/
- function selectCoursesub($con, $limit){
+ function selectCoursesub($limit){
-         printf("<table width=\"90%%\" border = \"1\" cellpadding = \"2\" >");
+         printf("<table width=\"90%%\" border = \"1\" cellpadding = \"2\" >\n");
-         printf("<tr>");
+         printf("<tr>\n");
-         printf("<td class = \"cellPlain\">ID</td>");
+         printf("<td class = \"cellPlain\">ID</td>\n");
-         printf("<td class = \"cellPlain\">Subject</td>");
+         printf("<td class = \"cellPlain\">Subject</td>\n");
-         printf("<td class = \"cellPlain\">Subject Description</td>");
+         printf("<td class = \"cellPlain\">Subject Description</td>\n");
-         printf("<td class = \"cellPlain\">Campus</td>");
+         printf("<td class = \"cellPlain\">Campus</td>\n");
-         printf("<td class = \"cellPlain\">CIP Code</td>");
+         printf("<td class = \"cellPlain\">CIP Code</td>\n");
-         printf("<td class = \"cellPlain\">Select</td>");
+         printf("<td class = \"cellPlain\">Select</td>\n");
          printf("</tr>");
          // Build the sql
-Line 2516 
 function selectCoursesub($con, $limit){
+Line 2356 
 function selectCoursesub($con, $limit){
          // Order the display
          $sql .= " ORDER BY coursesub_descr";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          // Initialize row counter
          $rowcount = 0;
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $coursesub_id = $row["coursesub_id"];
                  $coursesub = Trim($row["coursesub"]);
                  $coursesub_descr = Trim($row["coursesub_descr"]);
-Line 2534 
 function selectCoursesub($con, $limit){
+Line 2374 
 function selectCoursesub($con, $limit){
                  printf("<tr>");
-                 printf("<td %s>%d</td>", $color, $coursesub_id);
+                 printf("<td %s>%d</td>\n", $color, $coursesub_id);
-                 printf("<td %s>%s</td>", $color, $coursesub);
+                 printf("<td %s>%s</td>\n", $color, $coursesub);
-                 printf("<td %s>%s</td>", $color, $coursesub_descr);
+                 printf("<td %s>%s</td>\n", $color, $coursesub_descr);
-                 printf("<td %s>%s</td>", $color, $campus);
+                 printf("<td %s>%s</td>\n", $color, $campus);
-                 printf("<td %s>%s</td>", $color, $cip_code);
+                 printf("<td %s>%s</td>\n", $color, $cip_code);
-                 printf("<td %s>&nbsp;<input type = \"Radio\" name = \"coursesub_id\" value =\"%d\" >&nbsp;", $color, $coursesub_id);
+                 printf("<td %s>&nbsp;<input type = \"Radio\" name = \"coursesub_id\" value =\"%d\" >&nbsp;</td>\n", $color, $coursesub_id);
-                 printf("</tr>");
+                 printf("</tr>\n");
                  $rowcount++;
          };
-         printf("</table>");
+         printf("</table>\n");
  }
  /**********************************************************
- Function: selectFaculty($con)
+ Function: selectFaculty()
  Author: Paul Bramscher
- Last Modified: 07.02.2002
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
+ None
  ***********************************************************
  Outgoing:
  None
-Line 2565 
 Purpose:
+Line 2405 
 Purpose:
  Draws a table with all faculty for basic command add/edit/
  delete selection.
  **********************************************************/
- function selectFaculty($con){
+ function selectFaculty(){
-         printf("<table width=\"90%%\" border = \"1\" cellpadding = \"2\" >");
+         printf("<table width=\"90%%\" border = \"1\" cellpadding = \"2\" >\n");
-         printf("<tr>");
+         printf("<tr>\n");
-         printf("<td class = \"cellPlain\">ID</td>");
+         printf("<td class = \"cellPlain\">ID</td>\n");
-         printf("<td class = \"cellPlain\">Faculty name</td>");
+         printf("<td class = \"cellPlain\">Faculty name</td>\n");
-         printf("<td class = \"cellPlain\">Account</td>");
+         printf("<td class = \"cellPlain\">Account</td>\n");
-         printf("<td class = \"cellPlain\">Email</td>");
+         printf("<td class = \"cellPlain\">Email</td>\n");
-         printf("<td class = \"cellPlain\">Select</td>");
+         printf("<td class = \"cellPlain\">Select</td>\n");
          printf("</tr>");
          // Build the sql
-Line 2590 
 function selectFaculty($con){
+Line 2430 
 function selectFaculty($con){
          // Order the display
          $sql .= " ORDER BY faculty_lastname, faculty_firstname";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          // Row counter
          $rowcount = 0;
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $faculty_id = $row["faculty_id"];
                  $faculty_firstname = Trim($row["faculty_firstname"]);
                  $faculty_lastname = Trim($row["faculty_lastname"]);
-Line 2612 
 function selectFaculty($con){
+Line 2452 
 function selectFaculty($con){
                  printf("<tr>");
-                 printf("<td %s>%d</td>", $color, $faculty_id);
+                 printf("<td %s>%d</td>\n", $color, $faculty_id);
-                 printf("<td %s>%s, %s</td>", $color, $faculty_lastname, $faculty_firstname);
+                 printf("<td %s>%s, %s</td>\n", $color, $faculty_lastname, $faculty_firstname);
-                 printf("<td %s>%s</td>", $color, $faculty_account);
+                 printf("<td %s>%s</td>\n", $color, $faculty_account);
-                 printf("<td %s>%s</td>", $color, $faculty_email);
+                 printf("<td %s>%s</td>\n", $color, $faculty_email);
-                 printf("<td %s>&nbsp;<input type = \"Radio\" name = \"faculty_id\" value =\"%d\" >&nbsp;", $color, $faculty_id);
+                 printf("<td %s>&nbsp;<input type = \"Radio\" name = \"faculty_id\" value =\"%d\" >&nbsp;</td>\n", $color, $faculty_id);
-                 printf("</tr>");
+                 printf("</tr>\n");
                  $rowcount++;
          };
-         printf("</table>");
+         printf("</table>\n");
  }
  /**********************************************************
- Function: selectKey($con, $display, $display_field,
+ Function: selectKey($display, $display_field,
  $key_field, $limit, $table)
  Author: Paul Bramscher
- Last Modified: 06.25.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $display                A form header to display to user
  $display_field          Meaningful field in the table to display
  $key_field              The table primary key (no composites)
-Line 2657 
 Note that the pick-list filters out the
+Line 2496 
 Note that the pick-list filters out the
  (N/A) rows which are present in many tables as system
  placeholders.
  **********************************************************/
- function selectKey($con, $display, $display_field,
+ function selectKey($display, $display_field,
          $key_field, $limit, $table){
          $sql = "SELECT "
-Line 2688 
 function selectKey($con, $display, $disp
+Line 2527 
 function selectKey($con, $display, $disp
                  // Order the display
                  $sql .= " ORDER BY " . $display_field;
-                 $rs = mysql_query($sql, $con);
+                 $rs = mysql_tryquery($sql);
                  printf("<table width=\"60%%\" border = \"1\" >\n");
                  printf("<tr><td class=\"cellPlain\">Description</td>\n");
-                 // printf("<td><b>Key</b></td>");
                  printf("<td class=\"cellPlain\">Select</td></tr>\n");
                  $rowcount = 0;
-                 while ($row = mysql_fetch_array ($rs)) {
+                 while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                          $field_display_item = $row[$display_field];
                          $field_value_item = (int) Trim($row[$key_field]);
-Line 2711 
 function selectKey($con, $display, $disp
+Line 2549 
 function selectKey($con, $display, $disp
                          printf("<td %s><input type =\"Radio\" name =\"key_id\" value =\"%s\"></td>\n",
                                  $color, $field_value_item);
                          printf("</tr>\n");
-                         /*
-                         printf("<tr><td>"
-                                 . $field_display_item
-                                 . "</td><td>"
-                                 . "<input type = \"Radio\" name = \"key_id\" value =\""
-                                 . $field_value_item
-                                 . "\"></td></tr>\n");
-                         */
                          $rowcount++;
                  };
-Line 2732 
 function selectKey($con, $display, $disp
+Line 2561 
 function selectKey($con, $display, $disp
  /**********************************************************
- Function: selectStaff($con)
+ Function: selectStaff()
  Author: Paul Bramscher
- Last Modified: 04.28.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
+ None
  ***********************************************************
  Outgoing:
  None
-Line 2746 
 Purpose:
+Line 2575 
 Purpose:
  Draws a table with all staff for basic command add/edit/
  delete selection.
  **********************************************************/
- function selectStaff($con){
+ function selectStaff(){
-         printf("<table width=\"90%%\" border = \"1\" cellpadding = \"2\" >");
+         printf("<table width=\"90%%\" border = \"1\" cellpadding = \"2\" >\n");
-         printf("<tr>");
+         printf("<tr>\n");
-         printf("<td class = \"cellPlain\">ID</td>");
+         printf("<td class = \"cellPlain\">ID</td>\n");
-         printf("<td class = \"cellPlain\">Staff name</td>");
+         printf("<td class = \"cellPlain\">Staff name</td>\n");
-         printf("<td class = \"cellPlain\">Staff Account</td>");
+         printf("<td class = \"cellPlain\">Staff Account</td>\n");
-         printf("<td class = \"cellPlain\">Local pwd?</td>");
+         printf("<td class = \"cellPlain\">Local pwd?</td>\n");
-         printf("<td class = \"cellPlain\">Access</td>");
+         printf("<td class = \"cellPlain\">Access</td>\n");
-         printf("<td class = \"cellPlain\">Level</td>");
+         printf("<td class = \"cellPlain\">Level</td>\n");
-         printf("<td class = \"cellPlain\">Last login</td>");
+         printf("<td class = \"cellPlain\">Last login</td>\n");
-         printf("<td class = \"cellPlain\">Last ip</td>");
+         printf("<td class = \"cellPlain\">Last ip</td>\n");
-         printf("<td class = \"cellPlain\">Select</td>");
+         printf("<td class = \"cellPlain\">Select</td>\n");
          printf("</tr>");
          // Build the sql
-Line 2779 
 function selectStaff($con){
+Line 2608 
 function selectStaff($con){
          // Order the display
          $sql .= " ORDER BY last_name, first_name";
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
          $rowcount = 0;
-         while ($row = mysql_fetch_array ($rs)) {
+         while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
                  $first_name = Trim($row["first_name"]);
                  $last_name = Trim($row["last_name"]);
                  $staff_account = $row["staff_account"];
-Line 2807 
 function selectStaff($con){
+Line 2636 
 function selectStaff($con){
                  printf("<tr>");
-                 printf("<td %s>%d</td>", $color, $staff_id);
+                 printf("<td %s>%d</td>\n", $color, $staff_id);
-                 printf("<td %s>%s, %s</td>", $color, $last_name, $first_name);
+                 printf("<td %s>%s, %s</td>\n", $color, $last_name, $first_name);
-                 printf("<td %s>%s</td>", $color, $staff_account);
+                 printf("<td %s>%s</td>\n", $color, $staff_account);
-                 printf("<td %s>%s</td>", $color, $local_pwd);
+                 printf("<td %s>%s</td>\n", $color, $local_pwd);
-                 printf("<td %s>%s</td>", $color, $access);
+                 printf("<td %s>%s</td>\n", $color, $access);
-                 printf("<td %s>%d</td>", $color, $access_level);
+                 printf("<td %s>%d</td>\n", $color, $access_level);
-                 printf("<td %s>%s</td>", $color, $last_login);
+                 printf("<td %s>%s</td>\n", $color, $last_login);
-                 printf("<td %s>%s</td>", $color, $last_ip);
+                 printf("<td %s>%s</td>\n", $color, $last_ip);
                  printf("<td %s>&nbsp;<input type = \"Radio\" name = \"staff_id\"
-                         value =\"%d\" >&nbsp;", $color, $staff_id);
+                         value =\"%d\" >&nbsp;</td>\n", $color, $staff_id);
-                 printf("</tr>");
+                 printf("</tr>\n");
                  $rowcount++;
          };
-         printf("</table>");
+         printf("</table>\n");
  }
  /**********************************************************
- Function: statQuery($con, $sql)
+ Function: statQuery($sql)
  Author: Paul Bramscher
- Last Modified: 06.24.2003
+ Last Modified: 03.02.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
  $sql                    A SQL statement to execute.  The
                          SELECT must have a COUNT(*) in it.
                          The stat logic should be in WHERE.
-Line 2849 
 column is $label explaining the purpose
+Line 2677 
 column is $label explaining the purpose
  the second column is the numerical figure of the $sql.
  **********************************************************/
- function statQuery($con, $sql){
+ function statQuery($sql){
-         $rs = mysql_query($sql, $con);
+         $rs = mysql_tryquery($sql);
-         $row = mysql_fetch_array ($rs);
+         $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
          // We should be getting only a single row.
          if (mysql_num_rows($rs) == 1) $result = $row["COUNT(*)"];
-Line 2925 
 function textSearchmySQL($incoming) {
+Line 2753 
 function textSearchmySQL($incoming) {
          return $outgoing;
  }
  ?>

 Legend:



Removed from v.66
 


changed lines


 
Added in v.67
 Legend:



Removed from v.66
 


changed lines


 
Added in v.67
-Removed from v.66
+Added in v.67

	ViewVC Help
Powered by ViewVC 1.1.26