Login using userid and password from other database

[eteune]

YaBB SE Version: 1.5.4
PHP Version: 4.1.1
MySQL Version: 4.0.x
Server Platform: Windows
Link to Forum:

Problem Description:
Is it possible to use the login and password information from a different mySQL database sitting on the same machine as my YaBBSE install for login to YaBBSE ?
I have a portal already in place and the users are complaining that they have to login to the portal then login to the BB. So I need to combine them.

As a second option, I'm sure it has been covered but how do I use YaBBSE's login scheme for a larger portal of which YaBBSE is a part?

Any suggestions or pointers to exisiting threads/answers greatly appreciated.

Ed

[eteune]

Sorry, here is part of the answer I was looking for already posted:

http://www.yabbse.org/community/index.php?thread=25559

Maybe I could use the same ideas to go the other way and use my exising login scheme for YaBBSE, any ideas?

Ed

[[Unknown]]

What portal are you using?

It's fairly easy to integrate YaBB SE in - I've done it at least 5 times.

-[Unknown]

[eteune]

Several actually, mostly written by myself.
In the process of rewriting the ASP version into JSP and also working on a PHP version.
On top of that have another project where one of the project managers likes YaBBSE so well after I demoed it, that he wants to use YaBBSE's login scheme for the entire PHP base site.
So I guess I was just looking for some high level stuff first to explain to the teams and then I will just have to dig down in the code myself to understand it better.
But any pointers are greatly appreciated.

Ed

[[Unknown]]

Well, I'm going to first say that I hate ASP with a passion.  Sorry.

For the PHP, it's actually pretty simple.

You have to connect to the database - which isn't too hard, just look at how index.php does it... and then you read the cookie:
list ($id, $pass) = unserialize(stripslashes($_COOKIE[$cookienameFromSettingsPhp]));

And then you check for the "passwd" column in members, where ID_MEMBER = $id.

Then, you check that $pass against md5_hmac(passwd_in_database, 'ys'). (md5_hmac is in Load.php.)

-[Unknown]

[eteune]

No need for apologizing, like I said, I am now rewriting the old ASP stuff into Java/JSP and PHP. Java/JSP because it integrates with our company's product and PHP because I like it.

Thanks for the tip, I will give it a spin shortly.