1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / earnlouq / .trash /
Filename : turn_on_yielder.php
back
<?php
session_start();
include('../../config/oxconfig.php');
include('includes/functions.php');

$response = ['status' => 'error', 'message' => 'Invalid request'];

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['user_id'])) {
    $user_id = intval($_POST['user_id']);

    // Fetch user data
    $user = getUserInfo($con, $user_id);
    if (!$user) {
        $response['message'] = 'User not found';
        echo json_encode($response);
        exit;
    }

    // Check if yielder is active
    if (!$user['is_yielder_active']) {
        // Attempt to purchase yielder for $5
        if ($user['balance'] < 5.00) {
            $response = [
                'status' => 'deposit_required',
                'message' => 'Insufficient balance to purchase yielder. Please deposit at least $5.'
            ];
            echo json_encode($response);
            exit;
        }

        // Deduct $5 and activate yielder
        $new_balance = $user['balance'] - 5.00;
        $stmt = $con->prepare("UPDATE users SET balance = ?, is_yielder_active = 1 WHERE id = ?");
        $stmt->bind_param("di", $new_balance, $user_id);
        $stmt->execute();
        $stmt->close();
    }

    // Fetch yielder progress
    $stmt = $con->prepare("SELECT plan_id, amount, is_active FROM yielder_progress WHERE user_id = ?");
    $stmt->bind_param("i", $user_id);
    $stmt->execute();
    $yielder = $stmt->get_result()->fetch_assoc();
    $stmt->close();

    if (!$yielder || !$yielder['plan_id']) {
        $response['message'] = 'No investment plan selected';
        echo json_encode($response);
        exit;
    }

    if ($yielder['is_active']) {
        $response['message'] = 'Yielder is already running';
        echo json_encode($response);
        exit;
    }

    // Fetch plan details
    $stmt = $con->prepare("SELECT profit_percentage FROM investment_plans WHERE id = ?");
    $stmt->bind_param("i", $yielder['plan_id']);
    $stmt->execute();
    $plan = $stmt->get_result()->fetch_assoc();
    $stmt->close();

    // Fetch market condition
    $stmt = $con->prepare("SELECT `condition` FROM market_conditions ORDER BY updated_at DESC LIMIT 1");
    $stmt->execute();
    $market = $stmt->get_result()->fetch_assoc();
    $market_condition = $market['condition'] ?? 'neutral';
    $stmt->close();

    // Calculate profit or loss
    $amount = $yielder['amount'];
    $profit_percentage = $plan['profit_percentage'];
    $profit = ($market_condition === 'good') ? ($amount * $profit_percentage / 100) : (-$amount * $profit_percentage / 100);

    // Update yielder_progress with profit and start_time, set is_active to 0
    $stmt = $con->prepare("UPDATE yielder_progress SET profit = ?, start_time = NOW(), is_active = 0 WHERE user_id = ?");
    $stmt->bind_param("di", $profit, $user_id);
    $stmt->execute();
    $stmt->close();

    $response = [
        'status' => 'success',
        'message' => $market_condition === 'good' 
            ? 'Yielder activated. Profit of $' . number_format($profit, 2) . ' can be claimed in 24 hours.'
            : 'Yielder activated. Loss of $' . number_format(abs($profit), 2) . ' will be applied in 24 hours.'
    ];
}

echo json_encode($response);
?>