Код: Выделить всё
if
$sender_address is "${lookup mysql{SELECT `mail_address` FROM `black_list` WHERE `mail_address`='$sender_address' LIMIT 1}}"
or $reply_address is "${lookup mysql{SELECT `mail_address` FROM `black_list` WHERE `mail_address`='$reply_address' LIMIT 1}}"
then
logwrite "$tod_log sender $sender_address is in black list. mail is deleting"
seen finish
endif
Код: Выделить всё
Return-path: <USER@mail.ru>
Envelope-to: system-filter
Delivery-date: Fri, 26 Sep 2008 16:54:26 +0300
Received: from f207.mail.ru ([194.186.55.151])
by HOST.cg.ukrtel.net with esmtp (Exim 4.69 (FreeBSD))
(envelope-from <USER@mail.ru>)
id 1KjDm6-0000PQ-ML
for USER@HOST.cg.ukrtel.net; Fri, 26 Sep 2008 16:54:26 +0300
Received: from mail by f207.mail.ru with local
id 1KjDka-0006ym-00
for USER@HOST.cg.ukrtel.net; Fri, 26 Sep 2008 17:52:52 +0400
Received: from [92.112.94.68] by win.mail.ru with HTTP;
Fri, 26 Sep 2008 17:52:52 +0400
From: USER <USER@mail.ru>
To: USER <USER@HOST.cg.ukrtel.net>
Subject: test
Mime-Version: 1.0
X-Mailer: mPOP Web-Mail 2.19
X-Originating-IP: [92.112.94.68]
Date: Fri, 26 Sep 2008 17:52:52 +0400
Reply-To: USER <USER@mail.ru>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 8bit
Message-Id: <E1KjDka-0006ym-00.USER-mail-ru@f207.mail.ru>
X-Spam: Not detected
X-Mras: OK
X-Spam-Description: if spam count > 60 - this is spam
X-Spam-Count: 10
Код: Выделить всё
Return-path: <gluck@mail.subscribe.ru>
Envelope-to: system-filter
Delivery-date: Tue, 30 Sep 2008 12:00:49 +0300
Received: from gato77.subscribe.ru ([81.222.129.77])
by HOST.cg.ukrtel.net with esmtp (Exim 4.69 (FreeBSD))
(envelope-from <gluck@mail.subscribe.ru>)
id 1Kkb68-000JAN-8K
for USER2@HOST.cg.ukrtel.net; Tue, 30 Sep 2008 12:00:49 +0300
Received: id 2AA7022DA3D-1222765125
X-Felis-Queue-Id: 20080930125840
Precedence: normal
List-Id: <ad.creatiff.subscribe.ru>
List-Help: <http://subscribe.ru/catalog/ad.creatiff>
List-Subscribe: <mailto:ad.creatiff-sub@subscribe.ru>
List-Unsubscribe: <mailto:ad.creatiff-unsub@subscribe.ru>
List-Archive: <http://subscribe.ru/archive/ad.creatiff>
List-Owner: <mailto:ask@subscribe.ru>
List-Post: NO
Message-Id: <20080930124952.hki.12055538@ad.creatiff.subscribe>
Date: Tue, 30 Sep 2008 12:49:52 +0400
From: "Subscribe.Ru" <namma12055538@subscribe.ru>
To: "ad.creatiff" <USER2@HOST.cg.ukrtel.net> (12055538)
Subject: =?koi8-r?Q?AdMe=2Eru=20-=20=F1=D2=CB=C9=C5=20=C9=C4=C5=C9=20=D7=20=D2=C5?=
=?koi8-r?Q?=CB=CC=C1=CD=C5=2C=20=CD=C1=D2=CB=C5=D4=C9=CE=C7=C5=20=C9=20PR?=
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="=felis-related=20080930125832=25949"
X-Spam-Description: if spam count > 60 - this is spam
X-Spam-Count: 10
Код: Выделить всё
SELECT * FROM `black_list`;
+----+----------------------------+
| id | mail_address |
+----+----------------------------+
| 1 | namma12055538@subscribe.ru |
| 2 | shizoid2@mail.ru |
+----+----------------------------+
2 rows in set (0.00 sec)
в чем прикол?
при чем первое режется по первому правилу
Код: Выделить всё
$sender_address is "${lookup mysql{SELECT `mail_address` FROM `black_list` WHERE `mail_address`='$sender_address' LIMIT 1}}"