Yes, allowing people to access my MySQL db would be a VERY bad thing.
What i (
www.feds201.com) will be doing is this: We will allow people to upload/download data in both XML and CSV. This way, teams will be able to use MS Excel or Notepad to edit/view their CSV file. And... anyone who would prefer to use XML (also websites sync-ing data) would use XML. Once again: It won't be stored in a 'flat-file'. I'll have a script that you would call (ex: xmlteamdata.php ) which would then output/download the XML file to your computer.
Here are a few of my ideas in regards to Event Data:
HP: 1 stack, 2 stack, 3 stack, 4 stack
AP: Nothing, Under bar to defend, search and distroy stacks, knock down wall (If they do go to knock down the wall, we should have a field saying if they knocked it down first, or if the other alliance knocked it down first)
CP: Defended stacks, stacked bins, knocked down stacks, stole bins, sat on platform, little/nothing
For Robot Data:
Traction on Carpet: 1-5
Traction on Ramp: 1-5
Traction on Platform: 1-5
Max bins that can stack (In a game): 0-29
Go under bar: y/n
Speed: 1-5
Drive System: Wheels, treads, swerve drive, (***)
Steal stacks: y/n
Senors: Stack && || Line
Main AP action: See AP list above
Main CP action: See CP list above
These are just a few of my first ideas.