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.

Reply via email to