Template:FactionBuildingCargo: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
|join on = | |join on = | ||
building_t.target_id = B.id | building_t.target_id = B.id | ||
|where = B.faction = ' | |where = B.faction = '{{{dungeon|}}}' | ||
AND building_t.language = 'en' | AND building_t.language = 'en' | ||
AND B.id = '{{{bldg_id|}}}' | AND B.id = '{{{bldg_id|}}}' | ||
Revision as of 15:51, 31 May 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` =
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 |
