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 .= "
".LAN_ADMINLOG_1." | ".LAN_ADMINLOG_2." | ".LAN_ADMINLOG_3." | ".LAN_ADMINLOG_4." | ".LAN_ADMINLOG_5." | ||
{$image} | \n"; $text .= "{$datestamp} | \n"; $text .= "".$tp->toHtml($row['dblog_title'],FALSE,"defs")." | \n"; $text .= "".$tp->toHtml($row['dblog_remarks'],FALSE,"defs")." | \n"; $text .= "{$row['dblog_ip']} | \n"; $text .= ($row['user_name']) ? "{$row['user_name']} | \n" : "{$row['dblog_user_id']} | \n"; $text .= "