View Single Post
  #2  
Old 01-26-2014, 02:20 AM
Kayen
Developer
 
Join Date: Mar 2009
Location: -
Posts: 228
Default

Good work.

Alternatively, SQL query to return gaps in spell file.

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
GM Storm Haven
Reply With Quote