what i did is i used php to create a random string of numbers and letters about 15 chars long, then i store this in the db, and in the email i make the link page.php?code=RandomStringHere, then on the page.php i get the code and compare it to the ont in the database. If they match activate the user otherwise show an error. On Sun, 26 Sep 2004 05:54:14 -0700 (PDT), Stuart Felenstein <stuart4m@xxxxxxxxx> wrote: > 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 > > -- Joseph Crawford Jr. Codebowl Solutions codebowl@xxxxxxxxx 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
