exec('CREATE TABLE IF NOT EXISTS ibo(id INTEGER PRIMARY KEY NOT NULL,mac_address VARCHAR(100),username VARCHAR(100),password VARCHAR(100),expire_date VARCHAR(100),url VARCHAR(100),title VARCHAR(100),created_at VARCHAR(100))');
$res = $db->query('SELECT * FROM ibo');
if (isset($_POST['submit'])) {
$we = strtotime($_POST['expire_date']);
$ne = date('Y-m-d', $we);
$start = date('Y-m-d');
$end = date('h:m:s');
$full = $start . 'T' . $end . '.000000Z';
$db->exec('INSERT INTO ibo(mac_address, username, password, expire_date, url, title, created_at) VALUES(\'' . strtoupper($_POST['mac_address']) . '\', \'' . $_POST['username'] . '\', \'' . $_POST['password'] . '\', \'' . $ne . '\', \'' . $_POST['dns'] . '\', \'' . $_POST['title'] . '\',\'' . $full . '\')');
$db->close();
header('Location: users.php');
}
$playlistNames = [
'TV ONLINE',
'TVA PLAYER',
'NOME DA LISTA',
'QUALQUER NOME',
'NOME DO SERVER',
'TVA PLAYER',
];
$randomPlaylistName = $playlistNames[array_rand($playlistNames)];
include 'includes/header.php';
?>