[jadmin] Message filtering using SQL with jabberd14

[Grégoire Menuel]

Le Jeudi 8 Mars 2007 20:27, David Ammouial a écrit :
> Hello,
>
> I am using jabberd14 1.6.0.
>
> I would like to use jabberd14's custom SQL query mechanism to decide if a
> given message is allowed to be sent/received, according to database
> information.
>
> Unfortunately, unlike many other parts of the communication
> (getting/setting one's roster, for example), the message delivery doesn't
> have a dedicated SQL section in the configuration file. A section expecting
> a boolean as a result of the request, for example, would probably do the
> job.
>
> Is there a way to reuse the SQL query mechanism to implement message
> filtering?

It shouldn't be to complicate to create a small module which drops thoses 
messages. The only problem is to access the database, I don't see how to give 
two arguments (to and from) to an xdb_get query, but I'm not very familiar 
with the xdb part of jabberd14.

-- 
Grégoire Menuel
xmpp:omega at im.apinc.org
GPG: 1024D/D3BF3B20