← Back to branch summary

~ay-databay/openc/openc

« back to all changes in this revision

Viewing changes to classes/class.gruppen.php

  • Committer: aresch
  • Date: 2012-03-08 13:41:10 UTC
  • Revision ID: svn-v4:ce0b872e-c4d4-4b22-b26e-e8b0f33039ed::251

Show diffs side-by-side

added added

removed removed

Lines of Context:
classes/class.gruppen.php
375
375
        */
376
376
        public function getMembers($cg_fk) {
377
377
                // {{{
378
 
                $M = $this->fw->DC->getAllByQuery("SELECT * FROM co_groups_member WHERE gm_cg_fk='".(int)$cg_fk."' AND gm_member=1 ");
 
378
                $M = $this->fw->DC->getAllByQuery("SELECT * FROM co_groups_member 
 
379
                                                    INNER JOIN fe_user ON gm_fe_fk=fe_pk  
 
380
                                                    WHERE fe_deleted='0000-00-00 00:00:00' AND gm_cg_fk='".(int)$cg_fk."' AND gm_member=1 ");
379
381
                return($M);
380
382
                // }}}
381
383
        }