Page MenuHomeGitPull.it

Fix 122969 spam comments in 3tolo.com
Closed, ResolvedPublic

Description

$ SELECT comment_approved, COUNT( * ) AS total FROM  wp_comments WHERE comment_post_ID = 467 GROUP BY comment_approved;
+------------------+--------+
| comment_approved | total  |
+------------------+--------+
| 0                | 122969 |
| 1                |      3 |
+------------------+--------+
2 rows in set (25.414 sec)

Event Timeline

valerio.bozzolan triaged this task as Unbreak Now! priority.Tue, Mar 30, 11:44
valerio.bozzolan created this task.
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%carcinoma%';
Query OK, 18118 rows affected (32.907 sec)
valerio.bozzolan renamed this task from Fix spam in 3tolo.com to Fix 122969 spam comments in 3tolo.com.Tue, Mar 30, 11:46
valerio.bozzolan shifted this object from the S1 Public space to the Restricted Space space.
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%medical%' OR comment_content LIKE '%vascular%' OR comment_content LIKE '%syndrome%';
Query OK, 71295 rows affected (1 min 20.884 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%medical%' OR comment_content LIKE '%vascular%' OR comment_content LIKE '%syndrome%';
Query OK, 71295 rows affected (1 min 20.884 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%BITCOIN%' OR comment_content LIKE '%blood%' OR comment_content LIKE '%sexy%';
Query OK, 8337 rows affected (21.832 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%cialis%' OR comment_content LIKE '%timeblock%' OR comment_content LIKE '%thesis%';
Query OK, 3118 rows affected (17.915 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%dating%' OR comment_content LIKE '%vagina%' OR comment_content LIKE '%adult%' OR comment_content LIKE '%girl%' OR comment_content LIKE '%ф%';
Query OK, 3683 rows affected (16.170 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%zithromax%' OR comment_content LIKE '%б%' OR comment_content LIKE '%.ru%' OR comment_content LIKE '%porno%' OR comment_content LIKE '%bit.ly%';
Query OK, 3036 rows affected (13.854 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%и%' OR comment_content LIKE '%neurontin%' OR comment_content LIKE '%viagra%' OR comment_content LIKE '%ロ%' OR comment_content LIKE '%cancerous%';
Query OK, 1804 rows affected (19.326 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_approved != 1 AND (comment_content LIKE '%https://%' OR comment_content LIKE '%http://%');
Query OK, 6139 rows affected, 19 warnings (16.839 sec)
valerio.bozzolan shifted this object from the Restricted Space space to the Restricted Space space.Tue, Mar 30, 12:07
valerio.bozzolan shifted this object from the Restricted Space space to the S1 Public space.Wed, Mar 31, 07:39