in reply to Re: Dealing with spam users
in thread Dealing with spam users

There already is such a script to look at Users with outbound links, and the users get locked regularly (but manually).

Replies are listed 'Best First'.
Re^3: Dealing with spam users
by LanX (Saint) on Feb 25, 2022 at 22:26 UTC
    > There already is such a script to look at Users with outbound links, and the users get locked regularly (but manually).

    Does it mean we can stop reporting spam in homenodes / scratchpads because you find them anyway?

    I just wanted to share a free nodelet-hack which makes reporting easier (2 clicks)

    Cheers Rolf
    (addicted to the Perl Programming Language :)
    Wikisyntax for the Monastery

      So far I'm not aware of spam homenodes that were not highlighted by the script, so yes, you can stop reporting spam in homenodes from my point of view.

Re^3: Dealing with spam users
by LanX (Saint) on Dec 05, 2020 at 14:47 UTC
    Hm... but this SQL-Query doesn't check if someone edited an old node of his, right?

    Cheers Rolf
    (addicted to the Perl Programming Language :)
    Wikisyntax for the Monastery

      Why wouldn't it?

      Of course it does. User and scratchpad nodes to have a field that they were edited recently. This field is used for example by the Recently Updated Home Nodes node, and also by that query.

        > Why wouldn't it?

        I don't know the DB schema°, it looked to me like "user nodes" meant "home nodes" not regular posts like e.g. my oldest node.

        Cheers Rolf
        (addicted to the Perl Programming Language :)
        Wikisyntax for the Monastery

        °) and I'm not aware of any documentation for pmdevs