XoopsModules25x / efqdirectory

        $sql     = 'SELECT dtypeid,title,section,fieldtypeid,uid,defaultyn,created,seq,activeyn,options,custom,icon	WHERE dtypeid=' . (int)$gpc_dtypeid;

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

        $numrows = $this->db->getRowsNum($result);

        if ($numrows > 0) {

            while (list($dtypeid, $title, $section, $fieldtypeid, $uid, $defaultyn, $activeyn, $options, $custom, $icon) = $this->db->fetchRow($result)) {

                if (!$this->objDataType) {

                    $this->objDataType = new efqDataType();

                }

                $this->objDataType->setVar('dtypeid', $dtypeid);

                $this->objDataType->setVar('title', $title);

                $this->objDataType->setVar('section', $section);

                $this->objDataType->setVar('fieldtypeid', $fieldtypeid);

                $this->objDataType->setVar('uid', $uid);

                $this->objDataType->setVar('defaultyn', $defaultyn);

                $this->objDataType->setVar('created', $created);

                $this->objDataType->setVar('seq', $seq);

                $this->objDataType->setVar('options', $options);

                $this->objDataType->setVar('activeyn', $activeyn);

                $this->objDataType->setVar('custom', $custom);

                $this->objDataType->setVar('icon', $icon);

            }

        } else {

            return false;

        }

        return true;

    }

                   . '';

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

        $numrows = $this->db->getRowsNum($result);

        if ($numrows > 0) {

            while (list($offerid, $offertitle, $typeid, $duration, $count, $price, $activeyn, $currency, $descr, $dirid, $typename, $level) = $this->db->fetchRow($result)) {

                if (!$this->objOffer) {

                    $this->objOffer = new efqSubscriptionOffer();

                }

                $this->objOffer->setVar('offerid', $offerid);

                $this->objOffer->setVar('title', $offertitle);

                $this->objOffer->setVar('typeid', $typeid);

                $this->objOffer->setVar('duration', $duration);

                $this->objOffer->setVar('count', $count);

                $this->objOffer->setVar('price', $price);

                $this->objOffer->setVar('activeyn', $activeyn);

                $this->objOffer->setVar('currency', $currency);

                $this->objOffer->setVar('descr', $descr);

                $this->objOffer->setVar('dirid', $dirid);

                $this->objOffer->setVar('typename', $typename);

                $this->objOffer->setVar('level', $level);

            }

        } else {

            return false;

        }

        return true;

    }