Hello can anyone tell me the best way to accomplish this? I am porting a
legacy app I maintain to use MVC. On the auth query I join a customer info
table to store some other info in the session.
// Login Attempt
$sql = "SELECT
*,
UNIX_TIMESTAMP(renew) AS renew_unix,
UNIX_TIMESTAMP(signup) AS signup_unix
FROM
`users`
LEFT JOIN `users_info` USING (userid)
WHERE
username = '".clean_string('username')."'
AND
passwd = '".md5(clean_string('passwd'))."'";
$res = $db->get_row($sql);
How can I port this for use Zend_Auth so the additional info is stored in
the Auth or should I just suck it up and combined users_info and users.
Thx for any ideas
Eric
