1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / tapnaire.live / user /
Filename : add-reward.php
back
<?php
session_start();
// Database connection
include('../../config/conn.php');

// Get users id or username from the session
$uid= $_SESSION['id'];
$username=$_SESSION['username'];

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


  //Check for the task activity and give user a bonus
  $sql = "SELECT * FROM `users`  WHERE `id`='$uid' ";
  $res = mysqli_query($con, $sql);
  $rtask = mysqli_fetch_assoc($res);
 
 $lastTask = $rtask['lastTask'];
 $earnings = $rtask['earnings'];

 $countryQuery = "SELECT `daily_visit` FROM `countries` WHERE `id`='" . $rtask['country_id'] . "'";
 $countryResult = mysqli_query($con, $countryQuery);
 $countryData = mysqli_fetch_assoc($countryResult);

 $TaskBonus = $countryData['task'];


 $new_earnings=$earnings+$TaskBonus;
 if ($lastTask !== $today) {

    $sql1="UPDATE `users` SET `earnings`='$new_earnings',`lastTask`='$today' WHERE `id`='$uid' ";
    $result1=mysqli_query($con,$sql1);
    if($result1){ 
     $userid=$_SESSION['id'];
       //Set a bonus message to send as a notification
       $bonus_message="Congrats! You just received your daily task reward for today.";    
       $notificationsql="INSERT INTO `notifications` (`receiver_id`,`action_type`,`body`)
                                 VALUES  ('$userid','Task','$bonus_message')";
       $result2=mysqli_query($con,$notificationsql);

       // Set result and message
       $success = true; 
       $messageOne = 'Daily Task unlocked!';
       $messageTwo = `$TaskBonus will be added to GC`;

  }else{
    $success = false; 
    $messageOne = 'An Error Occured!';
    $messageTwo = '0 would be added to PMQ';

  }

 }else{

  // Set result and message
$success = false; 
$messageOne = 'You have unlocked for today!';
$messageTwo = '0 would be added to PMQ';


 }

// Prepare the response as JSON
$response = array(
  'success' => $success,
  'messageOne' => $messageOne,
  'messageTwo' => $messageTwo
);

// Send the JSON response
header('Content-Type: application/json');
echo json_encode($response);
?>