X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fplatalglobals.php.in;h=0fb6e6fc0d123ca394b1628754dbeba126284149;hb=be719660db2aa5d78e8cf3d83163a561eaab222d;hp=cc95b1b1d708c560581ece9727343059d04a6749;hpb=af744c2d5f4ddf83b738b9cb390926eaca4cf7c3;p=platal.git diff --git a/classes/platalglobals.php.in b/classes/platalglobals.php.in index cc95b1b..0fb6e6f 100644 --- a/classes/platalglobals.php.in +++ b/classes/platalglobals.php.in @@ -26,6 +26,7 @@ class PlatalGlobals extends PlGlobals /** db params */ public $dbdb = 'x4dat'; + public $dbprefix = ''; public $dbhost = 'localhost'; public $dbuser = 'x4dat'; public $dbpwd = 'x4dat'; @@ -60,12 +61,13 @@ class PlatalGlobals extends PlGlobals } if ($gp) { - $res = XDB::query('SELECT a.*, d.nom AS domnom, - FIND_IN_SET(\'wiki_desc\', a.flags) AS wiki_desc, - FIND_IN_SET(\'notif_unsub\', a.flags) AS notif_unsub - FROM groupex.asso AS a - LEFT JOIN groupex.dom AS d ON d.id = a.dom - WHERE diminutif = {?}', $gp); + $res = XDB::query("SELECT a.*, d.nom AS domnom, + FIND_IN_SET('notif_unsub', a.flags) AS notif_unsub, + FIND_IN_SET('has_ml', a.flags) AS has_ml + FROM #groupex#.asso AS a + LEFT JOIN #groupex#.dom AS d ON d.id = a.dom + WHERE diminutif = {?}", + $gp); if (!($aid = $res->fetchOneAssoc())) { $aid = array(); }