Ok , I think this is along the lines of what I've started. I added a column called "active" with a default to 0. It's a tiny int since I'm think 0=fales, 1=true. So can you explain a tad more about this hash stuff ? Is that specific to a sql field or just a name you've chose ? I'm not sure what you mean in your last statement about the hash passing over to the activate column ? Stuart --- M Saleh EG <m.saleh.eg@xxxxxxxxx> wrote: > I'd do it this way... > > I'd add two column in the users table. 1- activated, > 2- activation-hash > > once the registeration form is ubmited.. > a-the username and user info will be saved in the > users table. > b-an encrypted hash would be made n saved in > activation-hash column > and sent along with the registeration info (username > & pass) in the > form of a url (eg. > http://domain/activationpage.php?hash=ljk;lkj;lkjl;ksjfasdfa). > > if the user is activated then the login function > works for them if not > given a msg saying ur activation hasnt been done > yet.... > > the activatepage.php should then put 1, or on in the > activated colum > in the users table on the row that has the hash > passed to it. > > simple enought aint it? > > > On Sun, 26 Sep 2004 05:02:07 -0700 (PDT), Stuart > Felenstein > <stuart4m@xxxxxxxxx> wrote: > > Currently there are only 2 types of users planned > > Each has a basic access level. I don't think this > is > > the same as a usergroup though. > > > > If I don't have usergroups, but access levels, > then > > perhaps I should set the level to some less then > what > > is required login till activated. > > > > Then it sounds like I have the system autogenerate > an > > activation code. > > > > Not sure what you mean by : > > > a separate table holding information on how to > > > activate (something > > > along the lines of userid, tousergroup, > > > activationcode). > > > > > > > > > > --- Oscar Rylin <oscar.rylin@xxxxxxxxx> wrote: > > > > > Usergroups. > > > Most likely, you're dealing with an application > > > where you'll want to have > > > different kinds of users (administrators, power > > > users, users). > > > > > > Just make a usergroup for accounts that haven't > been > > > activated yet. > > > Also, a separate table holding information on > how to > > > activate (something > > > along the lines of userid, tousergroup, > > > activationcode). > > > > > > / rylin > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > > > > > -- > M.Saleh.E.G > 97150-4779817 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php