I have a big guild around 91 70s when I try to access the Equipment Viewer page if it loads it is just a blank page.

If there some way to get the page to load with no data?

Modify your conf.php file and set the "minLevel" to something higher than the default of 55. That will restrict the number of characters that the addon is trying to load.

With that many people, I'd suggest setting it to only load the level 70 characters.

For 1.8, I'm intending to add additional filtering/sorting options.

Thanks for the tips but that didn't help.

Hmm. Ok... Let's try this.

Open index.php

Look for

Code: Select all

   $query = 'SELECT name, level, member_id, class, clientLocale FROM `'.ROSTER_PLAYERSTABLE.'` WHERE level >= '.$addon_conf['equipview']['minLevel'].' '.$class_where.' GROUP BY name ORDER BY name ASC';


after

Code: Select all

ORDER BY name ASC

add

Code: Select all

 LIMIT 10

That will restrict it to the first 10 characters in the database. If that works, then we can further tweak the query...

I will try it out tonight.

Thanks

that got it, it is loading now....

Ok, good. It's pulling a lot of data from the database, so it's very possible that even limiting it to only your level 70's will still be too much.

Is there anything else we can use to help filter? Guild rank, maybe? We can probably also tweak it so that it chooses only a specific class, rather than trying to grab everyone.

Let me know what works for you and I'll hook you up with a modified SQL query that gets us there...

Cool thanks again.

How about modified the query so it pull up the Druids 1st.

FYI
I have been playing around with the number of ppl it can pull in before having problems & it looks like anything over 71 & at that point the CPU jumps to 100% & the MEM starts going up.

Piece of cake.

Find:

Code: Select all

require_once 'lib/item.php';

After, add:

Code: Select all

$class="Druid";

That will initialize the page by filtering to display only druids. You can also remove the "Limit 10" that we put in earlier, but be aware that selecting "All Classes" from the dropdown will still give you the same problem as before.

Hope that helps,

thanks

I just going to leave the Limit 20 in as a safeguard.