Operator: Created page with "
{{#get_external_data: source=externaldb |from=data_items |data=ItemID=item_id,InternalName=internal_name,ResourceClass=resource_class, ResourceSubclass=resource_subclass,Tier=tier,Rarity=rarity,Faction=faction, Name=name,Description=description,HowToObtain=how_to_obtain,Notes=notes,..."

2025-05-26T19:18:01Z

Created page with "<includeonly> <div class="dune-breadcrumb-nav"> <templatestyles src="Template:ResourcePage/styles.css" />  {{#get_external_data: source=externaldb |from=data_items |data=ItemID=item_id,InternalName=internal_name,ResourceClass=resource_class, ResourceSubclass=resource_subclass,Tier=tier,Rarity=rarity,Faction=faction, Name=name,Description=description,HowToObtain=how_to_obtain,Notes=notes,..."

New page

<includeonly>
<div class="dune-breadcrumb-nav">
<templatestyles src="Template:ResourcePage/styles.css" />


{{#get_external_data:
source=externaldb
|from=data_items
|data=ItemID=item_id,InternalName=internal_name,ResourceClass=resource_class,
ResourceSubclass=resource_subclass,Tier=tier,Rarity=rarity,Faction=faction,
Name=name,Description=description,HowToObtain=how_to_obtain,Notes=notes,
AdditionalNotes=additional_notes,Weight=weight,MaxStacks=max_stacks,
XPPerHarvest=xp_per_harvest,BaseVendorPrice=base_vendor_price,
LocationsToHarvest=locations_to_harvest,GuideLink=guide_link,
IconLink=icon_link,ImageLink=image_link,Category1=category_1,
Category2=category_2,Category3=category_3
|where=name={{PAGENAME}}
|limit=1
|cache=yes
}}
{{#for_external_table:|
{{#vardefine:ItemID|{{{ItemID}}}}}{{#vardefine:InternalName|{{{InternalName}}}}}
{{#vardefine:ResourceClass|{{{ResourceClass}}}}}{{#vardefine:ResourceSubclass|{{{ResourceSubclass}}}}}
{{#vardefine:Tier|{{{Tier}}}}}{{#vardefine:Rarity|{{{Rarity}}}}}{{#vardefine:Faction|{{{Faction}}}}}
{{#vardefine:Name|{{{Name}}}}}{{#vardefine:Description|{{{Description}}}}}
{{#vardefine:HowToObtain|{{{HowToObtain}}}}}{{#vardefine:Notes|{{{Notes}}}}}
{{#vardefine:AdditionalNotes|{{{AdditionalNotes}}}}}{{#vardefine:Weight|{{{Weight}}}}}
{{#vardefine:MaxStacks|{{{MaxStacks}}}}}{{#vardefine:XPPerHarvest|{{{XPPerHarvest}}}}}
{{#vardefine:BaseVendorPrice|{{{BaseVendorPrice}}}}}{{#vardefine:LocationsToHarvest|{{{LocationsToHarvest}}}}}
{{#vardefine:GuideLink|{{{GuideLink}}}}}{{#vardefine:IconLink|{{{IconLink}}}}}
{{#vardefine:ImageLink|{{{ImageLink}}}}}{{#vardefine:Category1|{{{Category1}}}}}
{{#vardefine:Category2|{{{Category2}}}}}{{#vardefine:Category3|{{{Category3}}}}}
}}


<span id="menuRadialTrigger" class="menu-button-wrapper" style="cursor:pointer;">
[[File:MenuButton.png|100px|link=|alt=Menu]]
</span>
<span class="dune-breadcrumb-separator">/</span>[[{{#var:Category1}}|{{#var:Category1}}]]
<span class="dune-breadcrumb-separator">/</span>[[{{#var:Category2}}|{{#var:Category2}}]]
<span class="dune-breadcrumb-separator">/</span>[[{{#var:Category3}}|{{#var:Category3}}]]
<span class="dune-breadcrumb-separator">/</span><span>{{PAGENAME}}</span></div>

<div class="responsive-container">


… 


{{#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
|data=OutputItem = primary_output_label,
Resources = GROUP_CONCAT(
DISTINCT CONCAT(
ingredient_label,CHAR(32),CHAR(120),amount
) SEPARATOR CHAR(59)
),
Stations = GROUP_CONCAT(
DISTINCT production_type
SEPARATOR CHAR(59)
)
|where=ingredient_label={{PAGENAME}}
|group by=primary_output_label
|order by=primary_output_label
|limit=5
|cache=yes
}}

<div class="dune-table-wrapper">
<table class="infobox-dune-standard-table recipe-table" id="craftedWithTable">
<thead><tr class="tr-dark">
<th style="width:35%;">Item Created</th>
<th style="width:40%;">Resources Needed</th>
<th style="width:25%;">Stations</th>
</tr></thead>
<tbody>
{{#for_external_table:|
<tr class="recipe-row">
<td>{{#invoke:DataTableParserV2|iconize|{{{OutputItem}}}}}</td>
<td>{{#invoke:DataTableParserV2|formatRecipeList|{{{Resources}}}}}</td>
<td>{{{Stations}}}</td>
</tr>
}}
</tbody>
</table>
</div>


{{#get_external_data:
source=externaldb
|from=data_recipe_outcomes
JOIN data_recipes ON data_recipe_outcomes.recipe_id = data_recipes.id
JOIN data_recipe_ingredients ON data_recipes.id = data_recipe_ingredients.recipe_id
JOIN data_recipe_stations ON data_recipes.id = data_recipe_stations.recipe_id
|data=OutputItem = output_label,
Resources = GROUP_CONCAT(
DISTINCT CONCAT(
ingredient_label,CHAR(32),CHAR(120),amount
) SEPARATOR CHAR(59)
),
Stations = GROUP_CONCAT(
DISTINCT production_type
SEPARATOR CHAR(59)
)
|where=output_label={{PAGENAME}}
|group by=output_label
|order by=output_label
|limit=5
|cache=yes
}}

<div class="dune-table-wrapper">
<table class="infobox-dune-standard-table recipe-table" id="craftedFromTable">
<thead><tr class="tr-dark">
<th style="width:35%;">Item Created</th>
<th style="width:40%;">Resources Needed</th>
<th style="width:25%;">Stations</th>
</tr></thead>
<tbody>
{{#for_external_table:|
<tr class="recipe-row">
<td>{{#invoke:DataTableParserV2|iconize|{{{OutputItem}}}}}</td>
<td>{{#invoke:DataTableParserV2|formatRecipeList|{{{Resources}}}}}</td>
<td>{{{Stations}}}</td>
</tr>
}}
</tbody>
</table>
</div>


… 

</div> 
</includeonly>


<div class="responsive-col col3">
<div class="skin-pivot">
<div class="dune-card">
<div class="dune-card-decoration"></div>
<div class="dune-card-inner">
<div class="dune-card-label">VIDEO TUTORIALS</div>
<div class="dune-card-title"><span class="icon">▶</span> Resource Guide</div>
<div style="padding:3px;"></div>
<div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;">
{{#if:{{#var:GuideLink}}
| <youtube>{{#var:GuideLink}}</youtube>
| <youtube>r8lxVDqoHLQ</youtube>}}
</div>

<div style="clear:both; padding:10px;"></div>


<div class="dune-card-title"><span class="icon">≡</span> Notes</div>
<div style="padding:3px;"></div>
<div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{#var:AdditionalNotes}}}}</div>

{{#if:{{#var:LocationsToHarvest}}|
<div style="clear:both; padding:10px;"></div>

<div class="dune-card-title"><span class="icon">🗺</span> Harvest Locations</div>
<div style="padding:3px;"></div>
<div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{#var:LocationsToHarvest}}}}</div>
|}}
</div>
</div>
</div>
</div>
</div>


<script id="recipePopupTemplate" type="text/template">
<div class="recipe-popup-overlay">
<div class="recipe-popup">
<div class="popup-header">
<h3 class="popup-title">{{title}}</h3>
<button class="popup-close">×</button>
</div>
<div class="popup-content">
<div class="popup-search-container">
<input type="text" class="popup-search-input" placeholder="Search recipes...">
</div>
<div class="popup-table-wrapper">
<table class="infobox-dune-standard-table recipe-popup-table">
<thead>
<tr class="tr-dark">
<th>Item Created</th>
<th>Resources Needed</th>
<th>Stations</th>
<th>Water (mL)</th>
<th>Craft Time</th>
<th>Schematic</th>
</tr>
</thead>
<tbody>
{{tableRows}}
</tbody>
</table>
</div>
</div>
</div>
</div>
</script>

Template:ResourcePage&action=edit - Revision history