Difference between revisions of "Template:pathCast"
From pathCast
(84 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 11: | 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__{{#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 41: | Line 49: | ||
,faculty.position | ,faculty.position | ||
,faculty.institution | ,faculty.institution | ||
+ | ,pathCast.subspecialty | ||
+ | ,pathCast.presenter1 | ||
+ | ,subspecialty._pageName | ||
+ | ,faculty._pageTitle | ||
+ | ,pathCast.presenter2 | ||
+ | ,pathCast.presenter3 | ||
+ | |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]