All off topic discussions go here. Everything from the funny thing your cat did to your favorite tv shows. Non-programming computer questions are ok too.
Pype.Clicker wrote:And no, i have no recent dump myself: all my attemps to get a snapshot or a dump of the wiki just resulted in corrupted zip files. All i could ever gather are XHTML dumps.
...and restoring the Wiki from backup file failed royally, further screwing up the edit history. DAMN!
Don't bother with manual edits, that sucker will probably raid again.
df, is there some way you can make your "kill everything younger that X" SQL into something that can be triggered remotely (after sufficient authorization, of course)? I'm thinking of some PHP script behind .htaccess... that way, the mods stand a chance of at least keeping that spam script, without you having to do it each time.
Every good solution is obvious once you've found it.
all it involves is knowing the pagename of the last good edit, getting its page id, finding mtime from its lage page revision and deleteing all pages where mtime > X (and purge the cache too)
I dont particuarly want to lock all pages... I guess this is nice and simple cleanup. I have not written php in a looong time. I'll see what I can do.
df wrote:I have not written php in a looong time. I'll see what I can do.
I'll see if I can get a fellow PHP coder interested in this.... {picks up the phone}
Edit: He'd be willing to do this. He needs: a) the PhpWiki version; b) the PHP version; c) the MySQL version used, to make sure he doesn't use features of versions that aren't there. Ideal would be a mysqldump of the database (for testing). If that's fine for you, send it to me (solar (at) rootdirectory (dot) de) (or send me the URL where to download the dump), I'll forward the stuff, and we have our mass de-spammer done in short order.
Every good solution is obvious once you've found it.
