Template:PlayerRecords: Difference between revisions
From UFFL Wiki
m (The view's columns need to all be in lowercase. Dumb af) |
m (Uffladmin moved page Template:PlayerRecords/QB to Template:PlayerRecords without leaving a redirect: Works for all positions) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
db = ufflData | db = ufflData | ||
|from = playerRecordsLabeled | |from = playerRecordsLabeled | ||
|where = playerid='{{{PID|}}}' | |where = playerid='{{{PID|}}}' AND recordtype='0' | ||
|order by= recordid ASC | |order by= recordid ASC | ||
|data=name=recordname,wk=week,season=season,team= | |data=name=recordname,wk=week,season=season,team=teamabbr,vsteam=vsteamabbr,value=recordvalue | ||
}} | }} | ||
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | {| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | ||
| Line 24: | Line 24: | ||
{{!}} {{{value}}} | {{!}} {{{value}}} | ||
}} | }} | ||
|} | |}{{#clear_external_data:}} | ||
<!--- For whatever dumb reason, when recordtype equals 1, the view does not add those records to the view. So this is blanked out until that issue is resolved. | |||
{{#get_db_data: | |||
db = ufflData | |||
|from = playerRecordsLabeled | |||
|where = playerid='{{{PID|}}}' AND recordtype='1' | |||
|order by= recordid ASC | |||
|data=name=recordname,wk=week,season=season,team=teamabbr,vsteam=vsteamabbr,value=recordvalue | |||
}} | |||
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | |||
|- | |||
! colspan="6" style="text-align: left; font-size: 16px"|Season Records | |||
|- | |||
! Record | |||
! Season | |||
! Week | |||
! Team | |||
! vs. Team | |||
! Value{{#for_external_table:<nowiki/> | |||
{{!}}- | |||
{{!}} {{{name}}} | |||
{{!}} {{{season}}} | |||
{{!}} {{{wk}}} | |||
{{!}} {{{team}}} | |||
{{!}} {{{vsteam}}} | |||
{{!}} {{{value}}} | |||
}} | |||
|}{{#clear_external_data:}}---> | |||
{{#get_db_data: | |||
db = ufflData | |||
|from = playerRecordsLabeled | |||
|where = playerid='{{{PID|}}}' AND recordtype='2' | |||
|order by= recordid ASC | |||
|data=name=recordname,season=season,team=teamabbr,vsteam=vsteamabbr,value=recordvalue | |||
}} | |||
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | |||
|- | |||
! colspan="5" style="text-align: left; font-size: 16px"|Playoff Records | |||
|- | |||
! Record | |||
! Season | |||
! Team | |||
! vs. Team | |||
! Value{{#for_external_table:<nowiki/> | |||
{{!}}- | |||
{{!}} {{{name}}} | |||
{{!}} {{{season}}} | |||
{{!}} {{{team}}} | |||
{{!}} {{{vsteam}}} | |||
{{!}} {{{value}}} | |||
}} | |||
|}{{#clear_external_data:}} | |||
Latest revision as of 02:12, 30 June 2021
| Game Records | |||||
|---|---|---|---|---|---|
| Record | Season | Week | Team | vs. Team | Value |
| Playoff Records | ||||
|---|---|---|---|---|
| Record | Season | Team | vs. Team | Value |
