Creating a LoginShare

[Rodney B]

Originally Posted by craigbrass

So you mean its just plain text passwords (ie examplepassword would be stored as examplepassword in the database)?

For now, yes, that's what it appears to be.

After reading a bit more, we'll probably need to change that ASAP. But in the mean time, I'd like to see if I can get the loginshare working with the current setup. Then I know it will be easy to get it working once we get the MD5 implemented.

[craigbrass]

Try replacing $_user["password"] with md5($_user["password"])

[Rodney B]

Originally Posted by craigbrass

Try replacing $_user["password"] with md5($_user["password"])

That didn't seem to work. It still connects, but I get an invalid username/password error.

Here's what that section of the code looks like now:

PHP Code:

$userpassword = md5($password);
    
    $regpassword = substr(buildHash(),0,8);

    if (md5($_user["password"]) == $userpassword && !empty($_user["Password"])) 


[Rodney B]

anybody have any ideas?

[mopa]

Do you know if it is possible to integrate this with a MS SQL Server 2005?

[craigbrass]

Yep. See Microsoft SQL and LoginShare for more details.

[gauravdc]

Thanks craig....just finished integrating the system with my website

Your instructions were great!

Thanks again!

[craigbrass]

Your welcome. Glad I could be of assistance.

[kingele18]

Hello!

I try to integrate with another supportsuite version on a localhost , so i can't do it becuse of the table " users" doesn't contain the emails...

so i need your help craig

sorry for my bad english

waiting for your reply

[craigbrass]

So what you are saying is one table contains usernames and passwords but another table contains email addresses?

[kingele18]

Originally Posted by craigbrass

4. Find the following line (2 lines down from the one in step 3) :-

$_user = $dbLoginShare->queryFetch("SELECT * FROM `". $_loginshare["vcdbprefix"] ."customers` WHERE `email` = '". $dbCore->escape($username) ."';");

and change "vc" to the initial you changed to in step 3. Also, change customers to the name of the table after the table prefix.

("SELECT * FROM `". $_loginshare["vcdbprefix"] ."customers` WHERE `email`
i mean this query , i think it's for getting the user who is using email....

in the supportsuite users table , there is no email ....

i wish you understood what i mean

[craigbrass]

I think your totally missing the point of a LoginShare. It connects to a 3rd party script database (such as phpBB, vBulletin, etc) so users can login with the same details.

You don't need to worry about SupportSuite's database.

[Xav]

There are one thing or two I don't understand with loginshare...

Ok, I read and did all steps described in this topic. Now, do I need to modify something in my 3rd party app?

In my case, it is a simple login form in other part on my website. What could I do now?

TIA

[craigbrass]

You don't need to modify the 3rd party app. You just connect to it by creating a LoginShare.

[Xav]

Hello craigbrass,

Sorry but I'm missing something. How to pass the session to eSupport to launch functions contained in the xxx.login.php and check if the user exists...