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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
