that is done when they click the link in thier email if they are sent to domain.com/page.php?code=X4rfkj490T the code in page.php will $_GET['code'] and compare it to the one in the database, if they match, flip the switch if not show an error. On Sun, 26 Sep 2004 06:35:59 -0700 (PDT), Stuart Felenstein <stuart4m@xxxxxxxxx> wrote: > K...I've added the 2 columns, my names - activate and > activate_hash. > > Upon registration, the activate_hash has a generated > string inserted. activate column is default to 0. > I can compare it to the database - but not sure how to > flip the switch on the activate column 0->1 > Is that done through an update mechanism ? > > Stuart > > > > --- Joseph Crawford <codebowl@xxxxxxxxx> wrote: > > > 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 > > > > > > -- 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
