XoopsModules25x / smartpartner

     * @param $obj

     * @return string

     */

    public function _insertQuery($obj)

    {

        // Copy all object vars into local variables

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

            ${$k} = $v;

        }

        $sql = sprintf('INSERT INTO %s (mime_id, mime_ext, mime_types, mime_name, mime_admin, mime_user) VALUES

               (%u, %s, %s, %s, %u, %u)', $this->_db->prefix($this->_dbtable), $mime_id, $this->_db->quoteString($mime_ext), $this->_db->quoteString($mime_types), $this->_db->quoteString($mime_name),

                       $mime_admin, $mime_user);

        return $sql;

    }

    /**

     * @param $obj

     * @return string

     */

    public function _updateQuery($obj)

    {

        // Copy all object vars into local variables

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

            ${$k} = $v;

        }

        $sql = sprintf('UPDATE %s SET mime_ext = %s, mime_types = %s, mime_name = %s, mime_admin = %u, mime_user = %u WHERE

               mime_id = %u', $this->_db->prefix($this->_dbtable), $this->_db->quoteString($mime_ext), $this->_db->quoteString($mime_types), $this->_db->quoteString($mime_name), $mime_admin,

                       $mime_user, $mime_id);

        return $sql;

    }

    /**