imsoftware imsoftware

uberspace, maildrop & MySQL

A simple maildrop sender filter with MySQL backend

This is a simple maildrop filter which filters incoming messages by the sender address and move it to the corresponding folder. E-Mail address and destination folder are both defined in a MySQL table.

This example is used in an uberspace environment.

Step 1: Create MySQL table

For convenience we use the already existing database corresponding to your uberspace account (e.g. your uberspace username is melanie there will be already a database called melanie.

	SELECT tablename.colname
	FROM tablename
	INNER JOIN (
	SELECT colname
	FROM tablename
	GROUP BY colname
	HAVING COUNT(db_pid) > 1
	)
	dup ON tablename.colname = dup.colname

	// List prime numbers with processing 2
	// Quick n dirty solution. Not for production.
	// By: http://mariusmüller.de

	void setup() {

	float number = 0; // standard input
	int count = 100; // count until 100
	boolean ISPRIME = true; // 1=true (is prime); 0=false (not)