Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/wwwroot/globify.live/chatscript/fns/realtime/

View File Name : last_seen_by_recipient.php

<?php

$data["last_seen_by_recipient"] = filter_var($data["last_seen_by_recipient"], FILTER_SANITIZE_NUMBER_INT);

if (empty($data["last_seen_by_recipient"])) {
    $data["last_seen_by_recipient"] = 0;
}

$columns = $join = $where = null;

$columns = ['private_conversations.private_conversation_id'];

$where["OR"]["AND #first_query"] = [
    "private_conversations.initiator_user_id" => $data["user_id"],
    "private_conversations.recipient_user_id" => $current_user_id,
];
$where["OR"]["AND #second_query"] = [
    "private_conversations.initiator_user_id" => $current_user_id,
    "private_conversations.recipient_user_id" => $data["user_id"],
];

$where["LIMIT"] = 1;
$private_conversation_id = DB::connect()->select('private_conversations', $columns, $where);

if (isset($private_conversation_id[0])) {
    $private_conversation_id = $private_conversation_id[0]['private_conversation_id'];

    $columns = $join = $where = null;
    $columns = ['private_chat_messages.private_chat_message_id'];
    $where = [
        'private_chat_messages.private_conversation_id' => $private_conversation_id,
        'private_chat_messages.read_status' => 1,
        'private_chat_messages.user_id' => $current_user_id,
        'ORDER' => ["private_chat_messages.private_chat_message_id" => "DESC"],
        "LIMIT" => 1
    ];

    $last_seen_by_recipient = DB::connect()->select('private_chat_messages', ['private_chat_message_id'], $where);

    if (isset($last_seen_by_recipient[0])) {
        $last_seen_by_recipient = $last_seen_by_recipient[0]['private_chat_message_id'];

        if ((int)$last_seen_by_recipient !== (int)$data["last_seen_by_recipient"]) {
            $result['last_seen_by_recipient']['user_id'] = $data["user_id"];
            $result['last_seen_by_recipient']['message_id'] = $last_seen_by_recipient;
            $escape = true;
        }
    }
}