~line 86
add the words members.level and AND members.level ='60'";
so the line reads
- Code: Select all
$query = "SELECT members.member_id, members.name, members.class, members.level, players.clientLocale, " .
"players.server, players.max_res_all, players.max_res_fire, players.max_res_nat, players.max_res_arc, players.max_res_fro, players.max_res_shad".
" FROM `".ROSTER_MEMBERSTABLE."` members LEFT JOIN `".ROSTER_PLAYERSTABLE."` players ON members.member_id = players.member_id AND members.guild_id = $guildId AND members.level ='60'";




