[RaTix]

I thought vB had added this in a newer patch and was about to update again when I saw your mod. Since I didn't feel like having to sort through what mods and customizations would be broken again because of it, I decided to give this a whirl. Unfortunately I ran into Db error when doing so.

I am Running VB 3.7.1 PL1. There seems to be no difference in the files specified except for your edits (File compare in Notepadd++), so I do not think my version of VB is the issue.

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbsocialgroup AS socialgroup
LEFT JOIN vbsocialgroupmember AS socialgroupmember ON
(socialgroupmember.userid = XXXX AND socialgroupmember.groupid = socialgroup.groupid)
WHERE vbsocialgroup.type != 'inviteonly';

MySQL Error : Unknown column 'vbsocialgroup.type' in 'where

I think the problem lies within this section of your mod.

//WESLEY MOD
case 'grouplist':
{
if (!can_moderate(0, 'caneditsocialgroups')) {
$socialgroupsearch->generator->where['type'] = TABLE_PREFIX . "socialgroup.type != 'inviteonly'";
}
}
break;
//WESLEY MOD

in the group.php.

Here's the thing, it works fine for admins, but any other user will get a DB error when trying to access the Social Groups page. To make sure there was nothing else I changed or another mod perhaps conflicting. I replaced the group.php with my original 3.7.1 pl1 group.php and it works as normal.

Was this ever officially added to any newer versions or patches of VB? If not, any help to get this much desired feature working will be appreciated.