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

[kotkerk]

for example, this file does not exists in directory customavatars
_http://www.foroartesmarciales.com/customavatars/avatar18354_2.gif
"Page not found"
==
check it on your server =)

[Artes_Marciales]

Originally Posted by kotkerk

for example, this file does not exists in directory customavatars
_http://www.foroartesmarciales.com/customavatars/avatar18354_2.gif
"Page not found"
==
check it on your server =)

sure, the user never had an avatar.
The mod should not seek that route (avatar_userID_2), the mod should look images/misc/unknown.gif
Example: http://www.foroartesmarciales.com/se...hp?do=getdaily

the error is random, sometimes it is about other users other (always without avatar).
That happens in every forum I installed the hack (4 forums).
Thanks for check!

[Artes_Marciales]

Another example of error in the image

These errors happen only in new messages.

Best Regards!! : )

[kotkerk]

yep... =)
i confirm, it's bug...
but give me some time, i'll fix this...

[Artes_Marciales]

Thanks!!! : D

[kotkerk]

Artes_Marciales,
download attachment from first post
reupload file search_results_query_threads.php from archive to your server
code of sql query in one file (search_results_query_threads.php) rewrited
i think this update will fix the problem =)
on my local test forum i was not detect this problem

[Artes_Marciales]

Now works fine! : D
Great Mod!
THANKS!!!!

[Alfa1]

Please add an option to place the avatar in the position where the thread icons are now. This is how XenForo does it.
Please add the option / setting to not display the avatar of the last poster. XenForo does not display it either and I think that is best.

* tagged for future use.

[kotkerk]

Alfa1, this is a simple mod, writen out of hours =)
if u want to not display last poster avatar, just remove the code from template
it's simple like bolacha "Maria"
in case to place avatar in the position of thread icons, move the code

[TerryMason]

Thanks, this works great!

I did have one problem though. I use another mod named Geek Article Review (gar), and it causes errors with this mod. Specifically:

MySQL Error : Unknown column 'ga.synopsis' in 'field list'

Is the an easy way to keep this mod from running on forums where that plugin is active? Something like

if($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true) OR is forum 4,5,6 )
{
      // do nothing
}else{