This is a great hack and I have installed it for a long time but the more members are using it in a big forum, your forum will be much more slower. After removed this from showthread and store avatar and sig image on web harddisk instead of on the database, my forum speed is much much faster.
So if you have a big forum and would like to use this or multi avatar feature then I would recommend not to store on database.
and the best part is i don't use any queries for both avatars and sig image. i even removed all avatars and sig image from big get post queries in showthread.
what i do is allow members to upload to a directory and set their userid as filename. if user uploaded avatar or sig image then i would change the field avatarid and signatureid to 1, then in function.php, i would add sigimage by check weather those field is one or not. if it's 1 then the avatar and sig will display.
i will add a multi avatars later
|