Template:PlayerSeasonStats: Difference between revisions

From UFFL Wiki
m (testing join on statement)
m (jump-kick...)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
<!--- PASSING STATS ---->
<!--- PASSING STATS ---->  
{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from= PlayerSeasonStats=statistics,Players=players
  |from=PlayerSeasonStats
  |where= statistics.Season='{{{season|}}}' AND statistics.PassYds <> '0'
  |where= Season='{{{season|}}}' AND PassYds <> '0'
|join on = statistics.PlayerID = players.PlayerID
  |limit = 60
  |limit = 60
  |order by= statistics.PassYds DESC
  |order by= PassYds DESC
  |data=position=Position,playerID=players.PlayerID,team=players.Team,games=G,gameStarts=GS,passAtt=PassAtt,passComp=PassCmp,passYds=PassYds,passCmpPct=PassPct,longestpass=PassLong,touchdowns=PassTD,interceptions=PassInt,qbrating=PassRating
  |data=playerID=PlayerID,team=Team,games=G,gameStarts=GS,passAtt=PassAtt,passComp=PassCmp,passYds=PassYds,passCmpPct=PassPct,longestpass=PassLong,touchdowns=PassTD,interceptions=PassInt,qbrating=PassRating
}}
}}
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="13"|{{{season|}}} Passing Statistics
! colspan="12"|{{{season|}}} Passing Statistics
|-
|-
! Name
! Name
! Pos
! Team
! Team
! G
! G

Latest revision as of 00:21, 28 January 2022


Passing Statistics
Name Team G GS PA PC Yds % Lng TD Int Rating


Rushing Statistics
Name Team G Att Yds Avg Lng TD Fum


Receiving Statistics
Name Team G No Yds Avg Lng TD Fum


Defensive Statistics
Name Team G Tck TFL FF/FR Sck Int PD Sfty TD Blk P/XP/FG


Offensive Line Statistics
Name Team G Pancakes Sacks Allowed


Kicking Statistics
Name Team G XPM XPA XP% FGM FGA FG% <20 20-29 30-39 40-49 50+ Lng Pts


Punting Statistics
Name Team G Punts Yds Avg Inside 20 Long


Special Teams Statistics
Name Team G KR KR Yds KR Avg KR Lng KR TD PR PR Yds PR Avg PR Lng PR TD