Is it possible to set the program to not display or count any guild members with a certain guild rank?

We have lots of people that take time off, we move them to retired. I'd like to leave them in guild IN GAME, but remove their character from displaying or accumulating into total count in wowroster....possible??

Not currently, but it shoudl be easy to mod in for the front page.

memberslist.php, line 205-207:

Code: Select all

// All those people asking about guild searching, here's a spot!  and here's the simple alteration to stop guild filtering in this particular place
    "LEFT JOIN `".ROSTER_PLAYERSTABLE."` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '$guildId' ".
    "ORDER BY ";
 

Insert a WHERE condition:

Code: Select all

// All those people asking about guild searching, here's a spot!  and here's the simple alteration to stop guild filtering in this particular place
    "LEFT JOIN `".ROSTER_PLAYERSTABLE."` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '$guildId' ".
    "WHERE `guild_rank` = 8,
    "ORDER BY ";


There 8 is the number of the rank (GM is 0, lower ranks count up)

Thank you

Final query that worked :

Code: Select all

   "LEFT JOIN `".ROSTER_PLAYERSTABLE."` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '$guildId' ".
   "WHERE `members`.`guild_rank` <> '4'".
   "ORDER BY ";

This worked in disabling the display of these mebers, but I wuld also like to affect the guild member tally that shows on the menu.

Can you direct me to what pages need to be changed to make this effective there as well?

Menu.php. 7 queries in total, if I remember correctly.