User:Dragonaire/Yapeal

Yapeal (Yet Another PHP Eve API Library) is an open source licensed PHP library designed to retrieve XML data from the Eve Online API and store it to a MySQL database.

Features
Some of the more important features:


 * Will automatic downloading data from API after being configured with user's information
 * Automatic updating of database tables using the data received from the API
 * Uses the cURL library to get the data from the API making it usably at most Internet hosting sites
 * Uses ADOdb (included) for all database access
 * Made to be ran from a crontab in Linux or Scheduled Task in Microsoft Windows
 * Runs from CLI for debugging or special needs
 * Uses the database to keep track of the API cachedUntil times so it is API friendly even when ran every minute from a crontab or Scheduled Task
 * Does optional local caching of the API's XML file
 * Easily used with multiple corporations and multiple characters on multiple user accounts by just adding their information to database tables

Platforms
Since the main code of Yapeal is programmed in PHP it could, in theory, be run on any platform where you can run PHP and have a local MySQL database available. It has been tested on openSuSE 10.3 and 11.1, and on Windows Vista. It has also been reported to ran on several other versions of Linux by users.

Licensing
The main code of Yapeal is using a GNU Lesser General Public License version 3 license with the ADOdb using a duel BSD and LGPL 2.1 license.

History
Yapeal has it's origins in another project called EMT that was made for Dragonaire's in game corporation Corax to help them manage their marketing and other corporation operations in Eve. After Dragonaire's corporation moved away from marketing and more into PvP she decided to continue development on the part of EMT that retrieved the XML data from the Eve API and stored the information into a MySQL database. This new project now named 'Yapeal' was originally hosted at SourceForge but soon moved over to Google Code because the developer felt managing projects over there was easier. The project has been in very active development ever since.