1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / user /
Filename : quiz.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('includes/checklogin.php');
check_login();
$title = "Survey";
$uip = $_SERVER['REMOTE_ADDR'];
include 'includes/header.php';
include 'includes/functions.php';

error_reporting(E_ALL);
ini_set('display_errors', 1);

$uid = $_SESSION['id'];
$username = $_SESSION['username'];
$sql = "SELECT * FROM `users` WHERE `id` = $uid";
$res = mysqli_query($con, $sql);
$user = mysqli_fetch_assoc($res);
$activity_balance = $user['earnings'];
$country_id = $user['country_id'];
$plan_id = (int) $user['plan_id'];  // Ensure it's an integer

// Fetch country-specific settings if needed
$countryQuery = "SELECT `symbol` FROM `countries` WHERE `id` = '$country_id'";
$countryResult = mysqli_query($con, $countryQuery);
$countryData = mysqli_fetch_assoc($countryResult);
$symbol = $countryData['symbol'];

// Process survey submission
if (isset($_POST['submit'])) {
    $survey_id = $_POST['survey_id'];
    $selected_option = $_POST['answer'];

    // Fetch the correct answer and points for the survey question
    $surveyQuery = "SELECT correct_option, points FROM surveys WHERE id = $survey_id";
    $surveyResult = mysqli_query($con, $surveyQuery);
    $survey = mysqli_fetch_assoc($surveyResult);
    $correct_option = $survey['correct_option'];
    $bonus = $survey['points'];

    // Determine bonus based on plan_id
    if ($plan_id == 1 || $plan_id == 2 || $plan_id == 8) {  
        $points = 500;
    } elseif ($plan_id == 5 || $plan_id == 6 || $plan_id == 7) {  
        $points = 1000;
    } else {
        $points = 500;
    }
    
    // Check if the user's selected answer is correct
    $is_correct = ($selected_option === $correct_option) ? 1 : 0;

    // Insert user response into the database
    $insertQuery = "INSERT INTO user_survey_responses (user_id, survey_id, selected_option, is_correct)
                    VALUES ($uid, $survey_id, '$selected_option', $is_correct)";
    mysqli_query($con, $insertQuery);

// Update user's points if the answer is correct
if ($is_correct) {
    $updatePointsQuery = "UPDATE users SET earnings = earnings + $points WHERE id = $uid";
    mysqli_query($con, $updatePointsQuery);
    $msg = "Correct! You've earned $points GC.";
    $type = "success";

    // Add notification for correct answer
    $notification_message = "Congrats! You've earned $points GC for answering the quiz correctly.";
} else {
    $msg = "Incorrect answer, better luck next time!";
    $type = "warning";

    // Add notification for incorrect answer
    $notification_message = "You answered the quiz incorrectly. Better luck next time!";
}

// Escape the notification message to prevent SQL errors
$escaped_notification_message = mysqli_real_escape_string($con, $notification_message);

// Insert notification record
$notificationsql = "INSERT INTO `notifications` (`receiver_id`, `action_type`, `body`)
                    VALUES ('$uid', 'Quiz', '$escaped_notification_message')";
mysqli_query($con, $notificationsql);

}
?>

<div
      class="container min-h-dvh relative overflow-hidden py-8 dark:text-white -z-10 dark:bg-color1"
    >
 <!-- Page Title Start -->
 <div class="relative z-10 px-6 pb-20">
        <div class="flex justify-between items-center gap-4">
          <div class="flex justify-start items-center gap-4">
            <h2 class="text-2xl font-semibold text-white">
              Daily Quiz
            </h2>
          </div>
        </div>

        <div class="pt-8">
          <div
            class="py-6 px-5 bg-white dark:bg-color9 border border-dashed border-p1 rounded-xl"
            style="margin-top:20px;"
            >
            <div
              class="flex justify-between items-center  border-p1"
            >
           
               Answer the questions correctly
            </div> 
          </div>
            <!-- End Page Title -->
<br>
            <!-- Display Messages -->
            <?php if(isset($msg)) { ?>
                        <div class="error-wrapper-<?php echo $type?>">
                        <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                        </div>
                        <?php }?>

            <!-- Survey Section -->
            <div class="row pt-12">
                <?php
                // Fetch surveys for the user to answer
                $surveyQuery = "SELECT * FROM surveys";
                $surveyResult = mysqli_query($con, $surveyQuery);
                if (mysqli_num_rows($surveyResult) > 0) {
                    while ($survey = mysqli_fetch_assoc($surveyResult)) {
                        $survey_id = $survey['id'];
                        $question = $survey['question'];
                        $option_a = $survey['option_a'];
                        $option_b = $survey['option_b'];
                        $option_c = $survey['option_c'];
                        $option_d = $survey['option_d'];

                        // Check if the user has already answered this survey
                        $checkResponseQuery = "SELECT * FROM user_survey_responses WHERE user_id = '$uid' AND survey_id = '$survey_id'";
                        $checkResponseResult = mysqli_query($con, $checkResponseQuery);

                        if (mysqli_num_rows($checkResponseResult) == 0) {
                ?>
                            <div class="col-lg-6">
                                <div class="card">
                                    <div class="card-body">
                                        <h4 class="card-title mb-3"><?php echo $question; ?></h4>
                                        <form method="POST" action="">
                                            <input type="hidden" name="survey_id" value="<?php echo $survey_id; ?>">
                                            <div class="form-group">
                                                <label><input type="radio" name="answer" value="A"> <?php echo $option_a; ?></label><br>
                                                <label><input type="radio" name="answer" value="B"> <?php echo $option_b; ?></label><br>
                                                <label><input type="radio" name="answer" value="C"> <?php echo $option_c; ?></label><br>
                                                <label><input type="radio" name="answer" value="D"> <?php echo $option_d; ?></label><br>
                                            </div>
                                            <button type="submit" name="submit" 
                                            class="bg-p2 rounded-full py-3 w-full text-white text-sm font-semibold text-center block mt-5 dark:bg-p1"

                                            >Submit Answer</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                <?php
                        } else {
                            echo "<p class='text-warning text-center'>You have already answered this quiz.</p>";
                        }
                    }
                } else {
                    echo "<p class='text-center'>No quiz available at the moment. Please check back later.</p>";
                }
                ?>
            </div>
        </div>
    </div>
</div>
<!-- End Main Content -->

<?php include 'bottom-tabs.php'; ?>
<?php include 'includes/footer.php'; ?>