Statistics/sandbox: Difference between revisions
From UFFL Wiki
(Team roster template created (easy!)) |
m (why is there no Position field in PlayerSeasonStats??? Annoying!) |
||
| Line 3: | Line 3: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=ufflData | db=ufflData | ||
|from= | |from=PlayerSeasonStats | ||
|where= | |where= Season='2015' AND PassYds <> '0' | ||
|order by= | |limit = 60 | ||
|data= | |order by= PassYds DESC | ||
|data=playerID=PlayerID,team=Team,games=G,gameStarts=GS,passAtt=PassAtt,passComp=PassCmp,passYds=PassYds | |||
}} | }} | ||
{| class="wikitable sortable" | {| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | ||
|- | |- | ||
! colspan=" | ! colspan="8"|Passing | ||
|- | |- | ||
! Name | ! Name | ||
! | ! Team | ||
! | ! G | ||
! | ! GS | ||
! | ! PA | ||
! PC | |||
! Yds{{#for_external_table:<nowiki/> | |||
{{!}}- | {{!}}- | ||
{{!}} {{{ | {{!}} {{{playerID}}} | ||
{{!}} {{{ | {{!}} {{{team}}} | ||
{{!}} | {{!}} {{{games}}} | ||
{{!}} {{{ | {{!}} {{{gameStarts}}} | ||
{{!}} {{{ | {{!}} {{{passAtt}}} | ||
{{!}} {{{ | {{!}} {{{passComp}}} | ||
{{!}} {{{ | {{!}} {{{passYds}}} | ||
}} | }} | ||
|} | |} | ||
| Line 146: | Line 147: | ||
}} | }} | ||
|} | |} | ||
IMPORTING PLAYER RECORDS | IMPORTING PLAYER RECORDS | ||
| Line 181: | Line 181: | ||
- Convert/teamid is not working on the TeamID and VsTeamID columns | - Convert/teamid is not working on the TeamID and VsTeamID columns | ||
- I do not know yet how to make the RecordID field meaningful (each number corresponds to a record type, and it may change depending on player position) | - I do not know yet how to make the RecordID field meaningful (each number corresponds to a record type, and it may change depending on player position) | ||
---> | |||
Revision as of 03:30, 26 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.
| Passing | |||||||
|---|---|---|---|---|---|---|---|
| Name | Team | G | GS | PA | PC | Yds | |
| 354 | NYC | 16 | 16 | 574 | 337 | 4152 | |
| 351 | BAL | 16 | 16 | 532 | 322 | 3955 | |
| 335 | FAR | 16 | 16 | 490 | 311 | 3757 | |
| 273 | TEX | 16 | 16 | 504 | 301 | 3610 | |
| 271 | CAL | 16 | 14 | 512 | 312 | 3535 | |
| 248 | LVB | 15 | 15 | 404 | 251 | 3239 | |
| 257 | GRD | 16 | 15 | 527 | 324 | 3214 | |
| 272 | CHI | 14 | 14 | 372 | 212 | 2628 | |
| 274 | EAS | 14 | 11 | 385 | 229 | 2307 | |
| 324 | DWN | 12 | 12 | 376 | 220 | 2188 | |
| 331 | ABI | 12 | 11 | 306 | 150 | 1775 | |
| 690 | NFR | 16 | 16 | 327 | 187 | 1748 | |
| 678 | ABI | 7 | 5 | 202 | 105 | 1017 | |
| 247 | NFR | 9 | 0 | 184 | 112 | 986 | |
| 325 | EAS | 8 | 4 | 124 | 80 | 906 | |
| 380 | CHI | 16 | 2 | 129 | 78 | 872 | |
| 288 | CAL | 5 | 2 | 97 | 55 | 616 | |
| 425 | LVB | 16 | 1 | 45 | 19 | 303 | |
| 698 | DWN | 4 | 2 | 79 | 34 | 284 | |
| 398 | GRD | 9 | 1 | 31 | 20 | 228 | |
| 276 | DWN | 3 | 2 | 44 | 20 | 174 | |
| 322 | FAR | 4 | 0 | 43 | 17 | 164 | |
| 371 | DWN | 16 | 0 | 27 | 17 | 117 | |
| 499 | TEX | 2 | 0 | 13 | 6 | 98 | |
| 256 | NYC | 4 | 0 | 14 | 9 | 96 | |
| 403 | BAL | 16 | 0 | 11 | 4 | 51 | |
