[Abe1]

Originally Posted by Namaless

I have used this code:

PHP Code:

$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS ps INNER JOIN " .TABLE_PREFIX. "user AS u ON (u.userid = ps.userid) WHERE ps.postid IN (" . $post_ids . ") ORDER BY ps.username ASC"); 


For query.

For get musername use this method:

PHP Code:

//$cache[$thank['postid']][$thank['userid']]['username'] = $thank['username'];
            // Get vBulletin User Group ID
            $UserGroupID = ( $thank['displaygroupid'] == 0 ) ? 'usergroupid' : 'displaygroupid';
            $cache[$thank['postid']][$thank['userid']]['username'] = fetch_musername($thank, $UserGroupID); 


Without this have 21 queries and after my edit give same 21 queries.

Please check your performance..

Thanks

Done. Will be added in the next version.

One question though. Why did you do the fieldname check? The function does it for you.