Thanks, that saved me some time. On 2/5/09, Marcin Gryszkalis <[email protected]> wrote: > I used something like that and I can confirm it worked well (lines broken so > don't forget to put \ here and there) > > # updating traffic data, condition is always false > warn > # domains = ! +local_domains > authenticated = * > condition = > ${lookup mysql { > INSERT INTO traffic (username,domain,day,sent) > values('${quote_mysql:${local_part:$authenticated_id}}','${quote_mysql: > ${domain:$authenticated_id}}',date(now()),$message_size) > ON DUPLICATE KEY UPDATE sent=sent+$message_size > }{$value}fail} > log_message = DEBUG traffic registered from > $authenticated_id/$authenticated_sender ($sender_address): $message_size > bytes > > accept > > -- > Marcin Gryszkalis, PGP 0x9F183FA3 > jabber jid:[email protected], gg:2532994 > http://the.fork.pl > > -- > ## List details at http://lists.exim.org/mailman/listinfo/exim-users > ## Exim details at http://www.exim.org/ > ## Please use the Wiki with this list - http://wiki.exim.org/ >
-- ## List details at http://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
