]> git.madduck.net Git - etc/mailfilter.git/commitdiff

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:

no more slew magic when selecting expired messages
authormartin f. krafft <madduck@madduck.net>
Sun, 2 Mar 2008 15:45:09 +0000 (16:45 +0100)
committermartin f. krafft <madduck@madduck.net>
Sun, 2 Mar 2008 15:45:09 +0000 (16:45 +0100)
bin/process-delayed-queue
bin/release-delayed-messages

index e978a40aacc9125166a658b7544d095390748fb8..6ab11636baf0015f02b52005943b12ce8f926b54 100755 (executable)
@@ -8,7 +8,7 @@ RESUBMIT=$HOME/.etc/mailfilter/bin/resubmit
 
 DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite
 
 
 DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite
 
-QUERY='select * from messages where release_ts < strftime("%s", "now")'
+QUERY='select * from messages where release_ts <= strftime("%s", "now")'
 
 $SQLITE -list -separator ' ' $DELAYED_QUEUE_DB "$QUERY" \
   | while read msgid basefile ts; do
 
 $SQLITE -list -separator ' ' $DELAYED_QUEUE_DB "$QUERY" \
   | while read msgid basefile ts; do
index 6a057c97ff808572036bcb41070a59e633725566..fd381d37fd550112bd4d4922908feab2799085a2 100755 (executable)
@@ -6,7 +6,7 @@ MAILDIR=$HOME/.maildir
 SQLITE=/usr/bin/sqlite3
 DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite
 
 SQLITE=/usr/bin/sqlite3
 DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite
 
-QUERY="update messages set release_ts = strftime('%s', 'now') - 10 where filename like '.delayed/%'"
+QUERY="update messages set release_ts = strftime('%s', 'now') where filename like '.delayed/%'"
 
 $SQLITE $DELAYED_QUEUE_DB "$QUERY"
 exec $HOME/.etc/mailfilter/bin/process-delayed-queue
 
 $SQLITE $DELAYED_QUEUE_DB "$QUERY"
 exec $HOME/.etc/mailfilter/bin/process-delayed-queue