On Mon 18 Jul 2005, Rev Simon Rumble simon@rumble.net wrote:
(turn on minor changes) http://engineer.openguides.org/?RecentChanges
I've been massively spammed by some Wikispamming bastards. What's a quick way to delete all these nodes?
Your recent changes are really really slow. I can't actually see them at all because I get timed out before the page loads. Have you got your indexes set up? (Explanation of that is somewhere in the list archives; I think in a conversation with jimbo.)
If they're the same people who hit the vegan guide to Oxford recently then try nuking everything with '&#' in the name of the node. That got everything bar four or five pages for me.
Ah, it's just managed to load. Nuke everything with 'supercasino' in the node name. In psql this is something like
delete from node where name like '%supercasino%'; delete from content where name like '%supercasino%'; delete from metadata where name like '%supercasino%';
Syntax is probably the same for other databases. Insert the usual warning to back up the database before you do this in case you typo.
Kake