3 Sep
2007
3 Sep
'07
3:11 p.m.
BTW, why can't I just delete the comments instead of changing the object
type ? I don't mind loosing these comments, can I damage any database key
constraint ?
2007/9/3, Raffaello Pelagalli <raffaello(a)xwiki.com>om>:
"Antonio Goncalves" <antonio.mailing(a)gmail.com> writes:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users