AIMySQL

AIMySQL is a logging plugin for Windows-based AIM clients that support OpenCC plugins.

It is a fast, lightweight database connector, allowing you to log your incoming and outgoing messages to a local or remote MySQL database.

 

History:

0.8 - 24/4/2008 ( Download )
Fixed clash with other plugins causing IMs to not be received correctly under some circumstances, removed need to restart under any client.
0.7 - 14/4/2008 ( Download )
Initial release

 

Potential Uses:

Whilst perhaps largely a plugin for advanced users and developers, there are many scenarios where being able to log information to a relational database may be useful:

Remote logging
Useful to synchronize data between logging on from seperate locations
Database logging
Useful for statistics or text search capabilities for larger volumes of messages
Bot logging
Useful for bot authors, the plugin may be used to store IMs in a database for later processing or statistical analysis (Original intent for the plugin)

System Requirements:

  • AIM6 or plugin-compatible AIM client
  • Microsoft .NET Framework 2.0
  • MySQL 5.0 or newer

Please note that for speed and reliability purposes, the plugin uses MySQL’s Connect/Net for database access, meaning it will only connect to MySQL systems.

If there is sufficient demand, a more general ODBC or ADO version may follow, however the widespread use and availability of MySQL, along with its open source nature and simple configuration, have lead to it being selected as the only option for the time being.

Configuration:

The plugin can be configured using a simple settings dialog, though a preferences file is also available:

  1. Download and install the plugin
  2. Open or restart AIM
  3. On loading, the plugin will open a settings dialog:
  4. Fill in the details of your server
  5. Enjoy!

The preferences file these options are stored in is named “aimysql-[screenname].xml” by default. It may be edited by hand if necessary, though it is not recommended.

Preferences:

The plugin uses the following preferences, registered as local with the AIM client:

aimcc.plugins.aimysql.host
(String)The host address of the MySQL server
aimcc.plugins.aimysql.dbname
(String)The name of the database to use
aimcc.plugins.aimysql.username
(String)The username of the MySQL user account
aimcc.plugins.aimysql.password
(String)The password of the MySQL user account
aimcc.plugins.aimysql.logincoming
(Boolean) Whether or not to log incoming IMs
aimcc.plugins.aimysql.logoutgoing
(Boolean) Whether or not to log outgoing IMs

Database:

The plugin will create a table in the provided database for each user who runs it, with the following fields:

id
The index/id number of the message
timestamp
The AIM timestamp of the message (Format: dd/mm/yyyy hh:mm AM)
from
The AOL screenname of the sender
to
The AOL screenname of the recipient
message
The text of the message body (HTML where applicable)

Details:

This plugin was developed in C# using Microsoft Visual Studio 2008.

It requires .NET 2.0 and runs on Windows-based platforms; no guarantee or warranty is provided whatsoever, but it has been tested and is known to operate under Windows XP SP2 and Windows Vista SP1 (32-bit and 64-bit)