db_Delete('dblog');
}
$total = $sql -> db_Select("dblog", "*", "ORDER BY `dblog_datestamp` DESC", "no_where");
$query = "SELECT l.*, u.user_name FROM #dblog AS l LEFT JOIN #user AS u ON l.dblog_user_id = u.user_id ORDER BY l.dblog_datestamp DESC LIMIT $from,$amount";
$sql -> db_Select_gen($query);
if(!is_object($gen)) {
$gen = new convert;
}
$parms = $total.",".$amount.",".$from.",".e_SELF.'?fm=[FROM]';
$text .= "
".$tp->parseTemplate("{NEXTPREV={$parms}}")."
";
$text .= "\n";
//
$text .= "
| |
Date |
Title |
Description |
User IP |
User ID |
\n";
while ($row = $sql -> db_Fetch()) {
$datestamp = $gen->convert_date($row['dblog_datestamp'], 'short');
$image = get_log_img($row['dblog_type']);
$text .= " \n";
$text .= " | {$image} | \n";
$text .= " {$datestamp} | \n";
$text .= " {$row['dblog_query']} | \n";
$text .= " {$row['dblog_remarks']} | \n";
$text .= " {$row['dblog_ip']} | \n";
$text .= ($row['user_name']) ? " {$row['user_name']} | \n" : " {$row['dblog_user_id']} | \n";
$text .= "
\n";
}
$text .= "
".$tp->parseTemplate("{NEXTPREV={$parms}}")."
";
$ns->tablerender("Admin Log", $text);
require_once("footer.php");
function get_log_img($log_type) {
switch ($log_type) {
case E_LOG_INFORMATIVE:
return "![Informative Icon](".e_IMAGE_ABS."admin_images/docs_16.png "Informative Message")
";
break;
case E_LOG_NOTICE:
return "![Notice Icon](".e_IMAGE_ABS."admin_images/notice_16.png "Notice Message")
";
break;
case E_LOG_WARNING:
return "![Warning Icon](".e_IMAGE_ABS."admin_images/blocked_16.png "Warning Message")
";
break;
case E_LOG_FATAL:
return "![Fatal Icon](".e_IMAGE_ABS."admin_images/nopreview_16.png "Fatal Error Message")
";
break;
}
return $log_type;
}
function headerjs() {
?>