= DATE_SUB(CURDATE(), INTERVAL " . (int)$days . " DAY) GROUP BY login_date" ); while ($row = @mysqli_fetch_assoc($result)) { $rows[$row['login_date']] = (int)$row['cnt']; } $labels = []; $values = []; for ($i = $days - 1; $i >= 0; $i--) { $date = date('Y-m-d', strtotime("-{$i} days")); $labels[] = date('d.m.', strtotime($date)); $values[] = $rows[$date] ?? 0; } return ['labels' => $labels, 'values' => $values]; } function listUsers(){ $query = "SELECT * FROM main_contact ORDER BY last_interaction DESC LIMIT 20"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); while ($main_contact = @mysqli_fetch_array($result)) { $last_interaction = new DateTime($main_contact['last_interaction']); $current_datetime = new DateTime(); $diff = $last_interaction->diff($current_datetime); $hours = $diff->h; $minutes = $diff->i; if($diff->d >= 1){ $status = "Zuletzt am {$last_interaction->format('d.m.Y')} aktiv"; $status_color = 'red'; }else if($hours > 3){ $status = "Zuletzt um {$last_interaction->format('H:i')} Uhr aktiv"; $status_color = 'red'; }else if($hours >= 1){ $status = "Vor {$hours} Stunde(n) aktiv"; $status_color = 'yellow'; }else if($minutes >= 5){ $status = "Vor {$minutes} Minuten aktiv"; $status_color = 'yellow'; }else{ $status = "Jetzt aktiv"; $status_color = 'green'; } echo "
"; if($main_contact['image'] == ""){ echo "
"; }else{ echo "
"; } echo "
"; echo "

".$main_contact['name']."

"; echo "

".$status."

"; echo "
"; echo "
"; } } function loadNews(){ $file_server = 'https://breadcrumb-solutions.de/news.xml'; $xml = simplexml_load_file($file_server); $temp = mb_convert_encoding( file_get_contents($file_server), 'UTF-8' ); $array = simplexml_load_string($temp); $i = 1; foreach ($array -> news as $news) { if($i <= 2){?>

category ?>

headline ?>

teaser ?>

Mehr erfahren

Willkommen zurück,

Aktionen

Übersicht

Intranet Basis

Anmeldungen (letzte 30 Tage)