User:Matosh/sandbox/version: Difference between revisions

Revision as of 13:28, 26 October 2022

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

inputValue

NameValue2

testing

NoteValue2

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

Stand LP

5LP

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

                  Template:AttackDataCargo-SF6-test

Stand LP

5LP

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

                  Template:AttackDataCargo-SF6-test1

--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

|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

Expression error: Unrecognized punctuation character "".

--invoke--

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

</includeonly>

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

@@ Line 104: / 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
+}}
+}}
+{{#ifexpr:{{#var:moveCount}}>1| greater than 1 | 1 result only}}