mambax7 / XoopsCore25

            return $ret;

        }

        $theObjects = array();

        while ($myrow = $this->db->fetchArray($result)) {

            $item = new PublisherItem();

            $item->assignVars($myrow);

            $theObjects[$myrow['itemid']] = $item;

            unset($item);

        }

        foreach ($theObjects as $theObject) {

            if ($id_key === 'none') {

                $ret[] = $theObject;

        $sql .= ' GROUP BY categoryid)mo';

        $sql .= ' JOIN ' . $this->db->prefix('publisher_items') . ' mi ON mi.datesub = mo.date';

        $result = $this->db->query($sql);

        while ($row = $this->db->fetchArray($result)) {

            $item = new PublisherItem();

            $item->assignVars($row);

            $ret[$row['categoryid']] = $item;

            unset($item);

        }

        return $ret;

    }