--- trunk/admin/scribe_stats.phtml 2004/03/04 22:43:17 41 +++ trunk/admin/scribe_stats.phtml 2004/03/04 22:43:50 42 @@ -78,8 +78,8 @@ $sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date FROM libstats.pagestats"; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $min_date = $row["min_date"]; $max_date = $row["max_date"]; @@ -269,14 +269,14 @@ p.page_title"; - $rs = mysql_query($sql, $con); + $rs = xx_query($sql, $con); // Initialize $rowcount = 0; $page_loads_total = 0; $element_uses_total = 0; - while ($row = mysql_fetch_array ($rs)) { + while ($row = xx_fetch_array ($rs)) { // Fetch the stuff $page_id = $row["page_id"]; @@ -306,8 +306,8 @@ . "' AND visit_date <= '" . $end_stamp . "'"; - $stats_rs = mysql_query($stats_sql, $con); - $stats_row = mysql_fetch_array ($stats_rs); + $stats_rs = xx_query($stats_sql, $con); + $stats_row = xx_fetch_array ($stats_rs); $page_loads = $stats_row["page_loads"]; printf("%d\n", $color, $page_loads); @@ -323,8 +323,8 @@ . $end_stamp . "'"; - $stats_rs = mysql_query($stats_sql, $con); - $stats_row = mysql_fetch_array ($stats_rs); + $stats_rs = xx_query($stats_sql, $con); + $stats_row = xx_fetch_array ($stats_rs); $element_uses = $stats_row["element_uses"]; @@ -388,14 +388,14 @@ ORDER BY c.course_concat"; - $rs = mysql_query($sql, $con); + $rs = xx_query($sql, $con); // Initialize $rowcount = 0; $page_loads_total = 0; $element_uses_total = 0; - while ($row = mysql_fetch_array ($rs)) { + while ($row = xx_fetch_array ($rs)) { // Fetch the stuff $page_id = $row["page_id"]; @@ -429,8 +429,8 @@ . "' AND visit_date <= '" . $end_stamp . "'"; - $stats_rs = mysql_query($stats_sql, $con); - $stats_row = mysql_fetch_array ($stats_rs); + $stats_rs = xx_query($stats_sql, $con); + $stats_row = xx_fetch_array ($stats_rs); $page_loads = $stats_row["page_loads"]; printf("%d\n", $color, $page_loads); @@ -445,8 +445,8 @@ . "' AND visit_date <= '" . $end_stamp . "'"; - $stats_rs = mysql_query($stats_sql, $con); - $stats_row = mysql_fetch_array ($stats_rs); + $stats_rs = xx_query($stats_sql, $con); + $stats_row = xx_fetch_array ($stats_rs); $element_uses = $stats_row["element_uses"]; // Encode the date limits