===============================================================================================
= Contact                                                                                     =
===============================================================================================
This DLL was written by wshs (wshs@users.sourceforge.net).

     Bug reports: http://sourceforge.net/tracker/?atid=395520&group_id=29203&func=browse
Support requests: http://sourceforge.net/tracker/?atid=395521&group_id=29203&func=browse
Feature requests: http://sourceforge.net/tracker/?atid=395523&group_id=29203&func=browse

...official site which is half done: http://infiniti.sourceforge.net

===============================================================================================
= Installation                                                                                =
===============================================================================================
libmysql.dll must be placed in the same directory as mIRC's program.  mysql.dll can be placed
anywhere.


===============================================================================================
= Interpreting output                                                                         =
===============================================================================================
Except for the DLLInfo function, and bEscapeString, results will be output in the following
format:
  <a> <b> <c> [d]
Where a would be a 1 or 0, signifying success and failure, respectively, b would be the error
code number (see errors.txt), c would be the function name, and d would be any additional
information, as specified in the error code file.


===============================================================================================
= Formatting lines for use with mIRC                                                          =
===============================================================================================
Basically, mIRC doesn't like [], (), {}, or a comma inside of DLL calls, so you need to a var
to contain your query, and then call the query using the var, using the following lines as an
example:
   var %query = SELECT * FROM table1,table2 WHERE symbol LIKE "("
   echo -s $dll(mysql.dll,Query,example %query)


===============================================================================================
= Functions                                                                                   =
===============================================================================================

MySQL.dll,Connect,<LABEL> -hpuwdcs [HOST] [PORT] [USER] [PASS]

  Options:
     h - host is being specified
     p - port is being specified
     u - user is being specified
     w - pass is being specified
     d - database is being specified
     c - Use compression
     s - use SSL (encrypted connection)

  If HOST isn't supplied, localhost will be assumed.  No USER, root will be assumed.  For
  the PORT, 3306 will be assumed.  LABEL is the identifier you wish to give to this connection.
  The LABEL must be used for all concurrent queries involving this particular connection. No 2
  connections can have the same LABEL.   Optional parameters must appear in the order in which
  you specified the flags.  IE: If you specified -ep, you must specify database first, then the
  port number.


MySQL.dll,Query,<LABEL> -d [DB] <QUERY>

  LABEL is the label you used when calling the Connect command.  Use a standard MySQL query for
  QUERY.  If the -d flag is specified, then the default database will be changed to DB.


MySQL.dll,Rows,<LABEL>

  Will return the number of rows returned by Query.


MySQL.dll,RowsAffected,<LABEL>

  Will return the number of rows affected by a DELETE, UPDATE, or INSERT statement.  If the
  query was a SELECT statement, RowsAffected will return the same result as Rows.


MySQL.dll,FetchRow,<LABEL> <ROW> [SEPARATOR]

  Will return the row number specified by ROW, with data being separated by the character
  specified by SEPARATOR.  If SEPARATOR is not specified, a tab character will be assumed.


MySQL.dll,SetDatabase,<LABEL> <DATABASE>

  Sets the default database to use for queries to that particular connection.  Due to a bug
  in mIRC 6.x, it will be told by mIRC that the database is the full path to the dll, minus
  the first 4 characters, if you do not explicitly specify a database.  I am working on a
  temporary fix to this, but until I do, just use the function correctly, and you should
  have no problems.


MySQL.dll,Fields,<LABEL>

  Will return a comma delimited list of the field names returned by a Query.


MySQL.dll,EscapeString,<DATA>

  Escapes a string so that it may be used by the mysql server.


MySQL.dll,bEscapeString,<DATA>

  Does the same thing as EscapeString, but returns the parsed data only, to be used in a
  binary variable.


MySQL.dll,Labels,[n]

  If n is specified, and a positive number, the label matching that number will be returned.
  If n is 0, or not specified, the total number of labels will be returned.  If n is greater
  than the number of labels, an error will be returned.


MySQL.dll,Close,<LABEL>

  Closes the database connection.


MySQL.dll,ToBase64,<n>

  Converts a number, n, from base 10 to base 64, which consists of the following characters:
  ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789[]
  A would be 0, and ] would be 63.


MySQL.dll,ToBase10,<n>

  Converts a number, n, from base 64 to base 10.


MySQL.dll,Reverse,<TEXT>

  Reverses the specified text.

===============================================================================================
= Contributions                                                                               =
===============================================================================================
Much coding assistance was provided by nacitar, aka abaratican.  Props to him.  My only alpha
tester at the moment is xdxc.  God bless his uncanny ability to not kill me when his mIRC
crashed.  Thanks to the eggdrop coders for the base functions.  Translations of the
documentation into French, German, Danish, and Spanish are being done by various friends of
mine.  You know who you are, thanks.  Official beta testers are Mavric- and Gnome.  Good job.
Anyone else I forgot to mention?  If so, contact me asap, and I'll add you in for the next
release.

===============================================================================================
= Licensing/Legal                                                                             =
===============================================================================================
mIRC MySQL readme.txt
Copyright (C) 2000-2003 Michael Reynolds

This file is part of mIRC MySQL.

mIRC MySQL is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

mIRC MySQL is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with mIRC MySQL; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
