Automatic avatar image selection

[petteyg359]

I need to retrieve remote images via an ID in a private field of a user's profile to use as avatars. I already have a working image retrieval script, but I cannot find a way to properly insert the image names into the database. When I manually set an avatar, I found the image to be named "1.gif" or similar on the filesystem, while the entry in the database referenced the real file name (1188020.jpg). I could NOT find any file named 1188020.jpg on the filesystem. Is there a way to force the database to reference the real filename? I have in admincp set it to store all images on the filesystem and not in database.

[petteyg359]

Anybody have any suggestions?

[petteyg359]

Still need an answer... I have a script that grabs remote images after querying a custom profile field. It saves the images to a folder. What UPDATE do I need to perform in MySQL to assign the avatar picture to a user?

[petteyg359]

Again. Is it possible to have a script set avatar images for users? I have a script to get the images already. I just need to know where to place them, and what vBulletin database field(s) to modify.

[Lynne]

II could NOT find any file named 1188020.jpg on the filesystem. Is there a way to force the database to reference the real filename? I have in admincp set it to store all images on the filesystem and not in database.
I believe if you have a file number 1188020.jpg owned by user 567, then you would find it in the directory attachments/5/6/7 and it would be called 1188020.attach . I don't know that that helps any with your problem.