/** * KSSystem::getTableByIds() * * @param mixed $ids * @param mixed $table * @param mixed $fields * @param bool $published * @param bool $implode_keys * @param bool $single * @return */ public static function getTableByIds(array $ids, $table, array $fields, $published = true, $implode_keys = false, $single = false) { if (!empty($ids) && is_array($ids)) { if (empty(self::$ext_name)) { self::setGlobalVar('ext_name'); } $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select($fields)->from($db->qn('#__' . self::$ext_name . '_' . $table, 't')); if ($implode_keys) { $query->where('(' . $db->qn('t.id') . ' IN (' . KSSystem::key_implode(', ', $ids) . '))'); } else { $query->where('(' . $db->qn('t.id') . ' IN (' . implode(', ', $db->q($ids)) . '))'); } if ($published) { $query->where('t.published=1'); } $db->setQuery($query); // exit($query->dump()); if ($single) { $object = $db->loadObject(); } else { $object = $db->loadObjectList(); } if (!empty($object)) { return $object; } } return new stdClass(); }