From 62f0e0e85f62aadc17b794f1905f0a01ce4a157f Mon Sep 17 00:00:00 2001 From: Kilian Saffran Date: Thu, 28 Feb 2019 17:17:52 +0100 Subject: [PATCH] no blocked users visible --- tmpl/pages/avocats.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tmpl/pages/avocats.php b/tmpl/pages/avocats.php index fbfce43..8149b35 100644 --- a/tmpl/pages/avocats.php +++ b/tmpl/pages/avocats.php @@ -1,5 +1,5 @@ = CURRENT_DATE then 1 else null end as rendezvous_active,usr.* from users usr left join userservices srv on (usr.id=srv.id_user) where usr.usergroup in ('administrator','avocat') and usr.userblocked != 1 and usr.activationkey is null group by usr.id;"; + $sql = "SELECT case when srv.service = 'rendezvous' and srv.expiration >= CURRENT_DATE then 1 else null end as rendezvous_active,usr.* from users usr left join userservices srv on (usr.id=srv.id_user) where usr.usergroup in ('administrator','avocat') and usr.userblocked is null and usr.activationkey is null group by usr.id;"; $avocats = $db->dbqueryall($sql); if ($avocats){ ?> -- 2.39.5