Zonet
Web Developer
Is there anyway to make it so if someone with access 4-6 it don't show up on list?
Yes, easy.
Query:
PHP:
$qa = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `player_storage`.`value` AS `value`, `players`.`id`, `players`.`name` AS `name` FROM `player_storage` LEFT JOIN `players` ON `player_storage`.`player_id` = `players`.`id` WHERE `player_storage`.`key` = '.$storage.' AND `players`.`group_id` < 4 ORDER BY ABS(value) DESC LIMIT '.$limit)->fetchAll();