Thank you Stavors for the quick reply.. and thank you again (you and Asiby) for being my mentors, i've been reading your posts in the forum and learning alot.!
What i am facing is the following:
Setting the first option to (no) because i want the e-mail activation process.
As for the second option i tried both setting to (yes) and (no)
(yes) .. i got an e-mail saying the account is activated. i tried to login but could not (account is being blocked).. in the Admin interface i can see the account is not activated.
(no) .. i got an e-mail asking to follow a link for activation.. after follwing i got i page saying the account is active now as well as an e-mail similar to the one in the (yes) case. again i can not log in and the admin interface is showing that the account is not active.
in both cases i had to change the status of the account to (active) from the admin interface so that i can log in (as a user) and use it.
So i tried to follow the page which is involved (activate.php).. and found the code that i posted above .. it is updating the field (activatedbyuser) and leaving the (activated) field which is related to the account status in the admin interface.
I added another query involving the (activated) field and it worked..
before :
Code:
if(isset($key) && $list[0][8]=="f")
{
$QUERY = "UPDATE cc_card SET activatedbyuser = 't' WHERE ( loginkey = '".$key."' ) ";
$result = $instance_sub_table -> SQLExec ($HD_Form -> DBHandle, $QUERY, 0);
}
after :
Code:
if(isset($key) && $list[0][8]=="f")
{
$QUERY = "UPDATE cc_card SET activatedbyuser = 't' WHERE ( loginkey = '".$key."' ) ";
$result = $instance_sub_table -> SQLExec ($HD_Form -> DBHandle, $QUERY, 0);
$QUERY = "UPDATE cc_card SET activated = 't' WHERE ( loginkey = '".$key."' ) ";
$result = $instance_sub_table -> SQLExec ($HD_Form -> DBHandle, $QUERY, 0);
}
I admit that i am below the beginner in php, feel like wondering in the dark with a cigarette lighter.. i am not sure if i placed the new code in the right place and it is not going to interact with other pieces from the original code.