Deleting change does not update 'last modified' date

[theultramage@…]

I use this plugin for deletion of spam comments in tickets. I noticed that even though I delete a comment, the 'last modified' date doesn't revert to the last posting date, and the 2 year old ticket stays on top of the list.

This might cause some confusion, so I suggest adjusting the date when the comment to be deleted is the most recent one.

[theultramage@…]

After getting a bunch of ancient tickets bumped up to the first page by spam, I used Firefox's "SQLite Manager" plugin to run the following queries to correct the "last modified" column:

UPDATE ticket
SET   changetime = (SELECT MAX(time) FROM ticket_change WHERE ticket = id)
WHERE changetime > (SELECT MAX(time) FROM ticket_change WHERE ticket = id)

UPDATE ticket
SET   changetime = time
WHERE changetime != time
AND NOT EXISTS (SELECT 1 FROM ticket_change WHERE ticket = id)

[Ryan J Ollos]

Closing tickets for deprecated plugin.