I'm still having problems on this, but I'm close to a solution if I just had the right help.
PHP Code:
if ($foruminfo[forumid] == 31 && $vbulletin->userinfo['usergroupid'] != "5" && $vbulletin->userinfo['usergroupid'] != "6" && $vbulletin->userinfo['usergroupid'] != "7" && $vbulletin->userinfo['usergroupid'] != "11"){
$hook_query_fields .= ", posted.parentid AS parent_verify, posted.postid AS posted_verification";
$hook_query_joins .= " INNER JOIN " . TABLE_PREFIX . "post AS posted ON(posted.threadid = thread.threadid AND posted.userid = " . $vbulletin->userinfo['userid'] . ")";
/* ############*/
$hook_query_where .= " AND posted.postid != ''";
}
This is pulling the right information, but I have LEFT JOIN ed the post table, and now, the user is getting the thread listed 3 times if they have had 3 posts in the thread.... I just need to verify that they have at least 1 post....
Can someone help me with this? I know it's a simple fix with what I'm trying to accomplish....
01-13-2006, 10:03 PM
Hybrid Mode
