Spell ID Limit for UF?

[Township EQ]

From googling around I can't seem to find an answer.. What is the spell ID limit for underfoot? I know titanium is 9999.

from the stock spells_us i have almost 30,000 spells.. I want to know how much room I have to make custom ones.

[Kingly_Krab]

It is a known problem, use the forum search: http://www.eqemulator.org/forums/showthread.php?t=37304

https://github.com/EQEmu/Server/issues/7

Here's the fix mentioned in that thread, I cannot confirm it working: http://bpaste.net/show/133455/

[Township EQ]

Originally Posted by Kingly_Krab

It is a known problem, use the forum search: http://www.eqemulator.org/forums/showthread.php?t=37304

https://github.com/EQEmu/Server/issues/7

Here's the fix mentioned in that thread, I cannot confirm it working: http://bpaste.net/show/133455/

What's a known problem? I was just asking what the cap is for UF :S

[Kingly_Krab]

The problem is not knowing the cap, haha.

[demonstar55]

There are problems with that patch, it "works" though but poorly :P

[lerxst2112]

The highest ID in the spell file I have in my untouched Underfoot backup is 27999.

[Kayen]

27999 sounds about right from what I recall.

Big tip if you want to add custom spells.

There are hundreds of unused spell IDs in the database and tons of just junk tests spells.

Run this and it will tell you all the unused spell id ranges.

SELECT a.id+1 AS start, MIN(b.id) - 1 AS end
    FROM spells_new AS a, spells_new AS b
    WHERE a.id < b.id
    GROUP BY a.id
    HAVING start < MIN(b.id);

Kayen

[demonstar55]

IDs higher than 32,767 are will not work correctly, it's a bitch to fix this, which is why it hasn't yet :P

[Township EQ]

That query is pretty useful Kayen.. I'll save that. I was just looking to see how much wiggle room I had. I deleted like 8,000 or so spells off the top of the list so I'm at like 22000 now.

Thanks a lot guys.