[m4karow]

Quote:

Originally Posted by [HLF]Southclaw The real question is why? What would you gain from filling removed IDs? You'll probably cause more problems for yourself in future, just let AUTOINCREMENT do what it does and stay out. You have 4 billion possible integer values and 9,223,372,036,854,775,807 if your database supports 64 bit values (obviously SA:MP would not like that, but I'm making a point). If you are relying on the IDs being in sequence - don't.

The inventory system listing the player item's with their DB ID-s and whenever an item dropped into the floor and picked up this ID is increasing. So the ID-s could be easily above a million that would disturb the inventory dialog and the problem is the inventory system is working always with theese ID-s (for example select the given ID when responding to the inventory listitem)

The inventory dialog will look like this:

ID / Item name / Amount
2342523 Fuel 0,3 l
2342524 Money $5000
2342525 Something 0,3 l
2342526 Something 0,3 l