1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
Wynncraft, the Minecraft MMORPG. Play it now on your Minecraft client at (IP): play.wynncraft.com. No mods required! Click here for more info...

Community Event Help Us Solve How Spell Cost Functions!

Discussion in 'Wynncraft' started by Xavi, Dec 16, 2019.

Thread Status:
Not open for further replies.
  1. Xavi

    Xavi ♪ Wynncraft's Composer ♫ ♪ Music Item Team HERO

    Messages:
    6,528
    Likes Received:
    20,992
    Trophy Points:
    217
    Minecraft:
    Alright gamers!

    In the new update there were new ids added that change the cost of spells. There's both a % and raw version of these ids, and until now, we had no idea how the calculation involving them worked.

    After HOURS of testing, we think we have a functioning formula that catches all awkward edge cases, but we aren't 100% sure and we need your help!

    Here's our idea.

    1. Start with how much the spell costs normally.
    2. Apply the intelligence modifier.
    3. Add raw spell cost.
    4. Round the value to the nearest whole number.
    5. Multiply by the spell cost %.
    6. Truncate the value to the nearest whole number.

    This SHOULD be the new cost of the spell on the first cast.
    Through our testing this appears to be correct, but there could definitely be cases that we missed that break this. This is where you guys come in! See if you can find any strange interactions with spell costs ingame that don't follow this formula, and let us know so we can try and solve this mystery!

    Repeat casting works with both raw and % spell cost as expected, the unknown for us is how the first cost is calculated.

    Thanks for reading!
    -The Item Team

    @Major_Lue @jptheflip
     
  2. jptheflip

    jptheflip Well-Known Adventurer HERO

    Messages:
    87
    Likes Received:
    584
    Trophy Points:
    55
    Minecraft:
  3. Major_Lue

    Major_Lue Famous Adventurer HERO

    Messages:
    1,995
    Likes Received:
    2,116
    Trophy Points:
    130
    Minecraft:
    @dukioooo You can put this on Wynndata. Adding this functionality to WD might help people figure out edge cases that might break this formula. As far as anyone's concerned, this is the right formula.
     
  4. by2011

    by2011 category creator VIP+

    Messages:
    1,994
    Likes Received:
    2,198
    Trophy Points:
    130
    Guild:
    Minecraft:
    cannot believe i am being ignored here
     
    hppeng, A Human, Iboju and 8 others like this.
  5. jptheflip

    jptheflip Well-Known Adventurer HERO

    Messages:
    87
    Likes Received:
    584
    Trophy Points:
    55
    Minecraft:
    @by2011 ur mom

    (pls test this)
     
  6. dukioooo

    dukioooo Creator of WynnData HERO

    Messages:
    3,345
    Likes Received:
    2,502
    Trophy Points:
    136
    Guild:
    Minecraft:
    I'll add this in 11h
     
  7. SnapDoomy

    SnapDoomy Well-Known Adventurer HERO

    Messages:
    351
    Likes Received:
    451
    Trophy Points:
    67
    Minecraft:
    ohh whhaaaaa jpppp flipflip
     
    jptheflip likes this.
  8. dukioooo

    dukioooo Creator of WynnData HERO

    Messages:
    3,345
    Likes Received:
    2,502
    Trophy Points:
    136
    Guild:
    Minecraft:
    Just to make sure

    ROUNDDOWN( ROUND((baseSpellCost * intelPercent / 100) + spellCostRaw) * spellCostPercent / 100)

    right?


    So if base spell is 10, Intel 150 (=80.8%), spellCostRaw +1, spellCost% 0:

    Rounddown( round( (10 * 80.8 / 100) + 1) * 0 / 100)

    Guess spellCostPercent should be (100+spellCost%)? Or 1+(spellCost%/100)
     
    Last edited: Dec 17, 2019
  9. Druser

    Druser ele defs don't matter HERO

    Messages:
    5,138
    Likes Received:
    7,675
    Trophy Points:
    199
    Guild:
    Minecraft:
    Haha, Arrow Shield 8 mana explains why you had 3 mana shields with Spring dukio...

    I think that was one of my later formulas, which I abandoned because it didn't work with Arrow Shield lol. However, I recommend looking at situations where the sum of percent spell cost and intelligence modifier is positive (i.e. detrimental). I encountered a case with a weapon that had +25% Totem cost - at 0 Int I had 5 mana totems, which continued up until 29 Int. The moment I reached 29 Int, I got 3 mana totems.
     
  10. Druser

    Druser ele defs don't matter HERO

    Messages:
    5,138
    Likes Received:
    7,675
    Trophy Points:
    199
    Guild:
    Minecraft:
    Also, I'm pretty sure that first rounding is a rounding upward?
     
  11. MrH

    MrH Well-Known Adventurer VIP

    Messages:
    323
    Likes Received:
    141
    Trophy Points:
    72
    Minecraft:
    Is there a max -% spell cost? If not, how does getting over -100% spell cost work? Does it make that spell become 0 mana no matter how many times you cast it? For example: https://wynndata.tk/s/y6e052 does that mean you can spam cast aura infinite times and have aura still cast 0 mana? or does it use first spell cast as the base for the %?
     
  12. dukioooo

    dukioooo Creator of WynnData HERO

    Messages:
    3,345
    Likes Received:
    2,502
    Trophy Points:
    136
    Guild:
    Minecraft:
    /shrug

    Pretty sure minimum for a spell is 1 mana, no matter what.
     
  13. MrH

    MrH Well-Known Adventurer VIP

    Messages:
    323
    Likes Received:
    141
    Trophy Points:
    72
    Minecraft:
    So then would aura have 1 mana forever?
     
  14. dukioooo

    dukioooo Creator of WynnData HERO

    Messages:
    3,345
    Likes Received:
    2,502
    Trophy Points:
    136
    Guild:
    Minecraft:
    continous spell cast add a cost, so it won't be 1 forever
     
  15. Muchwag

    Muchwag Don’t call me Poliwhirl! VIP+

    Messages:
    856
    Likes Received:
    1,039
    Trophy Points:
    125
    Guild:
    Minecraft:
    mfw the IMs make the damage formula so complicated even they don't know how it works
     
  16. Saya

    Saya yeah don't mislead newbies thanks VIP+

    Messages:
    1,720
    Likes Received:
    2,538
    Trophy Points:
    162
    Guild:
    Minecraft:
    omg jp never tags me :(
     
    jptheflip and Xavi like this.
  17. jptheflip

    jptheflip Well-Known Adventurer HERO

    Messages:
    87
    Likes Received:
    584
    Trophy Points:
    55
    Minecraft:
    Saya likes this.
Thread Status:
Not open for further replies.