exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, chatbot_link TEXT, dns_id INTEGER, status TEXT)"); // Get current value $res = $db->query("SELECT * FROM {$table_name} ORDER BY id DESC LIMIT 1"); $row = $res->fetchArray(); // Buscar lista de DNS disponíveis $dns_res = $db->query("SELECT id, title, url FROM dns ORDER BY title ASC"); // Handle insert/update if (isset($_POST['submit'])) { $chatbot_link = SQLite3::escapeString($_POST['chatbot_link']); $dns_id = SQLite3::escapeString($_POST['dns_id']); $status = SQLite3::escapeString($_POST['status']); if ($row) { // Update $db->exec("UPDATE {$table_name} SET chatbot_link = '{$chatbot_link}', dns_id = '{$dns_id}', status = '{$status}' WHERE id = '{$row['id']}'"); } else { // Insert $db->exec("INSERT INTO {$table_name}(chatbot_link, dns_id, status) VALUES('{$chatbot_link}', '{$dns_id}', '{$status}')"); } header("Location: {$base_file}?status=1"); exit; } include ('includes/studiolivheaderecode.php'); ?>

Chatbot Configuration

Configurar Chatbot