User:Findar: Difference between revisions
No edit summary |
No edit summary |
||
| Line 17: | Line 17: | ||
tables=items | tables=items | ||
|where = items.rarity_id="unique" | |where = items.rarity_id="unique" | ||
|group by=items. | |group by=items.base_item | ||
|format=table | |format=table | ||
|fields=items.name,items.base_item | |fields=items.name,items.base_item | ||
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 |
|---|---|
| Abberath's Horn | Goat's Horn |
| Abhorrent Interrogation | Ambush Mitts |
| Acton's Nightmare | Overgrown Shrine Map |
| Actum | Butcher Axe |
| Advancing Fortress | Gut Ripper |
| Aegis Aurora | Champion Kite Shield |
| Agnerod East | Imperial Staff |
| Ahkeli's Meadow | Ruby Ring |
| Ahn's Contempt | Praetor Crown |
| Ahn's Heritage | Colossal Tower Shield |
| Ahn's Might | Midnight Blade |
| Al Dhih | Timeworn Claw |
| Alberon's Warpath | Soldier Boots |
| Allelopathy | Satin Gloves |
| Allure | Vaal Claw |
| Alpha's Howl | Sinner Tricorne |
| Altered Distant Memory | Synthesised Map |
| Amanamu's Gaze | Ghastly Eye Jewel |
| Ambu's Charge | Crusader Chainmail |
| Anathema | Moonstone Ring |
| Ancient Skull | Bone Helmet |
| Ancient Waystones | Crimson Jewel |
| Angler's Plait | Unset Ring |
| Annihilation's Approach | Dragonscale Boots |
| Apep's Rage | Omen 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 | MapWorldsAcademy |
| Acid Caverns Map | MapWorldsAcidLakes |
| Alleyways Map | MapWorldsAlleyways |
| Ancient City Map | MapWorldsAncientCity |
| Arachnid Nest Map | MapWorldsArachnidNest |
| Arachnid Tomb Map | MapWorldsArachnidTomb |
| Arcade Map | MapAtlasArcade |
| 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