MAINHACK

Viewing / Editing File: save_millionaire_results.php

<?php
require_once '../config/database.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $competition_id = $_POST['competition_id'];
    $player_name = sanitize($_POST['player_name']);
    $final_level = intval($_POST['final_level']);
    $final_prize = sanitize($_POST['final_prize']);
    $final_score = intval($_POST['final_score'] ?? 0);
    
    // Use the calculated score from frontend
    if ($final_score == 0) {
        // Fallback: Convert prize to score (1000 currency = 1 point)
        if (preg_match('/[\d,]+/', $final_prize, $matches)) {
            $prize_number = intval(str_replace(',', '', $matches[0]));
            $final_score = floor($prize_number / 1000);
        }
    }
    
    try {
        $stmt = $pdo->prepare("
            INSERT INTO game_results (competition_id, student_name, final_score, game_type, completed_at)
            VALUES (?, ?, ?, 'millionaire', NOW())
        ");
        $stmt->execute([$competition_id, $player_name, $final_score]);
        
        echo json_encode(['success' => true]);
        
    } catch (Exception $e) {
        echo json_encode(['success' => false, 'error' => $e->getMessage()]);
    }
} else {
    echo json_encode(['success' => false, 'error' => 'Invalid request method']);
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: save_millionaire_results.php

Server Info

System Features

User Info