Do not display any with guild rank X

Theme, template, layout, or image issues

Do not display any with guild rank X

Postby daysee » Sun Sep 24, 2006 3:07 am

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??
Image
User avatar
daysee
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Mon Jul 10, 2006 12:23 am

Do not display any with guild rank X

Postby PleegWat » Sun Sep 24, 2006 3:33 pm

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)
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Do not display any with guild rank X

Postby daysee » Sun Sep 24, 2006 10:18 pm

:thumright: 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?
Last edited by daysee on Sun Sep 24, 2006 10:36 pm, edited 2 times in total.
Image
User avatar
daysee
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Mon Jul 10, 2006 12:23 am

Do not display any with guild rank X

Postby PleegWat » Mon Sep 25, 2006 2:30 am

Menu.php. 7 queries in total, if I remember correctly.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm


Return to Appearance

Who is online

Users browsing this forum: No registered users and 0 guests

cron