index : builder | |
Archlinux32 build system | gitolite user |
summaryrefslogtreecommitdiff |
author | Erich Eckner <git@eckner.net> | 2018-09-25 23:24:00 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-09-25 23:24:00 +0200 |
commit | 66e5a09a9def89da730b31e39e52430a258027b4 (patch) | |
tree | e5c80046c813baab1f209a431970ab8951c34525 /bin/interpret-mail | |
parent | 1bde639672388022104723bb65d863355b967fc7 (diff) |
-rwxr-xr-x | bin/interpret-mail | 8 |
diff --git a/bin/interpret-mail b/bin/interpret-mail index 7790951..a925118 100755 --- a/bin/interpret-mail +++ b/bin/interpret-mail @@ -66,7 +66,7 @@ log() { fi # shellcheck disable=SC2016 { - printf 'INSERT INTO `email_log` (`success`,`action`,`count`,`gpg_key`,`comment`)' + printf 'INSERT IGNORE INTO `email_log` (`success`,`action`,`count`,`gpg_key`,`comment`)' printf ' SELECT ' if [ "${success}" = '1' ]; then printf '1,' @@ -131,7 +131,7 @@ if ! hashcash -qXc -b 20 \ "${tmp_dir}/mail"; then # shellcheck disable=SC2016 { - printf 'INSERT INTO `email_log` (`success`,`comment`)' + printf 'INSERT IGNORE INTO `email_log` (`success`,`comment`)' printf ' VALUES (0,"Invalid stamp - ignoring this message.");\n' } | \ mysql_run_query @@ -151,7 +151,7 @@ if ! sed -n ' gpg --batch --status-file "${tmp_dir}/gpg-status" -q -d -o "${tmp_dir}/plain-content" > /dev/null 2>&1; then # shellcheck disable=SC2016 { - printf 'INSERT INTO `email_log` (`success`,`comment`)' + printf 'INSERT IGNORE INTO `email_log` (`success`,`comment`)' printf ' VALUES (0,from_base64("%s"));\n' \ "$( { @@ -191,7 +191,7 @@ gpg_keys_filter=$( if [ -z "${gpg_keys_filter}" ]; then # shellcheck disable=SC2016 { - printf 'INSERT INTO `email_log` (`success`,`comment`)' + printf 'INSERT IGNORE INTO `email_log` (`success`,`comment`)' printf ' VALUES (0,from_base64("%s"));\n' \ "$( { |