new file mode 100644

@@ -0,0 +1,43 @@

+<?php

+/**

+ *  Copyright (C) 2021, 2024  Double Bastion LLC

+ *

+ *  This file is part of Roundpin, which is licensed under the

+ *  GNU Affero General Public License Version 3.0. The license terms

+ *  are detailed in the "LICENSE.txt" file located in the root directory.

+ */

+

+session_start();

+

+if (isset($_POST['s_ajax_call']) && ($_POST['s_ajax_call'] == $_SESSION['validate_s_access'])) {

+

+ define('ACCESSCONST', TRUE);

+

+ require('db-connect.php');

+

+    $username = $_POST['username'];

+    $contactName = $_POST['contact_name'];

+

+    // Get the id of the current user from the 'app_users' table

+    $enabled = 1;

+    $queryid = $mysqli->prepare("SELECT id, username, enabled FROM app_users WHERE BINARY username = ? AND enabled = ?");

+    $queryid->bind_param("si", $username, $enabled);

+    $queryid->execute();

+    $queryres = $queryid->get_result()->fetch_assoc();

+    $userID = $queryres['id'];

+

+    // Remove the contact from the 'contacts' table

+    $querycont = $mysqli->prepare("DELETE FROM contacts WHERE user_id = ? AND contact_name = ?");

+    $querycont->bind_param("ss", $userID, $contactName);

+    $querycont->execute();

+

+    if ($querycont) { $message = 'success'; } else { $message = 'failure'; }

+

+    $delresult = ['removeresult' => $message];

+    echo json_encode($delresult);

+

+} else {

+     header("Location: ../login.php");

+}

+

+?>