Client Spell ID Limits

[Halon]

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

[Noport]

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]

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.)

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]

Originally Posted by Noport

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.

Originally Posted by Halon

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

Yes, spells were imported into the db

Originally Posted by Kingly_Krab

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]

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

[Halon]

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.

Originally Posted by causticsand

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]

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]

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]

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

Appreciate all the responses.