[dismiss]

The wiki is currently a work in progress. If you'd like to help out, please check the Community Portal and our getting started guide. Also, check out our sister project on poewiki.net.

User:Mefisto1029 and User:Mefisto1029/sandbox: Difference between pages

(Difference between pages)
Jump to navigation Jump to search
Page 1
Page 2
 
No edit summary
Tag: Manual revert
 
Line 1: Line 1:
{{Sister|poewiki}}
{{Sister|poewiki}}
My bot [[User:MefistoBot|MefistoBot]].<br>
My [[User:Mefisto1029/sandbox|Sandbox]].


==Items without release_version==
==1==
{{Collapse top|Table list}}
{{Item/sandbox
{{#cargo_query:
|rarity_id                              = normal
|tables = items
|name                                    = Arctic Armour
|where = release_version IS NULL
|class_id                                = Active Skill Gem
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|size_x                                  = 1
|format = table
|size_y                                  = 1
}}
|drop_level                              = 1
{{Collapse bottom}}
|tags                                    = gem, default
|metadata_id                            =
|help_text                              =  
|intelligence_percent                    = 100
|gem_tags                                = Buff, Spell, Persistent, Sustained, Cold
|gem_description                        =  
|active_skill_name                      =  
|skill_icon                              = Arctic Armour
|skill_id                                = Arctic Armour
|required_level                          =
|static_cost_types                      = Spirit
|static_critical_strike_chance          = 11
|stat_text                              =
|static_cost_amounts                    = 30
|level1                                  = True


==Gems without gem_tier==
|gem_tier = 2
{{#cargo_query:
|release_version                        = 0.1.0
|tables = items, skill_gems
|join on = items._pageName=skill_gems._pageName
|fields = items.name
|format = template
|template = il
|delimiter = ,&nbsp;
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL
|limit = 25
}}
}}


==Files to fix==
* {{il|Spark}}
* {{il|Falling Thunder}}
* {{il|page=Uncut Skill Gem}}
* {{il|page=Uncut Skill Gem (quest item)}}
* {{ql|The Trail of Corruption}}
* {{il|Balbala's Barya}}
* {{il|The Last Flame}}
* {{il|Heartbound Loop}}


==Unique flavuor==
{{Item acquisition/sandbox}}
{{Drop enabled unique item table
|flavour_text = 1
|where = items.class_id NOT LIKE "Relic" AND (flavour_text IS NULL OR flavour_text LIKE "Coming Soon" )
}}
 
==Big def values==
{| class = "wikitable plainlist"
|+ Biggest defense values
|-
! Type
! Armour
! Evasion
! Energy Shield
|-
! Body Armour
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Body Armour"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Body Armour"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Body Armour"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}


|-
{{clear}}
! Helmets
<!--
|<!--Armour-->
==Gem==
{{Simple item list
{{Item/sandbox
|q_tables = armours
|rarity_id                               = normal
|q_join = items._PageID = armours._PageID
|name                                    = Uncut Skill Gem
|q_where = items.rarity_id = "normal"
|class_id                               = QuestItem
  AND items.drop_enabled = 1
|size_x                                  = 1
  AND items.class_id = "Helmet"
|size_y                                  = 1
  AND armours.energy_shield_range_maximum = 0
|drop_level                              = 1
  AND armours.evasion_range_maximum = 0
|tags                                    = default
  AND armours.armour_range_maximum > 0
|metadata_id                            =
|q_orderBy = armours.armour_range_maximum DESC
|stack_size                              =  
|q_limit = 1
|description                            = Creates a Skill Gem up to level 1
}}
|help_text                              = Right Click to engrave a Skill Gem.
|<!--Evasion-->
|stack_size_currency_tab                = 5000
{{Simple item list
|release_version                        = 0.1.0
|q_tables = armours
|is_drop_restricted                      = true
|q_join = items._PageID = armours._PageID
|drop_text                              = Quest reward for [[Reaching Clearfell]].
|q_where = items.rarity_id = "normal"
|quest_reward1_type                      = quest
  AND items.drop_enabled = 1
|quest_reward1_quest                    = Reaching Clearfell
  AND items.class_id = "Helmet"
|quest_reward1_quest_id                  = a1q1
  AND armours.energy_shield_range_maximum = 0
|quest_reward1_act                      = 1
  AND armours.evasion_range_maximum > 0
|quest_reward1_npc                      = Renly
  AND armours.armour_range_maximum = 0
|quest_reward1_notes                    = Tier 1
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Helmet"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
}}


|-
{{Item acquisition/sandbox}}-->
! Gloves
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Gloves"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Gloves"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Gloves"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|-
! Boots
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Boots"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Boots"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Boots"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|-
! Shields
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Shield"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Buckler"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Focus"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}


|}
==[[Witch]] maps==
* '''[[Forge]]''': Not quite hot enough here for my tastes.
* '''[[Sulphuric Caverns]]''': I don't mind pollution, but not like this.
* '''{{c|unique|[[Untainted Paradise]]}}''': —
Retrieved from "https://www.poe2wiki.net/wiki/Special:ComparePages"