[TFEX]

PHP Code:

                $apboupc_get_allowedrecs = $vbulletin->db->query_read("SELECT userid, username, usergroupid FROM `" . TABLE_PREFIX . "user` AS user WHERE `usergroupid` IN (".$vbulletin->options['apboupc_pm_allowed'].")  OR FIND_IN_SET('X', membergroupids) "); 


What would I need to do to to the above code be able to include secondary usergroups in the allowed PM recipient usergroup ID field? As of now you can select primary groups who are allowed to receive PM's (ie site staff) before a user meets the post-count requirement, but the field is useless if you want to add a secondary group id to it.

I have tried:

PHP Code:

$apboupc_get_allowedrecs = $vbulletin->db->query_read("SELECT userid, username, usergroupid, membergroupids FROM `" . TABLE_PREFIX . "user` AS user WHERE `usergroupid` IN (".$vbulletin->options['apboupc_pm_allowed'].") OR WHERE `membergroupids` IN (".$vbulletin->options['apboupc_pm_allowed'].")
"); 


as well as:

PHP Code:

$apboupc_get_allowedrecs = $vbulletin->db->query_read("SELECT userid, username, usergroupid, membergroupids FROM `" . TABLE_PREFIX . "user` AS user WHERE `usergroupid` IN (".$vbulletin->options['apboupc_pm_allowed'].") OR FIND_IN_SET (".$vbulletin->options['apboupc_pm_allowed'].", membergroupids) > 0)
"); 


the error message varies slightly, but it's along the lines of this one:

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/private.php(1174) : eval()'d code on line 40

Anyone able to tackle this? I really need to get secondary ID's added to the allowed recipients field...


EDIT: Found something that works for the time being:

PHP Code:

                $apboupc_get_allowedrecs = $vbulletin->db->query_read("SELECT userid, username, usergroupid FROM `" . TABLE_PREFIX . "user` AS user WHERE `usergroupid` IN (".$vbulletin->options['apboupc_pm_allowed'].") OR FIND_IN_SET('X', membergroupids) "); 


X being the ID of your secondary usergroup. If one was to simply keep continuing to add "OR FIND_IN_SET..." in the above code, they can include as many secondaries as they like. Not the prettiest fix, but still a fix.