Custom avatar question / mysql question
 

I'm importing about 40,000 users from another board where they had avatars into 3.7.1. I've got the files in the right folder, but I can't figure out where the name and existence of the avatars are stored in mysql.

I've got a few avatars from new registrations, yet the avatar table is empty... and the avatarid field in the user table is empty.

What am I missing?

Thanks for your help.

You need to set the avatars stored as files if you want them as files and not in the db.

Thought i had done that but i guess not... anyway, that setting is changed. but the tables look the same. How does VB know which users have avatars and which file to grab?

Thanks!

Is it working right now?

Well, the avatars uploaded thru VB for new users are working fine.

But I've got a few thousand I need to import. It looks like the naming convention is:

avatar[userid]_1.gif

If I convert the old avatars to this naming convention and move them into the avatar directory... is that all I need to do?

If you use ImpEx to import from vB to vB, then the avatars should be impored automatically.