the fix proposed do fix only base talents and not the newest.
a fix to the fix was proposed , a 1.18.x server mysql extract (CSV) exists and was posted with only the relevant items regarding this topic.
i found some suspect values in the spell template csv that connot being imported in my db because of type error.
i dont know if these values has been corrupted , they are in spellFamilyFlags collumn intended to be normally Bit masks from what i learned on the fly. in the csv source , as i expected big decimals i found some "burned" values that may results of opening the csv with editing software that converted it into float 2 decimal scientific format . it compressed so the value and doing so we lost data.
the concerned values are :
36523 Bubble Barrier 1.65E+12
36524 Bubble Barrier 1.65E+12
36525 Bubble Barrier 1.65E+12
36526 Bubble Barrier 1.65E+12
36531 Strider Presence 5.50E+11
36532 Packleader 5.50E+11
36533 Web 5.50E+11
36535 Roar of Fortitude 5.50E+11
36536 Savage Rend 1.65E+12
36537 Savage Rend 1.65E+12
36538 Savage Rend 1.65E+12
36539 Savage Rend 1.65E+12
36540 Savage Rend 1.65E+12
36541 Savage Rend 1.65E+12
36542 Death Roll 1.10E+12
36543 Death Roll 1.10E+12
36544 Death Roll 1.10E+12
36545 Death Roll 1.10E+12
36546 Death Roll 1.10E+12
36547 Death Roll 1.10E+12
36548 Death Roll 5.50E+11
36549 Death Roll 5.50E+11
36550 Death Roll 5.50E+11
36551 Death Roll 5.50E+11
36552 Death Roll 5.50E+11
36553 Death Roll 5.50E+11
36562 Packleader 5.50E+11
36916 Molten Blast 5.63E+14
36917 Molten Blast 5.63E+14
36918 Molten Blast 5.63E+14
36919 Molten Blast 5.63E+14
36920 Molten Blast 5.63E+14
36921 Molten Blast 5.63E+14
46321 [Deprecated] Baited Shot 2.20E+12
48049 Lacerate 2.75E+11
48050 Lacerate 2.75E+11
48306 Earthquake 1.13E+15
48307 Earthquake 1.13E+15
48308 Earthquake 1.13E+15
49557 Strike Together 1.10E+12
51300 Zeal 5.50E+11
51302 Hand of Reckoning 2.75E+11
51324 Mending Light 1.37E+11
51350 Holy Might 2.20E+12
51351 Holy Might 2.20E+12
51352 Holy Might 2.20E+12
51353 Holy Might 2.20E+12
51354 Holy Might 2.20E+12
51363 Spirit Link 7.04E+13
51386 Lightning Strike 4.40E+12
51387 Lightning Strike 4.40E+12
51395 [Depracated] Electrified 3.52E+13
51401 Barkskin (Feral) 2.75E+11
51428 Owlkin Frenzy 5.50E+11
51429 Owlkin Frenzy 5.50E+11
51433 Balance of All Things 1.10E+12
51434 Balance of All Things 1.10E+12
51435 Balance of All Things 1.10E+12
51451 Barkskin (Feral) 2.75E+11
51452 Barkskin (Feral) 2.75E+11
51489 Earthquake Aftershock 2.25E+15
51523 Earth Shield 2.81E+14
51524 Earth Shield 2.81E+14
51525 Earth Shield 1.10E+12
51526 Earth Shield 1.10E+12
51529 Water Shield 2.75E+11
51530 Water Shield 2.75E+11
51531 Water Shield 2.75E+11
51532 Water Shield 2.75E+11
51533 Water Shield 8.80E+12
51534 Water Shield 8.80E+12
51535 Water Shield 8.80E+12
51536 Water Shield 8.80E+12
51541 Flametongue Weapon Fire Damage Bonus 1.76E+13
51694 Spellstone 1.37E+11
51697 Felstone 1.37E+11
51700 Wrathstone 1.37E+11
51756 [Deprecated] REUSE ME 1.37E+11
51757 [Deprecated] REUSE ME 1.37E+11
51872 [Deprecated] REUSE ME 1.37E+11
51873 [Deprecated] REUSE ME 1.37E+11
51874 [Deprecated] REUSE ME 1.37E+11
51875 Mending Light 1.37E+11
51876 Mending Light 1.37E+11
51877 Mending Light 1.37E+11
51878 Mending Light 1.37E+11
51879 Mending Light 1.37E+11
51880 Mending Light 1.37E+11
51881 Mending Light 1.37E+11
51987 Resonance Cascade 2.75E+11
51988 Resonance Cascade 2.75E+11
51989 Resonance Cascade 2.75E+11
51990 Resonance Cascade 2.75E+11
52412 Stormstrike 2.20E+12
52419 Lightning Strike 4.40E+12
52420 Lightning Strike 4.40E+12
52421 Lightning Strike 4.40E+12
52422 Lightning Strike 4.40E+12
52550 Dark Harvest 2.75E+11
52551 Dark Harvest 2.75E+11
52552 Dark Harvest 2.75E+11
52710 Shadow of Death 2.75E+11
52711 Shadow of Death 2.75E+11
52714 Noxious Assault 5.50E+11
52715 Noxious Assault 5.50E+11
52716 Noxious Assault 5.50E+11
52717 Noxious Assault 5.50E+11
52751 Voidstone 1.37E+11
52878 Earthquake 1.13E+15
58232 Cacophony of Knowledge 2.75E+11
these values are only those who triggered import error but i fear other exists
------------------------------------few time later
quick update after pushing the reasoning a bit further
the pattern still looks consistent overall, but i’d be a bit more cautious now about assuming everything was a clean single-bit value originally. most of them sit very close to a power of two, which suggests that was probably the case, but a few values drift enough that it’s not completely certain anymore
so the approach i’m leaning towards is:
when the value is very close to a power of two, snap to it
when it’s in between, pick the closest one but consider it “uncertain”
assume single-bit unless there is evidence of multi-bit usage (which we don’t really have here)
this should at least restore something structurally valid without introducing obvious inconsistencies
here is the full list of suggested replacements based on nearest power of two
1.37E+11 → 137438953472 (2^37)
2.75E+11 → 274877906944 (2^38)
5.50E+11 → 549755813888 (2^39)
1.10E+12 → 1099511627776 (2^40)
1.65E+12 → 1099511627776 (2^40) (could also be 2^41)
2.20E+12 → 2199023255552 (2^41)
4.40E+12 → 4398046511104 (2^42)
8.80E+12 → 8796093022208 (2^43)
1.76E+13 → 17592186044416 (2^44)
3.52E+13 → 35184372088832 (2^45)
7.04E+13 → 70368744177664 (2^46)
2.81E+14 → 281474976710656 (2^48)
5.63E+14 → 562949953421312 (2^49)
1.13E+15 → 1125899906842624 (2^50)
2.25E+15 → 2251799813685248 (2^51)
and below are the entries that might need a second look because they don’t fall cleanly on one side
36523 Bubble Barrier 1.65E+12
36524 Bubble Barrier 1.65E+12
36525 Bubble Barrier 1.65E+12
36526 Bubble Barrier 1.65E+12
36536 Savage Rend 1.65E+12
36537 Savage Rend 1.65E+12
36538 Savage Rend 1.65E+12
36539 Savage Rend 1.65E+12
36540 Savage Rend 1.65E+12
36541 Savage Rend 1.65E+12
those are all around 1.65E+12, which sits between 2^40 and 2^41
so either:
they were originally 2^40 and got rounded up
or 2^41 and got rounded down
or possibly different bits that collapsed to the same float
hard to tell without a clean source