About this file
Overview
mIRC SQLite is an implementation of the SQLite library for mIRC. It requires mIRC version 6.2 or higher. It offers a flexible and easy-to-use API (Application Programming Interface) which is strongly inspired by the PHP's SQLite API. With mSQLite you can easily and quickly embed SQL to your mIRC scripts. It doesn't require a seperate process for SQL server nor complex configuration. The library IS the server. You just need to load the script and start coding.
1.3.0 - 18th August 2009
----------------------------
- Starting from this version mIRC SQLite will open databases and files from the directory specified by $mircdir by default (earlier it used the directory where $mircexe was in). Due to this change in mIRC installations where $mircexe is not in $mircdir, databases needs to be moved to $mircdir if the scripts open databases by using relative paths. The reason for this change was that the DLL wasn't consistent with mIRC's built-in aliases and identifiers, because they used different directory than mIRC SQLite.
- Updated SQLite to version 3.6.17. Upgrading is recommended.
- Updated PCRE to version 7.9.
- Added /sqlite_bind_null.
- Added $sqlite_fetch_num.
- Added $sqlite_fetch_assoc.
- Added $sqlite_fetch_all.
- Added $sqlite_safe_encode.
- Added $sqlite_safe_decode.
- Fixed $sqlite_fetch_bound fetching one byte too little when fetching non-binary data from an unbuffered query result into a binary variable.
- Fixed $sqlite_fetch_bound not returning $null when there's an error.
- Fixed $sqlite_fetch_bound not returning 0 when there's no more rows to fetch.
- Fixed $sqlite_bind_field not returning 1 on success.
- Fixed problems with passing binary data if there was a space in the temporary path used by Windows.
- Fixed "* /bread: invalid parameters" if trying to fetch binary data that is empty.
- Changed $sqlite_fetch_single and $sqlite_fetch_field return maximum string length from 900 bytes to 4096 bytes for mIRC versions 6.32+.
1.3.0 - 18th August 2009
----------------------------
- Starting from this version mIRC SQLite will open databases and files from the directory specified by $mircdir by default (earlier it used the directory where $mircexe was in). Due to this change in mIRC installations where $mircexe is not in $mircdir, databases needs to be moved to $mircdir if the scripts open databases by using relative paths. The reason for this change was that the DLL wasn't consistent with mIRC's built-in aliases and identifiers, because they used different directory than mIRC SQLite.
- Updated SQLite to version 3.6.17. Upgrading is recommended.
- Updated PCRE to version 7.9.
- Added /sqlite_bind_null.
- Added $sqlite_fetch_num.
- Added $sqlite_fetch_assoc.
- Added $sqlite_fetch_all.
- Added $sqlite_safe_encode.
- Added $sqlite_safe_decode.
- Fixed $sqlite_fetch_bound fetching one byte too little when fetching non-binary data from an unbuffered query result into a binary variable.
- Fixed $sqlite_fetch_bound not returning $null when there's an error.
- Fixed $sqlite_fetch_bound not returning 0 when there's no more rows to fetch.
- Fixed $sqlite_bind_field not returning 1 on success.
- Fixed problems with passing binary data if there was a space in the temporary path used by Windows.
- Fixed "* /bread: invalid parameters" if trying to fetch binary data that is empty.
- Changed $sqlite_fetch_single and $sqlite_fetch_field return maximum string length from 900 bytes to 4096 bytes for mIRC versions 6.32+.