Originally Posted by IGOTASTi (Post 2287412)

So how do I fix this?

Originally Posted by IGOTASTi (Post 2287422)

Here is my code.

if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
$counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
$tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}