DaniWeb Forum Index > Web Development > PHP

Restrict access based on activation

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 52

Reputation: mgn2683 is an unknown quantity at this point

Solved Threads: 0

mgn2683

Offline

Junior Poster in Training

Restrict access based on activation

Apr 8th, 2008

Right now the site I am working on has a restrict access set up for two levels, but the way they set up their registration, once someone registers, they can login to the member side without first being activated in the database. I'd like to be able to adjust the restriction kind of like a where clause, where activation= 1 or something to that effect. Is this possible or does anyone have any advice or help for me? Thanks.

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Restrict access based on activation

Apr 8th, 2008

When the user registers, set the value for activation column as 0 (for that user) in the user table. When the user activates, update activation column to 1 for that user. Then, when the user tries to log in, while checking for username and password, also check if activation=1. If it isn't 1, promt him to activate first.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Apr 2008

Posts: 3

Reputation: unabomber1 is an unknown quantity at this point

Solved Threads: 0

unabomber1 unabomber1 is offline

Offline

Newbie Poster

Re: Restrict access based on activation

Apr 8th, 2008

like nav33n said, and use sessions to store activation and add as include on each page.

Last edited by unabomber1; Apr 8th, 2008 at 10:56 am.

•

Join Date: Dec 2007

Posts: 52

Reputation: mgn2683 is an unknown quantity at this point

Solved Threads: 0

mgn2683

Offline

Junior Poster in Training

Re: Restrict access based on activation

Apr 8th, 2008

I'm using ADDT to do this, when I click on the Restrict Access under Server Behaviors, where would I go to add activation=1 and the sessions ? Thanks.

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Restrict access based on activation

Apr 8th, 2008

Can you be more specific ? If you post your code and the database structure, it will be easier for us to help you !

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Dec 2007

Posts: 52

Reputation: mgn2683 is an unknown quantity at this point

Solved Threads: 0

mgn2683

Offline

Junior Poster in Training

Re: Restrict access based on activation

Apr 8th, 2008

The database is Mysql, and is working with a User table.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
//Start Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_nscar, "../");
//Grand Levels: Level
$restrict->addLevel("0");
$restrict->Execute();
//End Restrict Access To Page
 
// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("kt_login_user", true, "text", "", "", "", "");
$formValidation->addField("kt_login_password", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);
// End trigger
 
// Make a login transaction instance
$loginTransaction = new tNG_login($conn_nscar);
$tNGs->addTransaction($loginTransaction);
// Register triggers
$loginTransaction->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "kt_login1");
$loginTransaction->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$loginTransaction->registerTrigger("END", "Trigger_Default_Redirect", 99, "{kt_login_redirect}");
// Add columns
$loginTransaction->addColumn("kt_login_user", "STRING_TYPE", "POST", "kt_login_user");
$loginTransaction->addColumn("kt_login_password", "STRING_TYPE", "POST", "kt_login_password");
$loginTransaction->addColumn("kt_login_rememberme", "CHECKBOX_1_0_TYPE", "POST", "kt_login_rememberme", "0");
// End of login transaction instance
//Start Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_nscar, "../");
//Grand Levels: Level
$restrict->addLevel("0");
$restrict->Execute();
//End Restrict Access To Page

// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("kt_login_user", true, "text", "", "", "", "");
$formValidation->addField("kt_login_password", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);
// End trigger

// Make a login transaction instance
$loginTransaction = new tNG_login($conn_nscar);
$tNGs->addTransaction($loginTransaction);
// Register triggers
$loginTransaction->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "kt_login1");
$loginTransaction->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$loginTransaction->registerTrigger("END", "Trigger_Default_Redirect", 99, "{kt_login_redirect}");
// Add columns
$loginTransaction->addColumn("kt_login_user", "STRING_TYPE", "POST", "kt_login_user");
$loginTransaction->addColumn("kt_login_password", "STRING_TYPE", "POST", "kt_login_password");
$loginTransaction->addColumn("kt_login_rememberme", "CHECKBOX_1_0_TYPE", "POST", "kt_login_rememberme", "0");
// End of login transaction instance