Re: restriction class and mysql lookup

2008-08-20 Thread Zhang Huangbin
Thanks mouss. :) Use hash file as replacement now.

Re: restriction class and mysql lookup

2008-08-19 Thread mouss
Zhang Huangbin wrote: 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; +--+---+--

Re: restriction class and mysql lookup

2008-08-19 Thread 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 | res

Re: restriction class and mysql lookup

2008-08-18 Thread Magnus Bäck
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_cl

Re: restriction class and mysql lookup

2008-08-18 Thread Zhang Huangbin
mouss wrote: so your check_recipient_access returns 'b.cn', which is not a valid action. what are you trying to do? you cannot implement checks based on multiple fields at a time, so your table design is suspicious (username and restricteddomain are independent). Thanks mouss. :) i want t

Re: restriction class and mysql lookup

2008-08-18 Thread mouss
Zhang Huangbin wrote: Hi, all. I'm confused about restriction class and the mysql lookup file format. What i should use in 'query'? Thanks very much. :) MySQL table structure: cut<< +---+--+--+-+-+---+ | Field