1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / manager /
Filename : edit-trading-bot.php
back
<?php
session_start();
include('../../config/oxconfig.php');
include('includes/checklogin.php');
include('includes/mail-settings.php');
check_login();
$title = "Edit Trading Bot";
include 'includes/header.php';
include 'includes/sidebar.php';

// Enable error reporting for debugging
ini_set('display_errors', 1);
error_reporting(E_ALL);

$currentTime = date('Y-m-d H:i:s');
$msg = $type = '';

// Validate bot ID
$bot_id = isset($_GET['bot_id']) ? filter_var($_GET['bot_id'], FILTER_VALIDATE_INT) : 0;
if (!$bot_id) {
    echo "<script>window.location.href='trading-bots.php';</script>";
    exit;
}

// Fetch bot details
$stmt = $con->prepare("SELECT bot_name, image, description, price, duration, platform FROM trading_bots WHERE id = ?");
$stmt->bind_param('i', $bot_id);
$stmt->execute();
$result = $stmt->get_result();
$bot = $result->fetch_assoc();
$stmt->close();

if (!$bot) {
    echo "<script>window.location.href='trading-bots.php';</script>";
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $bot_name = isset($_POST['bot_name']) ? mysqli_real_escape_string($con, trim($_POST['bot_name'])) : '';
    $description = isset($_POST['description']) ? mysqli_real_escape_string($con, trim($_POST['description'])) : '';
    $price = isset($_POST['price']) ? filter_var($_POST['price'], FILTER_VALIDATE_FLOAT) : 0;
    $duration = isset($_POST['duration']) ? filter_var($_POST['duration'], FILTER_VALIDATE_INT) : 0;
    $platform = isset($_POST['platform']) ? mysqli_real_escape_string($con, trim($_POST['platform'])) : '';
    $image = $_FILES['image'] ?? null;

    // Validate inputs
    $errors = [];
    if (empty($bot_name) || strlen($bot_name) > 100) {
        $errors[] = "Bot name is required and must be 100 characters or less.";
    }
    if (empty($description) || strlen($description) > 1000) {
        $errors[] = "Description is required and must be 1000 characters or less.";
    }
    if ($price <= 0) {
        $errors[] = "Price must be a positive number.";
    }
    if ($duration <= 0) {
        $errors[] = "Duration must be a positive number.";
    }
    if (empty($platform) || !in_array($platform, ['Binance', 'Coinbase', 'Kraken', 'MT5'])) {
        $errors[] = "Valid platform is required.";
    }

    // Validate image (optional)
    $image_path = $bot['image'];
    if ($image && $image['error'] === UPLOAD_ERR_OK) {
        $allowed_types = ['image/jpeg', 'image/jpg', 'image/png'];
        $max_size = 5 * 1024 * 1024; // 5MB
        if (!in_array($image['type'], $allowed_types)) {
            $errors[] = "Image must be JPG, JPEG, or PNG.";
        }
        if ($image['size'] > $max_size) {
            $errors[] = "Image size must not exceed 5MB.";
        }
        if (empty($errors)) {
            $image_name = uniqid() . '_' . basename($image['name']);
            $image_path = 'images/' . $image_name;
            $upload_dir ='../admin/bots/';
            if (!is_dir($upload_dir)) {
                mkdir($upload_dir, 0755, true);
            }
            if (!move_uploaded_file($image['tmp_name'], $upload_dir . $image_name)) {
                $errors[] = "Failed to upload image.";
            } else if (file_exists('../admin/bots/' . $bot['image'])) {
                unlink('../admin/bots/' . $bot['image']);
            }
        }
    }

    // Process form if no errors
    if (empty($errors)) {
        $con->begin_transaction();
        try {
            $stmt = $con->prepare("UPDATE trading_bots SET bot_name = ?, image = ?, description = ?, price = ?, duration = ?, platform = ?, updated_at = ? WHERE id = ?");
            $stmt->bind_param('sssdsssi', $bot_name, $image_name, $description, $price, $duration, $platform, $currentTime, $bot_id);
            if (!$stmt->execute()) {
                throw new Exception("Failed to update trading bot: " . $stmt->error);
            }
            $stmt->close();
            $con->commit();
            $msg = "Trading bot updated successfully.";
            $type = "success";
        } catch (Exception $e) {
            $con->rollback();
            error_log("Update trading bot error: " . $e->getMessage());
            $msg = "Failed to update trading bot: " . $e->getMessage();
            $type = "warning";
        }
    } else {
        $msg = implode("<br>", $errors);
        $type = "warning";
    }
}
?>

<div class="content-wrapper">
    <div class="container-xxl flex-grow-1 container-p-y">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Trading Bots/</span> Edit Trading Bot</h4>

        <?php if ($msg) { ?>
            <div class="alert alert-<?php echo $type; ?>">
                <h6 class="alert-heading fw-bold mb-1"><?php echo $type; ?></h6>
                <p class="mb-0"><?php echo $msg; ?></p>
            </div>
        <?php } ?>

        <div class="card mb-4">
            <h5 class="card-header">Edit Trading Bot</h5>
            <div class="card-body">
                <form method="post" enctype="multipart/form-data">
                    <div class="row">
                        <div class="mb-3 col-md-6">
                            <label for="bot_name" class="form-label">Bot Name</label>
                            <input type="text" class="form-control" id="bot_name" name="bot_name" maxlength="100" required value="<?php echo htmlspecialchars($bot['bot_name']); ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="image" class="form-label">Image (Current):<br><img src="../admin/bots/<?php echo htmlspecialchars($bot['image']); ?>" style="max-width: 100px; height: auto;margin-top:10px;" /></label>
                            <input type="file" class="form-control" id="image" name="image" accept=".jpg,.jpeg,.png" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="price" class="form-label">Price ($)</label>
                            <input type="number" class="form-control" id="price" name="price" step="0.01" min="0.01" required value="<?php echo htmlspecialchars($bot['price']); ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="duration" class="form-label">Duration (Days)</label>
                            <input type="number" class="form-control" id="duration" name="duration" min="1" required value="<?php echo htmlspecialchars($bot['duration']); ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="platform" class="form-label">Platform</label>
                            <select class="form-control" id="platform" name="platform" required>
                                <option value="MT5" <?php echo $bot['platform'] === 'MT5' ? 'selected' : ''; ?>>MT5</option>
                            </select>
                        </div>
                        <div class="mb-3 col-12">
                            <label for="description" class="form-label">Description</label>
                            <textarea class="form-control" id="description" name="description" rows="5" maxlength="1000" required><?php echo htmlspecialchars($bot['description']); ?></textarea>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-primary">Update Bot</button>
                </form>
            </div>
        </div>
    </div>
</div>

<?php include 'includes/footer.php'; ?>