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: | |||
|- | |- | ||
! 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 |
