@ukcobra
https://vborg.vbsupport.ru/showthread.php?t=82621

@adwade
thanks a lot

i sure will be updating this plugin + optimizing quries

Thanks for the pointer, installed, modified and working in under 5 minutes. This is a great help.

My checkbox values are showing up as number in my postbit. Do you know how to solve this? Here is a link to someone in another post who's having a similar problem. Granted, his is showing pics for another mod, but it's the same outcome for me with your mod. Thanks.

There's a post here about that:

http://www.vbulletin.com/forum/showthread.php?t=97400

I cant locate it in my admin cp.. where is it?

This plugin adds a lot of queries. If I add the profile fields to the postbit manually, no queries are added, because all of the fields are already joined on each post. However, if I use this plugin, a thread with 13 posts goes from 10 queries to 140! That's quite a lot of extra load for the database for bringing up a single page with 4 extra profile fields.

Looking at the code, it looks like the problem is that you are doing a separate query for each profile field and for each post, thus the extra queries needed become exponential for the number of posts per page and the number of profile fields. Since the fields are already loaded and available, you might see if you can use them instead of querying for them separately.

Hope that helps.

Thank you for the link, but I didn't see any clearcut solution. If anyone can help with this some more, i'd appreciate it. Thanks.

Here's some more info:

http://www.vbulletin.com/forum/showthread.php?t=108785

This is exactly what I have been looking for, only new to vb and I cant get it installed. Any tips ?

Cheers

Edit:
Sorted it, excellent stuff, thanks !!!

Its running on http://www.eastcoastutes.com

Hello emin3m,

Again it's nice hack, But!

When will you fix the lot of queries issue?