Template:Teampage: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}} | {{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}} | ||
{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} | {{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} | ||
{{#vardefine: | {{#vardefine:FindTeamYear|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}} | ||
{{#vardefine:LeftStringFromColn|{{#sub:{{PAGENAME}}|0|{{#var:LastColnPos}}}}}} | {{#vardefine:LeftStringFromColn|{{#sub:{{PAGENAME}}|0|{{#var:LastColnPos}}}}}} | ||
{{#vardefine:LastColnPos|{{#rpos:{{#var:LeftStringFromColn}}|:}}}} | {{#vardefine:LastColnPos|{{#rpos:{{#var:LeftStringFromColn}}|:}}}} | ||
{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} | {{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} | ||
{{#vardefine: | {{#vardefine:FindTeamTypeName|{{#sub:{{#var:LeftStringFromColn}}|{{#var:LastColnNextPos}}}}}} | ||
{{#vardefine:LeftStringFromColn|{{#sub:{{#var:LeftStringFromColn}}|0|{{#var:LastColnPos}}}}}} | |||
{{#vardefine:FindTeamName|{{#var:LeftStringFromColn}}}} | |||
{{#get_db_data: | {{#get_db_data: | ||
|server=drck-db | |server=drck-db | ||
|from=wikiyearsofteams | |from=wikiyearsofteams | ||
|where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}') | |where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}') and (Year='{{#var:FindTeamYear}}') | ||
|order by=Year DESC | |order by=Year DESC | ||
|data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,Photo=Photo | |data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,Photo=Photo | ||
}} | }} | ||
{| class="wikitable" | {| class="wikitable" | ||
{{#for_external_table:<nowiki/> | {{#for_external_table:<nowiki/> | ||
{{!}}- | {{!}}- | ||
{{!}} {{{Photo}}} | {{!}} {{{Photo}}} | ||
}} | }} | ||
|} | |} | ||
Latest revision as of 06:41, 9 December 2023
The query SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Teampag') and (TeamName='Teampa') and (Year='Teampage') ORDER BY Year DESC is invalid (Error 1054: Unknown column 'Photo' in 'field list'
Function: EDConnectorRdbms::fetch
Query: SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Teampag') and (TeamName='Teampa') and (Year='Teampage') ORDER BY Year DESC
).