Ok i would like remove the guilds bank toons from the Left Pane(Members Quick List) so they show up simlar to the Alts

Code: Select all

Members: ## (+## Alts) (+## Banks)

would changing this line

Code: Select all

    $result_menu = $wowdb->query("SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND ".$roster_conf['alt_location']." NOT LIKE '%".$roster_conf['alt_type']."%'") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
 

to some thing like

Code: Select all

    $result_menu = $wowdb->query("SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND ".$roster_conf['alt_location']." NOT LIKE '%".$roster_conf['alt_type']."%' AND ".$roster_conf['banker_fieldname']." NOT LIKE '%".$roster_conf['banker_rankname']."%'") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__); 

then adding another line

Code: Select all

    $result_menu = $wowdb->query("SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND ".$roster_conf['banker_fieldname']." LIKE '%".$roster_conf['banker_rankname']."%'") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_banks = $wowdb->num_rows($result_menu); 

then changing

Code: Select all

    print $wordings[$roster_conf['roster_lang']]['members'].': '.$num_non_alts.' (+'.$num_alts.' Alts)
      <br />
      <ul>
        <li style="color:#999999;">Average Level: '.round($result_avg[0]).'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 60-60: '.$num_lvl_60.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 50-59: '.$num_lvl_50_59.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 40-49: '.$num_lvl_40_49.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 30-39: '.$num_lvl_30_39.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 01-29: '.$num_lvl_1_29.'</li>
      </ul></td>';
 

to

Code: Select all

    print $wordings[$roster_conf['roster_lang']]['members'].': '.$num_non_alts.'<br />
          (+'.$num_alts.' Alts) (+'.$num_banks.' Banks)  
      <br />
      <ul>
        <li style="color:#999999;">Average Level: '.round($result_avg[0]).'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 60-60: '.$num_lvl_60.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 50-59: '.$num_lvl_50_59.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 40-49: '.$num_lvl_40_49.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 30-39: '.$num_lvl_30_39.'</li>
        <li>'.$wordings[$roster_conf['roster_lang']]['level'].' 01-29: '.$num_lvl_1_29.'</li>
      </ul></td>';
 

Will this work?

EDIT
---------

Ok for those that would like to do this i went ahead and tried it and it does work i know not many will want it but i always found it annoying that the banks showed up as real characters when they aren't so here's the code