Template:Weapon/Article: Difference between revisions

From Phantasy Star Universe Clementine
(update cargo structure)
Line 434: Line 434:
{{#cargo_query:tables=Boards, Shops
{{#cargo_query:tables=Boards, Shops
|fields=Boards.name, Shops.id
|fields=Boards.name, Shops.id
|where=make_id = "{{{id}}}"
|where=Boards.id = "{{{id}}}"
|join on=Boards.make_id = Shops.id
|join on=Boards.id = Shops.id
|named args=yes
|named args=yes
|format=template
|format=template
Line 450: Line 450:
  -->{{#cargo_query:tables=Boards, Shops
  -->{{#cargo_query:tables=Boards, Shops
|fields=Boards.name, Shops.id
|fields=Boards.name, Shops.id
|where=make_id = "{{{id}}}"
|where=Boards.id = "{{{id}}}"
|join on=Boards.make_id = Shops.id
|join on=Boards.id = Shops.id
|named args=yes
|named args=yes
|format=template
|format=template
Line 462: Line 462:
}}<!--  
}}<!--  
Board query  
Board query  
-->{{#cargo_query:tables=Boards, Board_Materials
-->{{#cargo_query:tables=Boards, Synthesis
|fields=Boards.name
|fields=Boards.name
|join on= Boards.id = Board_Materials.id
|join on= Boards.id = Synthesis.board_id
|where=make_id = "{{{id}}}"
|where=Boards.id = "{{{id}}}"
|named args=yes
|named args=yes
|format=template
|format=template

Revision as of 09:49, 10 January 2025

Automatically generates a weapon page.