WoW_ConnectMMO_Addon

Addon (mod) in LUA for data exchange between a game client and a database through XML. The addon must feed the game client based on a lua file according to XML standards generated by a third application (the third party application and the database are not in the scope of this particular project: they are being developed separately). It must also generate an output lua file according to XML standards file with information from the game characters in order for the third application to read and import this information to a SQL Server database. The addon must interact with the game client calendar interface inserting events from a XML file. The addon must notify the used about the time proximity to a scheduled event. ## Deliverables **Necessary knowledge:** • Lua language • MVC and UML based system analysis • Advanced XML Read and Write • SQL Server 2005, especially procedures and functions; • Notions of Java or any other object-oriented language • Be able to work with third party APIs, such as: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL](API) **Expected profile** At least 4 years developing applications, no necessarily in LUA, with any interaction (import/export) with XML files. Advanced knowledge of interpreted non-compiled languages; Desirable knowledge of application development in embedded applications, half-embedded applications and low level applications. **Description of the Project Summary** Addon (mod) in LUA for data exchange between a game client and a database through XML. The addon must feed the game client based on a lua file according to XML standards generated by a third application (the third party application and the database are not in the scope of this particular project: they are being developed separately). It must also generate an output lua file according to XML standards file with information from the game characters in order for the third application to read and import this information to a SQL Server database. The addon must interact with the game client calendar interface inserting events from a XML file. The addon must notify the used about the time proximity to a scheduled event. **Functions First part: data export** When the player logs in and then off from the one of the characters, client, the addon must collect the information mentioned below and save it in a lua file according to XML standards. - The addon must gather and save in file the following data: o All character data from character tabs (including Name, Level, Race, Class, Health, Power, Professions and their level, Base Statistics (each individually), Melee Statistics (each individually), Ranged Statistics (each individually), Spell Statistics (each individually), Defense Statistics (each individually)) o Achievement Points o Lifetime Kills o Arena Statistics (Team, Bracket, Ratio, Rating) o All Spells o Talent points (primary and secondary, indicating which is current) o Glyphs (primary and secondary, indicating which is current) o All professional recipes o Money o Items in bags o All quests character is in (including name, type, if it is a group quest the number of characters suggested, reward, minimum level, orange level, yellow level, green level and gray level) o Raid IDs o Guild and rank o Friends If data not exist, the add-on must generate blanks fields in XML file. This data will be used by a third party application to transfer the data to a SQL database. (the third party application and the database are not in the scope of this particular project: they are being developed separately). Each time there is a log in and log off from a particular character in the game client, the data regarding that particular character in the lua file is updated. The third party application will be run by the player only after the World of Warcraft client is closed. **Second part: scheduled events import and event interface and notification** The third party application will be run by the player before World of Warcraft is started. At this point, the third party application will save in a lua file according to XML standards data regarding events. After the third party application is closed, player will run the game client. When player logs in a particular character, the addon will insert in the game calendar information regarding the scheduled events. The information regarding scheduled events includes: · type of event (ex. Raid) · subtype of even (ex. Ulduar Heroic) · scheduled time to start · scheduled time to finish · vacancies and names of players who filled the vacancies · event creator name · private to friends (yes or no) · private to guild (yes or no) If it is a trade event: · buy or sell · item or service · item or service name · scheduled time to start · scheduled time to finish · event creator name · other player in the trade · my materials or your materials · price in gold, silver and copper When an even approaches (15, 10, 5, 4, 3, 2 and 1 minutes before the event), user must be notified in the screen about the event with basic event data. In addon options, user can turn of notification, change the format and time of notification and other functions of the addon. The user must be able to chose when to be notified, and between a warning sound, a flash in the screen or a pop up window. **Addons that might be used as base:** - Group calendar (for the notifications) - Ackis recipe list (for recipes) - Altoholic (for items and money) - RPGO Character profile (for character data) **Basis function flows** 1. User runs third party application and closes it 2. Game is started by user 3. User accesses character 4. Addon initiates the capture of character information 5. Addon inserts information in the game from the lua file according XML standards generated by the third application (including events in the calendar interface) 6. Addon notifies user about the proximity of scheduled events 7. Game is closed by user 8. Addon saves all the captured information in a file 9. Game client is completely exited 10. User runs third party application **Responsibility of LUA programmer** 1. Develop the addon exclusively in LUA; 2. Game has a prevent hack system that verifies all addons that run with the game to prevent cheats and, therefore, the addon must be in conformity with the rules and good practices of Blizzard Entertainment, Inc. and the user (player) must risk being blocked or banned in any way and the addon itself must not be blocked; 3. Develop the technical specification of the addon , user guide, f.a.q., etc. and addition information as may be required for IP documentation. * * *This broadcast message was sent to all bidders on Friday May 15, 2009 2:08:25 PM: Hello bidders, I have updated the project descriptions. Now it is complete. All the scope is now covered. I will soon post an exemple of a XML file with mock event schedules that the addon must read. Best regards, Mmog Og