53 lines
1.7 KiB
PHP
53 lines
1.7 KiB
PHP
<?php
|
|
/*
|
|
# Fuer debugging
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', 1);
|
|
#echo __LINE__."<br>";
|
|
*/
|
|
|
|
include_once 'classes/lg-on_Smarty.class.php';
|
|
$smarty = new lgon_Smarty();
|
|
require_once("config.inc.php");
|
|
require_once("func_rollenrechte.php");
|
|
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
|
|
require_once "language/german.inc.php";
|
|
|
|
$db = dbconnect();
|
|
|
|
|
|
$result_ges = $db->query( "SELECT count(*) Anz FROM userlog" );
|
|
$row_ges = $result_ges->fetch_array();
|
|
$gesamt = number_format($row_ges['Anz'], 0, ',', '.');
|
|
$smarty->assign('livestat_ges', "$gesamt");
|
|
|
|
$heute = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
|
|
$datum_db = date("Y-m-d", $heute);
|
|
|
|
$result_heute = $db->query( "SELECT count(*) Anz FROM userlog WHERE datum like '$datum_db%'" );
|
|
$row_heute = $result_heute->fetch_array();
|
|
$heute = number_format($row_heute['Anz'], 0, ',', '.');
|
|
$smarty->assign('livestat_heute', "$heute");
|
|
|
|
|
|
$gestern = mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
|
|
$datum_db_gestern = date("Y-m-d", $gestern);
|
|
$result_gestern = $db->query( "SELECT count(*) Anz FROM userlog WHERE datum like '$datum_db_gestern%'" );
|
|
$row_gestern = $result_gestern->fetch_array();
|
|
$gestern = number_format($row_gestern['Anz'], 0, ',', '.');
|
|
$smarty->assign('livestat_gestern', "$gestern");
|
|
|
|
|
|
$result_online = $db->query( "SELECT count(distinct vaid) online
|
|
FROM historie
|
|
WHERE DATE_SUB(NOW(), INTERVAL 10 MINUTE ) < Datum
|
|
" );
|
|
$row_online = $result_online->fetch_array();
|
|
$online = number_format($row_online['online'], 0, ',', '.');
|
|
if($row_online['online'] == ''){
|
|
$online = "0";
|
|
}
|
|
$smarty->assign('livestat_online', "$online");
|
|
|
|
$smarty->display("$template/$templatename");
|
|
?>
|