EQEmulator Forums - Spell ID Limit for UF?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Spell Support (https://www.eqemulator.org/forums/forumdisplay.php?f=664)

- - Spell ID Limit for UF? (https://www.eqemulator.org/forums/showthread.php?t=37617)

Township EQ

12-13-2013 09:22 PM

Spell ID Limit for UF?

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

12-13-2013 09:35 PM

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

12-13-2013 11:42 PM

Quote:

Originally Posted by Kingly_Krab (Post 226804)

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

Kingly_Krab

12-14-2013 12:05 AM

The problem is not knowing the cap, haha.

demonstar55

12-14-2013 12:41 AM

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

lerxst2112

12-14-2013 12:50 AM

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

Kayen

12-14-2013 02:39 AM

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.

Code:

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

12-14-2013 03:30 AM

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

12-14-2013 03:38 AM

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.

All times are GMT -4. The time now is 06:32 AM.