User:Matosh/sandbox/version: Difference between revisions

From SuperCombo Wiki
(Created page with "====<font style="visibility:hidden; float:right">5lp</font>==== {{MoveDataCargo | title = Stand LP | subtitle = | input = 5LP | images = {{MoveDataCargoImage|Jamie_5...")
 
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
====<font style="visibility:hidden; float:right">5lp</font>====
==Main==
===table test===
{| class="wikitable movedata-flex-framedata-table" style="display: table !important;border-top:solid 5px black;" align="center"
<!--style="display: table !important;"-->
|-
! style="width:25%;" | Startup
! style="width:25%;" | Active
! style="width:25%;" | Recovery
! style="width:25%;" | Invuln
|-
| style="text-align:center;" | {{#if: {{{startup|}}}  | {{{startup}}}    |-}}
| style="text-align:center;" | {{#if: {{{active|}}}    | {{{active}}}    |-}}
| style="text-align:center;" | {{#if: {{{recovery|}}}  | {{{recovery}}}  |-}}
| style="text-align:center;" | {{#if: {{{invuln|}}}    | {{{invuln}}}    |-}}
|- style="line-height:1em"
! style="width:25%;" | Damage
! style="width:25%;" | Guard
! style="width:25%;" | On Hit
! style="width:25%;" | On Block
|-
| style="text-align:center;" | {{#if: {{{damage|}}}  | {{{damage}}}  |-}}
| style="text-align:center;" | {{#if: {{{guard|}}}    | {{{guard}}}    |-}}
| style="text-align:center;" | {{#if: {{{hitAdv|}}}  | {{{hitAdv}}}  |-}}
| style="text-align:center;" | {{#if: {{{blockAdv|}}} | {{{blockAdv}}} |-}}
|}
===table2 test===
<div class="movedata-flex-framedata">
<div class="movedata-flex-framedata-name">
<div id="id-Movevalue1" class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-topright"><!--{{#invoke:MoveDataParser|createFrameDataLink|cargoTable=SF6_FrameData|moveId={{{moveId}}} }}--></div>
<div class="movedata-flex-framedata-name-item">
<div class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-middle">
<div>inputValue</div>
</div>{{#if:NameValue1|
<div class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-middle">
<div style="font-size:80%">NameValue2</div>
<div style="border-bottom: 1px solid black;">testing</div>
 
</div>}}{{#if:Notevalue1|
<div class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-middle">
<div>NoteValue2</div>
</div>}}
</div>
</div>
<!-- this div below is only for viewing purposes. otherwise it needs to be missing for query page to ensure it gets everything-->
</div>
<br><br>
===other===
 
====5LP original====
{{MoveDataCargo
{{MoveDataCargo
| title    = Stand LP
| title    = Stand LP
Line 9: Line 57:
{{AttackDataCargo-SF6/Query|Jamie_5lp}}
{{AttackDataCargo-SF6/Query|Jamie_5lp}}
}}
}}
====5LP bottom border====
{{MoveDataCargo
| title    = Stand LP
| subtitle =
| input    = 5LP
| images  =
{{MoveDataCargoImage|Jamie_5lp|caption=}}
| info    =
{{AttackDataCargo-SF6-test/Query|Jamie_5lp}}
}}
====5LP test border====
{{MoveDataCargo
| title    = Stand LP
| subtitle =
| input    = 5LP
| images  =
{{MoveDataCargoImage|Jamie_5lp|caption=}}
| info    =
{{AttackDataCargo-SF6-test1/Query|Jamie_5lp}}
}}
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test/Query
<br>
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test
<br>
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test1/Query
<br>
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test1
<br>
===Query testing===
<!--{{AttackDataCargo-SF6/Query|Jamie_5lp}}-->
--having=COUNT(*) > 2
|where=<!--name NOT IN ('Blorbo', 'Dragon Knight (Awakening)', 'Swift Master (Awakening)', 'Berserker (Frenzy)', 'Doll Hit')-->
{{AttackDataCargo-SF6/Query|Jamie_5lp|note=}}
<br><br>
===cargo notes===
<code>|fields=</code> is going to hit _pageName and subsequent values.
{{#cargo_query:tables=SF6_FrameData
|fields=_pageName,startup,active,recovery,moveId,chara
|where=chara="Jamie" and moveId="Jamie_5lp"
|format=table
}}
<br>
<!-- this is how you query the amount-->
<!--{{#cargo_query:tables = SF6_FrameData
| fields = count(*)
| where=chara="Jamie" and moveId="Jamie_5lp"
| group by = moveId
| named args = yes
}}-->
{{#cargo_query:tables = SF6_FrameData
| fields = count(*)
| where=chara="Jamie" and moveId="Jamie_5lp"
| group by = moveId
| named args = yes
}}
<br>
{{#ifexpr:2=2| true | false }}<br>
{{#ifexpr:70=1| true | false}}<br>
{{#vardefine:moveCount|{{#cargo_query:tables = SF6_FrameData<!--
-->| fields = count(*)<!--
-->| where=chara="Jamie" and moveId="Jamie_5lp"<!--
-->| group by = moveId<!--
-->| named args = yes}}<!--
-->}}
{{#var:moveCount}}<br>something<br>
{{#expr: 1 and -1 }} <!--1==-1 false so 1-->
<br>
expressions<br>
{{#expr:{{formatnum:{{#var:moveCount}}|R}}+100}}<br>
{{#expr:{{#var:moveCount}}+100}}<br>
{{#expr:9+60}}<br>
{{formatnum:{{#var:moveCount}}|R}}
<br>
<!--stuck here-->
{{#ifexpr:{{formatnum:{{#var:moveCount}}}}>1| greater than 1 | 1 result only}}
<br>
{{#if:{{#var:moveCount}}|{{#var:moveCount}}|}}
====pull table====
<!--{{#cargo_query:tables=SF6_FrameData
|fields=_pageName,startup,active,recovery,moveId,chara
|where=chara="Jamie" and moveId="Jamie_5lp"
|format=table
}}-->
'''Guile'''
{{#cargo_query:tables=SF6_FrameData
|fields=input,startup,active,recovery,hitAdv,blockAdv
|where=chara="Guile"
|format=table
|order by=_rowID
}}
==invoke==
--invoke-- this is the small part to left of data stuff
<div class="movedata-flex-framedata">
<div class="movedata-flex-framedata-name">
<div id="id-{{{moveId}}}" class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-topright">{{#invoke:MoveDataParser|createFrameDataLink|cargoTable=SF6_FrameData|moveId=Jamie_5lp}}</div>
<div class="movedata-flex-framedata-name-item">
<div class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-middle">
<div>{{{input|}}}</div>
</div>{{#if:{{{name|}}}|
<div class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-middle">
<div style="font-size:80%">{{{name}}}</div>
</div>}}{{#if:{{{note|}}}|
<div class="movedata-flex-framedata-name-item movedata-flex-framedata-name-item-middle">
<div>{{{note|}}}</div>
</div>}}
</div>
</div></div>
<br><br>
==AttackDataCargo-SF6==
===Original===
{| class="wikitable movedata-flex-framedata-table" style="display: table !important;"
|-
! style="width:25%;" | Startup
! style="width:25%;" | Active
! style="width:25%;" | Recovery
! style="width:25%;" | Invuln
|-
| style="text-align:center;" | {{#if: {{{startup|}}}  | {{{startup}}}    |-}}
| style="text-align:center;" | {{#if: {{{active|}}}    | {{{active}}}    |-}}
| style="text-align:center;" | {{#if: {{{recovery|}}}  | {{{recovery}}}  |-}}
| style="text-align:center;" | {{#if: {{{invuln|}}}    | {{{invuln}}}    |-}}
|- style="line-height:1em"
! style="width:25%;" | Damage
! style="width:25%;" | Guard
! style="width:25%;" | On Hit
! style="width:25%;" | On Block
|-
| style="text-align:center;" | {{#if: {{{damage|}}}  | {{{damage}}}  |-}}
| style="text-align:center;" | {{#if: {{{guard|}}}    | {{{guard}}}    |-}}
| style="text-align:center;" | {{#if: {{{hitAdv|}}}  | {{{hitAdv}}}  |-}}
| style="text-align:center;" | {{#if: {{{blockAdv|}}} | {{{blockAdv}}} |-}}
|}
===Testing===
{| class="wikitable movedata-flex-framedata-table" style="display: table !important;"
|-
! style="width:25%;" | Startup
! style="width:25%;" | Active
! style="width:25%;" | Recovery
! style="width:25%;" | Invuln
|-
| style="text-align:center;" | {{#if: {{{startup|}}}  | {{{startup}}}    |-}}
| style="text-align:center;" | {{#if: {{{active|}}}    | {{{active}}}    |-}}
| style="text-align:center;" | {{#if: {{{recovery|}}}  | {{{recovery}}}  |-}}
| style="text-align:center;" | {{#if: {{{invuln|}}}    | {{{invuln}}}    |-}}
|- style="line-height:1em"
! style="width:25%;" | Damage
! style="width:25%;" | Guard
! style="width:25%;" | On Hit
! style="width:25%;" | On Block
|-
| style="text-align:center;" | {{#if: {{{damage|}}}  | {{{damage}}}  |-}}
| style="text-align:center;" | {{#if: {{{guard|}}}    | {{{guard}}}    |-}}
| style="text-align:center;" | {{#if: {{{hitAdv|}}}  | {{{hitAdv}}}  |-}}
| style="text-align:center;" | {{#if: {{{blockAdv|}}} | {{{blockAdv}}} |-}}
|- style="line-height:1em"
! colspan="2" | Special cancel?
! colspan="2" | Other?
|-
| colspan="2" style="text-align:center;" | {{#if: {{{damage|}}}  | {{{damage}}}  |-}}
| colspan="2" style="text-align:center;" | {{#if: {{{guard|}}}    | {{{guard}}}    |-}}
|}
<!--
Confirm windows:
Specials & CA: 11
Target Combos: 11
V-Trigger: 11
Cancel options: sp su vt1 vt2
-->
===notes===
using DR0~DR4 to try and parse the data further?

Latest revision as of 11:35, 16 December 2022

Main

table test

Startup Active Recovery Invuln
- - - -
Damage Guard On Hit On Block
- - - -

table2 test

inputValue
NameValue2
testing
NoteValue2



other

5LP original

Stand LP
5LP
Lua error: Wikimedia\Rdbms\Platform\SQLPlatform::makeList: empty input for field main_table.

5LP
Stand LP (DL0)
Startup Active Recovery Cancel Damage Guard On Hit On Block
5 2 7 Sp SA 270 LH +5 0

5LP bottom border

Stand LP
5LP
Lua error: Wikimedia\Rdbms\Platform\SQLPlatform::makeList: empty input for field main_table. 

                  Template:AttackDataCargo-SF6-test

5LP test border

Stand LP
5LP
Lua error: Wikimedia\Rdbms\Platform\SQLPlatform::makeList: empty input for field main_table. 

                  Template:AttackDataCargo-SF6-test1



https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test/Query
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test1/Query
https://wiki.supercombo.gg/w/Template:AttackDataCargo-SF6-test1

Query testing

--having=COUNT(*) > 2 |where=

5LP
Stand LP (DL0)
Startup Active Recovery Cancel Damage Guard On Hit On Block
5 2 7 Sp SA 270 LH +5 0



cargo notes

|fields= is going to hit _pageName and subsequent values.

_pageName startup active recovery moveId chara
Street Fighter 6/Jamie/Data 5 2 7 Jamie_5lp Jamie


1
true
false

1
something
1
expressions
Expression error: Unrecognized punctuation character "".
Expression error: Unrecognized punctuation character "".
69
1
Expression error: Unrecognized punctuation character "".
1

pull table

Guile

input startup active recovery hitAdv blockAdv
5LP 5 3 7 +4 -2
5MP 7 3 15 +6 0
5HP 7 3 23 -1 -6
5LK 5 2 12 +3 -1
5MK 7 5 18 +1 -4
5HK 13 3 21 +3 -4
2LP 4 3 8 +5 -2
2MP 6 3 13(16) +4 -2
2HP 9 5 20 0 -9
2LK 5 2 13 +1 -5
2MK 8 3 18 +4 -5
2HK 9 2(16)3 21 HKD +34 -12
j.LP 4 10 3 land +4(+9) 0(+5)
j.MP 7 3 3 land +9(+11) +5(+7)
j.HP 9 4 3 land +7(+15) +3(+11)
j.LK 6 10 3 land +5(+10) +1(+6)
j.MK 7 7 3 land +11(+13) +7(+9)
j.HK 10 5 3 land +10(+15) +6(+11)
6MP 20 3 19 +2 -3
6HP 16 3 20 +5 +3
4HP 9 3 21 +1 -4
4LK 8 5 15 0(+4) -4(0)
4MK or 6MK 11 3 18(21) +3 -6
6HK 17 3 26 -1 -8
3HK 10 3 23 0 -9
5MP~4HP 16 3 26 KD +35 -9
2MP~2MP 12 3 16 KD +44 -6
2MK~6MP 20 3 21 +1 -5
2HK~3HK 10 3 25 KD +33 -10(-30)
LPLK 5 3 23 KD +15 -
4LPLK 5 3 23 KD +18 -
LPLK (air) 5 3 3 land KD +21(23) -
4LPLK (air) 5 3 3 land KD +15 -
HPHK 26 2 35 KD +35 / Wall Splat KD +65 -3 / Wall Splat HKD +72
6HPHK 20 3 26(31) KD +23 -6
6HPHK 18 3 26(31) KD +23 -6
MPMK 1 12 or until released 33(1)(11) - -
MPMK~66 3+8 - 15(37) - -
MPMK or 66 9 - 15(37) - -
[4]6LP 10 - 30 +3(+4) -3
[4]6MP 10 - 30 +3(+4) -3
[4]6HP 10 - 30 +3(+4) -3
[4]6PP 10 - 28 KD +48 +3
[2]8LK 5 6 26+15 land KD +36 -30
[2]8MK 6 6 27+15 land KD +37 -31
[2]8HK 7 6 28+15 land KD +39 -32
[2]8KK 6 4,2 26+20 land KD +29 -33(-37)
214LP 16 [45] 26 -3 -4
214MP 21 [85] 29 -6 -7
214HP 31 [100] 23 +1 -1
214P ~ 6P 10 - 28 KD +44~ -1
214P ~ 6PP 10 - 28 KD +48~ +3
214PP 15 [100] 24 KD +57 -4
214PP ~ 6P 10 - 28 KD +47 -3
214PP ~ 6PP 10 - 28 KD Spin + Splat +3
PP 11 - 25 +2 -2
[4]6P~P 11 - 25 +2 -2
[4]6PP~P 11 - 24 KD +54~ +3
[4]646P 8(11) 51 81 KD +41 -26
[4]646HP 7 52 68 KD +70 -2
214214P 1 (1500) 5 - -
[4]646K 9 6 30+40 land HKD +16 -59
[4]646K 9 6 30+40 land HKD +16 -59
5PPPKKK 116 (total) - - - -
6PPPKKK 225 (total) - - - -
4PPPKKK 325 (total) - - - -
2PPPKKK 73 (total) - - - -

invoke

--invoke-- this is the small part to left of data stuff



AttackDataCargo-SF6

Original

Startup Active Recovery Invuln
- - - -
Damage Guard On Hit On Block
- - - -

Testing

Startup Active Recovery Invuln
- - - -
Damage Guard On Hit On Block
- - - -
Special cancel? Other?
- -


notes

using DR0~DR4 to try and parse the data further?

Retrieved from "https://wiki.supercombo.gg/index.php?title=User:Matosh/sandbox/version&oldid=246684"