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 <[EMAIL PROTECTED]>:
>
> "Antonio Goncalves" <[EMAIL PROTECTED]> 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
>
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to