Edit File - save-smtp.php

<?php
session_start();
require '../../inc/config.php';
header('Content-Type: application/json');

if (empty($_SESSION['AdminID'])) {
    echo json_encode(['status' => 'FALSE', 'message' => 'Not authorized']);
    exit;
}

$host = trim($_POST['host'] ?? '');
$port = trim($_POST['port'] ?? '');
$username = trim($_POST['username'] ?? '');
$password = trim($_POST['password'] ?? '');
$encryption = trim($_POST['encryption'] ?? '');
$from_email = trim($_POST['from_email'] ?? '');
$from_name = trim($_POST['from_name'] ?? '');

$errors = [];
if ($host === '') {
    $errors[] = 'SMTP host is required';
}
if (!filter_var($port, FILTER_VALIDATE_INT, ['options' => ['min_range' => 1, 'max_range' => 65535]])) {
    $errors[] = 'Port must be a number between 1 and 65535';
}
if ($username === '') {
    $errors[] = 'Username is required';
}
if ($password === '') {
    $errors[] = 'Password is required';
}
if (!in_array($encryption, ['none', 'tls', 'ssl'], true)) {
    $errors[] = 'Encryption must be none, tls, or ssl';
}
if (!filter_var($from_email, FILTER_VALIDATE_EMAIL)) {
    $errors[] = 'A valid From Email is required';
}
if ($from_name === '') {
    $errors[] = 'From Name is required';
}

if ($errors) {
    echo json_encode(['status' => 'FALSE', 'message' => implode(', ', $errors)]);
    exit;
}

$e_host = mysqli_real_escape_string($con, $host);
$e_username = mysqli_real_escape_string($con, $username);
$e_password = mysqli_real_escape_string($con, $password);
$e_encryption = mysqli_real_escape_string($con, $encryption);
$e_from_email = mysqli_real_escape_string($con, $from_email);
$e_from_name = mysqli_real_escape_string($con, $from_name);
$e_port = (int)$port;

$chkSql = "SELECT `id` FROM `smtp` WHERE `id` = 1 LIMIT 1";
$chkRes = mysqli_query($con, $chkSql);
if (!$chkRes) {
    echo json_encode(['status' => 'FALSE', 'message' => 'Database error: ' . mysqli_error($con)]);
    exit;
}

if (mysqli_num_rows($chkRes) > 0) {
    $sql = "UPDATE `smtp` SET `host` = '$e_host', `port` = $e_port, `username` = '$e_username',
    `password` = '$e_password',`encryption` = '$e_encryption', `from_email` = '$e_from_email',
    `from_name`  = '$e_from_name', `updated_at` = NOW() WHERE `id` = 1";
} else {
    $sql = "INSERT INTO `smtp` (`id`, `host`, `port`, `username`, `password`, `encryption`, `from_email`, `from_name`, `updated_at`)
    VALUES(1, '$e_host', $e_port, '$e_username', '$e_password', '$e_encryption', '$e_from_email', '$e_from_name', NOW())";
}

if (!mysqli_query($con, $sql)) {
    echo json_encode(['status' => 'FALSE', 'message' => 'Database error: ' . mysqli_error($con)]);
    exit;
}

echo json_encode(['status' => 'TRUE', 'message' => 'SMTP settings saved.']);
exit;
?>

Kembali