# 静音阅读时间少于1分钟的用户

**URL:** <https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830>\
**Category:** Support\
**Created:** [2019年三月28日 16:29 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830 "2019-03-28T16:29:52Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![slackmoehrle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/slackmoehrle/32/82215_2.png) [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)\
**Post date:** [2019年三月28日 16:29 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/1 "2019-03-28T16:29:52Z")

</div>

I’m still fighting SPAM. Many hundreds of fake accounts being created. All with \<1m read time. The users try to post a spam topic, but I do require post approval for new users until they reach a certain trust level.

I want to run a query that will silence users with **\<1m read time** but where is it stored? I don’t see it in the user table. What is the best way to do this?

I started with this silence users that hadn’t posted since 2017.

```sql
UPDATE users
SET silenced_till = '3019-02-01 13:00:00'
WHERE last_seen_at >= '2013-01-01' 
AND last_seen_at <= '2017-12-31'
RETURNING id, username_lower

```

---

<div class="post-metadata">

**Author:** ![Stephen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stephen/32/95011_2.png) [@Stephen](https://meta.discourse.org/u/Stephen)\
**Post date:** [2019年三月28日 16:51 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/2 "2019-03-28T16:51:15Z")

</div>

What kind of spam are you seeing? Are you using Akismet?

---

<div class="post-metadata">

**Author:** ![slackmoehrle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/slackmoehrle/32/82215_2.png) [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)\
**Post date:** [2019年三月28日 17:20 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/3 "2019-03-28T17:20:11Z")

</div>

Yup, and it isn’t catching this.

It posts where they start out talking about the topic, but then change to things like “hire is for moving”, “research papers for cheap”, etc. I obviously delete these users, but more just keep cropping up.

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2019年三月29日 01:54 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/4 "2019-03-29T01:54:00Z")

</div>

> [@slackmoehrle](#):
>
> Many hundreds of fake accounts being created. All with \<1m read time.

Over what time period are these being created? How many per day?

> [@slackmoehrle](#):
>
> The users try to post a spam topic

One simple thing to try is restrict new topic creation to TL1. This forces them into replying versus creating a new topic.

> [@slackmoehrle](#):
>
> they start out talking about the topic, but then change

Over what time period? 1 day? 1 week? Can you provide more specific examples.

---

<div class="post-metadata">

**Author:** ![slackmoehrle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/slackmoehrle/32/82215_2.png) [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)\
**Post date:** [2019年三月29日 11:50 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/5 "2019-03-29T11:50:12Z")

</div>

> [@codinghorror](#):
>
> Over what time period are these being created? How many per day?

Per week.

> [@codinghorror](#):
>
> One simple thing to try is restrict new topic creation to TL1. This forces them into replying versus creating a new topic.

I do this already, but then they just start replying to topics with their SPAM.

> [@codinghorror](#):
>
> Over what time period? 1 day? 1 week? Can you provide more specific examples.

No, in the same post.

I’ll post some examples

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2019年三月29日 19:48 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/6 "2019-03-29T19:48:15Z")

</div>

Yes, we need a lot more specifics.

---

<div class="post-metadata">

**Author:** ![slackmoehrle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/slackmoehrle/32/82215_2.png) [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)\
**Post date:** [2019年三月30日 14:46 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/7 "2019-03-30T14:46:37Z")

</div>

@codinghorror Thanks. I will start posting examples as they come in:

**Example 1:**

```plaintext
Not at all like different papers in common administration mains tests, exposition paper is actually simple to score marks. In any case, just on the off chance that you realize how to do it in the precise way! While perusing for GS papers and discretionary papers, you may complete pretty much every book. This perusing propensity is required for composing the article. The main thing which remains is the composition expertise which is expected to make a decent article. We as a whole realize that there must be an introduction, body, and end. In any case, for what reason is there such variety in the imprints that applicants at long last get? Does it happen as a result of the expertise in the English language? Or then again does it happen in light of the substance or absence of it? Or on the other hand is there any alternate way which some know and some don't? The appropriate response is "these" and no doubt a lot more factors. The most ideal approach to thrashing such issues is to rehearse a ton before composing the expositions in the test. In the event that we do as such, the great and terrible sides of our composition style can be discovered. See here to [url=https://mightyessays.com/]buy essays[/url].
It is hence that we have made an Essay Test arrangement. Obviously who else is more adept to direct this than individuals who have really experienced it! You can discover around 20 article subjects from the previous year's inquiry papers. Consider great statements and focuses to fill in each theme. Make an arrangement of the paper. It ought to be arranged in right request. Great and clear penmanship has additional imprints. The GS answers and papers ought to be written in positive soul. Silly analysis of government strategies and individuals ought to be sidestepped at any expense. 

```

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2019年三月30日 18:49 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/8 "2019-03-30T18:49:46Z")

</div>

It seems to me akismet should pick up the spam URL in that reply.

---

<div class="post-metadata">

**Author:** ![slackmoehrle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/slackmoehrle/32/82215_2.png) [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)\
**Post date:** [2019年三月30日 22:11 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/9 "2019-03-30T22:11:36Z")

</div>

It picks up maybe 2 out of 41 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)\
**Post date:** [2022年六月2日 02:47 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/10 "2022-06-02T02:47:26Z")

</div>



---

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [2022年十月27日 09:47 UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/11 "2022-10-27T09:47:10Z")

</div>