Code: Select all
INSERT INTO phpbb_config (`config_name`, `config_value`, `is_dynamic`) VALUES ('allow_ban_list', '2', '0');
Code: Select all
INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('allow_ban_list', '2', '0');
Code: Select all
SELECT ban_userid from phpbb_banlist WHERE ban_userid > -1;
Code: Select all
$sql = 'SELECT COUNT(ban_userid) AS total_banned
FROM ' . BANLIST_TABLE . '
WHERE ban_userid <> 0
AND (ban_end >= ' . time() . ' OR ban_end = 0)';