View Single Post
  #11  
Old 07-22-2015, 08:54 AM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Actually, some client-side limitations have been noticed, like around the 28,000+ area spells start to have weird issues client-side on Underfoot. Such as the inability to accurately see the spell, regardless of it is in your spell file. There's a pretty cool query that allows you to find spell id ranges that are empty, I re-wrote it a little to sort by the amount of empty spell IDs in each range:
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;
Also, for reference, here's a post by demonstar55: http://www.eqemulator.org/forums/sho...42&postcount=8
Reply With Quote