Spells: Differences in Spell Cast time and Mana Cost

[enr4ged]

Originally Posted by Sundawg [You must be logged in to view images. Log in or Register.]

Can you list the damage differences too? For example, Wildfire.

Check the v2 spreadsheet for a new tab with a value that is the damage value of nuke and instant damage spells.

https://docs.google.com/spreadsheet/...PaVBtRUE#gid=1

I had to add the program to look at value as well, but I didn't have much time to clean it up it looks like the particular bytes storing this value is sometimes damage but for other spells it's showing something different. But it looks accurate for all of the nuke direct damage spell types.

I can upload the source for my program if you're interested in looking how I'm getting the values from the file, or I can just upload the program as well.

[Alecta]

Originally Posted by enr4ged [You must be logged in to view images. Log in or Register.]

the particular bytes storing this value is sometimes damage but for other spells it's showing something different.

Yeup, there are a number of 'slots' each of which have an effect type and associated value. See SE_* in SPDAT.h

[enr4ged]

Updated the spreadsheet to exclude values where the value was 0 (in the eqtrilogy spdat) to get rid of the unnecessary effects.

Some interesting spell differences include:
Reckoning +135 on p1999
Wildfire +120 on p1999
Shock of Steel +75 on p1999
Druid root line damage all higher on p1999
druid 60 heal nature's touch +513 on p1999 (hope that one doesn't go live like that)
some wizard nukes and aoe's are too low on p1999

legacy of spike showing as 20 damage shield compared to 24 on p1999
a quick search on lucy history shows it was changed from 20 to 24
2004-06-16 10:05 Changed Slot 1 from "Increase Damage Shield by 20" to "Increase Damage Shield by 24"


Where was the original Spell data pulled from???

I could expand this to check things like buff/debuff values if I can figure it out but it would be a lot more work and I don't want to do it if this isn't going to be used to fix any data.

[Nirgon]

Pillar cast times on red should all be 4.5, not the case atm

[Senn]

Did anything end up happening with these spell bugs?

[Dolalin]

I have a whole sheet with every spdat I've ever found from original release CD up to mid-velious with almost every monthly patch starting from Kunark release.

https://github.com/dbsanfte/eq-archi....xlsx?raw=true

It probably needs a script to be written to parse it out into something that could be reconciled against the p99 db.

So the data is there it just needs some (not insignificant) dev time.

[enr4ged]

This is the wrong file there should be another in the same directory called "spdat.eff" or similar. It should have an .eff extension but be larger than the spells.eff file.

This may be why you couldn't find one on the other cds?

Thanks.

[enr4ged]

Originally Posted by Bamzal Sherbet [You must be logged in to view images. Log in or Register.]

sorry, try this

direct link

alternate

What era was this file from?
It looks like it has a different format (although still in hex like the trilogy one) that will require me to do some additional work in figuring out the fields.

edit: Looks like it's a classic file (no 51+ spells) so not really that useful at this point. One of the kunark cd, or even velious cd would be most useful.

Thanks though, good for my stash.

[enr4ged]

Hmm yeah. I see what you mean, looks like the trilogy spdat may be the closest thing to Velious spell data that we can get.