Various GoD AA Code Changes

**cavedude** · #8 10-25-2008, 06:28 PM

That's the problem with using MySQL line numbers to identify data instead of IDs, they will change. If you insert new lines on the fly, it will just tack them on the end. But, the next time the server lists the data, it will in this case order by skill_id. A simple test:

Clear the index:

Code:

SET @line = 0;

Then, output the line numbers in reference to skill_id:

Code:

SELECT @line := @line + 1, skill_id FROM altadv_vars;

Maybe need to put a limit on, I did. Insert new AAs. Run the above query again, they *should* be tacked on the end. Clear the index with the first query, and then run the second query again. You'll notice, they will all be ordered by the skill_id again.