2007/9/3, Raffaello Pelagalli <raffaello@xwiki.com>:

"Antonio Goncalves" <antonio.mailing@gmail.com > writes:

> Hi,
>
> My XWiki website has been spammed with more than 200 (porn) comments on the
> main page. I didn't want to put any access restriction on comments thinking
> that the world was a better place and that anybody could comment :o)  Well, I
> was wrong and I'm gonna change the user rights.
>
> How can I safely delete all these comments (by hand it will take me ages) ?
>
> Thanks,

Hi,

An easy way to do that, without loosing anything is to change the object type of
each spam comments.

For exemple, you can execute something like that on your database server :

update xwikiobjects, xwikilargestrings set
      XWO_CLASSNAME='XWiki.XWikiComments_spam' where
      XWO_CLASSNAME='XWiki.XWikiComments' and XWL_ID=XWO_ID and
      XWL_VALUE like '%viagra%';

Best regards,
--
Raffaello Pelagalli
XPertNet - XWiki.com
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users