User:Findar: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
|rarity_id = unique | |rarity_id = unique | ||
{{Item | |||
|rarity_id = unique | |||
|name = The Screaming Eagle | |||
|class_id = One Hand Axe | |||
|base_item = Jade Hatchet | |||
{{#cargo_query: | |||
tables=items | |||
|where = items.rarity_id="unique" | |||
|group by=items.class_id | |||
|format=table | |||
|fields=items.name,items.base_item | |||
|limit=25 | |||
}} | |||
items._pageID=maps._pageID, | items._pageID=maps._pageID, | ||
Revision as of 18:33, 10 October 2023
Test Page
items._pageName=maps._pageName=maps.series=map_series.name
drop_areas
|rarity_id = unique
{{Item |rarity_id = unique |name = The Screaming Eagle |class_id = One Hand Axe |base_item = Jade Hatchet
| name | base item |
|---|---|
| Abhorrent Interrogation | Ambush Mitts |
| Actum | Butcher Axe |
| Ahuana's Bite | Sharktooth Arrow Quiver |
| Akoya's Gaze | Regicide Mask |
| Amanamu's Gaze | Ghastly Eye Jewel |
| Ambition | Vaal Aspect |
| Anathema | Moonstone Ring |
| Ancestral Vision | Viridian Jewel |
| Arn's Anguish | Cloth Belt |
| Atop the Atlas | Platinum Valdo's Rest Watchstone |
| Atziri's Rule | Judgement Staff |
| Aurumvorax | Basket Rapier |
| Badge of the Brotherhood | Turquoise Amulet |
| Beacon of Madness | Two-Toned Boots |
| Blood of the Karui | Sanctified Life Flask |
| Blunderbore | Astral Plate |
| Cold Iron Point | Ezomyte Dagger |
| Contract: Breaking the Unbreakable | Preventative Contract |
| Divination Distillate | Large Hybrid Flask |
| Doedre's Elixir | Greater Mana Flask |
| Elixir of the Unbroken Circle | Iron Flask |
| Emperor's Vigilance | Steel Kite Shield |
| Escalation | Brimstone Stalker Sentinel |
| Goblinedge | Ambusher |
| Grace of the Goddess | Prophecy Wand |
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 | MapAtlasAcademy |
| Acid Caverns Map | MapAtlasAcidLakes |
| Alleyways Map | MapWorldsAlleyways |
| Ancient City Map | MapAtlasVaalCity |
| Arachnid Nest Map | MapAtlasArachnidNest |
| Arachnid Tomb Map | MapAtlasArachnidTomb |
| Arcade Map | MapAtlasArcade |
| Arena Map | MapAtlasArena |
| Arid Lake Map | MapAtlasAridLake |
| Armoury Map | MapAtlasArmory |
| Arsenal Map | MapAtlasArsenal |
| Ashen Wood Map | MapAtlasAshenWood |
| Atoll Map | MapAtlasAtoll |
| Barrows Map | MapAtlasBarrows |
| Basilica Map | MapWorldsBasilica |
| Bazaar Map | MapAtlasBazaar |
| Beach Map | MapAtlasBeach |
| Belfry Map | MapWorldsBelfry |
| Bog Map | MapAtlasBog |
| Bone Crypt Map | MapAtlasCatacomb_ |
| Bramble Valley Map | MapWorldsBrambleValley |
| Burial Chambers Map | MapAtlasBurialChambers |
| Cage Map | MapWorldsCage |
| Caldera Map | MapAtlasAbyss |
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