Statistics/sandbox: Difference between revisions

From UFFL Wiki
mNo edit summary
(Team roster template created (easy!))
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.


{{#get_db_data:
db=ufflData
|from=Players
|where=Team='CHI'
|order by= Jersey
|data=position=Position,jerseynum=Jersey,firstName=FirstName,lastName=LastName,speciesCollege=College,height=Height,weight=Weight,yearsPro=Experience
}}
{| class="wikitable sortable"
|-
! colspan="7"|Roster
|-
! Pos
! #
! Name
! Species/College
! Ht (in)
! Wt (lbs)
! Yrs{{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{position}}}
{{!}} {{{jerseynum}}}
{{!}} [[{{{firstName}}} {{{lastName}}}]]
{{!}} {{{speciesCollege}}}
{{!}} {{{height}}}
{{!}} {{{weight}}}
{{!}} {{{yearsPro}}}
}}
|}
<!--- TEAM ANNUAL STATISTICS FOR TEAM PAGES: Further work would be needed to make this a fully automated template.
{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
Line 52: Line 83:
{{!}} {{#expr:(359+250+266+288+305+265)}}
{{!}} {{#expr:(359+250+266+288+305+265)}}
|}
|}
 
--->


<!--- IMPORTING PLAYER SEASON STATS
<!--- IMPORTING PLAYER SEASON STATS

Revision as of 21:50, 25 January 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.


Roster
Pos # Name Species/College Ht (in) Wt (lbs) Yrs
QB 2 Lezra Astrah Dragon / Braylor 72 250 4
K 10 Thalia Perez Bear / SFU 68 150 7
QB 11 Gregory Russell Coyote / Pred Tech 78 234 5
P 14 Rodger Blackman Dog-Neapolitan Mastiff 73 210 13
WR 17 Zeke Carmichael Kingfisher / Baltimore Bay 73 190 12
QB 19 Darius Smith African Wild Dog / Forest Park 74 205 7
RB 23 Ellsworth Starr Swallow-Tree / Harvaardwak 72 195 7
SS 24 Marigold Wu Tibetan Sand Fox - University of California - Santa Bearba 72 210 2
RB 27 Steven Durand Wolverine / Gambling State 71 194 2
RB 32 Willy Redman Marlin-Blue / Florida Aquatic 70 218 1
CB 33 Julius Stafford Canary / Oriole Robin 72 196 10
CB 33 Uka Nakoyak Alaska Hare / Lapine State University 72 190 2
SS 34 Everett Simms Crow / DE Anthro 72 150 7
FB 36 Hiroshige Neo Japanese Serow - UW - Farmside 70 244 2
CB 36 Tina Gaye Penn State 74 222 0
FS 37 Patrice Bush Civet-African Palm / West La. 76 226 10
FS 38 Chi Lim Tennessee 72 184 4
SS 43 John Pressley Panther-Black / Savannah River 73 191 1
LB 43 Elliot Brisette Dog, American Pitbull Terrier / UA Laval 76 260 0
FS 44 Quincy Doss Dog -Canaan / CT Canid 73 230 11
RB 45 Jean-Étienne Tremblay Bear-Brown / UA Laval 76 255 5
LB 51 Erick Farmer Dog- Chihuahua 69 226 7
C 51 Kyle Sykes Turtle / Josephtown 75 319 1
T 52 Ralph Razortusk Boar / Longhorn State 80 315 0
LB 54 Toby Otternator Otter-NA River / Otterville 73 265 7
LB 54 Julian Coronado Jaguar - Wissota 75 253 2
DT 54 Fortuna Angulu Oryx-Scimitar / Gem State 75 277 1
LB 58 Bennie Sierra Horse-Miniature / Iowa College 71 241 9
LB 59 Harlan Freeman Pika- American 72 245 11
C 60 Sam Zapata Hare-Grey / Lapine State 75 260 7
DT 62 Brandon Whitaker West Texas A&M 73 273 0
G 62 Torry Greco Missouri 73 274 0
DE 63 Billy-Bob Robertson Pig / Appalachian Ungulate 75 235 0
DT 66 Ralph Cano Lizard - Cope's Leopard 76 302 14
DE 67 Jamarcus Triper Zebra - Braylor 75 275 2
DT 68 Nathan Mills Tiger-White / CSUF 76 290 3
T 69 Sal Darden Leopard - Snow 75 270 8
G 72 Otis Benitez Cow / Western Illinois 74 300 9
T 73 Leroy Wilcox Air Force 74 315 3
G 74 Edison Schroeder Pied Tamarin / Appalachian Mammal 71 285 10
G 77 Tomas Steiger Dog (White Schnauzer) - Pittsburgh Anthropomorphic College 75 328 2
WR 81 Aaron Ragland Otter - River 75 210 9
TE 82 Lucie Damphousse Otter / UA Laval 74 185 4
TE 83 Byrus Downey Porcupine / MN's West 72 235 9
WR 84 Mtendere Idowu Antelope / Oglethorpe 73 193 1
WR 85 Ricky Mitchell Iguana - Gray's Spiny-tailed 74 195 10
WR 87 Eddie Halstead California 73 182 0
WR 89 Nicholas Baker Jacksonville FL 74 212 1
DE 99 J.J. White Shark- Tiger 77 288 5


IMPORTING PLAYER RECORDS


Records
Record ID Week Season Team Versus Value
1 16 2019 8 5 28
2 9 2021 2 15 100
4 14 2015 8 9 444
5 14 2015 8 9 5
3 6 2016 8 10 3
6 10 2018 8 6 150
7 8 2016 8 12 87
0 16 2019 8 5 43
5 0 2019 8 0 26
7 0 2016 8 0 87
6 0 2018 8 0 97
3 0 2016 8 0 14
4 0 2015 8 0 3955
2 0 2016 8 0 63
1 0 2015 8 0 322
0 0 2015 8 0 532
0 0 2015 8 5 40
1 0 2015 8 9 27
2 0 2015 8 12 72
4 0 2015 8 12 523
5 0 2015 8 9 4
3 0 2015 8 5 2
6 0 2015 8 9 128
7 0 2015 8 12 98

Issues: - 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)