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