Query to set default avatar for imported users?

[Jamie G]

Hi there,

We've just imported 3, large IPB forum Databases into vBulletin following a hack on IPB which took out 3 of our sites. It was the last straw for us, but we now have an issue.

After importing the IPB users, it didn't copy across the User's avatars. We've rebuilt the avatars, but they aren't showing.

Is there a query we can run, to set all the users to have an avatar. Right now, it is showing as completely blank, and with over 10,000 users, it's going to take some time to do it manually.

For instance, on IPB we could run the following.

update profile_portal set
`pp_main_photo` = 'profile/default.png',
`pp_main_width` = 170,
`pp_main_height` = 121,
`pp_thumb_photo` = 'profile/default.png',
`pp_thumb_width`= 100,
`pp_thumb_height`= 100;

Is there an equivalent for vBulletin that we can use?

Many thanks,

--------------- Added [DATE]1357838892[/DATE] at [TIME]1357838892[/TIME] ---------------

No-one?

[mokujin]

You can install this hack: https://vborg.vbsupport.ru/showthrea...default+avatar