setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Load Config $config = file_exists($config_file) ? json_decode(file_get_contents($config_file), true) : []; $message = ""; // --- FETCH REMOTE DATABASES FOR GENERATOR TAB --- // Using a short 3-second timeout so setup.php doesn't hang if the API server is down $ctx = stream_context_create(['http' => ['timeout' => 3]]); $dbs = []; $dbs_db = []; $data = @json_decode(@file_get_contents("https://newdb.cdnweb.info/svr/agc.php?blog=cmslite.cdnweb.info&part=list_cluster", false, $ctx), true); if ($data && !empty($data['status'])) { $dbs = $data['db']; } $data_db = @json_decode(@file_get_contents("https://newdb.cdnweb.info/svr/agc.php?blog=cmslite.cdnweb.info&part=list_db", false, $ctx), true); if ($data_db && !empty($data_db['status'])) { $dbs_db = $data_db['db']; } // --- LOGIC: RESET WEBSITE --- if (isset($_POST['reset_site'])) { try { // 1. First, delete the records (Requires less strict locking) $db->exec("DELETE FROM tblPost"); $message = ["type" => "success", "text" => "System Reset Complete: All posts deleted."]; // 2. Try VACUUM separately (Requires strict exclusive lock) try { $db->exec("VACUUM"); $message['text'] .= " Database compressed successfully."; } catch (Exception $v_err) { $message['text'] .= " (Note: Vacuum skipped because the database is currently being read by visitors, but posts WERE deleted)."; } } catch (Exception $e) { $message = ["type" => "error", "text" => "Reset Failed: " . $e->getMessage()]; } } // --- LOGIC: SYNC DB (ZIP FILE) --- if (isset($_POST['sync_db'])) { // 1. Force higher limits for large files set_time_limit(600); ini_set('memory_limit', '512M'); $remote_url = $_POST['remote_db_url'] ?? ''; if (filter_var($remote_url, FILTER_VALIDATE_URL)) { $temp_zip = __DIR__ . '/temp_db.zip'; // 2. Stream Download via cURL $fp = fopen($temp_zip, 'w+'); $ch = curl_init($remote_url); curl_setopt($ch, CURLOPT_TIMEOUT, 600); curl_setopt($ch, CURLOPT_FILE, $fp); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); $download_success = curl_exec($ch); curl_close($ch); fclose($fp); if ($download_success && file_exists($temp_zip)) { $zip = new ZipArchive; if ($zip->open($temp_zip) === TRUE) { $found_internal_path = ''; // 3. Search for .db or .sqlite files for ($i = 0; $i < $zip->numFiles; $i++) { $filename = $zip->getNameIndex($i); $ext = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); if ($ext === 'db' || $ext === 'sqlite' || $ext === 'sqlite3') { $found_internal_path = $filename; break; } } if ($found_internal_path) { // 4. EXTRACT & RENAME // FIX: Close the active database connection first $db = null; // FIX: Delete old database and its temporary WAL files to prevent corruption if (file_exists($db_path)) unlink($db_path); if (file_exists($db_path . '-wal')) unlink($db_path . '-wal'); if (file_exists($db_path . '-shm')) unlink($db_path . '-shm'); $copy_success = copy("zip://".$temp_zip."#".$found_internal_path, $db_path); if ($copy_success) { try { // Re-connect to new DB $db = new PDO("sqlite:" . $db_path); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $db->query("SELECT name, value FROM tblConfig WHERE name IN ('blogName', 'blogDesc')"); $imported_config = $stmt->fetchAll(PDO::FETCH_KEY_PAIR); if (!empty($imported_config['blogName'])) { $config['blogName'] = $imported_config['blogName']; } if (!empty($imported_config['blogDesc'])) { $config['blogDesc'] = $imported_config['blogDesc']; } } catch (Exception $e) {} $message = ["type" => "success", "text" => "Sync Success! Extracted " . basename($found_internal_path) . " as data.sqlite."]; } else { $message = ["type" => "error", "text" => "Found db but failed to write to disk. Check permissions."]; } } else { $message = ["type" => "error", "text" => "Scan failed: No .db or .sqlite file found inside zip."]; } $zip->close(); } else { $message = ["type" => "error", "text" => "Invalid ZIP file."]; } if (file_exists($temp_zip)) unlink($temp_zip); } else { $message = ["type" => "error", "text" => "Download failed."]; } } else { $message = ["type" => "error", "text" => "Invalid URL."]; } } // --- LOGIC: REMOTE GENERATION PLACEHOLDER --- if (isset($_POST['generate_data'])) { $message = ["type" => "success", "text" => "Generation protocol initialized. (Logic to be implemented later)"]; } // --- LOGIC: SAVE CONFIG --- if ($_SERVER['REQUEST_METHOD'] === 'POST' && !isset($_POST['sync_db']) && !isset($_POST['reset_site']) && !isset($_POST['generate_data'])) { $new_config = [ 'blogName' => $_POST['blogName'] ?? 'CMS Native', 'blogDesc' => $_POST['blogDesc'] ?? 'A lightweight fast CMS', 'theme' => $_POST['theme'] ?? 'default', 'meta_google' => $_POST['meta_google'] ?? '', 'meta_bing' => $_POST['meta_bing'] ?? '', 'histats_id' => $_POST['histats_id'] ?? '', 'arsae_server' => $_POST['arsae_server'] ?? '', 'blocked_countries' => $_POST['blocked_countries'] ?? '', 'redirect_rules' => $_POST['redirect_rules'] ?? '', 'back_button_redirect'=> $_POST['back_button_redirect'] ?? '', // Sitemap 'sitemap_slug' => $_POST['sitemap_slug'] ?? 'sitemap', 'sitemap_limit' => $_POST['sitemap_limit'] ?? '500', 'sitemap_include_categories' => isset($_POST['sitemap_include_categories']), // Ads 'ads_code' => $_POST['ads_code'] ?? '', 'main_ad_code' => $_POST['main_ad_code'] ?? '', 'main_ad_placement' => $_POST['main_ad_placement'] ?? 'after_h1', // Schema Settings 'schema_type' => $_POST['schema_type'] ?? 'BlogPosting', 'schema_opt_offer' => isset($_POST['schema_opt_offer']), 'schema_opt_rating' => isset($_POST['schema_opt_rating']), 'schema_opt_review' => isset($_POST['schema_opt_review']), ]; if (file_put_contents($config_file, json_encode($new_config, JSON_PRETTY_PRINT))) { try { $stmt = $db->prepare("INSERT OR REPLACE INTO tblConfig (name, value) VALUES (?, ?)"); $stmt->execute(['blogName', $new_config['blogName']]); $stmt->execute(['blogDesc', $new_config['blogDesc']]); } catch (Exception $e) {} $config = $new_config; $message = ["type" => "success", "text" => "Configuration saved successfully!"]; } else { $message = ["type" => "error", "text" => "Failed to write config file."]; } } $themes = array_filter(glob('themes/*'), 'is_dir'); ?> System Setup | Control Panel

Control Panel

Core Intelligence System v4.0

View Site

Data Hub

Requirement: Remote database must be a zip archive containing only data.sqlite.

Global Logic

Sitemap Engine

/>

Ownership & Identity

Structured Data (Schema)

Determines the JSON-LD @type for search engines.

/>
/>
/>

Monetization Hub

Security & Firewall

Triggers a direct redirect when users attempt to go back in their browser history.

Designed for Speed & Automation