Thread: Membership ID number

Hi

I noticed that members have an ID number. Thats is great, but I am starting from probably only few members and lets face it would you join a site that has ID "you are number 26" lets say! Is there away of changing the ID to start at say 1972 (year I was born thought it might be symbolic!).

I do not want you all to think I am unethical, I am not at anytime saying your ID reflect the number of members, but I just think it looks a little sad such low numbers. Just giving myself a helping hand so to speak....

Any ideas anyone, or how have you over over come this problem.

Cheers

Hi,

I looked for the old post too - could not find it...

Anyways - use PhpMyAdmin - go to your Profiles table, choose "operations" and then find at the bottom, the "auto increment" number - change it to what you want... a low (starting with 2 or 3) 5 or 6 digit number is ok... then save.

Note - I have seen bugs in various servers with phpmyadmin where this does not work - you would then use, after you do a backup:

Code:

ALTER TABLE `Profiles` PACK_KEYS =0 CHECKSUM =0 DELAY_KEY_WRITE =0 AUTO_INCREMENT =123456

Change 123456 to what you want it to be.

Smoge