$result=$db->query("SELECT id,examples,nexamples FROM sessions ORDER BY id");
$SESSIONS_next = -1;
$SESSIONS_actual = -1;
+ $SESSIONS_n = 0;
while ($session = $result->fetch(PDO::FETCH_ASSOC)) {
$SESSIONS[$session['id']] = array("id" => $session['id'], "timestr" => date("d.m.Y H:i", $session['id']),
if ( strtotime("now") < $session['id'] + 3600 && ( $SESSIONS_actual==-1 || $SESSIONS_actual > $session['id'] ) ) {
$SESSIONS_actual = $session['id'];
}
+ $SESSIONS_n++;
}
if($SESSIONS_next == -1) unset($SESSIONS_next);
if($SESSIONS_actual == -1) unset($SESSIONS_actual);
$SESSIONS_totex = 0;
- foreach ($SESSIONS as $session) {
- if($session['id'] < $SESSIONS_next) { $SESSIONS_totex += $session['nexamples']; }
+ if(isset($SESSIONS)) {
+ foreach ($SESSIONS as $session) {
+ if($session['id'] < $SESSIONS_next) { $SESSIONS_totex += $session['nexamples']; }
+ }
}
$SESSIONS_totex_nextinc = 0;
- foreach ($SESSIONS as $session) {
- if($session['id'] <= $SESSIONS_next) { $SESSIONS_totex_nextinc += $session['nexamples']; }
+ if( isset($SESSIONS) && isset($SESSIONS_next) ) {
+ foreach ($SESSIONS as $session) {
+ if($session['id'] <= $SESSIONS_next) { $SESSIONS_totex_nextinc += $session['nexamples']; }
+ }
}
}
?>