--- trunk/admin/include/delete.php 2004/03/04 22:43:17 41 +++ trunk/admin/include/delete.php 2004/03/04 22:43:50 42 @@ -89,14 +89,14 @@ $sql = "UPDATE course SET campus_id = NULL WHERE campus_id = " . $campus_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Campus purged from assignments to course pages.
\n"); } @@ -104,14 +104,14 @@ if ($problem == 0) { $sql = "UPDATE coursesub SET campus_id = 1 WHERE campus_id =" . $campus_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed from affected Course Subjects.
\n"); } } @@ -120,14 +120,14 @@ if ($problem == 0) { $sql = "DELETE FROM campus WHERE campus_id =" . $campus_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this campus successfully.

\n"); } } @@ -228,14 +228,14 @@ // Delete from the sub_coursesub table $sql = "DELETE FROM sub_coursesub WHERE coursesub_id = " . $coursesub_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 0; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-Course Subject assignments removed.
\n"); } @@ -245,13 +245,13 @@ $sql = "DELETE FROM coursesub WHERE coursesub_id =" . $coursesub_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this Course Subject successfully.

\n"); } @@ -366,14 +366,14 @@ $sql = "DELETE FROM course_personnel WHERE faculty_id = " . $faculty_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Faculty person purged from assignments to course pages.
\n"); } @@ -381,14 +381,14 @@ if ($problem == 0) { $sql = "DELETE FROM faculty WHERE faculty_id =" . $faculty_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this faculty person successfully.

\n"); } } @@ -478,14 +478,14 @@ // Delete all resource_feature assignments $sql = "DELETE from res_feature WHERE feature_id =" . $feature_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed resource-feature associations.
\n"); if ($problem == 0) { @@ -493,14 +493,14 @@ // Delete from feature table $sql = "DELETE FROM feature WHERE feature_id =" . $feature_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed feature successfully.

\n"); } } @@ -592,14 +592,14 @@ // Delete all res_sub_infotype assignments $sql = "DELETE from res_sub_infotype WHERE infotype_id =" . $infotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed resource-subject-infotype associations.
\n"); @@ -608,14 +608,14 @@ // Set (N/A) type in resource table $sql = "UPDATE resource SET infotype_id = 1 WHERE infotype_id =" . $infotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Set default information types for affects resources to (N/A).
\n"); } } @@ -626,14 +626,14 @@ // Delete from infotype table $sql = "DELETE FROM infotype WHERE infotype_id =" . $infotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this information type successfully.

\n"); } } @@ -731,14 +731,14 @@ // First delete from res_loc $sql = "DELETE FROM res_loc WHERE location_id = " . $location_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Affected resource-location assignments removed.
\n"); } @@ -746,14 +746,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_loc WHERE location_id =" . $location_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Affected subject-location assignments removed.
\n"); } } @@ -762,14 +762,14 @@ if ($problem == 0) { $sql = "UPDATE subject SET sublocation_id = NULL WHERE sublocation_id =" . $location_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Affected primary subject locations set to NULL.
\n"); } } @@ -778,14 +778,14 @@ if ($problem == 0) { $sql = "DELETE FROM serv_loc WHERE location_id =" . $location_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Affected service-location assignments removed.
\n"); } } @@ -796,8 +796,8 @@ // First, get the default location description and title $sql = "SELECT location, location_descr FROM location WHERE location_id = " . $location_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $location = $row["location"]; $location_descr = $row["location_descr"]; @@ -818,14 +818,14 @@ . "'), location_id = NULL WHERE location_id =" . $location_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions.
\n"); } @@ -838,14 +838,14 @@ . "', location_id = NULL WHERE location_id =" . $location_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions.
\n"); } @@ -864,14 +864,14 @@ . "'), location_id = NULL WHERE location_id =" . $location_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions (buffers).
\n"); } @@ -884,14 +884,14 @@ . "', location_id = NULL WHERE location_id =" . $location_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions (buffers).
\n"); } @@ -902,14 +902,14 @@ if ($problem == 0) { $sql = "DELETE FROM location WHERE location_id =" . $location_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Location successfully removed.

\n"); } } @@ -1018,8 +1018,8 @@ . $masterinfotype_id; // Fetch the values - $rs = mysql_query($sql, $con); - while ($row = mysql_fetch_array ($rs)) { + $rs = xx_query($sql, $con); + while ($row = xx_fetch_array ($rs)) { $infotype_id = $row["infotype_id"]; $infotype = $row["infotype"]; @@ -1029,14 +1029,14 @@ // Delete all res_sub_infotype assignments $sql = "DELETE from res_sub_infotype WHERE infotype_id =" . $infotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed resource-subject-infotype associations.
\n"); @@ -1045,14 +1045,14 @@ // Set (N/A) type in resource table $sql = "UPDATE resource SET infotype_id = 1 WHERE infotype_id =" . $infotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Set default information types for affects resources to (N/A).
\n"); } } @@ -1063,14 +1063,14 @@ // Delete from infotype table $sql = "DELETE FROM infotype WHERE infotype_id =" . $infotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed affected specific information types.
\n"); } } // successful delete of a specific information type @@ -1086,14 +1086,14 @@ // Delete from masterinfotype table $sql = "DELETE FROM masterinfotype WHERE masterinfotype_id =" . $masterinfotype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed Master Information Type successfully.

\n"); } } // delete masterinfotype itself @@ -1197,14 +1197,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_mastersubject WHERE mastersubject_id =" . $mastersubject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Affected subject-mastersubject assignments removed.
\n"); } } @@ -1213,14 +1213,14 @@ if ($problem == 0) { $sql = "DELETE FROM res_mastersubject WHERE mastersubject_id =" . $mastersubject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Affected resource-mastersubject assignments removed.
\n"); } } @@ -1229,14 +1229,14 @@ if ($problem == 0) { $sql = "DELETE FROM mastersubject WHERE mastersubject_id =" . $mastersubject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed Master Subject successfully.

\n"); } } @@ -1289,8 +1289,8 @@ // Check subjects $sql = "SELECT COUNT(sm.subject_id) as num_subjects FROM sub_mastersubject sm WHERE sm.mastersubject_id =" . $mastersubject_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $num_subjects = $row["num_subjects"]; if ($num_subjects > 0) $problem = 1; @@ -1299,8 +1299,8 @@ // Check resources $sql = "SELECT COUNT(rm.resource_id) as num_resources FROM res_mastersubject rm WHERE rm.mastersubject_id = " . $mastersubject_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $num_resources = $row["num_resources"]; if ($num_resources > 1) $problem = 1; @@ -1361,15 +1361,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the resource form back @@ -1396,15 +1396,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the resource form back @@ -1432,15 +1432,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the resource form back @@ -1481,15 +1481,15 @@ // First delete all related rows in res_sub_infotype $sql = "DELETE FROM res_sub_infotype WHERE resource_id = " . $resource_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Resource removed from all resource-subject-infotype assignments.
\n"); } @@ -1498,14 +1498,14 @@ if ($problem == 0) { $sql = "DELETE FROM res_loc WHERE resource_id =" . $resource_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed from resource-location table.
\n"); } } @@ -1515,14 +1515,14 @@ $sql = "DELETE FROM res_mastersubject WHERE resource_id =" . $resource_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed from resource-mastersubject table.
\n"); } } @@ -1532,14 +1532,14 @@ $sql = "DELETE FROM res_feature WHERE resource_id =" . $resource_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed from resource-feature table.
\n"); } } @@ -1550,8 +1550,8 @@ // First, get the default resource description and title $sql = "SELECT annotation, title FROM resource WHERE resource_id = " . $resource_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $annotation = $row["annotation"]; $title = $row["title"]; @@ -1572,14 +1572,14 @@ . "'), resource_id = NULL WHERE resource_id =" . $resource_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions.
\n"); } @@ -1592,14 +1592,14 @@ . "', resource_id = NULL WHERE resource_id =" . $resource_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions.
\n"); } @@ -1618,14 +1618,14 @@ . "'), resource_id = NULL WHERE resource_id =" . $resource_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions (buffers).
\n"); } @@ -1638,14 +1638,14 @@ . "', resource_id = NULL WHERE resource_id =" . $resource_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions (buffers).
\n"); } @@ -1658,15 +1658,15 @@ $sql = "DELETE FROM resource WHERE resource_id =" . $resource_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } @@ -1776,15 +1776,15 @@ // First delete all related rows in serv_servtype $sql = "DELETE FROM serv_servtype WHERE service_id = " . $service_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Service removed from all service-servicetype assignments.
\n"); } @@ -1793,14 +1793,14 @@ if ($problem == 0) { $sql = "DELETE FROM serv_loc WHERE service_id =" . $service_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed from service-location table.
\n"); } } @@ -1812,8 +1812,8 @@ // First, get the default service description and title $sql = "SELECT service, serviceDescr FROM service WHERE service_id = " . $service_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $service = $row["service"]; $serviceDescr = $row["serviceDescr"]; @@ -1834,14 +1834,14 @@ . "'), service_id = NULL WHERE service_id =" . $service_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions.
\n"); } @@ -1854,14 +1854,14 @@ . "', service_id = NULL WHERE service_id =" . $service_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions.
\n"); } @@ -1880,14 +1880,14 @@ . "'), service_id = NULL WHERE service_id =" . $service_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions (buffers).
\n"); } @@ -1900,14 +1900,14 @@ . "', service_id = NULL WHERE service_id =" . $service_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions (buffers).
\n"); } @@ -1920,15 +1920,15 @@ $sql = "DELETE FROM service WHERE service_id =" . $service_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } @@ -2027,14 +2027,14 @@ // Delete from servicetype table $sql = "DELETE FROM servicetype WHERE servicetype_id =" . $servicetype_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed Service Type successfully.

\n"); } @@ -2125,15 +2125,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the service form back @@ -2161,15 +2161,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the service form back @@ -2198,15 +2198,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the subject form back @@ -2243,14 +2243,14 @@ // First delete all related rows in res_sub_infotype $sql = "DELETE FROM res_sub_infotype WHERE subject_id = " . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Resource-subject-information type associations removed.
\n"); } @@ -2258,14 +2258,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_loc WHERE subject_id =" . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-location associations removed.
\n"); } } @@ -2274,14 +2274,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_mastersubject WHERE subject_id =" . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-mastersubject associations removed.
\n"); } @@ -2291,14 +2291,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_staff WHERE subject_id =" . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-staff assignments removed.
\n"); } @@ -2308,14 +2308,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_coursesub WHERE subject_id =" . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-Course Subject assignments removed.
\n"); } @@ -2325,14 +2325,14 @@ if ($problem == 0) { $sql = "DELETE FROM sub_page WHERE subject_id =" . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-Page assignments removed.
\n"); } @@ -2345,14 +2345,14 @@ . " OR subject_id = " . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Subject-Other Subject assignments removed.
\n"); } @@ -2364,8 +2364,8 @@ // First, get the default subject description and title $sql = "SELECT subject, subject_descr FROM subject WHERE subject_id = " . $subject_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $subject = $row["subject"]; $subject_descr = $row["subject_descr"]; @@ -2386,14 +2386,14 @@ . "'), subject_id = NULL WHERE subject_id =" . $subject_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions.
\n"); } @@ -2406,14 +2406,14 @@ . "', subject_id = NULL WHERE subject_id =" . $subject_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions.
\n"); } @@ -2432,14 +2432,14 @@ . "'), subject_id = NULL WHERE subject_id =" . $subject_id . " AND (element_descr IS NOT NULL OR element_descr != '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions (buffers).
\n"); } @@ -2452,14 +2452,14 @@ . "', subject_id = NULL WHERE subject_id =" . $subject_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to default PageScribe descriptions (buffers).
\n"); } @@ -2470,14 +2470,14 @@ if ($problem == 0) { $sql = "DELETE FROM subject WHERE subject_id =" . $subject_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Successfully removed this subject from the system.

\n"); } @@ -2566,15 +2566,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the subject form back @@ -2603,15 +2603,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the subject form back @@ -2639,15 +2639,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the subject form back @@ -2681,14 +2681,14 @@ if ($libunit_id > 1) { $sql = "DELETE FROM libunit_staff WHERE libunit_id = " . $libunit_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Deleted all Library Unit staff assignments.
\n"); } @@ -2696,14 +2696,14 @@ if ($problem == 0) { $sql = "DELETE FROM libunit WHERE libunit_id =" . $libunit_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this Library Unit successfully.

\n"); } } @@ -2783,15 +2783,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the libunit form back @@ -2831,14 +2831,14 @@ $sql = "DELETE FROM sub_staff WHERE staff_id = " . $staff_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("All subject-staff assignments for this staff person removed.
\n"); } } @@ -2847,14 +2847,14 @@ if ($problem == 0) { $sql = "DELETE FROM course_personnel WHERE staff_id =" . $staff_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this staff person from course personnel tables.
\n"); } } // delete from course_personnel table @@ -2864,14 +2864,14 @@ $sql = "DELETE FROM page_staff WHERE staff_id = " . $staff_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("All page-staff assignments for this staff person removed.
\n"); } } @@ -2882,8 +2882,8 @@ // First, get the staff fields $sql = "SELECT first_name, last_name FROM staff WHERE staff_id = " . $staff_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $first_name = $row["first_name"]; $last_name = $row["last_name"]; @@ -2904,14 +2904,14 @@ . "'), staff_id = NULL WHERE staff_id =" . $staff_id . " AND element_descr IS NOT NULL AND element_descr <> ''"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions.
\n"); } } @@ -2926,14 +2926,14 @@ . "', staff_id = NULL WHERE staff_id =" . $staff_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to blank PageScribe descriptions.
\n"); } @@ -2950,14 +2950,14 @@ . "'), staff_id = NULL WHERE staff_id =" . $staff_id . " AND element_descr IS NOT NULL AND element_descr <> ''"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to custom PageScribe descriptions.
\n"); } } @@ -2972,14 +2972,14 @@ . "', staff_id = NULL WHERE staff_id =" . $staff_id . " AND (element_descr IS NULL OR element_descr = '')"; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Added delete message to blank PageScribe descriptions.
\n"); } @@ -2989,14 +2989,14 @@ if ($problem == 0) { $sql = "DELETE FROM staff WHERE staff_id =" . $staff_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this staff person successfully.

\n"); } } // delete from staff table @@ -3099,15 +3099,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the staff form back @@ -3138,15 +3138,15 @@ . $key_list_array[$element]; // Failed - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); } } // Call the staff form back @@ -3180,14 +3180,14 @@ if ($stafftitle_id > 1) { $sql = "UPDATE staff SET stafftitle_id = 1 WHERE stafftitle_id = " . $stafftitle_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Successfully set affected staff person job titles to (N/A).
\n"); } @@ -3195,14 +3195,14 @@ if ($problem == 0) { $sql = "DELETE FROM stafftitle WHERE stafftitle_id =" . $stafftitle_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this job title successfully.

\n"); } } @@ -3292,14 +3292,14 @@ if ($style_id > 2) { $sql = "UPDATE page SET style_id = 1 WHERE style_id = " . $style_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Successfully set affected page styles to (N/A).
\n"); } @@ -3307,14 +3307,14 @@ if ($problem == 0) { $sql = "DELETE FROM style WHERE style_id =" . $style_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this style successfully.

\n"); } } @@ -3413,14 +3413,14 @@ // Delete all course term assignments $sql = "UPDATE course SET term_id = NULL WHERE term_id =" . $term_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed this term from affected course pages.
\n"); } @@ -3430,14 +3430,14 @@ // Delete from term table $sql = "DELETE FROM term WHERE term_id =" . $term_id; - if (!mysql_query ($sql, $con)){ + if (!xx_query ($sql, $con)){ $problem = 1; sql_err($sql); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } else { - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); printf("Removed term successfully.

\n"); } }