<?

header('Content-type: application/json');

include('../db.php');
if (!$_SESSION['isAdmin']) {
    die('Error !');
}

$content_id = (int) $_REQUEST['content_id'];
$category_name = mysqli_real_escape_string($dbconn, $_REQUEST['category_name']);

if ($category_name == '') {
    $response['status'] = 'error';
    $response['message'] = 'Please enter category name!';
}
if ($content_id == '' || $content_id == 0 || !($content_id)) {
    $response['status'] = 'error';
    $response['message'] = 'Invalid content ID!';
}
if (count(dbQuery("SELECT record_num FROM niches WHERE name = '$category_name'",false)) > 0) {
    $response['status'] = 'error';
    $response['message'] = 'This category already exists.';
}

if ($response['status'] != 'error') {
    dbQuery("INSERT INTO niches SET name = '$category_name'");
    $insertid = mysqli_insert_id($dbconn);
    if (is_numeric($insertid)) {
        dbQuery("INSERT INTO content_niches SET content = '$content_id', niche = '$insertid'");
        $get_languages = dbQuery("SELECT * FROM languages", false);
        foreach ($get_languages as $lang) {
            dbQuery("INSERT INTO niches_languages SET niche = '$insertid', language = '" . $lang['iso'] . "', name = '$category_name'");
        }
        $response['status'] = 'success';
        $response['message'] = 'Category has been added.';
    }
}

echo json_encode($response);
?>