User:OmegaK2/test2: Difference between revisions
Jump to navigation
Jump to search
>OmegaK2 No edit summary |
>OmegaK2 No edit summary |
||
Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=items | |tables=items, weapons | ||
|fields=items. | |join on=weapons._pageID=items._pageID | ||
|where=items. | |fields=items.class=Class, CONCAT(CASE items.class WHEN "Bows" THEN "Ranged" WHEN "Wands" THEN "Ranged" ELSE "Melee" END)=test, MIN(weapons.critical_strike_chance_range_minimum)=Min, MAX(weapons.critical_strike_chance_range_maximum)=Max | ||
|group by=items.class | |||
|where=items.rarity="Normal" | |||
}} | }} |
Revision as of 10:27, 28 January 2018
Class | test | Min | Max |
---|---|---|---|
Abyss Jewel | Melee | ||
Amulet | Melee | ||
Belt | Melee | ||
Blueprint | Melee | ||
Body Armour | Melee | ||
Boots | Melee | ||
Bow | Melee | 5.0 | 7.5 |
Breachstone | Melee | ||
Captured Soul | Melee | ||
Charm | Melee | ||
Claw | Melee | 6.0 | 6.5 |
Contract | Melee | ||
Corpse item | Melee | ||
Cosmetic Item | Melee | ||
Currency Item | Melee | ||
Dagger | Melee | 6.0 | 6.5 |
Divination Card | Melee | ||
Ember of the Allflame | Melee | ||
Expedition Logbook | Melee | ||
Fishing Rod | Melee | 5.0 | 5.0 |
Gloves | Melee | ||
Harvest Seed | Melee | ||
Heist Target | Melee | ||
Helmet | Melee | ||
Hideout Decoration | Melee | ||
Hybrid Flask | Melee | ||
Incubator | Melee | ||
Incursion Item | Melee | ||
Instance Local Item | Melee | ||
Item Piece | Melee | ||
Jewel | Melee | ||
Labyrinth Key | Melee | ||
Labyrinth Trinket | Melee | ||
Leaguestone | Melee | ||
Life Flask | Melee | ||
Mana Flask | Melee | ||
Map | Melee | ||
Map Fragment | Melee | ||
Memory | Melee | ||
Miscellaneous Map Item | Melee | ||
Monster Organ Sample | Melee | ||
One-Handed Axe | Melee | 5.0 | 5.0 |
One-Handed Mace | Melee | 5.0 | 5.0 |
One-Handed Sword | Melee | 5.0 | 7.0 |
Quest Item | Melee | ||
Quiver | Melee | ||
Relic | Melee | ||
Resonator | Melee | ||
Ring | Melee | ||
Rogue's Brooch | Melee | ||
Rogue's Cloak | Melee | ||
Rogue's Gear | Melee | ||
Rogue's Tool | Melee | ||
Rune Dagger | Melee | 6.3 | 6.5 |
Sanctified Relic | Melee | ||
Sanctum Research | Melee | ||
Sceptre | Melee | 6.0 | 6.5 |
Seed Enhancer | Melee | ||
Sentinel | Melee | ||
Shield | Melee | ||
Skill Gem | Melee | ||
Staff | Melee | 6.0 | 7.0 |
Support Gem | Melee | ||
Thrusting One-Handed Sword | Melee | 5.5 | 6.5 |
Tincture | Melee | ||
Trinket | Melee | ||
Two-Handed Axe | Melee | 5.0 | 7.5 |
Two-Handed Mace | Melee | 5.0 | 6.0 |
Two-Handed Sword | Melee | 5.0 | 7.0 |
Utility Flask | Melee | ||
Vault Key | Melee | ||
Voidstone | Melee | ||
Wand | Melee | 7.0 | 8.0 |
Warstaff | Melee | 6.1 | 7.3 |
Watchstone | Melee |