nansenat16/quarantine_report_zh_TW.php

## quarantine_report_zh_TW.php
#!/usr/bin/php -q
<?php

/*
 MailWatch for MailScanner
 Copyright (C) 2003-2011  Steve Freegard (steve@freegard.name)
 Copyright (C) 2011  Garrod Alwood (garrod.alwood@lorodoes.com)
 Copyright (C) 2014-2015  MailWatch Team (https://github.com/orgs/mailwatch/teams/team-stable)

 This program is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 In addition, as a special exception, the copyright holder gives permission to link the code of this program
 with those files in the PEAR library that are licensed under the PHP License (or with modified versions of those
 files that use the same license as those files), and distribute linked combinations including the two.
 You must obey the GNU General Public License in all respects for all of the code used other than those files in the
 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
*/

define("RELEASE_NOAUTH_URL",'http://EFA-HOST.Domain/cgi-bin/release-msg-noauth.cgi');

// Change the following to reflect the location of functions.php
require_once('/var/www/html/mailscanner/functions.php');

$required_constant = array(
    'QUARANTINE_REPORT_DAYS',
    'QUARANTINE_REPORT_HOSTURL',
    'QUARANTINE_DAYS_TO_KEEP',
    'QUARANTINE_REPORT_FROM_NAME',
    'QUARANTINE_FROM_ADDR',
    'QUARANTINE_REPORT_SUBJECT',
    'MAILWATCH_HOME',
    'QUARANTINE_MAIL_HOST',
    'FROMTO_MAXLEN',
    'SUBJECT_MAXLEN',
    'TIME_ZONE',
    'DATE_FORMAT',
    'TIME_FORMAT'
);
$required_constant_missing_count = 0;
foreach ($required_constant as $constant) {
    if (!defined($constant)) {
        echo "The variable $constant is empty, please set a value in conf.php.\n";
        $required_constant_missing_count++;
    }
}
if ($required_constant_missing_count == 0) {

    require_once('Mail.php');
    require_once('Mail/mime.php');
    date_default_timezone_set(TIME_ZONE);

    ini_set('html_errors', 'off');
    ini_set('display_errors', 'on');
    ini_set('implicit_flush', 'false');
    ini_set("memory_limit", '256M');
    ini_set("error_reporting", E_ALL);
    ini_set("max_execution_time", 0);
    if (version_compare(phpversion(), '5.3.0', '<')) {
        error_reporting(E_ALL ^ E_STRICT);
    } else {
        // E_DEPRECATED added in PHP 5.3
        error_reporting(E_ALL ^ E_STRICT ^ E_DEPRECATED);
    }

    /*
    ** HTML Template
    */

    $html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
 <title>每日垃圾郵件報告</title>
 <style type="text/css">
 <!--
  body, td, tr {
  font-family: sans-serif;
  font-size: 8pt;
 }
 -->
 </style>
</head>
<body style="margin: 5px;">

<!-- Outer table -->
<table width="100%%" border="0">
 <tr>
  <td><img src="mailwatch-logo.png"/></td>
  <td align="center" valign="middle">
   <h2>%s 的垃圾郵件隔離清單</h2>
   在最近的 %s 天,您接收了 %s 封垃圾郵件,隔離的清單如下。<br />隔離的郵件將會在收到後的 %s 天後被系統清除。
  </td>
 </tr>
 <tr>
  <td colspan="2">%s</td>
 </tr>
</table>
</body>
</html>';

    $html_table = '<table width="100%%" border="0">
 <tr>
  <td style="background-color: #F7CE4A"><b>接收時間</b></td>
  <!--- <td style="background-color: #F7CE4A"><b>收件者</b></td> --->
  <td style="background-color: #F7CE4A"><b>寄件者</b></td>
  <td style="background-color: #F7CE4A"><b>主旨</b></td>
  <td style="background-color: #F7CE4A"><b>類型</b></td>
  <td style="background-color: #F7CE4A"><b>動作</b></td>
 </tr>
%s
</table>';

    $html_content = ' <tr>
  <td style="background-color: #EBEBEB">%s</td>
  <!--- <td style="background-color: #EBEBEB">%s</td> --->
  <td style="background-color: #EBEBEB">%s</td>
  <td style="background-color: #EBEBEB">%s</td>
  <td style="background-color: #EBEBEB">%s</td>
  <td style="background-color: #EBEBEB">%s</td>
 </tr>
';

    /*
    ** Text Template
    */

    $text = '%s 的垃圾郵件隔離清單

   在最近的 %s 天,您接收了 %s 封垃圾郵件,隔離的清單如下。
   隔離的郵件將會在收到後的 %s 天後被系統清除。

%s';

    $text_content = '接收時間: %s
寄件者: %s
主旨: %s
類型: %s
動作:
%s

';

    /*
    ** SQL Templates
    */

    $users_sql = "
SELECT
 username,
 quarantine_rcpt,
 type
FROM
 users
WHERE
 quarantine_report=1
";

    $filters_sql = "
SELECT
 filter
FROM
 user_filters
WHERE
 username=%s
AND
 active='Y'
";

    $sql = "
SELECT DISTINCT
a.id AS id,
DATE_FORMAT(timestamp,'" . str_replace('%', '%%', DATE_FORMAT) . " <br/>" . str_replace('%', '%%', TIME_FORMAT) . "') AS datetime,
DATE_FORMAT(timestamp,'%%Y%%m%%d') AS releasedate,
a.to_address AS to_address,
a.from_address AS from_address,
a.subject AS subject,
CASE
 WHEN a.virusinfected>0 THEN 'Virus'
 WHEN a.nameinfected>0 THEN 'Bad Content'
 WHEN a.otherinfected>0 THEN 'Infected'
 WHEN a.ishighspam>0 THEN 'Spam'
 WHEN a.issaspam>0 THEN 'Spam'
 WHEN a.isrblspam>0 THEN 'Spam'
 WHEN a.spamblacklisted>0 THEN 'Blacklisted'
 WHEN a.isspam THEN 'Spam'
 WHEN a.ismcp>0 THEN 'Policy'
 WHEN a.ishighmcp>0 THEN 'Policy'
 WHEN a.issamcp>0 THEN 'Policy'
 WHEN a.mcpblacklisted>0 THEN 'Policy'
 WHEN a.isspam>0 THEN 'Spam'
 ELSE 'UNKNOWN'
END AS reason
FROM
 maillog a
WHERE
/*
 a.quarantined = 1
AND
*/
 ((to_address=%s) OR (to_domain=%s))
AND
 ((a.isspam > 0) OR (a.virusinfected > 0) OR (a.nameinfected > 0))
AND
 a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL " . QUARANTINE_REPORT_DAYS . " DAY)";

 // Hide high spam/mcp from users if enabled
if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM) {
  $sql .= "
    AND
     ishighspam=0
    AND
     ishighmcp=0";
}

$sql .= "
ORDER BY a.date DESC, a.time DESC";

$users_sql= "
    select distinct to_address as username,
      to_address as quarantine_rcpt,
      'U' as type from maillog where timestamp >'%s' and isspam!=0";
$users_sql=sprintf($users_sql,date('Y-m-d','-'.QUARANTINE_REPORT_DAYS.' day'));

//echo 'SQL:'.$users_sql."\n";
    $result = dbquery($users_sql);
    $rows = mysql_num_rows($result);
//echo 'SPAM item:'.$rows."\n";
    if ($rows > 0) {
        while ($user = mysql_fetch_object($result)) {
            dbg("\n === Generating report for " . $user->username . " type=" . $user->type);
            // Work out destination e-mail address
            switch ($user->type) {
                case 'U':
                    // Type: user - see if to address needs to be overridden
                    if (!empty($user->quarantine_rcpt)) {
                        $email = $user->quarantine_rcpt;
                    } else {
                        $email = $user->username;
                    }
                    $to_address = $user->username;
                    $to_domain = $user->username;
                    break;
                case 'D':
                    // Type: domain admin - this must be overridden
                    $email = $user->quarantine_rcpt;
                    $to_address = $user->username;
                    if (preg_match('/(\S+)@(\S+)/', $user->username, $split)) {
                        $to_domain = $split[2];
                    } else {
                        $to_domain = $user->username;
                    }
                    break;
                default:
                    // Shouldn't ever get here - but just in case...
                    $email = $user->quarantine_rcpt;
                    $to_address = $user->username;
                    $to_domain = $user->username;
                    break;
            }
            // Make sure we have a destination address
            if (!empty($email)) {
                dbg(" ==== Recipient e-mail address is $email");
                // Get any additional reports required
                $filters = array_merge(array($email), return_user_filters($user->username));
                foreach ($filters as $filter) {
                    dbg(" ==== Building list for $filter");
                    $quarantined = return_quarantine_list_array($filter, $to_domain);
                    dbg(" ==== Found " . count($quarantined) . " quarantined e-mails");
                    //print_r($quarantined);
                    if (count($quarantined) > 0) {
                        send_quarantine_email($email, $filter, $quarantined);
                    }
                    unset($quarantined);
                }
            } else {
                dbg(" ==== " . $user->username . " has empty e-mail recipient address, skipping...");
            }
        }
    }
}

function dbg($text)
{
    echo $text . "\n";
}

function return_user_filters($user)
{
    global $filters_sql;
    $result = dbquery(sprintf($filters_sql, quote_smart($user)));
    $rows = mysql_num_rows($result);
    $array = array();
    if ($rows > 0) {
        while ($row = mysql_fetch_object($result)) {
            $array[] = $row->filter;
        }
    }
    return $array;
}

function return_quarantine_list_array($to_address, $to_domain)
{
    global $sql;
    $result = dbquery(sprintf($sql, quote_smart($to_address), quote_smart($to_domain)));
    $rows = mysql_num_rows($result);
    $array = array();
    if ($rows > 0) {
        while ($row = mysql_fetch_object($result)) {
            $array[] = array(
                'id' => trim($row->id),
                'datetime' => trim($row->datetime),
                'releasedate' => trim($row->releasedate),
                'to' => trim_output($row->to_address, FROMTO_MAXLEN),
                'from' => trim_output($row->from_address, FROMTO_MAXLEN),
                'subject' => trim_output($row->subject, SUBJECT_MAXLEN),
                'reason' => trim($row->reason)
            );
        }
    }
    return $array;
}

function send_quarantine_email($email, $filter, $quarantined)
{
    global $html, $html_table, $html_content, $text, $text_content;
    // Setup variables to prevent warnings
    $h1 = "";
    $t1 = "";
    // Build the quarantine list for this recipient
    foreach ($quarantined as $qitem) {
        // HTML Version

	$release_URL='<a href="' . RELEASE_NOAUTH_URL . '?id=' . $qitem['id'] . '&datenumber=' . $qitem['releasedate'] . '">取回郵件</a>';
        if($qitem['reason']!='Spam'){
		$release_URL='停用';
	}

        $h1 .= sprintf(
            $html_content,
            $qitem['datetime'],
            $qitem['to'],
            $qitem['from'],
            $qitem['subject'],
            $qitem['reason'],
            //'<a href="' . QUARANTINE_REPORT_HOSTURL . '/viewmail.php?id=' . $qitem['id'] . '">檢視</a>'
            $release_URL
        );
        // Text Version
        $t1 .= sprintf(
            $text_content,
            strip_tags($qitem['datetime']),
            $qitem['to'],
            $qitem['from'],
            $qitem['subject'],
            $qitem['reason'],
            //'<a href="' . QUARANTINE_REPORT_HOSTURL . '/viewmail.php?id=' . $qitem['id'] . '">檢視</a>'
            $release_URL
        );
    }

    // HTML
    $h2 = sprintf($html_table, $h1);
    $html_report = sprintf($html, $filter, QUARANTINE_REPORT_DAYS, count($quarantined), QUARANTINE_DAYS_TO_KEEP, $h2);
    if (DEBUG) {
        echo $html_report;
    }

    // Text
    $text_report = sprintf($text, $filter, QUARANTINE_REPORT_DAYS, count($quarantined), QUARANTINE_DAYS_TO_KEEP, $t1);
    if (DEBUG) {
        echo "<pre>$text_report</pre>\n";
    }

    // Send e-mail
    $mime = new Mail_mime("\n");
    $hdrs = array(
        //'From' => QUARANTINE_REPORT_FROM_NAME . ' <' . QUARANTINE_FROM_ADDR . '>',
        'From' => '郵件隔離所 <' . QUARANTINE_FROM_ADDR . '>',
        'To' => $email,
        'Subject' => '每日垃圾郵件隔離清單',
        'Date' => date("r"),
        'Content-Type' => 'text/html; charset=UTF-8',
        'Content-Transfer-Encoding' => '8bit'
    );

    $mimeparams['text_encoding']="8bit";
    $mimeparams['text_charset']="UTF-8";
    $mimeparams['html_charset']="UTF-8";
    $mimeparams['head_charset']="UTF-8";

    $mime->addHTMLImage(MAILWATCH_HOME . '/images/mailwatch-logo.png', 'image/png', 'mailwatch-logo.png', true);
    $mime->setTXTBody($text_report);
    $mime->setHTMLBody($html_report);
    $body = $mime->get($mimeparams);
    $hdrs = $mime->headers($hdrs);
    $mail_param = array('host' => QUARANTINE_MAIL_HOST);

    $mail =& Mail::factory('smtp', $mail_param);
    $mail->send($email, $hdrs, $body);
    dbg(" ==== Sent e-mail to $email");
}
	#!/usr/bin/php -q
	<?php

	/*
	MailWatch for MailScanner
	Copyright (C) 2003-2011 Steve Freegard (steve@freegard.name)
	Copyright (C) 2011 Garrod Alwood (garrod.alwood@lorodoes.com)
	Copyright (C) 2014-2015 MailWatch Team (https://github.com/orgs/mailwatch/teams/team-stable)

	This program is free software; you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation; either version 2 of the License, or
	(at your option) any later version.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	GNU General Public License for more details.

	In addition, as a special exception, the copyright holder gives permission to link the code of this program
	with those files in the PEAR library that are licensed under the PHP License (or with modified versions of those
	files that use the same license as those files), and distribute linked combinations including the two.
	You must obey the GNU General Public License in all respects for all of the code used other than those files in the
	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
	*/

	define("RELEASE_NOAUTH_URL",'http://EFA-HOST.Domain/cgi-bin/release-msg-noauth.cgi');

	// Change the following to reflect the location of functions.php
	require_once('/var/www/html/mailscanner/functions.php');

	$required_constant = array(
	'QUARANTINE_REPORT_DAYS',
	'QUARANTINE_REPORT_HOSTURL',
	'QUARANTINE_DAYS_TO_KEEP',
	'QUARANTINE_REPORT_FROM_NAME',
	'QUARANTINE_FROM_ADDR',
	'QUARANTINE_REPORT_SUBJECT',
	'MAILWATCH_HOME',
	'QUARANTINE_MAIL_HOST',
	'FROMTO_MAXLEN',
	'SUBJECT_MAXLEN',
	'TIME_ZONE',
	'DATE_FORMAT',
	'TIME_FORMAT'
	);
	$required_constant_missing_count = 0;
	foreach ($required_constant as $constant) {
	if (!defined($constant)) {
	echo "The variable $constant is empty, please set a value in conf.php.\n";
	$required_constant_missing_count++;
	}
	}
	if ($required_constant_missing_count == 0) {

	require_once('Mail.php');
	require_once('Mail/mime.php');
	date_default_timezone_set(TIME_ZONE);

	ini_set('html_errors', 'off');
	ini_set('display_errors', 'on');
	ini_set('implicit_flush', 'false');
	ini_set("memory_limit", '256M');
	ini_set("error_reporting", E_ALL);
	ini_set("max_execution_time", 0);
	if (version_compare(phpversion(), '5.3.0', '<')) {
	error_reporting(E_ALL ^ E_STRICT);
	} else {
	// E_DEPRECATED added in PHP 5.3
	error_reporting(E_ALL ^ E_STRICT ^ E_DEPRECATED);
	}

	/*
	** HTML Template
	*/

	$html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html>
	<head>
	<title>每日垃圾郵件報告</title>
	<style type="text/css">
	<!--
	body, td, tr {
	font-family: sans-serif;
	font-size: 8pt;
	}
	-->
	</style>
	</head>
	<body style="margin: 5px;">

	<!-- Outer table -->
	<table width="100%%" border="0">
	<tr>
	<td><img src="mailwatch-logo.png"/></td>
	<td align="center" valign="middle">
	<h2>%s 的垃圾郵件隔離清單</h2>
	在最近的 %s 天,您接收了 %s 封垃圾郵件,隔離的清單如下。<br />隔離的郵件將會在收到後的 %s 天後被系統清除。
	</td>
	</tr>
	<tr>
	<td colspan="2">%s</td>
	</tr>
	</table>
	</body>
	</html>';

	$html_table = '<table width="100%%" border="0">
	<tr>
	<td style="background-color: #F7CE4A"><b>接收時間</b></td>
	<!--- <td style="background-color: #F7CE4A"><b>收件者</b></td> --->
	<td style="background-color: #F7CE4A"><b>寄件者</b></td>
	<td style="background-color: #F7CE4A"><b>主旨</b></td>
	<td style="background-color: #F7CE4A"><b>類型</b></td>
	<td style="background-color: #F7CE4A"><b>動作</b></td>
	</tr>
	%s
	</table>';

	$html_content = ' <tr>
	<td style="background-color: #EBEBEB">%s</td>
	<!--- <td style="background-color: #EBEBEB">%s</td> --->
	<td style="background-color: #EBEBEB">%s</td>
	<td style="background-color: #EBEBEB">%s</td>
	<td style="background-color: #EBEBEB">%s</td>
	<td style="background-color: #EBEBEB">%s</td>
	</tr>
	';

	/*
	** Text Template
	*/

	$text = '%s 的垃圾郵件隔離清單

	在最近的 %s 天,您接收了 %s 封垃圾郵件,隔離的清單如下。
	隔離的郵件將會在收到後的 %s 天後被系統清除。

	%s';

	$text_content = '接收時間: %s
	寄件者: %s
	主旨: %s
	類型: %s
	動作:
	%s

	';

	/*
	** SQL Templates
	*/

	$users_sql = "
	SELECT
	username,
	quarantine_rcpt,
	type
	FROM
	users
	WHERE
	quarantine_report=1
	";

	$filters_sql = "
	SELECT
	filter
	FROM
	user_filters
	WHERE
	username=%s
	AND
	active='Y'
	";

	$sql = "
	SELECT DISTINCT
	a.id AS id,
	DATE_FORMAT(timestamp,'" . str_replace('%', '%%', DATE_FORMAT) . " <br/>" . str_replace('%', '%%', TIME_FORMAT) . "') AS datetime,
	DATE_FORMAT(timestamp,'%%Y%%m%%d') AS releasedate,
	a.to_address AS to_address,
	a.from_address AS from_address,
	a.subject AS subject,
	CASE
	WHEN a.virusinfected>0 THEN 'Virus'
	WHEN a.nameinfected>0 THEN 'Bad Content'
	WHEN a.otherinfected>0 THEN 'Infected'
	WHEN a.ishighspam>0 THEN 'Spam'
	WHEN a.issaspam>0 THEN 'Spam'
	WHEN a.isrblspam>0 THEN 'Spam'
	WHEN a.spamblacklisted>0 THEN 'Blacklisted'
	WHEN a.isspam THEN 'Spam'
	WHEN a.ismcp>0 THEN 'Policy'
	WHEN a.ishighmcp>0 THEN 'Policy'
	WHEN a.issamcp>0 THEN 'Policy'
	WHEN a.mcpblacklisted>0 THEN 'Policy'
	WHEN a.isspam>0 THEN 'Spam'
	ELSE 'UNKNOWN'
	END AS reason
	FROM
	maillog a
	WHERE
	/*
	a.quarantined = 1
	AND
	*/
	((to_address=%s) OR (to_domain=%s))
	AND
	((a.isspam > 0) OR (a.virusinfected > 0) OR (a.nameinfected > 0))
	AND
	a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL " . QUARANTINE_REPORT_DAYS . " DAY)";

	// Hide high spam/mcp from users if enabled
	if (defined('HIDE_HIGH_SPAM') && HIDE_HIGH_SPAM) {
	$sql .= "
	AND
	ishighspam=0
	AND
	ishighmcp=0";
	}

	$sql .= "
	ORDER BY a.date DESC, a.time DESC";

	$users_sql= "
	select distinct to_address as username,
	to_address as quarantine_rcpt,
	'U' as type from maillog where timestamp >'%s' and isspam!=0";
	$users_sql=sprintf($users_sql,date('Y-m-d','-'.QUARANTINE_REPORT_DAYS.' day'));

	//echo 'SQL:'.$users_sql."\n";
	$result = dbquery($users_sql);
	$rows = mysql_num_rows($result);
	//echo 'SPAM item:'.$rows."\n";
	if ($rows > 0) {
	while ($user = mysql_fetch_object($result)) {
	dbg("\n === Generating report for " . $user->username . " type=" . $user->type);
	// Work out destination e-mail address
	switch ($user->type) {
	case 'U':
	// Type: user - see if to address needs to be overridden
	if (!empty($user->quarantine_rcpt)) {
	$email = $user->quarantine_rcpt;
	} else {
	$email = $user->username;
	}
	$to_address = $user->username;
	$to_domain = $user->username;
	break;
	case 'D':
	// Type: domain admin - this must be overridden
	$email = $user->quarantine_rcpt;
	$to_address = $user->username;
	if (preg_match('/(\S+)@(\S+)/', $user->username, $split)) {
	$to_domain = $split[2];
	} else {
	$to_domain = $user->username;
	}
	break;
	default:
	// Shouldn't ever get here - but just in case...
	$email = $user->quarantine_rcpt;
	$to_address = $user->username;
	$to_domain = $user->username;
	break;
	}
	// Make sure we have a destination address
	if (!empty($email)) {
	dbg(" ==== Recipient e-mail address is $email");
	// Get any additional reports required
	$filters = array_merge(array($email), return_user_filters($user->username));
	foreach ($filters as $filter) {
	dbg(" ==== Building list for $filter");
	$quarantined = return_quarantine_list_array($filter, $to_domain);
	dbg(" ==== Found " . count($quarantined) . " quarantined e-mails");
	//print_r($quarantined);
	if (count($quarantined) > 0) {
	send_quarantine_email($email, $filter, $quarantined);
	}
	unset($quarantined);
	}
	} else {
	dbg(" ==== " . $user->username . " has empty e-mail recipient address, skipping...");
	}
	}
	}
	}

	function dbg($text)
	{
	echo $text . "\n";
	}

	function return_user_filters($user)
	{
	global $filters_sql;
	$result = dbquery(sprintf($filters_sql, quote_smart($user)));
	$rows = mysql_num_rows($result);
	$array = array();
	if ($rows > 0) {
	while ($row = mysql_fetch_object($result)) {
	$array[] = $row->filter;
	}
	}
	return $array;
	}

	function return_quarantine_list_array($to_address, $to_domain)
	{
	global $sql;
	$result = dbquery(sprintf($sql, quote_smart($to_address), quote_smart($to_domain)));
	$rows = mysql_num_rows($result);
	$array = array();
	if ($rows > 0) {
	while ($row = mysql_fetch_object($result)) {
	$array[] = array(
	'id' => trim($row->id),
	'datetime' => trim($row->datetime),
	'releasedate' => trim($row->releasedate),
	'to' => trim_output($row->to_address, FROMTO_MAXLEN),
	'from' => trim_output($row->from_address, FROMTO_MAXLEN),
	'subject' => trim_output($row->subject, SUBJECT_MAXLEN),
	'reason' => trim($row->reason)
	);
	}
	}
	return $array;
	}

	function send_quarantine_email($email, $filter, $quarantined)
	{
	global $html, $html_table, $html_content, $text, $text_content;
	// Setup variables to prevent warnings
	$h1 = "";
	$t1 = "";
	// Build the quarantine list for this recipient
	foreach ($quarantined as $qitem) {
	// HTML Version

	$release_URL='<a href="' . RELEASE_NOAUTH_URL . '?id=' . $qitem['id'] . '&datenumber=' . $qitem['releasedate'] . '">取回郵件</a>';
	if($qitem['reason']!='Spam'){
	$release_URL='停用';
	}

	$h1 .= sprintf(
	$html_content,
	$qitem['datetime'],
	$qitem['to'],
	$qitem['from'],
	$qitem['subject'],
	$qitem['reason'],
	//'<a href="' . QUARANTINE_REPORT_HOSTURL . '/viewmail.php?id=' . $qitem['id'] . '">檢視</a>'
	$release_URL
	);
	// Text Version
	$t1 .= sprintf(
	$text_content,
	strip_tags($qitem['datetime']),
	$qitem['to'],
	$qitem['from'],
	$qitem['subject'],
	$qitem['reason'],
	//'<a href="' . QUARANTINE_REPORT_HOSTURL . '/viewmail.php?id=' . $qitem['id'] . '">檢視</a>'
	$release_URL
	);
	}

	// HTML
	$h2 = sprintf($html_table, $h1);
	$html_report = sprintf($html, $filter, QUARANTINE_REPORT_DAYS, count($quarantined), QUARANTINE_DAYS_TO_KEEP, $h2);
	if (DEBUG) {
	echo $html_report;
	}

	// Text
	$text_report = sprintf($text, $filter, QUARANTINE_REPORT_DAYS, count($quarantined), QUARANTINE_DAYS_TO_KEEP, $t1);
	if (DEBUG) {
	echo "<pre>$text_report</pre>\n";
	}

	// Send e-mail
	$mime = new Mail_mime("\n");
	$hdrs = array(
	//'From' => QUARANTINE_REPORT_FROM_NAME . ' <' . QUARANTINE_FROM_ADDR . '>',
	'From' => '郵件隔離所 <' . QUARANTINE_FROM_ADDR . '>',
	'To' => $email,
	'Subject' => '每日垃圾郵件隔離清單',
	'Date' => date("r"),
	'Content-Type' => 'text/html; charset=UTF-8',
	'Content-Transfer-Encoding' => '8bit'
	);

	$mimeparams['text_encoding']="8bit";
	$mimeparams['text_charset']="UTF-8";
	$mimeparams['html_charset']="UTF-8";
	$mimeparams['head_charset']="UTF-8";

	$mime->addHTMLImage(MAILWATCH_HOME . '/images/mailwatch-logo.png', 'image/png', 'mailwatch-logo.png', true);
	$mime->setTXTBody($text_report);
	$mime->setHTMLBody($html_report);
	$body = $mime->get($mimeparams);
	$hdrs = $mime->headers($hdrs);
	$mail_param = array('host' => QUARANTINE_MAIL_HOST);

	$mail =& Mail::factory('smtp', $mail_param);
	$mail->send($email, $hdrs, $body);
	dbg(" ==== Sent e-mail to $email");
	}