--- trunk/admin/scribe_stats.phtml	2004/03/18 20:21:08	71
+++ trunk/admin/scribe_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.pagestats";
-	$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"];
 	
@@ -269,14 +279,14 @@
 		p.page_title";
 
 
-	$rs = xx_query($sql, $con);
+	$rs = xx_tryquery($sql);
 	
 	// Initialize
 	$rowcount = 0;
 	$page_loads_total = 0;
 	$element_uses_total = 0;	
 
-	while ($row = xx_fetch_array ($rs)) {
+	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 		// Fetch the stuff
 		$page_id = $row["page_id"];
@@ -306,8 +316,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);
 		$page_loads = $stats_row["page_loads"];		
 		
 		printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads);
@@ -323,8 +333,8 @@
 			. $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);
 		$element_uses = $stats_row["element_uses"];
 
 
@@ -388,14 +398,14 @@
 		ORDER BY c.course_concat";
 
 
-	$rs = xx_query($sql, $con);
+	$rs = xx_tryquery($sql);
 	
 	// Initialize
 	$rowcount = 0;
 	$page_loads_total = 0;
 	$element_uses_total = 0;
 
-	while ($row = xx_fetch_array ($rs)) {
+	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 		// Fetch the stuff
 		$page_id = $row["page_id"];
@@ -429,8 +439,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);
 		$page_loads = $stats_row["page_loads"];		
 		
 		printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads);
@@ -445,8 +455,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);
 		$element_uses = $stats_row["element_uses"];
 		
 		// Encode the date limits