Hi Paul, What about adding this to the dbmail-util program to check of out-of-date auto replies? It will save performance.
Best regards, Eelco On Mon, 8 Aug 2005, Paul J Stevens wrote:
Some of todays action in svn-trunk: I've added two new datetime fields to the dbmail_auto_replies table called start_date and stop_date. This way activation and deactivation of auto_replies is shoot and forget. If no start_date and/or stop_date is specified in the table, default values are used in the query. "SELECT reply_body FROM %sauto_replies " "WHERE user_idnr = %llu " "AND NOW() BETWEEN COALESCE(start_date,DATE '1900-01-01') " "AND COALESCE(stop_date, DATE '3000-01-01'", DBPFX,user_idnr); this way, rather than using default values in the table, if a user clears such a value, auto_reply behaviour should still follow the rule of least surprise. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
