]>
git.madduck.net Git - etc/mailfilter.git/blobdiff - procmail/msgid-index
madduck's git repository
Every one of the projects in this repository is available at the canonical
URL git://git.madduck.net/madduck/pub/<projectpath> — see
each project's metadata for the exact URL.
All patches and comments are welcome. Please squash your changes to logical
commits before using git-format-patch and git-send-email to
patches@ git. madduck. net .
If you'd read over the Git project's submission guidelines and adhered to them,
I'd be especially grateful.
SSH access, as well as push access can be individually
arranged .
If you use my repositories frequently, consider adding the following
snippet to ~/.gitconfig and using the third clone URL listed for each
project:
[url "git://git.madduck.net/madduck/"]
insteadOf = madduck:
# create table logfiles (sender text not null, recipient text not null,
# subject text not null, msgid text unique not null, filename text primary key
# create table logfiles (sender text not null, recipient text not null,
# subject text not null, msgid text unique not null, filename text primary key
-# not null unique, timestamp timestamp with time zone);
+# not null unique, timestamp timestamp with time zone, dest text not null );
#
# create trigger insert_logfiles_timestamp after insert on logfiles begin
# update logfiles set timestamp = datetime('now') where filename
#
# create trigger insert_logfiles_timestamp after insert on logfiles begin
# update logfiles set timestamp = datetime('now') where filename
SQ="'\\''"
SQE="'\\\''"
FIELDS="$FROM$NL$ORIGINAL_TO$NL$SUBJECT$NL$MSGID"
SQ="'\\''"
SQE="'\\\''"
FIELDS="$FROM$NL$ORIGINAL_TO$NL$SUBJECT$NL$MSGID"
-QUERY="insert into logfiles (sender, recipient, subject, msgid, filename) values (
+QUERY="insert into logfiles (sender, recipient, subject, msgid, filename, dest ) values (
`echo \"$FIELDS\" | sed -e 's,'\'','$SQE$SQE',g; s/^.*$/'\$SQE'&'\$SQE',/'`
`echo \"$FIELDS\" | sed -e 's,'\'','$SQE$SQE',g; s/^.*$/'\$SQE'&'\$SQE',/'`
- $SQ$THISLOGFILE_REL$SQ)"
+ $SQ$THISLOGFILE_REL$SQ, '\\'\$DEST\\'' )"
TRAP="$TRAP; $DO_QUERY '$QUERY'"
QUERY
TRAP="$TRAP; $DO_QUERY '$QUERY'"
QUERY
projects / etc / mailfilter.git / blobdiff