$dbResult = $db->read('SELECT p.player_name, p.game_id, b.entry_id FROM player p JOIN message_blacklist b ON p.account_id = b.blacklisted_id AND b.game_id = p.game_id WHERE b.account_id=' . $db->escapeNumber($player->getAccountID()) . ' ORDER BY p.game_id, p.player_name');
30
31
$blacklist = [];
32
foreach ($dbResult->records() as $dbRecord) {
33
$blacklist[] = $dbRecord->getRow();
34
}
35
$template->assign('Blacklist', $blacklist);
36
37
if ($blacklist) {
38
$container = new MessageBlacklistDeleteProcessor();