<?php
    include_once("../../cfg/db.php");

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

    $current_user = $_SESSION['user']['id'];

    if(intval($db -> select("SELECT count(1) FROM source_dms WHERE name = '$new_dms'")) > 0){
        $return_arr['status'] = 0; //duplicate dms name
        $return_arr['message'] = "DMS already existing";
        echo json_encode($return_arr);
    }
    else {
        $db->sql_query("INSERT INTO `source_dms` (`name`, `added_by`) VALUES('$new_dms', '$current_user')");
        $return_arr['status'] = 1;
        echo json_encode($return_arr);
    }
?>