Madden Stat Parser

Concluído Postado Feb 11, 2007 Pago na entrega
Concluído Pago na entrega

This is a more refined part to my Madden Stat import Project.

[url removed, login to view]

The programmer I had working on this did a very nice job and uses Php to import the Emails into the created game results database. The only problem is that the backend he created in php works fine on Emails I forward from [url removed, login to view] but does not work on Emails sent directly from Electionis Arts. He took the cut-n-paste I posted on GAF as the definitative format. THAT IS NOT THE FORMAT. I WILL FORWARD TOU THE EMAIL AND YOU WILL HAVE TO FIGURE OUT THE FORMAT AND THE BEST WAY TO PARSE THE EMAIL.

I need someone with good parsing skill either in Perl or PHP that can take the formated EA Game result emails (programmer is going to have to determine how they are delimitered and import them into the database.

The script needs to do the following;

Import Emails into the database as they come from EA in the Electronic Arts format.

Remove Duplicate Emails that are sent or forwarded so they don't get imported or deleted if they are imported.

Ignore Spam emails that might come into the account.

Be bulletproof so that corrupt or malformed emails do not corrupt the database.

Delete and save off processed Emails incase they are needed for future archive purposes.

Run as a CRON job automatically 2x an hour.

BELOW is a CUT-N-Paste from the Emails I get from EA. The format is a little different as the Cut-n-Paste formats them. So you are going to have to figure out how to seperate the data in the Email and get it into the database properly.

-Do not reply to this email-

Here are the official results of your Madden NFL 07 game on 2007.2.9-4:37:37.

WallyB [Level 9] vs WeaponX20 [Level 1]

Skill Points Lost: -45

Skill Points Needed For Next Level: 311

My Rank: 833

Opponent Rank: 7110

Mode: Ranked

Qtr Length: 5 minutes

Difficulty: All-Pro

Score breakdown:

1 2 3 4 OT F

WallyB 7 0 7 6 0 20

WeaponX20 7 7 7 7 0 28

Statistics WallyB WeaponX20

Rushing attempts for 18 31

Rushing yards for 241 192

Passing attempts for 18 10

Passing yards for 86 77

Punts 2 3

Field goals for 0 0

Long field goals (40+) for 0 0

Rushing touchdowns for 3 2

Passing touchdowns for 0 2

Returns touchdowns for 0 0

Defensive touchdowns for 0 0

Turnovers for 0 3

Interceptions for 2 0

Sacks for 2 1

Number of third downs 6 8

Third down conversions 4 5

No-huddle plays 3 0

Audibles called 10 0

Hot routes used 14 13

Shotgun plays 2 2

Blitzes 33 10

Time of possession 6:46 13:18

2-point conversions tried 0 0

2-point conversions succeeded 0 0

Red zone field goals 0 0

Red zone touchdowns 1 3

Red zone opportunities 3 3

First downs 11 13

First down yards 106 181

Special teams yards 140 92

Punt return yards 0 21

Punt yards 81 117

Penalties 0 0

Penalty yards 0 0

First down rushing plays 10 19

First down passing plays 9 3

Second down rushing plays 5 9

Second down passing plays 7 4

Third down rushing plays 3 3

Third down passing plays 3 5

Fourth down rushing plays 0 0

Fourth down passing plays 0 0

Passes completed 8 6

Fumbles 1 1

Fumbles recovered 0 1

Possessions 13 17

Third downs, 3 or less yards 1 2

Successes 1 2

Third downs, 4 to 9 yards 3 5

Successes 1 3

Third downs, 10 or more yards 2 1

Successes 2 0

Hurries 5 2

Knockdowns 1 0

Passes deflected 1 1

Passes tipped 0 0

Offensive yards 327 269

Total yards 467 361

Return yards 140 71

Total touchdowns 3 4

Perl

ID do Projeto: #124870

Sobre o projeto

2 propostas Projeto remoto Ativo em Feb 14, 2007

Concedido a:

leonardop

Looks like an interesting and fun project to do. I could do it in Perl or PHP; the parsing shouldn't be a problem in either. A little more detail would be very helpful, especially regarding the database schema, but Mais

$50 USD em 2 dias
(2 Comentários)
2.9

2 freelancers estão ofertando em média $75 nesse trabalho

Obercosmonaut

See PM. I am not trying to participate, just interesting.

$100 USD in 31 dias
(0 Comentários)
0.0