User:Matosh/sandbox/version: Difference between revisions

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

/Data#5LP

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?

@@ Line 42: / Line 42: @@
 		</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===
-===other===
+====5LP original====
-====<font style="visibility:hidden; float:right">5lp</font>====
+{{MoveDataCargo
+| title    = Stand LP
+| subtitle =
+| input    = 5LP
+| images   =
+{{MoveDataCargoImage|Jamie_5lp|caption=}}
+| info     =
+{{AttackDataCargo-SF6/Query|Jamie_5lp}}
+}}
+====5LP bottom border====
 {{MoveDataCargo
 | title    = Stand LP
@@ Line 54: / Line 67: @@
 {{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>
@@ Line 73: / Line 104: @@
 |format=table
 }}
-<br><br>
+<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==
+--invoke-- this is the small part to left of data stuff
 <div class="movedata-flex-framedata">
 	<div class="movedata-flex-framedata-name">
@@ Line 91: / Line 171: @@
 			</div>}}
 		</div>
-	</div>
+	</div></div>
+<br><br>
-===AttackDataCargo-SF6===
+==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;"
 |-
@@ Line 115: / Line 219: @@
 | style="text-align:center;" | {{#if: {{{hitAdv|}}}   | {{{hitAdv}}}   |-}}
 | style="text-align:center;" | {{#if: {{{blockAdv|}}} | {{{blockAdv}}} |-}}
-|}</div></includeonly><noinclude>
+|- 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?