--- branches/paul/admin/include/assign.php	2004/03/18 19:24:54	67
+++ branches/paul_xx/admin/include/assign.php	2004/03/18 20:01:09	69
@@ -41,8 +41,8 @@
 		// Check to make sure that the staff isn't already assigned
 		$sql = "SELECT * FROM libunit_staff WHERE libunit_id = " . $libunit_id .
 		" AND staff_id = " . $staff_id_array[$subscript];
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 	
 			$sql = "INSERT INTO libunit_staff (libunit_id, staff_id) VALUES ("
 				. $libunit_id
@@ -50,7 +50,7 @@
 				. $staff_id_array[$subscript]
 				. ")";
 	
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // staff not already assigned
 
@@ -82,8 +82,8 @@
 			. " AND feature_id = "
 			. $feature_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 	
 			$sql = "INSERT INTO res_feature (resource_id, feature_id) VALUES ("
 				. $resource_id
@@ -91,7 +91,7 @@
 				. $feature_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // feature not already assigned
 
@@ -123,8 +123,8 @@
 			. " AND location_id = "
 			. $location_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO res_loc (resource_id, location_id) VALUES ("
 				. $resource_id
@@ -132,7 +132,7 @@
 				. $location_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 
 		} // location not already assigned
 
@@ -164,8 +164,8 @@
 			. " AND mastersubject_id = "
 			. $mastersubject_id_array[$subscript];
 		
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO res_mastersubject (resource_id, mastersubject_id) VALUES ("
 				. $resource_id
@@ -173,7 +173,7 @@
 				. $mastersubject_id_array[$subscript]
 				. ")";
 	
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 
 		} // mastersubject not already assigned
 
@@ -205,8 +205,8 @@
 			. " AND location_id = "
 			. $location_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 	
 			$sql = "INSERT INTO serv_loc (service_id, location_id) VALUES ("
 				. $service_id
@@ -214,7 +214,7 @@
 				. $location_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // location not already assigned
 
@@ -246,8 +246,8 @@
 			. " AND servicetype_id = "
 			. $servicetype_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO serv_servtype (service_id, servicetype_id) VALUES ("
 				. $service_id
@@ -255,7 +255,7 @@
 				. $servicetype_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // servicetype not already assigned
 
@@ -289,8 +289,8 @@
 			. " AND libunit_id = "
 			. $libunit_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO libunit_staff (libunit_id, staff_id) VALUES ("
 				. $libunit_id_array[$subscript]
@@ -298,7 +298,7 @@
 				. $staff_id
 				. ")";
 	
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // assignment didn't already exist
 
@@ -330,8 +330,8 @@
 			. " AND subject_id = "
 			. $subject_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES ("
 				. $subject_id_array[$subscript]
@@ -339,7 +339,7 @@
 				. $staff_id
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // assignment didn't already exist
 
@@ -371,8 +371,8 @@
 			. " AND coursesub_id = "
 			. $coursesub_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO sub_coursesub (subject_id, coursesub_id) VALUES ("
 				. $subject_id
@@ -380,7 +380,7 @@
 				. $coursesub_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // coursesub not already assigned
 
@@ -412,8 +412,8 @@
 			. " AND location_id = "
 			. $location_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO sub_loc (subject_id, location_id) VALUES ("
 				. $subject_id
@@ -421,7 +421,7 @@
 				. $location_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // location not already assigned
 
@@ -453,8 +453,8 @@
 			. " AND mastersubject_id = "
 			. $mastersubject_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO sub_mastersubject (subject_id, mastersubject_id) VALUES ("
 				. $subject_id
@@ -462,7 +462,7 @@
 				. $mastersubject_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 			
 		} // location not already assigned
 
@@ -494,8 +494,8 @@
 			. " AND staff_id = "
 			. $staff_id_array[$subscript];
 
-		$rs = mysql_tryquery($sql);
-		if (mysql_num_rows($rs) == 0) {
+		$rs = xx_tryquery($sql);
+		if (xx_num_rows($rs) == 0) {
 
 			$sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES ("
 				. $subject_id
@@ -503,7 +503,7 @@
 				. $staff_id_array[$subscript]
 				. ")";
 
-			mysql_tryquery($sql);
+			xx_tryquery($sql);
 		}
 
 	} // array of staff id's