User:Findar: Difference between revisions
No edit summary |
No edit summary |
||
Line 9: | Line 9: | ||
items._pageID=maps._pageID, | items._pageID=maps._pageID, | ||
maps.area_id=areas.id, | |||
{{#cargo_query: | {{#cargo_query: | ||
Line 15: | Line 17: | ||
|where = items.class_id="DivinationCard" | |where = items.class_id="DivinationCard" | ||
|group by=items.name | |group by=items.name | ||
|format= | |format=table | ||
|fields=items.name, items.drop_areas | |fields=items.name,items.drop_areas | ||
|limit=25 | |limit=25 | ||
}} | }} | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=items, maps | tables=items, maps | ||
|join on=items._pageName=maps._pageName | |join on=items._pageName=maps._pageName | ||
|where = items.class_id="Map" AND items.rarity_id!="unique" | |where = items.class_id="Map" AND items.rarity_id!="unique" | ||
|group by = items.name | |group by = items.name | ||
|format= | |format=table | ||
|fields=items.name, items._pageName | |fields=items.name, maps.area_id | ||
|limit=25 | |||
| no html | |||
}} | |||
{{#cargo_query: | |||
tables=items=divCards,items=mapItems, maps | |||
|where = mapItems.class_id="Map" AND mapItems.rarity_id!="unique" | |||
|join on=mapItems._pageName=maps._pageName, divCards.drop_areas HOLDS maps.area_id | |||
|format=table | |||
|fields=mapItems.name, divCards.name, maps.area_id | |||
|limit=25 | |limit=25 | ||
| no html | |||
}} | }} |
Revision as of 09:33, 24 May 2023
Test Page
items._pageName=maps._pageName=maps.series=map_series.name
drop_areas
|rarity_id = unique
items._pageID=maps._pageID,
maps.area_id=areas.id,
name | drop areas |
---|---|
A Chilling Wind | MapWorldsForbiddenWoods • MapWorldsColdRiver_ • MapWorldsFrozenCabins • MapWorldsSummit • MapWorldsGorge • MapWorldsIceberg |
A Dab of Ink | 1_3_17_1 • MapWorldsScriptorium • MapWorldsMuseum • MapWorldsAcademy |
A Dusty Memory | Synthesis_MapBoss • Synthesis_MapGuardian1 • Synthesis_MapGuardian2 • Synthesis_MapGuardian3 • Synthesis_MapGuardian4 |
A Familiar Call | |
A Fate Worse Than Death | |
A Modest Request | |
A Mother's Parting Gift | 1_3_15 • 2_8_4 |
A Note in the Wind | MapWorldsDrySea • MapWorldsDunes • MapWorldsDesertSpring • 2_9_4 • MapWorldsDesert |
A Sea of Blue | MapWorldsMineralPools • MapWorldsCrystalOre • MapWorldsTortureChamber • MapWorldsGrotto • MapWorldsCitadel • MapWorldsZiggurat |
A Stone Perfected | MapWorldsGrotto • MapWorldsWharf • MapWorldsFloodedMine • MapWorldsWaterways • MapWorldsVault • MapWorldsCoves • MapWorldsPeninsula • MapWorldsGeode |
Abandoned Wealth | MapAtlasArsenal • MapAtlasReefUnique • MapWorldsShoreUnique |
Acclimatisation | MapWorldsDesertSpring • MapWorldsDunes • MapWorldsDesert • MapWorldsDrySea |
Akil's Prophecy | |
Alivia's Grace | MapWorldsAshenWood • MapWorldsSpiderForest • MapWorldsLair • MapWorldsThicket • MapWorldsDarkForest • MapWorldsForbiddenWoods • MapWorldsTropicalIsland • MapWorldsRamparts • MapWorldsStagnation • MapWorldsJungleValley • MapWorldsBrambleValley |
Alluring Bounty | MapAtziri1 • MapAtziri2 |
Alone in the Darkness | |
Altered Perception | |
Ambitious Obsession | |
Anarchy's Price | |
Arrogance of the Vaal | MapWorldsSunkenCity • MapWorldsAncientCity • MapWorldsVaalPyramid |
Assassin's Favour | 1_3_5 • 2_8_8 • MapAtlasArcade • MapAtlasBazaar • MapAtlasQuay • MapWorldsAlleyways • MapWorldsBazaar • MapWorldsArcade • MapWorldsPort |
Assassin's Gift | |
Astral Protection | MapWorldsMoonTemple |
Atziri's Arsenal | MapWorldsVaalPyramidUnique • MapAtlasVaalPyramidUnique_ • MapAtlasSpiderLair_ |
Audacity | MapAtziri1 |
name | area id |
---|---|
Abomination Map | MapWorldsAbomination |
Academy Map | MapWorldsAcademy |
Acid Caverns Map | MapWorldsAcidLakes |
Alleyways Map | MapWorldsAlleyways |
Ancient City Map | MapWorldsAncientCity |
Arachnid Nest Map | MapWorldsArachnidNest |
Arachnid Tomb Map | MapWorldsArachnidTomb |
Arcade Map | MapWorldsArcade |
Arena Map | MapWorldsArena |
Arid Lake Map | MapWorldsAridLake |
Armoury Map | MapWorldsArmoury |
Arsenal Map | MapWorldsArsenal |
Ashen Wood Map | MapWorldsAshenWood |
Atoll Map | MapWorldsAtoll |
Barrows Map | MapWorldsBarrows |
Basilica Map | MapWorldsBasilica |
Bazaar Map | MapWorldsBazaar |
Beach Map | MapWorldsBeach |
Belfry Map | MapWorldsBelfry |
Bog Map | MapWorldsBog |
Bone Crypt Map | MapWorldsBoneCrypt |
Bramble Valley Map | MapWorldsBrambleValley |
Burial Chambers Map | MapWorldsBurialChambers |
Cage Map | MapWorldsCage |
Caldera Map | MapWorldsCaldera |
Function: CargoSQLQuery::run Query: SELECT `divCards`.`name` AS `name`,`cargo__maps`.`area_id` AS `area id` FROM `cargo__items` `divCards`,`cargo__items` `mapItems` LEFT OUTER JOIN `cargo__items__drop_areas` `divCards__drop_areas` ON ((`divCards`.`_ID`=`divCards__drop_areas`.`_rowID`)) LEFT OUTER JOIN `cargo__maps` ON ((`mapItems`.`_pageName`=`cargo__maps`.`_pageName`) AND (`divCards__drop_areas`.`_value`=`cargo__maps`.`area_id`)) WHERE `mapItems`.`class_id`="Map" AND `mapItems`.`rarity_id`!="unique" ORDER BY `divCards`.`name`,`cargo__maps`.`area_id` LIMIT 25