Difference between revisions of "Template:pathCast"
From pathCast
| (106 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<noinclude>{{CTRADMIN}}{{#cargo_declare: | <noinclude>{{CTRADMIN}}{{#cargo_declare: | ||
_table = pathCast | _table = pathCast | ||
| − | |date = | + | |date = Datetime |
| − | | | + | |presenter1 = String (size=255) |
| + | |presenter2 = String (size=255) | ||
| + | |presenter3 = String (size=255) | ||
|title = String (size=255) | |title = String (size=255) | ||
|subspecialty = String (size=255) | |subspecialty = String (size=255) | ||
| − | |||
|categories = Wikitext | |categories = Wikitext | ||
|series = String (size=255) | |series = String (size=255) | ||
| Line 12: | Line 13: | ||
|urlyt = Wikitext | |urlyt = Wikitext | ||
|urlperi = Wikitext | |urlperi = Wikitext | ||
| + | |hide = Boolean | ||
| + | |uid = String (size=510) | ||
|user = String (size=255) | |user = String (size=255) | ||
|dts = Datetime | |dts = Datetime | ||
}}{{CargoCreate}}</noinclude><includeonly>{{#cargo_store: | }}{{CargoCreate}}</noinclude><includeonly>{{#cargo_store: | ||
_table = pathCast | _table = pathCast | ||
| − | |date = {{{date}}} | + | |date = {{{date|2038/04/11}}} |
| − | | | + | |presenter1 = {{{presenter1|}}} |
| + | |presenter2 = {{{presenter2|null}}} | ||
| + | |presenter3 = {{{presenter3|null}}} | ||
|title = {{{title|}}} | |title = {{{title|}}} | ||
|subspecialty = {{{subspecialty|}}} | |subspecialty = {{{subspecialty|}}} | ||
| − | |||
|categories = {{{categories|}}} | |categories = {{{categories|}}} | ||
| − | |series = {{{series|}}} | + | |series = {{{series|null}}} |
|language = {{{language|}}} | |language = {{{language|}}} | ||
|urlfb = {{{urlfb|}}} | |urlfb = {{{urlfb|}}} | ||
| − | |urlyt = {{{urlyt|}}} | + | |urlyt = {{{urlyt|null}}} |
|urlperi = {{{urlperi|}}} | |urlperi = {{{urlperi|}}} | ||
| + | |hide = {{{hide|No}}} | ||
| + | |uid = {{{uid|}}} | ||
|user = {{{user|}}} | |user = {{{user|}}} | ||
|dts = {{{dts|}}} | |dts = {{{dts|}}} | ||
| − | }}__NOCACHE__ | + | }}__NOCACHE__{{#cargo_query: |
| − | {{#cargo_query: | + | tables=pathCast,faculty,subspecialty |
| − | tables=pathCast | + | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty |
| − | |fields=date= | + | |fields= |
| − | |format= | + | ,pathCast.title |
| + | ,subspecialty.hashtag | ||
| + | ,faculty.namefirstlast | ||
| + | ,pathCast.date | ||
| + | ,pathCast.urlyt | ||
| + | ,pathCast.series | ||
| + | ,subspecialty.name | ||
| + | ,faculty.degree | ||
| + | ,faculty.position | ||
| + | ,faculty.institution | ||
| + | ,pathCast.subspecialty | ||
| + | ,pathCast.presenter1 | ||
| + | ,subspecialty._pageName | ||
| + | ,faculty._pageTitle | ||
| + | ,pathCast.presenter2 | ||
| + | ,pathCast.presenter3 | ||
| + | |where=pathCast._pageName='{{FULLPAGENAME}}' | ||
| + | |format=template|template=pathCastPage|}} | ||
| + | {{#seo: | ||
| + | |title={{{title}}} | ||
| + | |description={{#cargo_query: tables=pathCast,faculty,subspecialty |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty |fields=subspecialty.hashtag,faculty.namefirstlast,faculty.degree,faculty.institution|where=pathCast._pageName='{{FULLPAGENAME}}'|format=template|template=metaDescription}} | ||
| + | |published_time={{{date}}} | ||
| + | |image={{#cargo_query: tables=pathCast,pathCastFiles |join on=pathCast._pageName=pathCastFiles.pathCast|fields=pathCastFiles._pageTitle |where=pathCastFiles.filetype='banner' AND pathCastFiles.pathCast='{{FULLPAGENAME}}'|format=template|template=filepath}} | ||
| + | }} | ||
</includeonly> | </includeonly> | ||
Latest revision as of 22:36, 24 September 2020
Template:CTRADMINThis template defines the table "pathCast". View table. [1]