to reorder users

[14DH01]

Hello, :)
I am looking for a way to reorder the users deleted

After deletion of accounts, my forum is at 1080 users.
Before around 3400.
The problem is that each new registration, the user table increments from 3400 :o
So I'm looking for a mod that allows to put in order all the ID's ghost.
For the counter off again from 1080.

I asked the question on this thread but I do not think this mod solve my problem

https://vborg.vbsupport.ru/showthread.php?t=244707


thank you in advance for your support ;)

[kh99]

The userid isn't meant to be reused and the fact that you have a gap in the id range won't affect anything, so I'd recommend leaving it alone. However, if you still want to do it, you can execute a query like:

ALTER TABLE user AUTO_INCREMENT = 1080;


Also you should always have a recent backup of your database before messing with it.

[14DH01]

thank you my friend

Your query did not work

if there is a mod to replace all the id in order as the image ? :erm:

http://img338.imageshack.us/img338/7747/nomatch.png (http://imageshack.us/photo/my-images/338/nomatch.png/)

[kh99]

Oh...then you will want to reset your auto_increment field because I think I misunderstood what you wanted. You need to figure out what the highest userid value is, then rerun that query and set it to highest + 1 (or else users trying to register may get an error).

As far as the actual question you're asking, I don't think that mod was intended to do that, and I think you will probably end up causing yourself a lot of trouble if you try to do that. Is there some specific reason you need the ids to be like that?

[Lynne]

You cannot redo the user table so that every number is used.

[14DH01]

and with impex?
it would work ?

[Lynne]

Yeah, that would probably work. But you may lose other information when doing that, along with messing up any links on your site to threads or posts or users.

[14DH01]

ok so no other way to get what I ask.

there is not a script that can do this by taking into account the messages.

I drop.
I need the user id, to assign a number to the member.

A long number is not faficle to say about the calling frequency

for example
QRZ 14DH01 ID2= my call id "Charlie France 02".

Call user ID 3989 "charlie France 3989" = is no good

Each year the user trials to reach the QRG and give their ID to identify to forum.