Pruning Spam Pages In Php Wiki

Instructions

I have configured this wiki so that it uses LDAP and only logged in accounts can add and edit pages. This reduces spam significantly, but there are two plugins that by-pass this login requirement:

• Add Comment Plugin
• Wiki Blog Plugin

After I noticed a lot of spam with urls simalar to the above I disabled the plugins and then ran some SQL to detect and delete these pages in mass.

To delete all pages that match a certain name in phpWiki using SQL. First I found that the phpwiki uses two tables, page, which saves the latest version cached, and version, which saves the content of every version. They are linked by their common 'id' field.

  SELECT count(id) FROM page WHERE pagename LIKE "WikiBlogPlugin/Blog/2%";

gave me 1425, heck of a lot of spam!

  SELECT count(version.id) from version INNER JOIN page ON version.id = page.id WHERE page.pagename LIKE "WikiBlogPlugin/Blog/2%";

gave me 1426, which means that their was a duplicate version entry.

So, then I deleted the version entries that had the same id as the pages with pagename that matched WikiBlogPlugin/Blog/2...."

  DELETE version FROM version INNER JOIN page ON version.id = page.id WHERE page.pagename LIKE "WikiBlogPlugin/Blog/2%";

  1426 deleted

And, then I deleted the page entries that had the same pagename:

  DELETE FROM page WHERE pagename LIKE "WikiBlogPlugin/Blog/2%";

  1425 deleted

Then I did all the above using "AddCommentPlugin/Comment/20%" as my search string.

Notes

Admin