[JDEV] Re: Re: Re: xdb_sql

[Anton Raharja]

keep your PHP script and db, dont change that
tblPerson is on my script and now everytime jabber client register or auth
jabber server pass it to xdb_sql and wrote everything to my tblPerson

all im trying to say is..just use same table for jabber and your script but keep your script and change the jabber part
use xdb_sql, try it..

if anyone can do better than that, we surely do need some advice here

*********** REPLY SEPARATOR  ***********

On 21/07/2003 at 2:17 Sonic98 wrote:

>I'm not sure I'm getting you. I actually haven't played around with
>xdb_sql
>at all. I'm still trying to learn about it. All I know is I want to add the
>PHP/Jabber webmessenger I saw on my site, and I don't the memebers in my
>site's database to have to register seperarely for the jabber server. Too
>bad all the jabber servers that use databases instead of files are
>commercial.
>
>"Anton Raharja" <anton at ngoprek.org> wrote in message
>news:200307210330330090.013B9B97 at 192.168.0.6...
>> ok now you know that xdb_sql sent you user at domain but your PHP script
>more
>> to 'user' and 'domain' separately saved
>> my choice is to let PHP keep old setting and xdb_sql tricked
>> heres some example of my jabber-sql.xml:
>>
>>     <queries>
>>       <!-- Authentication get query (all queries have standard names) -->
>>       <querydef name="auth-get">
>>         <text>SELECT PersonPassword FROM tblPerson WHERE PersonUsername =
>> SUBSTRING_INDEX('$$username$$','@',1)</text>
>>         <bindvar name="user">$$username$$</bindvar>
>>         <bindcol name="password" offset="0"/>
>>       </querydef>
>>
>>       <!-- Authentication set query -->
>>       <querydef name="auth-set">
>>         <text>UPDATE tblPerson SET PersonPassword = '$$p$$' WHERE
>> PersonUsername = SUBSTRING_INDEX('$$username$$','@',1)</text>
>>         <bindvar name="user">$$username$$</bindvar>
>>         <bindvar name="password">$$p$$</bindvar>
>>       </querydef>
>>    ...
>>    ...
>>    </queries>
>>
>> there, when user auth xdb_sql pass user at domain replacing $$username$$ but
>> than SUBSTRING_INDEX makes the query only recognize 'user' part
>> do some changes on xml file to suite your needs