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.substats"; |
FROM libstats.substats"; |
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 |
|
|
269 |
WHERE s.subject_id > 1 |
WHERE s.subject_id > 1 |
270 |
ORDER BY s.subject"; |
ORDER BY s.subject"; |
271 |
|
|
272 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
273 |
|
|
274 |
// Initialize |
// Initialize |
275 |
$rowcount = 0; |
$rowcount = 0; |
276 |
$sub_loads_total = 0; |
$sub_loads_total = 0; |
277 |
|
|
278 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
279 |
|
|
280 |
// Fetch the stuff |
// Fetch the stuff |
281 |
$subject_id = $row["subject_id"]; |
$subject_id = $row["subject_id"]; |
305 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
306 |
. $end_stamp |
. $end_stamp |
307 |
. "'"; |
. "'"; |
308 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = mysql_tryquery($stats_sql); |
309 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC); |
310 |
$sub_loads = $stats_row["sub_loads"]; |
$sub_loads = $stats_row["sub_loads"]; |
311 |
|
|
312 |
printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads); |
printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads); |