Welcome, Guest. Please login or register.
Did you miss your activation email? 		November 26, 2024, 10:47:24 am *

Login with username, password and session length

User

Welcome, Guest. Please login or register.
Did you miss your activation email?
November 26, 2024, 10:47:24 am

Login with username, password and session length

EZ Server Tools

EZ Server Downloads

Useful Links

Pages: [1]
« previous next »
Print
Author Topic: Tracking Character's Stuff  (Read 6118 times)
Camric
Full Member
***
Posts: 134


View Profile
« 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.
Logged
Fugitive
Legend
*******
Posts: 1807


TROLL KING


View Profile
« Reply #1 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..
Logged

Quoted for the Brotherhood of Warriors
"I want my wizard to cast Fugitives instead of fireballs.
We can't always get what we want. ;-)"
-Hate"
hateborne
Legend
*******
Posts: 2282


Don't nerf me bro!


View Profile
« Reply #2 on: October 19, 2012, 07:21:07 am »
If you need some one to handle the SQL backend, let me know gents.

-Hate
Logged
I'm so sorry Hunter, I tried...
Hunter
EZ Server GM
Legend
*******
Posts: 8100


EZ Server GM


View Profile
« Reply #3 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 Smiley
Logged
Hunter - EZ Server GM
Camric
Full Member
***
Posts: 134


View Profile
« Reply #4 on: October 19, 2012, 01:36:49 pm »
Quote from: hateborne on October 19, 2012, 07:21:07 am
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).
« Last Edit: October 19, 2012, 01:54:48 pm by Camric » Logged
Hunter
EZ Server GM
Legend
*******
Posts: 8100


EZ Server GM


View Profile
« Reply #5 on: October 19, 2012, 07:41:56 pm »
VB is easy Smiley
Logged
Hunter - EZ Server GM
Mixlor
Full Member
***
Posts: 165


View Profile
« Reply #6 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
Logged
Pages: [1]
Print
« previous next »
�
Jump to:  

Search

Recent

Stats

Members
  • Total Members: 6156
  • Latest: Rin1
Stats
  • Total Posts: 65127
  • Total Topics: 5066
  • Online Today: 370
  • Online Ever: 8678
  • (December 19, 2022, 02:32:09 pm)
Users Online
Users: 1
Guests: 322
Total: 323
TinyPortal v1.0 beta 4 © Bloc