<?php
    include_once("../../cfg/db.php");
    $id = $db->escape(trim($_POST['dms_id']));
    $status = $db->escape(trim($_POST['status']));
    $set_status = 0;

    if($status == "true"){
        $set_status = 1;
    }

    $new_dms_name = $db->escape(trim(strtoupper($_POST['new_dms_name'])));

    if(intval($db -> select("SELECT count(1) FROM source_dms WHERE `name` != '' AND `name` = '$new_dms_name' AND id != '$id'")) > 0){
        $arr['status'] = 0; //duplicate dms name
    } else {
        $update_query = "UPDATE `source_dms` SET `name`='$new_dms_name', `status`='$set_status' WHERE `id` = '$id'";
        //echo $update_query; 
        $db->sql_query($update_query);

        $arr['status'] = 1; //success update
    }

    echo json_encode($arr);
?>