Statistics/sandbox: Difference between revisions
From UFFL Wiki
m (Percentages are coming in as rounded numbers... will look into fixing later) |
No edit summary |
||
| Line 24: | Line 24: | ||
---> | ---> | ||
<!--- IMPORTING PLAYER SEASON STATS | <!--- IMPORTING PLAYER SEASON STATS | ||
{{#get_db_data: | {{#get_db_data: | ||
db = ufflData | db = ufflData | ||
| Line 85: | Line 85: | ||
}} | }} | ||
|} | |} | ||
---> | |||
IMPORTING PLAYER RECORDS | |||
{{#get_db_data: | |||
db = ufflData | |||
|from = PlayerRecords | |||
|where = PlayerID='351' | |||
|order by = RecordType ASC | |||
|data = record=RecordID,week=Week,season=Season,teamID=TeamID,vsteamID=VsTeamID,recordVal=RecordValue | |||
}} | |||
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | |||
|- | |||
! colspan="6"|Records | |||
|- | |||
! Record ID | |||
! Week | |||
! Season | |||
! Team | |||
! Versus | |||
! Value{{#for_external_table:<nowiki/> | |||
{{!}}- | |||
{{!}} {{{record}}} | |||
{{!}} {{{week}}} | |||
{{!}} {{{season}}} | |||
{{!}} {{Convert/teamid|{{{teamID}}}}} | |||
{{!}} {{Convert/teamid|{{{vsteamID}}}}} | |||
{{!}} {{{recordVal}}} | |||
}} | |||
|} | |||
Issues: | |||
- 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) | |||
Revision as of 00:32, 25 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.
IMPORTING PLAYER RECORDS
| Records | |||||
|---|---|---|---|---|---|
| Record ID | Week | Season | Team | Versus | Value |
| 1 | 16 | 2019 | 8 | 5 | 28 |
| 2 | 9 | 2021 | 2 | 15 | 100 |
| 4 | 14 | 2015 | 8 | 9 | 444 |
| 5 | 14 | 2015 | 8 | 9 | 5 |
| 3 | 6 | 2016 | 8 | 10 | 3 |
| 6 | 10 | 2018 | 8 | 6 | 150 |
| 7 | 8 | 2016 | 8 | 12 | 87 |
| 0 | 16 | 2019 | 8 | 5 | 43 |
| 5 | 0 | 2019 | 8 | 0 | 26 |
| 7 | 0 | 2016 | 8 | 0 | 87 |
| 6 | 0 | 2018 | 8 | 0 | 97 |
| 3 | 0 | 2016 | 8 | 0 | 14 |
| 4 | 0 | 2015 | 8 | 0 | 3955 |
| 2 | 0 | 2016 | 8 | 0 | 63 |
| 1 | 0 | 2015 | 8 | 0 | 322 |
| 0 | 0 | 2015 | 8 | 0 | 532 |
| 0 | 0 | 2015 | 8 | 5 | 40 |
| 1 | 0 | 2015 | 8 | 9 | 27 |
| 2 | 0 | 2015 | 8 | 12 | 72 |
| 4 | 0 | 2015 | 8 | 12 | 523 |
| 5 | 0 | 2015 | 8 | 9 | 4 |
| 3 | 0 | 2015 | 8 | 5 | 2 |
| 6 | 0 | 2015 | 8 | 9 | 128 |
| 7 | 0 | 2015 | 8 | 12 | 98 |
Issues: - 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)
