PhpWiki de AsturLiNUX - Eliminar Spam Del Gallery

Eliminar montones de comentarios Spam del Gallery no es trivial, puesto que si tocas directamente la base de datos, posiblemente dejes el Gallery en un estado inconsistente. Inspirado por http://gallery.menalto.com/node/55331, he preparado un script SQL que elimina gran parte del spam:

CREATE TEMPORARY TABLE tmptable
SELECT g_id
FROM `g2_Comment` gc
WHERE
gc.g_subject like '%url%' or
gc.g_subject like '%http%' or
gc.g_subject like '%personals%' or
gc.g_subject like '%poker%' or
gc.g_subject like '%blackjack%' or
gc.g_subject like '%gambling%' or
gc.g_subject like '%viagra%' or
gc.g_subject like '%phentermine%' or
gc.g_subject like '%casino%' or
gc.g_subject like '100%' or
gc.g_subject like '%slots%' or
gc.g_subject like '%Cialis%' or
gc.g_subject like '%url%' or
gc.g_subject like '%thias website%' or
gc.g_comment like '%http%' or
gc.g_comment like '%personals%' or
gc.g_comment like '%poker%' or
gc.g_comment like '%blackjack%' or
gc.g_comment like '%gambling%' or
gc.g_comment like '%viagra%' or
gc.g_comment like '%phentermine%' or
gc.g_comment like '%casino%' or
gc.g_comment like '100%' or
gc.g_comment like '%slots%' or
gc.g_comment like '%Cialis%' or
gc.g_comment like '%999999999.txt%' or
gc.g_comment like '%href%' ;


DELETE g2_Entity
FROM g2_Entity
INNER JOIN tmptable ON g2_Entity.g_id = tmptable.g_id;


DELETE g2_ChildEntity
FROM g2_ChildEntity
INNER JOIN tmptable ON g2_ChildEntity.g_id = tmptable.g_id;

DELETE g2_Comment
FROM g2_Comment
INNER JOIN tmptable ON g2_Comment.g_id = tmptable.g_id;

DROP TEMPORARY TABLE tmptable;

No nos hacemos responsables de la pifia que puedas montar si usas este script :)

EliminarSpamDelGallery