Template:TeamLeaderStats: Difference between revisions

From UFFL Wiki
(WIP)
 
mNo edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
<!--- TEAM LEADER STATS ---->
<!--- TEAM LEADER STATS ---->
<!--- Get the season and team data from the user --->
{{#get_db_data:
{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{#vardefine:season|{{{season|}}}}}' AND Team = '{{#vardefine:team|{{{team|}}}}}'
|data=season=Season,team=Team
}}<!--- Then start importing individual 'Leader' values --->{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{#var:season}}' AND Team = '{{#var:team}}'
|limit = 1
|order by = PassYds DESC
|data=playerName1=PlayerID,passYds=PassYds
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = PassTD DESC
|data=playerName2=PlayerID,passTDs=PassTD
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = RushYds DESC
|data=playerName3=PlayerID,rushYds=RushYds
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = RushTD DESC
|data=playerName4=PlayerID,rushTDs=RushTD
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = Catches DESC
|data=playerName5=PlayerID,receptions=Catches
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = RecYds DESC
|data=playerName6=PlayerID,recYds=RecYds
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = RecTD DESC
|data=playerName7=PlayerID,recTDs=RecTD
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = Points DESC
|data=playerName8=PlayerID,points=Points
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = KickoffReturnYds DESC
|data=playerName9=PlayerID,kickRetYds=KickoffReturnYds
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = PuntReturnYds DESC
|data=playerName10=PlayerID,puntRetYds=PuntReturnYds
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = Tackles DESC
|data=playerName11=PlayerID,tackles=Tackles
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = Sacks DESC
|data=playerName12=PlayerID,sacks=Sacks
}}{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
|limit = 1
|order by = ForcedFumbles DESC
|data=playerName13=PlayerID,forcedFumbles=ForcedFumbles
}}{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |where= Season='{{{season|}}}' AND Team = '{{{team|}}}'
  |data=season=Season,team=Team,player=PlayerID,passYds=PassYds,passTDs=PassTD,rushYds=RushYds,rushTDs=RushTD,receptions=Catches,recYds=RecYds,recTDs=RecTD,points=Points,kickRetYds=KickoffReturnYds,puntRetYds=PuntReturnYds,tackles=Tackles,sacks=Sacks,forcedfum=ForcedFumbles,interceptions=Ints
  |limit = 1
|order by = Ints DESC
|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 15: Line 114:
|-
|-
| Passing Yards
| Passing Yards
| {{{player}}}
| {{SID|{{#external_value:playerName1}}}}
| {{{passYds}}}
| {{#external_value:passYds}}
|-
|-
| Touchdown Passes
| Touchdown Passes
| {{{player}}}
| {{SID|{{#external_value:playerName2}}}}
| {{{passTDs}}}
| {{#external_value:passTDs}}
|-
|-
| Rushing Yards
| Rushing Yards
| {{{player}}}
| {{SID|{{#external_value:playerName3}}}}
| {{{rushYds}}}
| {{#external_value:rushYds}}
|-
|-
| Touchdown Runs
| Touchdown Runs
| {{{player}}}
| {{SID|{{#external_value:playerName4}}}}
| {{{rushTDs}}}
| {{#external_value:rushTDs}}
|-
|-
| Receptions
| Receptions
| {{{player}}}
| {{SID|{{#external_value:playerName5}}}}
| {{{receptions}}}
| {{#external_value:receptions}}
|-
|-
| Receiving Yards
| Receiving Yards
| {{{player}}}
| {{SID|{{#external_value:playerName6}}}}
| {{{recYds}}}
| {{#external_value:recYds}}
|-
|-
| Touchdown Catches
| Touchdown Catches
| {{{player}}}
| {{SID|{{#external_value:playerName7}}}}
| {{{recTDs}}}
| {{#external_value:recTDs}}
|-
|-
| Points Scored
| Points Scored
| {{{player}}}
| {{SID|{{#external_value:playerName8}}}}
| {{{points}}}
| {{#external_value:points}}
|-
|-
| Kick Return Yards
| Kick Return Yards
| {{{player}}}
| {{SID|{{#external_value:playerName9}}}}
| {{{kickRetYds}}}
| {{#external_value:kickRetYds}}
|-
|-
| Punt Return Yards
| Punt Return Yards
| {{{player}}}
| {{SID|{{#external_value:playerName10}}}}
| {{{puntRetYds}}}
| {{#external_value:puntRetYds}}
|-
|-
| Tackles
| Tackles
| {{{player}}}
| {{SID|{{#external_value:playerName11}}}}
| {{{tackles}}}
| {{#external_value:tackles}}
|-
|-
| Sacks
| Sacks
| {{{player}}}
| {{SID|{{#external_value:playerName12}}}}
| {{{sacks}}}
| {{#external_value:sacks}}
|-
|-
| Forced Fumbles
| Forced Fumbles
| {{{player}}}
| {{SID|{{#external_value:playerName13}}}}
| {{{forcedFumbles}}}
| {{#external_value:forcedFumbles}}
|-
|-
| Interceptions
| Interceptions
| {{{player}}}
| {{SID|{{#external_value:playerName14}}}}
| {{{interceptions}}}
| {{#external_value:interceptions}}
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}

Latest revision as of 03: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"