Statistics/sandbox: Difference between revisions
From UFFL Wiki
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
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. | 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. | ||
<!--- TOP 10 pages ---> | |||
{{#get_db_data: | |||
db=ufflData | |||
|from=PlayerCareerStats | |||
|where=PassAtt <> '0' | |||
|order by= PassAtt DESC | |||
|limit = 10 | |||
|data=team1=Team,playerName1=PlayerID,recordValue1=PassAtt | |||
}} | |||
{{#get_db_data: | |||
db=ufflData | |||
|from=PlayerCareerStats | |||
|where=PassCmp <> '0' | |||
|order by= PassCmp DESC | |||
|limit = 10 | |||
|data=team2=Team,playerName2=PlayerID,recordValue2=PassCmp | |||
}} | |||
{{#get_db_data: | |||
db=ufflData | |||
|from=PlayerCareerStats | |||
|where=PassPct <> '0' | |||
|order by= PassPct DESC | |||
|limit = 10 | |||
|data=team3=Team,playerName3=PlayerID,recordValue3=PassPct | |||
}} | |||
{| 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 green" |Pass Completions | |||
! colspan="3" style="border: 1px solid red" |Pass Completion % | |||
|- | |||
! Team | |||
! Player | |||
! Record | |||
! Team | |||
! Player | |||
! Record | |||
! Team | |||
! Player | |||
! Record | |||
{{#display_external_table:template=Top10Records}} | |||
|} | |||
{{#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:13, 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 |
