I made some adjustments in PHP and added a column in the mailscanner database to add this option.
When releasing an e-mail, the mail gets blue highlighted in the mail listings
Add column to SQL database mailscanner:
Code: Select all
ALTER TABLE `maillog` ADD `isreleased` TINYINT( 1 ) NULL DEFAULT '0';
Code: Select all
TABLE.mail TR.released {
background-color:#40C1ED;
color:#000;
}
TABLE.mail TD.released {
background-color:#40C1ED;
width:15px;
}
status.php | rep_message_listing.php | rep_message_ops.php
search for:
Code: Select all
$sql .= "
to_address,
subject,
size as size,
isspam,
ishighspam,
Code: Select all
isreleased,
search for:
Code: Select all
echo ' <tr> <td>' . __('blacklisted03') . '</td> <td class="blacklisted"></td> </tr>' . "\n";
echo ' <tr> <td>' . __('notverified03') . '</td> <td class="notscanned"></td> </tr>' . "\n";
Code: Select all
echo ' <tr> <td>Released</td> <td class="released"></td> </tr>' . "\n";
Code: Select all
case 'time':
$fieldname[$f] = 'Time';
break;
case 'headers':
$display[$f] = false;
break;
Code: Select all
case 'isreleased':
$display[$f] = false;
break;
Code: Select all
$blacklisted = false;
$mcp = false;
$highmcp = false;
Code: Select all
$released = false;
Code: Select all
case 'clienthost':
$hostname = gethostbyaddr($row[$f]);
if ($hostname == $row[$f]) {
$row[$f] = "(Hostnaam opvragen mislukt)";
} else {
$row[$f] = $hostname;
}
break;
Code: Select all
case 'isreleased':
if ($row[$f] == 'Y' || $row[$f] > 0) {
$released = true;
// $status_array = array();
array_push($status_array, 'Vrijgegeven');
}
break;
Code: Select all
// Colorise the row
switch (true) {
Code: Select all
case $released:
echo '<tr class="released">' . "\n";
break;
search for:
Code: Select all
CASE WHEN spamwhitelisted>0 THEN '$yes' ELSE '$no' END AS '" . __('spamwl04') . "',
CASE WHEN spamblacklisted>0 THEN '$yes' ELSE '$no' END AS '" . __('spambl04') . "',
spamreport AS '" . __('saautolearn04') . "',
sascore AS '" . __('sascore04') . "',
search for:CASE WHEN isreleased>0 THEN '$yes' ELSE '$no' END AS 'Released:',
Code: Select all
// Release
if (isset($_GET['release'])) {
Code: Select all
$sqlunsetspam = "UPDATE maillog SET `isreleased` = '1', `quarantined` = '0' WHERE `maillog`.`id` ='$url_id'";
dbquery($sqlunsetspam);
if (DEBUG == 'true') {
echo $sqlunsetspam;
}
Cya!