Building DKP Addon with Web-based PHP Database access
For someone who doesn't know crap about LUA or the WoW UI this sounds like it's going to be a headache and a half, but It's part of an on-going project to make guild life easier on everyone that my guild has taken up. What we hope to achieve here is a web-based system for the guild master and raid organizers to use that will track the players' DKP. The players will install an addon that will simply display their current DKP by loading a LUA file from the web server. This LUA file is actually a PHP script that accesses the database and exports the information into variables that the addon will access to show the player's current DKP available.
Eventually we would like to have this system working with an in-game addon that would allow the raid organizer to enter a username/password to authenticate with the web API and allow them to award DKP to every player in the raid automatically without the need to type in the names to add DKP for the raid. This interface would also allow them to subtract DKP for misbehavior, purchased items, etc.
All-in-all what we are after is a method to make DKP real-time. You shouldn't have to tab out or keep a scratchpad with your DKP on it for heavy raiding guilds. Nor should the leaders of the guild need to spend a couple hours a night managing the DKP system. We're hoping that once this system is built that guilds across all realms will find it to be one of those "necessity" addons that you can't live without.
I program PHP for a living so I'm very up-to-speed on the basics of coding/scripting etc, but I have to admit that LUA is friggin confusing the crap out of me here. I've read all these tutorials and whatnot, but I can't find the simple info I need to start with this addon. All we need is a little box, or text area under the player portrait in the upper-left that can have it's text set to the content of a variable which is loaded from an LUA script on the webserver. Not a very complicated addon, but I can't even find the information on how variables are defined in LUA. I've tried to code it in the wow UI designer program and I just don't know what to do lol. I've opened every addon I have and can't seem to find anything that would be a variable with a value assigned to it, so I'm at a complete loss here.
I guess I'm just hoping someone here could give me a clue as to where I should start here... I've been to the wiki and all the links in the tutorials and read every forum I can, but I'm just not finding what I need. If someone has a few spare minutes to throw up an XML and LUA script that would just show me how to set a variable, then use the data in the variable to populate the text field in the XML layout I think I could manage from there as far as this part goes. When it comes to the adding buttons and login info *runs and hides*
This is for the good of all guilds if we can get it working, so please don't think I'm going to selfishly um.. horde.. the code for myself and my guild (sorry for the bad pun lol). Any help would be appreciated by myself and all who use this DKP management system in time!