Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u530111037

Directory:

/home/u530111037/domains/goodcharacteropc.com/public_html

Free Space:

3.36 TB

🔧 Quick Actions

✏️ Editing: quiz-index_og.php

<?php
require_once __DIR__.'/db.php';
require_once __DIR__.'/header-student.php';
require_student();

$school_id = (int)$_SESSION['school_id'];
$student_id = (int)$_SESSION['student_id'];

// $sql = "SELECT q.*,
//         EXISTS(SELECT 1 FROM attempts a WHERE a.student_id=$student_id AND a.quiz_id=q.id AND a.status='completed') as completed,
//         qs.amount
//         FROM quizzes q
//         JOIN quiz_school qs ON qs.quiz_id=q.id AND qs.school_id=$school_id
//         WHERE q.is_active=1
//         ORDER BY q.id DESC";
$sql = "
SELECT
    q.*,
    qs.amount,

-- quiz completed?
    EXISTS (
        SELECT 1
        FROM attempts a
        WHERE a.student_id = $student_id
          AND a.quiz_id = q.id
          AND a.status = 'completed'
    ) AS completed,

-- payment already done?
    EXISTS (
        SELECT 1
        FROM quiz_payments p
        WHERE p.student_id = $student_id
          AND p.quiz_id = q.id
          AND p.status = 'paid'
    ) AS paid

FROM quizzes q
JOIN quiz_school qs
  ON qs.quiz_id = q.id
 AND qs.school_id = $school_id

WHERE q.is_active = 1
ORDER BY q.id DESC
";
$quizzes = $mysqli->query($sql);
?>
<!doctype html>
<html>
<head>
  <meta charset="utf-8">
  <title>Quizzes • <?= e(APP_NAME) ?></title>
  <link rel="stylesheet" href="/assets/style.css">
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
  <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
</head>

<div class="mt-2 card">
    <div class="card-header">
      Active Quizzes
    </div>

<div class="card-body m-0 p-0" style="overflow:auto">
      <table class="table table-hover align-middle m-0" style="width: 100%;">
        <thead class="table-dark">
          <tr>
            <th>Quiz</th>
            <th>Description</th>
            <th>Price</th>
            <th>Time Limit</th>
            <th>Status</th>
            <th>Action</th>
          </tr>
        </thead>
        <?php while($q = $quizzes->fetch_assoc()): ?>
          <tr>
            <td><?= e($q['title']) ?></td>
            <td><?= e($q['description']) ?></td>
            <td>
              <?= $q['amount'] && $q['amount'] > 0 ? '₹'.number_format($q['amount'],2) : 'Free' ?>
            </td>
            <td><?= $q['duration'] ?>min.</td>
            <td><?= $q['completed'] ? 'Completed' : 'Not attempted' ?></td>
            <td>
            <?php if ($q['completed']): ?>

<?php
                $at = $mysqli->query("
                    SELECT id FROM attempts
                    WHERE student_id=$student_id
                      AND quiz_id={$q['id']}
                      AND status='completed'
                    ORDER BY id DESC LIMIT 1
                ")->fetch_row()[0] ?? 0;
                ?>
                <a class="btn btn-info btn-sm" href="certificate.php?attempt_id=<?= (int)$at ?>">
                    Certificate
                </a>

<?php else: ?>

<?php if ($q['amount'] > 0 && !$q['paid']): ?>

<button
                        class="btn btn-warning btn-sm start-quiz-btn"
                        data-quiz-id="<?= $q['id'] ?>"
                    >
                        Pay & Start Quiz
                    </button>

<?php else: ?>

<a class="btn btn-success btn-sm"
                       href="take_quiz.php?quiz_id=<?= $q['id'] ?>">
                        Start Quiz
                    </a>

<?php endif; ?>

<?php endif; ?>
            </td>
          </tr>
        <?php endwhile; ?>
      </table>
    </div>

</div>
</div>

<script src="https://checkout.razorpay.com/v1/checkout.js"></script>
<script>
$(document).on('click', '.start-quiz-btn', function () {
  let quiz_id = $(this).data('quiz-id');
  let btn = $(this).prop('disabled', true).text('Processing...');

$.post('razorpay/create_order.php', { quiz_id: quiz_id }, function (resp) {
    if (!resp || resp.error) {
      alert(resp.error || 'Failed to create order');
      btn.prop('disabled', false).text('Start quiz');
      return;
    }

let options = {
      key: resp.key_id,
      amount: resp.amount,
      currency: resp.currency,
      name: "<?= e(APP_NAME) ?>",
      description: "Quiz Payment",
      order_id: resp.order_id,
      handler: function (response) {
        console.log('Razorpay Response:', response);

$.ajax({
    url: '<?php echo $base_url; ?>razorpay/verify.php',
    type: 'POST',
    dataType: 'json',
    data: {
      razorpay_payment_id: response.razorpay_payment_id,
      razorpay_order_id: response.razorpay_order_id,
      razorpay_signature: response.razorpay_signature,
      quiz_id: quiz_id
    },
    success: function (res) {
      if (res.success) {
        window.location.href = 'take_quiz.php?quiz_id=' + quiz_id;
      } else {
        alert(res.error);
      }
    },
    error: function (xhr) {
      console.error(xhr.responseText);
      alert('Verify AJAX failed');
    }
  });
      },
      prefill: {
        name: "<?= e($_SESSION['student_name'] ?? '') ?>",
        email: "<?= e($_SESSION['student_email'] ?? '') ?>"
      },
      theme: { color: "#0b5ed7" }
    };

let rzp = new Razorpay(options);
    rzp.open();
  }, 'json').fail(function (xhr) {
  alert(xhr.responseText);
});
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: quiz-index_og.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation