Actions

Template

BuildingRefinerDisplayV2: Difference between revisions

From Dune Awakening DB

← Older editNewer edit →
VisualWikitext
mNo edit summary
Tags: Manual revert Reverted
mNo edit summary
Tag: Manual revert
Line 1: Line 1:
<div class="responsive-container">
<div class="responsive-container">
{{#vardefine:BuildingName|{{{Name|{{PAGENAME}}}}}}}
<div class="responsive-col col1">
<div class="skin-pivot">
<div class="dune-card">
<div class="dune-card-decoration"></div>
<div class="dune-card-inner">
<div class="dune-card-label">SCHEMATIC – BUILDABLE</div>
<div class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{{Name}}}</div>


{{#get_external_data: source=externaldb
{{#get_external_data: source=externaldb
  |from=data_buildings
  |from=data_buildings
  |where=name='{{#var:BuildingName}}'
  |where=name='{{{Name}}}'
  |data=id=ID,building_type=BuildingType,name=Name,energy_consumption=EnergyConsumption,
  |data=name=Name,description=Description,journey_requirement=JourneyRequirement,
        image_file=ImageFile,health=Health,power_cost=EnergyConsumption,
         generates_power=GeneratesPower,storage_slots=StorageSlots,
         generates_power=GeneratesPower,storage_slots=StorageSlots,
         storage_volume=StorageVolume,schematic_requirement=SchematicRequirement,
         storage_capacity=StorageVolume,recipe_to_build=Components,
         journey_requirement=JourneyRequirement,placed_with=PlacedWith,
         placed_with=PlacedWith,additional_notes=AdditionalNotes,
        recipe_to_build=Components,image_file=ImageFile,icon_file=IconFile,
         tier=Tier,primary_source=PrimarySource,category3=Category3
         category_1=Category1,category_2=Category2,category_3=Category3,
        gallery_1=Gallery1,gallery_2=Gallery2,gallery_3=Gallery3,gallery_4=Gallery4
}}
}}


<div class="responsive-col col1">
<div class="skin-pivot">
<div class="dune-card">
<div class="dune-card-decoration"></div>
<div class="dune-card-inner">
<div class="dune-card-label">SCHEMATIC – BUILDABLE</div>
<div class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{#var:BuildingName}}</div>
<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-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">{{#get_external_data: source=externaldb
<div class="dune-card-description">{{{Description}}}</div>
|from=data_building_descriptions
|where=building_name='{{#var:BuildingName}}'
|data=description=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>
Line 34: Line 27:
<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> Type</th><td>{{{BuildingType}}}</td></tr>
<tr><th><span class="icon">&#127941;</span> Tier</th><td>{{{Tier}}}</td></tr>
<tr><th><span class="icon">&#9881;</span> Primary Source</th><td>Crafting</td></tr>
<tr><th><span class="icon">&#9881;</span> Primary Source</th><td>{{{PrimarySource}}}</td></tr>
<tr><th><span class="icon">&#9829;</span> Health</th><td>{{{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>{{{EnergyConsumption}}}</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>{{{StorageSlots}}}</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>{{{StorageVolume}}}</td></tr>
<tr><th><span class="icon">&#9883;</span> Components</th><td>
<tr><th><span class="icon">&#9883;</span> Components</th><td>{{#get_external_data: source=externaldb  
{{#get_external_data: source=externaldb  
|from=data_resources  
|from=data_resources  
|where=name IN ({{{Components}}})  
|where=name IN ({{{Components}}})  
Line 68: Line 61:
     {{#get_external_data: source=externaldb
     {{#get_external_data: source=externaldb
     |from=data_refining_recipes
     |from=data_refining_recipes
     |where=refiner_needed='{{#var:BuildingName}}'
     |where=refiner_needed='{{{Name}}}'
     |data=output_item=OutputItem,ingredients=Ingredients,time=Time,recipe_qty=RecipeQty
     |data=output_item=OutputItem,ingredients=Ingredients,time=Time,recipe_qty=RecipeQty
     }}
     }}
Line 95: Line 88:
       <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">{{#get_external_data: source=externaldb
       <div class="dune-card-description">{{{AdditionalNotes}}}</div>
|from=data_building_notes
|where=building_name='{{#var:BuildingName}}'
|data=notes=AdditionalNotes
}}{{{AdditionalNotes|}}}</div>
     </div>
     </div>
   </div>
   </div>
Line 114: Line 103:
       <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
     {{#get_external_data: source=externaldb
     |from=data_building_videos
     |from=data_buildings
     |where=building_name='{{#var:BuildingName}}'
     |where=name='{{{Name}}}'
     |data=youtube_url=YoutubeURL
     |data=youtube_url=YouTubeURL
     }}
     }}
     {{#if: {{{YoutubeURL}}} |
     {{#if: {{{YouTubeURL}}} |
     <youtube dimensions="480x360" alignment="center">{{#replace: {{{YoutubeURL}}} | .*v=([a-zA-Z0-9_-]+).* | $1 }}</youtube>
     <youtube dimensions="480x360" alignment="center">{{#replace: {{{YouTubeURL}}} | .*v=([a-zA-Z0-9_-]+).* | $1 }}</youtube>
     | Coming Soon }}
     | Coming Soon }}
</div>
</div>
Line 135: Line 124:
         {{#get_external_data: source=externaldb
         {{#get_external_data: source=externaldb
         |from=data_buildings
         |from=data_buildings
         |where=category_3='{{{Category3}}}'
         |where=category3='{{{Category3}}}'
         |data=name=RelatedName,building_type=RelatedType,icon_file=RelatedIconFile
         |data=name=RelatedName,tier=RelatedTier,description=RelatedDescription,icon_file=RelatedIconFile
        }}
        {{#get_external_data: source=externaldb
        |from=data_building_descriptions
        |where=building_name IN ({{{RelatedName}}})
        |data=building_name=DescName,description=RelatedDescription
         }}
         }}
         <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;">Type</th>
           <th style="text-align:left;">Tier</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}}} | {{#var:BuildingName}} | | 1 }} |
         {{#if: {{#ifeq: {{{RelatedName}}} | {{{Name}}} | | 1 }} |
         {{!}}-
         {{!}}-
         {{!}} [[File:{{{RelatedIconFile}}}|20px]] [[{{{RelatedName}}}]]
         {{!}} [[File:{{{RelatedIconFile}}}|20px]] [[{{{RelatedName}}}]]
         {{!}} {{{RelatedType}}}
         {{!}} {{{RelatedTier}}}
         {{!}} {{{RelatedDescription}}}
         {{!}} {{{RelatedDescription}}}
         |}}
         |}}

Revision as of 13:45, 25 March 2025

SCHEMATIC – BUILDABLE
🛈 {{{Name}}}

The query SELECT Name,Description,JourneyRequirement,ImageFile,Health,EnergyConsumption,GeneratesPower,StorageSlots,StorageVolume,Components,PlacedWith,AdditionalNotes,Tier,PrimarySource,Category3 FROM `data_buildings` WHERE name='{{{Name}}}' is invalid (Error 1054: Unknown column 'JourneyRequirement' in 'SELECT' Function: EDConnectorRdbms::fetch Query: SELECT Name,Description,JourneyRequirement,ImageFile,Health,EnergyConsumption,GeneratesPower,StorageSlots,StorageVolume,Components,PlacedWith,AdditionalNotes,Tier,PrimarySource,Category3 FROM `data_buildings` WHERE name='{{{Name}}}' ).

[[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;]]
{{{Description}}}
🔒Locked Behind
{{{JourneyRequirement}}}
🏅 Tier{{{Tier}}}
⚙ Primary Source{{{PrimarySource}}}
♥ Health{{{Health}}}
⚡ Power Cost{{{EnergyConsumption}}}
📦 Inventory Slots{{{StorageSlots}}}
🗃 Volume Capacity{{{StorageVolume}}}
⚛ ComponentsThe query SELECT ComponentName,ComponentIconFile FROM `data_resources` WHERE name IN ({{{Components}}}) 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 'Template:Components})' at line 1

Function: EDConnectorRdbms::fetch Query: SELECT ComponentName,ComponentIconFile FROM `data_resources` WHERE name IN ({{{Components}}}) ).

🔨 Placed With{{{PlacedWith}}}
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='{{{Name}}}' 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='{{{Name}}}' ).
Output Ingredients Craft Time
Additional Information
≡ Notes
{{{AdditionalNotes}}}
VIDEO TUTORIALS
▶ Building Guide
   The query SELECT  YouTubeURL  FROM `data_buildings`    WHERE name='{{{Name}}}'   is invalid (Error 1054: Unknown column 'YouTubeURL' in 'SELECT'

Function: EDConnectorRdbms::fetch Query: SELECT YouTubeURL FROM `data_buildings` WHERE name='{{{Name}}}' ). 

   Provided ID could not be validated.
RELATED BUILDINGS
🏗 Other {{{Category3}}}
Explore similar building types to expand your base capabilities.
       The query SELECT  RelatedName,RelatedTier,RelatedDescription,RelatedIconFile  FROM `data_buildings`    WHERE category3='{{{Category3}}}'   is invalid (Error 1054: Unknown column 'RelatedName' in 'SELECT'

Function: EDConnectorRdbms::fetch Query: SELECT RelatedName,RelatedTier,RelatedDescription,RelatedIconFile FROM `data_buildings` WHERE category3='{{{Category3}}}' ).

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