INSERT INTO `bans` (
`type`,
`value`,
`expires`,
`added`,
`admin_id`,
`comment`
) SELECT
3 AS `type`,
`accounts`.`id` AS `value`,
UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL 24 HOUR)) AS `expires`,
UNIX_TIMESTAMP(CURDATE()) AS `added`,
933 AS `admin_id`,
'Temporary ban on all accounts.' AS `comment`
FROM `accounts`;