|
Title: Tracking Character's Stuff Post by: Camric on October 18, 2012, 09:01:58 pm I just wanted to see if anyone has done something similar with the hope of sharing some ideas. Skyte and I have developed a database to track all of our characters and their associated gear, bag inventory, and bank spaces. With more than 30 characters combined, tracking the data in excel was laborious and painful to maintain.
Thus the idea to build a MySQL database solution integrated with macroquest to push the data from the everquest client. The solution currently captures the following for each character: • All slot armor • Charm • Weapons • All bag inventory • All bank inventory • T5 quest mob flags • Platinum With the data loaded, questions like the following can be asked: • How much platinum do I have cross all characters? • How many essences of each type and on which character? • Which character does not have a Halloween pet? • Which T5 flag mobs are my characters missing? The next steps to improve the solution would include: • Reporting gui that doesn’t require SQL knowledge. • Packaged queries that can be executed from within Everquest to answer questions specific to that character or others. • Incorporate the other tasks flags (i.e. fighter/caster guild, UC v2) If you have done something similar please share your experience. Title: Re: Tracking Character's Stuff Post by: Fugitive on October 18, 2012, 10:05:25 pm nerdz...
Just kidding, sent ya Email about this =D I'll see ya in Houston in a few weeks.. Title: Re: Tracking Character's Stuff Post by: hateborne on October 19, 2012, 07:21:07 am If you need some one to handle the SQL backend, let me know gents.
-Hate Title: Re: Tracking Character's Stuff Post by: Hunter on October 19, 2012, 07:49:27 am Yeah, Hate is good for that stuff.
Hey Hate, drop me an email, I got a minor request for a MYSQL Query, need something a bit complicated here but the code shouldn't be too long :) Title: Re: Tracking Character's Stuff Post by: Camric on October 19, 2012, 01:36:49 pm If you need some one to handle the SQL backend, let me know gents. -Hate Thanks Hate - the sql is pretty straight forward as there's only a handful of tables. I did create a few stored procedures to simplify the interface between MacroQuest and the database. The biggest challenges was the plug-in and .dll that handles the database connection. Do you have any recommendations for a reporting tool for MySQL? I'd like to use something that is out of the box and configurable. Otherwise, It will be a Java interface using JFreeCharts and other reporting API(s). Title: Re: Tracking Character's Stuff Post by: Hunter on October 19, 2012, 07:41:56 pm VB is easy :)
Title: Re: Tracking Character's Stuff Post by: Mixlor on October 21, 2012, 02:17:17 pm I am right there with you Cam... gonna be a nightmare looking thru 17 toons trying to figure out where they are at with what. Excel spreadsheet, pen and paper.. time wasted when I should be playing.
Mix |