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