--- trunk/admin/scribe_stats_page.phtml 2004/03/04 22:43:17 41
+++ trunk/admin/scribe_stats_page.phtml 2004/03/04 22:43:50 42
@@ -51,8 +51,8 @@
FROM libstats.elementstats
WHERE page_id = "
. $page_id;
- $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"];
@@ -65,8 +65,8 @@
WHERE p.page_id = "
. $page_id;
- $rs = mysql_query($sql, $con);
- $row = mysql_fetch_array ($rs);
+ $rs = xx_query($sql, $con);
+ $row = xx_fetch_array ($rs);
$page_title = $row["page_title"];
$course_concat = $row["course_concat"];
@@ -150,13 +150,13 @@
//printf($sql);
- $rs = mysql_query($sql, $con);
+ $rs = xx_query($sql, $con);
// Initialize counters
$row_num = 0;
$total_hits = 0;
- while ($row = mysql_fetch_array ($rs)) {
+ while ($row = xx_fetch_array ($rs)) {
// Element related
$element_id = $row["element_id"];
@@ -273,8 +273,8 @@
if (strlen($start_stamp) > 0) $stats_sql .= " AND visit_date >= '" . $start_stamp . "'";
if (strlen($end_stamp) > 0) $stats_sql .= " 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_hits = $stats_row["element_hits"];
// Cover the NULL value