<?php
if(isset($_GET['pwd']))
{
    if(base64_encode("Admin@123")==$_GET['pwd'])
    {
        $servername = "localhost";
        $username = "u926327694_raghuadmin1233";
        $password = "Raghu@48221";
        $dbname = "u926327694_admin_onlinefe";
        
        $main_conn = mysqli_connect($servername,$username,$password,$dbname); 
        
        $sel_School = mysqli_query($main_conn,"select * from schools");
        
        while($row_school = mysqli_fetch_array($sel_School)) {
            $school_code = $row_school['schoolCode'];
            $main_username=$row_school['dbUsernameFees'];
            $main_password=$row_school['dbPassword'];
            $main_dbname=$row_school['dbFees'];
            $con_school=mysqli_connect("localhost",$main_username,$main_password,$main_dbname);
            if($con_school) {
                $sel_users = mysqli_query($con_school,"SELECT * FROM `users` where type='Fees_Management'");
                while($row_user = mysqli_fetch_array($sel_users)) {
                    $uid = $row_user['id'];
                    // For delete
                    $sel_del_permission = mysqli_query($con_school,"SELECT * FROM `user_permission` where user_id=$uid and menu='fees_delete'");
                    if(mysqli_num_rows($sel_del_permission) > 0) {
                        
                    }
                    else {
                        $ins = mysqli_query($con_school, "INSERT INTO `user_permission`(`user_id`, `menu`, `status`) VALUES ('$uid','fees_delete','1')");
                    }
                    
                    // For edit
                    $sel_edit_permission = mysqli_query($con_school,"SELECT * FROM `user_permission` where user_id=$uid and menu='fees_edit'");
                    if(mysqli_num_rows($sel_edit_permission) > 0) {
                        
                    }
                    else {
                        $ins = mysqli_query($con_school, "INSERT INTO `user_permission`(`user_id`, `menu`, `status`) VALUES ('$uid','fees_edit','1')");
                    }
                }
            }
            else {
                $update_message .= "<p style='color:red'>". $school_code." = Migration Failed because unable to connect database.</p>";
            }
        }
    }
    else
    {
        echo"Access Denied"; exit;
    }
}
else
{
    echo"Access Denied"; exit;
}
?>