I think I have located the issue but have no clue how to fix it. It has to do with the vB code on how it brings in custom avatars.
In the alldonors.php file, part of the code says the following:
Code:
$avatar_row = $vbulletin->db->query_first("SELECT user.showdonor, user.username, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar, customavatar.dateline AS avatardateline
FROM ".TABLE_PREFIX."user AS user
LEFT JOIN ".TABLE_PREFIX."avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN ".TABLE_PREFIX."customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE user.userid = '".$row['userid']."'");
What is bolded calls reference to the table '
customavatar' and the field '
filedata'
This particular field uses the type of MEDIUMBLOB with attributes - binary and NULL set to YES as default (don't know why but maybe someone with more experience can explain this one).
All of the avatars that are actually displayed on the ALL DONORS page, have a filedata field setting of '[BLOB - (file size of image) KB]'. All the ones that are NOT displayed, the filedata field has this setting: [BLOB - NULL].
Any thoughts to those that are more 'code savy' than I am?
Thanks for your time.