From e94f99bdad8f78edac4824698855997cb149835f Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@users.mediawiki.org>
Date: Mon, 4 Sep 2006 13:08:59 +0000
Subject: [PATCH] * Add a quickie script dumpSisterSites.php for generating a
 page list in the   format for WSR-1 SisterSites support

---
 RELEASE-NOTES                   |  2 ++
 maintenance/dumpSisterSites.php | 49 +++++++++++++++++++++++++++++++++
 2 files changed, 51 insertions(+)
 create mode 100644 maintenance/dumpSisterSites.php

diff --git a/RELEASE-NOTES b/RELEASE-NOTES
index 2bec957f76..68af55c203 100644
--- a/RELEASE-NOTES
+++ b/RELEASE-NOTES
@@ -178,6 +178,8 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN
   read the main page in the first place
 * (bug 7188) Fix minor borkage in HTMLForm
 * (bug 6675) Replaced message 'watchthis' with new message 'watchthisupload in Special:Upload
+* Add a quickie script dumpSisterSites.php for generating a page list in the
+  format for WSR-1 SisterSites support
 
 
 == Languages updated ==
diff --git a/maintenance/dumpSisterSites.php b/maintenance/dumpSisterSites.php
new file mode 100644
index 0000000000..50e121e604
--- /dev/null
+++ b/maintenance/dumpSisterSites.php
@@ -0,0 +1,49 @@
+<?php
+/**
+ * Quickie page name dump script for SisterSites usage.
+ * http://www.eekim.com/cgi-bin/wiki.pl?SisterSites
+ *
+ * Copyright (C) 2006 Brion Vibber <brion@pobox.com>
+ * http://www.mediawiki.org/
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with this program; if not, write to the Free Software Foundation, Inc.,
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ * http://www.gnu.org/copyleft/gpl.html
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
+
+require_once( 'commandLine.inc' );
+
+$dbr = wfGetDB( DB_SLAVE );
+$dbr->bufferResults( false );
+$result = $dbr->select( 'page',
+	array( 'page_namespace', 'page_title' ),
+	array(
+		'page_namespace'   => NS_MAIN,
+		'page_is_redirect' => 0,
+	),
+	'dumpSisterSites' );
+
+while( $row = $dbr->fetchObject( $result ) ) {
+	$title = Title::makeTitle( $row->page_namespace, $row->page_title );
+	$url = $title->getFullUrl();
+	$text = $title->getPrefixedText();
+	echo "$url $text\n";
+}
+
+$dbr->freeResult( $result );
+
+?>
-- 
2.20.1