View Single Post
02-06-2011, 06:30 PM   #26
Jeff
Administrator
 
Jeff's Avatar
 
Join Date: Jul 2010
Posts: 402
Rep Power: 10
Jeff is getting browny points
Quote:
Originally Posted by freak99 View Post
Jeff, I'd like to implement forum avatars in the comments. I think I have a general idea how to do this, however, any chance you tell me what code I would need (and where) to pull the avatarrevision from the user table by userid?

The mysql query would look something like this:

"SELECT avatarrevision FROM `user` WHERE `userid`= $userid";

Based on that, I think I could construct the avatar link based on an path of:

/forum/customavatars/avatar".$userid."_".$customavatar.".gif

Thanks for your work. I really appreciate what you've done with this mod.
Is not avatarrevision stored in $vb->userinfo ? i.e. $vb->userinfo['avatarrevision ']?
Jeff is offline   Reply With Quote