Fix so identity fields are cast to string to prevent "Column X cannot be nu...

Aleksander Machniak

2014-03-30 8c783c0d66e9b7e2c27fce7beee2c07594bae3c4

Fix so identity fields are cast to string to prevent "Column X cannot be null" errors.

 plugins/virtuser_query/virtuser_query.php

@@ -70,13 +70,13 @@
            if (strpos($sql_arr[0], '@')) {
                if ($p['extended'] && count($sql_arr) > 1) {
                    $result[] = array(
                        'email'         => rcube_utils::idn_to_ascii($sql_arr[0]),
                        'name'          => $sql_arr[1],
                        'organization'  => $sql_arr[2],
                        'reply-to'      => rcube_utils::idn_to_ascii($sql_arr[3]),
                        'bcc'           => rcube_utils::idn_to_ascii($sql_arr[4]),
                        'signature'     => $sql_arr[5],
                        'html_signature' => (int)$sql_arr[6],
                        'email'          => rcube_utils::idn_to_ascii($sql_arr[0]),
                        'name'           => (string) $sql_arr[1],
                        'organization'   => (string) $sql_arr[2],
                        'reply-to'       => (string) rcube_utils::idn_to_ascii($sql_arr[3]),
                        'bcc'            => (string) rcube_utils::idn_to_ascii($sql_arr[4]),
                        'signature'      => (string) $sql_arr[5],
                        'html_signature' => (int) $sql_arr[6],
                    );
                }
                else {