Toggle menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Template:SSBU Move Card: Difference between revisions

Template page
Content added Content deleted
(Created page with "<includeonly><!--------------------------- defaults the character to the subpagename --------------------------- -->{{#vardefine:MoveCardTargetChara|{{{chara|{{PAGENAME}}}}}}}<!----------- <!----------- determines up to 4 inputs from a comma seperated list of inputs in the |input argument ----------- -->{{#vardefine:input1|{{#explode:{{{input}}}|,|0}}}}<!-- -->{{#vardefine:input2|{{#explode:{{{input}}}|,|1}}}}<!-- -->{{#vardefine:input3|{{#explode:{{{input}}}|,|2}}}}<!--...")
 
No edit summary
Line 18: Line 18:
|join on= SSBU_MoveData__images._rowID=SSBU_MoveData._ID, SSBU_MoveData__images._rowID=SSBU_MoveData__caption._rowID, SSBU_MoveData__images._position=SSBU_MoveData__caption._position
|join on= SSBU_MoveData__images._rowID=SSBU_MoveData._ID, SSBU_MoveData__images._rowID=SSBU_MoveData__caption._rowID, SSBU_MoveData__images._position=SSBU_MoveData__caption._position
|fields= SSBU_MoveData__images._value=image, SSBU_MoveData__caption._value=caption
|fields= SSBU_MoveData__images._value=image, SSBU_MoveData__caption._value=caption
|where=SSBU_MoveData.chara="{{#var:MoveCardTargetChara}}" and SSBU_MoveData.input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}', '{{#var:input8}}', '{{#var:input9}}', '{{#var:input10}}', '{{#var:input11}}', '{{#var:input12}}') {{#if: {{{type|}}}| and SSBU_MoveData.type="{{{type|}}}" |}}
|where=SSBU_MoveData.character="{{#var:MoveCardTargetChara}}" and SSBU_MoveData.input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}', '{{#var:input8}}', '{{#var:input9}}', '{{#var:input10}}', '{{#var:input11}}', '{{#var:input12}}') {{#if: {{{type|}}}| and SSBU_MoveData.type="{{{type|}}}" |}}
|group by= SSBU_MoveData__images._value
|group by= SSBU_MoveData__images._value
|order by=_ID,SSBU_MoveData__images._position
|order by=_ID,SSBU_MoveData__images._position
Line 28: Line 28:
|join on= SSBU_MoveData__hitboxes._rowID=SSBU_MoveData._ID, SSBU_MoveData__hitboxes._rowID=SSBU_MoveData__hitboxCaption._rowID, SSBU_MoveData__hitboxes._position=SSBU_MoveData__hitboxCaption._position
|join on= SSBU_MoveData__hitboxes._rowID=SSBU_MoveData._ID, SSBU_MoveData__hitboxes._rowID=SSBU_MoveData__hitboxCaption._rowID, SSBU_MoveData__hitboxes._position=SSBU_MoveData__hitboxCaption._position
|fields= SSBU_MoveData__hitboxes._value=image, SSBU_MoveData__hitboxCaption._value=hitboxCaption
|fields= SSBU_MoveData__hitboxes._value=image, SSBU_MoveData__hitboxCaption._value=hitboxCaption
|where=SSBU_MoveData.chara="{{#var:MoveCardTargetChara}}" and SSBU_MoveData.input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}', '{{#var:input8}}', '{{#var:input9}}', '{{#var:input10}}', '{{#var:input11}}', '{{#var:input12}}') {{#if: {{{type|}}}| and SSBU_MoveData.type="{{{type|}}}" |}}
|where=SSBU_MoveData.character="{{#var:MoveCardTargetChara}}" and SSBU_MoveData.input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}', '{{#var:input8}}', '{{#var:input9}}', '{{#var:input10}}', '{{#var:input11}}', '{{#var:input12}}') {{#if: {{{type|}}}| and SSBU_MoveData.type="{{{type|}}}" |}}
|group by= SSBU_MoveData__hitboxes._value
|group by= SSBU_MoveData__hitboxes._value
|order by=_ID,SSBU_MoveData__hitboxes._position
|order by=_ID,SSBU_MoveData__hitboxes._position
Line 50: Line 50:
{{#cargo_query:tables=SSBU_MoveData
{{#cargo_query:tables=SSBU_MoveData
|fields={{#if:{{#var:input2}} {{{versioned|}}} |input=inputInfo,|}}damage,active,faf,angle,safety,invuln
|fields={{#if:{{#var:input2}} {{{versioned|}}} |input=inputInfo,|}}damage,active,faf,angle,safety,invuln
|where=chara="{{#var:MoveCardTargetChara}}" and input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}', '{{#var:input8}}', '{{#var:input9}}', '{{#var:input10}}', '{{#var:input11}}', '{{#var:input12}}') {{#if: {{{type|}}}| and SSBU_MoveData.type="{{{type|}}}" |}}
|where=character="{{#var:MoveCardTargetChara}}" and input in ('{{#var:input1}}', '{{#var:input2}}', '{{#var:input3}}', '{{#var:input4}}', '{{#var:input5}}', '{{#var:input6}}', '{{#var:input7}}', '{{#var:input8}}', '{{#var:input9}}', '{{#var:input10}}', '{{#var:input11}}', '{{#var:input12}}') {{#if: {{{type|}}}| and SSBU_MoveData.type="{{{type|}}}" |}}
|format=template|template=AttackData-SSBU|named args=yes|order by=_ID
|format=template|template=AttackData-SSBU|named args=yes|order by=_ID
|delimiter=\n{{!}}-\n
|delimiter=\n{{!}}-\n

Revision as of 18:50, 5 October 2022

Cookies help us deliver our services. By using our services, you agree to our use of cookies.