Template:TeamLeaderStats: Difference between revisions

From UFFL Wiki
(WIP)
mNo edit summary
 
(7 intermediate revisions by the same user not shown)
Line 4: Line 4:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |where= Season='{{#vardefine:season|{{{season|}}}}}' AND Team = '{{#vardefine:team|{{{team|}}}}}'
|data=season=Season,team=Team
|data=season=Season,team=Team
}}<!--- Then start importing individual 'Leader' values --->{{#get_db_data:
}}<!--- Then start importing individual 'Leader' values --->{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{#var:season}}' AND Team = '{{#var:team}}'
  |limit = 1
  |limit = 1
  |order by = PassYds DESC
  |order by = PassYds DESC
Line 16: Line 16:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = PassTD DESC
  |order by = PassTD DESC
Line 23: Line 23:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = RushYds DESC
  |order by = RushYds DESC
Line 30: Line 30:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = RushTD DESC
  |order by = RushTD DESC
Line 37: Line 37:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = Catches DESC
  |order by = Catches DESC
Line 44: Line 44:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = RecYds DESC
  |order by = RecYds DESC
Line 51: Line 51:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = RecTD DESC
  |order by = RecTD DESC
|data=playerName7=PlayerID,rushYds=RecTD
|data=playerName7=PlayerID,recTDs=RecTD
}}{{#get_db_data:
}}{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = Points DESC
  |order by = Points DESC
Line 65: Line 65:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = KickoffReturnYds DESC
  |order by = KickoffReturnYds DESC
Line 72: Line 72:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = PuntReturnYds DESC
  |order by = PuntReturnYds DESC
Line 79: Line 79:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = Tackles DESC
  |order by = Tackles DESC
Line 86: Line 86:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = Sacks DESC
  |order by = Sacks DESC
Line 93: Line 93:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = ForcedFumbles DESC
  |order by = ForcedFumbles DESC
Line 100: Line 100:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season}}}' AND Team = '{{{team}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |limit = 1
  |limit = 1
  |order by = Ints DESC
  |order by = Ints DESC
|data=playerName14=PlayerID,interceptions=Ints
|data=playerName14=PlayerID,interceptions=Ints
}}
}}
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 70%" class="wikitable sortable"  
{| style="{{UFFL color cell|{{{team}}}}}; border:0; font-size:16px; cellpadding:0.5; cellspacing:0.5; width: 70%" class="wikitable sortable"  
|-
|-
! colspan="3"|{{{season|}}} {{{team|}}} Team Leaders
! colspan="3"|{{{season|}}} {{Convert/teamabbr|{{{team|}}}}} Team Leaders
|-
|-
! Category
! Category
Line 114: Line 114:
|-
|-
| Passing Yards
| Passing Yards
| {{{playerName1}}}
| {{SID|{{#external_value:playerName1}}}}
| {{{passYds}}}
| {{#external_value:passYds}}
|-
|-
| Touchdown Passes
| Touchdown Passes
| {{{playerName2}}}
| {{SID|{{#external_value:playerName2}}}}
| {{{passTDs}}}
| {{#external_value:passTDs}}
|-
|-
| Rushing Yards
| Rushing Yards
| {{{playerName3}}}
| {{SID|{{#external_value:playerName3}}}}
| {{{rushYds}}}
| {{#external_value:rushYds}}
|-
|-
| Touchdown Runs
| Touchdown Runs
| {{{playerName4}}}
| {{SID|{{#external_value:playerName4}}}}
| {{{rushTDs}}}
| {{#external_value:rushTDs}}
|-
|-
| Receptions
| Receptions
| {{{playerName5}}}
| {{SID|{{#external_value:playerName5}}}}
| {{{receptions}}}
| {{#external_value:receptions}}
|-
|-
| Receiving Yards
| Receiving Yards
| {{{playerName6}}}
| {{SID|{{#external_value:playerName6}}}}
| {{{recYds}}}
| {{#external_value:recYds}}
|-
|-
| Touchdown Catches
| Touchdown Catches
| {{{playerName7}}}
| {{SID|{{#external_value:playerName7}}}}
| {{{recTDs}}}
| {{#external_value:recTDs}}
|-
|-
| Points Scored
| Points Scored
| {{{playerName8}}}
| {{SID|{{#external_value:playerName8}}}}
| {{{points}}}
| {{#external_value:points}}
|-
|-
| Kick Return Yards
| Kick Return Yards
| {{{playerName9}}}
| {{SID|{{#external_value:playerName9}}}}
| {{{kickRetYds}}}
| {{#external_value:kickRetYds}}
|-
|-
| Punt Return Yards
| Punt Return Yards
| {{{playerName10}}}
| {{SID|{{#external_value:playerName10}}}}
| {{{puntRetYds}}}
| {{#external_value:puntRetYds}}
|-
|-
| Tackles
| Tackles
| {{{playerName11}}}
| {{SID|{{#external_value:playerName11}}}}
| {{{tackles}}}
| {{#external_value:tackles}}
|-
|-
| Sacks
| Sacks
| {{{playerName12}}}
| {{SID|{{#external_value:playerName12}}}}
| {{{sacks}}}
| {{#external_value:sacks}}
|-
|-
| Forced Fumbles
| Forced Fumbles
| {{{playerName13}}}
| {{SID|{{#external_value:playerName13}}}}
| {{{forcedFumbles}}}
| {{#external_value:forcedFumbles}}
|-
|-
| Interceptions
| Interceptions
| {{{playerName14}}}
| {{SID|{{#external_value:playerName14}}}}
| {{{interceptions}}}
| {{#external_value:interceptions}}
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}

Latest revision as of 02:48, 31 January 2021


Team Leaders
Category Player(s) Value
Passing Yards Your wiki coding sucks Error: no local variable "passYds" has been set.
Touchdown Passes Your wiki coding sucks Error: no local variable "passTDs" has been set.
Rushing Yards Your wiki coding sucks Error: no local variable "rushYds" has been set.
Touchdown Runs Your wiki coding sucks Error: no local variable "rushTDs" has been set.
Receptions Your wiki coding sucks Error: no local variable "receptions" has been set.
Receiving Yards Your wiki coding sucks Error: no local variable "recYds" has been set.
Touchdown Catches Your wiki coding sucks Error: no local variable "recTDs" has been set.
Points Scored Your wiki coding sucks Error: no local variable "points" has been set.
Kick Return Yards Your wiki coding sucks Error: no local variable "kickRetYds" has been set.
Punt Return Yards Your wiki coding sucks Error: no local variable "puntRetYds" has been set.
Tackles Your wiki coding sucks Error: no local variable "tackles" has been set.
Sacks Your wiki coding sucks Error: no local variable "sacks" has been set.
Forced Fumbles Your wiki coding sucks Error: no local variable "forcedFumbles" has been set.
Interceptions Your wiki coding sucks Error: no local variable "interceptions" has been set.
Retrieved from "https://unitedfurryfootball.com/wiki/index.php?title=Template:TeamLeaderStats&oldid=292"