30 lines
992 B
PHP
30 lines
992 B
PHP
<?php
|
|
require_once __DIR__ . '/db/config.php';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
$botToken = $_POST['bot_token'] ?? '';
|
|
$prefix = $_POST['prefix'] ?? '/';
|
|
|
|
$db = db();
|
|
|
|
// UPSERT pattern for MySQL/MariaDB
|
|
$sql = "INSERT INTO bot_settings (setting_key, setting_value)
|
|
VALUES (:key1, :val1), (:key2, :val2)
|
|
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value)";
|
|
|
|
try {
|
|
$stmt = $db->prepare("INSERT INTO bot_settings (setting_key, setting_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE setting_value = ?");
|
|
|
|
$db->beginTransaction();
|
|
$stmt->execute(['bot_token', $botToken, $botToken]);
|
|
$stmt->execute(['prefix', $prefix, $prefix]);
|
|
$db->commit();
|
|
|
|
header('Location: index.php?saved=1#config');
|
|
exit;
|
|
} catch (Exception $e) {
|
|
if ($db->inTransaction()) $db->rollBack();
|
|
die("Error saving settings: " . $e->getMessage());
|
|
}
|
|
}
|