Template:PlayerSeasonStats: Difference between revisions

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

@@ Line 1: / Line 1: @@
 <!--- PASSING STATS ---->
 {{#get_db_data:
   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
-  |order by= statistics.PassYds DESC
+  |order by= PassYds DESC
-  |data=position=Position,playerID=statistics.PlayerID,team=statistics.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"
 |-
-! colspan="13"|{{{season|}}} Passing Statistics
+! colspan="12"|{{{season|}}} Passing Statistics
 |-
 ! Name
-! Pos
 ! Team
 ! G