1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / ashtokenrewards.com /
Filename : verified-bonus.php
back
<?php
include('../config/aconn.php');

$reward_tokens = 6;

// Fetch users eligible for the daily reward
$queryUsersToUpdate = "
    SELECT id, ton_balance 
    FROM users 
    WHERE verification_status = 1
";
$stmtFetchUsers = $con->prepare($queryUsersToUpdate);

if ($stmtFetchUsers) {
    $stmtFetchUsers->execute();
    $resultUsers = $stmtFetchUsers->get_result();

    if ($resultUsers && $resultUsers->num_rows > 0) {
        // Prepare statements
        $updateBalanceStmt = $con->prepare("
            UPDATE users 
            SET ton_balance = ton_balance + ?
            WHERE id = ?
        ");

        $transactionStmt = $con->prepare("
            INSERT INTO transactions (
                user_id, amount, transaction_type, description, old_balance, 
                new_balance, profit, status, ref, last_transaction_time, 
                creationDate, updationDate
            ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW(), NOW())
        ");

        if ($updateBalanceStmt && $transactionStmt) {
            $transactionType = "Bonus";
            $description = "Verification Reward";
            $status = "Completed";

            while ($user = $resultUsers->fetch_assoc()) {
                $userId = $user['id'];
                $oldBalance = $user['ton_balance'];
                $newBalance = $oldBalance + $reward_tokens;
                $ref = uniqid("TXN"); // Unique transaction reference

                // Update user balance
                $updateBalanceStmt->bind_param("ii", $reward_tokens, $userId);
                if ($updateBalanceStmt->execute()) {
                    // Insert transaction record
                    $profit = $reward_tokens;
                    $transactionStmt->bind_param(
                        "iissddsss", 
                        $userId, $reward_tokens, $transactionType, $description, 
                        $oldBalance, $newBalance, $profit, $status, $ref
                    );
                    if ($transactionStmt->execute()) {
                        echo "Reward and transaction recorded for user ID: $userId\n";
                    } else {
                        echo "Failed to insert transaction for user ID: $userId: " . $transactionStmt->error . "\n";
                    }
                } else {
                    echo "Failed to update balance for user ID: $userId: " . $updateBalanceStmt->error . "\n";
                }
            }
        } else {
            echo "Failed to prepare statements: " . $con->error . "\n";
        }

        $updateBalanceStmt->close();
        $transactionStmt->close();
    } else {
        echo "No eligible users found for reward update.\n";
    }

    $stmtFetchUsers->close();
} else {
    echo "Failed to prepare fetch users statement: " . $con->error . "\n";
}

$con->close();
?>