Could a dev please think about creating a mod page that shows a list of top users who have 'http' in their answers please. I think this would help us find those who just link to their own pages and shouldn't be too complex to do, I don't think anyway.

2 Answers 2


That kind of thing can be done with the right query over on data-explorer, but my SQL-fu is too weak to come up with it myself. Once such a query has been identified, it should be easy to slap it into either mod-tools or /review.

  • There's already at least one query on data-explorer that does this; I used it a while ago to find a few spammy users. If I get around to finding it again, I'll post it as an answer.
    – womble Mod
    Commented Aug 26, 2011 at 21:39
  • I imagine there is, it therefore would be less hard to just add as a mod tool page then.
    – Chopper3
    Commented Aug 27, 2011 at 8:45

This sounds useful but might be too blunt an instrument -- A lot of valid/non-spam answers have links in them (I frequently link people to man pages, the O'Reilly page for "DNS and BIND", etc.).

Sorting users by "Percent of answers that contain a link" could be a good start. "Percent of answers that contain the SAME link" would be better, but probably harder to code up in an efficient way (?).

  • It would be used as a search tool, not an auto-destroy button :)
    – Chopper3
    Commented Aug 26, 2011 at 18:00
  • I figured that, but we should strive for a clean tool (to whatever extent it's practical) - no sense having to wade through 20 screens of crap to find spammers :)
    – voretaq7
    Commented Aug 26, 2011 at 18:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .