Statistics/sandbox: Difference between revisions
From UFFL Wiki
mNo edit summary |
mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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: | |||
db=ufflData | |||
|from=Players | |||
|where=Team='{{{teamCode|}}}' | |||
|order by= Jersey | |||
|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" | |||
|- | |||
! style="color:#AAA"|PID # | |||
! Jersey # | |||
! Position | |||
! Name | |||
! Species/College | |||
! Years | |||
! Height (in) | |||
! Weight (lbs) | |||
! OVR Rating | |||
! Current Salary | |||
! Years on Contract | |||
! Injured? | |||
! Injury Weeks Remaining{{#for_external_table:<nowiki/> | |||
{{!}}- | |||
{{!}} {{{pid}}} | |||
{{!}} {{{jerseynum}}} | |||
{{!}} {{{pos}}} | |||
{{!}} {{{firstName}}} {{{lastName}}} | |||
{{!}} {{{speciesCollege}}} | |||
{{!}} {{{yearsPro}}} | |||
{{!}} {{{ht}}} | |||
{{!}} {{{wt}}} | |||
{{!}} {{{rating}}} | |||
{{!}} {{{salary}}} | |||
{{!}} {{{ctryrs}}} | |||
{{!}} {{{injury}}} | |||
{{!}} {{{injwks}}} | |||
}} | |||
|}{{#clear_external_data:}} | |||
<!--- TEAM SEASON LEADERS | |||
{{TeamLeaderStats | {{TeamLeaderStats | ||
|season=2015 | |season=2015 | ||
| Line 7: | Line 48: | ||
}} | }} | ||
<!--- TOP 10 pages | ---><!--- TOP 10 pages | ||
{{#get_db_data: | {{#get_db_data: | ||
db=ufflData | db=ufflData | ||
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 |
|---|
