View Single Post
02-06-2011, 05:47 AM   #25
freak99
Junior Member
 
Join Date: Feb 2011
Posts: 20
Rep Power: 0
freak99 is getting browny points
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.
freak99 is offline   Reply With Quote