roundcubemail/program/lib/Roundcube/rcube_spellchecker.php
private function update_dict()
    {
        if (strcasecmp($this->options['dictionary'], 'shared') != 0) {
            $userid = $this->rc->get_user_id();
        }

        $plugin = $this->rc->plugins->exec_hook('spell_dictionary_save', array(
            'userid' => $userid, 'language' => $this->lang, 'dictionary' => $this->dict));

        if (!empty($plugin['abort'])) {
            return;
        }

        if ($this->have_dict) {
            if (!empty($this->dict)) {
                $this->rc->db->query(
                    "UPDATE " . $this->rc->db->table_name('dictionary', true)
                    ." SET `data` = ?"
                    ." WHERE `user_id` " . ($plugin['userid'] ? "= ".$this->rc->db->quote($plugin['userid']) : "IS NULL")
                        ." AND `language` = ?",
                    implode(' ', $plugin['dictionary']), $plugin['language']);
            }
            // don't store empty dict
            else {
                $this->rc->db->query(
                    "DELETE FROM " . $this->rc->db->table_name('dictionary', true)
                    ." WHERE `user_id` " . ($plugin['userid'] ? "= ".$this->rc->db->quote($plugin['userid']) : "IS NULL")
                        ." AND `language` = ?",
                    $plugin['language']);
            }
        }
        else if (!empty($this->dict)) {
            $this->rc->db->query(
                "INSERT INTO " . $this->rc->db->table_name('dictionary', true)
                ." (`user_id`, `language`, `data`) VALUES (?, ?, ?)",
                $plugin['userid'], $plugin['language'], implode(' ', $plugin['dictionary']));
        }
    }
private function update_dict()
    {
        if (strcasecmp($this->options['dictionary'], 'shared') != 0) {
            $userid = $this->rc->get_user_id();
        }

        $plugin = $this->rc->plugins->exec_hook('spell_dictionary_save', array(
            'userid' => $userid, 'language' => $this->lang, 'dictionary' => $this->dict));

        if (!empty($plugin['abort'])) {
            return;
        }

        if ($this->have_dict) {
            if (!empty($this->dict)) {
                $this->rc->db->query(
                    "UPDATE " . $this->rc->db->table_name('dictionary', true)
                    ." SET `data` = ?"
                    ." WHERE `user_id` " . ($plugin['userid'] ? "= ".$this->rc->db->quote($plugin['userid']) : "IS NULL")
                        ." AND `language` = ?",
                    implode(' ', $plugin['dictionary']), $plugin['language']);
            }
            // don't store empty dict
            else {
                $this->rc->db->query(
                    "DELETE FROM " . $this->rc->db->table_name('dictionary', true)
                    ." WHERE `user_id` " . ($plugin['userid'] ? "= ".$this->rc->db->quote($plugin['userid']) : "IS NULL")
                        ." AND `language` = ?",
                    $plugin['language']);
            }
        }
        else if (!empty($this->dict)) {
            $this->rc->db->query(
                "INSERT INTO " . $this->rc->db->table_name('dictionary', true)
                ." (`user_id`, `language`, `data`) VALUES (?, ?, ?)",
                $plugin['userid'], $plugin['language'], implode(' ', $plugin['dictionary']));
        }
    }
private function update_dict ( ) { if ( strcasecmp ( $ this -> options [ 'dictionary' ] , 'shared' ) != 0 ) { $ userid = $ this -> rc -> get_user_id ( ) ; } $ plugin = $ this -> rc -> plugins -> exec_hook ( 'spell_dictionary_save' , array ( 'userid' => $ userid , 'language' => $ this -> lang , 'dictionary' => $ this -> dict ) ) ; if ( ! empty ( $ plugin [ 'abort' ] ) ) { return ; } if ( $ this -> have_dict ) { if ( ! empty ( $ this -> dict ) ) { $ this -> rc -> db -> query ( "UPDATE " . $ this -> rc -> db -> table_name ( 'dictionary' , true ) . " SET `data` = ?" . " WHERE `user_id` " . ( $ plugin [ 'userid' ] ? "= " . $ this -> rc -> db -> quote ( $ plugin [ 'userid' ] ) : "IS NULL" ) . " AND `language` = ?" , implode ( ' ' , $ plugin [ 'dictionary' ] ) , $ plugin [ 'language' ] ) ; } // don't store empty dict else { $ this -> rc -> db -> query ( "DELETE FROM " . $ this -> rc -> db -> table_name ( 'dictionary' , true ) . " WHERE `user_id` " . ( $ plugin [ 'userid' ] ? "= " . $ this -> rc -> db -> quote ( $ plugin [ 'userid' ] ) : "IS NULL" ) . " AND `language` = ?" , $ plugin [ 'language' ] ) ; } } else if ( ! empty ( $ this -> dict ) ) { $ this -> rc -> db -> query ( "INSERT INTO " . $ this -> rc -> db -> table_name ( 'dictionary' , true ) . " (`user_id`, `language`, `data`) VALUES (?, ?, ?)" , $ plugin [ 'userid' ] , $ plugin [ 'language' ] , implode ( ' ' , $ plugin [ 'dictionary' ] ) ) ; } }
Update dictionary row in DB
Update dictionary row in DB