Currently the module only hides posts created after the module was installed. There is a possibility to create a back log of IPs for comments, and maybe even nodes using watchdog records, so I need to create a cron job for this.

Comments

danielb’s picture

danielb commented
Title: Back log comments » Back log posts
danielb’s picture

danielb commented
Project: Cave your trolls » IP address manager
Version: 6.x-1.0-beta1 » 6.x-1.x-dev

The feature is now part of the IP module.

danielb’s picture

danielb commented

SELECT DISTINCT uid, hostname FROM `watchdog` WHERE type = 'content' AND message = 'Comment: added %subject.';
SELECT DISTINCT uid, hostname FROM `watchdog` WHERE type = 'content' AND message = '@type: added %title.';

those are the queries, but there are more things in that table we can get IPs from, plus we'll need a way to only get comments/nodes from before the module was installed.

danielb’s picture

danielb commented

Alright I have this working in my development copy, just need to commit. Doesn't work as well as I hoped since watchdog seems to only keep the last 1000 records?

danielb’s picture

danielb commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

  • Commit a489301 on 6.x-1.x, 7.x-2.x by danielb: 
    Issue #502934 by danielb: Backlog posts.