PDA

View Full Version : Don't really know how to explain...


gethinoakes
09-29-2005, 06:08 PM
On my forums, I deleted a few members so its like this with the member id's, there's no 2,3,4,5 etc.

Is there anyway, that when a member is removed, it doesn't effect the user ID, e.g. so if I remove a member the member above will then become that ID... if you get what I mean it's kinda confusing.

Dam sorry, I don't have a clue how I posted this in the vB2 forum, could some one please move it up to the vB 3.5 forum?

Zachery
09-29-2005, 06:43 PM
On my forums, I deleted a few members so its like this with the member id's, there's no 2,3,4,5 etc.

Is there anyway, that when a member is removed, it doesn't effect the user ID, e.g. so if I remove a member the member above will then become that ID... if you get what I mean it's kinda confusing.

Dam sorry, I don't have a clue how I posted this in the vB2 forum, could some one please move it up to the vB 3.5 forum?

Nope, not possible..

bigcurt
09-29-2005, 06:55 PM
Nope, not possible..


It is VERY rare to hear that out of zach's mouth xD.



~Curt

Paul M
09-29-2005, 07:14 PM
It is VERY rare to hear that out of zach's mouth xD.Really, where do you usually hear it from then ............

Zachery
09-29-2005, 10:12 PM
Really, where do you usually hear it from then ............

Let me rephrase that, is it possible yes? but realisticly? No

The massive updating that would need to go on to do this would be insane esp as your numbers grow.

Lets assume you have 1000 users in your database, and you delete 4 of them in differnt areas

You'd have to renuber up to 900 some users, including all id's in posts, threads, pms, and possibly other places in the system. Not to mention you'd have to reset mysql's auto incriment and possible permission issues...

Its not worth the trouble, you've got A few billion possible id's

bigcurt
09-29-2005, 10:29 PM
Let me rephrase that, is it possible yes? but realisticly? No

The massive updating that would need to go on to do this would be insane esp as your numbers grow.

Lets assume you have 1000 users in your database, and you delete 4 of them in differnt areas

You'd have to renuber up to 900 some users, including all id's in posts, threads, pms, and possibly other places in the system. Not to mention you'd have to reset mysql's auto incriment and possible permission issues...

Its not worth the trouble, you've got A few billion possible id's



Thats better :-D.



~Curt

gethinoakes
09-29-2005, 10:44 PM
Hmmm ok thanks guys, but what if I'm just starting my forum and I had to test a few hacks and had to delete members 2,3 so it jumps from member 1-4, anyway to change it so theres no gap. Theres only 2 members since it's not even open yet also...

if not nevermind it's just me being fussy! :nervous:

Andreas
09-29-2005, 10:48 PM
Userids are totally irrelevant, they are just IDs and nothing else ... so who cares if there are "gaps" or not?

gethinoakes
09-29-2005, 11:02 PM
see me being fussy :paranoid:... nevermind :)