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
