Actions

Template

BuildingRefinerDisplayV2: Difference between revisions

From Dune Awakening DB

Newer edit →
VisualWikitext
Created page with "<div class="responsive-container"> <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">🛈</span> {{{Name}}}</div> {{#get_external_data: source=externaldb |from=data_buildings |where=name='{{{Name}}}' |data=name=Name,description=Description,journey_require..."
 
mNo edit summary
Tag: Reverted
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,energy_consumption=EnergyConsumption,
        generates_power=GeneratesPower,storage_slots=StorageSlots,
        storage_volume=StorageVolume,schematic_requirement=SchematicRequirement,
        journey_requirement=JourneyRequirement,placed_with=PlacedWith,
        recipe_to_build=Components,image_file=ImageFile,icon_file=IconFile,
        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="responsive-col col1">
<div class="skin-pivot">
<div class="skin-pivot">
Line 6: Line 20:
<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> {{#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>
{{#get_external_data: source=externaldb
<div class="dune-card-description">{{#get_external_data: source=externaldb
  |from=data_buildings
  |from=data_building_descriptions
  |where=name='{{{Name}}}'
  |where=building_name='{{#var:BuildingName}}'
  |data=name=Name,description=Description,journey_requirement=JourneyRequirement,
  |data=description=Description
        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
}}
}}
 
{{{Description|}}}</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">{{{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 27: Line 34:
<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>{{{BuildingType}}}</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">&#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>{{#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 ({{{Components}}})  
Line 61: Line 68:
     {{#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 88: Line 95:
       <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">{{#get_external_data: source=externaldb
|from=data_building_notes
|where=building_name='{{#var:BuildingName}}'
|data=notes=AdditionalNotes
}}{{{AdditionalNotes|}}}</div>
     </div>
     </div>
   </div>
   </div>
Line 103: Line 114:
       <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_buildings
     |from=data_building_videos
     |where=name='{{{Name}}}'
     |where=building_name='{{#var:BuildingName}}'
     |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 124: Line 135:
         {{#get_external_data: source=externaldb
         {{#get_external_data: source=externaldb
         |from=data_buildings
         |from=data_buildings
         |where=category3='{{{Category3}}}'
         |where=category_3='{{{Category3}}}'
         |data=name=RelatedName,tier=RelatedTier,description=RelatedDescription,icon_file=RelatedIconFile
         |data=name=RelatedName,building_type=RelatedType,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;">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: {{{RelatedName}}} | {{#var:BuildingName}} | | 1 }} |
         {{!}}-
         {{!}}-
         {{!}} [[File:{{{RelatedIconFile}}}|20px]] [[{{{RelatedName}}}]]
         {{!}} [[File:{{{RelatedIconFile}}}|20px]] [[{{{RelatedName}}}]]
         {{!}} {{{RelatedTier}}}
         {{!}} {{{RelatedType}}}
         {{!}} {{{RelatedDescription}}}
         {{!}} {{{RelatedDescription}}}
         |}}
         |}}

Revision as of 13:41, 25 March 2025


The query SELECT ID,BuildingType,Name,EnergyConsumption,GeneratesPower,StorageSlots,StorageVolume,SchematicRequirement,JourneyRequirement,PlacedWith,Components,ImageFile,IconFile,Category1,Category2,Category3,Gallery1,Gallery2,Gallery3,Gallery4 FROM `data_buildings` WHERE name='BuildingRefinerDisplayV2' is invalid (Error 1054: Unknown column 'BuildingType' in 'SELECT' Function: EDConnectorRdbms::fetch Query: SELECT ID,BuildingType,Name,EnergyConsumption,GeneratesPower,StorageSlots,StorageVolume,SchematicRequirement,JourneyRequirement,PlacedWith,Components,ImageFile,IconFile,Category1,Category2,Category3,Gallery1,Gallery2,Gallery3,Gallery4 FROM `data_buildings` WHERE name='BuildingRefinerDisplayV2' ).

SCHEMATIC – BUILDABLE
🛈 BuildingRefinerDisplayV2
[[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;]]
The query SELECT Description FROM `data_building_descriptions` WHERE building_name='BuildingRefinerDisplayV2' is invalid (Error 1146: Table 'dunedbco_ddb.data_building_descriptions' doesn't exist

Function: EDConnectorRdbms::fetch Query: SELECT Description FROM `data_building_descriptions` WHERE building_name='BuildingRefinerDisplayV2' ).

🔒Locked Behind
{{{JourneyRequirement}}}
🏅 Type{{{BuildingType}}}
⚙ Primary SourceCrafting
⚡ Power Cost{{{EnergyConsumption}}}
📦 Inventory Slots{{{StorageSlots}}}
🗃 Volume Capacity{{{StorageVolume}}}
⚛ Components

The 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='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
The query SELECT AdditionalNotes FROM `data_building_notes` WHERE building_name='BuildingRefinerDisplayV2' is invalid (Error 1146: Table 'dunedbco_ddb.data_building_notes' doesn't exist

Function: EDConnectorRdbms::fetch Query: SELECT AdditionalNotes FROM `data_building_notes` WHERE building_name='BuildingRefinerDisplayV2'

).
VIDEO TUTORIALS
▶ Building Guide
   The query SELECT  YoutubeURL  FROM `data_building_videos`    WHERE building_name='BuildingRefinerDisplayV2'   is invalid (Error 1146: Table 'dunedbco_ddb.data_building_videos' doesn't exist

Function: EDConnectorRdbms::fetch Query: SELECT YoutubeURL FROM `data_building_videos` WHERE building_name='BuildingRefinerDisplayV2' ). 

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

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

       The query SELECT  DescName,RelatedDescription  FROM `data_building_descriptions`    WHERE building_name IN ({{{RelatedName}}})   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:RelatedName})' at line 1

Function: EDConnectorRdbms::fetch Query: SELECT DescName,RelatedDescription FROM `data_building_descriptions` WHERE building_name IN ({{{RelatedName}}}) ).

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