1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
class PluginsfGuardUserPeer extends BasesfGuardUserPeer
{
public static function retrieveByUsername($username, $isActive = true)
{
// modification du systeme de selection
$Syntaxe='#^[\w.-]+@[\w.-]+\.[a-zA-Z]{2,6}$#';
if(preg_match($Syntaxe,$username))
{
//Connextion a la bdd
@mysql_connect('localhost','user_de_la_base','mot_de_passe_base');
@mysql_select_db('nom_de_la_base');
$query = "select * from sf_guard_user, sf_guard_user_profile where sf_guard_user.id=sf_guard_user_profile.user_id and email='$username' and is_active=1 limit 1";
$res = mysql_query($query);
while ($val = mysql_fetch_array($res))
{
$username = $val['username'];
$c = new Criteria();
$c->add(self::USERNAME, $username);
$c->add(self::IS_ACTIVE, $isActive);
}
mysql_free_result($res);
}
else
{
$c = new Criteria();
$c->add(self::USERNAME, $username);
$c->add(self::IS_ACTIVE, $isActive);
}
return self::doSelectOne($c);
}
} |
Partager