I play video games that automatically email the end of the game statistics to my email. I would like to automatically have certain fields of this data parsed and inserted into a mysql database (Fields like the players name, skill points earned or loss, the result, total punches thrown, etc.) I would also like a webpage that displays the data in sortable columns. I'd like for this to be a wordpress plugin or i'd like for it to be integrated into my wordpress site. Below is an example of the text email that I receive:
EA Sports EA SPORTS٠FIGHT NIGHT CHAMPION
The EA Sports News
Ranked Match Scout Report
We hope you had a good game!
Below is the Scout Report from your last ranked match:
Blue Corner vs Red Corner
Name: deadfooot SportsGamer2010
Skill Level: 23 9
Country: United States United States
Result: Win Loss
Time: 1:149 1:149
Ranking Points Summary:
Current Skill Level: 23 9
Skill Points Earned: 26 -26
Knock Downs: 2 0
Total Punches Landed/Thrown: 65/111 41/73
Punch Connect%: 58% 56%
Total Jabs Landed/Thrown: 15/29 18/33
Jab Connect%: 51% 54%
Power Punches Landed/Thrown: 0/0 3/5
Power Punch Connect%: 0% 60%
Thanks for playing Fight Night Champion and good luck in your next match!
Make sure you receive your e-mail from EA! Add to your address book.
Please know that at EA, we don't want to send you information you don't want to receive. If you no longer want us to contact you, please click here to unsubscribe from our mailing list.
For this data base data will be received daily from different players so the fields will be the same but the data will be different. I'd like the data input into a database and for the name field if the name currently exist the data should be added (or subtracted) from the current data in the database or if the name doesn't exist it should be created. This will be a sports statistics database for the players that elect to forward the end of the game stats to the email that receives this. I am prepared to award this project immediately.
Once the stats are received they would be automatically processed and put into the database so that players can view the database and compare stats vs. other players.