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
 
No edit summary
 
Line 1: Line 1:
{{Sister|poewiki}}
{{Sister|poewiki}}
I am a casual editor and, at the time of writing, have made just over 14k edits. Also [[User:MefistoBot|MefistoBot]] is my bot.
{{#invoke:Sandbox/Mefisto1029/main|keyword|Fire}}
 
{{#invoke:Sandbox/Mefisto1029/main|keyword_infobox|Fire}}
==Subpages==
<!--{{#invoke:Sandbox/Mefisto1029/main|keyword_list}}-->
* [[User:Mefisto1029/sandbox|Sandbox]]
== Item test ==
* [[Module:Sandbox/Mefisto1029/main|Module sandbox]]
{{Item/sandbox
* [[Module:Sandbox/Mefisto1029/main/s1|Module sandbox (config)]]
|rarity_id                              = normal
* [[Module:Sandbox/Mefisto1029/main/s2|Module sandbox (data)]]
|name                                    = Liquid Mefisto
* [[Module:Sandbox/Mefisto1029/main/s3|Module sandbox (extra)]]
|class_id                                = StackableCurrency
 
|size_x                                  = 1
==0.3.0 checklist==
|size_y                                  = 1
* {{il|Ancestral Warrior Totem}} - Now have no Limit. Check interaction with [[Ancestral Bond]].
|drop_level                              = 1
 
|tags                                    = mushrune, currency, default
==Items only in EA standard league==
|metadata_id                            =  
{{Collapse top|Table list|EAItems}}
|stack_size                              = 10
* {{il|Lasting Ground}}
|description                            = Can be combined with other {{c|value|11}} {={c{{!}}value{{!}}11}=} {{#invoke:Sandbox/Mefisto1029/main|keyword|DistilledEmotion|Liquid Emotions}} to Instil Amulets<br>with Notable Passive Skills or [[Waystone]]s with Layers of [[Delirium]]
* {{il|Magnetic Remnants}}
|help_text                              = Right click this item to open the Instilling window.
* {{il|Rusted Spikes}}
|stack_size_currency_tab                = 5000
* {{il|Life Bounty}}
|liquid_emotion_tier                    = 11
* {{il|Mana Bounty}}
|liquid_emotion_mod                      = InstilledMapDelirium11
* {{il|Malady}}
|liquid_emotion_stat_text                = test test
* {{il|Murderous Intent}}
|drop_text                              = Drops from [[Delirium]] monsters.
* {{il|Auto Reload}}
|is_drop_restricted                      = true
* {{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==
{{Collapse top|Table list|Cruelmetadata}}
{{#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:
|tables = items
|where = items._pageNamespace = 0 AND release_version IS NULL
|fields = CONCAT('{{il{{!}}', name, '}}') = Name, class_id = Class
|format = table
}}
{{Collapse bottom}}
 
==Gems without gem_tier==
{{Collapse top|Table list|gem_tier}}
{{#cargo_query:
|tables = items, skill_gems
|join on = items._pageName=skill_gems._pageName
|where = items._pageNamespace = 0 AND items.class_id LIKE "%Skill Gem" and skill_gems.gem_tier IS NULL
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
}}
{{Collapse bottom}}
 
==Gems with diffrent name and pageName==
{{Collapse top|Table list|name_and_pageName}}
{{#cargo_query:
|tables = items
|where = items._pageNamespace = 0 AND items.name != items._pageName AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem")
|fields = CONCAT('{{il{{!}}page=', _pageName, '}}') = Gem, _pageName = Page
|format = table
}}
}}
{{Collapse bottom}}


==Unique items without flavuor==
{{Item/sandbox
{{Collapse top|Table list|flavuor}}
|rarity_id                              = normal
{{Drop enabled unique item table
|name                                    = Smithing Hammer Mefisto
|flavour_text = 1
|class_id                                = One Hand Mace
|where = items.class_id NOT LIKE "Relic" AND (flavour_text IS NULL OR flavour_text LIKE "Coming Soon" )
|size_x                                  = 2
|size_y                                  = 3
|drop_level                              = 4
|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
==Items without metadata_id==
|rarity_id                              = unique
{{Collapse top|Table list|metadata_id}}
|name                                    = Olrovasara Mefisto
{{#cargo_query:
|class_id                                = One Hand Mace
|tables = items
|base_item_page  = User:Mefisto1029/sandbox
|where = items._pageNamespace = 0 AND metadata_id IS NULL AND rarity_id = "normal"
|explicit1_text                              = Adds 1 to (60-80) Lightning Damage
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|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
==Areas without main_page==
|rarity_id                              = normal
{{Collapse top|Table list|areas_main_page}}
|name                                    = Elegant Greathelm Mefisto
{{#cargo_query:
|class_id                                = Helmet
|tables = areas
|size_x                                  = 2
|where = main_page IS NULL
|size_y                                  = 2
|fields = CONCAT('[[', name, ']]') = Name, areas._pageName = Area
|drop_level                              = 55
|format = table
|drop_rarities_ids                      = normal, magic, rare, unique
|limit = 1000
|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}}
==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==
{{clear}}
{| class = "wikitable plainlist"
<!--
|+ Biggest defense values
==Gem==
|-
{{Item/sandbox
! Type
|rarity_id                               = normal
! Armour
|name                                    = Uncut Skill Gem
! Evasion
|class_id                               = QuestItem
! Energy Shield
|size_x                                  = 1
|-
|size_y                                  = 1
! Body Armour
|drop_level                              = 1
|<!--Armour-->
|tags                                    = default
{{Simple item list
|metadata_id                            =  
|q_tables = armours
|stack_size                              =  
|q_join = items._PageID = armours._PageID
|description                            = Creates a Skill Gem up to level 1
|q_where = items.rarity_id = "normal"
|help_text                              = Right Click to engrave a Skill Gem.
  AND items.drop_enabled = 1
|stack_size_currency_tab                = 5000
  AND items.class_id = "Body Armour"
|release_version                        = 0.1.0
  AND armours.energy_shield_range_maximum = 0
|is_drop_restricted                      = true
  AND armours.evasion_range_maximum = 0
|drop_text                              = Quest reward for [[Reaching Clearfell]].
  AND armours.armour_range_maximum > 0
|quest_reward1_type                      = quest
|q_orderBy = armours.armour_range_maximum DESC
|quest_reward1_quest                    = Reaching Clearfell
|q_limit = 1
|quest_reward1_quest_id                  = a1q1
}}
|quest_reward1_act                      = 1
|<!--Evasion-->
|quest_reward1_npc                      = Renly
{{Simple item list
|quest_reward1_notes                    = Tier 1
|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
}}
}}


|}
{{Item acquisition/sandbox}}-->
Retrieved from "https://www.poe2wiki.net/wiki/Special:ComparePages"