// determine column and DB based on first letter in userID
if ($_col == 'C' or $_col == 'L') {
$user_col = 'userID';
$db->SelectDB('mle');
} else {
$user_col = 'affid';
$db->SelectDB('fap');
}
// extract email from mle or fap if exists, if not exist abort, move on to next file
if ($db->Query("SELECT {$col} FROM users WHERE {$user_col} = '{$userID}' AND {$col} != '' LIMIT 1")) {
list($email) = $db->FetchRow();
} else {
break;
}
if ($dbug) {
echo "email -> {$email} :: DB -> {$db->GetDBName()}\n";
}
$reason = get_reason($filename);
// determine if this is a quota bounce or not, and set db column to update in mle.bounced table
if (stristr($contents, 'full') or stristr($contents, 'quota')) {
$bounced_col = 'mailboxfull';
$reason = $reason ? "Mailbox is Over Quota!\n" . $reason : 'Mailbox is Over Quota.';
} else {
$bounced_col = 'count';
$reason = $reason ? "Mailbox is Bouncing!\n" . $reason : 'Mailbox is Bouncing!';
}
$db->SelectDB('mle');
// insert into mle.bounced table
$reason = $db->EscapeString($reason);
// get other bounced column
$col_other = $bounced_col == 'count' ? 'mailboxfull' : 'count';
