Actions

Template

BuildingRefinerDisplayV2: Difference between revisions

From Dune Awakening DB

mNo edit summary
mNo edit summary
 
(27 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#get_external_data:
<templatestyles src="Template:BuildingPage/styles.css" />
  source=externaldb
{{#get_external_data:source=externaldb|from=data_buildings|data=ID=id,BuildingType=building_type,Name=name,Description=description,PowerCost=power_cost,GeneratesPower=generates_power,StorageSlots=storage_slots,StorageCapacity=storage_capacity,SchematicRequirement=schematic_requirement,JourneyRequirement=journey_requirement,Health=health,PlacedWith=placed_with,AdditionalNotes=additional_notes,RecipeToBuild=recipe_to_build,ImageFile=image_file,IconFile=icon_file,Category1=category_1,Category2=category_2,Category3=category_3,Gallery1=gallery_1,Gallery2=gallery_2,Gallery3=gallery_3,Gallery4=gallery_4,YoutubeVideoLink=youtube_video_link|cache=yes|where=name='{{PAGENAME}}'|limit=1}}
  |from=data_buildings
{{#for_external_table:|{{#vardefine:Name|{{{Name}}}}}{{#vardefine:BuildingType|{{{BuildingType}}}}}{{#vardefine:Description|{{{Description}}}}}{{#vardefine:PowerCost|{{{PowerCost}}}}}{{#vardefine:GeneratesPower|{{{GeneratesPower}}}}}{{#vardefine:StorageSlots|{{{StorageSlots}}}}}{{#vardefine:StorageCapacity|{{{StorageCapacity}}}}}{{#vardefine:SchematicRequirement|{{{SchematicRequirement}}}}}{{#vardefine:JourneyRequirement|{{{JourneyRequirement}}}}}{{#vardefine:Health|{{{Health}}}}}{{#vardefine:PlacedWith|{{{PlacedWith}}}}}{{#vardefine:AdditionalNotes|{{{AdditionalNotes}}}}}{{#vardefine:RecipeToBuild|{{{RecipeToBuild}}}}}{{#vardefine:ImageFile|{{{ImageFile}}}}}{{#vardefine:IconFile|{{{IconFile}}}}}{{#vardefine:Category3|{{{Category3}}}}}{{#vardefine:Category2|{{{Category2}}}}}{{#vardefine:Category1|{{{Category1}}}}}{{#vardefine:YoutubeVideoLink|{{{YoutubeVideoLink}}}}} }}
  |data=ID=id,
<!-- Main container with reduced gaps for better wiki fit -->
        BuildingType=building_type,
{{#if:{{{AdditionalNotes|}}}
        Name=name,
| {{#vardefine:AdditionalNotes|{{{AdditionalNotes}}}}}
        Description=description,
| <!-- fallback already set inside external data loop -->
        PowerCost=power_cost,
        GeneratesPower=generates_power,
        StorageSlots=storage_slots,
        StorageCapacity=storage_capacity,
        SchematicRequirement=schematic_requirement,
        JourneyRequirement=journey_requirement,
        Health=health,
        PlacedWith=placed_with,
        AdditionalNotes=additional_notes,
        RecipeToBuild=recipe_to_build,
        ImageFile=image_file,
        IconFile=icon_file,
        Category1=category_1,
        Category2=category_2,
        Category3=category_3,
        Gallery1=gallery_1,
        Gallery2=gallery_2,
        Gallery3=gallery_3,
        Gallery4=gallery_4,
        YoutubeVideoLink=youtube_video_link
  |cache=yes
  |where=name='Small Ore Refinery'
  |limit=1
}}
}}
{{#for_external_table:|{{#vardefine:Name|{{{Name}}}}}{{#vardefine:BuildingType|{{{BuildingType}}}}}{{#vardefine:Description|{{{Description}}}}}{{#vardefine:PowerCost|{{{PowerCost}}}}}{{#vardefine:GeneratesPower|{{{GeneratesPower}}}}}{{#vardefine:StorageSlots|{{{StorageSlots}}}}}{{#vardefine:StorageCapacity|{{{StorageCapacity}}}}}{{#vardefine:SchematicRequirement|{{{SchematicRequirement}}}}}{{#vardefine:JourneyRequirement|{{{JourneyRequirement}}}}}{{#vardefine:Health|{{{Health}}}}}{{#vardefine:PlacedWith|{{{PlacedWith}}}}}{{#vardefine:AdditionalNotes|{{{AdditionalNotes}}}}}{{#vardefine:RecipeToBuild|{{{RecipeToBuild}}}}}{{#vardefine:ImageFile|{{{ImageFile}}}}}{{#vardefine:IconFile|{{{IconFile}}}}}{{#vardefine:Category3|{{{Category3}}}}}{{#vardefine:YoutubeVideoLink|{{{YoutubeVideoLink}}}}} }}
<div class="dune-breadcrumb-nav">
<!-- Main container -->
  <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">
<div class="responsive-container">
   <!-- Left Column -->
   <!-- Left Column -->
   <div class="responsive-col col1">
   <div class="responsive-col col1">
Line 41: Line 18:
         <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> {{#var:Name}}</div>
           <div class="dune-card-title"><span class="icon">&#x1F6C8;</span> Building Information</div>
           <div class="dune-card-image">
          <div style="padding:3px;"></div>
             {{#if:{{#var:ImageFile}}|[[File:{{#var:ImageFile}}|200px|alt={{#var:Name}}|style=max-width:100%;max-height:150px;object-fit:contain;border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;]]}}
         
          <!-- Image Section -->
           <div class="dune-card-image" style="text-align: center;">
             <div class="has-border">{{#if:{{#var:ImageFile}}
                | [[File:{{#var:ImageFile}}|200px|alt={{#var:Name}}]]
                | [[File:Placeholder.png|200px|alt=No image available]]}}
            </div>
           </div>
           </div>
          <div style="padding:3px;"></div>
         
          <!-- Description -->
           <div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{#var:Description}}}}</div>
           <div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{#var:Description}}}}</div>
         
          <!-- Locked Behind -->
           <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">{{#var:JourneyRequirement}}</div>
             <div class="dune-card-locked-value">{{#var:JourneyRequirement}}</div>
           </div>
           </div>
           <div class="dune-card-infobox-two-column">
 
          <table class="infobox-dune-two-column">
          <!-- Table -->
           <div class="dune-table-wrapper">
            <table class="infobox-dune-two-column">
               <tr><th><span class="icon">[[File:BuildingTypeIcon.png]]</span> Building Type</th><td>{{#var:BuildingType}}</td></tr>
               <tr><th><span class="icon">[[File:BuildingTypeIcon.png]]</span> Building Type</th><td>{{#var:BuildingType}}</td></tr>
               <tr><th><span class="icon">[[File:BuildingHealthIcon.png]]</span> Health</th><td>{{#var:Health}}</td></tr>
               <tr><th><span class="icon">[[File:BuildingHealthIcon.png]]</span> Health</th><td>{{#var:Health}}</td></tr>
Line 69: Line 59:
   <div class="responsive-col col2">
   <div class="responsive-col col2">
     <!-- Refining Recipes Card -->
     <!-- Refining Recipes Card -->
     <div class="skin-pivot" style="margin-bottom:20px;">
     <div class="skin-pivot">
       <div class="dune-card">
       <div class="dune-card">
         <div class="dune-card-decoration"></div>
         <div class="dune-card-decoration"></div>
Line 75: Line 65:
           <div class="dune-card-label">CRAFTING</div>
           <div class="dune-card-label">CRAFTING</div>
           <div class="dune-card-title"><span class="icon">&#9883;</span> Refining Recipes</div>
           <div class="dune-card-title"><span class="icon">&#9883;</span> Refining Recipes</div>
          <div style="padding:3px;"></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-description">Below is a list of possible outputs, required inputs, and the time to refine.</div>
         
          <!-- Refining Recipes -->
           <div class="dune-card-infobox-left">
           <div class="dune-card-infobox-left">
             {{#get_external_data:
             {{#get_external_data:
Line 82: Line 75:
               |data=Output=name,Time=time_to_smelt,Recipe=recipe_to_smelt,Refiner=refiner_needed
               |data=Output=name,Time=time_to_smelt,Recipe=recipe_to_smelt,Refiner=refiner_needed
               |cache=yes
               |cache=yes
               |where=refiner_needed='Small Ore Refinery'
               |where=refiner_needed='{{PAGENAME}}'
             }}
             }}
             <div style="overflow-x:auto;">
             <div class="dune-table-wrapper" style="overflow-x: auto;">
               <table class="infobox-dune-standard-table" style="width:100%; table-layout:fixed;">
               <table class="infobox-dune-standard-table">
                 <tr>
                 <tr class="tr-dark">
                   <th style="text-align:left; width:30%;">Output</th>
                   <th style="text-align:left; width:30%;">Output</th>
                   <th style="text-align:left; width:50%;">Recipe</th>
                   <th style="text-align:left; width:50%;">Recipe</th>
Line 101: Line 94:
             </div>
             </div>
           </div>
           </div>
        </div>
         
      </div>
          <div style="clear:both; padding:10px;"></div>
    </div>
         
 
          <!-- Other Refiners content integrated here -->
    <!-- Related Buildings Card (Moved to middle column) -->
    <div class="skin-pivot">
      <div class="dune-card">
        <div class="dune-card-decoration"></div>
        <div class="dune-card-inner">
          <div class="dune-card-label">RELATED BUILDINGS</div>
           <div class="dune-card-title"><span class="icon">&#x1F3D7;</span> Other {{#var:Category3}}</div>
           <div class="dune-card-title"><span class="icon">&#x1F3D7;</span> Other {{#var:Category3}}</div>
          <div style="padding:3px;"></div>
           <div class="dune-card-description">Explore similar building types to expand your base capabilities.</div>
           <div class="dune-card-description">Explore similar building types to expand your base capabilities.</div>
           <div class="dune-card-infobox">
           <div class="dune-table-wrapper">
             {{#get_external_data:
             {{#get_external_data:
               source=externaldb
               source=externaldb
Line 121: Line 109:
               |where=category_3='{{#var:Category3}}'
               |where=category_3='{{#var:Category3}}'
             }}
             }}
             <table class="infobox-dune-standard-table" style="width:100%">
             <table class="infobox-dune-standard-table">
               <tr>
               <tr class="tr-dark">
                 <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;">Tier</th>
Line 143: Line 131:
   <!-- Right Column -->
   <!-- Right Column -->
   <div class="responsive-col col3">
   <div class="responsive-col col3">
     <!-- Building Guide Video Card -->
     <!-- Building Guide Video Card with Notes integrated -->
     <div class="skin-pivot" style="margin-bottom:20px;">
     <div class="skin-pivot">
       <div class="dune-card">
       <div class="dune-card">
         <div class="dune-card-decoration"></div>
         <div class="dune-card-decoration"></div>
Line 150: Line 138:
           <div class="dune-card-label">VIDEO TUTORIALS</div>
           <div class="dune-card-label">VIDEO TUTORIALS</div>
           <div class="dune-card-title"><span class="icon">&#9654;</span> Building Guide</div>
           <div class="dune-card-title"><span class="icon">&#9654;</span> Building Guide</div>
           <div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;"> {{#if:{{{YoutubeEmbed|}}}
          <div style="padding:3px;"></div>
           <div class="dune-card-video" style="border:2px solid #e2d3ae;border-radius:4px;padding:2px;background-color:#262626;">  
            {{#if:{{{YoutubeEmbed|}}}
               | {{{YoutubeEmbed}}}
               | {{{YoutubeEmbed}}}
               | <youtube>r8lxVDqoHLQ</youtube>}}
               | <youtube>r8lxVDqoHLQ</youtube>}}
           </div>
           </div>
        </div>
         
      </div>
          <div style="clear:both; padding:10px;"></div>
    </div>
         
 
          <!-- Notes content integrated here -->
    <!-- Additional Notes Card (Moved to right column) -->
    <div class="skin-pivot">
      <div class="dune-card">
        <div class="dune-card-decoration"></div>
        <div class="dune-card-inner">
          <div class="dune-card-label">ADDITIONAL INFO</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 style="padding:3px;"></div>
           <div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{#var:AdditionalNotes}}}}</div>
           <div class="dune-card-description">{{#invoke:DataTableParserV2|iconize|{{#var:AdditionalNotes}}}}</div>
         </div>
         </div>

Latest revision as of 01:05, 23 May 2025


Menu/[[{{{Category1}}}|{{{Category1}}}]]/[[{{{Category2}}}|{{{Category2}}}]]/[[{{{Category3}}}|{{{Category3}}}]]/BuildingRefinerDisplayV2
SCHEMATIC – BUILDABLE
🛈 Building Information
[[File:{{{ImageFile}}}|200px|alt={{{Name}}}]]
{{{Description}}}
🔒Locked Behind
{{{JourneyRequirement}}}
Building Type{{{BuildingType}}}
Health{{{Health}}}
Power Cost{{{PowerCost}}}
Inventory Slots{{{StorageSlots}}}
Capacity{{{StorageCapacity}}}
Recipe{{{RecipeToBuild}}}
Placed With{{{PlacedWith}}}
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='BuildingRefinerDisplayV2'   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='BuildingRefinerDisplayV2' ).

Output Recipe Craft Time
🏗 Other {{{Category3}}}
Explore similar building types to expand your base capabilities.
Name Tier Description
VIDEO TUTORIALS
Building Guide
Notes
{{{AdditionalNotes}}}