Thanks for your response. Doesnt work either. Access is stillo granted :(
Bruno Friedmann-2 wrote:
>
> Hi
> Just a word : be carefull with 0/1 TRUE/FALSE and the type of your column
> and the database used.
>
>
> I suspect if you write you
> $authAdapter = new Zend_Auth_Adapter_DbTable($db, 'Members',
>> 'Email', 'Password', 'AND IsActive != "0"');
>
> AND IsActive != 0
>
> this would work ... :-)
> As another advice to be more SQL linguistic I would inverse the " and '
> "AND IsActive != '0'")
>
>
>
> dele454 wrote:
>> Am trying to implement a similar scenario where if the column IsActive is
>> set
>> to '0' the authentication should fail. A typical scenario is when a user
>> just signed up and still needs to active acct before allowed to gain
>> access.
>>
>> I followed the instruction in the Ref Guide but it isnt working. If the
>> user
>> supplies email+password before acct is activated - login is granted.
>>
>> The only code i didnt implement from the advanced useage example is the
>> MD5(?) because i have something similar implemented already. Except if it
>> does something else - i cant loggin with any credentials if i include it
>> though
>>
>>
>> $db= Zend_Registry::get('db');
>> $authAdapter = new Zend_Auth_Adapter_DbTable($db,
>> 'Members',
>> 'Email', 'Password', 'AND IsActive != "0"');
>>
>> $config = Zend_Registry::get('config');
>> $password = $logins['password'];
>> $salt = "$^&##&@";
>> $password =
>> md5($salt.$logins['password']);
>>
>> $authAdapter->setIdentity($logins['email']);
>> $authAdapter->setCredential($password);
>> return $authAdapter;
>>
>> Please help is needed thanks :)
>>
>> -----
>> dee
>
>
> --
>
> Bruno Friedmann
>
> Ioda-Net Sàrl
> 2830 Vellerat - Switzerland
>
> Tél : ++41 32 435 7171
> Fax : ++41 32 435 7172
> gsm : ++41 78 802 6760
> www.ioda-net.ch
>
> Centre de Formation et de Coaching En Ligne
> www.cfcel.com
>
>
>
-----
dee
--
View this message in context:
http://www.nabble.com/Zend-Auth%3A-Advanced-Usage-By-Example-tp20740513p20760074.html
Sent from the Zend Framework mailing list archive at Nabble.com.