\n"); chdir("/m/data1/app.hotlunches.net"); $databases = array(array('hotlunch','localhost'), ); // $databases = array(array('hotlunch','localhost')); $names = array('Hot Lunches', ); $minutes = 5; $time = time() - 60 * $minutes; $datetime = date("Y-m-d H:i:s",$time); $today = date("Y-m-d",$time); $total = 0; for ($i = 0; $i < count($databases); $i++) { $db_name = $databases[$i][0]; $db_host = $databases[$i][1]; $name = $names[$i]; echo("USE $db_name\n"); db_query("USE $db_name"); if ($db_name == 'hotlunch') { $query = "SELECT school_num,userid,max(activity_datetime) AS dt,school_name " . "FROM activity_log,schools " . "WHERE activity_time > $time " . "AND school_num = schools.record_num " . "GROUP BY 1,2,4 " . "ORDER BY school_name,userid"; } else { $query = "SELECT DISTINCT school_num,userid FROM login_log WHERE last_activity_date >= '$today' AND last_activity > $time"; } $results = db_query($query); $numEntries = db_num_rows($results); $total += $numEntries; printf("%30s: %5d\n",$name,$numEntries); } printf("%30s: %5d\n\n","Total Users",$total); // db_query("USE ezs"); // $query = "SELECT max_users FROM daily_load WHERE server = 'web2-db' AND log_date = '$today'"; // $max = db_getVal($query); // printf("%30s: %5d\n\n","Max Users",$max); ?>