User:Crimsonfalconer
CrimsonFalconer
Query Examples
Unique Items
Unique Item Based on Name
{{Query unique items|where=items.name="Vessel of Vinktar" |large=1 |stat=1 |level=1 }}
Yields:
Item | Stats | |
---|---|---|
Vessel of VinktarVessel of Vinktar Topaz FlaskLasts 8.00 Seconds Consumes (45-50) of 50 Charges on use +40% to Lightning Resistance +5% to maximum Lightning ResistanceRequires Level 68(125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken Adds (10-15) to (55-65) Lightning Damage to Attacks during Effect 20% of Lightning Damage Leeched as Life during EffectThe great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. | 68 | (125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken Adds (10-15) to (55-65) Lightning Damage to Attacks during Effect 20% of Lightning Damage Leeched as Life during Effect |
Vessel of VinktarVessel of Vinktar Topaz FlaskLasts 8.00 Seconds Consumes (45-50) of 50 Charges on use +40% to Lightning Resistance +5% to maximum Lightning ResistanceRequires Level 68(125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken Adds (10-15) to (55-65) Lightning Damage to Spells during Effect 20% of Lightning Damage Leeched as Life during EffectThe great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. | 68 | (125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken Adds (10-15) to (55-65) Lightning Damage to Spells during Effect 20% of Lightning Damage Leeched as Life during Effect |
Vessel of VinktarVessel of Vinktar Topaz FlaskLasts 8.00 Seconds Consumes (45-50) of 50 Charges on use +40% to Lightning Resistance +5% to maximum Lightning ResistanceRequires Level 68(125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken Damage Penetrates 6% Lightning Resistance during Effect 20% of Lightning Damage Leeched as Life during EffectThe great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. | 68 | (125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken Damage Penetrates 6% Lightning Resistance during Effect 20% of Lightning Damage Leeched as Life during Effect |
Vessel of VinktarVessel of Vinktar Topaz FlaskLasts 8.00 Seconds Consumes (45-50) of 50 Charges on use +40% to Lightning Resistance +5% to maximum Lightning ResistanceRequires Level 68(125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken 50% of Physical Damage Converted to Lightning during Effect 20% of Lightning Damage Leeched as Life during EffectThe great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. | 68 | (125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken 50% of Physical Damage Converted to Lightning during Effect 20% of Lightning Damage Leeched as Life during Effect |
Vessel of VinktarVessel of Vinktar Topaz FlaskLasts 8.00 Seconds Consumes (45-50) of 50 Charges on use +40% to Lightning Resistance +5% to maximum Lightning ResistanceRequires Level 68(125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken (25-40)% increased Effect of Shocks you inflict during Effect Shocks you inflict during Effect spread to other Enemies within 2 metres 20% of Lightning Damage Leeched as Life during EffectThe great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. | 68 | (125-150)% increased Charges per use Shocks nearby Enemies during Effect, causing 10% increased Damage taken You are Shocked during Effect, causing 50% increased Damage taken (25-40)% increased Effect of Shocks you inflict during Effect Shocks you inflict during Effect spread to other Enemies within 2 metres 20% of Lightning Damage Leeched as Life during Effect |
Unique Items Based on Stats
{{Query unique items |tables=item_stats |join=items._pageID=item_stats._pageID |where=(item_stats.id like "%gain_per_target%" OR item_stats.id like "%granted_when_hit%" OR item_stats.id like "%gained_on%hit%") AND item_stats.is_implicit=0 |large=1 |stat=1 |level=1 |q_limit=3 }}
Yields: Lua error: Error 1054: Unknown column 'cargo__item_stats.is_implicit' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__items`.`stat_text` AS `items.stat_text` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__item_stats` ON ((`cargo__items`.`_pageID`=`cargo__item_stats`.`_pageID`)) WHERE (`cargo__items`.`drop_enabled` = true
AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL AND `cargo__versions`.`release_date` < 20240625144823 ) AND `cargo__items`.`rarity_id` = "unique" AND ((`cargo__item_stats`.`id` like "%gain_per_target%" OR `cargo__item_stats`.`id` like "%granted_when_hit%" OR `cargo__item_stats`.`id` like "%gained_on%hit%") AND `cargo__item_stats`.`is_implicit`=0)) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 3
.
Base Items
{{Query base items |tables=item_stats |join=items._pageID=item_stats._pageID |where=(item_stats.id like "additional_%dexterity%" or item_stats.id="additional_all_attributes") AND item_stats.is_implicit=1 |level=1 |stat_column1_header=Dexterity |stat_column1_stat_format=add |stat_column1_stat1_id=additional_dexterity |stat_column1_stat2_id=additional_strength_and_dexterity |stat_column1_stat3_id=additional_dexterity_and_intelligence |stat_column1_stat4_id=additional_all_attributes }}
Yields: Lua error: Error 1054: Unknown column 'cargo__item_stats.is_implicit' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__item_stats` ON ((`cargo__items`.`_pageID`=`cargo__item_stats`.`_pageID`)) WHERE (`cargo__items`.`drop_enabled` = true
AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL AND `cargo__versions`.`release_date` < 20240625144823 ) AND `cargo__items`.`base_item` IS NULL AND `cargo__items`.`base_item_id` IS NULL AND `cargo__items`.`base_item_page` IS NULL AND ((`cargo__item_stats`.`id` like "additional_%dexterity%" or `cargo__item_stats`.`id`="additional_all_attributes") AND `cargo__item_stats`.`is_implicit`=1)) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000
.
Query Gems
{{Item table/skill gems |q_tables=skill_stats_per_level |q_join=skill_gems._pageID=skill_stats_per_level._pageID |q_where=skill_stats_per_level.id like "%gain_per_target%" OR skill_stats_per_level.id like "%granted_when_hit%" |level=yes |int=yes |dex=yes |str=yes |q_sort=Has primary attribute, Has name }}
Yields:
Gem | ||||
---|---|---|---|---|
Life Gain on Hit SupportLife Gain on Hit SupportAttack, Support Icon: h Level: (1-20) Cost & Reservation Multiplier: 130%Requires Level 8Supports attack skills.(6-44) Life gained per Enemy Hit with Supported Attacks Additional Effects From 1-20% Quality: (0.5-10) Life gained per Enemy Hit with Supported AttacksThis is a Support Gem. It does not grant a bonus to your character, but to skills in sockets connected to it. Place into an item socket connected to a socket containing the Skill Gem you wish to augment. Right click to remove from a socket. | 8 | N/A | N/A | |
Poacher's MarkPoacher's MarkPhysical, Spell, Curse, Mark Level: (1-20) Cost: (16-33) Mana Cast Time: 0.50 secRequires Level 16Curses a single enemy, lowering their physical damage reduction, and adding physical damage to all hits against them. Attacking the cursed enemy will grant life and mana, and killing them will grant a frenzy charge. You can only have one Mark at a time.Cursed enemies have a 100% chance to grant a Frenzy Charge when slain Cursed enemies grant (15-50) Life when Hit by Attacks Cursed enemies grant (8-25) Mana when Hit by Attacks Cursed enemies have -20% to Physical Damage Reduction Adds (3-30) to (4-45) Physical Damage to Hits against Cursed Enemies Additional Effects From 1-20% Quality: Cursed Enemies have a (0.25-5)% chance to grant a Frenzy Charge when HitPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket. | 16 | N/A | N/A |
Base Stats
{{Item table/skill gems |q_tables=skill_stats_per_level |q_join=skill_gems._pageID=skill_stats_per_level._pageID |q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%nslaught%" AND skill_stats_per_level.is_quality_stat=0 |level=yes |int=yes |dex=yes |str=yes |default=There are currently no support skill gems with related base stats. }}
Yields: Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__skill_gems`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class`="Support Skill Gems" AND `cargo__skill_stats_per_level`.`id` like "%nslaught%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=0) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000 .
Quality Stats
{{Item table/skill gems |q_tables=skill_stats_per_level |q_join=skill_gems._pageID=skill_stats_per_level._pageID |q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%nslaught%" AND skill_stats_per_level.is_quality_stat=1 |level=yes |int=yes |dex=yes |str=yes |default=There are currently no support skill gems with related quality stats. }}
Yields: Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__skill_gems`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class`="Support Skill Gems" AND `cargo__skill_stats_per_level`.`id` like "%nslaught%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=1) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000 .
Threshold Jewels
{{Skill threshold jewel list|stat_id=jewel_fireball}}