Problem loading

Display a macro-level overview of your guild members' equipped gear

Moderator: Samadhi

Problem loading

Postby blackice » Sun Jun 17, 2007 8:50 pm

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?
User avatar
blackice
WR.net Apprentice
WR.net Apprentice
 
Posts: 34
Joined: Tue Jul 25, 2006 4:15 pm

Problem loading

Postby Samadhi » Mon Jun 18, 2007 10:38 pm

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.
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Problem loading

Postby blackice » Tue Jun 19, 2007 6:54 pm

Thanks for the tips but that didn't help.
User avatar
blackice
WR.net Apprentice
WR.net Apprentice
 
Posts: 34
Joined: Tue Jul 25, 2006 4:15 pm

Problem loading

Postby Samadhi » Tue Jun 19, 2007 9:29 pm

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...
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Problem loading

Postby blackice » Tue Jun 19, 2007 10:39 pm

I will try it out tonight.

Thanks
User avatar
blackice
WR.net Apprentice
WR.net Apprentice
 
Posts: 34
Joined: Tue Jul 25, 2006 4:15 pm

Problem loading

Postby blackice » Wed Jun 20, 2007 5:08 am

that got it, it is loading now....
User avatar
blackice
WR.net Apprentice
WR.net Apprentice
 
Posts: 34
Joined: Tue Jul 25, 2006 4:15 pm

Problem loading

Postby Samadhi » Wed Jun 20, 2007 6:10 am

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...
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Problem loading

Postby blackice » Wed Jun 20, 2007 6:36 pm

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.
User avatar
blackice
WR.net Apprentice
WR.net Apprentice
 
Posts: 34
Joined: Tue Jul 25, 2006 4:15 pm

Problem loading

Postby Samadhi » Wed Jun 20, 2007 11:56 pm

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,
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Problem loading

Postby blackice » Thu Jun 21, 2007 1:20 am

thanks

I just going to leave the Limit 20 in as a safeguard.
User avatar
blackice
WR.net Apprentice
WR.net Apprentice
 
Posts: 34
Joined: Tue Jul 25, 2006 4:15 pm


Return to Equipment Viewer

Who is online

Users browsing this forum: No registered users and 1 guest

cron