User:Matosh/sandbox3: Difference between revisions

From SuperCombo Wiki
mNo edit summary
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
==Frame table==
====Tabber test====
'''Guile'''
<tabber> General=
===Normals and Target Combos===
----
{{#cargo_query:tables=SF6_FrameData
{{#cargo_query:tables=SF6_FrameData
|fields=input,damage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|fields=input,damage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|where=chara="Guile"  and (moveType="ground_normal" or moveType="normal" or moveType="air_normal")
|where=chara="JP"  and (moveType="ground_normal" or moveType="normal" or moveType="air_normal")
|format=dynamic table
|format=dynamic table
|order by=_rowID
|order by=_rowID
|rows per page=50
|rows per page=50
}}
}}
 
|-|
===Drive and Throw===
Detailed=
----
{{#cargo_query:tables=SF6_FrameData
{{#cargo_query:tables=SF6_FrameData
|fields=name,input,damage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|fields=input,damage,IF(chip='{{{chip}}}', "", chip)=chip,driveDamage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|where=chara="Guile"  and (moveType = "drive" or moveType="throw")
|where=chara="JP"  and (moveType="ground_normal" or moveType="normal" or moveType="air_normal")
|format=dynamic table
|format=dynamic table
|order by=_rowID
|order by=_rowID
|rows per page=50
|rows per page=50
}}
}}
===Specials===
</tabber>
----
{{#cargo_query:tables=SF6_FrameData
|fields=name,input,damage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|where=chara="Guile"  and moveType = "special"
|format=dynamic table
|order by=_rowID
|rows per page=50
}}
 
 
===Supers===
----
{{#cargo_query:tables=SF6_FrameData
|fields=name, input,damage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|where=chara="Guile"  and moveType = "super"
|format=dynamic table
|order by=_rowID
|rows per page=50
}}
 
 
===Move type count. personal use===
{{#cargo_query:tables=SF6_FrameData
|fields=moveType, count(*)
|where=chara="Kimberly"
|format=dynamic table
|group by=moveType
}}
 
 
<!--
{{#cargo_query:tables=SF6_FrameData
|fields=input,damage,guard,cancel,startup,active,recovery,hitAdv,blockAdv
|where=chara="Guile"  and moveType="air_normal"
|format=dynamic table
|order by=_rowID
|rows per page=50
}}-->
{{Navbox-SF6}}

Latest revision as of 15:11, 11 June 2023

Tabber test

input damage guard cancel startup active recovery hitAdv blockAdv
input damage guard cancel startup active recovery hitAdv blockAdv
5LP 300 LH Chn Sp SA 6 3 10 +4 -2
5MP 700 LH - 12 3 21 +1 -6
5HP 800 LH Sp SA 12 2 22 +3 -3
5LK 300 LH Sp SA 5 3 11 +3 -2
5MK 600 LH Sp SA 8 3 19 +3 -3
5HK 800 LH TC 12 4 17 +7 +2
2LP 300 LH Chn Sp SA 4 2 11 +4 -1
2MP 600 LH Sp SA 7 4 14 +6 -2
2HP 800 LH Sp SA 9 6 20 +1 -6
2LK 200 L Chn 6 2 10 +2 -2
2MK 700 L - 9 3 17 +3 -3
2HK 900 L - 10 3 21 HKD +27 -6
j.LP 300 H - 5 10 3 land +8(+9) +4(+5)
j.MP 700 H - 12 3 3 land +12(+13) +8(+9)
j.HP 800 H - 9 5 3 land +9(+15) +5(+11)
j.LK 300 H - 6 8 3 land +4(+10) +1(+7)
j.MK 600 H - 7 6 3 land +9(+13) +5(+9)
j.HK 800 H - 11 6 3 land +9(+15) +5(+11)
4MP 500 LH Sp SA TC 8 3 16 +5 -1
6MK 700 H - 22 2 19 +3 -3
3HP 900 L - 16 3 31 HKD +17 -14
6HK 300,600 LH Sp SA (2nd) 11 2,4 24 KD +38 -5(-8)
4MP~MP 500 LH Sp SA 10 3 20 +3 -6
5HK~HP 500 LH Sp SA TC 20 3 20 +3 -3
5HK~HP~HP 1000 H - 21 3 22 +3 -4
5HK~HP~HK 1000 L - 21 3 22 +3 -4

Error: No field named "driveDamage" found for any of the specified database tables.
Retrieved from "https://wiki.supercombo.gg/index.php?title=User:Matosh/sandbox3&oldid=262249"