Help:Wanted page

From The Scuba Wiki

Revision as of 18:44, 20 June 2006

A page is considered "wanted" if it does not exist, while two or more pages in the project link to it.

The SQL for determining this is from include/SpecialWantedpages.php

 SELECT 'Wantedpages' AS type,
   pl_namespace AS namespace,
   pl_title AS title,
   COUNT(*) AS value
   FROM $pagelinks
   LEFT JOIN $page
   ON pl_namespace=page_namespace AND pl_title=page_title
   WHERE page_namespace IS NULL
   GROUP BY pl_namespace,pl_title
   HAVING COUNT(*) > 1

You can set another threshold by setting 'HAVING COUNT(*) > n'

Links to other help pages

Help contents

Meta | Wikinews | Wikipedia | Wikiquote | Wiktionary | commons: | mw: | b: | s: | mw:Manual | google

Versions of this help page (for other languages see below)

Meta | Wikinews | Wikipediahttp://en.wikipedia.org/Help:Wanted_page | Wikiquote | Wiktionary

What links here on Meta or from Meta | Wikipedia | MediaWiki

Reading

Go | Search | Stop words | URL | Namespace | Page name | Section

Backlinks | Link | Piped link | Interwiki link | Redirect | Category | Image page

Logging in and preferences

Logging in | Preferences | User style

Editing

Advanced editing | Editing FAQ | Edit toolbar | Export | Import | Shortcuts

Tracking changes

Recent changes (enhanced) | Related changes | Watching pages | Diff

Page history | Edit summary | User contributions | Minor edit | Patrolled edit

Style & formatting

Wikitext examples | Reference card | HTML in wikitext | List | Table | Sorting | Colors

Special input and output

Inputbox | Special characters | Displaying a formula | Images (uploads) | EasyTimeline

Advanced functioning

Template | Advanced templates | Parser function | ParserFunctions | Parameter default

Variable | Magic word | System message | Substitution | Array | Calculation

Page management

Starting a new page | Renaming (moving) a page | Protecting pages | Deleting a page

Special pages

Talk page | Testing | Sandbox | CentralNotice

Template:-