Statistics/sandbox: Difference between revisions

From UFFL Wiki
mNo edit summary
mNo edit summary
Line 9: Line 9:
  |limit = 10
  |limit = 10
  |data=team1=Team,playerName1=PlayerID,recordValue1=PassAtt
  |data=team1=Team,playerName1=PlayerID,recordValue1=PassAtt
}}
}}{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerCareerStats
  |from=PlayerCareerStats
Line 17: Line 16:
  |limit = 10
  |limit = 10
  |data=team2=Team,playerName2=PlayerID,recordValue2=PassCmp
  |data=team2=Team,playerName2=PlayerID,recordValue2=PassCmp
}}
}}{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerCareerStats
  |from=PlayerCareerStats
Line 25: Line 23:
  |limit = 10
  |limit = 10
  |data=team3=Team,playerName3=PlayerID,recordValue3=PassPct
  |data=team3=Team,playerName3=PlayerID,recordValue3=PassPct
}}
}}{| class="wikitable" style="border:0; font-size:12px; width: 100%"
{| class="wikitable" style="border:0; font-size:11px; width: 100%"
|-
|-
! colspan="3" style="border: 1px solid blue" |Pass Attempts
! colspan="3" style="border: 1px solid blue" |Pass Attempts
Line 44: Line 41:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}


<!--- TEAM ANNUAL STATISTICS FOR TEAM PAGES: Further work would be needed to make this a fully automated template.
<!--- TEAM ANNUAL STATISTICS FOR TEAM PAGES: Further work would be needed to make this a fully automated template.

Revision as of 03:18, 29 January 2021

Mad is using this sandbox to review a variety of ways data can be imported from the DDSPF2021 MDB file (via MySQL) into meaningful information for the Wiki.

Pass Attempts Pass Completions Pass Completion %
Team Player Record Team Player Record Team Player Record
1 EAS Draco Lindwurm 2567 1 EAS Draco Lindwurm 1551 1 GRD Morton Ritter 66
1 DWN Aspen Redfield 2530 1 DWN Aspen Redfield 1550 1 NYC Andre Botkis 64
1 CHI Darius Smith 2438 1 COL Christina Carson 1505 1 MTL Tyron Appleby 64
1 COL Christina Carson 2408 1 LVB Sylvester Stapler 1494 1 LVB Sylvester Stapler 63
1 TEX Andrew Calder 2374 1 CHI Darius Smith 1466 1 COL Christina Carson 62
1 LVB Sylvester Stapler 2354 1 TEX Andrew Calder 1436 1 NSH Kiedo Masquarde 62
1 RIC Darnell Paige 2155 1 RIC Darnell Paige 1309 1 MIA Terence Curran 62
1 NSH Kiedo Masquarde 1967 1 NSH Kiedo Masquarde 1234 1 DWN Aspen Redfield 61
1 NYC Adrie Dawkins 1730 1 MIA Terence Curran 1053 1 DWN Joe McJamison 61
1 MIA Terence Curran 1683 1 NYC Adrie Dawkins 1009 1 NOC Flip Penguinator 61