Ich habe jetzt eine stored Procedure angelegt, die offenbar tut, was ich
will.
Für Interessierte:
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_amavis_settings`(IN
`address` VARCHAR(255))
BEGIN
DECLARE menge INT DEFAULT 0;
DECLARE position INT DEFAULT 0;
DECLARE domain VARCHAR(255) DEFAULT '';
DECLARE mengeca INT DEFAULT 0;
SELECT COUNT(*) FROM mail_virtual WHERE email = address INTO menge;
IF menge > 0 THEN
SELECT "Y" as local, 1 AS id, email AS sa_username,
bypass_virus_checks, bypass_spam_checks, spam_tag2_level, spam_kill_level
FROM mail_virtual WHERE email = address LIMIT 1;
ELSE
SELECT LOCATE('@', address) INTO position;
SELECT SUBSTRING(address, position) INTO domain;
SELECT COUNT(*) FROM mail_virtual WHERE iscatchall =
1 AND email LIKE domain INTO mengeca;
IF mengeca > 0 THEN
SELECT "Y" as local, 1 AS id, address AS
sa_username, bypass_virus_checks, bypass_spam_checks, spam_tag2_level,
spam_kill_level FROM mail_virtual WHERE iscatchall = 1 AND email LIKE domain
LIMIT 1;
ELSE
SELECT 'N' AS local, '1' AS id, address AS
sa_username, 'Y' AS bypass_virus_checks, 'Y' AS bypass_spam_checks, '999' AS
spam_tag2_level, '999' AS spam_kill_level;
END IF;
END IF;
END$$
DELIMITER ;
Aufgerufen wird dann aus amavis mit "CALL get_amavis_settings(%a);"
Mit freundlichen Grüßen / Kind regards
Ronny Seffner
--
Ronny Seffner | Alter Viehweg 1 | 01665 Klipphausen
www.seffner.de | [email protected] | +49 35245 72950
7EA62E22D9CC4F0B74DCBCEA864623A568694DB8
