LoginShare with vBulletin DB Prefix

[magna]

I am not sure if this was already asked and answered or even addressed? I am trying to get LoginShare to work with my vBulletin which is running 3.5 and I have assigned vB with a table prefix and your scripts seems to be calling on feild user. The questions is how can I modify it so it will read the prefix I can edit that one file but unsure how many times I need to add the prefix to?

Possible a future suggestions is that you write the table prefix variable in the script so when you set up LoginShare it will ask for a prefix and if left blank it would be blank?

Also while we are on the discussion of vBulletin has anyone look into intergrating this great Support System into it using there plugin system or atleast be able to use the same theme and login so do not have to retype the username and password? I am willing to help out on this if you would like to seek it further.

[magna]

Any ideas on how to getting this work with vB Table Prefixs?

[Dark_Wizard]

Here is a quick fix for you until this is done properly...open in notepad \includes\LoginShare\vb.login.php and do the following:

Find this at line 17:

PHP Code:

if (!defined("INSWIFT")) { 


add this before it (edit it to reflect your table prefix):

PHP Code:

define('TABLE_PREFIX', 'vb_'); 


THen change this line:

PHP Code:

$_user = $dbLoginShare->queryFetch("SELECT * FROM `user` WHERE `username` = '". $dbCore->escape($username) ."';"); 


to this:

PHP Code:

$_user = $dbLoginShare->queryFetch("SELECT * FROM " . TABLE_PREFIX . "user AS user WHERE `username` = '". $dbCore->escape($username) ."';"); 


[Dark_Wizard]

Varun,

If you need any assistance with vBulletin integration please let me know...

[Varun Shoor]

Hi,
The above fix should work fine, I will see if I can get the prefix added as an option under LoginShare page itself.

Regards,

Varun Shoor

[Varun Shoor]

UPDATE: The above code is actually incorrect, TABLE_PREFIX is reserved by SWIFT, You should define something like VB_TABLE_PREFIX and use that.

Regards,

Varun Shoor

[magna]

Okay thanks this is finally working although I with my username can not login as I am the SuperAdmin as well as the other admins couldn't login but I added them to the members usergroup and they are able to look into.

But this shouldn't be a usergroup limitation or atleast it seems to be because not all my admins have full access to other areas so they file tickets to others. It is resolved that is all I was concerned about other suggestions is to be able to register for the forum from the SupportSuite and to go from the forum login to supportsuite already login create a total smooth transition and seemly into one site. That is just a suggestion.

Thanks for all your help and I am not sure what everyone else is talking about the SupportSuite does more then I need and works for all my need currently - by the time you go gold I may use all the other features.

[magna]

Disregruad the request for the registering for that can proabbly be done in the template by setting up a link to the register page but it would be good if you can move between the two systems without logining in again.

[Dark_Wizard]

Originally Posted by magna

Disregruad the request for the registering for that can proabbly be done in the template by setting up a link to the register page but it would be good if you can move between the two systems without logining in again.

What version of vBulletin are you using?

[Dark_Wizard]

Originally Posted by Varun [K]

UPDATE: The above code is actually incorrect, TABLE_PREFIX is reserved by SWIFT, You should define something like VB_TABLE_PREFIX and use that.

Regards,

Varun Shoor

Glad you posted that as vBulletin uses it as well and I'm used to it since I do alot of custom coding for it....

[magna]

I am using vBulletin 3.5.4 - the only person that can't login is me the superadmin so it is fine but just letting you know incase it not fine with someone else. I do not need to login with my username because I have a admin user to check the tickets. But it would be cool if we could use our support username and login directly to the support center from the main window like everyone else.

[jwhysleep]

having this same problem but why is the vb.login.php encrypted!

[jwhysleep]

Originally Posted by Varun [K]

UPDATE: The above code is actually incorrect, TABLE_PREFIX is reserved by SWIFT, You should define something like VB_TABLE_PREFIX and use that.

Regards,

Varun Shoor

how to edit this swift file to change db prefixes