Template:Lowercase title/doc: Difference between revisions
Undid revision 740798999 by GreenComputer (talk) Dosen't work |
Adding SQL |
||
| Line 26: | Line 26: | ||
== Technical == |
== Technical == |
||
This template wraps the [[Help:Magic words|magic word]] DISPLAYTITLE so that it works automatically in any namespace (main, talk, template, etc.) to decapitalise the first letter of the name of a page it is transcluded on. |
This template wraps the [[Help:Magic words|magic word]] DISPLAYTITLE so that it works automatically in any namespace (main, talk, template, etc.) to decapitalise the first letter of the name of a page it is transcluded on. |
||
<source lang=sql> |
|||
/* Page using a lowercase title, with or without {{lowercase}} */ |
|||
SELECT page_title, pp_value AS displaytitle |
|||
FROM page |
|||
JOIN page_props ON pp_page=page_id AND pp_propname="displaytitle" |
|||
WHERE page_namespace=0 |
|||
AND CONVERT(pp_value USING utf8mb4) COLLATE utf8mb4_bin /* &#greek; */ |
|||
REGEXP "^([_ :]+|<[^<>]+>)*([[:lower:]]|	[4-6][0-9];)" |
|||
</source> |
|||
== See also == |
== See also == |
||
Revision as of 20:04, 15 November 2016
 | This is a documentation subpage for Template:Lowercase title. It may contain usage information, categories and other content that is not part of the original template page. |
Usage
 | This template should not be substituted. |
Simply add the tag {{lowercase title}} at the beginning of a page (and optionally, at the beginning of its talk page). There are no parameters. The tag will only decapitalize the first letter of the page's name in the title at the beginning of the page. Examples:
| Page name | Will display |
|---|---|
| EBay, IPod, etc. | eBay, iPod, etc. |
| Talk:EBay | Talk:eBay |
Issues
The template does not work together with other title modification templates: you need to use DISPLAYTITLE directly and make sure it's the last DISPLAYTITLE on the page. For example, to make "Example" italic and lowercase, use {{DISPLAYTITLE:''example''}}.
When using the template on redirect pages, the template must be moved after the redirect, since otherwise it will break the redirection. This, however, limits the template to have an effect only when viewing the redirect page directly. Nevertheless, it is still useful in this scenario in order to document the proper capitalization of a term.
Technical
This template wraps the magic word DISPLAYTITLE so that it works automatically in any namespace (main, talk, template, etc.) to decapitalise the first letter of the name of a page it is transcluded on.
/* Page using a lowercase title, with or without {{lowercase}} */
SELECT page_title, pp_value AS displaytitle
FROM page
JOIN page_props ON pp_page=page_id AND pp_propname="displaytitle"
WHERE page_namespace=0
AND CONVERT(pp_value USING utf8mb4) COLLATE utf8mb4_bin /* &#greek; */
REGEXP "^([_ :]+|<[^<>]+>)*([[:lower:]]|	[4-6][0-9];)"
See also
| Wiki markup Transclusion from template: |
Involves | Correct name | Actual article name |
|---|---|---|---|
| {{Italic title}} | Title in italics | To Kill a Mockingbird | To Kill a Mockingbird |
| {{Italic title|all=yes}} | Complete title in italics, including parentheses | Randall and Hopkirk (Deceased) | Randall and Hopkirk (Deceased) |
| {{Italic title|string=Ally McBeal}} | Phrase of |string= in italics
|
List of Ally McBeal episodes | List of Ally McBeal episodes |
| {{Italic title|all=yes|string=Fringe}} | Phrase of |string= in italics; also looks in parentheses
|
Peter (Fringe episode) | Peter (Fringe episode) |
| {{Italic disambiguation}} | Disambiguation in italics | The End (Lost) | The End (Lost) |
| {{Lowercase title}} | Lowercase first character | eBay | EBay |
| {{Lowercase title|italic=yes}} | Lowercase first character and place title in italics, not including disambiguation | iCarly (soundtrack) | ICarly (soundtrack) |
| {{Lowercase title|italic=yes|force=yes}} | Lowercase first character and place title in italics, including disambiguation | ||
| {{Lowercase title|dab=yes}} | Lowercase first character and place disambiguation in italics | iSpy (Modern Family) | ISpy (Modern Family) |
| {{Italic title prefixed|17}} | Italicize after the number characters at the beginning of the title | German battleship Bismarck | German battleship Bismarck |
| Magic word | |||
| {{DISPLAYTITLE:_NSAKEY}} | Various | _NSAKEY | NSAKEY |
| Title corrections | |||
| {{Correct title|reason=bracket}} | < > [ ] { } | Benzo[a]pyrene | Benzo(a)pyrene |
| {{Correct title|reason=#}} | # | Pilot #5 | Pilot No. 5 |
| {{Correct title|reason=:}} | : | DK: King of Swing | DK King of Swing |