#!/usr/local/bin/php
<?
	define('TABLE_WHITELIST', 'whitelist');
	define('WHITELIST_SENDER', 'sender');
	define('WHITELIST_ORIGIN', 'origin');
	define('WHITELIST_DATE_ADD', 'date_add');
	define('WHITELIST_TYPE', 'type');
	define('ADDING_TYPE', 2); //type 2 is an e-mail
	define('ADMIN_EMAIL', 'admin@domain.tld');

	$dsn = array(
		'phptype'	=> 'mysql',
		'protocol'	=> 'unix',
		'socket'	=> '/tmp/mysql.sock',
		'database'      => 'database',
		'username'      => 'user',
		'password'      => 'password'
		    );

	//first, check if we have an e-mail in env var
	if ( $address = strtolower(getenv('RECIPIENT')) ) {
		//second, connect to database
		require_once 'DB.php';
		
		$db = DB::connect($dsn);
		if (!DB::isConnection($db)) {
			mail(ADMIN_EMAIL, 'whitener', 'No DB Connection! while adding ' . $address);
			exit;
		}

		$query = sprintf("INSERT
				  INTO `%s` (%s, %s, %s, %s)
				  VALUES (%s, %s, NOW(), %d)",
				 TABLE_WHITELIST, WHITELIST_SENDER, WHITELIST_ORIGIN, WHITELIST_DATE_ADD, WHITELIST_TYPE,
				 $db->quoteSmart($address), $db->quoteSmart(strtolower(getenv('SENDER'))), ADDING_TYPE);
		$result = $db->query($query);
		$text = "Inserting $address\n\n$query\n\n";
		if (PEAR::isError($result) && !preg_match('/already exists/', $result->message)) {
			$text .= "Error!";
			mail(ADMIN_EMAIL, 'whitener', $text);
		}
		//debug mail(ADMIN_EMAIL, 'whitener', $argv[1]);
		exit;
	} else {
		//debug mail(ADMIN_EMAIL, 'whitener', 'No RECIPIENT!');
	}

?>