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
