load("adminlogs");
logadmin();
addacpnav($lang->nav_admin_logs, "adminlogs.php");
switch($mybb->input['action'])
{
case "view":
addacpnav($lang->nav_search_results);
break;
}
if($mybb->input['action'] == "do_prune")
{
$time = time();
$days = intval($mybb->input['days']);
$fromscript = addslashes($mybb->input['fromscript']);
$fromadmin = intval($mybb->input['fromadmin']);
$timecut = $time-($days*60*60*24);
$thequery = "";
if($timecut)
{
$thequery .= "dateline<$timecut";
if($fromscript || $fromadmin)
{
$thequery .= " AND ";
}
}
if($mybb->input['fromscript'])
{
$thequery .= "scriptname='$fromscript'";
if($fromadmin)
{
$thequery .= " AND ";
}
}
if($mybb->input['fromadmin'])
{
$thequery .= "uid='$fromadmin'";
}
if($thequery)
{
$thequery = "WHERE $thequery";
}
$db->query("DELETE FROM ".TABLE_PREFIX."adminlog $thequery");
cpredirect("adminlogs.php", $lang->log_pruned);
}
elseif($mybb->input['action'] == "view")
{
$perpage = intval($mybb->input['perpage']);
$fromscript = addslashes($mybb->input['fromscript']);
$fromadmin = intval($mybb->input['fromadmin']);
$orderby = $mybb->input['orderby'];
$page = $mybb->input['page'];
if(!$perpage)
{
$perpage = 20;
}
$squery = "";
if($fromscript)
{
$squery .= "scriptname='$fromscript'";
if($fromadmin)
{
$squery .= " AND ";
}
}
if($fromadmin)
{
$squery .= "l.uid='$fromadmin'";
}
if($squery)
{
$squery = "WHERE $squery";
}
if($orderby == "nameasc")
{
$order = "u.username ASC";
}
elseif($orderby == "scriptasc")
{
$order = "l.scriptname ASC";
}
else
{
$order = "l.dateline DESC";
}
$query = $db->query("SELECT COUNT(dateline) FROM ".TABLE_PREFIX."adminlog l LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid) ".$squery);
$rescount = $db->result($query, 0);
if(!$rescount)
{
cpmessage($lang->no_results);
}
if(!$perpage)
{
$perpage = 15;
}
if($page)
{
$start = ($page-1) *$perpage;
}
else
{
$start = 0;
$page = 1;
}
if($rescount > $perpage)
{
$pages = $rescount / $perpage;
$pages = ceil($pages);
}
else
{
$pages = 1;
}
if($page != $pages)
{
$npage = $page+1;
$nextpage = "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo " \n";
$query = $db->query("SELECT l.*, u.username FROM ".TABLE_PREFIX."adminlog l LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid) $squery ORDER BY $order LIMIT $start, $perpage");
while($logitem = $db->fetch_array($query))
{
$logitem['dateline'] = date("jS M Y, G:i", $logitem['dateline']);
$bgcolor = getaltbg();
echo "\n";
echo "$logitem[username] $logitem[dateline] \n";
echo "$logitem[scriptname] ";
echo "$logitem[action] ";
echo "$logitem[querystring] ";
echo "$logitem[ipaddress] ";
echo " \n";
}
if($prevpage || $nextpage)
{
tablesubheader("$firstpage$prevpage$nextpage$lastpage ", "", 6);
}
endtable();
cpfooter();
}
else
{
$query = $db->query("SELECT DISTINCT scriptname FROM ".TABLE_PREFIX."adminlog ORDER BY scriptname ASC");
while($script = $db->fetch_array($query))
{
$soptions .= "$script[scriptname] \n";
}
$query = $db->query("SELECT DISTINCT l.uid, u.username FROM ".TABLE_PREFIX."adminlog l LEFT JOIN ".TABLE_PREFIX."users u ON (l.uid=u.uid) ORDER BY u.username ASC");
while($user = $db->fetch_array($query))
{
$uoptions .= "$user[username] \n";
}
cpheader();
startform("adminlogs.php", "", "view");
starttable();
tableheader($lang->view_admin_logs);
makeinputcode($lang->entries_pp, "perpage", 20, 4);
makelabelcode($lang->entries_script, "\n$lang->all_scripts \n---------- \n$soptions ");
makelabelcode($lang->entries_admin, "\n$lang->all_admins \n---------- \n$uoptions ");
makelabelcode($lang->order_by, "$lang->date_desc \n$lang->username_asc $lang->script_asc \n\n$lang->all_scripts \n---------- \n$soptions ");
makelabelcode($lang->entries_admin, "\n$lang->all_admins \n---------- \n$uoptions ");
makeinputcode($lang->entries_older, "days", 30, 4);
endtable();
endform($lang->prune_log, $lang->reset_button);
}
?>