Template:Yearsofteams: Difference between revisions

Latest revision as of 05:25, 21 June 2024

Year	Photo

@@ Line 1: / Line 1: @@
-{{PAGENAME}}
+*Note: Use template <nowiki> {{Loadteamdata}}</nowiki> for these pages
-{{#rpos::|{{PAGENAME}}}}
+{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}}
+{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
+{{#vardefine:FindTeamTypeName|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}}
+{{#vardefine:LeftStringFromColn|{{#sub:{{PAGENAME}}|0|{{#var:LastColnPos}}}}}}
+{{#vardefine:FindTeamName|{{#var:LeftStringFromColn}}}}
 {{#get_db_data:
 |server=drck-db
 |from=wikiyearsofteams
-|where=(TeamTypeName='{{PAGENAME}}')
+|where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}')
 |order by=Year DESC
-|data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,
+|data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,PhotoTh=PhotoTh
 }}
 {| class="wikitable"
-! Team Name
+! Year
+! Photo
 {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} [[{{{Year}}}|{{{Year}}}]]
+{{!}} [[{{PAGENAME}}:{{{Year}}}|{{{Year}}}]]
-{{!}} TeamName
+{{!}} {{{PhotoTh}}}
-{{!}} {{{TeamName}}}
-{{!}} TeamTypeName
-{{!}} {{{TeamTypeName}}}
-{{!}} TeamTypePageName
-{{!}} {{{TeamTypePageName}}}
 }}
 |}