1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / tapnaire.live / user /
Filename : update-spin-reward.php
back
<?php
session_start();
error_reporting(0);
require_once '../../config/conn.php';
include 'includes/functions.php';

// Check if user is logged in
if (!isset($_SESSION['id'])) {
    $response = array(
        'status' => false,
        'message' => 'User not authenticated'
    );
    header('Content-Type: application/json');
    echo json_encode($response);
    exit;
}

$uid = $_SESSION['id'];

// Get the current date
$today = date("Y-m-d");

// Get user details from the database
$sql = "SELECT * FROM `users` WHERE `id` = ?";
$stmt = mysqli_prepare($con, $sql);
mysqli_stmt_bind_param($stmt, 'i', $uid);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $activity_balance = $row['earnings'];
    $lastSpin = $row['lastSpin'];

    // Check if the user has already spun today
    if ($lastSpin !== $today) {
        // Calculate new earnings
        $new_earnings = $activity_balance + 500;

        // Update the reward in the database
        $sql = "UPDATE `users` SET `earnings` = ?, `lastSpin` = ? WHERE `id` = ?";
        $stmt = mysqli_prepare($con, $sql);
        mysqli_stmt_bind_param($stmt, 'isi', $new_earnings, $today, $uid);
        $result = mysqli_stmt_execute($stmt);

        if ($result) {
            $userid = $_SESSION['id'];

            // Set a bonus message to send as a notification
            $bonus_message = "Congrats! You just received your daily spin and earn reward for today.";

            // Insert the notification into the database
            $notificationsql = "INSERT INTO `notifications` (`receiver_id`, `action_type`, `body`)
                                VALUES (?, 'Spin', ?)";
            $stmt = mysqli_prepare($con, $notificationsql);
            mysqli_stmt_bind_param($stmt, 'is', $userid, $bonus_message);
            mysqli_stmt_execute($stmt);

            // Set success response
            $response = array(
                'status' => true,
                'message' => 'You just won 500 EIX'
            );
        } else {
            // Set error response
            $response = array(
                'status' => false,
                'message' => 'An error occurred. Please try again'
            );
        }
    } else {
        // User has already spun today
        $response = array(
            'status' => false,
            'message' => 'You have already performed this for today!'
        );
    }
} else {
    // User not found
    $response = array(
        'status' => false,
        'message' => 'User not found'
    );
}

// Prepare the response as JSON
header('Content-Type: application/json');
echo json_encode($response);