[X] My Assistant

Legendary Savage Power Helmet of Balance
Attack Crit Chance 5.59%
Wiki 5.58%

This post has been edited by Maharid: Oct 15 2017, 05:52

Updated, look for strangeness

Legendary Amber Power Gauntlets of Slaughter

New Lmin for ADB: 19,77

Wiki: 20,02

Peerless Cobalt Power Gauntlets of Balance

ADB 16.34 (Wiki 16.33)

AAB 19.02% (Wiki 18.42%)

Attack Crit Chance 5.14% (Wiki 5.02%)

Magical Mitigation 5.66 (Wiki 5.65)

Great piece with good increases, expecially Hit Bonus (~+3,25%) and Crit Bonus (~+2,4%). (IMG:[invalid] style_emoticons/default/smile.gif)

Original owner Ckyc (got from a Xmas Unique Trophy).

Fair Leather Leggings

Resist chance = 5.38 (Wiki max 5.22)

Sometimes humble tools may surprise you (IMG:[invalid] style_emoticons/default/smile.gif)

[attachembed=112750]

Fair Leather Leggings

Resist chance = 5.38 (Wiki max 5.22)

Sometimes humble tools may surprise you (IMG:[invalid] style_emoticons/default/smile.gif)

Your information is incorrect. It is not the number you see that is important, but rather the base value (fixed value). In this case, the base value is 4.9 (pass the mouse pointer over the attribute and you will see a small box with a number - this is the base value).

Your information is incorrect. It is not the number you see that is important, but rather the base value (fixed value). In this case, the base value is 4.9 (pass the mouse pointer over the attribute and you will see a small box with a number - this is the base value).

Ooops, you're right; sorry, my bad (IMG:[invalid] style_emoticons/default/sad.gif)

Someone asked me why my database's numbers are different from those on the wiki for Leg Rapier Slaughter ADB. I'm using the following:

CODE

        SELECT eqs.`key`,MIN( CAST( eqs.value AS DECIMAL(9,2) ) ), MAX( CAST( eqs.value AS DECIMAL(9,2) ) )
        FROM
          hentaiverse_equipment AS eq
          INNER JOIN hentaiverse_equipment_meta AS eqs ON eq.`id` = eqs.`equipmentID`
        WHERE
          (eqs.`key` = 'weaponDamage' OR eqs.`key` = 'Attack Damage')
          AND eq.eid > 71001000
          AND eq.type = 'Rapier'
          AND eq.suffix = 'Slaughter'
          AND (eq.quality = 'Legendary' OR eq.quality = 'Peerless')

Which spits out 44.26 - 51.33, but Wiki Lmin is 42.8. Did I mess up?

https://ehwiki.org/wiki/Equipment_Ranges#Rapier
[reasoningtheory.net] https://reasoningtheory.net/viewranges

Which spits out 44.26 - 51.33, but Wiki Lmin is 42.8. Did I mess up?

https://ehwiki.org/wiki/Equipment_Ranges#Rapier
[reasoningtheory.net] https://reasoningtheory.net/viewranges

are we sure about that 42.8? it has always seemed a bit too low to me...

Someone asked me why my database's numbers are different from those on the wiki for Leg Rapier Slaughter ADB. I'm using the following:

CODE

        SELECT eqs.`key`,MIN( CAST( eqs.value AS DECIMAL(9,2) ) ), MAX( CAST( eqs.value AS DECIMAL(9,2) ) )
        FROM
          hentaiverse_equipment AS eq
          INNER JOIN hentaiverse_equipment_meta AS eqs ON eq.`id` = eqs.`equipmentID`
        WHERE
          (eqs.`key` = 'weaponDamage' OR eqs.`key` = 'Attack Damage')
          AND eq.eid > 71001000
          AND eq.type = 'Rapier'
          AND eq.suffix = 'Slaughter'
          AND (eq.quality = 'Legendary' OR eq.quality = 'Peerless')

Which spits out 44.26 - 51.33, but Wiki Lmin is 42.8. Did I mess up?

https://ehwiki.org/wiki/Equipment_Ranges#Rapier
[reasoningtheory.net] https://reasoningtheory.net/viewranges

The SQL looks correct. Could be the eq.eid > 71001000, does the wiki use that too? If not, that could cause the lower Lmin

Ah, you're probably right. I thought I was being permissive enough with >71m because "Please only post equipment with ID's over 72,000,000" but when I decrease the minimum EID to 68m (from 69m), it gives me a min of 42.80. Given that no other rapiers have ADB near that low, it seems like reasonable evidence for the possibility that the queries used to generate the wiki information might occasionally be looking at EIDs still from 0.81.

ah, yes. afaik the break point should be somewhere around 67M (and chipp could be using this one as well), but admin never confirmed this. it's more a calculation of ours. should also be the same EID used on SmartSearch.

also, i remember there were some derped ranges here and there, so he manipulated them a bit later. going with a slightly higher minimum EID may be a solution, yep.


[edit]: or even to deliberately remove lower-range items with only one occurrence

This post has been edited by Scremaz: Jan 4 2018, 13:15

link in 1st post 404s
Has there been any updates to the script or should I just continue to use the one included in hvtoolbox?

It was basically just this:

CODE

const rangesToSend = [];
rangesToSend.push({ 'eid' : item.eid, 'key' : item.key });

//repeat for all items you want to send: loop over all items in inventory?
        
function sendRanges(){
  if (rangesToSend.length === 0)
    return;
  const exists = new XMLHttpRequest();
  const data = new FormData();
  data.append('action', 'store');
  data.append('equipment', JSON.stringify(rangesToSend));
  exists.open("POST","https://hvitems.niblseed.com/",false);
  exists.send( data );
}

It was basically just this:

included in OP post.

ah okay, toolbox has the same part of code

Cutoff used in queries is 67250000

SELECT eqs.`key`,MIN( CAST( eqs.value AS DECIMAL(9,2) ) ), MAX( CAST( eqs.value AS DECIMAL(9,2) ) )
FROM
hentaiverse_equipment AS eq
INNER JOIN hentaiverse_equipment_meta AS eqs ON eq.`id` = eqs.`equipmentID`
WHERE
(eqs.`key` = 'weaponDamage' OR eqs.`key` = 'Attack Damage')
AND eq.eid > 67250000
AND eq.type = 'Rapier'
AND eq.suffix = 'Slaughter'
AND (eq.quality = 'Legendary' OR eq.quality = 'Peerless')

Results
field min max

Also, I don't like the fact my opening post was edited! It's like editing my wiki pages. !!! (IMG:[invalid] style_emoticons/default/smile.gif)
weaponDamage 42.80 51.33

Cutoff point was arbitrarily chosen after the update.

Switching to 68250000 min increases to 44.20

This post has been edited by skillchip: Jan 9 2018, 00:56

lmin/pmax of edb (phase) and prof (cotton) is approximately 89%.

Lmin of edb

Phase Cap Robe Gloves Pants Shoes
P 16.97 20.18 15.36 18.58 13.75
Lmin 15.12 18.02 13.68 16.56 12.22
Lmin/P(%) 89.098 89.296 89.063 89.128 88.873

Lmin of proficiency

Cotton Cap Robe Gloves Pants Shoes
P 8.29 9.89 7.5 9.09 6.7
Lmin 7.38 8.81 6.68 8.07 5.97
Lmin/P(%) 89.023 89.080 89.067 88.779 89.104

I checked adb of power slaughters and found that the approximate value is 85%.

But, due to HV 0.83's bug, they had wrong values for a while and that wrong lmin still remains in the wiki.

CODE

            |  pmax  ||  lmin_wiki        || lmin_bugged       ||  lmin_fixed      
====================================================================================
Helme       |  25.73 ||  19.87 |  77.22 % ||  19.87 |  77.22 % ||  21.88 |  85.03 %
Armor       |  30.68 ||  25.4  |  82.79 % ||        |          ||  26.00 |  84.74 %
Gauntlets   |  23.25 ||  20.02 |  86.10 % ||  17.80 |  76.55 % ||  19.76 |  84.98 %
Leggings    |  28.20 ||  23.94 |  84.89 % ||        |          ||  23.95 |  84.92 %
Boots       |  20.77 ||  17.3  |  83.29 % ||  16.19 |  77.94 % ||  17.73 |  85.36 %

19.87 Legendary Amber Power Helmet of Slaughter
17.80 Legendary Jade Power Gauntlets of Slaughter
16.19 Legendary Jade Power Boots of Slaughter


21.88 Legendary Savage Power Helmet of Slaughter
26.00 Legendary Amber Power Armor of Slaughter
19.76 Legendary Zircon Power Gauntlets of Slaughter
23.95 Legendary Zircon Power Leggings of Slaughter
17.73 Legendary Zircon Power Boots of Slaughter

Probably easy to get a cutoff ID "fast" by getting min values above each equipment ID in sql and seeing where the jump is in a specific type of equipment. Problem of doing that before was that not all values might be seen, shouldnt be an issue now as long as ranges havent changed since the last change.

https://hentaiverse.org/equip/98810256/c067ca8189
Exquisite Wakizashi of slaughter : maxi in equipment range : 38.14, I have 39.44 here