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.substats"; |
FROM libstats.substats"; |
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 |
|
|
259 |
WHERE s.subject_id > 1 |
WHERE s.subject_id > 1 |
260 |
ORDER BY s.subject"; |
ORDER BY s.subject"; |
261 |
|
|
262 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
263 |
|
|
264 |
// Initialize |
// Initialize |
265 |
$rowcount = 0; |
$rowcount = 0; |
266 |
$sub_loads_total = 0; |
$sub_loads_total = 0; |
267 |
|
|
268 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
269 |
|
|
270 |
// Fetch the stuff |
// Fetch the stuff |
271 |
$subject_id = $row["subject_id"]; |
$subject_id = $row["subject_id"]; |
295 |
. "' AND visit_date <= '" |
. "' AND visit_date <= '" |
296 |
. $end_stamp |
. $end_stamp |
297 |
. "'"; |
. "'"; |
298 |
$stats_rs = mysql_query($stats_sql, $con); |
$stats_rs = xx_query($stats_sql, $con); |
299 |
$stats_row = mysql_fetch_array ($stats_rs); |
$stats_row = xx_fetch_array ($stats_rs); |
300 |
$sub_loads = $stats_row["sub_loads"]; |
$sub_loads = $stats_row["sub_loads"]; |
301 |
|
|
302 |
printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads); |
printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads); |