<?php
/**
 * DADA API COMPLETE INTEGRATION KIT FOR DEVELOPERS
 * Auto-fetch & Auto-sync Mumbai Matka Results
 */

error_reporting(E_ALL);
ini_set('display_errors', 1);
date_default_timezone_set('Asia/Kolkata');

// STEP 1: DEVELOPER CONFIGURATION LAYER
$client_db_host = "localhost";
$client_db_user = "YOUR_LOCAL_DB_USER";       
$client_db_pass = "YOUR_LOCAL_DB_PASSWORD";   
$client_db_name = "YOUR_LOCAL_DB_NAME";       

// DADA API Target Endpoint Configurations:
$api_endpoint   = "https://satta-live-result-fast.com/api.php"; 
$api_secret_key = "DADA-MATKA-XYZ-78692";             

// STEP 2: CONNECT TO CLIENT LOCAL DATABASE
$local_conn = new mysqli($client_db_host, $client_db_user, $client_db_pass, $client_db_name);
if ($local_conn->connect_error) {
    die(json_encode(["status" => false, "message" => "Connection failed"]));
}

// STEP 3: cURL REQUEST TO DADA API
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $api_endpoint . "?api_key=" . urlencode($api_secret_key));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 20);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    "Authorization: Bearer " . $api_secret_key,
    "Accept: application/json"
]);

$api_response = curl_exec($ch);
curl_close($ch);

$json_data = json_decode($api_response, true);
if (!$json_data || $json_data['status'] !== true) {
    die(json_encode(["status" => false, "message" => "Bad Auth Token or Sync Error."]));
}

$current_date = $json_data['date'];

// STEP 4: AUTOMATIC RESULT UPDATE & SYNC LOGIC
foreach ($json_data['data'] as $game) {
    $name       = $local_conn->real_escape_string($game['game_name']);
    $open_time  = $local_conn->real_escape_string($game['timings']['open_time']);
    $close_time = $local_conn->real_escape_string($game['timings']['close_time']);
    
    $full       = $local_conn->real_escape_string($game['results']['full_format']);
    $op_pana    = $local_conn->real_escape_string($game['results']['open_pana']);
    $op_ank     = $local_conn->real_escape_string($game['results']['open_ank']);
    $jodi       = $local_conn->real_escape_string($game['results']['jodi']);
    $cl_ank     = $local_conn->real_escape_string($game['results']['close_ank']);
    $cl_pana    = $local_conn->real_escape_string($game['results']['close_pana']);

    // Sync Game Timings
    $local_conn->query("INSERT INTO local_matka_games (game_name, open_time, close_time) 
                        VALUES ('$name', '$open_time', '$close_time') 
                        ON DUPLICATE KEY UPDATE open_time='$open_time', close_time='$close_time'");

    // Sync Live Results Real-Time
    $local_conn->query("INSERT INTO local_matka_results 
        (game_name, result_date, full_result, open_pana, open_ank, jodi, close_ank, close_pana) 
        VALUES ('$name', '$current_date', '$full', '$op_pana', '$op_ank', '$jodi', '$cl_ank', '$cl_pana') 
        ON DUPLICATE KEY UPDATE 
            full_result='$full', open_pana='$op_pana', open_ank='$op_ank', jodi='$jodi', close_ank='$cl_ank', close_pana='$cl_pana'");
}

echo json_encode(["status" => true, "message" => "Sync Completed Successfully."]);
$local_conn->close();
?>