50 |
if ($staff_id > 0) { |
if ($staff_id > 0) { |
51 |
|
|
52 |
$sql = "UPDATE staff SET password = NULL WHERE staff_id = " . $staff_id; |
$sql = "UPDATE staff SET password = NULL WHERE staff_id = " . $staff_id; |
53 |
if (mysql_tryquery ($sql)) printf("Successfully purged password for this staff account."); |
if (xx_tryquery ($sql)) printf("Successfully purged password for this staff account."); |
54 |
|
|
55 |
} |
} |
56 |
else printf("Staff ID not found."); |
else printf("Staff ID not found."); |
115 |
. $campus_id |
. $campus_id |
116 |
. " WHERE coursesub_id =" |
. " WHERE coursesub_id =" |
117 |
. $coursesub_id; |
. $coursesub_id; |
118 |
if (mysql_tryquery ($sql)) printf("Successfully updated <b>%s</b> course subject.", $coursesub_display); |
if (xx_tryquery ($sql)) printf("Successfully updated <b>%s</b> course subject.", $coursesub_display); |
119 |
} |
} |
120 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
121 |
|
|
178 |
. $faculty_account |
. $faculty_account |
179 |
. "' WHERE faculty_id =" |
. "' WHERE faculty_id =" |
180 |
. $faculty_id; |
. $faculty_id; |
181 |
if (mysql_tryquery ($sql)) printf("Successfully updated faculty person <b>%s</b>.", $faculty_name_display); |
if (xx_tryquery ($sql)) printf("Successfully updated faculty person <b>%s</b>.", $faculty_name_display); |
182 |
} |
} |
183 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
184 |
|
|
240 |
. $image_path |
. $image_path |
241 |
. "' WHERE feature_id =" |
. "' WHERE feature_id =" |
242 |
. $feature_id; |
. $feature_id; |
243 |
if (mysql_tryquery ($sql)) printf("Successfully updated <b>%s</b> feature.", $feature_display); |
if (xx_tryquery ($sql)) printf("Successfully updated <b>%s</b> feature.", $feature_display); |
244 |
} |
} |
245 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
246 |
|
|
297 |
. $masterinfotype_id |
. $masterinfotype_id |
298 |
. " WHERE infotype_id = " |
. " WHERE infotype_id = " |
299 |
. $infotype_id; |
. $infotype_id; |
300 |
if (mysql_tryquery ($sql)) printf("Updated affected RQS relationships (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Updated affected RQS relationships (if any).<BR>\n"); |
301 |
|
|
302 |
// Build the SQL |
// Build the SQL |
303 |
$sql = "UPDATE infotype SET infotype = '" |
$sql = "UPDATE infotype SET infotype = '" |
308 |
. $mastersubject_id |
. $mastersubject_id |
309 |
. " WHERE infotype_id =" |
. " WHERE infotype_id =" |
310 |
. $infotype_id; |
. $infotype_id; |
311 |
if (mysql_tryquery ($sql)) printf("Successfully updated <b>%s</b> information type.", $infotype_display); |
if (xx_tryquery ($sql)) printf("Successfully updated <b>%s</b> information type.", $infotype_display); |
312 |
} |
} |
313 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
314 |
|
|
384 |
. $head_staff_id |
. $head_staff_id |
385 |
. " WHERE libunit_id =" |
. " WHERE libunit_id =" |
386 |
. $libunit_id; |
. $libunit_id; |
387 |
mysql_tryquery ($sql); |
xx_tryquery ($sql); |
388 |
formLibunit($libunit_id); |
formLibunit($libunit_id); |
389 |
} |
} |
390 |
|
|
480 |
. $telephone |
. $telephone |
481 |
. "' WHERE location_id =" |
. "' WHERE location_id =" |
482 |
. $location_id; |
. $location_id; |
483 |
if (mysql_tryquery ($sql)) printf("Successfully updated <b>%s</b> location.", $location_display); |
if (xx_tryquery ($sql)) printf("Successfully updated <b>%s</b> location.", $location_display); |
484 |
} |
} |
485 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
486 |
|
|
533 |
. "') WHERE staff_id =" |
. "') WHERE staff_id =" |
534 |
. $staff_id; |
. $staff_id; |
535 |
|
|
536 |
mysql_tryquery ($sql); |
xx_tryquery ($sql); |
537 |
formStaff($staff_id); |
formStaff($staff_id); |
538 |
} |
} |
539 |
|
|
650 |
. "' WHERE resource_id = " |
. "' WHERE resource_id = " |
651 |
. $key_id; |
. $key_id; |
652 |
|
|
653 |
mysql_tryquery ($sql); |
xx_tryquery ($sql); |
654 |
formResource($key_id, 0, 0, ''); |
formResource($key_id, 0, 0, ''); |
655 |
} |
} |
656 |
|
|
737 |
. "' WHERE service_id =" |
. "' WHERE service_id =" |
738 |
. $service_id; |
. $service_id; |
739 |
|
|
740 |
mysql_tryquery ($sql); |
xx_tryquery ($sql); |
741 |
formService($service_id); |
formService($service_id); |
742 |
|
|
743 |
} |
} |
809 |
. $key_field |
. $key_field |
810 |
. " = " |
. " = " |
811 |
. $key_id; |
. $key_id; |
812 |
if (mysql_tryquery ($sql)) printf("Successfully changed %s to <b>%s</b>.", $display, $newValue_display); |
if (xx_tryquery ($sql)) printf("Successfully changed %s to <b>%s</b>.", $display, $newValue_display); |
813 |
|
|
814 |
} |
} |
815 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
894 |
. "' WHERE staff_id =" |
. "' WHERE staff_id =" |
895 |
. $staff_id; |
. $staff_id; |
896 |
|
|
897 |
mysql_tryquery ($sql); |
xx_tryquery ($sql); |
898 |
formStaff($staff_id); |
formStaff($staff_id); |
899 |
} |
} |
900 |
else { |
else { |
963 |
. $header_file |
. $header_file |
964 |
. "' WHERE style_id =" |
. "' WHERE style_id =" |
965 |
. $style_id; |
. $style_id; |
966 |
if (mysql_tryquery ($sql)) printf("Successfully updated <b>%s</b> style.", $style_title_display); |
if (xx_tryquery ($sql)) printf("Successfully updated <b>%s</b> style.", $style_title_display); |
967 |
} |
} |
968 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
969 |
|
|
1021 |
. "', sublocation_id =" |
. "', sublocation_id =" |
1022 |
. $sublocation_id |
. $sublocation_id |
1023 |
. " WHERE subject_id = " . $subject_id; |
. " WHERE subject_id = " . $subject_id; |
1024 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1025 |
formSubject($subject_id); |
formSubject($subject_id); |
1026 |
} |
} |
1027 |
|
|
1095 |
. $vendor_status |
. $vendor_status |
1096 |
. "' WHERE vendor_id =" |
. "' WHERE vendor_id =" |
1097 |
. $vendor_id; |
. $vendor_id; |
1098 |
if (mysql_tryquery ($sql)) printf("Successfully updated <b>%s</b> vendor.", $vendor_display); |
if (xx_tryquery ($sql)) printf("Successfully updated <b>%s</b> vendor.", $vendor_display); |
1099 |
} |
} |
1100 |
else printf("%s", $err_msg); |
else printf("%s", $err_msg); |
1101 |
|
|