[JDEV] Re: Re: Re: xdb_sql

[Sonic98]

Also, I wonder how much it would slow things down if I change the login
script, so when someone trys to login it checks if they're registered on the
jabber server, and if they're registerd on my site but not the registerd on
the jabber server, it automatically registers them.  But if they are
registered on both it just logs them in to both.

Then again what I could do is wait til they try to launch the IM for it to
check. That way it won't have to check my DB to see if they're a memeber of
my website. Beause I already have a script on my page that won't let you get
on certain pages if you're not a member. So, I can make it where it won't
even launch the IM page if they're not a member. Then I can just make it
check the user name they're logged into my site with is on the jabber
server, and if not just register it then. Then I wouldn't have to make much
change to my IM script at all. Heck I wouldn't even have to use xdb_sql at
all.

Ofcourse we wouldn't be having this problem if some jabber and xdb_sql
developers realized that some people actually want to add jabber to a site
that already has some form of member system setup.



"Sonic98" <raymondcox at redlasertech.com> wrote in message
news:bfetdg$2dr$1 at main.gmane.org...
> I guess I could just use seperate tables for my forum and jabber. I
already
> have ibf_members. I could add jabber_members table. I could copy the user
> names and passwords from ibf_members to jabber_members, and just change my
> registration page so that new members automatically are registered with
> both.
>
> But then again, it would be easier, whether I was going to use a DB or not
> if someoone had a script that would pull the user names and passwords out
of
> my DB then automatically register it with the jabber server(basically add
> them to the jabber_members table or create the folder/xml file on the
> server)
>
> "Sonic98" <raymondcox at redlasertech.com> wrote in message
> news:bfej0i$ohj$1 at main.gmane.org...
> > Oh, that was you. I guess I'll have to have my current members register
> for
> > the server also, but change my script so when new people register they
> also
> > register for the server. I'll also have to find a way to make it
> > automatically login to the IM, if they try to launch it while already
> logged
> > into the website.
> >
> > "Hernux" <hernuz at etherac.com.ar> wrote in message
> > news:000d01c34ee0$20cfdc80$0200a8c0 at acer...
> > > I don't like it too...
> > > I tried to modify it, but It's almost imposible... some one told me, I
> was
> > > going to blood from ears....
> > > ;-)
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Sonic98" <raymondcox at redlasertech.com>
> > > To: <jdev at jabber.org>
> > > Sent: Sunday, July 20, 2003 1:24 PM
> > > Subject: [JDEV] Re: Re: xdb_sql
> > >
> > >
> > > > So, what you're saying is that when a user registers and it stores
> thier
> > > > information in the database it stores it as "user at site.com" ? That
> would
> > > be
> > > > ok for my exisiting memebers cause I could just make a PHP script
use
> > pull
> > > > out the username but stick @site.com on the end of it? But for new
> > members
> > > > it would be no good because it would create a new user in my
database
> > for
> > > my
> > > > site, but then jabber would also store "user at site.com" in the
> database.
> > I
> > > > don't know if I want it doing that. There has to be another way. I
> would
> > > > really hate to have my users have to register seperately for the
> jabber
> > > > client.
> > > >
> > > > "Hernux" <hernuz at etherac.com.ar> wrote in message
> > > > news:001501c34ed6$5017f0e0$0200a8c0 at acer...
> > > > >
> > > > > Yes. You can use an existing DB.
> > > > > I've tried it, but not too much...you just need to set your
queries
> to
> > > the
> > > > > table where you have your usernames and password...thats all you
> need,
> > > > other
> > > > > data is created automatically by de server.
> > > > >
> > > > > The problem I found, which made it unsuitable for me, is that it
> looks
> > > for
> > > > > usernames in the way "user = 'user at foo.com'" and I think I'd be
> better
> > > > > looking for "user = 'user' AND domain = 'foo.com'".  This way, I
can
> > use
> > > > the
> > > > > domain as identifier of the user's company....or may be better,
just
> > > > making
> > > > > a join at the select and look for the domain in other table
> (companies
> > > > table
> > > > > may be).
> > > > >
> > > > > Anyway, now I'm trying LDAP authentication.  And it doesn't work
the
> > way
> > > I
> > > > > need too.
> > > > > :'(
> > > > >
> > > > > Hernux
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Sonic98" <raymondcox at redlasertech.com>
> > > > > To: <jdev at jabber.org>
> > > > > Sent: Sunday, July 20, 2003 12:16 PM
> > > > > Subject: [JDEV] Re: xdb_sql
> > > > >
> > > > >
> > > > > > Anyway to get this to work with a current database? I think this
> > > > > > documentation is for setting up a new database to work with your
> > > jabber
> > > > > > server. What about if you already have a database with member
> > > > information
> > > > > > already in it? Can you make is just pull usernames and passwords
> > from
> > > > that
> > > > > > database?
> > > > > >
> > > > > >
> > > > > > "Raymond Cox" <raymondcox at redlasertech.com> wrote in message
> > > > > > news:bfe9vp$jt9$1 at main.gmane.org...
> > > > > > > That is actually one of the sites I'd looked at already. I was
> > > hoping
> > > > > for
> > > > > > > just a little bit more docuomentation about xdb_sql and how it
> > works
> > > > > > because
> > > > > > > I know nothing about it. Plus, I'm using PHP not Perl although
> the
> > > > > syntax
> > > > > > is
> > > > > > > similar.
> > > > > > > "Anton Raharja" <anton at ngoprek.org> wrote in message
> > > > > > > news:200307201422380651.01B941D8 at 192.168.0.6...
> > > > > > > > this site gave me right direction:
> > > > > > > > http://docs.myjabber.net/howto/mysql.htm
> > > > > > > >
> > > > > > > > *********** REPLY SEPARATOR  ***********
> > > > > > > >
> > > > > > > > On 20/07/2003 at 0:43 Raymond Cox wrote:
> > > > > > > >
> > > > > > > > >I downloaded the files and read the readme. It's kind of a
> poor
> > > > > excuse
> > > > > > > for
> > > > > > > > >documenation. Where can I go to really find some
information
> on
> > > > > > xdb_sql,
> > > > > > > > >how
> > > > > > > > >it works, what it does, and whether I really need it or
not.
> > > > > >
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > jdev mailing list
> > > > > > jdev at jabber.org
> > > > > > http://mailman.jabber.org/listinfo/jdev
> > > > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > jdev mailing list
> > > > jdev at jabber.org
> > > > http://mailman.jabber.org/listinfo/jdev
> > > >