From 7c87b0494806d3e6b3825ed5edf75680b3cf9870 Mon Sep 17 00:00:00 2001 From: "Pierre Habouzit (MadCoder" Date: Wed, 5 Jan 2005 09:37:12 +0000 Subject: [PATCH] backport Patches applied: * opensource@polytechnique.org--2005/platal--release--0.9.3--patch-19 optimize login request git-archimport-id: opensource@polytechnique.org--2005/platal--mainline--0.9--patch-219 --- include/xorg/session.inc.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/include/xorg/session.inc.php b/include/xorg/session.inc.php index b7ee199..79b8feb 100644 --- a/include/xorg/session.inc.php +++ b/include/xorg/session.inc.php @@ -297,7 +297,8 @@ function start_connexion ($uid, $identified) INNER JOIN aliases AS a2 ON (u.user_id = a2.id AND FIND_IN_SET('bestalias',a2.flags)) LEFT JOIN logger.sessions AS s ON (s.uid=u.user_id AND s.suid=0) WHERE u.user_id = {?} AND u.perms IN('admin','user') - ORDER BY s.start DESC, !FIND_IN_SET('epouse', a2.flags), length(a2.alias)", $uid); + ORDER BY s.start DESC + LIMIT 1", $uid); $sess = $res->fetchOneAssoc(); echo mysql_error(); $suid = Session::getMixed('suid'); -- 2.1.4