Template:FactionBuildingCargo: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
Browse history interactively
← Older editNewer edit →
No edit summary
No edit summary
Line 13: Line 13:
           AND B.id = '{{{bldg_id|}}}'
           AND B.id = '{{{bldg_id|}}}'


|fields  = B.id                     = id,
|fields  = B.id                                         = id,
           B.faction               = faction,
           B.faction                                   = faction,
           building_t.name         = name,
           building_t.name                             = name,
           building_t.description   = description,
           building_t.description                       = description,
           B.icon                   = icon,
           B.icon                                       = icon,
          <!--  CONCAT({{{faction}}}, '_', B.prereqs__full)               = prereqs, -->
          CONCAT({{{faction}}}, '_', B.prereqs__full) = prereqs,
           B.gold_cost             = gold,
           B.gold_cost                                 = gold,
           B.wood_cost             = wood,
           B.wood_cost                                 = wood,
           B.ore_cost               = ore,
           B.ore_cost                                   = ore,
           B.crystals_cost         = crystals,
           B.crystals_cost                             = crystals,
           B.gemstones_cost         = gems,
           B.gemstones_cost                             = gems,
           B.mercury_cost           = mercury,
           B.mercury_cost                               = mercury,
           B.dust_cost             = dust,
           B.dust_cost                                 = dust,
           B.graal_cost             = graal
           B.graal_cost                                 = graal
         
                               
            
            
|format    = template
|format    = template

Revision as of 00:16, 1 June 2026





Error 1054: Unknown column 'dungeon' in 'SELECT'

Function: CargoSQLQuery::run Query: SELECT `B`.`_pageID` AS `cargo_backlink_page_id_B`,`building_t`.`_pageID` AS `cargo_backlink_page_id_building_t`,`B`.`id` AS `id`,`B`.`faction` AS `faction`,`building_t`.`name` AS `name`,`building_t`.`description` AS `description`,`B`.`icon` AS `icon`,CONCAT(dungeon, '_', `B`.`prereqs__full`) AS `prereqs`,`B`.`gold_cost` AS `gold`,`B`.`wood_cost` AS `wood`,`B`.`ore_cost` AS `ore`,`B`.`crystals_cost` AS `crystals`,`B`.`gemstones_cost` AS `gems`,`B`.`mercury_cost` AS `mercury`,`B`.`dust_cost` AS `dust`,`B`.`graal_cost` AS `graal` FROM `mw4v_cargo__Translation` `building_t` LEFT OUTER JOIN `mw4v_cargo__Building` `B` ON ((`building_t`.`target_id`=`B`.`id`)) WHERE `B`.`faction` = 'dungeon' 

          AND `building_t`.`language` = 'en'
          AND `B`.`id` = 'dungeon_Build_Artifact_Market_L1'  ORDER BY `B`.`_pageID`,`building_t`.`_pageID`,`B`.`id`,`B`.`faction`,`building_t`.`name` LIMIT 100




Treasury
Requirements: Bank, Fortifications I
Cost Effect
5,000 Gold
5 Gems
5 Crystals
5 Mercury
 		Produces 2000 Gold daily.

Note: Something random test test test








Tavern
Requirements: None.
Cost Effect
5,000 Gold
5 Gems
5 Crystals
5 Mercury
 		Produces 2000 Gold daily.

Note: Something random test test test







Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:FactionBuildingCargo&oldid=21272"