Template:Yearsofteams: Difference between revisions

Latest revision as of 05:25, 21 June 2024

Year	Photo

@@ Line 1: / Line 1: @@
+*Note: Use template <nowiki> {{Loadteamdata}}</nowiki> for these pages
 {{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}}
-{{#vardefine:NextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
+{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
-{{#vardefine:FindPageName|{{#sub:{{PAGENAME}}|{{#var:NextPos}}}}}}
+{{#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='{{#var:FindPageName}}')
+|where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}')
 |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,PhotoTh=PhotoTh
 }}
 {| class="wikitable"
-! Team Name
+! Year
+! Photo
 {{#for_external_table:<nowiki/>
 {{!}}-
 {{!}} [[{{PAGENAME}}:{{{Year}}}|{{{Year}}}]]
-{{!}} {{{Photo}}}
+{{!}} {{{PhotoTh}}}
-{{#ifexist: {{{Photo}}} | value if exists | value if doesn't exist }}
 }}
 |}