Easy way to edit 3600 users?

[Watson]

I am wondering if there is an easy way to change 3600 odd users from there user ID's

The list in the user table is running out of sequence, and I would like the userid's to run from 1-3600 in sequence, but instead the run like 1,2,4,6,8 from inactive members that have been deleted.

Is there any easy way to do this other than editing them all manually which I worked out will take hours :)


This is so I can merge them with another table

Cheers

Watson

[Brad]

I am wondering if there is an easy way to change 3600 odd users from there user ID's

The list in the user table is running out of sequence, and I would like the userid's to run from 1-3600 in sequence, but instead the run like 1,2,4,6,8 from inactive members that have been deleted.

Is there any easy way to do this other than editing them all manually which I worked out will take hours :)


This is so I can merge them with another table

Cheers

Watson
Its really pointless and not worth it, changing them in the user table is going to throw all the other places that store userid's out of wack.

Userid's act like this so there is never a conflict. :)

[Marco van Herwaarden]

It would be like asking if we can give everybody in my class a new birthday, so we would have birthday on consecutive days.

This will cause you so much problems, it is never worth it.

[Paul M]

This would be a very quick way to completely break your board - the userids are embedded in all the major vb tables.

[Marco van Herwaarden]

Not even to mention links to userids posted as URL's.

Or if attachments are stored in teh filesystem, the directory names where the attachments are stored.

Just 1 advice: Forget it!

[Watson]

k cheers guy, need to find another way of doing it then :)

[Zachery]

k cheers guy, need to find another way of doing it then :)
What good reason do you have for renumbering your users...

[Watson]

running a torrent tracker, and trying to get the users to line up with each other so that they dont have to re-register on another tracker, and we can get stats to work, but it didnt work too well heh

[Reeve of shinra]

Maybe you could reimport your board using the vb importer? I am not sure how that works but vb to vb imports must renumber the user id's to avoid conflicts.

[Marco van Herwaarden]

I still don't see why members must have consecutive id's for a tracker?

But why don't you just add a new field to the user table. If you add it, you can do with it whatever you want.

[Watson]

I have just been told Marco that you my friend are a Genious :)

Thanks for that, we never even though of doing it that way :)

[Marco van Herwaarden]

Thank you :blushes:

I always try to look at things in a different perspective. A lot of times you are so much focused on 1 solution, that you miss the obvious.

[Watson]

yeah, think that was our problem