1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / pattklvg / public_html / admin / api / relationship /
Filename : update.php
back
<?php
include "../../dist/resources/config.php";
include "../common/utils.php";

$user_row = checkUser($conn);
$id = $user_row["id"];
$community_id = $user_row["community"];
$request_body = json_decode(file_get_contents("php://input"));

if (!isset($request_body->user_id)) {
    apiError("Missing required parameters user_id");
    die();
}

if ($id == $request_body->user_id) {
	apiError("You cannot set a relationship to yourself!");
	die();
}

// check if relationship is to be cleared
$relationship = isset($request_body->relationship) && $request_body->relationship !== '-' ? $request_body->relationship : NULL;

$sql = "SELECT * FROM relationship WHERE user_id='$id' AND user_id_2='$request_body->user_id'";
$res = $conn->query($sql);
$relationship_id = NULL;
while ($row = $res->fetch_assoc()) {
    $relationship_id = $row['id'];
}


if ($relationship_id == NULL && $relationship != NULL) {
    $stmt = $conn->prepare("INSERT INTO relationship VALUES (NULL, ?, ?, ?)");
    $stmt->bind_param('isi', $id, $relationship, $request_body->user_id);
} else {
    if ($request_body->relationship != NULL) {
        $stmt = $conn->prepare("UPDATE relationship SET user_id=?, relationship=?, user_id_2=? WHERE id=?");
        $stmt->bind_param('isii', $id, $request_body->relationship, $request_body->user_id, $relationship_id);
    } else {
        $stmt = $conn->prepare("DELETE FROM relationship WHERE id=?");
        $stmt->bind_param('i', $relationship_id);
    }
}

if ($stmt->execute()) {
    apiOK("Relationship to user updated.", communityIdToName($community_id, $conn));
} else {
    apiError("Failed updating user relationship.");
}