1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / earnlouq / ashtokenrewards.com /
Filename : start-task.php
back
<?php
session_start();

// Include necessary files
require_once '../config/aconn.php';
include 'includes/functions.php';

// Ensure the user is logged in
checkLogin();

// Check if task_id is provided via POST request and is a valid number
if (isset($_POST['task_id']) && is_numeric($_POST['task_id'])) {
    $taskId = (int) $_POST['task_id']; // Cast to integer to ensure no other characters
    $uid = $_SESSION['id'];  // Get the logged-in user's ID

    // Prepare query to check if the task exists and is available (status = '1')
    $task_query = "SELECT * FROM `tasks` WHERE `id` = ? AND `status` = '1'";
    if ($stmt = mysqli_prepare($con, $task_query)) {
        // Bind the parameter and execute the query
        mysqli_stmt_bind_param($stmt, "i", $taskId);
        mysqli_stmt_execute($stmt);
        $task_result = mysqli_stmt_get_result($stmt);

        if (mysqli_num_rows($task_result) > 0) {
            // Task exists and is available to start
            $task = mysqli_fetch_assoc($task_result);

            // Check if the user has already started the task
            $user_task_query = "SELECT * FROM `user_tasks` WHERE `user_id` = ? AND `task_id` = ?";
            if ($stmt_user_task = mysqli_prepare($con, $user_task_query)) {
                // Bind the parameters and execute
                mysqli_stmt_bind_param($stmt_user_task, "ii", $uid, $taskId);
                mysqli_stmt_execute($stmt_user_task);
                $user_task_result = mysqli_stmt_get_result($stmt_user_task);

                if (mysqli_num_rows($user_task_result) == 0) {
                    // The user has not started the task yet, so we can start it
                    $start_time = date('Y-m-d H:i:s'); // Get current date and time
                    $cooldown_end_time = date('Y-m-d H:i:s', strtotime('+1 hour')); // Add 1 hour to current time

                    $insert_user_task_query = "INSERT INTO `user_tasks` (`user_id`, `task_id`, `start_time`, `cooldown_end_time`, `status`) VALUES (?, ?, ?, ?, '0')";
                    if ($stmt_insert = mysqli_prepare($con, $insert_user_task_query)) {
                        // Bind the parameters and execute
                        mysqli_stmt_bind_param($stmt_insert, "iiss", $uid, $taskId, $start_time, $cooldown_end_time);

                        if (mysqli_stmt_execute($stmt_insert)) {
                            // Success: Task has been successfully started
                            echo json_encode([
                                'status' => 'success',
                                'message' => 'Task started successfully.'
                            ]);
                        } else {
                            // Failed to start the task
                            echo json_encode([
                                'status' => 'error',
                                'message' => 'Failed to start the task.'
                            ]);
                            error_log('MySQL Error: ' . mysqli_error($con));
                        }

                        // Close the prepared statement
                        mysqli_stmt_close($stmt_insert);
                    } else {
                        // Query preparation failed
                        echo json_encode([
                            'status' => 'error',
                            'message' => 'Failed to prepare the insert query.'
                        ]);
                        error_log('MySQL Error: ' . mysqli_error($con));
                    }
                } else {
                    // User has already started the task, no need to start it again
                    echo json_encode([
                        'status' => 'info',
                        'message' => 'You have already started this task.'
                    ]);
                }

                // Close the prepared statement
                mysqli_stmt_close($stmt_user_task);
            } else {
                // Query preparation failed
                echo json_encode([
                    'status' => 'error',
                    'message' => 'Failed to prepare the user task query.'
                ]);
                error_log('MySQL Error: ' . mysqli_error($con));
            }
        } else {
            // Task not found or not available to start
            echo json_encode([
                'status' => 'error',
                'message' => 'Task not found or not available to start.'
            ]);
        }

        // Close the prepared statement
        mysqli_stmt_close($stmt);
    } else {
        // Query preparation failed
        echo json_encode([
            'status' => 'error',
            'message' => 'Failed to prepare the task query.'
        ]);
        error_log('MySQL Error: ' . mysqli_error($con));
    }
} else {
    // Invalid task ID or missing task ID
    echo json_encode([
        'status' => 'error',
        'message' => 'Invalid or missing task ID.'
    ]);
}
?>