sqlite_fetch_all
Fetches everything into a file.
Syntax
$sqlite_fetch_all ( result, file [, delim = 9 ] )
Parameters
result
The result identifier.
file
The output filename.
delim
Optional. Delimiter in ASCII used to separate fields.
Return Value
1 on success or $null on error.
Remarks
$sqlite_fetch_all is useful for fetching everything into a single file if you wish to process it using a command such as /filter or /play through custom alias.Each line in the resulting fill will consist of a single row. All fields in the line are separated by delim, which is TAB by default. You can specify your own delimiter.
Because it's possible that the data for a field in a row can consist of unsafe characters that would mess up the rows/fields, mIRC SQLite encodes the special characters in the resulting file.
The characters that are encoded are: \ (backslash), \n (newline), \r (carriage return), \0 (null-byte, in binary data) and whatever delimiter is used. The characters are encoded as an escape sequence \xNN where NN is a two-digit hexadecimal number.
You can decode the data with $sqlite_safe_decode if you need to.