User:Moxian/Sandbox: Difference between revisions

Revision as of 19:34, 1 September 2022

Images = Hitboxes =

input	_ID	_rowID	image	caption
623S DI	1,099	1,099	GGXXACPR_Sol_DI-623S-1-Hitbox.png	All: 1st hit (Frames 7-9)
623S DI	1,099	1,099	GGXXACPR_Sol_DI-623S-2-Hitbox.png	All: 1st hit (Frames 7-9)
623H DI	1,100	1,100	GGXXACPR_Sol_DI-j623S-2-Hitbox.png	Ground H: Hits 2-9 (Frames 10-63)

@@ Line 1: / Line 1: @@
+<!--------------------------- defaults the character to the subpagename ---------------------------
-{{GGST_Move_Card|chara=Zato-1|input=]H[,236H|versioned=yes}}
+-->{{#vardefine:targetChara|Sol Badguy}}<!-----------
+<!----------- determines up to 4 inputs from a comma seperated list of inputs in the |input argument -----------
-{{GGST_Move_Card|chara=Ky Kiske|input=623S,623H,DI 623S, DI 623H|versioned=yes}}
+-->{{#vardefine:input1|623H DI}}<!--
+-->{{#vardefine:input2|623S DI}}<!--
-{{GGST_Move_Card|chara=Ky Kiske|input=6P}}
+-->{{#vardefine:input3|{{#explode:{{{input}}}|,|2}}}}<!--
+-->{{#vardefine:input4|{{#explode:{{{input}}}|,|3}}}}<!--
+-->{{#vardefine:input5|{{#explode:{{{input}}}|,|4}}}}<!--
+-->{{#vardefine:input6|{{#explode:{{{input}}}|,|5}}}}<!--
+-->{{#vardefine:input7|{{#explode:{{{input}}}|,|6}}}}<!--
+---><div class="attack-container"><div class="attack-gallery">
+Images = <!------------------- Pulls the images and captions from the game's moveData table ------------------->
+Hitboxes = <!-------------- Pulls the hitboxes and hitboxCaptions from the game's moveData table -------------->
+{{#cargo_query:tables=MoveData_GGACR, MoveData_GGACR__hitboxes, MoveData_GGACR__hitboxCaption
+|join on= MoveData_GGACR._ID=MoveData_GGACR__hitboxes._rowID , MoveData_GGACR._ID=MoveData_GGACR__hitboxCaption._rowID <!--MoveData_GGACR__hitboxes._position=MoveData_GGACR__hitboxCaption._position-->
+|fields= MoveData_GGACR.input,
+MoveData_GGACR._ID, MoveData_GGACR__hitboxes._rowID ,
+ MoveData_GGACR__hitboxes._value=image,
+MoveData_GGACR__hitboxCaption._value=caption
+|where=MoveData_GGACR.chara="{{#var:targetChara}}" and MoveData_GGACR.input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}') {{#if: {{{type|}}}| and MoveData_GGACR.type="{{{type|}}}" |}}
+|group by= MoveData_GGACR__hitboxes._value
+|order by=_ID,MoveData_GGACR__hitboxes._position
+|format=table|mode=nolines|show filename=0|show bytes=0|show dimensions=0
+|image height=210|image width=210
+|caption field=hitboxCaption|default=
+}}
+</div></div></div>