Template:TeamLeaderStats: Difference between revisions

From UFFL Wiki
(WIP)
 
(WIP)
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
  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
|data=season=Season,team=Team
}}<!--- Then start importing individual 'Leader' values --->{{#get_db_data:
db=ufflData
|from=PlayerSeasonStats
|where= Season='{{{season}}}' AND Team = '{{{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,rushYds=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
|from=PlayerSeasonStats
|where= Season='{{{season}}}' AND Team = '{{{team}}}'
|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="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 70%" class="wikitable sortable"  
Line 15: Line 114:
|-
|-
| Passing Yards
| Passing Yards
| {{{player}}}
| {{{playerName1}}}
| {{{passYds}}}
| {{{passYds}}}
|-
|-
| Touchdown Passes
| Touchdown Passes
| {{{player}}}
| {{{playerName2}}}
| {{{passTDs}}}
| {{{passTDs}}}
|-
|-
| Rushing Yards
| Rushing Yards
| {{{player}}}
| {{{playerName3}}}
| {{{rushYds}}}
| {{{rushYds}}}
|-
|-
| Touchdown Runs
| Touchdown Runs
| {{{player}}}
| {{{playerName4}}}
| {{{rushTDs}}}
| {{{rushTDs}}}
|-
|-
| Receptions
| Receptions
| {{{player}}}
| {{{playerName5}}}
| {{{receptions}}}
| {{{receptions}}}
|-
|-
| Receiving Yards
| Receiving Yards
| {{{player}}}
| {{{playerName6}}}
| {{{recYds}}}
| {{{recYds}}}
|-
|-
| Touchdown Catches
| Touchdown Catches
| {{{player}}}
| {{{playerName7}}}
| {{{recTDs}}}
| {{{recTDs}}}
|-
|-
| Points Scored
| Points Scored
| {{{player}}}
| {{{playerName8}}}
| {{{points}}}
| {{{points}}}
|-
|-
| Kick Return Yards
| Kick Return Yards
| {{{player}}}
| {{{playerName9}}}
| {{{kickRetYds}}}
| {{{kickRetYds}}}
|-
|-
| Punt Return Yards
| Punt Return Yards
| {{{player}}}
| {{{playerName10}}}
| {{{puntRetYds}}}
| {{{puntRetYds}}}
|-
|-
| Tackles
| Tackles
| {{{player}}}
| {{{playerName11}}}
| {{{tackles}}}
| {{{tackles}}}
|-
|-
| Sacks
| Sacks
| {{{player}}}
| {{{playerName12}}}
| {{{sacks}}}
| {{{sacks}}}
|-
|-
| Forced Fumbles
| Forced Fumbles
| {{{player}}}
| {{{playerName13}}}
| {{{forcedFumbles}}}
| {{{forcedFumbles}}}
|-
|-
| Interceptions
| Interceptions
| {{{player}}}
| {{{playerName14}}}
| {{{interceptions}}}
| {{{interceptions}}}
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}

Revision as of 20:44, 30 January 2021


Team Leaders
Category Player(s) Value
Passing Yards {{{playerName1}}} {{{passYds}}}
Touchdown Passes {{{playerName2}}} {{{passTDs}}}
Rushing Yards {{{playerName3}}} {{{rushYds}}}
Touchdown Runs {{{playerName4}}} {{{rushTDs}}}
Receptions {{{playerName5}}} {{{receptions}}}
Receiving Yards {{{playerName6}}} {{{recYds}}}
Touchdown Catches {{{playerName7}}} {{{recTDs}}}
Points Scored {{{playerName8}}} {{{points}}}
Kick Return Yards {{{playerName9}}} {{{kickRetYds}}}
Punt Return Yards {{{playerName10}}} {{{puntRetYds}}}
Tackles {{{playerName11}}} {{{tackles}}}
Sacks {{{playerName12}}} {{{sacks}}}
Forced Fumbles {{{playerName13}}} {{{forcedFumbles}}}
Interceptions {{{playerName14}}} {{{interceptions}}}
Retrieved from "https://unitedfurryfootball.com/wiki/index.php?title=Template:TeamLeaderStats&oldid=283"