#4349 New Project Spam Moderation

v1.0.0
closed
nobody
42cc (432)
General
Dave Brondsema
2015-08-20
2012-06-12
Rich Bowen
No

Create a new page under /nf/admin/ which lists new projects. Order by _id, so that new ones are listed first. Limit 100 by default, and use the standard pagination widget so that more results can be accessed easily. Omit projects whose name starts with 'u/'. This can be done as a regexp in the query (mongo is effecient on regexps if they begin with '^' and the field is indexed)

Show these columns:

  • date & time (get it from the _id ObjectId)
  • shortname
  • name
  • short_description
  • summary
  • deleted
  • external_homepage
  • list of admin usernames

All that content can make it pretty wide, so omit the left nav on this page. If necessary to make it readable, set certain columns to certain widths, use a smaller font, make each row have 2 rows of content, etc.

Add a checkbox at the beginning of each row, and an empty <div> underneath the table. Whenever a project is checked, add the project shortname to the <div> so it makes a list of all the names. Separate the shortnames by spaces. (We will use this to copy/paste to our internal deletion tool)

Related

Tickets: #4349

Discussion

  • Dave Brondsema

    Dave Brondsema - 2012-07-09
    • labels: --> 42cc
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1 +1,16 @@
-I'd like an interface that lists new projects created within the last X hours (24? 48?) with  simple one-button way to mark projects as spam. At the moment, I get a daily email from a script that runs off of my database snapshot. By then, many of the projects have already been purged, and many of the rest require only a momentary glance to see that they're spammy. However, I think it would be very hard to do any kind of automated spam filtering on this - someone needs to look at it.
+Create a new page under /nf/admin/ which lists new projects.  Order by _id, so that new ones are listed first.  Limit 100 by default, and use the standard pagination widget so that more results can be accessed easily.  Omit projects whose name starts with 'u/'.  This can be done as a regexp in the query (mongo is effecient on regexps if they begin with '^' and the field is indexed)
+
+Show these columns:
+
+* date & time (get it from the _id ObjectId)
+* shortname
+* name
+* short_description
+* summary
+* deleted
+* external_homepage
+* list of admin usernames
+
+All that content can make it pretty wide, so omit the left nav on this page.  If necessary to make it readable, set certain columns to certain widths, use a smaller font, make each row have 2 rows of content, etc.
+
+Add a checkbox at the beginning of each row, and an empty `<div>` underneath the table.  Whenever a project is checked, add the project `shortname` to the `<div>` so it makes a list of all the names.  Separate the shortnames by spaces.  (We will use this to copy/paste to our internal deletion tool)
    • milestone: limbo --> forge-backlog
     

  • Yaroslav Luzin - 2012-07-10

    created #110: [#4349] Create a new page under /nf/admin/ which lists new projects (2cp)

     

    Related

    Tickets: #4349

  • Yaroslav Luzin - 2012-07-10
    • status: open --> in-progress
     

  • Yaroslav Luzin - 2012-07-12

    closed #110, see 42cc_4349 branch

    • status: in-progress --> code-review
     

  • Dave Brondsema

    Dave Brondsema - 2012-07-13
    • qa: Cory Johns
     

  • Dave Brondsema

    Dave Brondsema - 2012-07-16
    • status: code-review --> in-progress
    • qa: Cory Johns --> Dave Brondsema
     

  • Dave Brondsema

    Dave Brondsema - 2012-07-16

    The test only checks for non-authorized users. There should be a test using an admin, so the page is actually rendered.

    The regex for projects starting with 'u/' doesn't work for me. I tried it at http://regexpal.com/ and in the mongo shell in an actual query. Also my statement regexps starting with ^ being fast on mongo doesn't apply either, since we're looking for negative matches. I guess it would be better to just query for the Neighborhood where name=='Users', and filter out projects with that neighborhood id.

    A small feature addition: please make the project name be a link to the project's url.

     

  • Yaroslav Luzin - 2012-07-17

    created #119: [#4349] Write tests and small amendments (1cp)

     

    Related

    Tickets: #4349

  • Yaroslav Luzin - 2012-07-18

    closed #119, pushed changes into 42cc_4349

    • status: in-progress --> code-review
     

  • Dave Brondsema

    Dave Brondsema - 2012-07-18
    • status: code-review --> closed
     

  • Dave Brondsema

    Dave Brondsema - 2012-07-18
    • milestone: forge-backlog --> forge-jul-27
     

Log in to post a comment.