[unprotectedtext]

first off i was using heidisql, i right clicked in the column and clicked reset sorting thinking it would list it in numerical order, just as i clicked it i knew that i should of just clicked to top of the column but by then to late no undo to be heard of. backed up player data, world data and bot data to rebuild database, just deleted whole data base and rebuilt from scratch and checked befor i souced in my player/world/bot data and the items table still ended up with the same id's going from 1001 - 2117.

if i were to just source in the items table. how would i go about getting just the items table from and old backup? or if anyone would be so kind as to point me in the right direction of just the data table sql.

so sorry for bothering anyone with this i now just realized that it did exactly that, reset my sorting order, what i didn't see is that it only shows the first 1000 entries, clicked show all and everything was sorted numerically like i wanted >.<