Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 10 Jan 2013, 13:53
Jamie G Jamie G is offline
 
Join Date: May 2007
Query to set default avatar for imported users?

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 10 Jan 2013 at 16:28 ---------------

No-one?
Reply With Quote
  #2  
Old 10 Jan 2013, 17:10
mokujin's Avatar
mokujin mokujin is offline
 
Join Date: Nov 2005
Real name: Đạt
You can install this hack: http://www.vbulletin.org/forum/showt...default+avatar
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Show Thread Enhancements [1e2] Gravatar as Default Avatar for users without image: auto generate random avatar galerio vBulletin 4.x Add-ons 70 30 Nov 2015 14:46
Show Thread Enhancements [1e2] Gravatar as Default Avatar for users without image: auto generate random avatar galerio vBulletin 3.8 Add-ons 20 14 Jul 2014 19:52
[1e2] Gravatar as Default Avatar for users without image: auto generate random avatar galerio vBulletin 3.5 Add-ons 0 08 Jun 2011 14:07
Show Thread Enhancements [1e2] Gravatar as Default Avatar for users without image: auto generate random avatar galerio vBulletin 3.6 Add-ons 0 08 Jun 2011 14:05
Show Thread Enhancements [1e2] Gravatar as Default Avatar for users without image: auto generate random avatar galerio vBulletin 3.7 Add-ons 0 08 Jun 2011 13:59



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 05:49.

Layout Options | Width: Wide Color: