<?php
 /**
  *  Copyright (C) 2021  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 user for which we want to update the contact data
     $query1 = $mysqli->query("SELECT id, username, enabled FROM app_users WHERE BINARY username = '$username' AND enabled = 1");
     $queryres = $query1->fetch_array();
     $userID = $queryres[0];
 
     // Get the row id from the 'contacts' table, for the current contact
     $query2 = $mysqli->prepare("SELECT id, user_id, contact_name FROM contacts WHERE user_id=? AND contact_name=?");
     $query2->bind_param("is", $userID, $contactName);
     $query2->execute();
     $fetchInfo = $query2->get_result();
     $contactdata = $fetchInfo->fetch_row();
     $contactRowId = $contactdata[0];
     $query2->close();
 
     if ($contactRowId != '' && $contactRowId != null && $contactRowId != 'undefined') {
         $CntctDatabaseId = $contactRowId;
         $messagetosend = 'success';
     } else { $CntctDatabaseId = ''; $messagetosend = 'failure'; }
 
     $response = array('successorfailure' => $messagetosend, 'cntctDatabaseID' => $CntctDatabaseId);
     echo json_encode($response);
 
 } else {
     header("Location: roundpin-login.php");
 }
 
 ?>