Difference between revisions of "Template:pathCast"
From pathCast
| (43 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) | ||
| 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|}}} | ||
| Line 25: | Line 29: | ||
|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__{{#cargo_query: | }}__NOCACHE__{{#cargo_query: | ||
tables=pathCast,faculty,subspecialty | tables=pathCast,faculty,subspecialty | ||
| − | |join on=pathCast. | + | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty |
|fields= | |fields= | ||
,pathCast.title | ,pathCast.title | ||
,subspecialty.hashtag | ,subspecialty.hashtag | ||
| − | ,faculty. | + | ,faculty.namefirstlast |
,pathCast.date | ,pathCast.date | ||
,pathCast.urlyt | ,pathCast.urlyt | ||
| Line 44: | Line 50: | ||
,faculty.institution | ,faculty.institution | ||
,pathCast.subspecialty | ,pathCast.subspecialty | ||
| − | ,pathCast. | + | ,pathCast.presenter1 |
,subspecialty._pageName | ,subspecialty._pageName | ||
,faculty._pageTitle | ,faculty._pageTitle | ||
| − | ,pathCast. | + | ,pathCast.presenter2 |
| + | ,pathCast.presenter3 | ||
|where=pathCast._pageName='{{FULLPAGENAME}}' | |where=pathCast._pageName='{{FULLPAGENAME}}' | ||
|format=template|template=pathCastPage|}} | |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]