PDA

View Full Version : SQL Query for Custom Avatars


SnapOff Racing
10-21-2009, 07:23 AM
When moving the Custom Avatars from the database to the filesystem I noticed that vb names the files as so avatar15_8.gif where 15=userid and 8=an incremented number. What I would like to know is where does vb store the information for that incremented number? Like let's say you goto move your avatars from the db to the fs and it fails so then let's say that one of your avatars are now named avatar15_1.gif but then you run it again and now your filename will be avatar15_2.gif since vb automatically increments this value. Well I would like to know where vb stores this value. I am assuming that it's stored in the database somewhere so as soon as I find it I could run an UPDATE query such as ALTER TABLE `tablename` AUTO_INCREMENT = 1 so that way when I run an export of my avatars they will come out looking like avatar15_1.gif, avatar16_1.gif etc.

Lynne
10-21-2009, 02:38 PM
If you look at the user table, you'll see a field called avatarrevision which is that second number in the avatar image name.

SnapOff Racing
10-21-2009, 03:55 PM
Lynne FTW as always! Thank you :up: