--- branches/paul/admin/scribe_stats.phtml	2004/03/18 19:58:18	68
+++ branches/paul_xx/admin/scribe_stats.phtml	2004/03/18 20:01:09	69
@@ -88,8 +88,8 @@
 
 	$sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date
 		FROM libstats.pagestats";
-	$rs = mysql_tryquery($sql);	
-	$row = mysql_fetch_array ($rs, MYSQL_ASSOC);
+	$rs = xx_tryquery($sql);	
+	$row = xx_fetch_array ($rs, xx_ASSOC);
 	$min_date = $row["min_date"];
 	$max_date = $row["max_date"];
 	
@@ -279,14 +279,14 @@
 		p.page_title";
 
 
-	$rs = mysql_tryquery($sql);
+	$rs = xx_tryquery($sql);
 	
 	// Initialize
 	$rowcount = 0;
 	$page_loads_total = 0;
 	$element_uses_total = 0;	
 
-	while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 		// Fetch the stuff
 		$page_id = $row["page_id"];
@@ -316,8 +316,8 @@
 			. "' AND visit_date <= '"
 			. $end_stamp
 			. "'";
-		$stats_rs = mysql_tryquery($stats_sql);
-		$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);
+		$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);
@@ -333,8 +333,8 @@
 			. $end_stamp
 			. "'";
 
-		$stats_rs = mysql_tryquery($stats_sql);
-		$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);
+		$stats_rs = xx_tryquery($stats_sql);
+		$stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
 		$element_uses = $stats_row["element_uses"];
 
 
@@ -398,14 +398,14 @@
 		ORDER BY c.course_concat";
 
 
-	$rs = mysql_tryquery($sql);
+	$rs = xx_tryquery($sql);
 	
 	// Initialize
 	$rowcount = 0;
 	$page_loads_total = 0;
 	$element_uses_total = 0;
 
-	while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 		// Fetch the stuff
 		$page_id = $row["page_id"];
@@ -439,8 +439,8 @@
 			. "' AND visit_date <= '"
 			. $end_stamp
 			. "'";	
-		$stats_rs = mysql_tryquery($stats_sql);
-		$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);
+		$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);
@@ -455,8 +455,8 @@
 			. "' AND visit_date <= '"
 			. $end_stamp
 			. "'";	
-		$stats_rs = mysql_tryquery($stats_sql);
-		$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);
+		$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