View source for User:Matosh

I work on frame data.
My [https://twitter.com/matosh_lee Twitter] link can be found here. Please contact me here if anything is needed or via the dustloop discord.

My edits can be found here: https://www.dustloop.com/wiki/index.php?title=Special:Contributions/Matosh

==test bed 0 ==
===Test sample===
====table test====

{| class='wikitable sortable' style="text-align: center; margin: 1em auto 1em auto;"
|+Wild Assault Chart
|-
! Color !! Characters !! Startup !! active !! recovery !! on Block !! cancel !! invuln
|-
| {{clr|D|Orange}} || {{Character Label|GGST|Sol}} {{Character Label|GGST|Ky}} {{Character Label|GGST|May}}<br>{{Character Label|GGST|Axl}} {{Character Label|GGST|Chipp}} {{Character Label|GGST|Ramlethal}}<br>{{Character Label|GGST|Leo}} {{Character Label|GGST|Giovanna}} {{Character Label|GGST|Anji}}<br>{{Character Label|GGST|I-No}} {{Character Label|GGST|Testament}} {{Character Label|GGST|Sin}} {{Character Label|GGST|Johnny}} || 16 [28] || 3 || 20 || -4 || yes
|-
| {{clr|K|Blue}} || {{Character Label|GGST|Faust}} {{Character Label|GGST|Millia}} {{Character Label|GGST|Zato}}<br>{{Character Label|GGST|Jack-O}} {{Character Label|GGST|Happy Chaos}}<br>{{Character Label|GGST|Baiken}} {{Character Label|GGST|Bridget}} {{Character Label|GGST|Asuka}} || 20 [32] || 3 || 20 || +12 [+17] || yes ||
|-
| White || {{Character Label|GGST|Potemkin}} {{Character Label|GGST|Nagoriyuki}}<br>{{Character Label|GGST|Goldlewis}} {{Character Label|GGST|Bedman}}|| 20 [32] || 3 || 20 || +7 [+12] || no ||  9~22 [9~34] strike
|}

====X move chart====
<center><b>X Values</b>
{{#cargo_query:tables=MoveData_GGST, MoveData_GGST__notes
|join on=MoveData_GGST._ID=MoveData_GGST__notes._rowID
|fields=chara=Character,input, images,hitboxes,startup=Startup,active=Active,recovery=Recovery,ROUND(startup + active + recovery - 1, 0)=Total Duration,level=Level,onBlock=On-Block,onHit=On-Hit,notes,SUBSTRING(MoveData_GGST__notes._value, 30, 3)=Input Proximity Range
|where=input="236D"
|group by=chara
|format=dynamic table|order by=chara,_rowID|rows per page=50
|details fields=notes,images,hitboxes
}}
</center>

===count rows===
<center><b>move chart testing</b>
{{#cargo_query:tables=MoveData_GGST
|fields=_rowID,chara,input,images,hitboxes,startup,active,recovery,onBlock,onHit,invuln,notes
|where= input like "2S%" and chara="Nagoriyuki"
|format=dynamic table|order by=_rowID|rows per page=50
|details fields=notes,images,hitboxes
}}
</center>

count check
<code>
query count
if: count > 1
then: add bar at bottom or top of each move
else: do what you normally would do.
</code><br>
maybe use nested? or at least nested IF's
<br>
https://www.mediawiki.org/wiki/Template:If
<br>
<code><noinclude>{{#if|expr|2<3| p | q }}</noinclude></code><br>
{{#ifexpr:2=2| true | false }}<br>
{{#ifexpr:70=1| true | false}}
<br>
{{#cargo_query:tables=MoveData_GGST
|fields=count(*)=moveCount
|where= input like "2S%" and chara="Nagoriyuki"
|groupby = chara
|format=dynamic table|order by=_rowID|rows per page=50
|details fields=notes,images,hitboxes
}}

===proration table===
{{#cargo_query:tables=MoveData_GGST
|fields=chara, count(*)=proration
|where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special")
|groupby =chara
|format=dynamic table|order by=_rowID|rows per page=50
}}
<br>

{{#cargo_query:tables=MoveData_GGST=tableMoves,ggstCharacters=tableChar
|join on =tableMoves.name=tableChar.name
|fields=chara, count(*)=proration
|where=prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special")
|group by =chara
|format=dynamic table
}}

<br>
'''testing better'''
{{#cargo_query:tables=MoveData_GGST=tableMoves,ggstCharacters=tableChar
|join on =tableMoves.name=tableChar.name
|fields=tableMoves._pageName,count(*)
|where=prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special")
|groupby =tableMoves._pageName
|format=dynamic table
}}
<!--{{#cargo_compound_query:
tables=MoveData_GGST;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara="Ramlethal Valentine"
|tables=MoveData_GGST;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara="Zato-1"
;fields=chara, count(*)=proration
;group by=chara
|format=dynamic table
}}-->
<br>
====somewhat working but tedious====
{{#cargo_compound_query:
tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Anji Mito"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Axl Low"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Baiken"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Bridget"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Chipp Zanuff"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Faust"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Giovanna"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Goldlewis Dickinson"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Happy Chaos"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "I-No"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Jack-O"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Ky Kiske"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara like "Leo Whitefang%"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "May"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Millia Rage"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Nagoriyuki"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Potemkin"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Ramlethal Valentine"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Sin Kiske"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Sol Badguy"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Testament"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|tables=MoveData_GGST,ggstCharacters;join on=MoveData_GGST.chara=ggstCharacters.name;where= prorate="90%" and input not in ("c.S","5D", "5[D]") and type in ("normal", "special") and chara= "Zato-1"
;fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera, count(*)=proration
|format=dynamic table|order by=_rowID|rows per page=50}}

=== Reversal Values ===
<center><b>Reversal Values</b>
{| class='wikitable sortable' style="text-align: center; margin: 1em auto 1em auto;"
|+Meterless reversal
|-
!class="unsortable" rowspan=2| Startup
|-
!data-sort-type="number" | Character and Move 
|-
! 9f
|{{MiniMoveCard|game=BBCF|chara=Hibiki Kohaku|input=623C|label=Hibiki {{clr|C|623C}}}}<br>{{MiniMoveCard|game=BBCF|chara=Kagura Mutsuki|input=[2]8C|label=Kagura {{clr|C|[2]8C}}}}<br>{{MiniMoveCard|game=BBCF|chara=Makoto Nanaya|input=623C|label=Makoto {{clr|C|623C}}}}<br>{{MiniMoveCard|game=BBCF|chara=Naoto Kurogane|input=623D|label=Naoto {{clr|D|623D}}}}<br>{{MiniMoveCard|game=BBCF|chara=Ragna the Bloodedge|input=623C|label=Ragna {{clr|C|623C}}}}
|-
! 10f
| Tsubaki {{MiniMoveCard|game=BBCF|chara=Tsubaki Yayoi|input=623C|label={{clr|C|623C}}}} or {{MiniMoveCard|game=BBCF|chara=Tsubaki Yayoi|input=623D|label={{clr|D|623D}}}}
|-
! 11f
| {{MiniMoveCard|game=BBCF|chara=Litchi Faye Ling |input=623Dm |label=Litchi {{clr|D|623Dm}}}}<br>{{MiniMoveCard|game=BBCF|chara=Platinum the Trinity |input=5D Bat |label=Platinum {{clr|D|5D Bat}}}}
|-
! 12f
| {{MiniMoveCard|game=BBCF|chara=Susano'o |input=623C |label=Susano'o {{clr|C|623C}}}}
|-
! 13f
| {{MiniMoveCard|game=BBCF|chara=Es |input=623C |label=Es {{clr|C|623C}}}}<br>{{MiniMoveCard|game=BBCF|chara=Celica A. Mercury |input=236C |label=Celica {{clr|C|236C}} (guardpoint)}}<br>Jin {{MiniMoveCard|game=BBCF|chara=Jin Kisaragi |input=623C |label={{clr|C|623C}}}} or {{MiniMoveCard|game=BBCF|chara=Jin Kisaragi |input=623D |label={{clr|D|623D}}}}
|-
! 14f 
| {{MiniMoveCard|game=BBCF|chara=Bullet |input=623B |label=Bullet {{clr|B|623B}}}}<br>{{MiniMoveCard|game=BBCF|chara=Mu-12 |input=623C |label=Mu-12 {{clr|C|623C}}}}
|-
! 15f
| {{MiniMoveCard|game=BBCF|chara=Izayoi |input=623C |label=Izayoi {{clr|C|623C}}}}
|-
! 18f
| {{MiniMoveCard|game=BBCF|chara=Azrael |input=623B |label=Azrael {{clr|B|623B}}}}
|-
! 22f
| {{MiniMoveCard|game=BBCF|chara=Nine the Phantom |input=214D with spell |label=Nine {{clr|D|214D}}}}
|-
! 26f
| {{MiniMoveCard|game=BBCF|chara=Lambda-11 |input=22D |label=Lambda-11 {{clr|D|22D}} (situational)}}
|}
</center>

==Test best==
===6P chart Xrd===

{{#cargo_query:tables=MoveData_GGXRDR2
|fields=chara,input,startup,active,recovery,onBlock,invuln,images,hitboxes,notes
|where=input="5D" and type="normal"
|format=dynamic table|order by=_rowID|rows per page=50
|details fields=notes,images,hitboxes
}}


===Reversal chart===
<center><b>reversal chart testing</b>
{{#cargo_query:tables=MoveData_GGST, ggstCharacters
|join on=MoveData_GGST.chara=ggstCharacters.name
|fields=CONCAT('[[file:', icon, '|24px|link=]] ', ggstCharacters.name)=Charactera,MoveData_GGST.input,MoveData_GGST.startup,MoveData_GGST.onBlock,MoveData_GGST.invuln,MoveData_GGST.notes
|image width=20px
|image height=20px
|where= MoveData_GGST.notes holds like "reversal%"
|format=dynamic table|order by=MoveData_GGST._rowID|rows per page=50
|details fields=MoveData_GGST.notes
}}
</center>
<!--|join on=MoveData_GGACR.chara=ggacrCharacters.name-->
<!--{{#cargo_query:tables=MoveData_GGACR,ggacrCharacters
|join on=MoveData_GGACR.chara=ggacrCharacters.name
}}-->

===move chart===
<center><b>move chart testing</b>
{{#cargo_query:tables=MoveData_GGST
|fields=chara,input,images,hitboxes,startup,active,recovery,onBlock,onHit,invuln,notes
|where= input="c.S"
|format=dynamic table|order by=_rowID|rows per page=50
|details fields=notes,images,hitboxes
}}
</center>
====testing====

<br>
{{clr|2|236K}} <code><nowiki>{{clr|2|236K}}</nowiki></code><br>
{{clr|K|236K}} <code><nowiki>{{clr|K|236K}}</nowiki></code><br>
{{clr|GGST-K|236K}} <code><nowiki>{{clr|GGST-K|236K}}</nowiki></code><br>

===Lazy links for WIP===
https://www.dustloop.com/wiki/index.php?title=Template:MoveData-DNFD

https://www.dustloop.com/wiki/index.php?title=Template:DNFD-character

https://www.dustloop.com/wiki/index.php?title=Template:DNFD_Move_Card

https://www.dustloop.com/wiki/index.php?title=Template:DNFD-Character-infobox

https://www.dustloop.com/wiki/index.php?title=User:Matosh/Sandbox

===Testing css===
https://www.dustloop.com/wiki/index.php?title=User:Matosh/sandbox/Template:TestClr

https://www.dustloop.com/wiki/index.php?title=User:Matosh/sandbox/Template:TestClr/styles.css

https://www.dustloop.com/w/MediaWiki:Common.css