Nama User Id Hoki Slot

Start your 7 day free trial

Offenbar hast du diese Funktion zu schnell genutzt. Du wurdest vorübergehend von der Nutzung dieser Funktion blockiert.

Wenn dies deiner Meinung nach nicht gegen unsere Gemeinschaftsstandards verstößt,

I have a table like this

I want the SLOT to be dependant on the user id.

If I add a new item, it should automatically be given slot 5. But If I first, let's say, deleted (slot 2 or moved it to another slot, the new item should get slot number 2. Is this possible to with SQL?

Slot is basically the position where the "item" row is place.

An inventory would look like this:

Where the numbers 1-20 are the Slots. If, let's say the 4 slots above are taken by items, the next items should be assigned 5. But If I move an item (like slot 2), to like slot 20, the next item should be placed on number 2, as it not taken now. If both 3-4 were deleted, and then an item was added, it would be placed at 3.