XOOPS / XoopsCore25

     *

     * @return bool true on success, otherwise false

     **/

    public function insert(XoopsObject $imgsetimg)

    {

        $className = 'XoopsImageSetImg';

        if (!($imgsetimg instanceof $className)) {

            return false;

        }

        if (!$imgsetimg->isDirty()) {

            return true;

        }

        if (!$imgsetimg->cleanVars()) {

            return false;

        }

        foreach ($imgsetimg->cleanVars as $k => $v) {

            ${$k} = $v;

        }

        if ($imgsetimg->isNew()) {

            $imgsetimg_id = $this->db->genId('imgsetimg_imgsetimg_id_seq');

            $sql          = sprintf('INSERT INTO %s (imgsetimg_id, imgsetimg_file, imgsetimg_body, imgsetimg_imgset) VALUES (%u, %s, %s, %s)', $this->db->prefix('imgsetimg'), $imgsetimg_id, $this->db->quoteString($imgsetimg_file), $this->db->quoteString($imgsetimg_body), $this->db->quoteString($imgsetimg_imgset));

        } else {

            $sql = sprintf('UPDATE %s SET imgsetimg_file = %s, imgsetimg_body = %s, imgsetimg_imgset = %s WHERE imgsetimg_id = %u', $this->db->prefix('imgsetimg'), $this->db->quoteString($imgsetimg_file), $this->db->quoteString($imgsetimg_body), $this->db->quoteString($imgsetimg_imgset), $imgsetimg_id);

        }

        if (!$result = $this->db->query($sql)) {

            return false;

        }

        if (empty($imgsetimg_id)) {

            $imgsetimg_id = $this->db->getInsertId();

        }

        $imgsetimg->assignVar('imgsetimg_id', $imgsetimg_id);

        return true;

    }

    /**

     * Delete an image from the database

     *

     * @return bool true on success, otherwise false

     */

    public function insert(XoopsObject $tplset)

    {

        $className = 'XoopsTplset';

        if (!($tplset instanceof $className)) {

            return false;

        }

        if (!$tplset->isDirty()) {

            return true;

        }

        if (!$tplset->cleanVars()) {

            return false;

        }

        foreach ($tplset->cleanVars as $k => $v) {

            ${$k} = $v;

        }

        if ($tplset->isNew()) {

            $tplset_id = $this->db->genId('tplset_tplset_id_seq');

            $sql       = sprintf('INSERT INTO %s (tplset_id, tplset_name, tplset_desc, tplset_credits, tplset_created) VALUES (%u, %s, %s, %s, %u)', $this->db->prefix('tplset'), $tplset_id, $this->db->quoteString($tplset_name), $this->db->quoteString($tplset_desc), $this->db->quoteString($tplset_credits), $tplset_created);

        } else {

            $sql = sprintf('UPDATE %s SET tplset_name = %s, tplset_desc = %s, tplset_credits = %s, tplset_created = %u WHERE tplset_id = %u', $this->db->prefix('tplset'), $this->db->quoteString($tplset_name), $this->db->quoteString($tplset_desc), $this->db->quoteString($tplset_credits), $tplset_created, $tplset_id);

        }

        if (!$result = $this->db->query($sql)) {

            return false;

        }

        if (empty($tplset_id)) {

            $tplset_id = $this->db->getInsertId();

        }

        $tplset->assignVar('tplset_id', $tplset_id);

        return true;

    }

    /**

     * delete a tplset from the database

     *

     * @return bool true on success, otherwise false

     */

    public function insert(XoopsObject $group)

    {

        $className = 'XoopsGroup';

        if (!($group instanceof $className)) {

            return false;

        }

        if (!$group->isDirty()) {

            return true;

        }

        if (!$group->cleanVars()) {

            return false;

        }

        foreach ($group->cleanVars as $k => $v) {

            ${$k} = $v;

        }

        if ($group->isNew()) {

            $groupid = $this->db->genId('group_groupid_seq');

            $sql     = sprintf('INSERT INTO %s (groupid, name, description, group_type) VALUES (%u, %s, %s, %s)', $this->db->prefix('groups'), $groupid, $this->db->quoteString($name), $this->db->quoteString($description), $this->db->quoteString($group_type));

        } else {

            $sql = sprintf('UPDATE %s SET name = %s, description = %s, group_type = %s WHERE groupid = %u', $this->db->prefix('groups'), $this->db->quoteString($name), $this->db->quoteString($description), $this->db->quoteString($group_type), $groupid);

        }

        if (!$result = $this->db->query($sql)) {

            return false;

        }

        if (empty($groupid)) {

            $groupid = $this->db->getInsertId();

        }

        $group->assignVar('groupid', $groupid);

        return true;

    }

    /**

     * remove a group from the database