mapping Vbulletin usergroup with Support access at Kayako

[kushaaal]

Hello,
I want to restrict access to a particlar usergroup of the VB to have access to Kayako support suite.

If that is possible, is it also possible to configure the permissions of secondary user group of vb to have access to Kayako Support suite?

Regards,

[craigbrass]

Not having vBulletin and not having used it for about 3 years, I will just guide you vauigly through this and hopefully you can work the rest out.

Using phpMyAdmin, go and get into the users table and find the field that gives the group id. Also find the group id you want to restrict to. Make a note of both of these.

Open /includes/LoginShare/vb.php with a text editor or similar. Find :-

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

and change to like

"SELECT * FROM `user` WHERE `group` = "2" AND `username` = '". $dbCore->escape($username) ."';"

where group is the field name of the group column and 2 is the group ID you want to allow access.

[kushaaal]

Thank You, however, it returns the blank white page. Is there something missing in the code?

[craigbrass]

Odd, making that change *shouldn't* develop a blank page. Are you sure you put the field name in correctly for the group?

[kushaaal]

PHP Code:

"SELECT * FROM `user` WHERE `usergroupid` = "13" AND `username` = '". $dbCore->escape($username) ."';" 


I tried with other field as membergroupid too with same blank page, am I missing the code?

[craigbrass]

It looks fine to me. If you could email me the LoginShare file and a database dump of your vBulletin installation, I'll take a look at it for you if you like. I'll PM you my email address.