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]].


==0.3.0 checklist==
== Item test ==
* {{il|Ancestral Warrior Totem}} - Now have no Limit. Check interaction with [[Ancestral Bond]].
{{Item/sandbox
|rarity_id                              = normal
|name                                    = Pyrophyte Staff Mefisto
|class_id                                = Staff
|size_x                                  = 1
|size_y                                  = 4
|drop_level                              = 16
|drop_rarities_ids                      = normal, magic, rare, unique
|tags                                    = no_cold_spell_mods, no_lightning_spell_mods, no_chaos_spell_mods, no_physical_spell_mods, staff, twohand, default


==Items only in EA standard league==
|inherent_skill1_id                      = ShieldBlockPlayer
{{Collapse top|Table list|EAItems}}
|inherent_skill1_min_level              = 0
* {{il|Lasting Ground}}
|inherent_skill1_max_level              = 0
* {{il|Magnetic Remnants}}
|inherent_skill2_id                      = ShieldBlockPlayer
* {{il|Rusted Spikes}}
|inherent_skill2_min_level              = 15
* {{il|Life Bounty}}
|inherent_skill2_max_level              = 15
* {{il|Mana Bounty}}
|inherent_skill3_id                      = ShieldBlockPlayer
* {{il|Malady}}
|inherent_skill3_min_level              = 14
* {{il|Murderous Intent}}
|inherent_skill3_max_level              = 18
* {{il|Auto Reload}}
|inherent_skill4_id                      = ShieldBlockPlayer
* {{il|Bloodlust}}
* {{il|Commandment}}
* {{il|Dauntless}}
* {{il|Ferocity}}
* {{il|Flamepierce}}
* {{il|Lockdown}}
* {{il|Spar}}
* {{il|Stormchain}}
* {{il|xxx}}
* {{il|xxx}}
* {{il|xxx}}
{{Collapse bottom}}


==Items in game with Cruel in metadata==
|implicit1_text = This is implicit text
{{Collapse top|Table list|Cruelmetadata}}
|explicit1_text = This is explicit text
{{#cargo_query:
|tables = items
|where = items._pageNamespace = 0 AND items.metadata_id LIKE "%Cruel%" AND items.is_in_game = true
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|limit = 1000
}}
}}
{{Collapse bottom}}


==Items without release_version==
{{Collapse top|Table list|release_version}}
{{#cargo_query:
{{#cargo_query:
|tables = items
|tables = items
|where = items._pageNamespace = 0 AND release_version IS NULL
|where = items.name LIKE "Pyrophyte Staff%"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name, class_id = Class
|fields = CONCAT('[[', _pageName, '|', name, ']]') = Name, stat_text = Stats
|format = table
|format = table
|limit = 5
}}
}}
{{Collapse bottom}}


==Gems without gem_tier==
{{Item/sandbox
{{Collapse top|Table list|gem_tier}}
|rarity_id                              = normal
{{#cargo_query:
|name                                    = Smithing Hammer Mefisto
|tables = items, skill_gems
|class_id                                = One Hand Mace
|join on = items._pageName=skill_gems._pageName
|size_x                                  = 2
|where = items._pageNamespace = 0 AND items.class_id LIKE "%Skill Gem" and skill_gems.gem_tier IS NULL
|size_y                                  = 3
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|drop_level                              = 4
|format = table
|drop_rarities_ids                      = normal, magic, rare, unique
|tags                                    = ezomyte_basetype, mace, one_hand_weapon, onehand, weapon, default
|metadata_id                            =  
|required_level                          = 4
|required_strength                      = 11
|physical_damage_min                    = 9
|physical_damage_max                    = 15
|critical_strike_chance                  = 5
|attack_speed                            = 1.45
|weapon_range                            = 1.1
|implicit1_text                          = 50% of this Weapon's base Physical Damage Converted to Fire Damage (Hidden)
|extra_stat1_id = local_weapon_implicit_hidden_%_base_damage_is_fire
|extra_stat1_min = 50
|extra_stat1_max = 50
|extra_stat2_id = local_minimum_added_physical_damage
|extra_stat2_min = 10
|extra_stat2_max = 10
|extra_stat3_id = local_maximum_added_physical_damage
|extra_stat3_min = 20
|extra_stat3_max = 20
}}
}}
{{Collapse bottom}}
<!--
 
{{Item/sandbox
==Gems with diffrent name and pageName==
|rarity_id                              = unique
{{Collapse top|Table list|name_and_pageName}}
|name                                    = Olrovasara Mefisto
{{#cargo_query:
|class_id                                = One Hand Mace
|tables = items
|base_item_page  = User:Mefisto1029/sandbox
|where = items._pageNamespace = 0 AND items.name != items._pageName AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem")
|explicit1_text                              = Adds 1 to (60-80) Lightning Damage
|fields = CONCAT('{{il{{!}}page=', _pageName, '}}') = Gem, _pageName = Page
|explicit2_text                              = +(300-400) to Accuracy Rating
|format = table
|explicit3_text                              = (5-30)% increased Attack Speed
|explicit4_text                              = On Hitting an enemy, gains maximum added Lightning damage equal to the enemy's Power for 6 seconds, up to a total of 500
|flavour_text                            = True heroes grow stronger in the face of adversity."<br>- Fourth Tenet of the Knights of the Sun
|release_version                        = 0.1.0
|is_drop_restricted                      = true
|drop_text                              = Drops from [[Olroth, Origin of the Fall]].
|extra_stat1_id = local_weapon_implicit_hidden_%_base_damage_is_fire
|extra_stat1_min = 50
|extra_stat1_max = 50
|extra_stat2_id = local_minimum_added_lightning_damage
|extra_stat2_min = 1
|extra_stat2_max = 1
|extra_stat3_id = local_maximum_added_lightning_damage
|extra_stat3_min = 60
|extra_stat3_max = 80
}}
}}
{{Collapse bottom}}
-->
 
{{Item
==Unique items without flavuor==
|rarity_id                              = normal
{{Collapse top|Table list|flavuor}}
|name                                    = Elegant Greathelm Mefisto
{{Drop enabled unique item table
|class_id                                = Helmet
|flavour_text = 1
|size_x                                  = 2
|where = items.class_id NOT LIKE "Relic" AND (flavour_text IS NULL OR flavour_text LIKE "Coming Soon" )
|size_y                                  = 2
|drop_level                              = 55
|drop_rarities_ids                      = normal, magic, rare, unique
|tags                                    = str_armour, helmet, armour, default
|metadata_id                            =
|required_level                          = 55
|required_strength                      = 101
|armour_min                              = 210
|armour_max                              = 210
|inventory_icon                          = Spired Greathelm
|release_version                        = 0.1.0
}}
}}
{{Collapse bottom}}


==Items without metadata_id==
{{clear}}
{{Collapse top|Table list|metadata_id}}
<!--
{{#cargo_query:
==Gem==
|tables = items
{{Item/sandbox
|where = items._pageNamespace = 0 AND metadata_id IS NULL AND rarity_id = "normal"
|rarity_id                              = normal
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|name                                    = Uncut Skill Gem
|format = table
|class_id                                = QuestItem
|size_x                                  = 1
|size_y                                  = 1
|drop_level                              = 1
|tags                                    = default
|metadata_id                             =
|stack_size                              =
|description                            = Creates a Skill Gem up to level 1
|help_text                              = Right Click to engrave a Skill Gem.
|stack_size_currency_tab                = 5000
|release_version                        = 0.1.0
|is_drop_restricted                      = true
|drop_text                              = Quest reward for [[Reaching Clearfell]].
|quest_reward1_type                      = quest
|quest_reward1_quest                    = Reaching Clearfell
|quest_reward1_quest_id                  = a1q1
|quest_reward1_act                      = 1
|quest_reward1_npc                      = Renly
|quest_reward1_notes                    = Tier 1
}}
}}
{{Collapse bottom}}
==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}}
* {{il|Whirling Slash}}
* Soulcores:
** {{il|Soul Core of Atmohua}}
** {{il|Soul Core of Cholotl}}
** {{il|Soul Core of Citaqualotl}}
** {{il|Soul Core of Zantipi}}


==Big def values==
{{Item acquisition/sandbox}}-->
{| 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
}}
 
|-
! Helmets
|<!--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 = "Helmet"
  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 = "Helmet"
  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 = "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
}}
 
|-
! 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"