usergroup permission based SQL query

[kh99]

Originally Posted by MyPornLife.info

no. VARCHAR.
why? shud i change it?

No. I don't know. Just thinking about how to do the query. Try this:

$query = "SELECT * FROM " . TABLE_PREFIX . "vbarticles as vbarticles 
                 LEFT JOIN " . TABLE_PREFIX . "vbcat as vbcat ON vbarticles.cid = vbcat.cid
                 WHERE FIND_IN_SET(" . $vbulletin->userinfo['usergroupid'] . ", vbcat.cpermission) <> 0";