"; */ 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"); ?>