Are you making a suggestion or did you actually get it to work this way?
"Anton Raharja" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> wrote in message > >news:[EMAIL PROTECTED] > >> ok now you know that xdb_sql sent you [EMAIL PROTECTED] 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 [EMAIL PROTECTED] replacing $$username$$ but > >> than SUBSTRING_INDEX makes the query only recognize 'user' part > >> do some changes on xml file to suite your needs _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
