--- trunk/admin/infotype_drill.phtml	2003/12/05 18:34:18	1
+++ trunk/admin/infotype_drill.phtml	2004/03/18 20:33:37	72
@@ -17,6 +17,16 @@
 printf("</HEAD>\n");
 
 
+// Default access settings
+$sess_time_human = "";
+$sess_staff_account = "";
+$sess_staff_id = 0;
+$sess_access_level = 0;
+$sess_access = "";
+$sess_last_name = "";
+$sess_first_name = "";
+
+
 // Page header
 require_once ($GLOBAL_ADMIN_HEADER);
 
@@ -43,7 +53,7 @@
 
 
 	// Fetch the information type descr. field
-	$infotype = lookupField($con, "infotype", "infotype_id", $infotype_id, "infotype");
+	$infotype = lookupField("infotype", "infotype_id", $infotype_id, "infotype");
 
 	printf("<center>\n");
 	printf("<h3>Information Type '%s' (#%d) used on the following RQS Pages:</h3>", $infotype, $infotype_id);
@@ -78,10 +88,10 @@
 	// Initialize counter
 	$rowcount = 0;
 
-	$rs = mysql_query($sql, $con);
+	$rs = xx_tryquery($sql);
 
 	// Cycle through the result set
-	while ( $row = mysql_fetch_array ( $rs ) ) {
+	while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$subject = Trim($row["subject"]);
 		$subject_id = Trim($row["subject_id"]);			
 		$title = Trim($row["title"]);
@@ -106,8 +116,8 @@
 	*****************************/
 	
 	printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</td>\n");
-	if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
-	else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
+	if (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
+	else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs));
 	printf("</tr>\n");
 
 	// Close table
@@ -135,10 +145,10 @@
 	// Initialize counter
 	$rowcount = 0;
 
-	$rs = mysql_query($sql, $con);
+	$rs = xx_tryquery($sql);
 
 	// Cycle through the result set
-	while ( $row = mysql_fetch_array ( $rs ) ) {
+	while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$resource_id = Trim($row["resource_id"]);			
 		$title = Trim($row["title"]);
 
@@ -158,8 +168,8 @@
 
 	// Summary of occurences in resources
 	printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n");
-	if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
-	else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
+	if (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
+	else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs));
 	printf("</tr>\n");
 
 	// Close table