Contact Center

Sophia Williams

Online

2026-09-22

13:44:45

Sophia Williams

Due to the high volume of messages, our team needs time to respond. To prevent spamming, you cannot write further until your assigned agent replies. We kindly ask for your patience.

2026-09-22

13:44:45

// Get the selected language from the URL or default to English $lang = isset($_GET['lng']) ? htmlspecialchars($_GET['lng']) : 'EN'; $trans = getTranslation($lang); require 'php/db_connect.php'; $sql = "SELECT * FROM support WHERE ticket_number='".trim($_GET['token'])."'"; $result = mysqli_query($conn, $sql); $person=''; if (mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { $person = $row['support_person']; $saql = "SELECT * FROM support_messages WHERE ticket_number='".trim($_GET['token'])."' LIMIT 1"; $ressult = mysqli_query($conn, $saql); if (mysqli_num_rows($ressult) > 0) { // output data of each row while($reow = mysqli_fetch_assoc($ressult)) { $message = $reow['message']; $stamp_time = $reow['stamp_time']; } } else { // echo "0 results"; } // Create a DateTime object from the timestamp $dateTime = new DateTime($stamp_time); // Get the date and time separately $date = $dateTime->format('Y-m-d'); $time = $dateTime->format('H:i:s'); } } else { // echo "0 results"; } mysqli_close($conn); // Load the JSON data from the file $jsonFile = 'parts/Customer_Support.json'; // Path to your JSON file $jsonData = file_get_contents($jsonFile); $customers = json_decode($jsonData, true); // Function to search for the customer by name and return the image URL function getCustomerImage($fullName, $customers) { // List of possible language keys for first and last names $nameKeys = ['EN', 'RS', 'CN', 'ES', 'TR', 'FR', 'IT', 'DE', 'RU', 'JP']; // Loop through each customer foreach ($customers as $customer) { // Check each combination of first and last names in different languages foreach ($nameKeys as $key) { // Construct the full name for this language key $customerFullName = $customer["first_name_$key"] . ' ' . $customer["last_name_$key"]; // If the full name matches, return the image URL if ($fullName === $customerFullName) { return $customer['image_url']; } } } // If no match is found, return a default or error message return 'Image not found'; } // This is the input full name you are searching for $imageUrl = getCustomerImage($person, $customers); $languageCode = isset($_GET['lng']) ? strtoupper($_GET['lng']) : ''; ?> Contact Center | Kraford

24/7 Support

Give away

Cart

User