Nextcloud

Next cloud info.

If you want to have a custom timeout (override) on a public share link.

# find the share id in the oc_share table
select * from oc_share where id = 247;
# update it to some date in the future
update oc_share SET expiration = '2100-01-01' WHERE id = 247;

If you want to change the share URL, you can make the token custom up to 32 char

# find the share id in the oc_share table
select * from oc_share where id = 247;
# set the token ID, but ensure it's unique! 
update oc_share SET token = 'incoming-files' WHERE id = 247;

Nextcloud talk/chat. Some times you need delete coments or edit them. This is not allowed in the client for old messages. This can be done in the db

from the /call/<token> take the <token> and use it to find the chat ID
select oc_comments.id, actor_id,creation_timestamp,message  from oc_talk_rooms INNER JOIN oc_comments on oc_talk_rooms.id = oc_comments.object_id where token = '<token>';
# then take the oc_comments.id of the message ton confirm it
select * from oc_comments where id = 307;
# now update it or set it to  to delete it
update oc_comments SET message = 'NEW MESSAGE HERE' WHERE id = 307;