|
Registered UID (User ID)
|
| V I R U S |
Posted on 26-02-2008 15:13
|
Member
Posts: 84
Joined: 22/02/2007
|
Hi all and everyone here.
As you know, every user get his own USER ID, for example Digi's ID is 1 as he is first registered member. Sometimes, some users got banned and some admins don't want to keep all the time the banned users in DB, or if user has registered but don't verified his email to complete the registation, so the UID will be lost and will stay empty all the time.
For sure it will happen most the time on big project.
Is it possible to do on PHP-Fusion so that the empty UID will be refilled with new registered members?! For example if there on the site are 2000 registere members, and UID 100 has got deleted, the new member will get UID 100 instead of 2001 ?!
My signature is to damn big for you to see/Homdax.
|
| |
|
|
| TammyK |
Posted on 26-02-2008 15:19
|
Veteran Member
Posts: 501
Joined: 26/10/2005
|
Why would you want to? Users don't care about what number they're assigned and reclaiming those numbers doesn't make the database any smaller. Seems like a lot of effort for no reward. |
| |
|
|
| V I R U S |
Posted on 26-02-2008 16:02
|
Member
Posts: 84
Joined: 22/02/2007
|
On my project it will take a lot of users care. Mby not only on my.
My signature is to damn big for you to see/Homdax.
|
| |
|
|
| Josso |
Posted on 26-02-2008 16:36
|
Senior Member
Posts: 313
Joined: 19/11/2006
|
Well,, I'm one of the users who really care 'bout which ID I've gotten.
And as webmaster and normal user, It's nice to see who have been here for longest time (of the active users).
So if a user get a low ID but should have got a high ID, I would be confused... |
| |
|
|
| V I R U S |
Posted on 27-02-2008 13:02
|
Member
Posts: 84
Joined: 22/02/2007
|
But look, every user get a timestamp when he has joined. You can see every time when he joined.
My signature is to damn big for you to see/Homdax.
|
| |
|
|
| TammyK |
Posted on 27-02-2008 15:10
|
Veteran Member
Posts: 501
Joined: 26/10/2005
|
Okay. Josso has a reason why you shouldn't. What's your reason why you should, Virus? Again, there's no benefit to the database size and it's highly unlikely you'll run out of numbers for the field type. You'd have to have more than 99,999 people sign up. This site only has 18,000 or so, for example. |
| |
|
|
| Digitanium |
Posted on 27-02-2008 18:21
|
Super Admin
Posts: 1280
Joined: 12/04/2003
|
There isnt any real way to do this, the user ID is an auto incrementing field in the database. IDs are unique and can only be used once, forget it.  |
| |
|
|
| V I R U S |
Posted on 27-02-2008 18:38
|
Member
Posts: 84
Joined: 22/02/2007
|
Thanx for answer Digi. Therefore you can close this thread.
My signature is to damn big for you to see/Homdax.
|
| |
|
|
| alcazar |
Posted on 28-02-2008 15:50
|
Senior Member
Posts: 249
Joined: 13/11/2006
|
If you just want to remove the "gaps" (not refilling), you could do with backup the table and execute "Truncate Table..." to reset the auto_increment and then restore with new values.
But its more work than use.
Alcazar
nach Diktat spazierengegangen
|
| |
|
|
| Matonor |
Posted on 28-02-2008 18:29
|
Admin
Posts: 1026
Joined: 17/06/2004
|
then existing users would also be overwritten or at least the script would produce an error.
Impossible things are there to be made possible |
| |
|
|
| alcazar |
Posted on 29-02-2008 15:00
|
Senior Member
Posts: 249
Joined: 13/11/2006
|
the only problem besides editing the dump for new uid is to change the uid as well in other tables like comments, articles, news, forum_posts etc 
Alcazar
nach Diktat spazierengegangen
|
| |
|
