Ejemplo n.º 1
0
 function selectMembers($ids)
 {
     if (isset($ids[0])) {
         $ids_str = implode(',', $ids);
         $query = "SELECT mem.*, IFNULL(a.ID_ATTACH, 0) AS id_attach, a.filename, a.attachmentType AS attachment_type" . "\n FROM `#__members` AS mem" . "\n LEFT JOIN `#__attachments` AS a ON (a.ID_MEMBER = mem.ID_MEMBER)" . "\n WHERE mem.ID_MEMBER IN ( {$ids_str} )";
         $this->smf_db->setQuery($query);
         $res = $this->smf_db->loadObjectList();
         $res = JLMS_SMF_member::loadAdapter($res);
         return $res;
     }
     return false;
 }