Actions

Template

BuildingRefinerDisplayV2: Difference between revisions

From Dune Awakening DB

← Older editNewer edit →
VisualWikitext
mNo edit summary
Tag: Manual revert
mNo edit summary
Line 1: Line 1:
<div class="responsive-container">
<div class="responsive-container">
{{#vardefine:BuildingName|{{{Name|{{PAGENAME}}}}}}}
{{#get_external_data: source=externaldb
|from=data_buildings
|where=name='{{#var:BuildingName}}'
|data=id=ID,building_type=BuildingType,name=Name,description=Description,
        power_cost=PowerCost,generates_power=GeneratesPower,storage_slots=StorageSlots,
        storage_capacity=StorageCapacity,schematic_requirement=SchematicRequirement,
        journey_requirement=JourneyRequirement,health=Health,placed_with=PlacedWith,
        additional_notes=AdditionalNotes,recipe_to_build=RecipeToBuild,
        image_file=ImageFile,icon_file=IconFile,
        category_1=Category1,category_2=Category2,category_3=Category3,
        youtube_video_link=YoutubeURL
}}
<div class="responsive-col col1">
<div class="responsive-col col1">
<div class="skin-pivot">
<div class="skin-pivot">
Line 6: Line 21:
<div class="dune-card-inner">
<div class="dune-card-inner">
<div class="dune-card-label">SCHEMATIC – BUILDABLE</div>
<div class="dune-card-label">SCHEMATIC – BUILDABLE</div>
<div class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{{Name}}}</div>
<div class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{#external_value:name}}</div>
 
<div class="dune-card-image">[[File:{{#external_value:image_file}}|200px|alt={{#external_value:name}}|style:max-width:100%;max-height:150px;object-fit:contain;border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;]]</div>
{{#get_external_data: source=externaldb
<div class="dune-card-description">{{#external_value:description}}</div>
|from=data_buildings
|where=name='{{{Name}}}'
|data=name=Name,description=Description,journey_requirement=JourneyRequirement,
        image_file=ImageFile,health=Health,power_cost=EnergyConsumption,
        generates_power=GeneratesPower,storage_slots=StorageSlots,
        storage_capacity=StorageVolume,recipe_to_build=Components,
        placed_with=PlacedWith,additional_notes=AdditionalNotes,
        tier=Tier,primary_source=PrimarySource,category3=Category3
}}
 
<div class="dune-card-image">[[File:{{{ImageFile}}}|200px|alt={{{Name}}}|style:max-width:100%;max-height:150px;object-fit:contain;border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;]]</div>
<div class="dune-card-description">{{{Description}}}</div>
<div class="dune-card-locked">
<div class="dune-card-locked">
<div class="dune-card-locked-label"><span class="dune-card-locked-icon">&#128274;</span>Locked Behind</div>
<div class="dune-card-locked-label"><span class="dune-card-locked-icon">&#128274;</span>Locked Behind</div>
<div class="dune-card-locked-value">{{{JourneyRequirement}}}</div>
<div class="dune-card-locked-value">{{#external_value:journey_requirement}}</div>
</div>
</div>
<div class="dune-card-infobox">
<div class="dune-card-infobox">
<table class="infobox-dune">
<table class="infobox-dune">
<tr><th><span class="icon">&#127941;</span> Tier</th><td>{{{Tier}}}</td></tr>
<tr><th><span class="icon">&#127941;</span> Type</th><td>{{#external_value:building_type}}</td></tr>
<tr><th><span class="icon">&#9881;</span> Primary Source</th><td>{{{PrimarySource}}}</td></tr>
<tr><th><span class="icon">&#9881;</span> Primary Source</th><td>Crafting</td></tr>
<tr><th><span class="icon">&#9829;</span> Health</th><td>{{{Health}}}</td></tr>
<tr><th><span class="icon">&#9829;</span> Health</th><td>{{#external_value:health}}</td></tr>
<tr><th><span class="icon">&#9889;</span> Power Cost</th><td>{{{EnergyConsumption}}}</td></tr>
<tr><th><span class="icon">&#9889;</span> Power Cost</th><td>{{#external_value:power_cost}}</td></tr>
<tr><th><span class="icon">&#128230;</span> Inventory Slots</th><td>{{{StorageSlots}}}</td></tr>
<tr><th><span class="icon">&#128230;</span> Inventory Slots</th><td>{{#external_value:storage_slots}}</td></tr>
<tr><th><span class="icon">&#128451;</span> Volume Capacity</th><td>{{{StorageVolume}}}</td></tr>
<tr><th><span class="icon">&#128451;</span> Volume Capacity</th><td>{{#external_value:storage_capacity}}</td></tr>
<tr><th><span class="icon">&#9883;</span> Components</th><td>{{#get_external_data: source=externaldb  
<tr><th><span class="icon">&#9883;</span> Components</th><td>
{{#get_external_data: source=externaldb  
|from=data_resources  
|from=data_resources  
|where=name IN ({{{Components}}})  
|where=name IN ({{#external_value:recipe_to_build}})  
|data=name=ComponentName,icon_file=ComponentIconFile}}
|data=name=ComponentName,icon_file=ComponentIconFile}}
{{#for_external_table:|[[File:{{{ComponentIconFile}}}|20px]] [[{{{ComponentName}}}]]<br>}}
{{#for_external_table:|[[File:{{#external_value:ComponentIconFile}}|20px]] [[{{#external_value:ComponentName}}]]<br>}}
</td></tr>
</td></tr>
<tr><th><span class="icon">&#128296;</span> Placed With</th><td>{{{PlacedWith}}}</td></tr>
<tr><th><span class="icon">&#128296;</span> Placed With</th><td>{{#external_value:placed_with}}</td></tr>
</table>
</table>
</div>
</div>
Line 61: Line 65:
     {{#get_external_data: source=externaldb
     {{#get_external_data: source=externaldb
     |from=data_refining_recipes
     |from=data_refining_recipes
     |where=refiner_needed='{{{Name}}}'
     |where=refiner_needed='{{#var:BuildingName}}'
     |data=output_item=OutputItem,ingredients=Ingredients,time=Time,recipe_qty=RecipeQty
     |data=output_item=OutputItem,ingredients=Ingredients,time=Time,recipe_qty=RecipeQty
     }}
     }}
Line 71: Line 75:
     {{#for_external_table:|
     {{#for_external_table:|
     {{!}}-
     {{!}}-
     {{!}} {{#get_external_data: source=externaldb |from=data_resources |where=name='{{{OutputItem}}}' |data=icon_file=IconFile}}[[File:{{{IconFile}}}|20px]] [[{{{OutputItem}}}]] {{#if: {{{RecipeQty}}} | × {{{RecipeQty}}} | }}
     {{!}} {{#get_external_data: source=externaldb |from=data_resources |where=name='{{#external_value:OutputItem}}' |data=icon_file=IconFile}}[[File:{{#external_value:IconFile}}|20px]] [[{{#external_value:OutputItem}}]] {{#if: {{#external_value:RecipeQty}} | × {{#external_value:RecipeQty}} | }}
     {{!}} {{#get_external_data: source=externaldb |from=data_resources |where=name IN ({{{Ingredients}}}) |data=name=IngName,icon_file=IngIconFile}}
     {{!}} {{#get_external_data: source=externaldb |from=data_resources |where=name IN ({{#external_value:Ingredients}}) |data=name=IngName,icon_file=IngIconFile}}
     {{#for_external_table:|[[File:{{{IngIconFile}}}|20px]] [[{{{IngName}}}]]<br>}}
     {{#for_external_table:|[[File:{{#external_value:IngIconFile}}|20px]] [[{{#external_value:IngName}}]]<br>}}
     {{!}} {{{Time}}}
     {{!}} {{#external_value:Time}}
     }}
     }}
   </table>
   </table>
Line 88: Line 92:
       <div class="dune-card-label">Additional Information</div>
       <div class="dune-card-label">Additional Information</div>
       <div class="dune-card-title"><span class="icon">&#8801;</span> Notes</div>
       <div class="dune-card-title"><span class="icon">&#8801;</span> Notes</div>
       <div class="dune-card-description">{{{AdditionalNotes}}}</div>
       <div class="dune-card-description">{{#external_value:additional_notes}}</div>
     </div>
     </div>
   </div>
   </div>
Line 102: Line 106:
       <div class="dune-card-title"><span class="icon">&#9654;</span> {{{VideoTitle|Building Guide}}}</div>
       <div class="dune-card-title"><span class="icon">&#9654;</span> {{{VideoTitle|Building Guide}}}</div>
       <div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;">
       <div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;">
     {{#get_external_data: source=externaldb
     {{#if: {{#external_value:youtube_video_link}} |
    |from=data_buildings
     <youtube dimensions="480x360" alignment="center">{{#replace: {{#external_value:youtube_video_link}} | .*v=([a-zA-Z0-9_-]+).* | $1 }}</youtube>
    |where=name='{{{Name}}}'
    |data=youtube_url=YouTubeURL
    }}
    {{#if: {{{YouTubeURL}}} |
     <youtube dimensions="480x360" alignment="center">{{#replace: {{{YouTubeURL}}} | .*v=([a-zA-Z0-9_-]+).* | $1 }}</youtube>
     | Coming Soon }}
     | Coming Soon }}
</div>
</div>
Line 119: Line 118:
     <div class="dune-card-inner">
     <div class="dune-card-inner">
       <div class="dune-card-label">RELATED BUILDINGS</div>
       <div class="dune-card-label">RELATED BUILDINGS</div>
       <div class="dune-card-title"><span class="icon">&#x1F3D7;</span> Other {{{Category3}}}</div>
       <div class="dune-card-title"><span class="icon">&#x1F3D7;</span> Other {{#external_value:category_3}}</div>
       <div class="dune-card-description">{{{RelatedBuildingsDescription|Explore similar building types to expand your base capabilities.}}}</div>
       <div class="dune-card-description">{{{RelatedBuildingsDescription|Explore similar building types to expand your base capabilities.}}}</div>
       <div class="dune-card-infobox">
       <div class="dune-card-infobox">
         {{#get_external_data: source=externaldb
         {{#get_external_data: source=externaldb
         |from=data_buildings
         |from=data_buildings
         |where=category3='{{{Category3}}}'
         |where=category_3='{{#external_value:category_3}}'
         |data=name=RelatedName,tier=RelatedTier,description=RelatedDescription,icon_file=RelatedIconFile
         |data=name=RelatedName,building_type=RelatedType,description=RelatedDescription,icon_file=RelatedIconFile
         }}
         }}
         <table class="infobox-dune" style="width:100%">
         <table class="infobox-dune" style="width:100%">
         <tr>
         <tr>
           <th style="text-align:left;">Name</th>
           <th style="text-align:left;">Name</th>
           <th style="text-align:left;">Tier</th>
           <th style="text-align:left;">Type</th>
           <th style="text-align:left;">Description</th>
           <th style="text-align:left;">Description</th>
         </tr>
         </tr>
         {{#for_external_table:|
         {{#for_external_table:|
         {{#if: {{#ifeq: {{{RelatedName}}} | {{{Name}}} | | 1 }} |
         {{#if: {{#ifeq: {{#external_value:RelatedName}} | {{#var:BuildingName}} | | 1 }} |
         {{!}}-
         {{!}}-
         {{!}} [[File:{{{RelatedIconFile}}}|20px]] [[{{{RelatedName}}}]]
         {{!}} [[File:{{#external_value:RelatedIconFile}}|20px]] [[{{#external_value:RelatedName}}]]
         {{!}} {{{RelatedTier}}}
         {{!}} {{#external_value:RelatedType}}
         {{!}} {{{RelatedDescription}}}
         {{!}} {{#external_value:RelatedDescription}}
         |}}
         |}}
         }}
         }}

Revision as of 14:05, 25 March 2025


The query SELECT ID,BuildingType,Name,Description,PowerCost,GeneratesPower,StorageSlots,StorageCapacity,SchematicRequirement,JourneyRequirement,Health,PlacedWith,AdditionalNotes,RecipeToBuild,ImageFile,IconFile,Category1,Category2,Category3,YoutubeURL FROM `data_buildings` WHERE name='BuildingRefinerDisplayV2' is invalid (Error 1054: Unknown column 'BuildingType' in 'SELECT' Function: EDConnectorRdbms::fetch Query: SELECT ID,BuildingType,Name,Description,PowerCost,GeneratesPower,StorageSlots,StorageCapacity,SchematicRequirement,JourneyRequirement,Health,PlacedWith,AdditionalNotes,RecipeToBuild,ImageFile,IconFile,Category1,Category2,Category3,YoutubeURL FROM `data_buildings` WHERE name='BuildingRefinerDisplayV2' ).

SCHEMATIC – BUILDABLE
🛈 Error: no local variable "name" has been set.
[[File:Error: no local variable "image_file" has been set.|200px|alt=Error: no local variable "name" has been set.|style:max-width:100%;max-height:150px;object-fit:contain;border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;]]
Error: no local variable "description" has been set.
🔒Locked Behind
Error: no local variable "journey_requirement" has been set.
🏅 TypeError: no local variable "building_type" has been set.
⚙ Primary SourceCrafting
♥ HealthError: no local variable "health" has been set.
⚡ Power CostError: no local variable "power_cost" has been set.
📦 Inventory SlotsError: no local variable "storage_slots" has been set.
🗃 Volume CapacityError: no local variable "storage_capacity" has been set.
⚛ Components

The query SELECT ComponentName,ComponentIconFile FROM `data_resources` WHERE name IN (Error: no local variable "recipe_to_build" has been set.) is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Error: no local variable "recipe_to_build" has been set.<...' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT ComponentName,ComponentIconFile FROM `data_resources` WHERE name IN (Error: no local variable "recipe_to_build" has been set.) ).

🔨 Placed WithError: no local variable "placed_with" has been set.
CRAFTING
⚛ Refining Recipes
Below is a list of possible outputs, required inputs, and the time to refine. Times or power usage might vary based on external modifiers (e.g., upgrades).
The query SELECT OutputItem,Ingredients,Time,RecipeQty FROM `data_refining_recipes` WHERE refiner_needed='BuildingRefinerDisplayV2' is invalid (Error 1146: Table 'dunedbco_ddb.data_refining_recipes' doesn't exist Function: EDConnectorRdbms::fetch Query: SELECT OutputItem,Ingredients,Time,RecipeQty FROM `data_refining_recipes` WHERE refiner_needed='BuildingRefinerDisplayV2' ).
Output Ingredients Craft Time
Additional Information
≡ Notes
Error: no local variable "additional_notes" has been set.
VIDEO TUTORIALS
▶ Building Guide
   Provided ID could not be validated.
RELATED BUILDINGS
🏗 Other Error: no local variable "category_3" has been set.
Explore similar building types to expand your base capabilities.
       The query SELECT  RelatedName,RelatedType,RelatedDescription,RelatedIconFile  FROM `data_buildings`    WHERE category_3='Error: no local variable "category_3" has been set.'   is invalid (Error 1054: Unknown column 'RelatedName' in 'SELECT'

Function: EDConnectorRdbms::fetch Query: SELECT RelatedName,RelatedType,RelatedDescription,RelatedIconFile FROM `data_buildings` WHERE category_3='Error: no local variable "category_3" has been set.' ).

Name Type Description
Retrieved from "https://dunedb.com/index.php?title=Template:BuildingRefinerDisplayV2&oldid=246"