[Systems] Trac spam cleanup

[Sascha Silbe]

On Fri, Jan 08, 2010 at 06:59:22PM -0500, Bernie Innocenti wrote:

> <silbe> bernie_: can you issue "delete from ticket_change where author
> in ('nikecitycn', 'sunrise');" on the trac db (using sqlite3), please?
> from looking at the database schema it should cause no side effects 
> but
> i don't know Trac well so would recommend to do a backup of the
> database (file) first.
>
> Done. Thanks for reporting this.
Thanks! Here's another one:

delete name from wiki where name glob '[0-9][0-9][0-9]_buy_*';

All other SPAM pages have already been deleted using the web interface. 
If you notice any remaining SPAM (e.g. ticket comments) please prod me.

CU Sascha

-- 
http://sascha.silbe.org/
http://www.infra-silbe.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 489 bytes
Desc: Digital signature
Url : http://lists.sugarlabs.org/private/systems/attachments/20100115/ef2d6275/attachment.pgp