Mini Mods - Default Avatar

This plugin will make a default avatar show for all users if the user does not have an avatar. This works in the postbit, profiles, and members list. It uses the image "images/misc/unknown.gif" by default, which is used in several locations for the same purpose, and works on vB 3.7+ and vB4. This is editable in the Admin CP under vBulletin Options -> User Picture Options -> Default Avatar Image Location.

Updates:

• 1.0 - 3.5 release by Zachery - unsupported.
• 2.0 - Initial 3.7+ release.
  • 2.0.1 - Slight bugfix relating to users disabling avatar display. This setting does not affect avatars on the profile or memebers list by default, so this addon should not take it into account for those pages.
  • 2.0.2 - Added a setting to control the location of the image. See the updated description for details.

This works for vBulletin 4.0 as well as 3.7+. vB4 thread located here.

[yamahapaul]

Originally Posted by imported_silkroad

This would be a much more useful mod if we could specify default avatars for various user groups. One default avatar for the entire site is not very useful, IMHO.

I prefer this myself, as it encourages users to be individual, unique and to personalise their avatar..... just an opinion..

[LB1981]

Thanks for this mod

[Palace55]

Thanks for this modification, it has been installed on my forums!

[netcommander]

Hello
i've used this hack and i've uninstall via admincp and i've upgrade 4.0 and i see this error

Database error in vBulletin 4.0.0 Beta 5:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,blog_user.entries
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 19 AND postparsed.languageid = 11)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 19 AND sigparsed.languageid = 11)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = post.userid)
WHERE post.postid IN ()
ORDER BY post.dateline;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY post.dateline' at line 29
Error Number : 1064
Request Date : Sunday, December 6th 2009 @ 09:40:16 PM
Error Date : Sunday, December 6th 2009 @ 09:40:16 PM
Script : http://www.xxxxx.com/forum/showthrea...-yardym-fx5500
Referrer :
IP Address : 66.249.xx.xx
Username :Guest
Classname : vB_Database
MySQL Version :

how can I fix this problem

[Link14716]

Originally Posted by netcommander

Hello
i've used this hack and i've uninstall via admincp and i've upgrade 4.0 and i see this error

how can I fix this problem

This hack could not cause that error. I haven't seen that error before.

If you uninstalled it, it certainly isn't running anymore, and it makes no database changes. Furthermore, even if you kept it installed, it works just the same on vB4 as it does on vB3.

I don't know the cause of your error or how to resolve it, only that it isn't caused by this mod.

[Zachery]

Taht error message is from a thread that has no data. You've run impex.

[netcommander]

hmm how can fix this error Zachery ?
what can I do with impex ?
Thanks for all answer

[SİMAR]

thanks man

[carolc]

This works very nicely, thanks.

Is it possible for you to get this to work with the PhotoPost Gallery? If not, can you PM me an example of the conditional statements you used and I can see if I can figure out something similar to add to my gallery?

Thanks

[xDazedx]

Thanks for the great Mod