User:Matosh/sandbox/version: Difference between revisions

From SuperCombo Wiki
Line 104: Line 104:
|format=table
|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}}





Revision as of 13:28, 26 October 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.

5LP test border

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



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


Expression error: Unrecognized punctuation character "".


--invoke--

AttackDataCargo-SF6

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

</includeonly>

notes

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