Creating a LoginShare

[craigbrass]

Ok, I decided to create a step by step guide to creating a LoginShare. This is the guide for integrating with a piece of software that uses MD5 password storage. Any reference to email can be changed to username if your system uses usernames instead.

1. Download vipercart.login.php (attached).

2. Rename the vipercart part of the file to the name of the software you are integrating with.

3. Find the following line :-

$dbLoginShare = new dbCore($_loginshare["vchostname"], $_loginshare["vcdbuser"], $_loginshare["vcdbpass"], $_loginshare["vcdbname"], "mysql", false);

and change the "vc" bits to the initials of the software you are integrating with.

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.

5. Find the following line :-

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

and change the "password" part of the two $_user["password"] bits to the name of the field the MD5 hashed password is in if it needs changing.

6. Find the following line :-

$userid = getLoginShareUser(LOGINAPI_VIPERCART, $_user["id"]);

and change VIPERCART to the full name of the software you are integrating with without spaces and fully capitalised.

7. Find the following line :-

$userid = insertUser(true, $_user["email"], $regpassword, $_SWIFT["tgroup"]["regusergroupid"], LOGINAPI_VIPERCART, $_user["id"], $_user["firstname"]." ".$_user["lastname"], $_SWIFT["tgroup"]["languageid"], 0, false, 1, true);

and change the parts in quotations in $_user["email"], $_user["firstname"] and $_user["lastname"] to the correct fields in the tables. Also changed VIPERCART to what you put in part 6.

8. Find the following section :-

$forms[0]["title"] = $_SWIFT["language"]["hostname"];
$forms[0]["name"] = "vchostname";
$forms[1]["title"] = $_SWIFT["language"]["dbname"];
$forms[1]["name"] = "vcdbname";
$forms[2]["title"] = $_SWIFT["language"]["dbuser"];
$forms[2]["name"] = "vcdbuser";
$forms[3]["title"] = $_SWIFT["language"]["dbpass"];
$forms[3]["name"] = "vcdbpass";
$forms[4]["title"] = "DB Table Prefix";
$forms[4]["name"] = "vcdbprefix";

and change all the vc bits to the initials of the software you are integrating the same as you did in step 4.

9. Upload the file you just created to /includes/LoginShare/.

10. Open loginshare.config.php inside that same directory.

11. From aproximatly line 21 onwards, you will see lines similar to the follow :-

define("LOGINAPI_VBULLETIN", 2);

Below the last define, copy the last line onto the next line and edit the line to the same text you did in step 6 (the LOGINAPI_VBULLETIN bit). Also, change the number to the number after it so it is unique.

12. Scroll down to where you see lines similar to the following :-

$_LOGINAPI[LOGINAPI_MODERNBILL] = array("title" => $_SWIFT["language"]["loginapi_modernbill"], "include" => "modernbill.login.php");

Copy the last line and paste it below it. Edit LOGINAPI_MODERNBILL, loginapi_modernbill (note the lower case on this one) and modernbill.login.php accordingly.

13. Open /locale/en-us/templates.php and look for :-

'loginapi_modernbill' => 'ModernBill',

and scroll to the bottom of that list. Copy the above code onto a new line at the bottom and edit the "modernbill" bit to what you set in step 12.

14. You should now be able to follow the following tutorial to configure the loginshare :-
http://www.craigbrasssystems.com/oth...hare/main.html

[marcan]

Thanks for this excellent tutorial ! I have created a plugin file to integrate loginshare with my CMS. Now what do I need to do ? What do I do with this file ?

Thanks for your help !

[craigbrass]

How stupid am I! Forgot about the next bit! Will update the tutorial now.

[craigbrass]

Updated.

[marcan]

Thanks for the update and the cool flash tutorial.

Now, I edited the file loginshare.config.php, and uploaded it to my server. Now, when I go in Admin CP Templates > Login Share, I see a new plugin with no title. I guess it's the one I created. I have the feeling there should be a title define somewhere for this plugin and currently it is not, which is why the plugin's title if blank.

I the loginshare.config.php, I added this line as you mentionned :

$_LOGINAPI[LOGINAPI_XOOPS] = array("title" => $_SWIFT["language"]["loginapi_xoops"], "include" => "xoops.login.php");

Could this be related to
$_SWIFT["language"]["loginapi_xoops"] ? Where is this defined ?

Thanks for your help !

[craigbrass]

Oh yes, also missed that bit. Will update the thread to add more steps.

[craigbrass]

Updated. See step 13.

[marcan]

Ok I did all of this.

Now I'm still facing a problem. Here it is :

When I login with a user present in my CMS (XOOPS), the plugin finds the user, validate that the username match the password, look for this user in its database, does not find it, tries to create it, and can't :

if ($_user["pass"] == $userpassword && !empty($_user["pass"]))

{

xoops_debug('111');

// We have a match, Seems like a valid user.. now see if he is registered..

$userid = getLoginShareUser(LOGINAPI_XOOPS, $_user["uid"]);

if (!$userid)

{

xoops_debug('222');

// Not registered, Register him

$userid = insertUser(true, $_user["email"], $regpassword, $_SWIFT["tgroup"]["regusergroupid"], LOGINAPI_XOOPS, $_user["uid"], $username, $_SWIFT["tgroup"]["languageid"], 0, false, 1, true);

In the last line paste, $userid always returns false. So I guess the user cannot be created in the SupportSuite. What am I doing wrong ?

Thanks !

[Randles]

I'd love to follow your tutorial but the file loginshare.config.php is encrypted

[Jamie Edwards]

Originally Posted by Randles

I'd love to follow your tutorial but the file loginshare.config.php is encrypted

Please e-mail me the name of the file you want and I will send it to you.

Thanks,

[Rodney B]

In step 4:

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.

Does this customers table name come from kayako or the third party app?

[Rodney B]

Originally Posted by Rodney B

In step 4:




Does this customers table name come from kayako or the third party app?

I've figured out that this is from the third party app

My shared login still isn't working (it connects to the database, but says username/password isn't correct).

My next question is, what would I need to change above if the password isn't using MD5 storage?

[craigbrass]

Well if it isn't MD5 storage then thats why it won't be working. What password algorithm is it using?

[Rodney B]

Originally Posted by craigbrass

Well if it isn't MD5 storage then thats why it won't be working. What password algorithm is it using?

I don't think it's using an algorithm at the moment. Is there a way to modify the viper.login.php example above to make it not use an algorithm?

[craigbrass]

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