<?php
    if(isset($_GET['pwd']))
    {
        if(base64_encode("Admin@123")==$_GET['pwd'])
        {
            include('config.php');
            $voiceid     = isset($_REQUEST['voiceid']) ? trim($_REQUEST['voiceid']) : '';
            $soundstatus = isset($_REQUEST['soundstatus']) ? trim($_REQUEST['soundstatus']) : '';
            
            if (empty($voiceid) || empty($soundstatus)) {
                echo json_encode(array(
                    'status' => 0,
                    'message' => 'Voice ID or Status params Missing.'
                ));
            }
            else {
                $log_query = mysqli_query($con,"SELECT * FROM voice_audio_master_logs WHERE soundid='$voiceid' LIMIT 1");
                if (mysqli_num_rows($log_query) == 0) {
                    echo json_encode(array(
                        'status' => 0,
                        'message' => 'Sound ID Not Found in Database.'
                    ));
                }
                else {
                    $log_data = mysqli_fetch_assoc($log_query);
                    $audio_id    = $log_data['audio_id'];
                    $school_code = $log_data['school_code'];
                    
                    mysqli_query($con,"UPDATE voice_audio_master_logs SET status='$soundstatus' WHERE soundid='$voiceid'");
                    
                    $school_query = mysqli_query($con,"SELECT * FROM schools WHERE school_code='$school_code' LIMIT 1");
                    if (mysqli_num_rows($school_query) == 0) {
                        echo json_encode(array(
                            'status' => 0,
                            'message' => 'School Not Found in Database.'
                        ));
                    }
                    else {
                        $school = mysqli_fetch_assoc($school_query);
                        $custom_db = $school['db'];
                        $custom_db_user = $school['db_user'];
                        $custom_db_pwd = $school['db_pwd'];
                        
                        $school_con = mysqli_connect("localhost", $school['db_user'], $school['db_pwd'], $school['db']);
                        if (!$school_con) {
                            echo json_encode(array(
                                'status' => 0,
                                'message' => 'School DB Connection Failed.'
                            ));
                        }
                        else {
                            $mainstatus = $soundstatus == 'Active' ? 1 : 0;
                            mysqli_query($school_con,"UPDATE voice_call_audio SET status=$mainstatus WHERE api_id='$voiceid'");
                            echo json_encode(array(
                                'status' => 1,
                                'message' => 'Audio status has been updated successfully.'
                            ));
                        }
                    }
                }
            }
        }
        else {
            echo json_encode(array(
                'status' => 0,
                'message' => 'Authentication failed: Invalid webhook password.'
            ));
        }
    }
    else {
        echo json_encode(array(
            'status' => 0,
            'message' => 'Authentication failed: Invalid webhook password.'
        ));
    }
?>