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
 
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.
==Mods==
<onlyinclude>Cannot be used with Trials below level 80</onlyinclude>


==Subpages==
{{modifier table
* [[User:Mefisto1029/sandbox|Sandbox]]
|q_tables=mod_stats
* [[Module:Sandbox/Mefisto1029/main|Module sandbox]]
|q_join=mods._pageID=mod_stats._pageID
* [[Module:Sandbox/Mefisto1029/main/s1|Module sandbox (config)]]
|q_where = mods.domain = 8 AND mods.generation_type = 3
* [[Module:Sandbox/Mefisto1029/main/s2|Module sandbox (data)]]
  AND mods.stat_text_raw = "{{User:Mefisto1029/sandbox}}"
* [[Module:Sandbox/Mefisto1029/main/s3|Module sandbox (extra)]]
|generation_type=1
 
|level=1
==0.3.0 checklist==
|stat_text=1
* {{il|Ancestral Warrior Totem}} - Now have no Limit. Check interaction with [[Ancestral Bond]].
 
==Items only in EA standard league==
{{Collapse top|Table list|EAItems}}
* {{il|Lasting Ground}}
* {{il|Magnetic Remnants}}
* {{il|Rusted Spikes}}
* {{il|Life Bounty}}
* {{il|Mana Bounty}}
* {{il|Malady}}
* {{il|Murderous Intent}}
* {{il|Auto Reload}}
* {{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==
{{Collapse top|Table list|flavuor}}
{{Drop enabled unique item table
{{Drop enabled unique item table
|flavour_text = 1
|where=items.stat_text LIKE "%{{User:Mefisto1029/sandbox}}%"
|where = items.class_id NOT LIKE "Relic" AND (flavour_text IS NULL OR flavour_text LIKE "Coming Soon" )
|large=1|level=1|stat=1|release_version=1|orderBy=items.release_version}}
}}
{{Collapse bottom}}
 
==Items without metadata_id==
{{Collapse top|Table list|metadata_id}}
{{#cargo_query:
|tables = items
|where = items._pageNamespace = 0 AND metadata_id IS NULL AND rarity_id = "normal"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
}}
{{Collapse bottom}}
 
==Areas without main_page==
{{Collapse top|Table list|areas_main_page}}
{{#cargo_query:
|tables = areas
|where = main_page IS NULL
|fields = CONCAT('[[', name, ']]') = Name, areas._pageName = Area
|format = table
|limit = 1000
}}
{{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==
{{Drop disabled unique item table
{| class = "wikitable plainlist"
|where=items.stat_text LIKE "%{{User:Mefisto1029/sandbox}}%"
|+ Biggest defense values
|large=1|level=1|stat=1|release_version=1|orderBy=items.release_version}}
|-
! 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
}}


|-
{{ml|BeltImplicitCharmSlots3}}
! 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
}}


|-
== Item test ==
! Gloves
{{Item/sandbox
|<!--Armour-->
|rarity_id                              = normal
{{Simple item list
|name                                    = Smithing Hammer Mefisto
|q_tables = armours
|class_id                               = One Hand Mace
|q_join = items._PageID = armours._PageID
|size_x                                  = 2
|q_where = items.rarity_id = "normal"
|size_y                                  = 3
  AND items.drop_enabled = 1
|drop_level                              = 4
  AND items.class_id = "Gloves"
|drop_rarities_ids                      = normal, magic, rare, unique
  AND armours.energy_shield_range_maximum = 0
|tags                                    = ezomyte_basetype, mace, one_hand_weapon, onehand, weapon, default
  AND armours.evasion_range_maximum = 0
|metadata_id                            =  
  AND armours.armour_range_maximum > 0
|implicit1 = TowerMagicPackIncrease1
|q_orderBy = armours.armour_range_maximum DESC
|implicit2 = TowerAdditionalEssence1
|q_limit = 1
|required_level                          = 4
}}
|required_strength                      = 11
|<!--Evasion-->
|physical_damage_min                    = 9
{{Simple item list
|physical_damage_max                    = 15
|q_tables = armours
|critical_strike_chance                  = 5
|q_join = items._PageID = armours._PageID
|attack_speed                            = 1.45
|q_where = items.rarity_id = "normal"
|weapon_range                            = 1.1
  AND items.drop_enabled = 1
|debug=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
}}
}}


|-
{{Item/sandbox
! Boots
|rarity_id                              = unique
|<!--Armour-->
|name                                    = Smithing Hammer Mefisto unique
{{Simple item list
|base_item_page = User:Mefisto1029/sandbox
|q_tables = armours
|class_id                               = One Hand Mace
|q_join = items._PageID = armours._PageID
|size_x                                  = 2
|q_where = items.rarity_id = "normal"
|size_y                                  = 3
  AND items.drop_enabled = 1
|drop_level                              = 4
  AND items.class_id = "Boots"
|debug=1
  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-->
{{clear}}
{{Simple item list
<!--{{Item acquisition/sandbox}}-->
|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
}}
 
|}
Retrieved from "https://www.poe2wiki.net/wiki/Special:ComparePages"