\n\t\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t \n\t\t\t\t \n \n \n"; $db = new SQLite3("./api/.ansdb.db"); // $res = $db->query("SELECT * FROM ibo WHERE id_user = " . $_SESSION['id'] . " AND (active = 0 OR expire_date < date('today'))"); $res = $db->query("SELECT * FROM ibo"); while ($row = $res->fetchArray()) { $playlist_password = $row['playlistpassword']; $iid = $row["id"]; $imac = $row["mac_address"]; $ikey = $row["key"]; $iexpire_date = $row["expire_date"]; if ($idns = $row["dns"] == NULL) { $iusername = "listm3u-id" . $row["id"]; $idns = $row["url"]; } else { $iusername = $row["username"]; $idns = $row["dns"]; } $iepg = $row["epg_url"]; $ititle = $row["title"]; $today = date('Y-m-d'); $active = $row['active'] && $iexpire_date >= $today; $expired = $active ? "No" : "Yes"; if ($playlist_password) { $idns = "****"; $iepg = "****"; $ititle = "****"; } echo " \n"; echo " " . "\n"; echo " " . "\n"; // echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; // echo " " . "\n"; // echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; // echo " " . "\n"; echo " " . "\n"; echo "\t\t\t\t\n\t\t\t\n"; } echo "\t\t\t

ID	Device ID	Username	Expire Date	Title	Expired	Delete
" . $iid . "	" . $imac . "	" . $ikey . "	" . $iusername . "	" . $iexpire_date . "	" . $idns . "	" . $iepg . "	" . $ititle . "	" . $expired . "

\n\t\t