Subversion-Projekte lars-tiefland.medien

<?
        $start=intval(isset($_POST["start"])?$_POST["start"]:0);
        define("IN_ADMIN",true);
        require("include/common.php");
        if ($a->getAuth())
        {
                if($u->u_type!=1 && $mode!="edit")
                {
                        $meld="Ein Fehler ist aufgetreten!";
                        $db_meld="Nur Administratoren haben Zugriff auf diese Funktion!";
                        $smarty->assign("meld", $meld);
                        $smarty->assign("db_meld", $db_meld);
                        $smarty->assign("error", true);
                        $smarty->display("meld.tpl");
                        exit;
                }
        }
        $smarty->assign("title","Log");
        $log_sql="SELECT * FROM $prefix"."log WHERE ident='medien' ORDER BY logtime desc, priority";
        $res_log=$db->query($log_sql);
        if(DB::isError($res_log))
        {
                $smarty->assign("meld",$common["an_error_occured"]);
                $smarty->assign("db_meld",$res_log->getUserInfo());
                $smarty->assign("error","true");
                $smarty->display("meld.tpl");
        }
        else
        {
                $anz=$res_log->numRows();
                $i=0;
                $nav=generate_pagination2('"'.basename(__FILE__).'"', $anz, $max_anz,$start);
                $log_sql="SELECT * FROM $prefix"."log WHERE ident='medien' ORDER BY logtime desc, priority LIMIT $start,$max_anz";
                $res_log=$db->query($log_sql);
                while($row_log=$res_log->fetchRow())
                {
                        $priority=$logger->priorityToString($row_log["priority"]);
                        $u_id=$row_log["u_id"];
                        $sql_u="SELECT u_name FROM auth_user WHERE u_id=$u_id";
                        $res_u=$db->query($sql_u);
                        if(DB::isError($res_u))
                        {
                                $smarty->assign("meld",$common["an_error_occured"]);
                                $smarty->assign("db_meld",$res_u->getUserInfo());
                                $smarty->assign("error","true");
                                $smarty->display("meld.tpl");
                        }
                        else
                        {
                                $row_u=$res_u->fetchRow();
                                $u_name=$row_u["u_name"];
                                $message=$row_log["message"];
                                $datum=$loc->formatDateTime($row_log["logtime"]);
                                $log[$i]["datum"]=$datum;
                                $log[$i]["priority"]=$common["$priority"];
                                $log[$i]["u_name"]=$u_name;
                                $log[$i]["message"]=$message;
                                $i++;
                        }
                }
                $smarty->assign("log_row",$log);
                $smarty->assign("nav", $nav);
                $smarty->display("viewlog.tpl");
        }
?>