Miscellaneous Hacks - Forum Home and Forumdisplay avatars (like XF)

yes, i know =)
exists similar mods, but they produce mount of SQL queries on forum home page and forumdisplay page
i'm tried to create one product, that has no additional queries and save server resources
debug from my test forum (vbkerk.com)
No hack
====
Homepage
Page Generation 0.02608 seconds Memory Usage 1,558KB Queries Executed 10
Forumdisplay (Has threads)
Page Generation 0.03031 seconds Memory Usage 1,878KB Queries Executed 14
Forumdisplay (No threads - Category)
Page Generation 0.02724 seconds Memory Usage 1,832KB Queries Executed 8

Hack installed
====
Homepage
Page Generation 0.02612 seconds Memory Usage 1,600KB Queries Executed 10
Forumdisplay (Has threads)
Page Generation 0.03360 seconds Memory Usage 1,912KB Queries Executed 14
Forumdisplay (No threads - Category)
Page Generation 0.02957 seconds Memory Usage 1,855KB Queries Executed 8

Important Note!
avatar files must be in the File System! Not in Data Base!
and users used custom avatars, not uploaded by admin

====
I will no support this product
I don't know, how forum will work with this mod and mods, that used hooks:
cache_ordered_forums
forumdisplay_query
becouse, if you use hook cache_ordered_forums, you can not add fields, unless unsetting one variable ($counter_select) before

my english is bad, блин =)
live DEMO

[TerryMason]

I figured out my own question if anyone wants to know.

In plugin manager - xfavatar - forumdisplay_query

replace the plugin php code with this, changing the forumids to the forums you don't want this plugin in.

if( $foruminfo[forumid]==32 || $foruminfo[forumid]==17 || $foruminfo[forumid]==18 || $foruminfo[forumid]==19 || $foruminfo[forumid]==20 || $foruminfo[forumid]==21 || $foruminfo[forumid]==22 || $foruminfo[forumid]==23 || $foruminfo[forumid]==24 || $foruminfo[forumid]==25 || $foruminfo[forumid]==26 || $foruminfo[forumid]==28 ) {

} else {
if(file_exists(DIR . '/krscripts/xfavatar/forumdisplay_query.php'))
{
     require_once(DIR . '/krscripts/xfavatar/forumdisplay_query.php');
}
}

[TitanJeff]

I'm very interested in adding this. Is the avatar size adjustable? I'd like to somehow find a way for the text to all be the right of the avatar as well.

[kotkerk]

Is the avatar size adjustable?

you can change avatar size in the template (see install instructions)

width="30" height="30"

change this values... pronto =)

[TitanJeff]

One more question and I fear it's impossible to do easily.

I would like to have all the widths and heights the same. But many of the avatars are of different proportions which means it is stretched or compressed. Is there any way to add code which crops the image?

[kotkerk]

TitanJeff,
you can remove height="" from template
but in this case avatars will shows ugly on forum =)
==
crop images code need to add to upload (img) vbulletin files
i.e. before showing avatar on the forum

[Kolektor]

you're doing good mods
I like this one also.

[ChiNa]

Not Working fully! In my LAST POST. vBulletin 3.8.6 upgraded to 3.8.7
Sorry I am not home and cant login from other places,

So am with my moderator,and thiss is how his username looks like: WizardBoy" />

You can see the EXTRA " /> at the end..

So I removed this 2 times code:

alt="$lastpostinfo[lastposter]" />

And the images are hanging in the middle, either it should be on left or right!
So I added 2 times:

align="left"

befor the 2 times:

class="inlineimg"

I have attached an image, might help you to update the product!

Thank you was nicely made!

[muhakeme]

it does not work in vBadvanced. Can you help?

[kotkerk]

does not work in vBadvanced

you need to modify vbadvanced php module-file, to get info about user avatar from DB

[muhakeme]

Here is the module. Can you help?