X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/bd01be7c73f0cb65d39bee92874a8d1b2957c852..a61350bc7ddd403460f79498a48e07f101fc2067:/procmail/sql-escape

diff --git a/procmail/sql-escape b/procmail/sql-escape
new file mode 100644
index 0000000..08d0903
--- /dev/null
+++ b/procmail/sql-escape
@@ -0,0 +1,17 @@
+SQ="'\\''"
+SQE="'\\\''"
+
+:0
+* DATA ?? .
+{ 
+  DATA="`echo \"$DATA\" \
+    | sed -re 's,'\'','$SQE$SQE',g;' \
+          -e  's/^.*$/'\$SQE'&'\$SQE'/' \
+          -e  's/,'$SQE'$/'\$SQE',/'`"
+}
+
+:0 E
+{ LOG="sql-escape:  WARNING: no \$DATA provided!$NL" }
+
+SQE
+SQ