Statistics/sandbox: Difference between revisions

From UFFL Wiki
mNo edit summary
mNo edit summary
 
(4 intermediate revisions 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.


<!--- TOP 10 pages --->
<!--- 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
|season=2015
|team=CHI
}}
 
---><!--- TOP 10 pages
{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
Line 9: Line 56:
  |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 63:
  |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 70:
  |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:11px; width: 100%"
|-
|-
! colspan="3" style="border: 1px solid blue" |Pass Attempts
! colspan="4" style="border: 1px solid blue" |Pass Attempts
! colspan="3" style="border: 1px solid green" |Pass Completions
! colspan="4" style="border: 1px solid green" |Pass Completions
! colspan="3" style="border: 1px solid red" |Pass Completion %
! colspan="4" style="border: 1px solid red" |Pass Completion %
|-
|-
! #
! Team
! Team
! Player
! Player
! Record
! Record
! #
! Team
! Team
! Player
! Player
! Record
! Record
! #
! Team
! Team
! Player
! Player
Line 44: Line 91:
|}
|}
{{#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.
Line 76: Line 124:
| 11
| 11
| 0
| 0
|
| {{Winning percentage|5|11}}
| 262
| 262
| 359{{#for_external_table:<nowiki/>
| 359{{#for_external_table:<nowiki/>

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



Retrieved from "https://unitedfurryfootball.com/wiki/index.php?title=Statistics/sandbox&oldid=320"