62 lines
1.6 KiB
PHP
62 lines
1.6 KiB
PHP
<?php
|
|
$ValidAccess = 2010;
|
|
chdir("/m/data1/app.hotlunches.net");
|
|
require_once("include/globals.php");
|
|
|
|
$db_uname = "mark";
|
|
$db_pass = "hugger1";
|
|
|
|
if (isset($_SERVER['HTTP_USER_AGENT'])) {
|
|
if (SessionActive() != 1 || ! UserLoggedIn()) {
|
|
$error_message = getLanguageText('ERRORMSG-ACCESS-DENIED');
|
|
header("Location: /?error_message=".urlencode($error_message));
|
|
exit();
|
|
}
|
|
}
|
|
|
|
echo("<pre>\n");
|
|
|
|
$databases = array(array('hotlunch','localhost'),
|
|
);
|
|
$names = array('Hot Lunches',
|
|
);
|
|
|
|
$minutes = 5;
|
|
$time = time() - 60 * $minutes;
|
|
$today = date("Y-m-d",$time);
|
|
|
|
for ($i = 0; $i < count($databases); $i++) {
|
|
$db_name = $databases[$i][0];
|
|
$db_host = $databases[$i][1];
|
|
$name = $names[$i];
|
|
|
|
db_query("USE $db_name");
|
|
|
|
$query = "SELECT DISTINCT school_num,userid,school_name " .
|
|
"FROM activity_log,schools " .
|
|
"WHERE activity_time > $time " .
|
|
"AND school_num = schools.record_num " .
|
|
"ORDER BY school_name,userid";
|
|
$results = db_query($query);
|
|
$numEntries = db_num_rows($results);
|
|
|
|
printf("%30s: %5d\n",$name,$numEntries);
|
|
|
|
$prev = 0;
|
|
while ($row = db_fetch_assoc($results)) {
|
|
extract($row);
|
|
|
|
$dt = db_getVal("SELECT max(activity_time) FROM activity_log WHERE userid = '$userid' AND school_num = $school_num AND activity_time > $time");
|
|
if ($school_num != $prev) {
|
|
echo(" - $school_name\n");
|
|
}
|
|
|
|
printf(" -> %20s: %s\n",$dt,$userid);
|
|
|
|
$prev = $school_num;
|
|
}
|
|
echo("\n");
|
|
}
|
|
|
|
?>
|