61 |
FROM libstats.elementstats |
FROM libstats.elementstats |
62 |
WHERE page_id = " |
WHERE page_id = " |
63 |
. $page_id; |
. $page_id; |
64 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
65 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
66 |
$min_date = $row["min_date"]; |
$min_date = $row["min_date"]; |
67 |
$max_date = $row["max_date"]; |
$max_date = $row["max_date"]; |
68 |
|
|
75 |
WHERE p.page_id = " |
WHERE p.page_id = " |
76 |
. $page_id; |
. $page_id; |
77 |
|
|
78 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
79 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
80 |
$page_title = $row["page_title"]; |
$page_title = $row["page_title"]; |
81 |
$course_concat = $row["course_concat"]; |
$course_concat = $row["course_concat"]; |
82 |
|
|
160 |
|
|
161 |
//printf($sql); |
//printf($sql); |
162 |
|
|
163 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
164 |
|
|
165 |
// Initialize counters |
// Initialize counters |
166 |
$row_num = 0; |
$row_num = 0; |
167 |
$total_hits = 0; |
$total_hits = 0; |
168 |
|
|
169 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
170 |
|
|
171 |
// Element related |
// Element related |
172 |
$element_id = $row["element_id"]; |
$element_id = $row["element_id"]; |
283 |
if (strlen($start_stamp) > 0) $stats_sql .= " AND visit_date >= '" . $start_stamp . "'"; |
if (strlen($start_stamp) > 0) $stats_sql .= " AND visit_date >= '" . $start_stamp . "'"; |
284 |
if (strlen($end_stamp) > 0) $stats_sql .= " AND visit_date <= '" . $end_stamp . "'"; |
if (strlen($end_stamp) > 0) $stats_sql .= " AND visit_date <= '" . $end_stamp . "'"; |
285 |
|
|
286 |
$stats_rs = mysql_tryquery($stats_sql); |
$stats_rs = xx_tryquery($stats_sql); |
287 |
$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC); |
$stats_row = xx_fetch_array ($stats_rs, xx_ASSOC); |
288 |
$element_hits = $stats_row["element_hits"]; |
$element_hits = $stats_row["element_hits"]; |
289 |
|
|
290 |
// Cover the NULL value |
// Cover the NULL value |