miniBB ® 

miniBB

®
Support Forums
  
 | Start | Register | Search | Statistics | File Bank | Manual |
The Other miniBB Support Forums / The Other /  
 

User IDs changing / what's happening to deleted IDs

 
Author MB
Guest
#1 | Posted: 16 Feb 2004 05:14 
I have just added a fourth user to my test forum. While the first three users have the IDs of 1, 2, 3 respectively, the fourth user has the ID of 10 instead of 5. Is this normal?

Perhaps this has something to do with the fact that upon a time I had a few more users on the test forum (they since been all remvoved though)?

Do user ID numbers adjust themselves to reflect changes after certain members have been deleted? For example, does Jack (ID#10) become ID#9 when Peter (current ID#9) is removed?

Thanks.

--MB

Author cakeman
Partaker
#2 | Posted: 16 Feb 2004 11:31 
Do user ID numbers adjust themselves to reflect changes after certain members have been deleted? For example, does Jack (ID#10) become ID#9 when Peter (current ID#9) is removed?

Definitely not :)
ID has the proprety AUTO-INCREMENT in the DB: in fact, when you create a user, ID is incremented of 1 and affected to the last user registered. If the last user is deleted, ID value does'nt change.

fourth user has the ID of 10 instead of 5

That means that you created 10 users (the fourth users is in fact the user 10 ) but you deleted five users among this ten users.

Author MB
Guest
#3 | Posted: 16 Feb 2004 13:14 
Ah-hah, I see! Many thanks for your explanation, Cakeman.
Cheers,
MB

The Other miniBB Support Forums / The Other /
 User IDs changing / what's happening to deleted IDs
 Share Topic's Link

Your Reply Click this icon to move up to the quoted message


  ?
Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.


Before posting, make sure your message is compliant with forum rules; otherwise it could be locked or removed with no explanation.

 

 
miniBB Support Forums Powered by Forum Software miniBB ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.


  ⇑