Statistics/sandbox: Difference between revisions

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


<!--- IMPORTING PLAYER ROSTER INFO
<!--- GM SPREADSHEET ROSTER TESTS --->
{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=Players
  |from=Players
  |order by=TeamID ASC
|where=Team='{{{teamCode|}}}'
|data=PID=playerID,jerseynum=Jersey,college=College,yearspro=Experience
  |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
}}
}}


The UFFL has the following players:
{| class="wikitable sortable"
{| class="wikitable"
|-
! PID
! style="color:#AAA"|PID #
! Jersey
! Jersey #
! College
! Position
! XP{{#for_external_table:<nowiki/>
! Name
! Species/College
! Years
! Height (in)
! Weight (lbs)
! OVR Rating
! Current Salary
! Years on Contract
! Injured?
! Injury Weeks Remaining{{#for_external_table:<nowiki/>
{{!}}-
{{!}}-
{{!}} {{{PID}}}
{{!}} {{{pid}}}
{{!}} {{{jerseynum}}}
{{!}} {{{jerseynum}}}
{{!}} {{{college}}}
{{!}} {{{pos}}}
{{!}} {{{yearspro}}}
{{!}} {{{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 %
|-
! #
! Team
! Player
! Record
! #
! Team
! Player
! Record
! #
! Team
! Player
! Record
{{#display_external_table:template=Top10Records}}
|}
{{#clear_external_data:}}
--->
<!--- TEAM ANNUAL STATISTICS FOR TEAM PAGES: Further work would be needed to make this a fully automated template.
{{#get_db_data:
db=ufflData
|from=TeamSeasonStats
|where=Team='CHI'
|order by= Season ASC
|data = season=Season,wins=Wins,losses=Losses,ties=Ties,winPct=WinPct,points=PointsFor,ptsAgainst=PointsAgainst
}}
{{#get_db_data:
db=ufflData
|from=TeamCareerStats
|where=Team='CHI'
|data = totalWins=Wins,totalLosses=Losses,totalTies=Ties,winPctTot=WinPct,totalPts=Points,totalPtsAgst=PointsAgainst
}}
{| class="wikitable sortable"
|-
! colspan="7"|Team Yearly Stats
|-
! Season
! W
! L
! T
! Win %
! PF
! PA
|-
| 2014
| 5
| 11
| 0
| {{Winning percentage|5|11}}
| 262
| 359{{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{season}}}
{{!}} {{{wins}}}
{{!}} {{{losses}}}
{{!}} {{{ties}}}
{{!}} {{{winPct}}}
{{!}} {{{points}}}
{{!}} {{{ptsAgainst}}}
}}
|- class="sortbottom"
|<b>Total:</b>
{{!}} {{#expr:(5+{{#external_value:totalWins}})}}
{{!}} {{#expr:(11+{{#external_value:totalLosses}})}}
{{!}} {{#external_value:totalTies}}
{{!}} {{#external_value:winPctTot}}
{{!}} {{#expr:(262+{{#external_value:totalPts}})}}
{{!}} {{#expr:(359+250+266+288+305+265)}}
|}
|}
--->
--->
Line 85: Line 208:
}}
}}
|}
|}
--->


IMPORTING PLAYER RECORDS
IMPORTING PLAYER RECORDS
Line 120: Line 242:
- Convert/teamid is not working on the TeamID and VsTeamID columns
- 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)
- 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)
--->

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"