CREATE OR REPLACE VIEW v_banlist AS SELECT
id, IF(type = 0 OR type = 1 OR type = 6 OR type = 7 OR type = 9, IF(temptime = 0 OR UNIX_TIMESTAMP() <= temptime, 1, 0), 0) active,
CASE type
WHEN 0 THEN 'Ban'
WHEN 1 THEN 'IP ban'
WHEN 2 THEN 'Varování'
WHEN 3 THEN 'Vyhození'
WHEN 4 THEN 'Pokuta'
WHEN 5 THEN 'Unban'
WHEN 6 THEN 'Vězení'
WHEN 7 THEN 'Umlčení'
WHEN 8 THEN 'Vězení'
WHEN 9 THEN 'Trvalý ban'
ELSE 'Neznámý'
END type, name, reason, admin,
time, DATE_FORMAT(FROM_UNIXTIME(time), '%d. %m. %Y %H:%i:%s') timeString,
temptime, IF(temptime = 0, 'Nikdy', DATE_FORMAT(FROM_UNIXTIME(temptime), '%d. %m. %Y %H:%i:%s')) temptimeString,
IF(type = 0 OR type = 1 OR type = 6 OR type = 7 OR type = 9, IF(temptime = 0, NULL, temptime - time), NULL) length,
IF(type = 0 OR type = 1 OR type = 6 OR type = 7 OR type = 9, IF(temptime = 0, NULL, IF(UNIX_TIMESTAMP() <= temptime, temptime - UNIX_TIMESTAMP(), NULL)), NULL) remain
FROM banlist;