/[libdata]/trunk/admin/include/forms.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 /trunk/admin/include/forms.php

Parent Directory | Revision Log | View Patch Patch

-revision 71 by dpavlin,
Thu Mar  4 22:43:50 2004 UTC
+revision 72 by dpavlin,
Thu Mar 18 20:33:37 2004 UTC
 Line 1
  <?php
  /**********************************************************
  Function Library: forms.php
- Original Author: Paul Bramscher <brams006@tc.umn.edu>
+ Original Author: Paul Bramscher <brams006@umn.edu>
- Last Modified: 11.06.2003 by Paul Bramscher
+ Last Modified: 03.16.2004 by Paul Bramscher
  ***********************************************************
  Comments:
  Functions here include most data-entry forms.  Note that
 Line 35 
 formAssignSubMaster
  formAssignSubOtherSub
  formAssignSubPage
  formAssignSubStaff
- formEditSingleField
  formCoursesub
+ formEditSingleField
  formFaculty
  formFeature
  formInfotype
 Line 49 
 formService
  formStaff
  formStyle
  formSubject
+ formVendor
  **********************************************************/
  /**********************************************************
+ Function: formAssignLibunitStaff
+ Author: Paul Bramscher
+ Last Modified: 03.10.2004
+ ***********************************************************
+ Purpose:
+ Assigns staff (possibly multiple) to a given library unit.
+ **********************************************************/
+ function formAssignLibunitStaff($libunit_id){
+         // Table definition
+         printf("<br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
+         // Form
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
+         printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >\n", $libunit_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignLibunitStaff\" >\n");
+         // Available staff
+         // Omit the '(N/A)' staff
+         $omit_string = "WHERE staff_id > 1";
+         // Omit any pre-selected staff in libunit_staff
+         $in_string = getNotIn("staff_id", "libunit_id", $libunit_id, "libunit_staff");
+         if (strlen($in_string) > 0) $omit_string .= " AND staff_id NOT IN " . $in_string;
+         // Draw the box
+         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+         printf("Assign Staff to Library Unit");
+         printf("</td></tr>\n");
+         printf("<tr><td valign = \"top\" >\n");
+         printf("<br><b>Available Staff:<br></b>\n");
+         printf("<select name = \"staff_id_array[]\" multiple size = \"5\" >\n");
+         dropDownStaffOmit($omit_string);
+         printf("</select><br><br>\n");
+         // Close off form
+         printf("<center>\n");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
+         printf("</form>\n");
+         printf("</center>\n");
+         printf("</td>\n");
+         // Current staff
+         printf("<td valign = \"top\" >\n");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
+         printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >\n", $libunit_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteLibunitStaff\" >\n");
+         printf("<br><b>Selected Staff:</b><br>\n");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
+         $sql = "SELECT s.staff_id, s.last_name, s.first_name FROM
+                 staff s,
+                 libunit_staff ls
+                 WHERE
+                 ls.libunit_id = " . $libunit_id . " AND
+                 s.staff_id = ls.staff_id
+                 ORDER BY last_name, first_name";
+         $rs = xx_tryquery($sql);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
+                 $first_name = $row["first_name"];
+                 $last_name = $row["last_name"];
+                 $staff_id = $row["staff_id"];
+                 printf("<option value = \"%d\">%s, %s</option>\n", $staff_id, $last_name, $first_name);
+         }
+         printf("</select><br><br>\n");
+         printf("<center>\n");
+         printf("<input type = \"Submit\" value =\" << \">\n");
+         printf("</center>\n");
+         printf("</form>\n");
+         printf("</td></tr>\n");
+         // Close off table
+         printf("</td></tr></table>\n");
+ }
+ /**********************************************************
  Function: formAssignResFeature
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign features to the supplied resource id.
  **********************************************************/
- function formAssignResFeature($con, $resource_id){
+ function formAssignResFeature($resource_id){
          // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
+         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
          // Form of available features to select
-         printf("<form method = \"POST\" action = \"assign.phtml#ResFea\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml#ResFea\" >\n");
-         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
+         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >\n", $resource_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResFeature\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResFeature\" >\n");
          // Omit the '(N/A)' feature
          $omit_string = "WHERE feature_id > 1";
          // Omit any pre-selected features in res_feature
-         $in_string = getNotIn($con, "feature_id", "resource_id", $resource_id, "res_feature");
+         $in_string = getNotIn("feature_id", "resource_id", $resource_id, "res_feature");
          if (strlen($in_string) > 0) $omit_string .= " AND feature_id NOT IN " . $in_string;
          // Draw the combo box
-Line 83 
 function formAssignResFeature($con, $res
+Line 164 
 function formAssignResFeature($con, $res
          printf("Assign Features");
          printf("</td></tr>\n");
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Features(s):<br></strong>\n");
+         printf("<br><b>Available Features(s):<br></b>\n");
-         printf("<select name = \"feature_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"feature_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "feature", "feature", "feature_id", $omit_string);
+         dropDownFieldOmit("feature", "feature", "feature_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Form of current features to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
+         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >\n", $resource_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResFeature\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResFeature\" >\n");
-         printf("<br><strong>Selected feature(s):</strong><br>\n");
+         printf("<br><b>Selected feature(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT f.feature, f.feature_id FROM
                  feature f,
-Line 111 
 function formAssignResFeature($con, $res
+Line 192 
 function formAssignResFeature($con, $res
                  r.resource_id = " . $resource_id . " AND
                  rf.resource_id = r.resource_id AND
                  rf.feature_id = f.feature_id ORDER BY feature";
+         $rs = xx_tryquery($sql);
-         // Fetch the current selections
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $feature = $row["feature"];
                  $feature_id = $row["feature_id"];
-                 printf("<option value = \"%s\">%s</option>", $feature_id, $feature);
+                 printf("<option value = \"%s\">%s</option>\n", $feature_id, $feature);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignResLoc
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign locations to the supplied resource id.
  **********************************************************/
- function formAssignResLoc($con, $resource_id){
+ function formAssignResLoc($resource_id){
          // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
+         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
          // Form of available locations to select
-         printf("<form method = \"POST\" action = \"assign.phtml#ResLoc\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml#ResLoc\" >\n");
-         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
+         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >\n", $resource_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResLoc\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResLoc\" >\n");
          // Omit the '(N/A)' location
          $omit_string = "WHERE location_id > 1";
          // Omit any pre-selected locations in res_loc
-         $in_string = getNotIn($con, "location_id", "resource_id", $resource_id, "res_loc");
+         $in_string = getNotIn("location_id", "resource_id", $resource_id, "res_loc");
          if (strlen($in_string) > 0) $omit_string .= " AND location_id NOT IN " . $in_string;
          // Draw the combo box
-Line 164 
 function formAssignResLoc($con, $resourc
+Line 244 
 function formAssignResLoc($con, $resourc
          printf("Assign Locations");
          printf("</td></tr>\n");
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Location(s):<br></strong>\n");
+         printf("<br><b>Available Location(s):<br></b>\n");
-         printf("<select name = \"location_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"location_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "location", "location", "location_id", $omit_string);
+         dropDownFieldOmit("location", "location", "location_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current locations to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
+         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >\n", $resource_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResLoc\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResLoc\" >\n");
-         printf("<br><strong>Selected Location(s):</strong><br>\n");
+         printf("<br><b>Selected Location(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT l.location, l.location_id FROM
                  location l,
-Line 192 
 function formAssignResLoc($con, $resourc
+Line 272 
 function formAssignResLoc($con, $resourc
                  r.resource_id = " . $resource_id . " AND
                  rl.resource_id = r.resource_id AND
                  rl.location_id = l.location_id ORDER BY location";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $location = $row["location"];
                  $location_id = $row["location_id"];
-                 printf("<option value = \"%s\">%s</option>", $location_id, $location);
+                 printf("<option value = \"%s\">%s</option>\n", $location_id, $location);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignResMastersubject
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign master subjects to the supplied resource id.
  **********************************************************/
- function formAssignResMastersubject($con, $resource_id){
+ function formAssignResMastersubject($resource_id){
          // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
+         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
          // Form of available master subjects to select
-         printf("<form method = \"POST\" action = \"assign.phtml#ResMaster\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml#ResMaster\" >\n");
-         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
+         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >\n", $resource_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResMastersubject\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResMastersubject\" >\n");
          // Omit the '(N/A)' mastersubjects
          $omit_string = "WHERE mastersubject_id > 2";
          // Omit any pre-selected locations in res_mastersubject
-         $in_string = getNotIn($con, "mastersubject_id", "resource_id", $resource_id, "res_mastersubject");
+         $in_string = getNotIn("mastersubject_id", "resource_id", $resource_id, "res_mastersubject");
          if (strlen($in_string) > 0) $omit_string .= " AND mastersubject_id NOT IN " . $in_string;
          // Draw the combo box
-Line 245 
 function formAssignResMastersubject($con
+Line 324 
 function formAssignResMastersubject($con
          printf("Assign Master Subjects");
          printf("</td></tr>\n");
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Mastersubjects(s):<br></strong>\n");
+         printf("<br><b>Available Mastersubjects(s):<br></b>\n");
-         printf("<select name = \"mastersubject_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"mastersubject_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "mastersubject", "mastersubject", "mastersubject_id", $omit_string);
+         dropDownFieldOmit("mastersubject", "mastersubject", "mastersubject_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
          printf("<input type = \"Submit\" value = \" >> \" >");
          printf("</center>");
          printf("</form>");
-Line 259 
 function formAssignResMastersubject($con
+Line 338 
 function formAssignResMastersubject($con
          // Current master subjects to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
+         printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >\n", $resource_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResMastersubject\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResMastersubject\" >\n");
-         printf("<br><strong>Selected Mastersubjects(s):</strong><br>\n");
+         printf("<br><b>Selected Mastersubjects(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT m.mastersubject, m.mastersubject_id FROM
                  mastersubject m,
-Line 273 
 function formAssignResMastersubject($con
+Line 352 
 function formAssignResMastersubject($con
                  r.resource_id = " . $resource_id . " AND
                  rm.resource_id = r.resource_id AND
                  rm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $mastersubject = $row["mastersubject"];
                  $mastersubject_id = $row["mastersubject_id"];
-                 printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject);
+                 printf("<option value = \"%s\">%s</option>\n", $mastersubject_id, $mastersubject);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignServLoc
  Author: Paul Bramscher
- Last Modified: 07.02.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign locations to the supplied service id.
  **********************************************************/
- function formAssignServLoc($con, $service_id){
+ function formAssignServLoc($service_id){
          // Table definition
-         printf("<br><br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">");
+         printf("<br><br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
          // Form of available locations to select
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
+         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >\n", $service_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignServLoc\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignServLoc\" >\n");
          // Box header
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-Line 323 
 function formAssignServLoc($con, $servic
+Line 401 
 function formAssignServLoc($con, $servic
          $omit_string = "WHERE location_id > 1";
          // Omit any pre-selected locations in service_location
-         $in_string = getNotIn($con, "location_id", "service_id", $service_id, "serv_loc");
+         $in_string = getNotIn("location_id", "service_id", $service_id, "serv_loc");
          if (strlen($in_string) > 0) $omit_string .= " AND location_id NOT IN " . $in_string;
          // Draw the combo box
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Location(s):<br></strong>\n");
+         printf("<br><b>Available Location(s):<br></b>\n");
-         printf("<select name = \"location_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"location_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "location", "location", "location_id", $omit_string);
+         dropDownFieldOmit("location", "location", "location_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current locations to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
+         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >\n", $service_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteServLoc\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteServLoc\" >\n");
-         printf("<br><strong>Selected Location(s):</strong><br>\n");
+         printf("<br><b>Selected Location(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT l.location, l.location_id FROM
                  location l,
-Line 356 
 function formAssignServLoc($con, $servic
+Line 434 
 function formAssignServLoc($con, $servic
                  s.service_id = " . $service_id . " AND
                  sl.service_id = s.service_id AND
                  sl.location_id = l.location_id ORDER BY location";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         $rs = xx_query($sql, $con);
-         while ($row = xx_fetch_array ($rs)) {
                  $location = $row["location"];
                  $location_id = $row["location_id"];
-                 printf("<option value = \"%s\">%s</option>", $location_id, $location);
+                 printf("<option value = \"%s\">%s</option>\n", $location_id, $location);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignServServtype
  Author: Paul Bramscher
- Last Modified: 07.02.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign service types to the supplied service id.
  **********************************************************/
- function formAssignServServtype($con, $service_id){
+ function formAssignServServtype($service_id){
          // Table definition
-         printf("<br><br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">");
+         printf("<br><br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
          // Form of available service types to select
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
+         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >\n", $service_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignServServtype\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignServServtype\" >\n");
          // Box header
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-Line 406 
 function formAssignServServtype($con, $s
+Line 483 
 function formAssignServServtype($con, $s
          $omit_string = "WHERE servicetype_id > 1";
          // Omit any pre-selected servive types in serv_servtype
-         $in_string = getNotIn($con, "servicetype_id", "service_id", $service_id, "serv_servtype");
+         $in_string = getNotIn("servicetype_id", "service_id", $service_id, "serv_servtype");
          if (strlen($in_string) > 0) $omit_string .= " AND servicetype_id NOT IN " . $in_string;
          // Draw the combo box
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Service Types(s):<br></strong>\n");
+         printf("<br><b>Available Service Types(s):<br></b>\n");
-         printf("<select name = \"servicetype_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"servicetype_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "servicetype", "servicetype", "servicetype_id", $omit_string);
+         dropDownFieldOmit("servicetype", "servicetype", "servicetype_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current servicetypes to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
+         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >\n", $service_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteServServtype\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteServServtype\" >\n");
-         printf("<br><strong>Selected Service Types(s):</strong><br>\n");
+         printf("<br><b>Selected Service Types(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT t.servicetype, t.servicetype_id FROM
                  servicetype t,
-Line 439 
 function formAssignServServtype($con, $s
+Line 516 
 function formAssignServServtype($con, $s
                  s.service_id = " . $service_id . " AND
                  st.service_id = s.service_id AND
                  st.servicetype_id = t.servicetype_id ORDER BY servicetype";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         $rs = xx_query($sql, $con);
-         while ($row = xx_fetch_array ($rs)) {
                  $servicetype = $row["servicetype"];
                  $servicetype_id = $row["servicetype_id"];
-                 printf("<option value = \"%s\">%s</option>", $servicetype_id, $servicetype);
+                 printf("<option value = \"%s\">%s</option>\n", $servicetype_id, $servicetype);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
+ }
+ /**********************************************************
+ Function: formAssignStaffLibunit
+ Author: Paul Bramscher
+ Last Modified: 03.10.2004
+ ***********************************************************
+ Purpose:
+ Assigns library units (possibly multiple) to a given
+ staffperson.
+ **********************************************************/
+ function formAssignStaffLibunit($staff_id){
+         // Table definition
+         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
+         // Form
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
+         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignStaffLibunit\" >\n");
+         // Available libunits
+         // Omit the '(N/A)' libunit
+         $omit_string = "WHERE libunit_id > 1";
+         // Omit any pre-selected libunits in libunit_staff
+         $in_string = getNotIn("libunit_id", "staff_id", $staff_id, "libunit_staff");
+         if (strlen($in_string) > 0) $omit_string .= " AND libunit_id NOT IN " . $in_string;
+         // Draw the box
+         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+         printf("Assign Library Unit to Staff");
+         printf("</td></tr>\n");
+         printf("<tr><td valign = \"top\" >\n");
+         printf("<br><b>Available Library Unit(s):<br></b>\n");
+         printf("<select name = \"libunit_id_array[]\" multiple size = \"5\" >\n");
+         dropDownFieldOmit("libunit", "libunit", "libunit_id", $omit_string);
+         printf("</select><br><br>\n");
+         // Close off form
+         printf("<center>\n");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
+         printf("</form>\n");
+         printf("</center>\n");
+         printf("</td>\n");
+         // Current libunits
+         printf("<td valign = \"top\" >\n");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
+         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteStaffLibunit\" >\n");
+         printf("<br><b>Selected Library Unit(s):</b><br>\n");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
+         $sql = "SELECT l.libunit, l.libunit_id FROM
+                 staff s,
+                 libunit_staff ls,
+                 libunit l
+                 WHERE
+                 s.staff_id = " . $staff_id . " AND
+                 ls.staff_id = s.staff_id AND
+                 ls.libunit_id = l.libunit_id
+                 ORDER BY l.libunit";
+         $rs = xx_tryquery($sql);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
+                 $libunit = $row["libunit"];
+                 $libunit_id = $row["libunit_id"];
+                 printf("<option value = \"%s\">%s</option>\n", $libunit_id, $libunit);
+         }
+         printf("</select><br><br>\n");
+         printf("<center>\n");
+         printf("<input type = \"Submit\" value =\" << \">\n");
+         printf("</center>\n");
+         printf("</form>\n");
+         printf("</td></tr>\n");
+         // Close off table
+         printf("</td></tr></table>\n");
+ }
+ /**********************************************************
+ Function: formAssignStaffSub
+ Author: Paul Bramscher
+ Last Modified: 03.10.2004
+ ***********************************************************
+ Purpose:
+ Assigns subjects (possibly multiple) to a given
+ staffperson.
+ **********************************************************/
+ function formAssignStaffSub($staff_id){
+         // Table definition
+         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
+         // Form
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
+         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignStaffSub\" >\n");
+         // Available subjects
+         // Omit the '(N/A)' subject
+         $omit_string = "WHERE subject_id > 1";
+         // Omit any pre-selected subjects in sub_staff
+         $in_string = getNotIn("subject_id", "staff_id", $staff_id, "sub_staff");
+         if (strlen($in_string) > 0) $omit_string .= " AND subject_id NOT IN " . $in_string;
+         // Draw the box
+         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+         printf("Assign Subjects");
+         printf("</td></tr>\n");
+         printf("<tr><td valign = \"top\" >\n");
+         printf("<br><b>Available Subject(s):<br></b>\n");
+         printf("<select name = \"subject_id_array[]\" multiple size = \"5\" >\n");
+         dropDownFieldOmit("subject", "subject", "subject_id", $omit_string);
+         printf("</select><br><br>\n");
+         // Close off form
+         printf("<center>\n");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
+         printf("</form>\n");
+         printf("</center>\n");
+         printf("</td>\n");
+         // Current subjects
+         printf("<td valign = \"top\" >\n");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
+         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteStaffSub\" >\n");
+         printf("<br><b>Selected Subject(s):</b><br>\n");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
+         $sql = "SELECT s.subject, s.subject_id FROM
+                 staff t,
+                 sub_staff st,
+                 subject s
+                 WHERE
+                 t.staff_id = " . $staff_id . " AND
+                 st.staff_id = t.staff_id AND
+                 st.subject_id = s.subject_id
+                 ORDER BY s.subject";
+         $rs = xx_tryquery($sql);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
+                 $subject = $row["subject"];
+                 $subject_id = $row["subject_id"];
+                 printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject);
+         }
+         printf("</select><br><br>\n");
+         printf("<center>\n");
+         printf("<input type = \"Submit\" value =\" << \">\n");
+         printf("</center>\n");
+         printf("</form>\n");
+         printf("</td></tr>\n");
+         // Close off table
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignSubCoursesub
  Author: Paul Bramscher
- Last Modified: 06.26.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign course subjects (with cip codes) to the supplied
  subject id.
  **********************************************************/
- function formAssignSubCoursesub($con, $subject_id){
+ function formAssignSubCoursesub($subject_id){
          // Table definition
          printf("<br><br>\n");
-         printf("<table width=\"90%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\" >");
+         printf("<table width=\"90%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\" >\n");
          // Form of available course subjects to select
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
          printf("Map to Course Subjects / CIP Codes");
          printf("</td></tr>\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubCoursesub\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubCoursesub\" >\n");
          // Omit the '(N/A)' course subject
          $omit_string = "WHERE coursesub_id > 1";
          // Omit any pre-selected locations in sub_coursesub
-         $in_string = getNotIn($con, "coursesub_id", "subject_id", $subject_id, "sub_coursesub");
+         $in_string = getNotIn("coursesub_id", "subject_id", $subject_id, "sub_coursesub");
          if (strlen($in_string) > 0) $omit_string .= " AND coursesub_id NOT IN " . $in_string;
          // Draw the combo box
          printf("<tr><td valign = \"top\" >\n");
          printf("<br><b>Available Course Subjects(s):<br></b>\n");
-         printf("<select name = \"coursesub_id_array[]\" multiple size = \"20\" >");
+         printf("<select name = \"coursesub_id_array[]\" multiple size = \"20\" >\n");
-         dropDownCoursesubOmit($con, $omit_string);
+         dropDownCoursesubOmit($omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current coursesubs to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubCoursesub\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubCoursesub\" >\n");
          printf("<br><b>Selected Course Subject(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = \"20\">");
+         printf("<select name =\"key_list_array[]\" multiple size = \"20\">\n");
          $sql = "SELECT c.coursesub, c.coursesub_descr, c.coursesub_id, c.cip_code FROM
                  coursesub c,
-Line 523 
 function formAssignSubCoursesub($con, $s
+Line 763 
 function formAssignSubCoursesub($con, $s
                  s.subject_id = " . $subject_id . " AND
                  sc.subject_id = s.subject_id AND
                  sc.coursesub_id = c.coursesub_id ORDER BY coursesub_descr";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $coursesub = $row["coursesub"];
                  $coursesub_id = $row["coursesub_id"];
                  $coursesub_descr = $row["coursesub_descr"];
-Line 535 
 function formAssignSubCoursesub($con, $s
+Line 774 
 function formAssignSubCoursesub($con, $s
                  // Limit length
                  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>\n", $coursesub_id, $coursesub, $coursesub_descr, $cip_code);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignSubLoc
  Author: Paul Bramscher
- Last Modified: 06.26.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign locations to the supplied subject id.
  **********************************************************/
- function formAssignSubLoc($con, $subject_id){
+ function formAssignSubLoc($subject_id){
          // Table definition
          printf("<br><br>\n");
-         printf("<table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">");
+         printf("<table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
          // Form of available locations to select
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
          printf("Assign Secondary Locations");
          printf("</td></tr>\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubLoc\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubLoc\" >\n");
          // Omit the '(N/A)' location
          $omit_string = "WHERE location_id > 1";
          // Omit any pre-selected locations in sub_loc
-         $in_string = getNotIn($con, "location_id", "subject_id", $subject_id, "sub_loc");
+         $in_string = getNotIn("location_id", "subject_id", $subject_id, "sub_loc");
          if (strlen($in_string) > 0) $omit_string .= " AND location_id NOT IN " . $in_string;
          // Draw the combo box
          printf("<tr><td valign = \"top\" >\n");
          printf("<br><b>Available Location(s):<br></b>\n");
          printf("<select name = \"location_id_array[]\" multiple size = \"5\" >");
-         dropDownFieldOmit($con, "location", "location", "location_id", $omit_string);
+         dropDownFieldOmit("location", "location", "location_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current locations to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubLoc\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubLoc\" >\n");
          printf("<br><b>Selected Location(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT l.location, l.location_id FROM
                  location l,
-Line 612 
 function formAssignSubLoc($con, $subject
+Line 851 
 function formAssignSubLoc($con, $subject
                  s.subject_id = " . $subject_id . " AND
                  sl.subject_id = s.subject_id AND
                  sl.location_id = l.location_id ORDER BY location";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $location = $row["location"];
                  $location_id = $row["location_id"];
-                 printf("<option value = \"%s\">%s</option>", $location_id, $location);
+                 printf("<option value = \"%s\">%s</option>\n", $location_id, $location);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignSubMaster
  Author: Paul Bramscher
- Last Modified: 06.26.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign master subjects to the supplied subject id.
  **********************************************************/
- function formAssignSubMaster($con, $subject_id){
+ function formAssignSubMaster($subject_id){
          // Table definition
          printf("<br><br>\n");
-         printf("<table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
+         printf("<table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
          // Form of available master subjects to select
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
          printf("Assign Master Subjects");
          printf("</td></tr>\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubMaster\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubMaster\" >\n");
          // Omit the '(N/A)' location
          $omit_string = "WHERE mastersubject_id > 1";
          // Omit any pre-selected locations in sub_mastersubject
-         $in_string = getNotIn($con, "mastersubject_id", "subject_id", $subject_id, "sub_mastersubject");
+         $in_string = getNotIn("mastersubject_id", "subject_id", $subject_id, "sub_mastersubject");
          if (strlen($in_string) > 0) $omit_string .= " AND mastersubject_id NOT IN " . $in_string;
          // Draw the combo box
          printf("<tr><td valign = \"top\" >\n");
          printf("<br><b>Available Master Subjects(s):<br></b>\n");
-         printf("<select name = \"mastersubject_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"mastersubject_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "mastersubject", "mastersubject", "mastersubject_id", $omit_string);
+         dropDownFieldOmit("mastersubject", "mastersubject", "mastersubject_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current mastersubjects to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubMaster\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubMaster\" >\n");
          printf("<br><b>Selected Master Subject(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT m.mastersubject, m.mastersubject_id FROM
                  mastersubject m,
-Line 695 
 function formAssignSubMaster($con, $subj
+Line 933 
 function formAssignSubMaster($con, $subj
                  s.subject_id = " . $subject_id . " AND
                  sm.subject_id = s.subject_id AND
                  sm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $mastersubject = $row["mastersubject"];
                  $mastersubject_id = $row["mastersubject_id"];
-                 printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject);
+                 printf("<option value = \"%s\">%s</option>\n", $mastersubject_id, $mastersubject);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignSubOtherSub
  Author: Paul Bramscher
- Last Modified: 11.06.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign other subject pages to the supplied subject id.
  **********************************************************/
- function formAssignSubOtherSub($con, $subject_id){
+ function formAssignSubOtherSub($subject_id){
          // Table definition
-         printf("<table width=\"75%%\" border=\"2\" class=\"backLight\" cellpadding=\"4\" >");
+         printf("<table width=\"75%%\" border=\"2\" class=\"backLight\" cellpadding=\"4\" >\n");
          // Form of available master subjects to select
-         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
+         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubOtherSub\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubOtherSub\" >\n");
          // Free-form pages only
          $omit_string = "WHERE subject_id > 1 AND subject_id <> " . $subject_id;
          // Omit any pre-selected other subjects in sub_othersub
-         $in_string = getNotIn($con, "othersub_id", "subject_id", $subject_id, "sub_othersub");
+         $in_string = getNotIn("othersub_id", "subject_id", $subject_id, "sub_othersub");
          if (strlen($in_string) > 0) $omit_string .= " AND subject_id NOT IN " . $in_string;
          // Draw the combo box
-Line 749 
 function formAssignSubOtherSub($con, $su
+Line 986 
 function formAssignSubOtherSub($con, $su
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Subject(s):<br></strong>\n");
+         printf("<br><b>Available Subject(s):<br></b>\n");
-         printf("<select name = \"subject_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"subject_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "subject", "subject", "subject_id", $omit_string);
+         dropDownFieldOmit("subject", "subject", "subject_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" Add \" >");
+         printf("<input type = \"Submit\" value = \" Add \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Current rqs subjects to deselect
          printf("<tr><td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
+         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >\n");
          printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubOtherSub\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubOtherSub\" >\n");
-         printf("<br><strong>Selected Subject(s):</strong><br>\n");
+         printf("<br><b>Selected Subject(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = \"3\">");
+         printf("<select name =\"key_list_array[]\" multiple size = \"3\">\n");
          $sql = "SELECT so.othersub_id, s.subject FROM
                  subject s,
-Line 776 
 function formAssignSubOtherSub($con, $su
+Line 1013 
 function formAssignSubOtherSub($con, $su
                  so.subject_id = " . $subject_id . " AND
                  so.othersub_id = s.subject_id
                  ORDER BY s.subject";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $othersub = $row["subject"];
                  $othersub_id = $row["othersub_id"];
-                 printf("<option value = \"%s\">%s</option>", $othersub_id, $othersub);
+                 printf("<option value = \"%s\">%s</option>\n", $othersub_id, $othersub);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" Remove \">");
+         printf("<input type = \"Submit\" value =\" Remove \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignSubPage
  Author: Paul Bramscher
- Last Modified: 11.06.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign PageScribe Pages to the supplied subject id.
  **********************************************************/
- function formAssignSubPage($con, $subject_id){
+ function formAssignSubPage($subject_id){
          // Table definition
-         printf("<table width=\"75%%\" border=\"2\" class=\"backLight\" cellpadding=\"4\" >");
+         printf("<table width=\"75%%\" border=\"2\" class=\"backLight\" cellpadding=\"4\" >\n");
          // Form of available master subjects to select
-         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
+         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubPage\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubPage\" >\n");
          // Free-form pages only
          $omit_string = "WHERE pagetype_id = 2";
          // Omit any pre-selected pages in sub_page
-         $in_string = getNotIn($con, "page_id", "subject_id", $subject_id, "sub_page");
+         $in_string = getNotIn("page_id", "subject_id", $subject_id, "sub_page");
          if (strlen($in_string) > 0) $omit_string .= " AND page_id NOT IN " . $in_string;
          // Draw the combo box
-Line 831 
 function formAssignSubPage($con, $subjec
+Line 1067 
 function formAssignSubPage($con, $subjec
          printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Page(s):<br></strong>\n");
+         printf("<br><b>Available Page(s):<br></b>\n");
-         printf("<select name = \"page_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"page_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "page", "page_title", "page_id", $omit_string);
+         dropDownFieldOmit("page", "page_title", "page_id", $omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" Add \" >");
+         printf("<input type = \"Submit\" value = \" Add \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Current mastersubjects to deselect
          printf("<tr><td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
+         printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubPage\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubPage\" >\n");
-         printf("<br><strong>Selected Page(s):</strong><br>\n");
+         printf("<br><b>Selected Page(s):</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = \"3\">");
+         printf("<select name =\"key_list_array[]\" multiple size = \"3\">\n");
          $sql = "SELECT p.page_title, p.page_id FROM
                  page p,
-Line 858 
 function formAssignSubPage($con, $subjec
+Line 1094 
 function formAssignSubPage($con, $subjec
                  sp.subject_id = " . $subject_id . " AND
                  sp.page_id = p.page_id
                  ORDER BY p.page_title";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $page_title = $row["page_title"];
                  $page_id = $row["page_id"];
                  // Pull out any HTML
                  $page_title = strip_tags($page_title);
-                 printf("<option value = \"%s\">%s</option>", $page_id, $page_title);
+                 printf("<option value = \"%s\">%s</option>\n", $page_id, $page_title);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" Remove \">");
+         printf("<input type = \"Submit\" value =\" Remove \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off the table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formAssignSubStaff
  Author: Paul Bramscher
- Last Modified: 06.26.2003
+ Last Modified: 03.10.2004
  ***********************************************************
  Purpose:
  Draws an HTML combo box with multiple selection capability
  to assign staffpersons to the supplied subject id.
  **********************************************************/
- function formAssignSubStaff($con, $subject_id){
+ function formAssignSubStaff($subject_id){
          // Table definition
          printf("<br><br>\n");
          printf("<table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
          // Form of available staff to select
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
+         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
          printf("Assign Staff");
          printf("</td></tr>\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubStaff\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubStaff\" >\n");
          // Omit the '(N/A)' staff
          $omit_string = "WHERE staff_id > 1";
          // Omit any pre-selected staff in sub_staff
-         $in_string = getNotIn($con, "staff_id", "subject_id", $subject_id, "sub_staff");
+         $in_string = getNotIn("staff_id", "subject_id", $subject_id, "sub_staff");
          if (strlen($in_string) > 0) $omit_string .= " AND staff_id NOT IN " . $in_string;
          // Draw the combo box
          printf("<tr><td valign = \"top\" >\n");
          printf("<br><b>Available Staff:<br></b>\n");
-         printf("<select name = \"staff_id_array[]\" multiple size = \"5\" >");
+         printf("<select name = \"staff_id_array[]\" multiple size = \"5\" >\n");
-         dropDownStaffOmit($con, $omit_string);
+         dropDownStaffOmit($omit_string);
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
          // Close things
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</td>");
+         printf("</td>\n");
          // Current staff to deselect
          printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
+         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
+         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubStaff\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubStaff\" >\n");
          printf("<br><b>Selected Staff:</b><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
+         printf("<select name =\"key_list_array[]\" multiple size = \"5\">\n");
          $sql = "SELECT t.staff_id, t.last_name, t.first_name FROM
                  staff t,
-Line 945 
 function formAssignSubStaff($con, $subje
+Line 1180 
 function formAssignSubStaff($con, $subje
                  s.subject_id = " . $subject_id . " AND
                  st.subject_id = s.subject_id AND
                  st.staff_id = t.staff_id ORDER BY last_name, first_name";
+         $rs = xx_tryquery($sql);
-         // Fetch the values
-         $rs = xx_query($sql, $con);
+         while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
-         while ($row = xx_fetch_array ($rs)) {
                  $first_name = $row["first_name"];
                  $last_name = $row["last_name"];
                  $staff_id = $row["staff_id"];
-                 printf("<option value = \"%d\">%s, %s</option>", $staff_id, $last_name, $first_name);
+                 printf("<option value = \"%d\">%s, %s</option>\n", $staff_id, $last_name, $first_name);
          }
          // Close things
-         printf("</select><br><br>");
+         printf("</select><br><br>\n");
-         printf("<center>");
+         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">");
+         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>");
+         printf("</center>\n");
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
          // Close off table
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
  }
  /**********************************************************
  Function: formCoursesub
  Author: Paul Bramscher
- Last Modified: 07.02.2003
+ Last Modified: 03.16.2004
  ***********************************************************
  Purpose:
- Draws an HTML form to edit the supplied feature id, or to
+ Draws an HTML form to edit the supplied course subject id,
- create a new feature if the incoming id is less than 1.
+ or to create a new course subject if the incoming id is
+ less than 1.
  **********************************************************/
- function formCoursesub($con, $coursesub_id) {
+ function formCoursesub($coursesub_id) {
          // Cast as integer to be sure
          $coursesub_id = (int) $coursesub_id;
          // Get descriptive title
-         $coursesub = lookupField($con, "coursesub", "coursesub_id", $coursesub_id, "coursesub");
+         $coursesub = lookupField("coursesub", "coursesub_id", $coursesub_id, "coursesub");
          // Check to see if coursesub actually exists
-         $exists = existsRow($con, "coursesub", "coursesub_id", $coursesub_id);
+         $exists = existsRow("coursesub", "coursesub_id", $coursesub_id);
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Course Subject #%d Not Found</h3>", $coursesub_id);
+                 printf("<h3>Course Subject (ID# %d) Not Found</h3>\n", $coursesub_id);
          }
          // Check to see if there are affected courselib pages
-         $exists_courselib = existsRow($con, "course", "coursesub_id", $coursesub_id);
+         $exists_courselib = existsRow("course", "coursesub_id", $coursesub_id);
          if ($exists_courselib > 0) {
                  $problem = 1;
                  // Table definition
-                 printf("<center><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
+                 msgTableOpen(1, "Edit Course Subject (ID# " . $coursesub_id . ")");
-                 printf("<tr><td><br>\n");
+                 printf("<b>Messages:</b><br>\n");
-                 printf("<b>Messages:</b><br>");
                  printf("This course subject is currently used on one or more course pages.  ");
                  printf("It may not be edited or deleted until all affected courses are moved to ");
                  printf("an alternate course subject. Follow the link below for a list of ");
                  printf("affected pages.  Course titles are composed, in part, based on this ");
-                 printf("value.<br><br>");
+                 printf("value.<br><br>\n");
                  printf("<a href=\"page_results_brief.phtml?coursesub_id=%s\">", $coursesub_id);
-                 printf("page_results_brief.phtml?coursesub_id=%s", $coursesub_id);
+                 printf("page_results_brief.phtml?coursesub_id=%s</a>", $coursesub_id);
-                 printf("</a><br><br>");
+                 printf("<br><br>\n");
-                 printf("</td></tr></table></center>\n");
+                 msgTableClose();
          }
          // If no problems, then go for landing
          if ($problem != 1) {
-Line 1030 
 function formCoursesub($con, $coursesub_
+Line 1262 
 function formCoursesub($con, $coursesub_
                  // If the user is editing an existing record, fetch previous values
                  if ($coursesub_id > 0 && $exists == 1) {
                          $sql = "SELECT * FROM coursesub WHERE coursesub_id = " . $coursesub_id;
-                         $rs = xx_query($sql, $con);
+                         $rs = xx_tryquery($sql);
-                         $row = xx_fetch_array ($rs);
+                         $row = xx_fetch_array ($rs, xx_ASSOC);
                          // Fetch existing values
                          $coursesub_id = $row["coursesub_id"];
-Line 1052 
 function formCoursesub($con, $coursesub_
+Line 1284 
 function formCoursesub($con, $coursesub_
                  // If new insert
                  if ($coursesub_id <1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Course Subject");
                          printf("</td></tr>\n");
-Line 1060 
 function formCoursesub($con, $coursesub_
+Line 1292 
 function formCoursesub($con, $coursesub_
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Edit Course Subject: %s (#%d)", $coursesub, $coursesub_id);
+                         printf("Edit Course Subject: %s (ID# %d)", $coursesub, $coursesub_id);
                          printf("</td></tr>\n");
                  }
                  // Coursesub abbrev.
                  printf("<tr>\n");
                  printf("<td><b>Course Subject Abbrev:</b></td>\n");
-Line 1083 
 function formCoursesub($con, $coursesub_
+Line 1314 
 function formCoursesub($con, $coursesub_
                  printf("<tr>\n");
                  printf("<td><b>Campus:</b></td>\n");
                  printf("<td><select name =\"campus_id\">");
-                 dropDownFieldSelected($con, "campus", "campus", "campus_id", "WHERE campus_id >= 0", $campus_id);
+                 dropDownFieldSelected("campus", "campus", "campus_id", "WHERE campus_id >= 0", $campus_id);
                  printf("</select></td>\n");
                  printf("</tr>\n");
-Line 1098 
 function formCoursesub($con, $coursesub_
+Line 1329 
 function formCoursesub($con, $coursesub_
                  // If this is an existing course subject
                  if ($coursesub_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateCoursesub\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateCoursesub\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Course Subject\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Course Subject\" >\n");
-                         printf("<input type = \"Hidden\" name = \"coursesub_id\" value = \"%d\" > ", $coursesub_id);
+                         printf("<input type = \"Hidden\" name = \"coursesub_id\" value = \"%d\" >\n", $coursesub_id);
                  }
                  // Editing a new course subject
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertCoursesub\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertCoursesub\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Course Subject\"> ");
+                         printf("<input type = \"Submit\" value = \"Save New Course Subject\">\n");
                  }
                  // Common button
-Line 1120 
 function formCoursesub($con, $coursesub_
+Line 1351 
 function formCoursesub($con, $coursesub_
  /**********************************************************
- Function: formEditSingleField($con, $display, $display_field,
+ Function: formEditSingleField($display, $display_field,
          $key_field, $key_id, $table);
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.15.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
- $table                  Table name to operate against
  $display                A display to the user, typically
                          similar to $display_field
  $display_field          Field name within $table to generate
                          displayed values from
  $key_field              Name of primary key field in $table
  $key_id                 Value of $key_field
+ $table                  Table name to operate against
  ***********************************************************
  Outgoing:
  None
-Line 1143 
 This is a generic form function to creat
+Line 1373 
 This is a generic form function to creat
  table.  The table's primary key must not involve a
  composite key -- since this form won't handle that.
  **********************************************************/
- function formEditSingleField($con, $display, $display_field, $key_field, $key_id,
+ function formEditSingleField($display, $display_field, $key_field, $key_id,
                  $size, $table) {
          // Make sure we have a positive integer to work with
-Line 1159 
 function formEditSingleField($con, $disp
+Line 1389 
 function formEditSingleField($con, $disp
                          . " = "
                          . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array($rs);
+                 $row = xx_fetch_array($rs, xx_ASSOC);
                  $oldValue = Trim($row[$display_field]);
                  // Table definition
                  printf("<center>\n");
-                 printf("<table width = \"60%%\" border = \"1\" cellpadding =\"4\" class=\"backLight\"");
+                 printf("<table width = \"60%%\" border = \"1\" cellpadding =\"4\" class=\"backLight\">\n");
                  printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                 printf("Edit %s: %s (#%d)", $display, $oldValue, $key_id);
+                 printf("Edit %s: %s (ID# %d)", $display, $oldValue, $key_id);
                  printf("</td></tr>\n");
                  // Form to handle any single field
-                 printf("<form method = \"POST\" action = \"update.phtml\" >");
+                 printf("<form method = \"POST\" action = \"update.phtml\" >\n");
-                 printf("<tr><td>");
+                 printf("<tr><td>\n");
-                 printf("<b>%s:</b> ", $display);
+                 printf("<b>%s:</b>\n", $display);
                  printf("</td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"newValue\" size=\"%d\" value =\"%s\" >", $size, $oldValue);
+                 printf("<input type = \"text\" name = \"newValue\" size=\"%d\" value =\"%s\" >\n", $size, $oldValue);
-                 printf("<input type = \"Hidden\" name = \"display\" value = \"%s\" >", $display);
+                 printf("<input type = \"Hidden\" name = \"display\" value = \"%s\" >\n", $display);
-                 printf("<input type = \"Hidden\" name = \"display_field\" value = \"%s\" >", $display_field);
+                 printf("<input type = \"Hidden\" name = \"display_field\" value = \"%s\" >\n", $display_field);
-                 printf("<input type = \"Hidden\" name = \"key_field\" value = \"%s\" >", $key_field);
+                 printf("<input type = \"Hidden\" name = \"key_field\" value = \"%s\" >\n", $key_field);
-                 printf("<input type = \"Hidden\" name = \"key_id\" value = \"%s\" >", $key_id);
+                 printf("<input type = \"Hidden\" name = \"key_id\" value = \"%s\" >\n", $key_id);
-                 printf("<input type = \"Hidden\" name = \"table\" value = \"%s\" >", $table);
+                 printf("<input type = \"Hidden\" name = \"table\" value = \"%s\" >\n", $table);
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateSingleField\" >");
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateSingleField\" >\n");
                  printf("</td></tr>\n");
                  printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
-                 printf("<input type = \"Submit\" value = \"Save Changes To %s\" > ", $display);
+                 printf("<input type = \"Submit\" value = \"Save Changes To %s\" >\n", $display);
-                 printf("<input type = \"Reset\" value = \"Reset\" >");
+                 printf("<input type = \"Reset\" value = \"Reset\" >\n");
                  // Close things
-                 printf("</form><BR>");
+                 printf("</form><br>\n");
-                 printf("</td></tr>");
+                 printf("</td></tr>\n");
-                 printf("</table></center>");
+                 printf("</table></center>\n");
          }
-Line 1202 
 function formEditSingleField($con, $disp
+Line 1432 
 function formEditSingleField($con, $disp
  /**********************************************************
  Function: formFaculty
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.16.2004
  ***********************************************************
  Purpose:
  Draws an HTML form to edit the supplied faculty id, or to
  create a new faculty person if the incoming id is less than
 .
  **********************************************************/
- function formFaculty($con, $faculty_id){
+ function formFaculty($faculty_id){
          // Initialize variables
          $faculty_id = (int) $faculty_id;
-Line 1228 
 function formFaculty($con, $faculty_id){
+Line 1458 
 function formFaculty($con, $faculty_id){
                          FROM faculty f
                          WHERE
                          faculty_id = " . $faculty_id;
+                 $rs = xx_tryquery($sql);
-                 $rs = xx_query($sql, $con);
+                 $row = xx_fetch_array($rs, xx_ASSOC);
-                 $row = xx_fetch_array($rs);
                  // Fetch results
                  $faculty_firstname = Trim($row["faculty_firstname"]);
-Line 1248 
 function formFaculty($con, $faculty_id){
+Line 1477 
 function formFaculty($con, $faculty_id){
          // If new faculty
          if ($faculty_id < 1) {
-                 printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                 printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                  printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                  printf("Enter New Faculty");
                  printf("</td></tr>\n");
-Line 1256 
 function formFaculty($con, $faculty_id){
+Line 1485 
 function formFaculty($con, $faculty_id){
          // Else update
          else {
-                 printf("<form method = \"POST\" action = \"update.phtml\" >");
+                 printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                  printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                 printf("Edit Faculty: %s %s (#%d)", $faculty_firstname, $faculty_lastname, $faculty_id);
+                 printf("Edit Faculty: %s %s (ID# %d)", $faculty_firstname, $faculty_lastname, $faculty_id);
                  printf("</td></tr>\n");
          }
-Line 1290 
 function formFaculty($con, $faculty_id){
+Line 1519 
 function formFaculty($con, $faculty_id){
          printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
          // If new faculty
          if ($faculty_id < 1) {
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertFaculty\" >");
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertFaculty\" >\n");
-                 printf("<input type = \"Submit\" value = \"Save New Faculty\" > ");
+                 printf("<input type = \"Submit\" value = \"Save New Faculty\" >\n");
          }
          // Editing an existing faculty person
          else {
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateFaculty\" >");
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateFaculty\" >\n");
-                 printf("<input type = \"Hidden\" name = \"faculty_id\" value = \"%d\" >", $faculty_id);
+                 printf("<input type = \"Hidden\" name = \"faculty_id\" value = \"%d\" >\n", $faculty_id);
-                 printf("<input type = \"Submit\" value = \"Save Faculty Changes\" > ");
+                 printf("<input type = \"Submit\" value = \"Save Faculty Changes\" >\n");
          }
-         printf("<input type = \"Reset\" value = \"Reset\" >");
+         printf("<input type = \"Reset\" value = \"Reset\" >\n");
          // Close things
-         printf("</form>");
+         printf("</form>\n");
-         printf("</td></tr></table>");
+         printf("</td></tr></table>\n");
-         printf("</center><br>");
+         printf("</center><br>\n");
  }
  /**********************************************************
  Function: formFeature
  Author: Paul Bramscher
- Last Modified: 07.01.2003
+ Last Modified: 03.15.2004
  ***********************************************************
  Purpose:
  Draws an HTML form to edit the supplied feature id, or to
  create a new feature if the incoming id is less than 1.
  **********************************************************/
- function formFeature($con, $key_id) {
+ function formFeature($key_id) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if feature actually exists
-         $exists = existsRow($con, "feature", "feature_id", $key_id);
+         $exists = existsRow("feature", "feature_id", $key_id);
          // Header
          printf("<center>");
-Line 1335 
 function formFeature($con, $key_id) {
+Line 1564 
 function formFeature($con, $key_id) {
                  // Fetch existing values
                  $sql = "SELECT * FROM feature WHERE feature_id = " . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array ($rs);
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
                  $feature_id = $row["feature_id"];
                  $feature = $row["feature"];
                  $image_path = $row["image_path"];
-Line 1351 
 function formFeature($con, $key_id) {
+Line 1580 
 function formFeature($con, $key_id) {
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Feature #%d Not Found</h3>", $key_id);
+                 printf("<h3>Feature (ID# %d) Not Found</h3>\n", $key_id);
          }
          // If no problems, then go for landing
-Line 1363 
 function formFeature($con, $key_id) {
+Line 1592 
 function formFeature($con, $key_id) {
                  // Form to handle feature
                  // If new insert
                  if ($key_id <1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Feature");
                          printf("</td></tr>\n");
-Line 1371 
 function formFeature($con, $key_id) {
+Line 1600 
 function formFeature($con, $key_id) {
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Edit Feature: %s (#%d)", $feature, $feature_id);
+                         printf("Edit Feature: %s (ID# %d)", $feature, $feature_id);
                          printf("</td></tr>\n");
                  }
                  // Feature name
                  printf("<tr>\n");
-                 printf("<td><b>Feature:</b></td>");
+                 printf("<td><b>Feature:</b></td>\n");
                  printf("<td><input type = \"text\" name = \"feature\" size = \"40\" value = \"%s\" ></td>\n", $feature);
                  printf("</tr>\n");
-Line 1398 
 function formFeature($con, $key_id) {
+Line 1627 
 function formFeature($con, $key_id) {
                  printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
                  // If this is an existing feature
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateFeature\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateFeature\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Feature\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Feature\" >\n");
-                         printf("<input type = \"Hidden\" name = \"feature_id\" value = \"%d\" > ", $feature_id);
+                         printf("<input type = \"Hidden\" name = \"feature_id\" value = \"%d\" >\n", $feature_id);
                  }
                  // Editing a new feature
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertFeature\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertFeature\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Feature\"> ");
+                         printf("<input type = \"Submit\" value = \"Save New Feature\">\n");
                  }
                  // Common button
-Line 1422 
 function formFeature($con, $key_id) {
+Line 1651 
 function formFeature($con, $key_id) {
  /**********************************************************
  Function: formInfotype
  Author: Paul Bramscher
- Last Modified: 06.26.2003
+ Last Modified: 03.15.2004
  ***********************************************************
  Purpose:
  Draws an HTML form to edit the supplied information type id,
  or to create a new information type if the incoming id is
  less than 1.
  **********************************************************/
- function formInfotype($con, $key_id) {
+ function formInfotype($key_id) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if infotype actually exists
-         $exists = existsRow($con, "infotype", "infotype_id", $key_id);
+         $exists = existsRow("infotype", "infotype_id", $key_id);
          // Header
-         printf("<center>");
+         printf("<center>\n");
          if ($key_id > 0 && $exists == 1) {
                  // Initialization
-Line 1449 
 function formInfotype($con, $key_id) {
+Line 1678 
 function formInfotype($con, $key_id) {
                  // Fetch existing values
                  $sql = "SELECT * from infotype where infotype_id = " . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array ($rs);
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
                  $infotype_id = $row["infotype_id"];
                  $infotype = $row["infotype"];
                  $masterinfotype_id = $row["masterinfotype_id"];
-Line 1464 
 function formInfotype($con, $key_id) {
+Line 1693 
 function formInfotype($con, $key_id) {
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Information Type #%d Not Found</h3>", $key_id);
+                 printf("<h3>Information Type (ID# %d) Not Found</h3>\n", $key_id);
          }
          // If no problems, then go for landing
-Line 1475 
 function formInfotype($con, $key_id) {
+Line 1704 
 function formInfotype($con, $key_id) {
                  // If new insert
                  if ($key_id < 1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Information Type");
                          printf("</td></tr>\n");
-Line 1484 
 function formInfotype($con, $key_id) {
+Line 1713 
 function formInfotype($con, $key_id) {
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Edit Information Type: %s (#%d)", $infotype, $infotype_id);
+                         printf("Edit Information Type: %s (ID# %d)", $infotype, $infotype_id);
                          printf("</td></tr>\n");
                  }
-Line 1500 
 function formInfotype($con, $key_id) {
+Line 1729 
 function formInfotype($con, $key_id) {
                  printf("<tr>\n");
                  printf("<td><b>Master Information Type:</b></td>\n");
                  printf("<td>\n");
-                 printf("<select name =\"masterinfotype_id\">");
+                 printf("<select name =\"masterinfotype_id\">\n");
-                 dropDownFieldSelected($con, "masterinfotype", "masterinfotype", "masterinfotype_id", "WHERE masterinfotype_id >= 0", $masterinfotype_id);
+                 dropDownFieldSelected("masterinfotype", "masterinfotype", "masterinfotype_id", "WHERE masterinfotype_id >= 0", $masterinfotype_id);
                  printf("</select>\n");
                  printf("</td></tr>\n");
                  // Mastersubject
                  printf("<tr>\n");
-                 printf("<td><b>Master Subject:</b></td>");
+                 printf("<td><b>Master Subject:</b></td>\n");
                  printf("<td>\n");
-                 printf("<select name =\"mastersubject_id\">");
+                 printf("<select name =\"mastersubject_id\">\n");
-                 dropDownFieldSelected($con, "mastersubject", "mastersubject", "mastersubject_id", "WHERE mastersubject_id >= 0", $mastersubject_id);
+                 dropDownFieldSelected("mastersubject", "mastersubject", "mastersubject_id", "WHERE mastersubject_id >= 0", $mastersubject_id);
                  printf("</select>\n");
                  printf("</td></tr>\n");
-Line 1519 
 function formInfotype($con, $key_id) {
+Line 1748 
 function formInfotype($con, $key_id) {
                  // If this is an existing infotype
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateInfotype\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateInfotype\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Info Type\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Info Type\" >\n");
-                         printf("<input type = \"Hidden\" name = \"infotype_id\" value = \"%d\" > ", $infotype_id);
+                         printf("<input type = \"Hidden\" name = \"infotype_id\" value = \"%d\" >\n", $infotype_id);
                  }
                  // Editing a new infotype
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertInfotype\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertInfotype\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Info Type\"> ");
+                         printf("<input type = \"Submit\" value = \"Save New Info Type\">\n");
                  }
                  // Common button
-Line 1542 
 function formInfotype($con, $key_id) {
+Line 1771 
 function formInfotype($con, $key_id) {
  /**********************************************************
+ Function: formLibunit
+ Author: Paul Bramscher
+ Last Modified: 03.16.2004
+ ***********************************************************
+ Purpose:
+ Handles the creation of new (or editing of existing)
+ library units.
+ **********************************************************/
+ function formLibunit($key_id){
+         // Initialize variables
+         $libunit_id = (int) $key_id;
+         $libunit ="";
+         $libunit_abbrev = "";
+         // If editing an existing library unit load previous values
+         if ($libunit_id > 1){
+                 $sql = "SELECT
+                         l.libunit,
+                         l.libunit_abbrev,
+                         l.head_staff_id
+                         FROM libunit l
+                         WHERE
+                         libunit_id = " . $libunit_id;
+                 $rs = xx_tryquery($sql);
+                 $row = xx_fetch_array($rs, xx_ASSOC);
+                 // Fetch values
+                 $libunit = Trim($row["libunit"]);
+                 $libunit_abbrev = Trim($row["libunit_abbrev"]);
+                 $head_staff_id = $row["head_staff_id"];
+                 // Run strings through the HTML cleaner for output
+                 $libunit = textOutHTML($libunit);
+                 $libunit_abbrev = textOutHTML($libunit_abbrev);
+         }
+         // Table definition
+         printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
+         // If new insert
+         if ($key_id <1) {
+                 printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
+                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+                 printf("Enter New Library Unit");
+                 printf("</td></tr>\n");
+         }
+         // Else update
+         else {
+                 printf("<form method = \"POST\" action = \"update.phtml\" >\n");
+                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+                 printf("Edit Library Unit: %s (ID# %d)", $libunit, $libunit_id);
+                 printf("</td></tr>\n");
+         }
+         // Libunit
+         printf("<td><b>Library Unit:</b></td>\n");
+         printf("<td><input type = \"text\" name = \"libunit\" size = \"60\" value = \"%s\" ></td>\n", $libunit);
+         printf("</td></tr>\n");
+         // Libunit abbrev.
+         printf("<tr>\n");
+         printf("<td><b>Abbreviation:</b></td>\n");
+         printf("<td><input type = \"text\" name = \"libunit_abbrev\" size = \"20\" value = \"%s\"></td>\n", $libunit_abbrev);
+         printf("</tr>\n");
+         // Libunit lead
+         printf("<tr>\n");
+         printf("<td><b>Unit Lead:</b></td>\n");
+         printf("<td><select name = \"head_staff_id\" >\n");
+         dropDownStaffSelected($head_staff_id);
+         printf("</select></td>\n");
+         printf("</tr>\n");
+         // Buttons
+         printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
+         // If new libunit
+         if ($libunit_id < 2) {
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertLibunit\" >\n");
+                 printf("<input type = \"Submit\" value = \"Save New Library Unit\" >\n");
+         }
+         // Editing an existing libunit
+         else {
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateLibunit\" >\n");
+                 printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >\n", $libunit_id);
+                 printf("<input type = \"Submit\" value = \"Save Library Unit Changes\" >\n");
+         }
+         printf("<input type = \"Reset\" value = \"Reset\" >\n");
+         // Close the form and table
+         printf("</form>\n");
+         printf("</td></tr></table>\n");
+         // Other forms - only if editing an existing libunit
+         if ($libunit_id > 0) {
+                 formAssignLibunitStaff($libunit_id);
+         }
+         printf("</center><br>\n");
+ }
+ /**********************************************************
  Function: formLocation
  Author: Paul Bramscher
- Last Modified: 06.26.2003
+ Last Modified: 03.15.2004
  ***********************************************************
  Draws an HTML form to edit the supplied location id, or to
  create a new location if the incoming id is less than 1.
  **********************************************************/
- function formLocation($con, $key_id) {
+ function formLocation($key_id) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if location actually exists
-         $exists = existsRow($con, "location", "location_id", $key_id);
+         $exists = existsRow("location", "location_id", $key_id);
          // Header
          printf("<center>");
-Line 1577 
 function formLocation($con, $key_id) {
+Line 1913 
 function formLocation($con, $key_id) {
                  // Fetch existing values
                  $sql = "SELECT * from location where location_id = " . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array ($rs);
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
                  $location_id = $row["location_id"];
                  $location = $row["location"];
                  $location_descr = $row["location_descr"];
-Line 1607 
 function formLocation($con, $key_id) {
+Line 1943 
 function formLocation($con, $key_id) {
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Location #%d Not Found</h3>", $key_id);
+                 printf("<h3>Location (ID# %d) Not Found</h3>\n", $key_id);
          }
          // If no problems, then go for landing
-Line 1618 
 function formLocation($con, $key_id) {
+Line 1954 
 function formLocation($con, $key_id) {
                  // If new insert
                  if ($key_id <1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Location");
                          printf("</td></tr>\n");
-Line 1626 
 function formLocation($con, $key_id) {
+Line 1962 
 function formLocation($con, $key_id) {
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Edit Location: %s (#%d)", $location, $location_id);
+                         printf("Edit Location: %s (ID# %d)", $location, $location_id);
                          printf("</td></tr>\n");
                  }
                  // Location/Library
                  printf("<tr>\n");
-                 printf("<td><b>Location/Library:</b></td>");
+                 printf("<td><b>Location/Library:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"location\" size = \"60\" value = \"%s\" >", $location);
+                 printf("<input type = \"text\" name = \"location\" size = \"60\" value = \"%s\" >\n", $location);
                  printf("</td></tr>\n");
                  // Description
-Line 1651 
 function formLocation($con, $key_id) {
+Line 1987 
 function formLocation($con, $key_id) {
                  printf("<tr>\n");
                  printf("<td><b>Campus:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"campus\" size = \"50\" value = \"%s\" >", $campus);
+                 printf("<input type = \"text\" name = \"campus\" size = \"50\" value = \"%s\" >\n", $campus);
                  printf("</td></tr>\n");
                  // Address1
                  printf("<tr>\n");
                  printf("<td><b>Address Line 1:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"address1\" size = \"50\" value = \"%s\" >", $address1);
+                 printf("<input type = \"text\" name = \"address1\" size = \"50\" value = \"%s\" >\n", $address1);
                  printf("</td></tr>\n");
                  // Address2
                  printf("<tr>\n");
                  printf("<td><b>Address Line 2:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"address2\" size = \"50\" value = \"%s\" >", $address2);
+                 printf("<input type = \"text\" name = \"address2\" size = \"50\" value = \"%s\" >\n", $address2);
                  printf("</td></tr>\n");
                  // Address3
                  printf("<tr>\n");
                  printf("<td><b>Address Line 3:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"address3\" size = \"50\" value = \"%s\" >", $address3);
+                 printf("<input type = \"text\" name = \"address3\" size = \"50\" value = \"%s\" >\n", $address3);
                  printf("</td></tr>\n");
                  // Address4
                  printf("<tr>\n");
                  printf("<td><b>Address Line 4:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"address4\" size = \"50\" value = \"%s\" >", $address4);
+                 printf("<input type = \"text\" name = \"address4\" size = \"50\" value = \"%s\" >\n", $address4);
                  printf("</td></tr>\n");
                  // Telephone
                  printf("<tr>\n");
                  printf("<td><b>Telephone:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"telephone\" size = \"25\" value = \"%s\" >", $telephone);
+                 printf("<input type = \"text\" name = \"telephone\" size = \"25\" value = \"%s\" >\n", $telephone);
                  printf("</td></tr>\n");
                  // mainURL
                  printf("<tr>\n");
                  printf("<td><b>Main URL:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"mainURL\" size = \"70\" value = \"%s\" >", $mainURL);
+                 printf("<input type = \"text\" name = \"mainURL\" size = \"70\" value = \"%s\" >\n", $mainURL);
                  printf("</td></tr>\n");
                  // referenceURL
                  printf("<tr>\n");
                  printf("<td><b>Reference URL:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"referenceURL\" size = \"70\" value = \"%s\" >",
+                 printf("<input type = \"text\" name = \"referenceURL\" size = \"70\" value = \"%s\" >\n",
                          $referenceURL);
                  printf("</td></tr>\n");
-Line 1708 
 function formLocation($con, $key_id) {
+Line 2044 
 function formLocation($con, $key_id) {
                  printf("<tr>\n");
                  printf("<td><b>Hours URL:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"hoursURL\" size = \"70\" value = \"%s\" >",
+                 printf("<input type = \"text\" name = \"hoursURL\" size = \"70\" value = \"%s\" >\n",
                          $hoursURL);
                  printf("</td></tr>\n");
-Line 1716 
 function formLocation($con, $key_id) {
+Line 2052 
 function formLocation($con, $key_id) {
                  printf("<tr>\n");
                  printf("<td><b>Map URL:</b></td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"mapURL\" size = \"70\" value = \"%s\" >", $mapURL);
+                 printf("<input type = \"text\" name = \"mapURL\" size = \"70\" value = \"%s\" >\n", $mapURL);
                  printf("</td></tr>\n");
                  // Buttons
-Line 1724 
 function formLocation($con, $key_id) {
+Line 2060 
 function formLocation($con, $key_id) {
                  // If this is an existing location
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateLocation\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateLocation\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Location\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Location\" >\n");
-                         printf("<input type = \"Hidden\" name = \"location_id\" value = \"%d\" > ", $location_id);
+                         printf("<input type = \"Hidden\" name = \"location_id\" value = \"%d\" >\n", $location_id);
                  }
                  // Editing a new location
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertLocation\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertLocation\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Location\" > ");
+                         printf("<input type = \"Submit\" value = \"Save New Location\" >\n");
                  }
                  // Common button
-Line 1746 
 function formLocation($con, $key_id) {
+Line 2082 
 function formLocation($con, $key_id) {
  /**********************************************************
- Function: formNewSingleField($con, $display, $field,
+ Function: formNewSingleField($display, $field,
          $size, $table);
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.11.2004
  ***********************************************************
  Incoming:
- $con                    Database connection string
- $table                  Table name to operate against
  $field                  Field name within $table
  $display                A display to the user, typically
                          identical to $field
  $size                   The size of the HTML input box
+ $table                  Table name to operate against
  ***********************************************************
  Outgoing:
  None
-Line 1767 
 This is a generic form function to creat
+Line 2102 
 This is a generic form function to creat
  table.  The table's primary key must not involve a
  composite key since this form won't handle that.
  **********************************************************/
- function formNewSingleField($con, $display, $field, $size, $table) {
+ function formNewSingleField($display, $field, $size, $table) {
          // Draw Box
          printf("<center>\n");
-         printf("<table width = \"60%%\" border = \"1\" cellpadding =\"4\" class=\"backLight\">");
+         printf("<table width = \"60%%\" border = \"1\" cellpadding =\"4\" class=\"backLight\">\n");
          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
          printf("Enter New %s", $display);
          printf("</td></tr>\n");
          // Form for the new field value
-         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
          printf("<tr>\n");
          printf("<td><b>%s:</b></td>\n", $display);
-         printf("<td>");
+         printf("<td>\n");
-         printf("<input type = \"text\" name = \"newValue\" size = \"%d\" >", $size);
+         printf("<input type = \"text\" name = \"newValue\" size = \"%d\" >\n", $size);
-         printf("<input type = \"Hidden\" name = \"table\" value = \"%s\" >", $table);
+         printf("<input type = \"Hidden\" name = \"table\" value = \"%s\" >\n", $table);
-         printf("<input type = \"Hidden\" name = \"field\" value = \"%s\" >", $field);
+         printf("<input type = \"Hidden\" name = \"field\" value = \"%s\" >\n", $field);
-         printf("<input type = \"Hidden\" name = \"display\" value = \"%s\" >", $display);
+         printf("<input type = \"Hidden\" name = \"display\" value = \"%s\" >\n", $display);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertSingleField\" >");
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertSingleField\" >\n");
          printf("</td></tr>\n");
          printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
-         printf("<input type = \"Submit\" value = \"Save New %s\" > ", $display);
+         printf("<input type = \"Submit\" value = \"Save New %s\" >\n", $display);
-         printf("<input type = \"Reset\" value = \"Reset\" >");
+         printf("<input type = \"Reset\" value = \"Reset\" >\n");
          // Close things
-         printf("</form><br>");
+         printf("</form><br>\n");
-         printf("</td></tr>");
+         printf("</td></tr>\n");
-         printf("</table><br></center>");
+         printf("</table><br></center>\n");
  }
  /**********************************************************
+ Function: formPassword
+ Author: Paul Bramscher
+ Last Modified: 03.11.2004
+ ***********************************************************
+ Purpose:
+ Creates a new password for the supplied staff id.  Note
+ that this is a locally stored (in mySQL) and encrypted
+ password.  It is never visible in plaintext, nor is it
+ ever brought to an HTML form, neither in plaintext nor
+ in a "password" type HTML form field.
+ **********************************************************/
+ function formPassword($staff_id){
+         /*****************************************
+         ** If using native mySQL authentication **
+         *****************************************/
+         // Table definition
+         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
+         // Form
+         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
+         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+         printf("Local Authentication Password - See Note Below");
+         printf("</td></tr>\n");
+         // Staff password - for mySQL authentication only.  Ignored if x500 account is present.
+         printf("<tr><td colspan=\"2\">\n");
+         printf("<b>Note:</b> Supply if utilizing mySQL authentication, otherwise leave blank. ");
+         printf("This will replace the password (if any) currently assigned to this account.");
+         printf("</td></tr>\n");
+         // First type
+         printf("<tr>\n");
+         printf("<td><b>New Password (6 char. minimum):</b></td>\n");
+         printf("<td><input type = \"password\" name = \"password\" size = \"25\"></td>\n");
+         printf("</tr>\n");
+         // Confirm type
+         printf("<tr>\n");
+         printf("<td><b>Confirm password (type again):</b></td>\n");
+         printf("<td><input type = \"password\" name = \"password_confirm\" size = \"25\"></td>\n");
+         printf("</tr>\n");
+         // Buttons
+         printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
+         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
+         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updatePassword\" >\n");
+         printf("<input type = \"Submit\" value = \"Save Local Password\" >\n");
+         // Close the form and table
+         printf("</form>\n");
+         printf("</td></tr></table>\n");
+         /*******************************************
+         ** Determine if a password already exists **
+         *******************************************/
+         // Initialize variables
+         $pass_set = 0;
+         // Determine whether a password exists
+         $sql = "SELECT COUNT(*) as pass_set
+                 FROM staff s
+                 WHERE (s.password <> NULL OR s.password <> '') and s.staff_id = " . $staff_id;
+         $rs = xx_tryquery($sql);
+         $row = xx_fetch_array($rs, xx_ASSOC);
+         // Fetch values
+         $pass_set = $row["pass_set"];
+         // If some password already exists, offer this form
+         if ($pass_set > 0) {
+                 // Table definition
+                 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
+                 // Form
+                 printf("<tr><td class=\"cellPlain\">\n");
+                 printf("Local Password Found");
+                 printf("</td></tr>\n");
+                 printf("<form method = \"POST\" action = \"update.phtml\" >\n");
+                 // Purge existing password
+                 printf("<tr><td>\n");
+                 printf("<br><b>Purge password to null?</b><br><br>\n");
+                 printf("<b>Note:</b> It appears that this account currently has a password assigned to it.");
+                 printf("This option will clear out any existing password, and leave the value NULL.");
+                 printf("The staffperson may not login until a new password is supplied.<br><br>\n");
+                 // Buttons
+                 printf("<center>\n");
+                 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"purgePassword\" >\n");
+                 printf("<input type = \"Submit\" value = \"Purge Password!\" >\n");
+                 // Close the form and table
+                 printf("</form>\n");
+                 printf("</center></td></tr></table><br>\n");
+         } // end password purge form
+ } // end function
+ /**********************************************************
  Function: formResource
  Author: Paul Bramscher
- Last Modified: 06.19.2003 by Paul Bramscher
+ Last Modified: 03.16.2004 by Paul Bramscher
  ***********************************************************
  Draws an HTML form to edit the supplied resource id, or to
  create a new resource if the incoming id is less than 1.
  Note also that there are incoming masterinfotype id,
  mastersubject id, an title parameters.
  **********************************************************/
- function formResource($con, $key_id, $masterinfotype_id, $mastersubject_id, $title) {
+ function formResource($key_id, $masterinfotype_id, $mastersubject_id, $title) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if record actually exists
-         $exists = existsRow($con, "resource", "resource_id", $key_id);
+         $exists = existsRow("resource", "resource_id", $key_id);
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Resource #%d Not Found</h3>", $key_id);
+                 msgTableOpen(1, "Edit Resource (ID# " . $key_id . ")");
+                 printf("<b>Messages:</b><br>\n");
+                 printf("Resource not found. Operation cancelled.");
+                 printf("<br><br>\n");
+                 msgTableClose();
          }
-Line 1848 
 function formResource($con, $key_id, $ma
+Line 2296 
 function formResource($con, $key_id, $ma
                  $url = "";
                  $visited = "";
                  $annotation ="";
+                 $vendor_id = 0;
                  // If the user is editing an existing record, fetch previous values
                  if ($key_id > 0 && $exists == 1) {
                          $sql = "SELECT * from resource where resource_id = " . $key_id;
-                         $rs = xx_query($sql, $con);
+                         $rs = xx_tryquery($sql);
-                         $row = xx_fetch_array ($rs);
+                         $row = xx_fetch_array ($rs, xx_ASSOC);
                          // Fetch existing values
                          $resource_id = $row["resource_id"];
-Line 1873 
 function formResource($con, $key_id, $ma
+Line 2322 
 function formResource($con, $key_id, $ma
                          $cat_num = $row["cat_num"];
                          $site_title = $row["site_title"];
                          $url = $row["url"];
+                         $guide_url = $row["guide_url"];
                          $visited = $row["visited"];
                          $annotation = $row["annotation"];
                          $infotype_id = $row["infotype_id"];
-Line 1880 
 function formResource($con, $key_id, $ma
+Line 2330 
 function formResource($con, $key_id, $ma
                          $coverage_detail = $row["coverage_detail"];
                          $sources_indexed = $row["sources_indexed"];
                          $location_id = $row["location_id"];
+                         $vendor_id = $row["vendor_id"];
+                         $resource_status = $row["resource_status"];
+                         $resource_message = $row["resource_message"];
                          // Run strings through the HTML cleaner for output
                          $title = textOutHTML($title);
-Line 1925 
 function formResource($con, $key_id, $ma
+Line 2378 
 function formResource($con, $key_id, $ma
                  printf("<table width=\"100%%\" border=\"0\" cellspacing =\"2\" cellpadding=\"2\">\n");
                  // Form header
-                 printf("<tr><td colspan=\"4\" class=\"cellPlain\" >");
+                 printf("<tr><td colspan=\"4\" class=\"cellPlain\" >\n");
-                 if ($key_id > 0 && $exists == 1) printf("Edit Resource #%d", $key_id);
+                 if ($key_id > 0 && $exists == 1) printf("Edit Resource (ID# %d)", $key_id);
                  if ($key_id <= 0) printf("Enter New Resource\n");
                  printf("</td></tr>\n");
                  // If new insert
-                 if ($key_id <1) printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                 if ($key_id <1) printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                  // Else update
-                 else printf("<form method = \"POST\" action = \"update.phtml\" >");
+                 else printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                  // Account & Time/date information if this is not a new resource
                  if ($key_id > 0) {
                          printf("<tr>\n<td colspan = \"1\">\n");
-                         printf("<br><B>Date Created:</b>");
+                         printf("<br><B>Date Created:</b>\n");
                          printf("</td><td colspan =\"3\">\n");
                          printf("<BR>%s</td></tr>", $date_created);
                          printf("<tr>\n<td colspan = \"1\">\n");
-                         printf("<B>Date Modified:</b>");
+                         printf("<B>Date Modified:</b>\n");
                          printf("</td><td colspan =\"3\">\n");
-                         printf("%s</td></tr>", $date_modified);
+                         printf("%s</td></tr>\n", $date_modified);
                          printf("<tr>\n<td colspan = \"1\">\n");
-                         printf("<br><B>Creator:</b>");
+                         printf("<br><B>Creator:</b>\n");
                          printf("</td><td colspan =\"3\">\n");
-                         printf("<BR>%s</td></tr>", $account_created);
+                         printf("<BR>%s</td></tr>\n", $account_created);
                          printf("<tr>\n<td colspan = \"1\">\n");
-                         printf("<B>Last Modified by:</b>");
+                         printf("<B>Last Modified by:</b>\n");
                          printf("</td><td colspan =\"3\">\n");
-                         printf("%s</td></tr>", $account_modified);
+                         printf("%s</td></tr>\n", $account_modified);
                  }
                  // Title
                  printf("<tr><td colspan =\"1\" >\n");
-                 printf("<br><strong>Title:</strong> ");
+                 printf("<br><b>Title:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<br><input type = \"text\" name = \"title\" size = \"60\" value =\"%s\" >", $title);
+                 printf("<br><input type = \"text\" name = \"title\" size = \"60\" value =\"%s\" >\n", $title);
                  printf("</td></tr>\n");
                  // Other Title
                  printf("<tr><td colspan =\"1\" >\n");
-                 printf("<strong>Other Title:</strong> ");
+                 printf("<b>Other Title:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<input type = \"text\" name = \"other_title\" size = \"60\" value =\"%s\" >", $other_title);
+                 printf("<input type = \"text\" name = \"other_title\" size = \"60\" value =\"%s\" >\n", $other_title);
                  printf("</td></tr>\n");
                  // Author(s)
                  printf("<tr><td colspan =\"1\" >\n");
-                 printf("<br><strong>Author(s):</strong> ");
+                 printf("<br><b>Author(s):</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<br><input type = \"text\" name = \"author\" size = \"60\" value =\"%s\" >", $author);
+                 printf("<br><input type = \"text\" name = \"author\" size = \"60\" value =\"%s\" >\n", $author);
                  printf("<br><i>(if applicable)</i></td></tr>\n");
                  // Coverage detail
                  printf("<tr><td colspan = \"1\" valign=\"top\">\n");
-                 printf("<strong>Coverage Detail:</strong>");
+                 printf("<b>Coverage Detail:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<textarea name = \"coverage_detail\" cols = \"40\" rows = \"2\">");
+                 printf("<textarea name = \"coverage_detail\" cols = \"40\" rows = \"2\">\n");
                  printf("%s", $coverage_detail);
-                 printf("</textarea>");
+                 printf("</textarea>\n");
-                 printf("<br><i>(enter year, i.e. 1966 - 1985, or 1984 - present)</i>");
+                 printf("<br><i>(enter year, i.e. 1966 - 1985, or 1984 - present)</i>\n");
                  printf("<br><br></td></tr>\n");
                  // Sources Indexed
                  printf("<tr><td colspan =\"1\" valign=\"top\">\n");
-                 printf("<strong>Sources Indexed:</strong> ");
+                 printf("<b>Sources Indexed:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<input type = \"text\" name = \"sources_indexed\" size = \"60\" value =\"%s\" >", $sources_indexed);
+                 printf("<input type = \"text\" name = \"sources_indexed\" size = \"60\" value =\"%s\" >\n", $sources_indexed);
-                 printf("<br><i>(enter link to vendor page)</i>");
+                 printf("<br><i>(enter link to vendor page)</i>\n");
                  printf("</td></tr>\n");
                  // URL
                  printf("<tr><td colspan = \"1\" valign=\"top\">\n");
-                 printf("<strong>URL</a>:</strong>");
+                 printf("<b>URL</a>:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<textarea name = \"url\" rows = \"4\" cols = \"51\" >");
+                 printf("<textarea name = \"url\" rows = \"4\" cols = \"51\" >\n");
                  printf("%s", $url);
-                 printf("</textarea><br><br><br>\n");
+                 printf("</textarea><br>\n");
                  printf("</td></tr>\n");
+                 // Guide/Help URL
+                 printf("<tr><td colspan = \"1\" valign=\"top\">\n");
+                 printf("<b>Guide/Help URL</a>:</b>\n");
+                 printf("</td><td colspan =\"3\">\n");
+                 printf("<textarea name = \"guide_url\" rows = \"4\" cols = \"51\" >\n");
+                 printf("%s", $guide_url);
+                 printf("</textarea><br>\n");
+                 printf("</td></tr>\n");
                  // Publisher
                  printf("<tr><td colspan = \"1\" >\n");
-                 printf("<strong>Publisher:</strong> ");
+                 printf("<b>Publisher:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<input type = \"text\" name = \"publisher\" size = \"50\" value =\"%s\" >", $publisher);
+                 printf("<input type = \"text\" name = \"publisher\" size = \"50\" value =\"%s\" >\n", $publisher);
                  printf("</td></tr>\n");
                  // Publish date
                  printf("<td colspan = \"1\" >\n");
-                 printf("<strong>Publish Date:</strong> ");
+                 printf("<b>Publish Date:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<input type = \"text\" name = \"pub_date\" size = \"50\" value = \"%s\" >", $pub_date);
+                 printf("<input type = \"text\" name = \"pub_date\" size = \"50\" value = \"%s\" >\n", $pub_date);
                  printf("</td></tr>\n");
                  // Edition
                  printf("<tr><td colspan = \"1\" >\n");
-                 printf("<strong>Edition:</strong> ");
+                 printf("<b>Edition:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<input type = \"text\" name = \"edition\" size = \"20\" value = \"%s\" >", $edition);
+                 printf("<input type = \"text\" name = \"edition\" size = \"20\" value = \"%s\" >\n", $edition);
                  printf("</td></tr>\n");
                  // Library Location / Call number
                  printf("<td colspan = \"1\" valign=\"top\">\n");
-                 printf("<strong>Library Location and Call No.:</strong> ");
+                 printf("<b>Library Location and Call No.:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
                  printf("<textarea rows=\"4\" cols = \"50\" name = \"call_no\">\n");
                  printf($call_no);
                  printf("</textarea></td></tr>\n");
                  // Catalog Number
                  printf("<tr><td colspan = \"1\" >\n");
-                 printf("<strong>Aleph No.:</strong> ");
+                 printf("<b>Catalog No.:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<input type = \"text\" name = \"cat_num\" size = \"25\" value = \"%s\" >", $cat_num);
+                 printf("<input type = \"text\" name = \"cat_num\" size = \"25\" value = \"%s\" >\n", $cat_num);
                  printf("</td></tr>\n");
                  // Master subject
                  if ($mastersubject_id > 1 && $mastersubject_id != 2) {
-                         $mastersubject = lookupField($con, "mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");
+                         $mastersubject = lookupField("mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");
                          printf("<tr><td colspan =\"1\" >\n");
-                         printf("<strong>Master subject:</strong> ");
+                         printf("<b>Master subject:</b>\n");
                          printf("</td><td colspan =\"3\">\n");
                          printf("%s", $mastersubject);
                          printf("</td></tr>\n");
-Line 2054 
 function formResource($con, $key_id, $ma
+Line 2516 
 function formResource($con, $key_id, $ma
                  // Masterinfotype
                  if ($masterinfotype_id > 1) {
                          printf("<tr><td colspan = \"1\" >\n");
-                         printf("<strong>Master Information Type:</strong> ");
+                         printf("<b>Master Information Type:</b>\n");
                          printf("</td><td colspan =\"3\">\n");
-                         $masterinfotype = lookupField($con, "masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype");
+                         $masterinfotype = lookupField("masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype");
                          printf("%s", $masterinfotype);
                          printf("</td></tr>\n");
                  }
                  // Drop down box for default information type
                  printf("<td colspan = \"1\" >\n");
-                 printf("<strong>Base Information Type:</strong>");
+                 printf("<b>Base Information Type:</b>\n");
                  printf("</td><td colspan =\"3\">\n");
-                 printf("<select name = \"infotype_id\" >");
+                 printf("<select name = \"infotype_id\" >\n");
                  $limit = " WHERE infotype_id >= 0 ";
-Line 2079 
 function formResource($con, $key_id, $ma
+Line 2541 
 function formResource($con, $key_id, $ma
                      $limit .= " AND (masterinfotype_id < 2 OR masterinfotype_id = " . $masterinfotype_id . ")";
                  }
-                 dropDownFieldSelected($con, "infotype", "infotype", "infotype_id", $limit, $infotype_id);
+                 dropDownFieldSelected("infotype", "infotype", "infotype_id", $limit, $infotype_id);
                  printf("</select>");
                  printf("</td></tr>\n");
+                 // Vendor
+                 printf("<tr><td colspan=\"1\">\n");
+                 printf("<b>Vendor:</b>\n");
+                 printf("</td>\n");
+                 printf("<td colspan=\"2\">\n");
+                 printf("<select name = \"vendor_id\" >\n");
+                 dropDownFieldSelected("vendor", "vendor", "vendor_id", " WHERE vendor_id > 0", $vendor_id);
+                 printf("</select>\n");
+                 printf("</td></tr>\n");
+                 // Status toggle
+                 $up_toggle = "";
+                 $down_toggle = "";
+                 $alert_toggle = "";
+                 if ($resource_status < 1) $up_toggle = " CHECKED ";
+                 else if ($resource_status == 1) $down_toggle = " CHECKED ";
+                 else if ($resource_status == 2) $alert_toggle = " CHECKED ";
+                 printf("<tr><td colspan=\"1\">\n");
+                 printf("<b>Resource Status:</b>\n");
+                 printf("</td>\n");
+                 printf("<td colspan=\"3\">\n");
+                 printf("<b>Up</b> <input type=\"radio\" name =\"resource_status\" value=\"0\" %s>\n", $up_toggle);
+                 printf("<b>Down</b> <input type=\"radio\" name =\"resource_status\" value=\"1\" %s>\n", $down_toggle);
+                 printf("<b>Alert</b> <input type=\"radio\" name =\"resource_status\" value=\"2\" %s>\n", $alert_toggle);
+                 printf("</td></tr>\n");
+                 // Down/alert message
+                 printf("<tr><td colspan=\"1\">\n");
+                 printf("<b>Down/Alert Message:</b>\n");
+                 printf("</td>\n");
+                 printf("<td colspan=\"3\">\n");
+                 printf("<input type =\"text\" size=\"60\" name =\"resource_message\" value=\"%s\">\n", $resource_message);
+                 printf("</td></tr>\n");
                  // Annotation
                  printf("<tr><td colspan = \"4\">\n");
-                 printf("<br><strong><a name=\"additional\">Annotation</a>:</strong><br>");
+                 printf("<br><b><a name=\"additional\">Annotation</a>:</b><br>\n");
-                 printf("<textarea name = \"annotation\" rows = \"5\" cols = \"51\" >");
+                 printf("<textarea name = \"annotation\" rows = \"6\" cols = \"70\" >\n");
                  printf("%s", $annotation);
                  printf("</textarea><br><br><br>\n");
-Line 2095 
 function formResource($con, $key_id, $ma
+Line 2590 
 function formResource($con, $key_id, $ma
                  // If this is an existing resource
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateResource\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateResource\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Resource\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Resource\" >\n");
-                         printf("<input type = \"Hidden\" name = \"key_id\" value = \"%d\" > ", $key_id);
+                         printf("<input type = \"Hidden\" name = \"key_id\" value = \"%d\" >\n", $key_id);
                  }
                  // A new resource
                  else {
-                         printf("<input type = \"Hidden\" name = \"mastersubject_id\" value = \"%d\" > ", $mastersubject_id);
+                         printf("<input type = \"Hidden\" name = \"mastersubject_id\" value = \"%d\" >\n", $mastersubject_id);
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertResource\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertResource\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Resource\" > ");
+                         printf("<input type = \"Submit\" value = \"Save New Resource\" >\n");
                  }
                  // Common button
-Line 2119 
 function formResource($con, $key_id, $ma
+Line 2614 
 function formResource($con, $key_id, $ma
                  // Other forms - only if editing an existing resource
                  if ($key_id > 0) {
-                         formAssignResLoc($con, $key_id);
+                         formAssignResLoc($key_id);
-                         formAssignResFeature($con, $key_id);
+                         formAssignResFeature($key_id);
-                         formAssignResMastersubject($con, $key_id);
+                         formAssignResMastersubject($key_id);
                          // Offer a delete resource button
-                         printf("<BR>");
+                         printf("<BR>\n");
                          printf("<form method=\"POST\" action=\"delete.phtml\">\n");
                          printf("<input type=\"Hidden\" name=\"transaction\" value=\"deleteResourceConfirm\">\n");
                          printf("<input type=\"Hidden\" name=\"resource_id\" value=\"%d\">\n", $key_id);
-Line 2139 
 function formResource($con, $key_id, $ma
+Line 2634 
 function formResource($con, $key_id, $ma
  /**********************************************************
  Function: formService
  Author: Paul Bramscher
- Last Modified: 07.02.2003
+ Last Modified: 03.16.2004
  ***********************************************************
  Draws an HTML form to edit the supplied service id, or to
  create a new service if the incoming id is less than 1.
  **********************************************************/
- function formService($con, $key_id) {
+ function formService($key_id) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if service actually exists
-         $exists = existsRow($con, "service", "service_id", $key_id);
+         $exists = existsRow("service", "service_id", $key_id);
          // Header
          printf("<center>");
-Line 2171 
 function formService($con, $key_id) {
+Line 2666 
 function formService($con, $key_id) {
                  // Fetch existing values
                  $sql = "SELECT * from service where service_id = " . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array ($rs);
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
                  $service_id = $row["service_id"];
                  $service = $row["service"];
                  $serviceURL = $row["serviceURL"];
-Line 2199 
 function formService($con, $key_id) {
+Line 2694 
 function formService($con, $key_id) {
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Service #%d Not Found</h3>", $key_id);
+                 printf("<h3>Service (ID# %d) Not Found</h3>\n", $key_id);
          }
          // If no problems, then go for landing
-Line 2210 
 function formService($con, $key_id) {
+Line 2705 
 function formService($con, $key_id) {
                  // If new insert
                  if ($key_id <1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Service");
                          printf("</td></tr>\n");
-Line 2218 
 function formService($con, $key_id) {
+Line 2713 
 function formService($con, $key_id) {
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Edit Service: %s (#%d)", $service, $service_id);
+                         printf("Edit Service: %s (ID# %d)", $service, $service_id);
                          printf("</td></tr>\n");
                  }
-Line 2234 
 function formService($con, $key_id) {
+Line 2729 
 function formService($con, $key_id) {
                  // Description
                  printf("<tr>\n");
                  printf("<td colspan=\"2\"><b>Description:</b><br>\n");
-                 printf("<textarea name = \"serviceDescr\" rows = \"5\" cols = \"70\" >");
+                 printf("<textarea name = \"serviceDescr\" rows = \"5\" cols = \"70\" >\n");
                  printf("%s", $serviceDescr);
                  printf("</textarea><br>\n");
                  printf("</td></tr>\n");
-Line 2242 
 function formService($con, $key_id) {
+Line 2737 
 function formService($con, $key_id) {
                  // URL
                  printf("<tr>\n");
                  printf("<td><b>Service URL:</b></td>\n");
-                 printf("<td><input type = \"text\" name = \"serviceURL\" size = \"50\" value = \"%s\" ></td>",
+                 printf("<td><input type = \"text\" name = \"serviceURL\" size = \"50\" value = \"%s\" ></td>\n",
                          $serviceURL);
                  printf("</tr>\n");
-Line 2297 
 function formService($con, $key_id) {
+Line 2792 
 function formService($con, $key_id) {
                  printf("<tr>\n");
                  printf("<td><b>Open to Nonaffiliated Users?</b></td>\n");
-                 printf("<td>Yes <input type = \"radio\" name = \"nonaff\" value = \"1\" %s> ", $nonaff_yes);
+                 printf("<td>Yes <input type = \"radio\" name = \"nonaff\" value = \"1\" %s>\n", $nonaff_yes);
                  printf("No <input type = \"radio\" name = \"nonaff\" value = \"0\" %s></td>\n", $nonaff_no);
                  printf("</tr>\n");
-Line 2305 
 function formService($con, $key_id) {
+Line 2800 
 function formService($con, $key_id) {
                  printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
                  // If this is an existing service
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateService\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateService\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Service\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Service\" >\n");
-                         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" > ", $service_id);
+                         printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >\n", $service_id);
                  }
                  // Editing a new service
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertService\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertService\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Service\" > ");
+                         printf("<input type = \"Submit\" value = \"Save New Service\" >\n");
                  }
                  // Common button
-Line 2325 
 function formService($con, $key_id) {
+Line 2820 
 function formService($con, $key_id) {
                  // Change service-location assignments
                  if ($service_id > 0) {
-                         formAssignServServtype($con, $service_id);
+                         formAssignServServtype($service_id);
-                         formAssignServLoc($con, $service_id);
+                         formAssignServLoc($service_id);
                  }
                  printf("<BR>\n");
-Line 2338 
 function formService($con, $key_id) {
+Line 2833 
 function formService($con, $key_id) {
  /**********************************************************
  Function: formStyle
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.16.2004
  ***********************************************************
  Draws an HTML form to edit the supplied style id, or to
  create a new style if the incoming id is less than 1.
-Line 2349 
 whether the supplied values for filename
+Line 2844 
 whether the supplied values for filename
  proper permissions.  This must be done separately by
  someone with OS access.
  **********************************************************/
- function formStyle($con, $key_id) {
+ function formStyle($key_id) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if feature actually exists
-         $exists = existsRow($con, "style", "style_id", $key_id);
+         $exists = existsRow("style", "style_id", $key_id);
          // Header
          printf("<center>");
-Line 2367 
 function formStyle($con, $key_id) {
+Line 2862 
 function formStyle($con, $key_id) {
                  // Fetch existing values
                  $sql = "SELECT * from style where style_id = " . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array ($rs);
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
                  $style_id = $row["style_id"];
                  $style_title = $row["style_title"];
                  $header_file = $row["header_file"];
-Line 2385 
 function formStyle($con, $key_id) {
+Line 2880 
 function formStyle($con, $key_id) {
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Style #%d Not Found</h3>", $key_id);
+                 printf("<h3>Style (ID# %d) Not Found</h3>\n", $key_id);
          }
          // If no problems, then go for landing
-Line 2396 
 function formStyle($con, $key_id) {
+Line 2891 
 function formStyle($con, $key_id) {
                  // If new insert
                  if ($key_id <1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Style");
                          printf("</td></tr>\n");
-Line 2404 
 function formStyle($con, $key_id) {
+Line 2899 
 function formStyle($con, $key_id) {
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Edit Style: %s (#%d)", $style, $style_id);
+                         printf("Edit Style: %s (ID# %d)", $style_title, $style_id);
                          printf("</td></tr>\n");
                  }
-Line 2438 
 function formStyle($con, $key_id) {
+Line 2933 
 function formStyle($con, $key_id) {
                  printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
                  // If this is an existing style
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateStyle\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateStyle\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Style\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Style\" >\n");
-                         printf("<input type = \"Hidden\" name = \"style_id\" value = \"%d\" > ", $style_id);
+                         printf("<input type = \"Hidden\" name = \"style_id\" value = \"%d\" >\n", $style_id);
                  }
                  // Editing a new style
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertStyle\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertStyle\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Style\"> ");
+                         printf("<input type = \"Submit\" value = \"Save New Style\">\n");
                  }
                  // Common button
-Line 2460 
 function formStyle($con, $key_id) {
+Line 2955 
 function formStyle($con, $key_id) {
  /**********************************************************
+ Function: formStaff
+ Author: Paul Bramscher
+ Last Modified: 03.16.2004
+ ***********************************************************
+ Purpose:
+ Form to create a new staff person, or update the existing
+ staff id.
+ **********************************************************/
+ function formStaff($staff_id){
+         // Initialize variables
+         $staff_id = (int) $staff_id;
+         $last_name ="";
+         $first_name = "";
+         $staff_account = "";
+         $staff_email = "";
+         $password = "";
+         $access = "";
+         $access_id = 1;
+         // If editing an existing staff member load previous values
+         if ($staff_id > 1){
+                 $sql = "SELECT
+                         s.first_name,
+                         s.last_name,
+                         s.staff_account,
+                         s.staff_email,
+                         s.access_id,
+                         t.stafftitle,
+                         t.stafftitle_id,
+                         a.access_id,
+                         a.access_level,
+                         a.access
+                         FROM staff s, access a, stafftitle t
+                         WHERE
+                         s.access_id = a.access_id AND
+                         s.stafftitle_id = t.stafftitle_id AND
+                         staff_id=" . $staff_id;
+                 $rs = xx_tryquery($sql);
+                 $row = xx_fetch_array($rs, xx_ASSOC);
+                 // Fetch results
+                 $first_name = Trim($row["first_name"]);
+                 $last_name = Trim($row["last_name"]);
+                 $staff_account = Trim($row["staff_account"]);
+                 $staff_email = Trim($row["staff_email"]);
+                 $access = Trim($row["access"]);
+                 $access_id = Trim($row["access_id"]);
+                 $stafftitle = Trim($row["stafftitle"]);
+                 $stafftitle_id = Trim($row["stafftitle_id"]);
+                 // Run strings through the HTML cleaner for output
+                 $first_name = textOutHTML($first_name);
+                 $last_name = textOutHTML($last_name);
+                 $staff_account = textOutHTML($staff_account);
+         }
+         // Table definition
+         printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
+         // If new insert
+         if ($staff_id <1) {
+                 printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
+                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+                 printf("Enter New Staff Person");
+                 printf("</td></tr>\n");
+         }
+         // Else update
+         else {
+                 printf("<form method = \"POST\" action = \"update.phtml\" >\n");
+                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+                 printf("Edit Staff Person: %s %s (ID# %d)", $first_name, $last_name, $staff_id);
+                 printf("</td></tr>\n");
+         }
+         // Last name
+         printf("<tr>\n");
+         printf("<td><b>Last Name:</b></td>\n");
+         printf("<td><input type = \"text\" name = \"last_name\" size = \"40\" value = \"%s\" ></td>\n", $last_name);
+         printf("</tr>\n");
+         // First name
+         printf("<tr>\n");
+         printf("<td><b>First Name:</b></td>\n");
+         printf("<td><input type = \"text\" name = \"first_name\" size = \"30\" value = \"%s\"></td>\n", $first_name);
+         printf("</tr>\n");
+         // staff account - must be unique, may match against staff_account
+         printf("<tr>\n");
+         printf("<td><b>Staff Account (x500 if applicable, 20 char max.):</b></td>\n");
+         printf("<td><input type = \"text\" name = \"staff_account\" size = \"20\" value =\"%s\"></td>\n", $staff_account);
+         printf("</tr>\n");
+         // Staff email - whether or not x500 authentication is used
+         printf("<tr>\n");
+         printf("<td><b>Staff E-Mail:</b></td>\n");
+         printf("<td><input type = \"text\" name = \"staff_email\" size = \"50\" value =\"%s\"></td>\n", $staff_email);
+         printf("</tr>\n");
+         // Title
+         printf("<tr>\n");
+         printf("<td><b>Job Title:</b></td>\n");
+         printf("<td><select name = \"stafftitle_id\">\n");
+         dropDownFieldSelected("stafftitle", "stafftitle", "stafftitle_id", "WHERE stafftitle_id > 0", $stafftitle_id);
+         printf("</select></td>\n");
+         printf("</tr>\n");
+         // Access
+         printf("<tr>\n");
+         printf("<td><b>Access Level:</b></td>\n");
+         printf("<td><select name = \"access_id\">\n");
+         dropDownFieldSelected("access", "access", "access_id", "WHERE access_id > 0", $access_id);
+         printf("</select></td>\n");
+         printf("</tr>\n");
+         // Buttons
+         printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
+         // If new staff
+         if ($staff_id < 2) {
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertStaff\" >\n");
+                 printf("<input type = \"Submit\" value = \"Save New Staff\" >\n");
+         }
+         // Editing an existing staffperson
+         else {
+                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateStaff\" >\n");
+                 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
+                 printf("<input type = \"Submit\" value = \"Save Staff Changes\" >\n");
+         }
+         printf("<input type = \"Reset\" value = \"Reset\" >\n");
+         // Close the form and table
+         printf("</form>\n");
+         printf("</td></tr></table>\n");
+         // If editing existing staff, draw other forms
+         if ($staff_id > 0) {
+                 formPassword($staff_id);
+                 formAssignStaffLibunit($staff_id);
+                 formAssignStaffSub($staff_id);
+         }
+         printf("</center><br>\n");
+ }
+ /**********************************************************
  Function: formSubject
  Author: Paul Bramscher
- Last Modified: 06.25.2003
+ Last Modified: 03.15.2004
  ***********************************************************
  Draws an HTML form to edit the supplied subject id, or to
  create a new subject if the incoming id is less than 1.
  **********************************************************/
- function formSubject($con, $key_id) {
+ function formSubject($key_id) {
          // Cast as integer to be sure
          $key_id = (int) $key_id;
          // Check to see if location actually exists
-         $exists = existsRow($con, "subject", "subject_id", $key_id);
+         $exists = existsRow("subject", "subject_id", $key_id);
          // Header
          printf("<center>");
-Line 2486 
 function formSubject($con, $key_id) {
+Line 3133 
 function formSubject($con, $key_id) {
                  // If the user is editing an existing record, fetch previous values
                  $sql = "SELECT * from subject where subject_id = " . $key_id;
-                 $rs = xx_query($sql, $con);
+                 $rs = xx_tryquery($sql);
-                 $row = xx_fetch_array ($rs);
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
                  // Fetch existing values
                  $subject_id = $row["subject_id"];
-Line 2502 
 function formSubject($con, $key_id) {
+Line 3149 
 function formSubject($con, $key_id) {
          // Houston, we have a problem
          if ($key_id > 0 && $exists == 0) {
                  $problem = 1;
-                 printf("<h3>Subject #%d Not Found</h3>", $key_id);
+                 printf("<h3>Subject (ID# %d) Not Found</h3>\n", $key_id);
          }
          // If no problems, then go for landing
-Line 2513 
 function formSubject($con, $key_id) {
+Line 3160 
 function formSubject($con, $key_id) {
                  // If new insert
                  if ($key_id <1) {
-                         printf("<form method = \"POST\" action = \"insert.phtml\" >");
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
                          printf("Enter New Subject");
                          printf("</td></tr>\n");
-Line 2521 
 function formSubject($con, $key_id) {
+Line 3168 
 function formSubject($con, $key_id) {
                  // Else update
                  else {
-                         printf("<form method = \"POST\" action = \"update.phtml\" >");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
                          printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                         printf("Update Subject: %s (#%d)", $subject, $subject_id);
+                         printf("Edit Subject: %s (ID# %d)", $subject, $subject_id);
                          printf("</td></tr>\n");
                  }
                  // Subject
                  printf("<tr><td>\n");
-                 printf("<b>Subject:</b>");
+                 printf("<b>Subject:</b>\n");
                  printf("</td>\n");
                  printf("<td>\n");
-                 printf("<input type = \"text\" name = \"subject\" size = \"65\" value = \"%s\" >", $subject);
+                 printf("<input type = \"text\" name = \"subject\" size = \"65\" value = \"%s\" >\n", $subject);
                  printf("</td></tr>\n");
                  // Primary location
                  printf("<tr>\n");
                  printf("<td><b>Primary Location:</b></td>\n");
                  printf("<td>\n");
-                 printf("<select name = \"sublocation_id\">");
+                 printf("<select name = \"sublocation_id\">\n");
-                 dropDownFieldSelected($con, "location", "location", "location_id", "WHERE location_id > 0", $sublocation_id);
+                 dropDownFieldSelected("location", "location", "location_id", "WHERE location_id > 0", $sublocation_id);
                  printf("</select>\n");
                  printf("</td></tr>\n");
-Line 2548 
 function formSubject($con, $key_id) {
+Line 3195 
 function formSubject($con, $key_id) {
                  printf("<tr>\n");
                  printf("<td colspan=\"2\">\n");
                  printf("<b>Description:</b><br>");
-                 printf("<textarea name = \"subject_descr\" rows = \"5\" cols = \"65\" >");
+                 printf("<textarea name = \"subject_descr\" rows = \"5\" cols = \"65\" >\n");
                  printf("%s", $subject_descr);
                  printf("</textarea></td></tr>\n");
-Line 2557 
 function formSubject($con, $key_id) {
+Line 3204 
 function formSubject($con, $key_id) {
                  // If this is an existing subject
                  if ($key_id > 0) {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateSubject\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateSubject\" >\n");
-                         printf("<input type = \"Submit\" value = \"Update Subject\" > ");
+                         printf("<input type = \"Submit\" value = \"Update Subject\" >\n");
-                         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" > ", $subject_id);
+                         printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >\n", $subject_id);
                  }
                  // Editing a new subject
                  else {
-                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertSubject\" > ");
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertSubject\" >\n");
-                         printf("<input type = \"Submit\" value = \"Save New Subject\" > ");
+                         printf("<input type = \"Submit\" value = \"Save New Subject\" >\n");
                  }
                  // Common button
-Line 2577 
 function formSubject($con, $key_id) {
+Line 3224 
 function formSubject($con, $key_id) {
                  // Change subject-location assignments
                  if ($subject_id > 0) {
-                         formAssignSubMaster($con, $subject_id);
+                         formAssignSubMaster($subject_id);
-                         formAssignSubLoc($con, $subject_id);
+                         formAssignSubLoc($subject_id);
-                         formAssignSubStaff($con, $subject_id);
+                         formAssignSubStaff($subject_id);
-                         formAssignSubCoursesub($con, $subject_id);
+                         formAssignSubCoursesub($subject_id);
                  }
          } // No problems
-Line 2589 
 function formSubject($con, $key_id) {
+Line 3236 
 function formSubject($con, $key_id) {
  }
  /**********************************************************
- Function: formAssignLibunitStaff
+ Function: formVendor
  Author: Paul Bramscher
- Last Modified: 07.03.2003
+ Last Modified: 03.16.2004
  ***********************************************************
  Purpose:
- Assigns staff (possibly multiple) to a given library unit.
+ Draws an HTML form to edit the supplied vendor id, or to
- **********************************************************/
+ create a new vendor if the incoming id is less than 1.
- function formAssignLibunitStaff($con, $libunit_id){
+ **********************************************************/
+ function formVendor($key_id) {
-         // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\" bgcolor =\"#ffffff\" >");
-         // Form
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
-         printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >", $libunit_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignLibunitStaff\" >");
-         // Available staff
-         // Omit the '(N/A)' staff
-         $omit_string = "WHERE staff_id > 1";
-         // Omit any pre-selected staff in libunit_staff
-         $in_string = getNotIn($con, "staff_id", "libunit_id", $libunit_id, "libunit_staff");
-         if (strlen($in_string) > 0) $omit_string .= " AND staff_id NOT IN " . $in_string;
-         // Draw the box
-         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-         printf("Assign Staff to Library Unit");
-         printf("</td></tr>\n");
-         printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Staff:<br></strong>\n");
-         printf("<select name = \"staff_id_array[]\" multiple size = \"5\" >");
-         dropDownStaffOmit($con, $omit_string);
-         printf("</select><br><br>");
-         // Close off form
-         printf("<center>");
-         printf("<input type = \"Submit\" value = \" >> \" >");
-         printf("</form>");
-         printf("</center>");
-         printf("</td>");
-         // Current staff
-         printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
-         printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >", $libunit_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteLibunitStaff\" >");
-         printf("<br><strong>Selected Staff:</strong><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
-         $sql = "SELECT s.staff_id, s.last_name, s.first_name FROM
-                 staff s,
-                 libunit_staff ls
-                 WHERE
-                 ls.libunit_id = " . $libunit_id . " AND
-                 s.staff_id = ls.staff_id
-                 ORDER BY last_name, first_name";
-         // Fetch the values
-         $rs = xx_query($sql, $con);
-         while ($row = xx_fetch_array ($rs)) {
-                 $first_name = $row["first_name"];
-                 $last_name = $row["last_name"];
-                 $staff_id = $row["staff_id"];
-                 printf("<option value = \"%d\">%s, %s</option>", $staff_id, $last_name, $first_name);
-         }
-         printf("</select><br><br>");
-         printf("<center>");
-         printf("<input type = \"Submit\" value =\" << \">");
-         printf("</center>");
-         printf("</form>");
-         printf("</td></tr>");
-         // Close off table
-         printf("</td></tr></table>");
- }
+         // Cast as integer to be sure
+         $key_id = (int) $key_id;
+         // Check to see if vendor actually exists
+         $exists = existsRow("vendor", "vendor_id", $key_id);
- /**********************************************************
+         // Header
- Function: formAssignStaffLibunit
- Author: Paul Bramscher
- Last Modified: 07.03.2003
- ***********************************************************
- Purpose:
- Assigns library units (possibly multiple) to a given
- staffperson.
- **********************************************************/
- function formAssignStaffLibunit($con, $staff_id){
-         // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
-         // Form
-         printf("<form method = \"POST\" action = \"assign.phtml\" >");
-         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignStaffLibunit\" >");
-         // Available libunits
-         // Omit the '(N/A)' libunit
-         $omit_string = "WHERE libunit_id > 1";
-         // Omit any pre-selected libunits in libunit_staff
-         $in_string = getNotIn($con, "libunit_id", "staff_id", $staff_id, "libunit_staff");
-         if (strlen($in_string) > 0) $omit_string .= " AND libunit_id NOT IN " . $in_string;
-         // Draw the box
-         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-         printf("Assign Library Unit to Staff");
-         printf("</td></tr>\n");
-         printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Library Unit(s):<br></strong>\n");
-         printf("<select name = \"libunit_id_array[]\" multiple size = \"5\" >");
-         dropDownFieldOmit($con, "libunit", "libunit", "libunit_id", $omit_string);
-         printf("</select><br><br>");
-         // Close off form
          printf("<center>");
-         printf("<input type = \"Submit\" value = \" >> \" >");
+         if ($key_id > 0 && $exists == 1) {
-         printf("</form>");
-         printf("</center>");
-         printf("</td>");
-         // Current libunits
-         printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >");
-         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteStaffLibunit\" >");
-         printf("<br><strong>Selected Library Unit(s):</strong><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>");
-         $sql = "SELECT l.libunit, l.libunit_id FROM
-                 staff s,
-                 libunit_staff ls,
-                 libunit l
-                 WHERE
-                 s.staff_id = " . $staff_id . " AND
-                 ls.staff_id = s.staff_id AND
-                 ls.libunit_id = l.libunit_id
-                 ORDER BY l.libunit";
-         // Fetch the values
-         $rs = xx_query($sql, $con);
-         while ($row = xx_fetch_array ($rs)) {
-                 $libunit = $row["libunit"];
-                 $libunit_id = $row["libunit_id"];
-                 printf("<option value = \"%s\">%s</option>", $libunit_id, $libunit);
-         }
-         printf("</select><br><br>");
-         printf("<center>");
-         printf("<input type = \"Submit\" value =\" << \">");
-         printf("</center>");
-         printf("</form>");
-         printf("</td></tr>");
-         // Close off table
-         printf("</td></tr></table>");
- }
- /**********************************************************
- Function: formAssignStaffSub
- Author: Paul Bramscher
- Last Modified: 08.26.2003
- ***********************************************************
- Purpose:
- Assigns subjects (possibly multiple) to a given
- staffperson.
- **********************************************************/
- function formAssignStaffSub($con, $staff_id){
-         // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
-         // Form
-         printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignStaffSub\" >\n");
-         // Available subjects
-         // Omit the '(N/A)' subject
-         $omit_string = "WHERE subject_id > 1";
-         // Omit any pre-selected subjects in sub_staff
-         $in_string = getNotIn($con, "subject_id", "staff_id", $staff_id, "sub_staff");
-         if (strlen($in_string) > 0) $omit_string .= " AND subject_id NOT IN " . $in_string;
-         // Draw the box
-         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-         printf("Assign Subjects");
-         printf("</td></tr>\n");
-         printf("<tr><td valign = \"top\" >\n");
-         printf("<br><strong>Available Subject(s):<br></strong>\n");
-         printf("<select name = \"subject_id_array[]\" multiple size = \"5\" >\n");
-         dropDownFieldOmit($con, "subject", "subject", "subject_id", $omit_string);
-         printf("</select><br><br>\n");
-         // Close off form
-         printf("<center>\n");
-         printf("<input type = \"Submit\" value = \" >> \" >\n");
-         printf("</form>\n");
-         printf("</center>\n");
-         printf("</td>\n");
-         // Current subjects
-         printf("<td valign = \"top\" >\n");
-         printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
-         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteStaffSub\" >\n");
-         printf("<br><strong>Selected Subject(s):</strong><br>\n");
-         printf("<select name =\"key_list_array[]\" multiple size = 5>\n");
-         $sql = "SELECT s.subject, s.subject_id FROM
-                 staff t,
-                 sub_staff st,
-                 subject s
-                 WHERE
-                 t.staff_id = " . $staff_id . " AND
-                 st.staff_id = t.staff_id AND
-                 st.subject_id = s.subject_id
-                 ORDER BY s.subject";
-         // Fetch the values
-         $rs = xx_query($sql, $con);
-         while ($row = xx_fetch_array ($rs)) {
-                 $subject = $row["subject"];
-                 $subject_id = $row["subject_id"];
-                 printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject);
-         }
-         printf("</select><br><br>\n");
-         printf("<center>\n");
-         printf("<input type = \"Submit\" value =\" << \">\n");
-         printf("</center>\n");
-         printf("</form>\n");
-         printf("</td></tr>\n");
-         // Close off table
-         printf("</td></tr></table>\n");
- }
- /**********************************************************
- Function: formLibunit
- Author: Paul Bramscher
- Last Modified: 07.03.2003
- ***********************************************************
- Purpose:
- Handles the creation of new (or editing of existing)
- library units.
- **********************************************************/
- function formLibunit($con, $key_id){
-         // Initialize variables
-         $libunit_id = (int) $key_id;
-         $libunit ="";
-         $libunit_abbrev = "";
-         // If editing an existing library unit load previous values
-         if ($libunit_id > 1){
-                 $sql = "SELECT
-                         l.libunit,
-                         l.libunit_abbrev,
-                         l.head_staff_id
-                         FROM libunit l
-                         WHERE
-                         libunit_id = " . $libunit_id;
-                 $rs = xx_query($sql, $con);
-                 $row = xx_fetch_array($rs);
-                 // Fetch values
+                 // Initialization
-                 $libunit = Trim($row["libunit"]);
+                 $vendor_id = "";
-                 $libunit_abbrev = Trim($row["libunit_abbrev"]);
+                 $vendor = "";
-                 $head_staff_id = $row["head_staff_id"];
+                 $vendor_descr = "";
+                 $vendor_status = "";
+                 $vendor_message = "";
-                 // Run strings through the HTML cleaner for output
-                 $libunit = textOutHTML($libunit);
-                 $libunit_abbrev = textOutHTML($libunit_abbrev);
-         }
-         // Table definition
-         printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
-         // If new insert
-         if ($key_id <1) {
-                 printf("<form method = \"POST\" action = \"insert.phtml\" >");
-                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                 printf("Enter New Library Unit");
-                 printf("</td></tr>\n");
-         }
-         // Else update
-         else {
-                 printf("<form method = \"POST\" action = \"update.phtml\" >");
-                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                 printf("Edit Library Unit: %s (#%d)", $libunit, $libunit_id);
-                 printf("</td></tr>\n");
-         }
-         // Libunit
-         printf("<td><b>Library Unit:</b></td>\n");
-         printf("<td><input type = \"text\" name = \"libunit\" size = \"60\" value = \"%s\" ></td>\n", $libunit);
-         printf("</td></tr>");
-         // Libunit abbrev.
-         printf("<tr>\n");
-         printf("<td><b>Abbreviation:</b></td>\n");
-         printf("<td><input type = \"text\" name = \"libunit_abbrev\" size = \"20\" value = \"%s\"></td>\n", $libunit_abbrev);
-         printf("</tr>\n");
-         // Libunit lead
-         printf("<tr>\n");
-         printf("<td><b>Unit Lead:</b></td>\n");
-         printf("<td><select name = \"head_staff_id\" >");
-         dropDownStaffSelected($con, $head_staff_id);
-         printf("</select></td>\n");
-         printf("</tr>\n");
-         // Buttons
-         printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
-         // If new libunit
+                 // Fetch existing values
-         if ($libunit_id < 2) {
+                 $sql = "SELECT * FROM vendor WHERE vendor_id = " . $key_id;
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertLibunit\" >");
+                 $rs = xx_tryquery($sql);
-                 printf("<input type = \"Submit\" value = \"Save New Library Unit\" > ");
+                 $row = xx_fetch_array ($rs, xx_ASSOC);
-         }
+                 $vendor_id = $row["vendor_id"];
-         // Editing an existing libunit
+                 $vendor = $row["vendor"];
-         else {
+                 $vendor_descr = $row["vendor_descr"];
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateLibunit\" >");
+                 $vendor_status = $row["vendor_status"];
-                 printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >", $libunit_id);
+                 $vendor_message = $row["vendor_message"];
-                 printf("<input type = \"Submit\" value = \"Save Library Unit Changes\" > ");
-         }
-         printf("<input type = \"Reset\" value = \"Reset\" >");
-         // Close the form and table
-         printf("</form>");
-         printf("</td></tr></table>");
-         // Other forms - only if editing an existing libunit
-         if ($libunit_id > 0) {
-                 formAssignLibunitStaff($con, $libunit_id);
-         }
-         printf("</center><br>");
- }
- /**********************************************************
- Function: formPassword
- Author: Paul Bramscher
- Last Modified: 07.03.2003
- ***********************************************************
- Purpose:
- Creates a new password for the supplied staff id.  Note
- that this is a locally stored (in mySQL) and encrypted
- password.  It is never visible in plaintext, nor is it
- ever brought to an HTML form, neither in plaintext nor
- in a "password" type HTML form field.
- **********************************************************/
- function formPassword($con, $staff_id){
-         /*****************************************
-         ** If using native mySQL authentication **
-         *****************************************/
-         // Table definition
-         printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">");
-         // Form
-         printf("<form method = \"POST\" action = \"update.phtml\" >");
-         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-         printf("Local Authentication Password - See Note Below");
-         printf("</td></tr>\n");
-         // Staff password - for mySQL authentication only.  Ignored if x500 account is present.
-         printf("<tr><td colspan=\"2\">\n");
-         printf("<b>Note:</b> Supply if utilizing mySQL authentication, otherwise leave blank. ");
-         printf("This will replace the password (if any) currently assigned to this account.");
-         printf("</td></tr>\n");
-         // First type
-         printf("<tr>\n");
-         printf("<td><b>New Password (6 char. minimum):</b></td>\n");
-         printf("<td><input type = \"password\" name = \"password\" size = \"25\"></td>\n");
-         printf("</tr>\n");
-         // Confirm type
-         printf("<tr>\n");
-         printf("<td><b>Confirm password (type again):</b></td>\n");
-         printf("<td><input type = \"password\" name = \"password_confirm\" size = \"25\"></td>\n");
-         printf("</tr>\n");
-         // Buttons
-         printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
-         printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
-         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updatePassword\" >\n");
-         printf("<input type = \"Submit\" value = \"Save Local Password\" > ");
-         // Close the form and table
-         printf("</form>\n");
-         printf("</td></tr></table>\n");
-         /*******************************************
-         ** Determine if a password already exists **
-         *******************************************/
-         // Initialize variables
-         $pass_set = 0;
-         // Determine whether a password exists
-         $sql = "SELECT COUNT(*) as pass_set
-                 FROM staff s
-                 WHERE s.password IS NOT NULL and staff_id = " . $staff_id;
-         $rs = xx_query($sql, $con);
-         $row = xx_fetch_array($rs);
-         // Fetch values
-         $pass_set = Trim($row["pass_set"]);
-         // If some password already exists, offer this form
-         if ($pass_set > 0) {
-                 // Table definition
-                 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">");
-                 // Form
-                 printf("<tr><td class=\"cellPlain\">");
-                 printf("Local Password Found");
-                 printf("</td></tr>\n");
-                 printf("<form method = \"POST\" action = \"update.phtml\" >");
-                 // Purge existing password
-                 printf("<tr><td>\n");
-                 printf("<br><b>Purge password to null?</b><br><br>\n");
-                 printf("<b>Note:</b> It appears that this account currently has a password assigned to it.");
-                 printf("This option will clear out any existing password, and leave the value NULL.");
-                 printf("The staffperson may not login until a new password is supplied.<br><br>\n");
-                 // Buttons
-                 printf("<center>\n");
-                 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"purgePassword\" >");
-                 printf("<input type = \"Submit\" value = \"Purge Password!\" > ");
-                 // Close the form and table
-                 printf("</form>");
-                 printf("</center></td></tr></table><br>\n");
-         } // end password purge form
- } // end function
- /**********************************************************
- Function: formStaff
- Author: Paul Bramscher
- Last Modified: 07.03.2003
- ***********************************************************
- Purpose:
- Form to create a new staff person, or update the existing
- staff id.
- **********************************************************/
- function formStaff($con, $staff_id){
-         // Initialize variables
-         $staff_id = (int) $staff_id;
-         $last_name ="";
-         $first_name = "";
-         $staff_account = "";
-         $staff_email = "";
-         $password = "";
-         $access = "";
-         $access_id = 1;
-         // If editing an existing staff member load previous values
-         if ($staff_id > 1){
-                 $sql = "SELECT
-                         s.first_name,
-                         s.last_name,
-                         s.staff_account,
-                         s.staff_email,
-                         s.access_id,
-                         t.stafftitle,
-                         t.stafftitle_id,
-                         a.access_id,
-                         a.access_level,
-                         a.access
-                         FROM staff s, access a, stafftitle t
-                         WHERE
-                         s.access_id = a.access_id AND
-                         s.stafftitle_id = t.stafftitle_id AND
-                         staff_id=" . $staff_id;
-                 $rs = xx_query($sql, $con);
-                 $row = xx_fetch_array($rs);
-                 // Fetch results
-                 $first_name = Trim($row["first_name"]);
-                 $last_name = Trim($row["last_name"]);
-                 $staff_account = Trim($row["staff_account"]);
-                 $staff_email = Trim($row["staff_email"]);
-                 $access = Trim($row["access"]);
-                 $access_id = Trim($row["access_id"]);
-                 $stafftitle = Trim($row["stafftitle"]);
-                 $stafftitle_id = Trim($row["stafftitle_id"]);
-                 // Run strings through the HTML cleaner for output
-                 $first_name = textOutHTML($first_name);
-                 $last_name = textOutHTML($last_name);
-                 $staff_account = textOutHTML($staff_account);
-         }
-         // Table definition
-         printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
-         // If new insert
-         if ($staff_id <1) {
-                 printf("<form method = \"POST\" action = \"insert.phtml\" >");
-                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-                 printf("Enter New Staff Person");
-                 printf("</td></tr>\n");
          }
-         // Else update
+         // Houston, we have a problem
-         else {
+         if ($key_id > 0 && $exists == 0) {
-                 printf("<form method = \"POST\" action = \"update.phtml\" >");
+                 $problem = 1;
-                 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+                 printf("<h3>Vendor (ID# %d) Not Found</h3>\n", $key_id);
-                 printf("Edit Staff Person: %s %s (#%d)", $first_name, $last_name, $staff_id);
-                 printf("</td></tr>\n");
          }
-         // Last name
+         // If no problems, then go for landing
-         printf("<tr>\n");
+         if ($problem != 1) {
-         printf("<td><b>Last Name:</b></td>\n");
-         printf("<td><input type = \"text\" name = \"last_name\" size = \"40\" value = \"%s\" ></td>\n", $last_name);
-         printf("</tr>\n");
-         // First name
+                 // Table definition
-         printf("<tr>\n");
+                 printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
-         printf("<td><b>First Name:</b></td>\n");
-         printf("<td><input type = \"text\" name = \"first_name\" size = \"30\" value = \"%s\"></td>\n", $first_name);
-         printf("</tr>\n");
-         // staff account - must be unique, may match against staff_account
+                 // Form to handle vendor
-         printf("<tr>\n");
+                 // If new insert
-         printf("<td><b>Staff Account (x500 if applicable, 20 char max.):</b></td>");
+                 if ($key_id <1) {
-         printf("<td><input type = \"text\" name = \"staff_account\" size = \"20\" value =\"%s\"></td>\n", $staff_account);
+                         printf("<form method = \"POST\" action = \"insert.phtml\" >\n");
-         printf("</tr>\n");
+                         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
+                         printf("Enter New Vendor");
-         // Staff email - whether or not x500 authentication is used
+                         printf("</td></tr>\n");
-         printf("<tr>\n");
+                 }
-         printf("<td><b>Staff E-Mail:</b></td>\n");
-         printf("<td><input type = \"text\" name = \"staff_email\" size = \"50\" value =\"%s\"></td>\n", $staff_email);
-         printf("</tr>\n");
-         // Title
+                 // Else update
-         printf("<tr>\n");
+                 else {
-         printf("<td><b>Job Title:</b></td>\n");
+                         printf("<form method = \"POST\" action = \"update.phtml\" >\n");
-         printf("<td><select name = \"stafftitle_id\">");
+                         printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
-         dropDownFieldSelected($con, "stafftitle", "stafftitle", "stafftitle_id", "WHERE stafftitle_id > 0", $stafftitle_id);
+                         printf("Edit Vendor: %s (ID# %d)", $vendor, $vendor_id);
-         printf("</select></td>\n");
+                         printf("</td></tr>\n");
-         printf("</tr>\n");
+                 }
-         // Access
+                 // Vendor name
-         printf("<tr>\n");
+                 printf("<tr>\n");
-         printf("<td><b>Access Level:</b></td>\n");
+                 printf("<td><b>Vendor:</b></td>\n");
-         printf("<td><select name = \"access_id\">\n");
+                 printf("<td><input type = \"text\" name = \"vendor\" size = \"40\" value = \"%s\" ></td>\n", $vendor);
-         dropDownFieldSelected($con, "access", "access", "access_id", "WHERE access_id > 0", $access_id);
+                 printf("</tr>\n");
-         printf("</select></td>\n");
-         printf("</tr>\n");
-         // Buttons
+                 // Vendor description
-         printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
+                 printf("<tr>\n");
+                 printf("<td colspan=\"2\"><b>Description:</b><br>\n");
+                 printf("<textarea name =\"vendor_descr\" rows =\"5\" cols=\"60\">\n");
+                 printf("%s", $vendor_descr);
+                 printf("</textarea>\n");
+                 printf("</td></tr>\n");
+                 // Down toggle
+                 $up_toggle = "";
+                 $down_toggle = "";
+                 $alert_toggle = "";
+                 if ($vendor_status < 1) $up_toggle = " CHECKED ";
+                 else if ($vendor_status == 1) $down_toggle = " CHECKED ";
+                 else if ($vendor_status == 2) $alert_toggle = " CHECKED ";
+                 printf("<tr><td>\n");
+                 printf("<b>Vendor Status:</b>\n");
+                 printf("</td>\n");
+                 printf("<td>\n");
+                 printf("<b>Up</b> <input type=\"radio\" name =\"vendor_status\" value=\"0\" %s>\n", $up_toggle);
+                 printf("<b>Down</b> <input type=\"radio\" name =\"vendor_status\" value=\"1\" %s>\n", $down_toggle);
+                 printf("<b>Alert</b> <input type=\"radio\" name =\"vendor_status\" value=\"2\" %s>\n", $alert_toggle);
-         // If new staff
+                 printf("</td></tr>\n");
-         if ($staff_id < 2) {
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertStaff\" >");
+                 // Message
-                 printf("<input type = \"Submit\" value = \"Save New Staff\" > ");
+                 printf("<tr><td>\n");
-         }
+                 printf("<b>Down/Alert Message:</b>\n");
-         // Editing an existing staffperson
+                 printf("</td>\n");
-         else {
+                 printf("<td>\n");
-                 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateStaff\" >");
+                 printf("<input type =\"text\" size=\"60\" name =\"vendor_message\" value=\"%s\">\n", $vendor_message);
-                 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
+                 printf("</td></tr>\n");
-                 printf("<input type = \"Submit\" value = \"Save Staff Changes\" > ");
-         }
-         printf("<input type = \"Reset\" value = \"Reset\" >\n");
-         // Close the form and table
+                 // Buttons
-         printf("</form>\n");
+                 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
+                 // If this is an existing vendor
+                 if ($key_id > 0) {
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateVendor\" >\n");
+                         printf("<input type = \"Submit\" value = \"Update Vendor\" >\n");
+                         printf("<input type = \"Hidden\" name = \"vendor_id\" value = \"%d\" >\n", $vendor_id);
+                 }
+                 // Editing a new vendor
+                 else {
+                         printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertVendor\" >\n");
+                         printf("<input type = \"Submit\" value = \"Save New Vendor\">\n");
+                 }
-         printf("</td></tr></table>\n");
+                 // Common button
+                 printf("<input type = \"Reset\" value = \"Reset\" >\n");
-         // If editing existing staff, draw other forms
+                 // Close things
-         if ($staff_id > 0) {
+                 printf("</form>\n");
-                 formPassword($con, $staff_id);
+                 printf("</td></tr></table></center>\n");
-                 formAssignStaffLibunit($con, $staff_id);
-                 formAssignStaffSub($con, $staff_id);
-         }
-         printf("</center><br>\n");
+         } // No problems
  }
  ?>

 Legend:



Removed from v.71
 


changed lines


 
Added in v.72
 Legend:



Removed from v.71
 


changed lines


 
Added in v.72
-Removed from v.71
+Added in v.72

	ViewVC Help
Powered by ViewVC 1.1.26