CIMEvent::updateChatUserCounter

static function updateChatUserCounter($userId): void
{
	global $DB;
	$sql = "
		UPDATE b_im_chat C
		INNER JOIN b_im_relation R ON C.ID = R.CHAT_ID
		SET C.USER_COUNT = (
			SELECT COUNT(1)
			FROM b_im_relation R1
			INNER JOIN b_user U ON R1.USER_ID = U.ID
			WHERE R1.CHAT_ID = C.ID AND U.ACTIVE = 'Y'
		)
		WHERE R.MESSAGE_TYPE NOT IN ('".IM_MESSAGE_SYSTEM."','".IM_MESSAGE_PRIVATE."')
		AND R.USER_ID = ".$userId."
	";
	$DB->Query($sql, true, "File: ".__FILE__."
Line: ".__LINE__);
}