Re: restriction class and mysql lookup

[Zhang Huangbin]

Magnus � wrote:
On Tuesday, August 19, 2008 at 04:48 CEST,
     Zhang Huangbin <[EMAIL PROTECTED]> wrote:
[...]

  
In my record:
----cut<<----
mysql> select username,restriction_class,restricteddomain from 
restrictions;
+----------+-----------------------+------------------+
| username | restriction_class     | restricteddomain |
+----------+-----------------------+------------------+
| [EMAIL PROTECTED] | internal_deliver_only | b.cn             |
+----------+-----------------------+------------------+
----cut<<----

Replace mysql lookup by hash file, it works:
----cut<<----
b.cn   OK
----cut<<----

So, what SQL query should i use in mysql lookup file?
    

Use any query that returns "OK" is the lookup key is "b.cn".

query = SELECT "OK" FROM restrictions WHERE restricteddomain = '%s'
  

Thanks Magnus. :)

It works. But which filed should i use to match 'username' ([EMAIL PROTECTED]) in 
query string?

query = SELECT "OK" FROM restrictions WHERE restricteddomain='%s' AND 
username='???'

Thanks very much.