78 |
|
|
79 |
$sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date |
$sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date |
80 |
FROM libstats.pagestats"; |
FROM libstats.pagestats"; |
81 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
82 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
83 |
$min_date = $row["min_date"]; |
$min_date = $row["min_date"]; |
84 |
$max_date = $row["max_date"]; |
$max_date = $row["max_date"]; |
85 |
|
|
269 |
p.page_title"; |
p.page_title"; |
270 |
|
|
271 |
|
|
272 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
273 |
|
|
274 |
// Initialize |
// Initialize |
275 |
$rowcount = 0; |
$rowcount = 0; |
276 |
$page_loads_total = 0; |
$page_loads_total = 0; |
277 |
$element_uses_total = 0; |
$element_uses_total = 0; |
278 |
|
|
279 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
280 |
|
|
281 |
// Fetch the stuff |
// Fetch the stuff |
282 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
306 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
307 |
. $end_stamp |
. $end_stamp |
308 |
. "'"; |
. "'"; |
309 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = xx_query($stats_sql, $con); |
310 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = xx_fetch_array ($stats_rs); |
311 |
$page_loads = $stats_row["page_loads"]; |
$page_loads = $stats_row["page_loads"]; |
312 |
|
|
313 |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
323 |
. $end_stamp |
. $end_stamp |
324 |
. "'"; |
. "'"; |
325 |
|
|
326 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = xx_query($stats_sql, $con); |
327 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = xx_fetch_array ($stats_rs); |
328 |
$element_uses = $stats_row["element_uses"]; |
$element_uses = $stats_row["element_uses"]; |
329 |
|
|
330 |
|
|
388 |
ORDER BY c.course_concat"; |
ORDER BY c.course_concat"; |
389 |
|
|
390 |
|
|
391 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
392 |
|
|
393 |
// Initialize |
// Initialize |
394 |
$rowcount = 0; |
$rowcount = 0; |
395 |
$page_loads_total = 0; |
$page_loads_total = 0; |
396 |
$element_uses_total = 0; |
$element_uses_total = 0; |
397 |
|
|
398 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
399 |
|
|
400 |
// Fetch the stuff |
// Fetch the stuff |
401 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
429 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
430 |
. $end_stamp |
. $end_stamp |
431 |
. "'"; |
. "'"; |
432 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = xx_query($stats_sql, $con); |
433 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = xx_fetch_array ($stats_rs); |
434 |
$page_loads = $stats_row["page_loads"]; |
$page_loads = $stats_row["page_loads"]; |
435 |
|
|
436 |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
445 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
446 |
. $end_stamp |
. $end_stamp |
447 |
. "'"; |
. "'"; |
448 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = xx_query($stats_sql, $con); |
449 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = xx_fetch_array ($stats_rs); |
450 |
$element_uses = $stats_row["element_uses"]; |
$element_uses = $stats_row["element_uses"]; |
451 |
|
|
452 |
// Encode the date limits |
// Encode the date limits |