Live EQ Search

Outline
Description::Pulling data live from the EQ server's MySQL database to be accessed publicly online.

Desired Applications

 * Character registry with name, class, level, and online status
 * Searching for info on mobs, items, merchants, and zones
 * Displaying server statistics such as patronage and hotzones

Layers
Web
 * Provides user friendly access to functionality
 * Utilizes parser functions to poll database and return html displayed in the wiki

Data
 * MySQL Everquest database from Angelox
 * Provides a link between the Application layer and Web layer
 * Auto complete for search boxes

Application
 * Use EQ Grounds Keeper to generate data tables with statistics which can be polled by web layer

Implementation
EQ Search

Character Pages
Each character on the server has a character page, such as EQ:Vith. Each character page can be a full normal article in addition to showing live character statistics automatically pulled from the server. The page does not need to have content edited to show a characters stats.

Parser Function
Special Types:
 * Search
 * filter = argument name (to pass to the url)
 * aux = target page (if different than the current)
 * Characters
 * no current use of filter or aux

General Types:

For general types, filter will auto convert to it's query string value if one is present, otherwise the filter name is used as the filter argument. aux is unused for general types.
 * mobs_by_item
 * drops_by_mob
 * merchants_by_item
 * items_by_merchant
 * zones_by_mob
 * mobs_by_zone