I’ve installed the discourse-moderator-attention plugin and had two questions:
Is there a quick query that could set all the 70,000+ previous posts to “patrolled” so I can keep track of only new ones?
It looks like the plugin runs this SQL:
CREATE TABLE moderator_post_views( post_id int not null, user_id int not null, last_viewed timestamp without time zone not null )
Would this update be a safe way to do it? I’m not sure if I have the syntax correct.
INSERT INTO moderator_post_views(id, 1, make_date SET DEFAULT now()) ( SELECT id FROM posts )
I’m wondering if anyone else is seeing missing icons on the “Latest” view or if there is something wrong with my install. I’ve checked in multiple browsers with browser extensions disabled.
This is the HTML from the browser inspector:
<div class="topic-statuses"> <a href="/t/slug-is-here/12345/1" title="Topic contains posts that have not been reviews by moderators" class="topic-status "> <svg class="fa d-icon d-icon-asterisk svg-icon svg-string" xmlns="http://www.w3.org/2000/svg"> <use xlink:href="#asterisk"></use> </svg> </a> </div>
In the CSS, it looks like it might be targeting
.fa-asterisk, but in the HTML above, it looks like the output is
d-icon-asterisk. I’m not sure if that is the problem though.