To: bernard.le@orange-ftgroup.com
From: Norman Brandinger <norm@goes.com>
Date: 08/20/2007 10:58PM
cc: users@openser.org
Subject: Re: [OpenSER-Users] restriction on user (dialer map)

Hi Bernard,

I put together a couple of examples awhile ago and they are located at:
http://www.openser.org/docs/avp_db_query.html

If you extend some of the examples and think about  perhaps a
"blacklist" table and/or a "whitelist" table it would be just a matter
of checking to see of the ($rU == $avp(s:blacklist_entry).

For example:

if (!(avp_db_query("SELECT phone_number  FROM blacklist_table WHERE
(phone_number = '$rU')", "$avp(s:blacklist)")) {
   # Entry NOT found in blacklist_table
} else {
 # Entry FOUND in blacklist_table
}

There are probably a dozen different ways to solve your problem.  Your
particular situation will determine the solution that best fits your need.

Regards,
Norm


bernard.le@orange-ftgroup.com wrote:
> Hi
>  
> Can someone tell me how it is possible to have a dialer map.
> I mean that I don't know everyone to call everyone.
> I want to restrict a user to call some specific user only.
>  
> e.g. :
> A call B
> A call D
> B call C
> D call C
>  
> If B call D or A call C, this is not allow
> Of course it looks easy with IF condition but I will have about more
> that 1000 users.
> I thought with mysql, but I can't find documentation or example.
>  
> Can someone help me ???
>  
> Bernard
> =
> ------------------------------------------------------------------------
>
> *********************************
> This message and any attachments (the "message") are confidential and intended solely for the addressees.
> Any unauthorised use or dissemination is prohibited.
> Messages are susceptible to alteration.
> France Telecom Group shall not be liable for the message if altered, changed or falsified.
> If you are not the intended addressee of this message, please cancel it immediately and inform the sender.
> ********************************
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users@openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>