I’m interested in setting up an auto-incrementing custom member field

Hello

I would like to create a custom member field that is auto-incrementing.

I had originally planned on using the member_id field for my purposes, but since it ends up being passed in the URL I’d rather not. Though what I need is not a “security” sensitive field I would like to keep it private. I also realize that I have the option of passing the username through the url to bring in membership data, but since I’m forcing the email as the username that won’t work either (I’m using Solspace’s User addon).

So…. I’m thinking that the simplest way to do this is to open up phpMyAdmin and just add another field to the exp_members table, set the type to INT, Length to 10, default none and check off AUTO_INCREMENT. I figured I’d be able to pull it in to my member’s profile page just like I do the other fields from that table.

So what do you think? Is my logic sound? Are there ramifications that I’m unaware of?

Cheers! Jules

Moved to Development and Programming by Moderator