ResourceCraftedFrom: Difference between revisions
From Dune Awakening DB
Created page with "<includeonly><!-- Template:ResourceCraftedFrom (comma-escaped) --> {{#get_external_data: source = externaldb |from = data_recipe_ingredients JOIN data_recipes ON data_recipe_ingredients.recipe_id = data_recipes.id JOIN data_recipe_stations ON data_recipes.id = data_recipe_stations.recipe_id LEFT JOIN data_recipe_outcomes ON data_recipes.id = data_recipe_outcomes.recipe_id |data = Output..." |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly | <includeonly> | ||
{{#get_external_data: | {{#get_external_data: | ||
source = externaldb | source = externaldb | ||
|from = | |from = vw_recipe_by_ingredient | ||
|data = OutputItem = output_item, | |||
Resources = resources, | |||
Station = stations, | |||
|data = OutputItem = | WaterML = water_ml, | ||
Resources = | CraftTime = craft_time, | ||
Schematic = schematic | |||
WaterML = | |where = ingredient = '{{{resource|Copper Ingot}}}' <!-- note the quotes --> | ||
CraftTime = | |order by = Station | ||
Schematic = | |||
|where = | |||
|order by = | |||
|cache = yes | |cache = yes | ||
}} | }} | ||
| Line 23: | Line 19: | ||
<th>Item Created</th> | <th>Item Created</th> | ||
<th>Resources Needed</th> | <th>Resources Needed</th> | ||
<th> | <th>Station</th> | ||
<th>Water (mL)</th> | <th>Water (mL)</th> | ||
<th> | <th>Time</th> | ||
<th>Schematic</th> | <th>Schematic</th> | ||
</tr> | </tr> | ||
</thead> | </thead> | ||
<tbody> | <tbody> | ||
{{#for_external_table:| | |||
<tr> | |||
<td>{{#invoke:DataTableParserV2|iconize|{{{OutputItem}}}}}</td> | |||
<td>{{#invoke:DataTableParserV2|formatRecipeList|{{{Resources}}}}}</td> | |||
<td>{{{Station}}}</td> | |||
<td>{{{WaterML|0}}}</td> | |||
<td>{{{CraftTime|0}}} s</td> | |||
<td>{{#if:{{{Schematic|}}}|[[{{{Schematic}}}]]|None}}</td> | |||
</tr> | |||
}} | |||
</tbody> | </tbody> | ||
</table> | </table> | ||
</includeonly> | </includeonly> | ||