Exemple #1
0
 /**
  * Get a message, with optional parameters
  * Parameters from user input must be escaped for HTML *before* passing to this function
  *
  * @access	public
  * @param	integer	Message ID
  * @return	string
  */
 public function msg()
 {
     $args = func_get_args();
     $errorId = array_shift($args);
     $errorLevel = floor($errorId / 1000);
     $errorMessageId = $errorId % 1000;
     if (\DynamicPageListHooks::getDebugLevel() >= $errorLevel) {
         if (\DynamicPageListHooks::isLikeIntersection()) {
             if ($errorId == \DynamicPageListHooks::FATAL_TOOMANYCATS) {
                 $text = wfMessage('intersection_toomanycats', $args)->text();
             } elseif ($errorId == \DynamicPageListHooks::FATAL_TOOFEWCATS) {
                 $text = wfMessage('intersection_toofewcats', $args)->text();
             } elseif ($errorId == \DynamicPageListHooks::WARN_NORESULTS) {
                 $text = wfMessage('intersection_noresults', $args)->text();
             } elseif ($errorId == \DynamicPageListHooks::FATAL_NOSELECTION) {
                 $text = wfMessage('intersection_noincludecats', $args)->text();
             }
         }
         if (empty($text)) {
             $text = wfMessage('dpl_log_' . $errorMessageId, $args)->text();
         }
         $this->buffer[] = '<p>Extension:DynamicPageList (DPL), version ' . DPL_VERSION . ': ' . $text . '</p>';
     }
     return false;
 }
 /**
  * Main Constructor
  *
  * @access	public
  * @return	void
  */
 public function __construct()
 {
     $this->setRichness(Config::getSetting('functionalRichness'));
     if (\DynamicPageListHooks::isLikeIntersection()) {
         $this->data['ordermethod'] = ['default' => 'categoryadd', 'values' => ['categoryadd', 'lastedit', 'none']];
         $this->data['order'] = ['default' => 'descending', 'values' => ['ascending', 'descending']];
         $this->data['mode'] = ['default' => 'unordered', 'values' => ['none', 'ordered', 'unordered']];
         $this->data['userdateformat'] = ['default' => 'Y-m-d: '];
         $this->data['allowcachedresults']['default'] = 'true';
     }
 }
Exemple #3
0
 /**
  * Set SQL for 'ordermethod' parameter.
  *
  * @access	private
  * @param	mixed	Parameter Option
  * @return	void
  */
 private function _ordermethod($option)
 {
     global $wgContLang;
     if ($this->parameters->getParameter('goal') == 'categories') {
         //No order methods for returning categories.
         return true;
     }
     $namespaces = $wgContLang->getNamespaces();
     //$aStrictNs = array_slice((array) Config::getSetting('allowedNamespaces'), 1, count(Config::getSetting('allowedNamespaces')), true);
     $namespaces = array_slice($namespaces, 3, count($namespaces), true);
     $_namespaceIdToText = "CASE {$this->tableNames['page']}.page_namespace";
     foreach ($namespaces as $id => $name) {
         $_namespaceIdToText .= ' WHEN ' . intval($id) . " THEN " . $this->DB->addQuotes($name . ':');
     }
     $_namespaceIdToText .= ' END';
     $revisionAuxWhereAdded = false;
     foreach ($option as $orderMethod) {
         switch ($orderMethod) {
             case 'category':
                 $this->addOrderBy('cl_head.cl_to');
                 $this->addSelect(['cl_head.cl_to']);
                 //Gives category headings in the result.
                 if (is_array($this->parameters->getParameter('catheadings')) && in_array('', $this->parameters->getParameter('catheadings')) || is_array($this->parameters->getParameter('catnotheadings')) && in_array('', $this->parameters->getParameter('catnotheadings'))) {
                     $_clTableName = 'dpl_clview';
                     $_clTableAlias = $_clTableName;
                 } else {
                     $_clTableName = 'categorylinks';
                     $_clTableAlias = 'cl_head';
                 }
                 $this->addTable($_clTableName, $_clTableAlias);
                 $this->addTable('revision', 'rev');
                 $this->addJoin($_clTableAlias, ["LEFT OUTER JOIN", "page_id = cl_head.cl_from"]);
                 if (is_array($this->parameters->getParameter('catheadings')) && count($this->parameters->getParameter('catheadings'))) {
                     $this->addWhere(["cl_head.cl_to" => $this->parameters->getParameter('catheadings')]);
                 }
                 if (is_array($this->parameters->getParameter('catnotheadings')) && count($this->parameters->getParameter('catnotheadings'))) {
                     $this->addNotWhere(['cl_head.cl_to' => $this->parameters->getParameter('catnotheadings')]);
                 }
                 break;
             case 'categoryadd':
                 //@TODO: See TODO in __addfirstcategorydate().
                 $this->addOrderBy('cl1.cl_timestamp');
                 break;
             case 'counter':
                 if (class_exists("\\HitCounters\\Hooks")) {
                     //If the "addpagecounter" parameter was not used the table and join need to be added now.
                     if (!array_key_exists('hit_counter', $this->tables)) {
                         $this->addTable('hit_counter', 'hit_counter');
                         if (!isset($this->join['hit_counter'])) {
                             $this->addJoin('hit_counter', ["LEFT JOIN", "hit_counter.page_id = " . $this->tableNames['page'] . '.page_id']);
                         }
                     }
                     $this->addOrderBy('hit_counter.page_counter');
                 }
                 break;
             case 'firstedit':
                 $this->addOrderBy('rev.rev_timestamp');
                 $this->setOrderDir('ASC');
                 $this->addTable('revision', 'rev');
                 $this->addSelect(['rev.rev_timestamp']);
                 if (!$revisionAuxWhereAdded) {
                     $this->addWhere(["{$this->tableNames['page']}.page_id = rev.rev_page", "rev.rev_timestamp = (SELECT MAX(rev_aux.rev_timestamp) FROM {$this->tableNames['revision']} AS rev_aux WHERE rev_aux.rev_page=rev.rev_page)"]);
                 }
                 $revisionAuxWhereAdded = true;
                 break;
             case 'lastedit':
                 if (\DynamicPageListHooks::isLikeIntersection()) {
                     $this->addOrderBy('page_touched');
                     $this->addSelect(["page_touched" => "{$this->tableNames['page']}.page_touched"]);
                 } else {
                     $this->addOrderBy('rev.rev_timestamp');
                     $this->addTable('revision', 'rev');
                     $this->addSelect(['rev.rev_timestamp']);
                     if (!$revisionAuxWhereAdded) {
                         $this->addWhere(["{$this->tableNames['page']}.page_id = rev.rev_page", "rev.rev_timestamp = (SELECT MAX(rev_aux.rev_timestamp) FROM {$this->tableNames['revision']} AS rev_aux WHERE rev_aux.rev_page = rev.rev_page)"]);
                     }
                     $revisionAuxWhereAdded = true;
                 }
                 break;
             case 'pagesel':
                 $this->addOrderBy('sortkey');
                 $this->addSelect(['sortkey' => 'CONCAT(pl.pl_namespace, pl.pl_title) ' . $this->getCollateSQL()]);
                 break;
             case 'pagetouched':
                 $this->addOrderBy('page_touched');
                 $this->addSelect(["page_touched" => "{$this->tableNames['page']}.page_touched"]);
                 break;
             case 'size':
                 $this->addOrderBy('page_len');
                 break;
             case 'sortkey':
                 $this->addOrderBy('sortkey');
                 // If cl_sortkey is null (uncategorized page), generate a sortkey in the usual way (full page name, underscores replaced with spaces).
                 // UTF-8 created problems with non-utf-8 MySQL databases
                 $replaceConcat = "REPLACE(CONCAT({$_namespaceIdToText}, " . $this->tableNames['page'] . ".page_title), '_', ' ')";
                 if (count($this->parameters->getParameter('category')) + count($this->parameters->getParameter('notcategory')) > 0) {
                     if (in_array('category', $this->parameters->getParameter('ordermethod'))) {
                         $this->addSelect(['sortkey' => "IFNULL(cl_head.cl_sortkey, {$replaceConcat}) " . $this->getCollateSQL()]);
                     } else {
                         //This runs on the assumption that at least one category parameter was used and that numbering starts at 1.
                         $this->addSelect(['sortkey' => "IFNULL(cl1.cl_sortkey, {$replaceConcat}) " . $this->getCollateSQL()]);
                     }
                 } else {
                     $this->addSelect(['sortkey' => $replaceConcat . $collation]);
                 }
                 break;
             case 'titlewithoutnamespace':
                 if ($this->parameters->getParameter('openreferences')) {
                     $this->addOrderBy("pl_title");
                 } else {
                     $this->addOrderBy("page_title");
                 }
                 $this->addSelect(['sortkey' => "{$this->tableNames['page']}.page_title " . $this->getCollateSQL()]);
                 break;
             case 'title':
                 $this->addOrderBy('sortkey');
                 if ($this->parameters->getParameter('openreferences')) {
                     $this->addSelect(['sortkey' => "REPLACE(CONCAT(IF(pl_namespace  =0, '', CONCAT(" . $_namespaceIdToText . ", ':')), pl_title), '_', ' ') " . $this->getCollateSQL()]);
                 } else {
                     //Generate sortkey like for category links. UTF-8 created problems with non-utf-8 MySQL databases.
                     $this->addSelect(['sortkey' => "REPLACE(CONCAT(IF(" . $this->tableNames['page'] . ".page_namespace = 0, '', CONCAT(" . $_namespaceIdToText . ", ':')), " . $this->tableNames['page'] . ".page_title), '_', ' ') " . $this->getCollateSQL()]);
                 }
                 break;
             case 'user':
                 $this->addOrderBy('rev.rev_user_text');
                 $this->addTable('revision', 'rev');
                 $this->_adduser(null, 'rev');
                 break;
             case 'none':
                 break;
         }
     }
 }