From 907b7e3d7dadc1068d80bd91ec1b37cb6844ddc1 Mon Sep 17 00:00:00 2001 From: "vincent@cubedesigners.com" Date: Fri, 29 Apr 2011 11:48:44 +0000 Subject: [PATCH] --- inc/ws/Controlleur/class.ws.url.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/inc/ws/Controlleur/class.ws.url.php b/inc/ws/Controlleur/class.ws.url.php index ccfd17be5..f038d1b92 100644 --- a/inc/ws/Controlleur/class.ws.url.php +++ b/inc/ws/Controlleur/class.ws.url.php @@ -582,7 +582,7 @@ html{height:100%}' . "\n"; $book = $dao->selectById($book_id); $projects = array("--" => '0'); - $r = $core->con->select('SELECT * FROM projets WHERE client IN(SELECT entreprise FROM utilisateurs WHERE utilisateur_id IN( SELECT facturable_id FROM ws_users_tree WHERE utilisateur_id IN (SELECT utilisateur_id FROM utilisateurs WHERE entreprise=\'' . $core->con->escape($book->proprietaire_id) . '\'))) ORDER BY projet_id DESC'); + $r = $core->con->select('SELECT * FROM projets WHERE client IN(SELECT facturable_id FROM ws_users_tree WHERE utilisateur_id=\'' . $core->con->escape($book->proprietaire_id) . '\') ORDER BY projet_id DESC'); while ($r->fetch()) { $projects[$r->projet_id . ' - ' . $r->nom] = $r->projet_id; } -- 2.39.5