if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM === true && $_SESSION['user_type'] == 'U') { $sql .= "\n AND\n ishighspam=0\n AND\n COALESCE(ishighmcp,0)=0"; } $sql .= "\nORDER BY\n date DESC, time DESC"; db_colorised_table($sql, __('folder08') . ': ' . translateQuarantineDate($dir, DATE_FORMAT), true, true); } else { // SECURITY: trim off any potential nasties $dir = preg_replace('[\\.|\\.\\.|\\/]', '', $dir); $items = quarantine_list($dir); // Build list of message id's to be used in SQL statement if (count($items) > 0) { $msg_ids = join($items, ","); $date = mysql_real_escape_string(translateQuarantineDate($dir, 'sql')); $sql = "\n SELECT\n id AS id2,\n DATE_FORMAT(timestamp, '" . DATE_FORMAT . " " . TIME_FORMAT . "') AS datetime,\n from_address,"; if (defined('DISPLAY_IP') && DISPLAY_IP) { $sql .= "clientip,"; } $sql .= "\n to_address,\n subject,\n size,\n sascore,\n isspam,\n ishighspam,\n spamwhitelisted,\n spamblacklisted,\n virusinfected,\n nameinfected,\n otherinfected,\n report,\n ismcp,\n ishighmcp,\n issamcp,\n mcpwhitelisted,\n mcpblacklisted,\n mcpsascore,\n '' as status\n FROM\n maillog\n WHERE\n " . $_SESSION['global_filter'] . "\n AND\n date = '{$date}'\n AND\n BINARY id IN ({$msg_ids})"; // Hide high spam/mcp from regular users if enabled if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM === true && $_SESSION['user_type'] == 'U') { $sql .= "\n AND\n ishighspam=0\n AND\n COALESCE(ishighmcp,0)=0"; } $sql .= "\n ORDER BY\n date DESC, time DESC\n "; db_colorised_table($sql, __('folder_0208') . ': ' . translateQuarantineDate($dir), true, true); } else { echo "No quarantined messages found\n"; } } } html_end(); dbclose();
* your version of the program, but you are not obligated to do so. * If you do not wish to do so, delete this exception statement from your version. * * As a special exception, you have permission to link this program with the JpGraph library and distribute executables, * as long as you follow the requirements of the GNU GPL in regard to all of the software in the executable aside from * JpGraph. * * You should have received a copy of the GNU General Public License along with this program; if not, write to the Free * Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ require_once __DIR__ . '/functions.php'; session_start(); require __DIR__ . '/login.function.php'; html_start("Mail Queue Viewer", 0, false, false); switch ($_GET['queue']) { case "inq": $queue = 'inq'; $display = 'Inbound Mail Queue'; break; case "outq": $queue = 'outq'; $display = 'Outbound Mail Queue'; break; default: die("No queue specified\n"); } db_colorised_table("\n SELECT\n id AS id2,\n CONCAT(DATE_FORMAT(cdate, '" . DATE_FORMAT . "'),' ',ctime) AS datetime,\n hostname,\n from_address,\n to_address,\n subject,\n message,\n size,\n attempts,\n CASE WHEN lastattempt=0 THEN '00:00:00' ELSE SEC_TO_TIME((UNIX_TIMESTAMP() - lastattempt)) END AS lastattempt\nFROM\n " . $queue . "\nWHERE\n " . $_SESSION['global_filter'] . "\nORDER BY\n cdate, ctime", $display, true, true); // Add the footer html_end(); // close the connection to the Database dbclose();
// Include of necessary functions require_once __DIR__ . '/functions.php'; require_once __DIR__ . '/filter.inc'; // Authentication checking session_start(); require __DIR__ . '/login.function.php'; // add the header information such as the logo, search, menu, .... $filter = html_start("Message Listing", 0, false, true); // Checks to see if you are looking for quarantined files only if (QUARANTINE_USE_FLAG) { $flag_sql = "quarantined=1"; } else { $flag_sql = "1=1"; } // SQL query $sql = "\n SELECT\n id AS id2,\n DATE_FORMAT(timestamp, '" . DATE_FORMAT . " " . TIME_FORMAT . "') AS datetime,\n from_address,"; if (defined('DISPLAY_IP') && DISPLAY_IP) { $sql .= "clientip,"; } $sql .= "\n to_address,\n subject,\n size,\n isspam,\n ishighspam,\n isrblspam,\n spamwhitelisted,\n spamblacklisted,\n virusinfected,\n nameinfected,\n otherinfected,\n sascore,\n report,\n ismcp,\n ishighmcp,\n mcpwhitelisted,\n mcpblacklisted,\n mcpsascore,\n '' AS status\n FROM\n maillog\n WHERE\n {$flag_sql}\n" . $_SESSION["filter"]->CreateSQL(); // Hide high spam/mcp from regular users if enabled if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM === true && $_SESSION['user_type'] == 'U') { $sql .= "\n AND\n ishighspam=0\n AND\n COALESCE(ishighmcp,0)=0"; } $sql .= "\n ORDER BY\n date DESC, time DESC\n"; // function to display the data from functions.php db_colorised_table($sql, 'Message Operations', true, true, "SPAM"); // Add footer html_end(); // Close any open db connections dbclose();
$sql .= "\n to_address,\n subject,\n size,\n isspam,\n ishighspam,\n isrblspam,\n spamwhitelisted,\n spamblacklisted,\n virusinfected,\n nameinfected,\n otherinfected,\n sascore,\n report,\n ismcp,\n ishighmcp,\n mcpwhitelisted,\n mcpblacklisted,\n mcpsascore,\n '' AS status\n FROM\n maillog\n WHERE\n" . $_SESSION['global_filter']; // Hide high spam/mcp from regular users if enabled if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM && $_SESSION['user_type'] == 'U') { $sql .= "\n AND\n ishighspam=0\n AND\n ishighmcp=0"; } // Check if we've passed in a relay that we want to check the headers for, this is from detail.php $relay_regex = ""; if (isset($_GET['relay'])) { if (preg_match('/^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$/', $_GET['relay'])) { $relay_regex = "[[:<:]]" . str_replace('.', '\\.', $_GET['relay']) . "[[:>:]]"; } } if (strlen($relay_regex) > 0) { $sql .= " AND headers REGEXP '{$relay_regex}'"; if (isset($_GET['isspam'])) { $sql .= " AND isspam > 0"; } if (isset($_GET['isvirus'])) { $sql .= " AND virusinfected > 0"; } $sql .= " AND " . $_SESSION['global_filter']; } else { $sql .= " " . $_SESSION["filter"]->CreateSQL(); } $sql .= "\n ORDER BY\n date DESC, time DESC\n "; // function to display the data from functions.php db_colorised_table($sql, 'Message Listing', true, true); // Add footer html_end(); // Close any open db connections dbclose();
$sql .= "\n to_address,\n subject,\n size,\n isspam,\n ishighspam,\n isrblspam,\n spamwhitelisted,\n spamblacklisted,\n virusinfected,\n nameinfected,\n otherinfected,\n sascore,\n report,\n ismcp,\n ishighmcp,\n mcpwhitelisted,\n mcpblacklisted,\n mcpsascore,\n '' AS status\n FROM\n maillog\n WHERE\n" . $_SESSION['global_filter']; // Hide high spam/mcp from regular users if enabled if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM && $_SESSION['user_type'] == 'U') { $sql .= "\n AND\n ishighspam=0\n AND\n ishighmcp=0"; } // Check if we've passed in a relay that we want to check the headers for, this is from detail.php $relay_regex = ""; if (isset($_GET['relay'])) { if (preg_match('/^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$/', $_GET['relay'])) { $relay_regex = "[[:<:]]" . str_replace('.', '\\.', $_GET['relay']) . "[[:>:]]"; } } if (strlen($relay_regex) > 0) { $sql .= " AND headers REGEXP '{$relay_regex}'"; if (isset($_GET['isspam'])) { $sql .= " AND isspam > 0"; } if (isset($_GET['isvirus'])) { $sql .= " AND virusinfected > 0"; } $sql .= " AND " . $_SESSION['global_filter']; } else { $sql .= " " . $_SESSION["filter"]->CreateSQL(); } $sql .= "\n ORDER BY\n date DESC, time DESC\n "; // function to display the data from functions.php db_colorised_table($sql, __('messagelisting13'), true, true); // Add footer html_end(); // Close any open db connections dbclose();
PEAR library that are licensed under the PHP License. If you modify this program, you may extend this exception to your version of the program, but you are not obligated to do so. If you do not wish to do so, delete this exception statement from your version. As a special exception, you have permission to link this program with the JpGraph library and distribute executables, as long as you follow the requirements of the GNU GPL in regard to all of the software in the executable aside from JpGraph. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ require_once "./functions.php"; session_start(); require 'login.function.php'; $refresh = html_start(__('recentmsg05'), STATUS_REFRESH, false, false); $sql = "\nSELECT\n id AS id2,\n hostname AS host,\n DATE_FORMAT(timestamp, '" . DATE_FORMAT . " " . TIME_FORMAT . "') AS datetime,\n from_address,"; if (defined('DISPLAY_IP') && DISPLAY_IP) { $sql .= "clientip,"; } $sql .= "\n to_address,\n subject,\n size as size,\n isspam,\n ishighspam,\n spamwhitelisted,\n spamblacklisted,\n virusinfected,\n nameinfected,\n otherinfected,\n sascore,\n report,\n ismcp,\n issamcp,\n ishighmcp,\n mcpsascore,\n '' AS status\nFROM\n maillog\nWHERE\n " . $_SESSION['global_filter']; // Hide high spam/mcp from regular users if enabled if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM && $_SESSION['user_type'] == 'U') { $sql .= "\n AND\n ishighspam=0\n AND\n ishighmcp=0"; } $sql .= " \nORDER BY\n date DESC,\n time DESC\nLIMIT " . MAX_RESULTS; db_colorised_table($sql, __('last05') . " " . MAX_RESULTS . " " . __('messages05') . " (" . __('refevery05') . " {$refresh} " . __('seconds05') . ")"); // Add footer html_end(); // Close any open db connections dbclose();