MAINHACK

Viewing / Editing File: VerifyTicket.php

<?php
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *'); // Allow CORS for local testing

// Start session
session_start();

// Include database connection
include("functions.php");

// Check database connection
if (!isset($con) || !($con instanceof PDO)) {
    echo json_encode(['valid' => false, 'message' => 'Database connection failed.']);
    exit;
}

// Check user authentication
if (!isset($_SESSION['username_Xw21erAAsqg4']) || empty($_SESSION['username_Xw21erAAsqg4'])) {
    echo json_encode(['valid' => false, 'message' => 'User not authenticated.']);
    exit;
}
$username = $_SESSION['username_Xw21erAAsqg4'];

try {
    // Get input data
    $data = json_decode(file_get_contents('php://input'), true);
    $ticket_code = isset($data['ticket_code']) ? trim($data['ticket_code']) : '';
    $mode = isset($data['mode']) ? $data['mode'] : 'check'; // 'check' for live search, 'confirm' for marking as used

if (empty($ticket_code)) {
        echo json_encode(['valid' => false, 'message' => 'Ticket code is required']);
        exit;
    }

// Query to check ticket code and usage status
    $stmt = $con->prepare('SELECT * FROM tickets WHERE ticket_code = ?');
    $stmt->execute([$ticket_code]);
    $result = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$result) {
        // Ticket code does not exist
        echo json_encode(['valid' => false, 'message' => 'Invalid ticket code.']);
        exit;
    }

if ($result['ticket_used'] == 1) {
        // Ticket already used
        echo json_encode(['valid' => false, 'message' => 'Ticket has already been used.']);
        exit;
    }

if ($mode === 'confirm') {
        // Ticket is valid and unused; update ticket_used and verifyby
        $updateStmt = $con->prepare('UPDATE tickets SET ticketused = 1, verifyby = ? WHERE ticket_code = ?');
        $updateStmt->execute([$username, $ticket_code]);
        echo json_encode(['valid' => true, 'message' => 'Ticket is valid and has been marked as used!']);
    } else {
        // Live search mode: just confirm validity
        echo json_encode(['valid' => true, 'message' => 'Ticket is valid. Click Confirm to mark as used.']);
    }
} catch (PDOException $e) {
    echo json_encode(['valid' => false, 'message' => 'Database error: ' . $e->getMessage()]);
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: VerifyTicket.php

Server Info

System Features

User Info