Custom avatar question / mysql question

[islandcommuter]

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.

[Boofo]

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

[islandcommuter]

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!

[Boofo]

Is it working right now?

[islandcommuter]

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?

[Marco van Herwaarden]

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