Template:FactionBuildingCargo: Difference between revisions
No edit summary |
No edit summary Tag: Reverted |
||
| Line 18: | Line 18: | ||
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, | ||
Revision as of 00:17, 1 June 2026
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  Gold5  Gems5  Crystals5  Mercury |
Produces 2000 Gold daily.
Note: Something random test test test |
 |
Tavern |
| Requirements: None. | |
| Cost | Effect |
| 5,000 Gold 5 Gems5 Crystals5 Mercury |
Produces 2000 Gold daily.
Note: Something random test test test |
