diff options
Diffstat (limited to 'bin/interpret-mail')
| -rwxr-xr-x | bin/interpret-mail | 8 |
1 files changed, 4 insertions, 4 deletions
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' \ "$( { |