exec('CREATE TABLE IF NOT EXISTS config(id INTEGER PRIMARY KEY NOT NULL, Title TEXT, url TEXT, CreateDate TIMESTAMP, linktype TEXT)');
$rowschk = $db->query('SELECT COUNT(*) as count FROM config');
$rowcount = $rowschk->fetchArray();
$numRowsicons = $rowcount['count'];
if ($numRowsicons == 0) {
$db->exec('INSERT INTO config(Title,url,CreateDate,linktype) VALUES(\'LOGO\',\'default\',\'' . time() . '\',\'0\')');
$db->exec('INSERT INTO config(Title,url,CreateDate,linktype) VALUES(\'BACK\',\'default\',\'' . time() . '\',\'0\')');
$db->exec('INSERT INTO config(Title,url,CreateDate,linktype) VALUES(\'VIDEO\',\'default\',\'' . time() . '\',\'0\')');
}
if (!file_exists('config')) {
mkdir('config', 511, true);
}
if (isset($_GET['delete'])) {
$db->exec('UPDATE config SET url=\'default\', CreateDate=\'' . time() . '\',' . "\n\t\t\t\t\t\t" . 'linktype=\'0\'' . "\n\t\t\t\t\t\t" . ' WHERE ' . "\n\t\t\t\t\t\t\t" . ' id=\'' . $_GET['delete'] . '\'');
$db->close();
$msg = '?messageE=Clean item file..';
header("Location: {$base_file}" . $msg);
exit();
}
if (isset($_GET['remove_Al1'])) {
//$db->exec('UPDATE icons SET image=\'default\',CreateDate=\'' . time() . '\',type=\'0\'');
$db->exec("DELETE FROM config");
$db->close();
$msg = '?messageE=All clean itens file..';
header("Location: {$base_file}" . $msg);
exit();
}
include 'includes/header.php';
echo '
' . "\n";
echo '
' . "\n";
echo '
' . "\n";
echo ' ' . "\n";
echo '
' . "\n";
echo ' Você realmente deseja excluir?' . "\n";
echo '
' . "\n";
echo ' ' . "\n";
echo '
' . "\n";
echo '
' . "\n";
echo '
' . "\n";
echo ' ';
echo '
' . "\n";
if (isset($_GET['succes'])) {
echo $msg_delete;
}
if (isset($_GET['success'])) {
echo $msg_success;
}
if (isset($_GET['message'])) {
echo '
'.$_GET['message'].'
';
}
if (isset($_GET['messageA'])) {
echo '
'.$_GET['messageA'].'
';
}
if (isset($_GET['messageE'])) {
echo '
'.$_GET['messageE'].'
';
}
if (isset($_GET['messageS'])) {
echo '
'.$_GET['messageS'].'
';
}
echo '
' . "\n";
echo "\n";
echo ' ' . "\n";
echo '
' . "\n";
echo "\n";
echo ' ' . "\n";
echo '
' . "\n";
echo ' ' . "\n";
echo '
' . "\n";
echo '
' . "\n";
echo ' LIMPAR TODOS' . "\n";
echo ' ' . "\n";
echo ' ' . "\t\t\t\t\t" . '
';
echo "\t\t\t\t\t\t" . '
';
echo "\t\t\t\t\t\t\t" . '
';
echo "\t\t\t\t\t\t\t" . '';
echo "\t\t\t" . '';
echo "\t\t\t" . '| Index | ';
echo ' Titulo | ' . "\n";
echo ' Prever | ' . "\n";
echo ' Link Url | ' . "\n";
echo ' Criado em | ' . "\n";
echo "\t\t\t\t" . 'Editar | ' . "\n";
echo "\t\t\t\t" . 'Deletar | ' . "\n";
echo "\t\t\t\t" . '
';
echo "\t\t\t\t" . '';
echo "\t\t\t\t" . '';
$db = new SQLite3('./api/.boxbr_config.db');
$res1 = $db->query('SELECT * FROM config');
while ($row = $res1->fetchArray()) {
$id = $row['id'];
$Title = $row['Title'];
$url = $row['url'];
if ($Title == 'LOGO' && $url !== 'default') {
$image = $url;
}elseif ($Title == 'BACK' && $url !== 'default') {
$image = $url;
}elseif ($Title == 'VIDEO' && $url !== 'default') {
$image = './img/VOD.png';
}elseif (empty($image)) {
$url = 'Sem item gravado';
$image = './img/noimg.jpg';
}
$CreateDate = date('D d-m-y H:i:s', $row['CreateDate']);
echo "\t\t\t\t\t" . ' ';
echo "\t\t\t\t\t" . ' | ' . $id . ' | ';
echo "\t\t\t\t" . '' . $Title . ' | ' . "\n";
if ($Title == 'VIDEO' && $url !== 'default') {
echo ' | ' . "\n";
}else{
echo "\t\t\t\t" . ' | ' . "\n";}
echo "\t\t\t\t" . 'Passe o mouse para ver | ' . "\n";
echo "\t\t\t\t" . '' . $CreateDate . ' | ' . "\n";
echo "\t\t\t\t" . ' | ' . "\n";
echo "\t\t\t" . ' ';
echo "\t\t\t\t\t" . ' | ';
echo "\t\t\t\t\t" . '
';
}
echo "\t\t\t\t\t\t\t" . '';
echo "\t\t\t\t\t\t\t" . '
';
echo "\t\t\t\t\t\t" . '
';
echo "\t\t\t\t\t" . '
';
echo "\t\t\t\t" . '
';
echo "\t\t\t\t\t" . '
';
$db->close();
include ('includes/footer.php');
require ('includes/boxbr.php');
print "