/[libdata]/branches/paul_xx/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!
ViewVC logotype

Diff of /branches/paul_xx/admin/include/forms.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

branches/paul/admin/include/forms.php revision 68 by dpavlin, Thu Mar 18 19:24:54 2004 UTC branches/paul_xx/admin/include/forms.php revision 69 by dpavlin, Thu Mar 18 20:01:09 2004 UTC
# Line 111  function formAssignLibunitStaff($libunit Line 111  function formAssignLibunitStaff($libunit
111                  ls.libunit_id = " . $libunit_id . " AND                  ls.libunit_id = " . $libunit_id . " AND
112                  s.staff_id = ls.staff_id                  s.staff_id = ls.staff_id
113                  ORDER BY last_name, first_name";                  ORDER BY last_name, first_name";
114          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
115                    
116          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
117                  $first_name = $row["first_name"];                  $first_name = $row["first_name"];
118                  $last_name = $row["last_name"];                  $last_name = $row["last_name"];
119                  $staff_id = $row["staff_id"];                  $staff_id = $row["staff_id"];
# Line 192  function formAssignResFeature($resource_ Line 192  function formAssignResFeature($resource_
192                  r.resource_id = " . $resource_id . " AND                  r.resource_id = " . $resource_id . " AND
193                  rf.resource_id = r.resource_id AND                  rf.resource_id = r.resource_id AND
194                  rf.feature_id = f.feature_id ORDER BY feature";                  rf.feature_id = f.feature_id ORDER BY feature";
195          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
196                    
197          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
198                  $feature = $row["feature"];                  $feature = $row["feature"];
199                  $feature_id = $row["feature_id"];                  $feature_id = $row["feature_id"];
200                  printf("<option value = \"%s\">%s</option>\n", $feature_id, $feature);                  printf("<option value = \"%s\">%s</option>\n", $feature_id, $feature);
# Line 272  function formAssignResLoc($resource_id){ Line 272  function formAssignResLoc($resource_id){
272                  r.resource_id = " . $resource_id . " AND                  r.resource_id = " . $resource_id . " AND
273                  rl.resource_id = r.resource_id AND                  rl.resource_id = r.resource_id AND
274                  rl.location_id = l.location_id ORDER BY location";                  rl.location_id = l.location_id ORDER BY location";
275          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
276                    
277          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
278                  $location = $row["location"];                  $location = $row["location"];
279                  $location_id = $row["location_id"];                  $location_id = $row["location_id"];
280                  printf("<option value = \"%s\">%s</option>\n", $location_id, $location);                  printf("<option value = \"%s\">%s</option>\n", $location_id, $location);
# Line 352  function formAssignResMastersubject($res Line 352  function formAssignResMastersubject($res
352                  r.resource_id = " . $resource_id . " AND                  r.resource_id = " . $resource_id . " AND
353                  rm.resource_id = r.resource_id AND                  rm.resource_id = r.resource_id AND
354                  rm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";                  rm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";
355          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
356                    
357          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
358                  $mastersubject = $row["mastersubject"];                  $mastersubject = $row["mastersubject"];
359                  $mastersubject_id = $row["mastersubject_id"];                  $mastersubject_id = $row["mastersubject_id"];
360                  printf("<option value = \"%s\">%s</option>\n", $mastersubject_id, $mastersubject);                  printf("<option value = \"%s\">%s</option>\n", $mastersubject_id, $mastersubject);
# Line 434  function formAssignServLoc($service_id){ Line 434  function formAssignServLoc($service_id){
434                  s.service_id = " . $service_id . " AND                  s.service_id = " . $service_id . " AND
435                  sl.service_id = s.service_id AND                  sl.service_id = s.service_id AND
436                  sl.location_id = l.location_id ORDER BY location";                  sl.location_id = l.location_id ORDER BY location";
437          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
438                    
439          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
440                  $location = $row["location"];                  $location = $row["location"];
441                  $location_id = $row["location_id"];                  $location_id = $row["location_id"];
442                  printf("<option value = \"%s\">%s</option>\n", $location_id, $location);                  printf("<option value = \"%s\">%s</option>\n", $location_id, $location);
# Line 516  function formAssignServServtype($service Line 516  function formAssignServServtype($service
516                  s.service_id = " . $service_id . " AND                  s.service_id = " . $service_id . " AND
517                  st.service_id = s.service_id AND                  st.service_id = s.service_id AND
518                  st.servicetype_id = t.servicetype_id ORDER BY servicetype";                  st.servicetype_id = t.servicetype_id ORDER BY servicetype";
519          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
520                    
521          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
522                  $servicetype = $row["servicetype"];                  $servicetype = $row["servicetype"];
523                  $servicetype_id = $row["servicetype_id"];                  $servicetype_id = $row["servicetype_id"];
524                  printf("<option value = \"%s\">%s</option>\n", $servicetype_id, $servicetype);                  printf("<option value = \"%s\">%s</option>\n", $servicetype_id, $servicetype);
# Line 598  function formAssignStaffLibunit($staff_i Line 598  function formAssignStaffLibunit($staff_i
598                  ls.staff_id = s.staff_id AND                  ls.staff_id = s.staff_id AND
599                  ls.libunit_id = l.libunit_id                  ls.libunit_id = l.libunit_id
600                  ORDER BY l.libunit";                  ORDER BY l.libunit";
601          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
602                    
603          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
604                  $libunit = $row["libunit"];                  $libunit = $row["libunit"];
605                  $libunit_id = $row["libunit_id"];                  $libunit_id = $row["libunit_id"];
606                  printf("<option value = \"%s\">%s</option>\n", $libunit_id, $libunit);                  printf("<option value = \"%s\">%s</option>\n", $libunit_id, $libunit);
# Line 680  function formAssignStaffSub($staff_id){ Line 680  function formAssignStaffSub($staff_id){
680                  st.staff_id = t.staff_id AND                  st.staff_id = t.staff_id AND
681                  st.subject_id = s.subject_id                  st.subject_id = s.subject_id
682                  ORDER BY s.subject";                  ORDER BY s.subject";
683          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
684    
685          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
686                  $subject = $row["subject"];                  $subject = $row["subject"];
687                  $subject_id = $row["subject_id"];                  $subject_id = $row["subject_id"];
688                  printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject);                  printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject);
# Line 763  function formAssignSubCoursesub($subject Line 763  function formAssignSubCoursesub($subject
763                  s.subject_id = " . $subject_id . " AND                  s.subject_id = " . $subject_id . " AND
764                  sc.subject_id = s.subject_id AND                  sc.subject_id = s.subject_id AND
765                  sc.coursesub_id = c.coursesub_id ORDER BY coursesub_descr";                  sc.coursesub_id = c.coursesub_id ORDER BY coursesub_descr";
766          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
767    
768          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
769                  $coursesub = $row["coursesub"];                  $coursesub = $row["coursesub"];
770                  $coursesub_id = $row["coursesub_id"];                  $coursesub_id = $row["coursesub_id"];
771                  $coursesub_descr = $row["coursesub_descr"];                  $coursesub_descr = $row["coursesub_descr"];
# Line 851  function formAssignSubLoc($subject_id){ Line 851  function formAssignSubLoc($subject_id){
851                  s.subject_id = " . $subject_id . " AND                  s.subject_id = " . $subject_id . " AND
852                  sl.subject_id = s.subject_id AND                  sl.subject_id = s.subject_id AND
853                  sl.location_id = l.location_id ORDER BY location";                  sl.location_id = l.location_id ORDER BY location";
854          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
855    
856          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
857                  $location = $row["location"];                  $location = $row["location"];
858                  $location_id = $row["location_id"];                  $location_id = $row["location_id"];
859                  printf("<option value = \"%s\">%s</option>\n", $location_id, $location);                  printf("<option value = \"%s\">%s</option>\n", $location_id, $location);
# Line 933  function formAssignSubMaster($subject_id Line 933  function formAssignSubMaster($subject_id
933                  s.subject_id = " . $subject_id . " AND                  s.subject_id = " . $subject_id . " AND
934                  sm.subject_id = s.subject_id AND                  sm.subject_id = s.subject_id AND
935                  sm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";                  sm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";
936          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
937    
938          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
939                  $mastersubject = $row["mastersubject"];                  $mastersubject = $row["mastersubject"];
940                  $mastersubject_id = $row["mastersubject_id"];                  $mastersubject_id = $row["mastersubject_id"];
941                  printf("<option value = \"%s\">%s</option>\n", $mastersubject_id, $mastersubject);                  printf("<option value = \"%s\">%s</option>\n", $mastersubject_id, $mastersubject);
# Line 1013  function formAssignSubOtherSub($subject_ Line 1013  function formAssignSubOtherSub($subject_
1013                  so.subject_id = " . $subject_id . " AND                  so.subject_id = " . $subject_id . " AND
1014                  so.othersub_id = s.subject_id                  so.othersub_id = s.subject_id
1015                  ORDER BY s.subject";                  ORDER BY s.subject";
1016          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
1017    
1018          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
1019                  $othersub = $row["subject"];                  $othersub = $row["subject"];
1020                  $othersub_id = $row["othersub_id"];                  $othersub_id = $row["othersub_id"];
1021                                    
# Line 1094  function formAssignSubPage($subject_id){ Line 1094  function formAssignSubPage($subject_id){
1094                  sp.subject_id = " . $subject_id . " AND                  sp.subject_id = " . $subject_id . " AND
1095                  sp.page_id = p.page_id                  sp.page_id = p.page_id
1096                  ORDER BY p.page_title";                  ORDER BY p.page_title";
1097          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
1098    
1099          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
1100                  $page_title = $row["page_title"];                  $page_title = $row["page_title"];
1101                  $page_id = $row["page_id"];                  $page_id = $row["page_id"];
1102                                    
# Line 1180  function formAssignSubStaff($subject_id) Line 1180  function formAssignSubStaff($subject_id)
1180                  s.subject_id = " . $subject_id . " AND                  s.subject_id = " . $subject_id . " AND
1181                  st.subject_id = s.subject_id AND                  st.subject_id = s.subject_id AND
1182                  st.staff_id = t.staff_id ORDER BY last_name, first_name";                  st.staff_id = t.staff_id ORDER BY last_name, first_name";
1183          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
1184    
1185          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
1186                  $first_name = $row["first_name"];                  $first_name = $row["first_name"];
1187                  $last_name = $row["last_name"];                  $last_name = $row["last_name"];
1188                  $staff_id = $row["staff_id"];                  $staff_id = $row["staff_id"];
# Line 1262  function formCoursesub($coursesub_id) { Line 1262  function formCoursesub($coursesub_id) {
1262                  // If the user is editing an existing record, fetch previous values                  // If the user is editing an existing record, fetch previous values
1263                  if ($coursesub_id > 0 && $exists == 1) {                  if ($coursesub_id > 0 && $exists == 1) {
1264                          $sql = "SELECT * FROM coursesub WHERE coursesub_id = " . $coursesub_id;                          $sql = "SELECT * FROM coursesub WHERE coursesub_id = " . $coursesub_id;
1265                          $rs = mysql_tryquery($sql);                          $rs = xx_tryquery($sql);
1266                          $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                          $row = xx_fetch_array ($rs, xx_ASSOC);
1267    
1268                          // Fetch existing values                          // Fetch existing values
1269                          $coursesub_id = $row["coursesub_id"];                          $coursesub_id = $row["coursesub_id"];
# Line 1389  function formEditSingleField($display, $ Line 1389  function formEditSingleField($display, $
1389                          . " = "                          . " = "
1390                          . $key_id;                          . $key_id;
1391                    
1392                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
1393                  $row = mysql_fetch_array($rs, MYSQL_ASSOC);                  $row = xx_fetch_array($rs, xx_ASSOC);
1394                  $oldValue = Trim($row[$display_field]);                  $oldValue = Trim($row[$display_field]);
1395    
1396                  // Table definition                  // Table definition
# Line 1458  function formFaculty($faculty_id){ Line 1458  function formFaculty($faculty_id){
1458                          FROM faculty f                          FROM faculty f
1459                          WHERE                          WHERE
1460                          faculty_id = " . $faculty_id;                          faculty_id = " . $faculty_id;
1461                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
1462                  $row = mysql_fetch_array($rs, MYSQL_ASSOC);                  $row = xx_fetch_array($rs, xx_ASSOC);
1463                                    
1464                  // Fetch results                  // Fetch results
1465                  $faculty_firstname = Trim($row["faculty_firstname"]);                  $faculty_firstname = Trim($row["faculty_firstname"]);
# Line 1564  function formFeature($key_id) { Line 1564  function formFeature($key_id) {
1564                    
1565                  // Fetch existing values                          // Fetch existing values        
1566                  $sql = "SELECT * FROM feature WHERE feature_id = " . $key_id;                  $sql = "SELECT * FROM feature WHERE feature_id = " . $key_id;
1567                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
1568                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
1569                  $feature_id = $row["feature_id"];                  $feature_id = $row["feature_id"];
1570                  $feature = $row["feature"];                  $feature = $row["feature"];
1571                  $image_path = $row["image_path"];                  $image_path = $row["image_path"];
# Line 1678  function formInfotype($key_id) { Line 1678  function formInfotype($key_id) {
1678    
1679                  // Fetch existing values                          // Fetch existing values        
1680                  $sql = "SELECT * from infotype where infotype_id = " . $key_id;                  $sql = "SELECT * from infotype where infotype_id = " . $key_id;
1681                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
1682                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
1683                  $infotype_id = $row["infotype_id"];                  $infotype_id = $row["infotype_id"];
1684                  $infotype = $row["infotype"];                  $infotype = $row["infotype"];
1685                  $masterinfotype_id = $row["masterinfotype_id"];                  $masterinfotype_id = $row["masterinfotype_id"];
# Line 1795  function formLibunit($key_id){ Line 1795  function formLibunit($key_id){
1795                          FROM libunit l                          FROM libunit l
1796                          WHERE                          WHERE
1797                          libunit_id = " . $libunit_id;                          libunit_id = " . $libunit_id;
1798                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
1799                  $row = mysql_fetch_array($rs, MYSQL_ASSOC);                  $row = xx_fetch_array($rs, xx_ASSOC);
1800                                    
1801                  // Fetch values                  // Fetch values
1802                  $libunit = Trim($row["libunit"]);                  $libunit = Trim($row["libunit"]);
# Line 1913  function formLocation($key_id) { Line 1913  function formLocation($key_id) {
1913    
1914                  // Fetch existing values                  // Fetch existing values
1915                  $sql = "SELECT * from location where location_id = " . $key_id;                  $sql = "SELECT * from location where location_id = " . $key_id;
1916                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
1917                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
1918                  $location_id = $row["location_id"];                  $location_id = $row["location_id"];
1919                  $location = $row["location"];                  $location = $row["location"];
1920                  $location_descr = $row["location_descr"];                  $location_descr = $row["location_descr"];
# Line 2202  function formPassword($staff_id){ Line 2202  function formPassword($staff_id){
2202                  FROM staff s                  FROM staff s
2203                  WHERE (s.password <> NULL OR s.password <> '') and s.staff_id = " . $staff_id;                  WHERE (s.password <> NULL OR s.password <> '') and s.staff_id = " . $staff_id;
2204    
2205          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
2206          $row = mysql_fetch_array($rs, MYSQL_ASSOC);          $row = xx_fetch_array($rs, xx_ASSOC);
2207    
2208          // Fetch values          // Fetch values
2209          $pass_set = $row["pass_set"];          $pass_set = $row["pass_set"];
# Line 2302  function formResource($key_id, $masterin Line 2302  function formResource($key_id, $masterin
2302                  if ($key_id > 0 && $exists == 1) {                  if ($key_id > 0 && $exists == 1) {
2303                                    
2304                          $sql = "SELECT * from resource where resource_id = " . $key_id;                          $sql = "SELECT * from resource where resource_id = " . $key_id;
2305                          $rs = mysql_tryquery($sql);                          $rs = xx_tryquery($sql);
2306                          $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                          $row = xx_fetch_array ($rs, xx_ASSOC);
2307    
2308                          // Fetch existing values                          // Fetch existing values
2309                          $resource_id = $row["resource_id"];                          $resource_id = $row["resource_id"];
# Line 2666  function formService($key_id) { Line 2666  function formService($key_id) {
2666    
2667                  // Fetch existing values                  // Fetch existing values
2668                  $sql = "SELECT * from service where service_id = " . $key_id;                  $sql = "SELECT * from service where service_id = " . $key_id;
2669                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
2670                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
2671                  $service_id = $row["service_id"];                  $service_id = $row["service_id"];
2672                  $service = $row["service"];                  $service = $row["service"];
2673                  $serviceURL = $row["serviceURL"];                  $serviceURL = $row["serviceURL"];
# Line 2862  function formStyle($key_id) { Line 2862  function formStyle($key_id) {
2862                    
2863                  // Fetch existing values                          // Fetch existing values        
2864                  $sql = "SELECT * from style where style_id = " . $key_id;                  $sql = "SELECT * from style where style_id = " . $key_id;
2865                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
2866                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
2867                  $style_id = $row["style_id"];                  $style_id = $row["style_id"];
2868                  $style_title = $row["style_title"];                  $style_title = $row["style_title"];
2869                  $header_file = $row["header_file"];                  $header_file = $row["header_file"];
# Line 2994  function formStaff($staff_id){ Line 2994  function formStaff($staff_id){
2994                          s.stafftitle_id = t.stafftitle_id AND                          s.stafftitle_id = t.stafftitle_id AND
2995                          staff_id=" . $staff_id;                          staff_id=" . $staff_id;
2996    
2997                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
2998                  $row = mysql_fetch_array($rs, MYSQL_ASSOC);                  $row = xx_fetch_array($rs, xx_ASSOC);
2999                                    
3000                  // Fetch results                  // Fetch results
3001                  $first_name = Trim($row["first_name"]);                  $first_name = Trim($row["first_name"]);
# Line 3133  function formSubject($key_id) { Line 3133  function formSubject($key_id) {
3133                    
3134                  // If the user is editing an existing record, fetch previous values                  // If the user is editing an existing record, fetch previous values
3135                  $sql = "SELECT * from subject where subject_id = " . $key_id;                  $sql = "SELECT * from subject where subject_id = " . $key_id;
3136                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
3137                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
3138    
3139                  // Fetch existing values                  // Fetch existing values
3140                  $subject_id = $row["subject_id"];                  $subject_id = $row["subject_id"];
# Line 3267  function formVendor($key_id) { Line 3267  function formVendor($key_id) {
3267                    
3268                  // Fetch existing values                          // Fetch existing values        
3269                  $sql = "SELECT * FROM vendor WHERE vendor_id = " . $key_id;                  $sql = "SELECT * FROM vendor WHERE vendor_id = " . $key_id;
3270                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
3271                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
3272                  $vendor_id = $row["vendor_id"];                  $vendor_id = $row["vendor_id"];
3273                  $vendor = $row["vendor"];                  $vendor = $row["vendor"];
3274                  $vendor_descr = $row["vendor_descr"];                  $vendor_descr = $row["vendor_descr"];
Legend:
Removed from v.68  
changed lines
  Added in v.69
  ViewVC Help
Powered by ViewVC 1.1.26