51 |
FROM libstats.elementstats |
FROM libstats.elementstats |
52 |
WHERE page_id = " |
WHERE page_id = " |
53 |
. $page_id; |
. $page_id; |
54 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
55 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
56 |
$min_date = $row["min_date"]; |
$min_date = $row["min_date"]; |
57 |
$max_date = $row["max_date"]; |
$max_date = $row["max_date"]; |
58 |
|
|
65 |
WHERE p.page_id = " |
WHERE p.page_id = " |
66 |
. $page_id; |
. $page_id; |
67 |
|
|
68 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
69 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
70 |
$page_title = $row["page_title"]; |
$page_title = $row["page_title"]; |
71 |
$course_concat = $row["course_concat"]; |
$course_concat = $row["course_concat"]; |
72 |
|
|
150 |
|
|
151 |
//printf($sql); |
//printf($sql); |
152 |
|
|
153 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
154 |
|
|
155 |
// Initialize counters |
// Initialize counters |
156 |
$row_num = 0; |
$row_num = 0; |
157 |
$total_hits = 0; |
$total_hits = 0; |
158 |
|
|
159 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
160 |
|
|
161 |
// Element related |
// Element related |
162 |
$element_id = $row["element_id"]; |
$element_id = $row["element_id"]; |
273 |
if (strlen($start_stamp) > 0) $stats_sql .= " AND visit_date >= '" . $start_stamp . "'"; |
if (strlen($start_stamp) > 0) $stats_sql .= " AND visit_date >= '" . $start_stamp . "'"; |
274 |
if (strlen($end_stamp) > 0) $stats_sql .= " AND visit_date <= '" . $end_stamp . "'"; |
if (strlen($end_stamp) > 0) $stats_sql .= " AND visit_date <= '" . $end_stamp . "'"; |
275 |
|
|
276 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = xx_query($stats_sql, $con); |
277 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = xx_fetch_array ($stats_rs); |
278 |
$element_hits = $stats_row["element_hits"]; |
$element_hits = $stats_row["element_hits"]; |
279 |
|
|
280 |
// Cover the NULL value |
// Cover the NULL value |