Statistics/sandbox: Difference between revisions

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


<!--- UFFL GAME RECORDS ---->
<!--- GM SPREADSHEET ROSTER TESTS --->
{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=LeagueRecords=records,RecordNames=names
  |from=Players
  |where=RecordType = '0'
  |where=Team='{{{teamCode|}}}'
  |order by= RecordID DESC
  |order by= Jersey
|data=recordName=records.RecordID,season=Season,week=Week,name=PlayerID,playerTeam=TeamID,vsTeam=VsTeamID,recordValue=RecordValue
|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
}}
}}
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
 
{| class="wikitable sortable"
|-
|-
! colspan="12"|UFFL Game Records
! 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:
db=ufflData
|from=PlayerCareerStats
|where=PassAtt <> '0'
|order by= PassAtt DESC
|limit = 10
|data=team1=Team,playerName1=PlayerID,recordValue1=PassAtt
}}{{#get_db_data:
db=ufflData
|from=PlayerCareerStats
|where=PassCmp <> '0'
|order by= PassCmp DESC
|limit = 10
|data=team2=Team,playerName2=PlayerID,recordValue2=PassCmp
}}{{#get_db_data:
db=ufflData
|from=PlayerCareerStats
|where=PassPct <> '0'
|order by= PassPct DESC
|limit = 10
|data=team3=Team,playerName3=PlayerID,recordValue3=PassPct
}}{| class="wikitable" style="border:0; font-size:12px; width: 100%"
|-
! colspan="4" style="border: 1px solid blue" |Pass Attempts
! colspan="4" style="border: 1px solid green" |Pass Completions
! colspan="4" style="border: 1px solid red" |Pass Completion %
|-
|-
! Record Name
! #
! Season
! Team
! Week
! Player
! Player
! Record
! #
! Team
! Team
! Versus
! Player
! Record
! Record
{{#display_external_table:template=RecordsLeagueGame}}
! #
! Team
! Player
! Record
{{#display_external_table:template=Top10Records}}
|}
|}
{{#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 55: 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"