--- 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