--- 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");
}
}