--- trunk/admin/subject_stats.phtml	2004/03/04 22:43:50	42
+++ trunk/admin/subject_stats.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);
 
@@ -78,8 +88,8 @@
 
 	$sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date
 		FROM libstats.substats";
-	$rs = xx_query($sql, $con);	
-	$row = xx_fetch_array ($rs);
+	$rs = xx_tryquery($sql);	
+	$row = xx_fetch_array ($rs, xx_ASSOC);
 	$min_date = $row["min_date"];
 	$max_date = $row["max_date"];
 	
@@ -259,13 +269,13 @@
 		WHERE s.subject_id > 1
 		ORDER BY s.subject";
 
-	$rs = xx_query($sql, $con);
+	$rs = xx_tryquery($sql);
 	
 	// Initialize
 	$rowcount = 0;
 	$sub_loads_total = 0;
 
-	while ($row = xx_fetch_array ($rs)) {
+	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 		// Fetch the stuff
 		$subject_id = $row["subject_id"];
@@ -295,8 +305,8 @@
 			. "' AND visit_date <= '"
 			. $end_stamp
 			. "'";
-		$stats_rs = xx_query($stats_sql, $con);
-		$stats_row = xx_fetch_array ($stats_rs);
+		$stats_rs = xx_tryquery($stats_sql);
+		$stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
 		$sub_loads = $stats_row["sub_loads"];
 		
 		printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads);