OSDev.org

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.

FWIW, I managed to get a working snapshot of the Wiki, uncorrupted, available at http://www.rootdirectory.de/solar/wiki.zip. Feels much better now.

Since the Wiki has recovered, I'm taking the static HTML version offline again.

It happened again. :'(

@#$)(*@ spammers!! >:(

...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.

I can probably write something.

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.

I'll crank up the info you need tonight (my work blocks ssh so I cant get into my box) and send it with all relevant info.

Great, thanks.

Edit: All further talk on the wiki issues in WikiIssues or the OS FAQ thread, please.