Idle Thoughts: WoW Macro Library
|gotta love those moths|
My research into WoW macros was to determine a max size. I had roughly remembered that macros had a 255 character limit (very visible in game, but not from the office). Hmm, in database terms, macros fields are strings; strings can be a maximum of 255 characters. <geek out>This leads me to believe, attached to your character table, is a macro table. The macro table has probably 5 fields (account id, character id, macro name, macro icon, macro code). Now, why would they want to setup a new table for each and every toon out there. No way, management overhead nightmare. They likely have a single table on each realm, that hosts all of the world of macros.</geek out>
WoW Armory Extension?
How about this? A web interface to that table, a veritable WoW Armory Code Repository. Using the player info, they could break down macros by toon types (Warlock: Destro, Aff, Demo). Macros could be weighted by popularity, or commented on (add categories). You like one, have it assigned to your account (take up a free macro slot). Macro get's updated, you can have the option of accepting changes, or not. From a technical perspective, unfortunately, this wouldn't be that easy to implement. Allowing you to assign a global macro to your account would require another layer of abstraction, i.e. another table. Another table per user would likely mean your account would increase in size, loading and performance on the backend servers increased.
OK, never mind. Global repository aside, I still would love to have a way to see everyone's macros. Yeah, I know about all those websites (wowmdb, wow
Is that out there already?