XF 1.1 Change all avatars to default

rbecking

Member
I've converted from vbulletin 3.8 to xenforo, users custom avatars have imported but they look rubbish as small on vb and been stretched. Is it possible to change all users to default avatar?
 
Run this query on your database:

Code:
UPDATE xf_user
SET avatar_date = 0, avatar_width = 0, avatar_height = 0;

Then delete the contents of the data/avatars directory on the server.
 
Top Bottom