matteocontrini
Ho fatto una prova "stupida" in locale (con flarum-move-posts 0.1.7 e docker-flarum 1.3.0)
Ho creato due utenti, 1 admin e 2 user.
Admin ha creato una discussione con 15 messaggi, quindi li ha letti tutti, user ne ha letti solo 3:
MariaDB [flarum]> select * from flarum_discussion_user;
+---------+---------------+---------------------+-----------------------+--------------+
| user_id | discussion_id | last_read_at | last_read_post_number | subscription |
+---------+---------------+---------------------+-----------------------+--------------+
| 1 | 1 | 2022-09-01 09:28:52 | 15 | NULL |
| 2 | 1 | 2022-09-01 09:28:36 | 3 | NULL |
+---------+---------------+---------------------+-----------------------+--------------+
Admin ha spostato 3 messaggi (2, 4, 14) nella discussione 2:
MariaDB [flarum]> select * from flarum_discussion_user;
+---------+---------------+---------------------+-----------------------+--------------+
| user_id | discussion_id | last_read_at | last_read_post_number | subscription |
+---------+---------------+---------------------+-----------------------+--------------+
| 1 | 1 | 2022-09-01 09:28:52 | 15 | NULL |
| 2 | 1 | 2022-09-01 09:28:36 | 3 | NULL |
+---------+---------------+---------------------+-----------------------+--------------+
Entrambi hanno fatto refresh della home del forum e aperto la discussione 2:
MariaDB [flarum]> select * from flarum_discussion_user;
+---------+---------------+---------------------+-----------------------+--------------+
| user_id | discussion_id | last_read_at | last_read_post_number | subscription |
+---------+---------------+---------------------+-----------------------+--------------+
| 1 | 1 | 2022-09-01 09:28:52 | 15 | NULL |
| 1 | 2 | 2022-09-01 09:29:59 | 13 | NULL |
| 2 | 1 | 2022-09-01 09:28:36 | 3 | NULL |
| 2 | 2 | 2022-09-01 09:32:29 | 13 | NULL |
+---------+---------------+---------------------+-----------------------+--------------+
Ho resettato il contatore per tutti gli utenti. user ha aperto una nuova tab e riaperto la discussione 2:
MariaDB [flarum]> select * from flarum_discussion_user;
+---------+---------------+---------------------+-----------------------+--------------+
| user_id | discussion_id | last_read_at | last_read_post_number | subscription |
+---------+---------------+---------------------+-----------------------+--------------+
| 1 | 1 | 2022-09-01 09:28:52 | 1 | NULL |
| 1 | 2 | 2022-09-01 09:29:59 | 1 | NULL |
| 2 | 1 | 2022-09-01 09:28:36 | 1 | NULL |
| 2 | 2 | 2022-09-01 09:38:41 | 13 | NULL |
+---------+---------------+---------------------+-----------------------+--------------+
Questo è il contenuto della tabella posts dopo tutti questi passaggi:
MariaDB [flarum]> select id, discussion_id, number from flarum_posts;
+----+---------------+--------+
| id | discussion_id | number |
+----+---------------+--------+
| 1 | 1 | 1 |
| 3 | 1 | 3 |
| 5 | 1 | 5 |
| 6 | 1 | 6 |
| 7 | 1 | 7 |
| 8 | 1 | 8 |
| 9 | 1 | 9 |
| 10 | 1 | 10 |
| 11 | 1 | 11 |
| 12 | 1 | 12 |
| 13 | 1 | 13 |
| 15 | 1 | 15 |
| 2 | 2 | 1 |
| 4 | 2 | 3 |
| 14 | 2 | 13 |
+----+---------------+--------+