[X] My Assistant

Exquisite Rapier of the Battlecaster. Mana Conservation.

13.58, over the max of Exquisite.

Legendary Fiery Club of Slaughter

60.40 WD, under leg min (61.76).

Legendary Amber Power Helmet of Slaughter

22.16 ADB, below wiki leg min (23.2).

Legendary Frugal Cotton Pants of the Elementalist
Attack acc: 4,32 Wiki min: 4,33
Mana Conservation: 3,61 Wiki min: 3,66
Physical mitigation: 4,69 Wiki max: 3,7
Magical Mitigation: 4,16 Wiki min: 4,21
Crushing mitigation: 3,35 Wiki max: 2,73
Agility bonus: 4,59 Wiki min: 5,56

Also why no proficiency stat on phases at all? Unless it's the same as regular cottons?

Updated again, please use the script if you are able so that everything will be pushed to the server, I am not maintaining data by hand in order to reduce error.

Friday update completed, look for anything strange

Fixed Leather Burden/Interference Missing

This post has been edited by skillchip: Dec 14 2015, 00:21

Some new ranges on this http://hentaiverse.org/pages/showequip.php...;key=d6805525c6

This post has been edited by cichy133: Dec 17 2015, 00:49

Full update again

Legendary Onyx Cotton Gloves of the Elementalist

Base Elemental proficiency: 6.99 wiki say Lmax:6.89



PS: I used the script but I don't see anything so...
PS2: I will upgrade this equipment

Exquisite Shocking Oak Staff of the Earth-Walker (84,765,138)
http://hentaiverse.org/pages/showequip.php...;key=7569f97397

Now, not sure if I'm reading this right, but... Elec EDB of 9.23. The chart doesn't list Elec Prefix, so I just compared it to the Other Prefix section, which lists a maximum of 9.08. Not sure if you already have that but haven't updated the chart, though. I believe the script should have pushed it, just posting it to make sure.


Superior Charged Cotton Robe of the Elementalist (84,076,836)
http://hentaiverse.org/pages/showequip.php...;key=03bdf7b486

Base evade is 3.29 and base ele proficiency is 8.2; the chart says the max is 3.21 & 7.39, respectively. Again, the script should've pushed it, I'm just making sure you get it.


Exquisite Jade Cotton Gloves of the Curse-Weaver (85,936,373)
http://hentaiverse.org/pages/showequip.php...;key=e25ea5989d

Base evade is 3.14, deprecating proficiency is 6.49, and agi is 3.54; the chart says the max is 2.93, 6.32, and 3.41, respectively. Also should've been pushed, just making sure.

This post has been edited by conundrum: Jan 10 2016, 22:55

Peerless Cobalt Cotton Cap of the Earth-walker


Cold Mit: 26.11 Wiki max: 26.04

Prof: 8.29 Wiki max: 8.27

Legendary Onyx Power Armor of Warding

Piercing Mit = 8.23, Wiki Lmin = 8.26

Base STR = 8.24, Wiki Lmax = 8.08

Legendary Cobalt Phase Pants of Heimdall

Cold Mit: 25.03 Wiki Lmin: 25.04

This post has been edited by cheg0: Jan 19 2016, 13:48

new ranges for longswords of balance: negligible differences in ADB and PABs, relevant in ACC and Crit

Peerless Ethereal Longsword of Balance

Hi, skillchip.

sorry for my bad english.
I am making Equipment Compare script's Wiki base data update code.
I think Wiki Equipment Ranges Staff's EDB part have missing cases.


Staff EDB (None, Low, Mid, High)
ex) Willow have High Dark, Low Elec/Wind

So Staff EDB with/without EDB Prefix and with/without EDB Suffix(except None EDB and Low EDB)

Staff None EDB (this case EDB is 0, except)
Staff None EDB w Prefix
Staff Low EDB
Staff Low EDB w Prefix
Staff Mid EDB
Staff Mid EDB w Prefix
Staff Mid EDB w Suffix
Staff Mid EDB w Prefix w Suffix
Staff High EDB
Staff High EDB w Prefix
Staff High EDB w Suffix
Staff High EDB w Prefix w Suffix


Wiki Equipment Ranges Staff EDB Part need below
Staff None EDB with Prefix
Each Staff Inherent EDB's with/without Prefix/Suffix cases

ex) Willow Staff's Equipment Ranges (Willow can not have EDB Suffix)
Elemental Damage Bonuses
Dark Prefix // Staff High EDB w Prefix
Elec/Wind Prefix // Staff Low EDB w Prefix
Other Prefix // Staff None EDB w Prefix

I think Missing cases are
Dark without Prefix // Staff High EDB
Elec/Wind without Prefix // Staff Low EDB

other Staff's EDB part also have missing cases.

Possible combinations are

Katalox
Staff None EDB w Prefix
Staff Mid EDB
Staff Mid EDB w Prefix
Staff Mid EDB w Suffix
Staff Mid EDB w Prefix w Suffix

Redwood
Staff None EDB w Prefix
Staff Mid EDB
Staff Mid EDB w Prefix
Staff Mid EDB w Suffix
Staff Mid EDB w Prefix w Suffix

Willow
Staff None EDB w Prefix
Staff Low EDB
Staff Low EDB w Prefix
Staff High EDB
Staff High EDB w Prefix

Oak
Staff None EDB w Prefix
Staff Low EDB
Staff Low EDB w Prefix
Staff High EDB
Staff High EDB w Prefix
Staff High EDB w Suffix
Staff High EDB w Prefix w Suffix

and calculate roughly when staff with Prefix add 5~10(Prefix_Mod_Roll), with Suffix add 10~15(Suffix_Mod_Roll)
is it right?

Thank you for your contribution. (IMG:[invalid] style_emoticons/default/smile.gif)


- below list is Weapon Lottery Aug 11, 2015 ~ Feb 01, 2016 Staff Data (created Feb 01, 2016)

- Potency Tier zero

Peerless Fiery Katalox Staff of Heimdall, {Holy=27.39, Dark=11.31, Fire=11.31}, Potency Tier: 0, Link
Peerless Shocking Katalox Staff of Focus, {Holy=11.32, Dark=11.32, Elec=11.32}, Potency Tier: 0, Link
Peerless Shocking Katalox Staff of Heimdall, {Holy=27.39, Dark=11.31, Elec=11.31}, Potency Tier: 0, Link
Peerless Ethereal Katalox Staff of Destruction, {Holy=11.31, Dark=11.31}, Potency Tier: 0, Link
Peerless Arctic Katalox Staff of the Heaven-sent, {Holy=11.31, Dark=11.31, Cold=11.31}, Potency Tier: 0, Link
Peerless Ethereal Katalox Staff of Focus, {Holy=11.32, Dark=11.32}, Potency Tier: 0, Link
Peerless Shocking Katalox Staff of Fenrir, {Holy=11.31, Dark=27.39, Elec=11.31}, Potency Tier: 0, Link
Peerless Shocking Katalox Staff of Focus, {Holy=11.32, Dark=11.32, Elec=11.70}, Potency Tier: 0, Link
Peerless Shocking Katalox Staff of Fenrir, {Holy=11.31, Dark=27.39, Elec=11.31}, Potency Tier: 0, Link
Peerless Fiery Katalox Staff of the Demon-fiend, {Holy=11.31, Dark=11.31, Fire=11.31}, Potency Tier: 0, Link
Peerless Tempestuous Katalox Staff of Fenrir, {Holy=11.31, Dark=27.39, Wind=11.31}, Potency Tier: 0, Link


Peerless Ethereal Redwood Staff of Focus, {Fire=11.33, Cold=11.33, Elec=11.33, Wind=11.33}, Potency Tier: 0, Link
Peerless Tempestuous Redwood Staff of Niflheim, {Fire=11.32, Cold=27.40, Elec=11.32, Wind=21.77}, Potency Tier: 0, Link
Peerless Ethereal Redwood Staff of Destruction, {Fire=11.32, Cold=11.32, Elec=11.32, Wind=11.32}, Potency Tier: 0, Link
Peerless Ethereal Redwood Staff of Destruction, {Fire=11.32, Cold=11.32, Elec=11.32, Wind=11.32}, Potency Tier: 0, Link
Peerless Tempestuous Redwood Staff of Surtr, {Fire=27.40, Cold=11.32, Elec=11.32, Wind=21.77}, Potency Tier: 0, Link
Peerless Arctic Redwood Staff of Freyr, {Fire=11.32, Cold=21.77, Elec=11.32, Wind=27.40}, Potency Tier: 0, Link
Peerless Ethereal Redwood Staff of the Elementalist, {Fire=11.32, Cold=11.32, Elec=11.32, Wind=11.32}, Potency Tier: 0, Link

Peerless Tempestuous Willow Staff of Focus, {Elec=8.11, Wind=18.56, Dark=16.15}, Potency Tier: 0, Link
Peerless Shocking Willow Staff of the Curse-weaver, {Elec=18.56, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Hallowed Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14, Holy=11.32}, Potency Tier: 0, Link
Peerless Shocking Willow Staff of the Curse-weaver, {Elec=18.56, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Arctic Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14, Cold=11.32}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of Destruction, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Arctic Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14, Cold=11.32}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Demonic Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=26.60}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link
Peerless Ethereal Willow Staff of the Curse-weaver, {Elec=8.10, Wind=8.10, Dark=16.14}, Potency Tier: 0, Link

Peerless Demonic Oak Staff of Heimdall, {Fire=8.10, Cold=8.10, Holy=32.22, Dark=11.32}, Potency Tier: 0, Link
Peerless Fiery Oak Staff of the Earth-walker, {Fire=18.56, Cold=8.10, Holy=16.14}, Potency Tier: 0, Link
Peerless Ethereal Oak Staff of the Earth-walker, {Fire=8.10, Cold=8.10, Holy=16.14}, Potency Tier: 0, Link
Peerless Tempestuous Oak Staff of the Earth-walker, {Fire=8.10, Cold=8.10, Holy=16.14, Wind=11.32}, Potency Tier: 0, Link
Peerless Arctic Oak Staff of Heimdall, {Fire=8.10, Cold=18.56, Holy=32.22}, Potency Tier: 0, Link
Peerless Ethereal Oak Staff of Focus, {Fire=8.11, Cold=8.11, Holy=16.15}, Potency Tier: 0, Link
Peerless Tempestuous Oak Staff of Focus, {Fire=8.11, Cold=8.11, Holy=16.15, Wind=11.33}, Potency Tier: 0, Link
Peerless Shocking Oak Staff of Heimdall, {Fire=8.10, Cold=8.10, Holy=32.22, Elec=11.32}, Potency Tier: 0, Link
Peerless Ethereal Oak Staff of Heimdall, {Fire=8.10, Cold=8.10, Holy=32.22}, Potency Tier: 0, Link
Peerless Arctic Oak Staff of the Earth-walker, {Fire=8.10, Cold=18.56, Holy=16.14}, Potency Tier: 0, Link


------------------------------------
Potency Tier greater than zero (useless; may have forge or IW)

Peerless Tempestuous Katalox Staff of the Demon-fiend, {Holy=11.31, Dark=12.16, Wind=11.31}, Potency Tier: 2, Link
Peerless Ethereal Katalox Staff of Focus, {Holy=11.32, Dark=11.32}, Potency Tier: 8, Link
Peerless Hallowed Katalox Staff of Heimdall, {Holy=51.08, Dark=12.16}, Potency Tier: 10, Link
Peerless Shocking Katalox Staff of Fenrir, {Holy=13.39, Dark=36.42, Elec=14.98}, Potency Tier: 9, Link

Peerless Ethereal Redwood Staff of Freyr, {Fire=11.32, Cold=11.32, Elec=11.32, Wind=29.55}, Potency Tier: 4, Link
Peerless Ethereal Redwood Staff of Destruction, {Fire=13.06, Cold=13.06, Elec=13.06, Wind=13.06}, Potency Tier: 10, Link
Peerless Fiery Redwood Staff of Destruction, {Fire=28.65, Cold=11.32, Elec=11.32, Wind=11.32}, Potency Tier: 10, Link
Peerless Tempestuous Redwood Staff of Destruction, {Fire=11.32, Cold=11.32, Elec=11.32, Wind=29.25}, Potency Tier: 9, Link
Peerless Hallowed Redwood Staff of Destruction, {Fire=11.32, Cold=11.32, Elec=11.32, Wind=11.32, Holy=11.32}, Potency Tier: 4, Link
Peerless Ethereal Redwood Staff of Focus, {Fire=11.33, Cold=11.33, Elec=11.33, Wind=11.33}, Potency Tier: 1, Link
Peerless Shocking Redwood Staff of the Elementalist, {Fire=12.16, Cold=12.16, Elec=25.76, Wind=12.16}, Potency Tier: 9, Link

Peerless Tempestuous Willow Staff of Focus, {Elec=8.70, Wind=22.20, Dark=17.77}, Potency Tier: 10, Link
Peerless Fiery Willow Staff of Destruction, {Elec=8.69, Wind=8.69, Dark=17.38, Fire=15.06}, Potency Tier: 10, Link
Peerless Fiery Willow Staff of Focus, {Elec=8.11, Wind=8.11, Dark=16.15, Fire=12.98}, Potency Tier: 10, Link
Peerless Fiery Willow Staff of Focus, {Elec=8.96, Wind=8.11, Dark=16.15, Fire=11.33}, Potency Tier: 1, Link

Peerless Ethereal Oak Staff of the Earth-walker, {Fire=8.10, Cold=8.10, Holy=16.14}, Potency Tier: 2, Link

------------------------------------

- Staff EDB
Katalox: Mid Holy/Dark
Redwood: Mid Fire/Cold/Elec/Wind
Willow: Low Elec/Wind, High Dark
Oak: Low Fire/Cold, High Holy

- EDB Prefix
All

- EDB Prefix with Staff EDB
All

- EDB Suffix
Katalox: Heimdall, Fenrir (Mid: Holy/Dark) - match Mid EDB w Suffix
Redwood: Surtr, Niflheim, Mjolnir, Freyr (Mid: Fire/Cold/Elec/Wind) - match Mid EDB w Suffix
Oak: Heimdall (Low Fire/Cold, High: Holy) - match High EDB w Suffix
Willow: None

- EDB Suffix with EDB
Mid EDB w Suffix
High EDB w Suffix

- Conclusion
Staff None EDB and Low EDB are not associated with EDB Suffix.

Staff None EDB 0 (w Prefix 11.32)
Staff Low EDB 8.10 (w Prefix 18.56)
Staff Mid EDB 11.32 (w Prefix 21.77) (w Suffix 27.40)
Staff High EDB 16.14 (w Prefix 26.60) (w Suffix 32.22)
(observational error +- 0.01)

- Not found cases in Lottery Data
Staff Mid EDB (w Prefix w Suffix)
Staff High EDB (w Prefix w Suffix)

This post has been edited by hansvar92: Feb 15 2016, 03:23

The missing cases are due to the query not being able to filter out prefixes currently, so all the data is raw data from the database instead of calculated and contrasted on my side like the old versions. Staffs, Reinforce-able prefixes (spec mit), savage prefixes (damage), heavy armor & staff burden (mithril),

The missing cases are due to the query not being able to filter out prefixes currently, so all the data is raw data from the database instead of calculated and contrasted on my side like the old versions. Staffs, Reinforce-able prefixes (spec mit), savage prefixes (damage), heavy armor & staff burden (mithril),

Git back ta work!

I'm working on it, I'm getting better at SQL

Full update, as usual be on the lookout for strange things.

Please note I have not yet split out prefix as of yet

This post has been edited by skillchip: Feb 17 2016, 05:00

Scremaz, your changes will not be kept unless the data is pushed to the server. This is both for data validity and for my ease of updating.