Jack Bates wrote:
I'm working on a (currently read-only) Subversion interface to MediaWiki: http://www.mediawiki.org/wiki/WebDAV
It's implemented in PHP and lets me checkout wiki pages using a Subversion client, or as Subversion externals: http://svnbook.red-bean.com/en/1.4/svn.advanced.externals.html
I hope I'll eventually succeed in using this interface to edit pages offline, using Emacs version control mode, or Subclipse.
Today I'm stuck on an SQL issue. To implement the Subversion update-report, I need a list of pages which changed since revision X, and whether those pages have any revisions before X (whether those pages are "new").
You seem to be treating as svn version, the revision number. What about also using the last ArticleId when comparing with an old revision? The 'page' has some revision before X if it belongs to a page_id before Y.