TicketDelete actually does this kind of value restoration already.
Using the checkboxes, select all changes (not just comments) that you
want removed, and it will make sure the ticket table reflects the
current state.
--Noah
On Jun 25, 2006, at 12:43 PM, Alexander Shopov wrote:
* trac-admin $TRAC_ENV ticket remove <id-of-spam-only-ticket>
This is trivial even now - just delete everything with the ticket#
from TICKET_CHANGE and set the necessary values in TICKET.
* http://trac-hacks.org/wiki/TicketDeletePlugin on Trac Hacks,
which also has the ability
to delete specific comments
Changes where only comments are added are also easy to get rid of -
just delete them from TICKET_CHANGE - comments do not have the
oldvalue-newvalue chain.
However there are cases when a spammer changes other fields with or
without changing the comment.
So I am still back to the drawing board - not knowing enough SQL +
sqlite-supported procedural language to do this.
I would believe that similar work will be necessary in cases beyond
spam fighting (filtering out changes based on some criteria). This
is a problem not bound to this oldish version of TRAC but will be
useful in future as well.
Yes - it is my problem but I think that no matter the anti-spam
measures - public sites will always have spam that needs to be purged.
Kind regards:
al_shopov
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
