How does a friendica instance get the "contact id" of a visitor? / Need SQL help

Marek Bachmann 1 Jahr her friendica

How does a friendica instance get the "contact id" of a visitor? / Need SQL help

Hi !Friendica Developers !Friendica Support

I am digging in the problem that restricted image / images shared with a specific group or user are not accessible, see https://github.com/friendica/friendica/issues/12412

Now I think that I found at least two issues:

First:
The allow_cid filed in the photo table seems not correctly be set. For an image shared with followers only, the result is:

 select `accessible`,allow_cid,allow_gid from photo where `resource-id` = '100228443963b9a03d31378698994057';
+------------+-----------+-----------+
| accessible | allow_cid | allow_gid |
+------------+-----------+-----------+
|          1 | <3>       | <~>       |
|

 select `accessible`,allow_cid,allow_gid from photo where `resource-id` = '100228443963b9a03d31378698994057';
+------------+-----------+-----------+
| accessible | allow_cid | allow_gid |
+------------+-----------+-----------+
|          1 | <3>       | <~>       |
|          1 | <3>       | <~>       |
|          1 | <3>       | <~>       |
+------------+-----------+-----------+

Second:
The getRemoteContactID method returns a value > 0 iff the page is reloaded completely (ctrl + f5) otherwise 0.

Accordingly, I have two questions:

Does anyone know how the "visitor" is identified, in more detail their contact-id (cid), on the local instance?
To the mysql pros: Can someone provide me the sql command to update the allow_cid filed in the photo table? This would make by debugging efforts much easier .

Thank you very much, helping me to support

Sending images to a group. Images are set to private and are not displayed · Issue #12412 · friendica/friendica

[ x ] I have searched open and closed issues for duplicates Bug Description Sending images to a group. Images are set to private and are not displayed It has already been noticed elsewhere that all...

^GitHub

!Friendica Support !Friendica Developers

Kassel

Marek Bachmann 1 Jahr her friendica

For further discussion / remark to myself:

https://github.com/friendica/friendica/blob/develop/src/App.php#L605-L610

could be a good start for "visitor" is identified.

$requester = HTTPSignature::getSigner('', $_SERVER);
if (!empty($requester)) {
	Profile::addVisitorCookieForHandle($requester);
}

The $requester is only filled on full reload (ctrl + f5)