Actions

Template

BuildingRefinerDisplayV2: Difference between revisions

From Dune Awakening DB

mNo edit summary
mNo edit summary
Line 1: Line 1:
<!-- Template:BuildingRefinerDisplayV2 -->
<!-- Template:BuildingRefinerDisplayV2 -->
{{#get_external_data: source=externaldb
 
        |from=data_buildings
<!-- Retrieve main building data -->
        |data=ID=id,
{{#get_external_data:
              BuildingType=building_type,
  source=externaldb
              Name=name,
  |from=data_buildings
              Description=description,
  |data=ID=id,
              PowerCost=power_cost,
        BuildingType=building_type,
              GeneratesPower=generates_power,
        Name=name,
              StorageSlots=storage_slots,
        Description=description,
              StorageCapacity=storage_capacity,
        PowerCost=power_cost,
              SchematicRequirement=schematic_requirement,
        GeneratesPower=generates_power,
              JourneyRequirement=journey_requirement,
        StorageSlots=storage_slots,
              Health=health,
        StorageCapacity=storage_capacity,
              PlacedWith=placed_with,
        SchematicRequirement=schematic_requirement,
              AdditionalNotes=additional_notes,
        JourneyRequirement=journey_requirement,
              RecipeToBuild=recipe_to_build,
        Health=health,
              ImageFile=image_file,
        PlacedWith=placed_with,
              IconFile=icon_file,
        AdditionalNotes=additional_notes,
              Category1=category_1,
        RecipeToBuild=recipe_to_build,
              Category2=category_2,
        ImageFile=image_file,
              Category3=category_3,
        IconFile=icon_file,
              Gallery1=gallery_1,
        Category1=category_1,
              Gallery2=gallery_2,
        Category2=category_2,
              Gallery3=gallery_3,
        Category3=category_3,
              Gallery4=gallery_4,
        Gallery1=gallery_1,
              YoutubeVideoLink=youtube_video_link
        Gallery2=gallery_2,
        |cache=yes
        Gallery3=gallery_3,
        |where=name='Small Ore Refinery'
        Gallery4=gallery_4,
        |limit=1
        YoutubeVideoLink=youtube_video_link
  |cache=yes
  |where=name='Small Ore Refinery'
  |limit=1
}}
}}


{{#for_external_table:|
<!-- Main container -->
  <div class="responsive-container">
<div class="responsive-container">
    <!-- Left Column: Main Building Card -->
 
  <!-- Left Column: Main Building Card -->
  {{#for_external_table:|
   
     <div class="responsive-col col1">
     <div class="responsive-col col1">
       <div class="skin-pivot">
       <div class="skin-pivot">
Line 40: Line 49:
           <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 class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{{Name}}}</div>
            </div>
             <div class="dune-card-image">
             <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;]]
              {{#if:{{{ImageFile|}}}
            </div>
                | [[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 class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{{Description}}}}}
              }}
             </div>
             </div>
            <div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{{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 class="dune-card-locked-label"><span class="dune-card-locked-icon">&#128274;</span>Locked Behind</div>
              </div>
               <div class="dune-card-locked-value">{{{JourneyRequirement}}}</div>
               <div class="dune-card-locked-value">{{{JourneyRequirement}}}</div>
             </div>
             </div>
             <div class="dune-card-infobox">
             <div class="dune-card-infobox">
               <table class="infobox-dune">
               <table class="infobox-dune">
                 <tr>
                 <tr><th><span class="icon">&#127941;</span> Building Type</th><td>{{{BuildingType}}}</td></tr>
                  <th><span class="icon">&#127941;</span> Building Type</th>
                 <tr><th><span class="icon">&#9829;</span> Health</th><td>{{{Health}}}</td></tr>
                  <td>{{{BuildingType}}}</td>
                 <tr><th><span class="icon">&#9889;</span> Power Cost</th><td>{{{PowerCost}}}</td></tr>
                </tr>
                 <tr><th><span class="icon">&#128230;</span> Inventory Slots</th><td>{{{StorageSlots}}}</td></tr>
                 <tr>
                 <tr><th><span class="icon">&#128451;</span> Capacity</th><td>{{{StorageCapacity}}}</td></tr>
                  <th><span class="icon">&#9829;</span> Health</th>
                 <tr><th><span class="icon">&#9883;</span> Recipe</th><td>{{#invoke:DataTableParserV2|iconize|{{{RecipeToBuild}}}}}</td></tr>
                  <td>{{{Health}}}</td>
                 <tr><th><span class="icon">&#128296;</span> Placed With</th><td>{{#invoke:DataTableParserV2|iconize|{{{PlacedWith}}}}}</td></tr>
                </tr>
                 <tr>
                  <th><span class="icon">&#9889;</span> Power Cost</th>
                  <td>{{{PowerCost}}}</td>
                </tr>
                 <tr>
                  <th><span class="icon">&#128230;</span> Inventory Slots</th>
                  <td>{{{StorageSlots}}}</td>
                </tr>
                 <tr>
                  <th><span class="icon">&#128451;</span> Capacity</th>
                  <td>{{{StorageCapacity}}}</td>
                </tr>
                 <tr>
                  <th><span class="icon">&#9883;</span> Recipe</th>
                  <td>{{#invoke:DataTableParserV2|iconize|{{{RecipeToBuild}}}}}</td>
                </tr>
                 <tr>
                  <th><span class="icon">&#128296;</span> Placed With</th>
                  <td>{{#invoke:DataTableParserV2|iconize|{{{PlacedWith}}}}}</td>
                </tr>
               </table>
               </table>
             </div>
             </div>
Line 87: Line 75:
       </div>
       </div>
     </div>
     </div>
   
    <!-- Middle Column: Refining Recipes & Additional Information -->
    <div class="responsive-col col2">
      <!-- Refining Recipes Card -->
      <div class="skin-pivot" style="margin-bottom:20px;">
        <div class="dune-card">
          <div class="dune-card-decoration"></div>
          <div class="dune-card-inner">
            <div class="dune-card-label">CRAFTING</div>
            <div class="dune-card-title"><span class="icon">&#9883;</span> Refining Recipes</div>
            <div class="dune-card-description">Below is a list of possible outputs, required inputs, and the time to refine.
            </div>
            <div class="dune-card-infobox-left">
  <!-- Make sure we define Output, Ingredients, and Time in data= -->
  {{#get_external_data: source=externaldb
    |from=data_refining_recipes
    |data=Output=name,Time=time_to_smelt,Recipe=recipe_to_smelt,Refiner=refiner_needed
    |cache=yes
    |where=refiner_needed='Small Ore Refinery'
   }}
   }}


  <!-- Open the table outside the loop -->
<!-- Middle Column: Refining Recipes & Additional Information -->
  <table class="infobox-dune">
<div class="responsive-col col2">
    <tr>
      <th style="text-align:left;">Output</th>
      <th style="text-align:left;">Recipe</th>
      <th style="text-align:left;">Craft Time</th>
    </tr>
 
    <!-- Each row in the DB becomes a new <tr> here -->
    {{#for_external_table:|
      <tr>
        <!-- Print only the iconized version (no duplication) -->
        <td style="text-align:left;">
          {{#invoke:DataTableParserV2|iconize|{{{Output}}}}}
        </td>
        <td style="text-align:left;">
          {{#invoke:DataTableParserV2|iconize|{{{Recipe}}}}}
        </td>
        <td style="text-align:left;">{{{Time}}}</td>
      </tr>
    }}
  </table>
</div>


  <!-- Refining Recipes Card -->
  <div class="skin-pivot" style="margin-bottom:20px;">
    <div class="dune-card">
      <div class="dune-card-decoration"></div>
      <div class="dune-card-inner">
        <div class="dune-card-label">CRAFTING</div>
        <div class="dune-card-title"><span class="icon">&#9883;</span> Refining Recipes</div>
        <div class="dune-card-description">Below is a list of possible outputs, required inputs, and the time to refine.
        </div>
        <div class="dune-card-infobox-left">
          {{#get_external_data:
            source=externaldb
            |from=data_refining_recipes
            |data=Output=name,Time=time_to_smelt,Recipe=recipe_to_smelt,Refiner=refiner_needed
            |cache=yes
            |where=refiner_needed='Small Ore Refinery'
          }}
          <div style="overflow-x:auto;">
            <table class="infobox-dune" style="width:100%; table-layout:fixed;">
              <tr>
                <th style="text-align:left; width:30%;">Output</th>
                <th style="text-align:left; width:50%;">Recipe</th>
                <th style="text-align:left; width:20%;">Craft Time</th>
              </tr>
              {{#for_external_table:|
                <tr>
                  <td style="text-align:left;">{{#invoke:DataTableParserV2|iconize|1={{{Output}}}}}</td>
                  <td style="text-align:left;">{{#invoke:DataTableParserV2|formatRecipeList|1={{{Recipe}}}}}</td>
                  <td style="text-align:left;">{{{Time}}}</td>
                </tr>
              }}
            </table>
           </div>
           </div>
         </div>
         </div>
       </div>
       </div>
     
    </div>
      <!-- Additional Information Card -->
  </div>
      <div class="skin-pivot" style="margin-bottom:20px;">
 
        <div class="dune-card">
  <!-- Additional Information Card -->
          <div class="dune-card-decoration"></div>
  <div class="skin-pivot" style="margin-bottom:20px;">
          <div class="dune-card-inner">
    <div class="dune-card">
            <div class="dune-card-label">Additional Information</div>
      <div class="dune-card-decoration"></div>
            <div class="dune-card-title"><span class="icon">&#8801;</span> Notes</div>
      <div class="dune-card-inner">
            <div class="dune-card-description">{{{AdditionalNotes}}}
        <div class="dune-card-label">ADDITIONAL INFO</div>
            </div>
        <div class="dune-card-title">
          </div>
          <span class="icon">&#8801;</span> Notes
        </div>
        <div class="dune-card-description">
          {{#invoke:DataTableParserV2|iconize|{{{AdditionalNotes}}}}}
         </div>
         </div>
       </div>
       </div>
     </div>
     </div>
   
  </div>
    <!-- Right Column: Video Tutorials & Related Buildings -->
 
    <div class="responsive-col col3">
</div>
      <!-- Video Tutorials Card -->
 
      <div class="skin-pivot" style="margin-bottom:20px;">
 
        <div class="dune-card">
 
          <div class="dune-card-decoration"></div>
  <!-- Right Column: Video Tutorials & Related Buildings -->
          <div class="dune-card-inner">
  <div class="responsive-col col3">
            <div class="dune-card-label">VIDEO TUTORIALS</div>
 
            <div class="dune-card-title"><span class="icon">&#9654;</span> {{{VideoTitle|Building Guide}}}</div>
    <!-- Video Tutorials Card -->
            <div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;">{{{YoutubeEmbed}}}
    <div class="skin-pivot" style="margin-bottom:20px;">
            </div>
      <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">&#9654;</span> {{{VideoTitle|Building Guide}}}</div>
          <div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;">
            {{#if:{{{YoutubeEmbed|}}}
              | {{{YoutubeEmbed}}}
              | <youtube>r8lxVDqoHLQ</youtube>
            }}
           </div>
           </div>
         </div>
         </div>
       </div>
       </div>
     
    </div>
      <!-- Related Buildings Card -->
 
      <div class="skin-pivot">
    <!-- Related Buildings Card -->
        <div class="dune-card">
    <div class="skin-pivot">
          <div class="dune-card-decoration"></div>
      <div class="dune-card">
          <div class="dune-card-inner">
        <div class="dune-card-decoration"></div>
            <div class="dune-card-label">RELATED BUILDINGS</div>
        <div class="dune-card-inner">
            <div class="dune-card-title"><span class="icon">&#x1F3D7;</span> Other {{{Category3}}}</div>
          <div class="dune-card-label">RELATED BUILDINGS</div>
            <div class="dune-card-description">{{{RelatedBuildingsDescription|Explore similar building types to expand your base capabilities.}}}
          <div class="dune-card-title"><span class="icon">&#x1F3D7;</span> Other {{#external_value:Category3|CategoryThree}}
            </div>
          <div class="dune-card-infobox">
  {{#get_external_data: source=externaldb
    |from=data_buildings
    |data=Name=name,BuildingType=building_type,Category3=category_3
    |cache=yes
    |where=category_3='{{{Category3}}}'
  }}
  <table class="infobox-dune" style="width:100%">
    <tr>
      <th style="text-align:left;">Name</th>
      <th style="text-align:left;">Tier</th>
      <th style="text-align:left;">Description</th>
    </tr>
    {{#for_external_table:|
      <tr>
        <td style="text-align:left;">{{{Name}}}</td>
        <td style="text-align:left;">{{{BuildingType}}}</td>
        <td style="text-align:left;">{{{Category3}}}</td>
      </tr>
    }}
  </table>
</div>
</div>
          <div class="dune-card-description">{{{RelatedBuildingsDescription|Explore similar building types to expand your base capabilities.}}}
          </div>
          <div class="dune-card-infobox">
            {{#get_external_data:
              source=externaldb
              |from=data_buildings
              |data=Name=name,BuildingType=building_type,Category3=category_3
              |cache=yes
              |where=category_3='{{#external_value:Category3|CategoryThree}}
'
            }}
            <table class="infobox-dune" style="width:100%">
              <tr>
                <th style="text-align:left;">Name</th>
                <th style="text-align:left;">Tier</th>
                <th style="text-align:left;">Description</th>
              </tr>
              {{#for_external_table:
                <tr>
                  <td style="text-align:left;">{{{Name}}}</td>
                  <td style="text-align:left;">{{{BuildingType}}}</td>
                  <td style="text-align:left;">{{{Category3}}}</td>
                </tr>
              }}
            </table>
           </div>
           </div>
         </div>
         </div>
       </div>
       </div>
     </div>
     </div>
   
    <div style="clear:both;"></div>
   </div>
   </div>
}}
</div>

Revision as of 01:47, 1 April 2025





SCHEMATIC – BUILDABLE
🛈 Small Ore Refinery
             Small Ore Refinery
Processes raw Copper Ore, Carbon Ore, and Iron Ore into Refined Resource. Can also create Steel Ingots from Iron and Carbon.
🔒Locked Behind
🏅 Building TypeFunctional
Health15
Power Cost5
📦 Inventory Slots
🗃 Capacity
Recipe Salvaged Metal x 90
🔨 Placed WithContruction Tool


CRAFTING
Refining Recipes
Below is a list of possible outputs, required inputs, and the time to refine.
         The query SELECT  name,time_to_smelt,recipe_to_smelt,refiner_needed  FROM `data_refining_recipes`    WHERE refiner_needed='Small Ore Refinery'   is invalid (Error 1146: Table 'dunedbco_ddb.data_refining_recipes' doesn't exist

Function: EDConnectorRdbms::fetch Query: SELECT name,time_to_smelt,recipe_to_smelt,refiner_needed FROM `data_refining_recipes` WHERE refiner_needed='Small Ore Refinery' ).

Output Recipe Craft Time
{{{Output}}} {{{Recipe}}} {{{Time}}}
ADDITIONAL INFO
          Notes
         {{{AdditionalNotes}}}


VIDEO TUTORIALS
Building Guide
RELATED BUILDINGS
🏗 Other Refineries
Explore similar building types to expand your base capabilities.
Name Tier Description
Small Ore Refinery Functional Refineries