17 |
printf("</HEAD>\n"); |
printf("</HEAD>\n"); |
18 |
|
|
19 |
|
|
20 |
|
// Default access settings |
21 |
|
$sess_time_human = ""; |
22 |
|
$sess_staff_account = ""; |
23 |
|
$sess_staff_id = 0; |
24 |
|
$sess_access_level = 0; |
25 |
|
$sess_access = ""; |
26 |
|
$sess_last_name = ""; |
27 |
|
$sess_first_name = ""; |
28 |
|
|
29 |
|
|
30 |
// Page header |
// Page header |
31 |
require_once ($GLOBAL_ADMIN_HEADER); |
require_once ($GLOBAL_ADMIN_HEADER); |
32 |
|
|
88 |
|
|
89 |
$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 |
90 |
FROM libstats.pagestats"; |
FROM libstats.pagestats"; |
91 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
92 |
$row = mysql_fetch_array ($rs); |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
93 |
$min_date = $row["min_date"]; |
$min_date = $row["min_date"]; |
94 |
$max_date = $row["max_date"]; |
$max_date = $row["max_date"]; |
95 |
|
|
279 |
p.page_title"; |
p.page_title"; |
280 |
|
|
281 |
|
|
282 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
283 |
|
|
284 |
// Initialize |
// Initialize |
285 |
$rowcount = 0; |
$rowcount = 0; |
286 |
$page_loads_total = 0; |
$page_loads_total = 0; |
287 |
$element_uses_total = 0; |
$element_uses_total = 0; |
288 |
|
|
289 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
290 |
|
|
291 |
// Fetch the stuff |
// Fetch the stuff |
292 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
316 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
317 |
. $end_stamp |
. $end_stamp |
318 |
. "'"; |
. "'"; |
319 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = mysql_tryquery($stats_sql); |
320 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC); |
321 |
$page_loads = $stats_row["page_loads"]; |
$page_loads = $stats_row["page_loads"]; |
322 |
|
|
323 |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
333 |
. $end_stamp |
. $end_stamp |
334 |
. "'"; |
. "'"; |
335 |
|
|
336 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = mysql_tryquery($stats_sql); |
337 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC); |
338 |
$element_uses = $stats_row["element_uses"]; |
$element_uses = $stats_row["element_uses"]; |
339 |
|
|
340 |
|
|
398 |
ORDER BY c.course_concat"; |
ORDER BY c.course_concat"; |
399 |
|
|
400 |
|
|
401 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
402 |
|
|
403 |
// Initialize |
// Initialize |
404 |
$rowcount = 0; |
$rowcount = 0; |
405 |
$page_loads_total = 0; |
$page_loads_total = 0; |
406 |
$element_uses_total = 0; |
$element_uses_total = 0; |
407 |
|
|
408 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
409 |
|
|
410 |
// Fetch the stuff |
// Fetch the stuff |
411 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
439 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
440 |
. $end_stamp |
. $end_stamp |
441 |
. "'"; |
. "'"; |
442 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = mysql_tryquery($stats_sql); |
443 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC); |
444 |
$page_loads = $stats_row["page_loads"]; |
$page_loads = $stats_row["page_loads"]; |
445 |
|
|
446 |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads); |
455 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
456 |
. $end_stamp |
. $end_stamp |
457 |
. "'"; |
. "'"; |
458 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = mysql_tryquery($stats_sql); |
459 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC); |
460 |
$element_uses = $stats_row["element_uses"]; |
$element_uses = $stats_row["element_uses"]; |
461 |
|
|
462 |
// Encode the date limits |
// Encode the date limits |