[JDEV] Re: Re: Re: Re: xdb_sql

[Sonic98]

Are you making a suggestion or did you actually get it to work this way?


"Anton Raharja" <anton at ngoprek.org> wrote in message
news:200307211503440054.011D4DA3 at 192.168.0.6...
> 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