350
351
# $viruses_that_fake_sender_re = undef;
351
352
# @viruses_that_fake_sender_maps = (\$viruses_that_fake_sender_re, 1);
352
353
# @virus_name_to_spam_score_maps =
353
# (new_RE( [ qr'^(Email|HTML)\.(Phishing|Spam|Scam[a-z0-9]?)\.'i => 0.1 ],
354
# [ qr'^(Email|Html)\.Malware\.Sanesecurity\.' => undef ],
355
# [ qr'^(Email|Html)(\.[^., ]*)*\.Sanesecurity\.' => 0.1 ],
356
# [ qr'^(MSRBL-Images/|MSRBL-SPAM\.)' => 0.1 ],
354
# (new_RE( # the order matters!
355
# [ qr'^Phishing\.' => 0.1 ],
356
# [ qr'^(Email|HTML)\.Phishing\.(?!.*Sanesecurity)' => 0.1 ],
357
# [ qr'^Sanesecurity\.(Malware|Rogue|Trojan)\.' => undef ], # keep infected
358
# [ qr'^Sanesecurity(\.[^., ]*)*\.' => 0.1 ],
359
# [ qr'^Sanesecurity_PhishBar_' => 0 ],
360
# [ qr'^Email\.Spam\.Bounce(\.[^., ]*)*\.Sanesecurity\.' => 0 ],
361
# [ qr'^(MSRBL-Images\b|MSRBL-SPAM\.)' => 0.1 ],
362
# [ qr'^VX\.Honeypot-SecuriteInfo\.com\.Joke' => 0.1 ],
363
# [ qr'^VX\.not-virus_(Hoax|Joke)\..*-SecuriteInfo\.com(\.|\z)' => 0.1 ],
364
# [ qr'^Email\.Spam.*-SecuriteInfo\.com(\.|\z)' => 0.1 ],
365
# [ qr'-SecuriteInfo\.com(\.|\z)' => undef ], # keep as infected
366
# [ qr'^MBL_' => undef ], # keep as infected
359
369
# $banned_namepath_re = undef; # new-style
452
462
# 'sel_policy' => \$sql_select_policy,
453
463
# 'sel_wblist' => \$sql_select_white_black_list,
455
# 'SELECT id FROM maddr WHERE email=?',
465
# 'SELECT id FROM maddr WHERE partition_tag=? AND email=?',
457
# 'INSERT INTO maddr (email, domain) VALUES (?,?)',
467
# 'INSERT INTO maddr (partition_tag, email, domain) VALUES (?,?,?)',
459
# 'INSERT INTO msgs (mail_id, secret_id, am_id, time_num, time_iso, sid,'.
460
# ' policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?,?)',
469
# 'INSERT INTO msgs (partition_tag, mail_id, secret_id, am_id,'.
470
# ' time_num, time_iso, sid, policy, client_addr, size, host)'.
471
# ' VALUES (?,?,?,?,?,?,?,?,?,?,?)',
462
473
# 'UPDATE msgs SET content=?, quar_type=?, quar_loc=?, dsn_sent=?,'.
463
# ' spam_level=?, message_id=?, from_addr=?, subject=? WHERE mail_id=?',
474
# ' spam_level=?, message_id=?, from_addr=?, subject=?, client_addr=?'.
475
# ' WHERE partition_tag=? AND mail_id=?',
465
# 'INSERT INTO msgrcpt (mail_id, rid,'.
466
# ' ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?)',
477
# 'INSERT INTO msgrcpt (partition_tag, mail_id, rid,'.
478
# ' ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?,?)',
468
# 'INSERT INTO quarantine (mail_id, chunk_ind, mail_text)'.
480
# 'INSERT INTO quarantine (partition_tag, mail_id, chunk_ind, mail_text)'.
481
# ' VALUES (?,?,?,?)',
482
# 'sel_msg' => # obtains partition_tag if missing in a release request
483
# 'SELECT partition_tag FROM msgs WHERE mail_id=?',
471
# 'SELECT mail_text FROM quarantine WHERE mail_id=? ORDER BY chunk_ind',
485
# 'SELECT mail_text FROM quarantine'.
486
# ' WHERE coalesce(partition_tag,0)=coalesce(?,0) AND mail_id=?'.
487
# ' ORDER BY chunk_ind',
488
# 'sel_penpals' => # no message-id references list
473
489
# "SELECT msgs.time_num, msgs.mail_id, subject".
474
# " FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id".
475
# " WHERE sid=? AND rid=? AND ds='P' AND content!='V'".
476
# " ORDER BY time_num DESC LIMIT 1",
490
# " FROM msgs JOIN msgrcpt USING (partition_tag,mail_id)".
491
# " WHERE sid=? AND rid=? AND content!='V' AND ds='P'".
492
# " ORDER BY msgs.time_num DESC", # LIMIT 1
493
# 'sel_penpals_msgid' => # with a nonempty message-id references list
494
# "SELECT msgs.time_num, msgs.mail_id, subject, message_id, rid".
495
# " FROM msgs JOIN msgrcpt USING (partition_tag,mail_id)".
496
# " WHERE sid=? AND content!='V' AND ds='P' AND message_id IN (%m)".
498
# " ORDER BY rid=? DESC, msgs.time_num DESC", # LIMIT 1
479
501
## LDAP, Please see file README.lookups for more info.