My wiki (which is just a bunch of help pages authored by me that are for advanced users of algebra.com), was protected from spammers by only allowing registered users to make edits (and not allowing to register).
It worked great.
Then I upgraded it and forgot to make same permissions changes. A year later I looked at the site and it was totally infested by spammers.
I cleaned up quite a few pages, but there are some obscure ones that I may have missed.
Is there some SQL command or some such to find the spammed pages?
i
Then I upgraded it and forgot to make same permissions changes. A year later I looked at the site and it was totally infested by spammers.
I cleaned up quite a few pages, but there are some obscure ones that I may have missed.
Is there some SQL command or some such to find the spammed pages?
This all depends on what was added. The easiest starting point would probably be the number of external links on a page, substracting the ones linking to algebra.com
example query: select page_namespace, page_title, count(el_from) from page right join externallinks on page_id=el_from where el_index not like 'http://com.algebra.%' group by el_from order by count(el_from) desc;
Might be interesting to scan for bloated link pages, too :)
--valhallasw
On 09/08/07, Igor Chudov ichudov@algebra.com wrote:
Is there some SQL command or some such to find the spammed pages?
Install the SpamBlacklist extension, and use the cleanup script it provides.
Rob Church
wikitech-l@lists.wikimedia.org