[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

Not bad performance on that page. Just about .1 sec. longer to load. from .5 to .6 average to load.

Will look into now.