latest photopost picture as avatar per usergroup

[sabret00the]

i saw a thread where someone was requesting to have it in the postbit, however i'd like it as an avatar with an additional option in the usercp to give the user the option of using their selected normal avatar or the photopost picture. but to make this even more complex i'd like that usergroup to use the photopost picture by default thus they'd have to turn it off.

anyway is this possible withuot racking up queries?

[sabret00the]

ok i had an idea on how to make this work, without the query load, it was gonna make a function to pull the information all at once. however i think i've done that, but i'm not really sure how to do the rest of this, if anyone has any ideas on how to do this, then please post. my minds just gone blank so i have no idea quite what i'm doing.

basically to pull the image it's literally

<img src="$vboption[galleryurl]/data/$ppost_catid/$userid$ppost_bigimagename-thumb.jpg" />