DATE(DATE_SUB(NOW(), INTERVAL 1 YEAR))"); $unterminiert = mysqli_num_rows($qry); $qry = mysqli_query($dbconn,"SELECT id FROM termin WHERE DATE_FORMAT(termtime,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d') AND done = 0"); $heute = mysqli_num_rows($qry); include("incs/mysql_ecape_wrapper.php"); $text_version = substr($version, 0, 1).".".substr($version, 1, 1).".".substr($version, 2, 1); $smarty->assign("SWfirma",$firma); $_SESSION["firma"] = $firma; $smarty->assign("text_version",$text_version); $smarty->display('head.tpl'); if($_SESSION["login"] == "valid") { include(checkRightsNInclude()); } else { switch($action) { case "setup": include "./update/firststart.php"; break; default: include "./sites/start.php"; break; } } /* echo << ENDE; */ $termine="".str_pad($unterminiert, 1, '0')." nicht terminiert  /  ".str_pad($heute, 1, '0')." heute"; $smarty->assign("termine",$termine); //$smarty->display("greetings.tpl"); //include("update/firststart.php"); $smarty->display('foot.tpl'); ?>