exec($query)) {
} else {
echo "Error creating table: " . $db->lastErrorMsg() . "
";
}
$query = "SELECT COUNT(*) FROM adsstatus";
$result = $db->querySingle($query);
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$ad_item = $_POST["ad_item"];
if (empty($ad_item)) {
die("Please select an ad item.");
}
if ($result === 0) {
$updateQuery = "INSERT INTO adsstatus (adstype) VALUES (:ad_item)";
} else {
$updateQuery = "UPDATE adsstatus SET adstype = :ad_item WHERE id = 1";
}
$stmt = $db->prepare($updateQuery);
$stmt->bindValue(':ad_item', $ad_item, SQLITE3_TEXT);
if ($stmt->execute()) {
echo "Modo '$ad_item' foi atualizado com sucesso ✅
";
// Move o arquivo allads.php conforme a seleção
if ($ad_item === "Manualads") {
$source = "./Manualads/allads.php";
$destination = "./api/allads.php";
if (file_exists($source)) {
copy($source, $destination);
} else {
echo "Error: File 'allads.php' not found in 'Manualads' folder.
";
}
} elseif ($ad_item === "Autoads") {
$source = "./Autoads/allads.php";
$destination = "./api/allads.php";
if (file_exists($source)) {
copy($source, $destination);
} else {
echo "Error: File 'allads.php' not found in 'Autoads' folder.
";
}
}
} else {
echo "Error updating record: " . $db->lastErrorMsg();
}
}
?>
close();
?>