X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialLonelypages.php;h=e652f9d4c57dd0ee72aeb757b401ee5a434a857e;hb=07aeee4da8cbb4569c48a45f167e75d55401adc1;hp=5bf4d8850f8423bedbb71abbc4a8c59f947910c3;hpb=0ee4ab374b2ca143fc7d0a7fec0456e15b743e82;p=lhc%2Fweb%2Fwiklou.git

diff --git a/includes/SpecialLonelypages.php b/includes/SpecialLonelypages.php
index 5bf4d8850f..e652f9d4c5 100644
--- a/includes/SpecialLonelypages.php
+++ b/includes/SpecialLonelypages.php
@@ -1,12 +1,22 @@
 <?php
-
-require_once( "QueryPage.php" );
-
+/**
+ *
+ * @addtogroup SpecialPage
+ */
+
+/**
+ * A special page looking for articles with no article linking to them,
+ * thus being lonely.
+ * @addtogroup SpecialPage
+ */
 class LonelyPagesPage extends PageQueryPage {
 
 	function getName() {
 		return "Lonelypages";
 	}
+	function getPageHeader() {
+		return wfMsgExt( 'lonelypagestext', array( 'parse' ) );
+	}
 
 	function sortDescending() {
 		return false;
@@ -15,17 +25,30 @@ class LonelyPagesPage extends PageQueryPage {
 	function isExpensive() {
 		return true;
 	}
-	
+	function isSyndicated() { return false; }
+
 	function getSQL() {
-		$dbr =& wfGetDB( DB_SLAVE );
-		extract( $dbr->tableNames( 'cur', 'links' ) );
+		$dbr = wfGetDB( DB_SLAVE );
+		list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
+
+		return
+		  "SELECT 'Lonelypages'  AS type,
+		          page_namespace AS namespace,
+		          page_title     AS title,
+		          page_title     AS value
+		     FROM $page
+		LEFT JOIN $pagelinks
+		       ON page_namespace=pl_namespace AND page_title=pl_title
+		    WHERE pl_namespace IS NULL
+		      AND page_namespace=".NS_MAIN."
+		      AND page_is_redirect=0";
 
-		return "SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value " .
-			"FROM $cur LEFT JOIN $links ON cur_id=l_to ".
-			"WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0";
 	}
 }
 
+/**
+ * Constructor
+ */
 function wfSpecialLonelypages() {
 	list( $limit, $offset ) = wfCheckLimits();
 
@@ -34,4 +57,4 @@ function wfSpecialLonelypages() {
 	return $lpp->doQuery( $offset, $limit );
 }
 
-?>
+