From ef2fa1558e2e81c972369eb5066b78da9f3a492d Mon Sep 17 00:00:00 2001
From: Kilian Saffran <ksaffran@dks.lu>
Date: Thu, 28 Feb 2019 17:14:12 +0100
Subject: [PATCH] do not display blocked and not activated users

---
 tmpl/pages/avocats.php     | 2 +-
 tmpl/pages/tabledeprix.php | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/tmpl/pages/avocats.php b/tmpl/pages/avocats.php
index 2904606..fbfce43 100644
--- a/tmpl/pages/avocats.php
+++ b/tmpl/pages/avocats.php
@@ -1,5 +1,5 @@
 <?php
-  $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') 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 != 1 and usr.activationkey is null group by usr.id;";
   $avocats = $db->dbqueryall($sql);
   if ($avocats){
 ?>
diff --git a/tmpl/pages/tabledeprix.php b/tmpl/pages/tabledeprix.php
index fbf70e7..0136062 100644
--- a/tmpl/pages/tabledeprix.php
+++ b/tmpl/pages/tabledeprix.php
@@ -14,7 +14,7 @@
         <li class="list-group-item">Visible dans l'annuaire</li>
         <li class="list-group-item list-group-item-dark"><strong>Service Rendez-Vous</strong></li>
         <li class="list-group-item">Periode d'évaluation 1 mois gratuit</li>
-        <li class="list-group-item list-group-item-dark"><strong>Système Billjee</strong></li>
+        <li class="list-group-item list-group-item-dark"><strong>Service Billjee</strong></li>
         <li class="list-group-item">Periode d'évaluation 1 mois gratuit</li>
       </ul>
     </div>
-- 
2.39.5