View Single Post
  #6  
Old 07-10-2014, 06:44 PM
Einon
Fire Beetle
 
Join Date: May 2010
Posts: 17
Default

Ok, so the problem is that only so many spell-IDs are available, depending on which version of EQ you are using.

So basicly, you have to give all your custom ID's a lower unused ID.

As suggested by Kayen (http://www.eqemulator.org/forums/sho...ht=spell+limit), these can by found by using:

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);
Just remember to update your items pointing to your custom spells as well and place the spells_us on the server and client.
Reply With Quote