1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / .trash /
Filename : process-yielder-profit.php
back
<?php
include('../../config/oxconfig.php');
include('includes/functions.php');

// Fetch yielders past 24 hours
$stmt = $con->prepare("SELECT user_id, plan_id, amount, profit, start_time 
                       FROM yielder_progress 
                       WHERE is_active = 0 AND profit IS NOT NULL AND start_time IS NOT NULL 
                       AND start_time <= NOW() - INTERVAL 24 HOUR");
$stmt->execute();
$yielders = $stmt->get_result();
$stmt->close();

while ($yielder = $yielders->fetch_assoc()) {
    $user_id = $yielder['user_id'];
    $plan_id = $yielder['plan_id'];
    $amount = $yielder['amount'];
    $profit = $yielder['profit'];

    // Insert into unclaimed_profits
    $stmt = $con->prepare("INSERT INTO unclaimed_profits (user_id, plan_id, amount, profit, created_at) 
                           VALUES (?, ?, ?, ?, NOW())");
    $stmt->bind_param("iidd", $user_id, $plan_id, $amount, $profit);
    $stmt->execute();
    $stmt->close();

    // Reset yielder_progress
    $stmt = $con->prepare("UPDATE yielder_progress SET profit = NULL, start_time = NULL WHERE user_id = ?");
    $stmt->bind_param("i", $user_id);
    $stmt->execute();
    $stmt->close();
}
?>