Statistics/sandbox: Difference between revisions
From UFFL Wiki
m (Testing Free Agency list) |
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. | ||
<!--- | <!--- GM SPREADSHEET ROSTER TESTS ---> | ||
{{#get_db_data: | {{#get_db_data: | ||
db=ufflData | db=ufflData | ||
|from=Players | |from=Players | ||
|where= | |where=Team='{{{teamCode|}}}' | ||
|order by= | |order by= Jersey | ||
|data=firstName=FirstName,lastName=LastName, | |data=pid=PlayerID,pos=Position,jerseynum=Jersey,firstName=FirstName,lastName=LastName,speciesCollege=College,ht=Height,wt=Weight,yearsPro=Experience,salary=Salary,ctryrs=ContractYears,injury=Injury,injwks=InjuryLength,rating=Overall | ||
}} | }} | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
! style="color:#AAA"|PID # | |||
! Jersey # | |||
! Position | |||
! Name | ! Name | ||
! Species/College | |||
! Species | ! Years | ||
! | ! Height (in) | ||
! Height | ! Weight (lbs) | ||
! Weight | ! OVR Rating | ||
! OVR{{#for_external_table:<nowiki/> | ! Current Salary | ||
! Years on Contract | |||
! Injured? | |||
! Injury Weeks Remaining{{#for_external_table:<nowiki/> | |||
{{!}}- | {{!}}- | ||
{{!}} | {{!}} {{{pid}}} | ||
{{!}} {{{jerseynum}}} | |||
{{!}} {{{pos}}} | {{!}} {{{pos}}} | ||
{{!}} {{{ | {{!}} {{{firstName}}} {{{lastName}}} | ||
{{!}} {{{ | {{!}} {{{speciesCollege}}} | ||
{{!}} {{{yearsPro}}} | |||
{{!}} {{{ht}}} | {{!}} {{{ht}}} | ||
{{!}} {{{wt}}} | {{!}} {{{wt}}} | ||
{{!}} {{{rating}}} | {{!}} {{{rating}}} | ||
{{!}} {{{salary}}} | |||
{{!}} {{{ctryrs}}} | |||
{{!}} {{{injury}}} | |||
{{!}} {{{injwks}}} | |||
}} | }} | ||
|}{{#clear_external_data:}} | |}{{#clear_external_data:}} | ||
Latest revision as of 02:26, 27 June 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.
| PID # | Jersey # | Position | Name | Species/College | Years | Height (in) | Weight (lbs) | OVR Rating | Current Salary | Years on Contract | Injured? | Injury Weeks Remaining |
|---|
