EQEmulator Forums - Client Spell ID Limits

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

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

- - Client Spell ID Limits (https://www.eqemulator.org/forums/showthread.php?t=39000)

Halon

11-12-2014 12:33 AM

Client Spell ID Limits

Hi, I have been reading up on clients and spell ids etc. Just for clarification.

Titanium max id is 10kish? - I cant test this yet, I can not find my CDs nuy we are in the middle of a move so no surprise.

SoD - 18kish?

UF max is 28k - I tested it this evening. I have RoF spell file in the client and loaded in the db, I could cast 28000 but 28001 was unknown.

RoF - I am assuming is like 30-40k

On most of the private servers, are there enough non-used spell ids to create a complete lvling scheme for all classes up to level 70+ for Titanium clients?

I am playing around with different ideas and it seems to me that there would be a shortage of available IDs. I have not gone through them all. It just seems a low ceiling to me. But I guess I am greedy like that.

I am working on setting up a server currently with a lvl 85 cap. So far everything is working great but I think we could document some of this on the wiki :-D

Noport

11-12-2014 03:46 AM

did you import the spells to spells_new the database not listing 28000-28001 the list jumps from 27998-30500 the spell listing is 28000 Reprieve 28001 Reprieve Rk. II CToF-TDS 50k

Kingly_Krab

11-12-2014 04:05 AM

Here's a pretty cool query that someone posted and that I modified. It pulls all the empty spell ID ranges. (It takes a while to run.)

Code:

SELECT (a.id + 1) AS `START`, (MIN(b.id) - 1) AS `END`, ((MIN(b.id - 1)) - (a.id + 1)) AS `AMOUNT` FROM spells_new AS a, spells_new AS b        

WHERE (a.id < b.id) GROUP BY a.id HAVING (`START` < MIN(b.id))

ORDER BY `AMOUNT` DESC;

Halon

11-12-2014 09:55 AM

Quote:

Originally Posted by Noport (Post 235458)

did you import the spells to spells_new the database not listing 28000-28001 the list jumps from 27998-30500 the spell listing is 28000 Reprieve 28001 Reprieve Rk. II CToF-TDS 50k

I could list all the spells in the UF client, but could only #cast to 28000 and lower and get the buff icon etc.

but 28001+ I would just get the Unknown Spell buff icon, I would see the correct words in chat. And I checked both the RoF and Live spell_us.txt.

Quote:

Originally Posted by Halon (Post 235454)

I have RoF spell file in the client and loaded in the db

Yes, spells were imported into the db :oops:

Quote:

Originally Posted by Kingly_Krab (Post 235459)

Here's a pretty cool query that someone posted and that I modified. It pulls all the empty spell ID ranges. (It takes a while to run.)

Thanks Kingly_Krab! I saw that in another post, I have not run it yet but will take a look today.

Noport

11-12-2014 08:43 PM

read this post: Halon
http://www.eqemulator.org/forums/showthread.php?t=38789

Halon

11-13-2014 09:56 AM

Thanks Noport, not having those type of issues. Spells work fine. I just wanted to find out the approximate limit per client version so I can build my world around it without surprises.

And that post could be helpful, though --force could fix or break a lot of things if the db has been updated and the sql(scripts) portion has not. ;)

Quote:

Originally Posted by causticsand (Post 234711)

For any future readers, the required sql's are in ../eqemu/utils/sql/git/required
I sourced them in with these commands:
$ mysql -u eq -p --force eq < 2014*.sql
$ mysql -u eq -p --force eq < 2013*.sql

I have been tossing around the idea of limiting my server to something like UF client+ to have a more expanded spell range to work with. I played with RoF client as well, seems to work, but my is a hybrid of current Steam unPatched install with older binaries since my original RoF was lost to hd crash.

ghanja

11-13-2014 02:37 PM

Titanium spell limit is up to 9999 (spell ID). SoD, I believe is 23500(ish), albeit, it's been awhile now. Beyond SoD, I cannot recall.

demonstar55

11-14-2014 02:38 PM

Ones I was able to confirm:

Tit: 9999 (I think? My tit idb isn't as well labeled)
SoF: 15999
SoD: 23000
UF: 28000
RoF: 45000

Halon

11-14-2014 08:24 PM

Thanks all, thats what I got on UF I guess it is where I will "standardize" for now.

Appreciate all the responses.

All times are GMT -4. The time now is 01:55 PM.