BuildingRefinerDisplayV2: Difference between revisions

Revision as of 13:44, 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 Source	Crafting
⚡ 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

@@ Line 10: / Line 10: @@
          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
+         category_1=Category1,category_2=Category2,category_3=Category3,
+        gallery_1=Gallery1,gallery_2=Gallery2,gallery_3=Gallery3,gallery_4=Gallery4
 }}
@@ Line 19: / Line 20: @@
 <div class="dune-card-inner">
 <div class="dune-card-label">SCHEMATIC – BUILDABLE</div>
-<div class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{#external_value:Name}}</div>
+<div class="dune-card-title"><span class="icon">&#x1F6C8;</span> {{#var:BuildingName}}</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>
+<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
   |from=data_building_descriptions
@@ Line 26: / Line 27: @@
   |data=description=Description
 }}
-{{#external_value:Description|No description available}}</div>
+{{{Description|}}}</div>
 <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-value">{{#external_value:journey_requirement}}</div>
+<div class="dune-card-locked-value">{{{JourneyRequirement}}}</div>
 </div>
 <div class="dune-card-infobox">
 <table class="infobox-dune">
-<tr><th><span class="icon">&#127941;</span> Type</th><td>{{#external_value:building_type}}</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>Crafting</td></tr>
-<tr><th><span class="icon">&#9889;</span> Power Cost</th><td>{{#external_value:energy_consumption}}</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>{{#external_value:storage_slots}}</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>{{#external_value:storage_volume}}</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
 |from=data_resources
-|where=name IN ({{#external_value:recipe_to_build}})
+|where=name IN ({{{Components}}})
 |data=name=ComponentName,icon_file=ComponentIconFile}}
-{{#for_external_table:|[[File:{{#external_value:ComponentIconFile}}|20px]] [[{{#external_value:ComponentName}}]]<br>}}
+{{#for_external_table:|[[File:{{{ComponentIconFile}}}|20px]] [[{{{ComponentName}}}]]<br>}}
 </td></tr>
-<tr><th><span class="icon">&#128296;</span> Placed With</th><td>{{#external_value:placed_with}}</td></tr>
+<tr><th><span class="icon">&#128296;</span> Placed With</th><td>{{{PlacedWith}}}</td></tr>
 </table>
 </div>

Template

BuildingRefinerDisplayV2: Difference between revisions

From Dune Awakening DB

Revision as of 13:44, 25 March 2025