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");

	}

?>