Template:Loadteamdata: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) (Created page with "{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}} {{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} {{#vardefine:FindTeamYear|{{#sub:{{PAGENAME}}|{{#var:LastCo...") |
Kamalanath (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} | {{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}} | ||
{{#vardefine:FindTeamYear|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}} | {{#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:FindTeamTypeName|{{#sub:{{#var:LeftStringFromColn}}|{{#var:LastColnNextPos}}}}}} | {{#vardefine:FindTeamTypeName|{{#sub:{{#var:LeftStringFromColn}}|{{#var:LastColnNextPos}}}}}} | ||
{{#vardefine:LeftStringFromColn|{{#sub:{{#var:LeftStringFromColn}}|0|{{#var:LastColnPos}}}}}} | {{#vardefine:LeftStringFromColn|{{#sub:{{#var:LeftStringFromColn}}|0|{{#var:LastColnPos}}}}}} | ||
{{#vardefine:FindTeamName|{{#var:LeftStringFromColn}}}} | {{#vardefine:FindTeamName|{{#var:LeftStringFromColn}}}} | ||
{{#get_db_data: | {{#get_db_data: | ||
|server=drck-db | |server=drck-db | ||
Revision as of 08:34, 9 December 2023
The query SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Loadteamdat') and (TeamName='Loadteamda') and (Year='Loadteamdata') 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='Loadteamdat') and (TeamName='Loadteamda') and (Year='Loadteamdata') ORDER BY Year DESC ).