1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / manager /
Filename : bots.php
back
<?php
session_start();
include('../../config/oxconfig.php');
include('includes/checklogin.php');
include('includes/mail-settings.php');
check_login();
$title = "Trading Bots";
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 = '';

// Delete trading bot
if (isset($_GET['del']) && isset($_GET['bot_id']) && filter_var($_GET['bot_id'], FILTER_VALIDATE_INT)) {
    $bot_id = filter_var($_GET['bot_id'], FILTER_VALIDATE_INT);
    $con->begin_transaction();
    try {
        // Fetch image path to delete file
        $stmt = $con->prepare("SELECT image FROM trading_bots WHERE id = ?");
        $stmt->bind_param('i', $bot_id);
        $stmt->execute();
        $result = $stmt->get_result();
        $row = $result->fetch_assoc();
        $stmt->close();

        if ($row && file_exists(__DIR__ . '/' . $row['image'])) {
            unlink(__DIR__ . '/' . $row['image']);
        }

        // Delete bot
        $stmt = $con->prepare("DELETE FROM trading_bots WHERE id = ?");
        $stmt->bind_param('i', $bot_id);
        if (!$stmt->execute()) {
            throw new Exception("Failed to delete trading bot: " . $stmt->error);
        }
        $stmt->close();
        $con->commit();
        $msg = "Trading bot deleted successfully.";
        $type = "success";
    } catch (Exception $e) {
        $con->rollback();
        error_log("Delete trading bot error: " . $e->getMessage());
        $msg = "Failed to delete trading bot: " . $e->getMessage();
        $type = "warning";
    }
    echo "<script>window.location.href='trading-bots.php';</script>";
    exit;
}

// Fetch all trading bots
$stmt = $con->prepare("SELECT id, bot_name, image, description, price, duration, platform, created_at FROM trading_bots ORDER BY created_at DESC");
$stmt->execute();
$result = $stmt->get_result();
$bots = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
?>

<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> Trading Bots List</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">
            <h5 class="card-header">Trading Bots</h5>
            <div class="card-body">
               
                <div class="table-responsive">
                    <table class="table table-bordered" id="dataTables-example">
                        <thead>
                            <tr>
                                <th>Bot Name</th>
                                <th>Image</th>
                                <th>Description</th>
                                <th>Price ($)</th>
                                <th>Duration (Days)</th>
                                <th>Platform</th>
                                <th>Created At</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($bots as $bot) { ?>
                                <tr>
                                    <td><?php echo htmlspecialchars($bot['bot_name']); ?></td>
                                    <td><img src="../admin/bots/<?php echo htmlspecialchars($bot['image']); ?>" alt="Bot Image" style="max-width: 50px; height: auto;" /></td>
                                    <td><?php echo htmlspecialchars(substr($bot['description'], 0, 50)) . (strlen($bot['description']) > 50 ? '...' : ''); ?></td>
                                    <td>$<?php echo number_format($bot['price'], 2); ?></td>
                                    <td><?php echo htmlspecialchars($bot['duration']); ?></td>
                                    <td><?php echo htmlspecialchars($bot['platform']); ?></td>
                                    <td><?php echo htmlspecialchars($bot['created_at']); ?></td>
                                    <td>
                                        <a href="edit-trading-bot.php?bot_id=<?php echo $bot['id']; ?>" class="btn btn-sm btn-primary">
                                            <i class="fas fa-edit"></i> Edit
                                        </a>
                                        <a href="?bot_id=<?php echo $bot['id']; ?>&del=delete" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure you want to delete this trading bot?')">
                                            <i class="fas fa-trash"></i> Delete
                                        </a>
                                    </td>
                                </tr>
                            <?php } ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

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