Here's a quick idea of a mySQL table setup and a few SQL Calls for
Qmail-Scanner:
Most of this should be self-explanatory. I'm not beholden to any of the
table or column names. Comments welcome.
CREATE database qmailScanner;
CREATE TABLE domainpref (
domainid int(11) NOT NULL auto_increment,
domainname varchar(80) NOT NULL,
password varchar(12) NOT NULL,
prefix_subject int(11) NOT NULL default '0',
prefix_text varchar(20) NULL default '[SPAM] ',
notify_address varchar(80) NULL default 'postmaster',
viri_address varchar(80) NULL default 'quarantine',
spam_address varchar(80) NULL default 'spam',
PRIMARY KEY (domainid),
KEY domainname (domainname)
) PACK_KEYS=1;
CREATE TABLE attachmentpref (
domainid int(11) NOT NULL ,
string_one varchar(250) NOT NULL,
string_two varchar(80) NOT NULL,
description varchar(80) NOT NULL,
PRIMARY KEY (domainid)
) PACK_KEYS=1;
## Grab Local Domains
SELECT domainpref.domainname
FROM domainpref
ORDER BY domainname;
## Grab Reroute Addresses & Subject Tweak
SELECT domainpref.notify_address
,domainpref.viri_address
,domainpref.spam_address
,domainpref.use_subject
FROM domainpref
WHERE domainname = '$DomainName';
## Grab Attachment Filters
SELECT attachmentpref.string_one
,attachmentpref.string_two
,attachmentpref.description
FROM attachmentpref, domainpref
WHERE domainpref.domainname = '$DomainName'
AND attachmentpref.domainid = domainpref.domainid;
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
No, I will not fix your computer.
http://thinkgeek.com/sf
_______________________________________________
Qmail-scanner-general mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/qmail-scanner-general
