MyBB Codes
[Tip&Trick] Default Groups Avatar - Printable Version

+- MyBB Codes (http://www.mybbcodes.com)
+-- Forum: Babjusi's Previous Forum General Stuff (/forumdisplay.php?fid=42)
+--- Forum: General Support (/forumdisplay.php?fid=46)
+---- Forum: Tutorials (/forumdisplay.php?fid=50)
+---- Thread: [Tip&Trick] Default Groups Avatar (/showthread.php?tid=1132)


[Tip&Trick] Default Groups Avatar - babjusi - 12-07-2009 05:16 PM

I came up with this solution on a request made at this thread:

http://www.forumsecurity.eu/showthread.php?tid=82

Go to the phpmyadmin at the cp of your host and then at the db where your forum resides on. Make a backup copy of your mybb_users table and then run the following query at the SQL tab.

PHP Code:[Highlight]
UPDATE mybb_users SET avatar 'images/avatars/image.gif',  avatartype 'gallery'avatardimensions '100|100' WHERE usergroup '4'

This will set a default avatar for all the members in the admin group. To do it for other groups, you can add more of Set avatar..... Where usergroups.... statements separated by commas, or run the query individualy by replacing the usergroup = '4' with the other group id''s that you want to hook them with up a default avatar.


RE: [Tip&Trick] Default Groups Avatar - skiilz - 12-12-2009 10:12 AM

Thank you!
It worked!