Afternoon all,

 

I'd like to try and set up a fantasy football league with some pals for the start of next season, however I don't have a clue where I would start. It would be web based and obviously database driven. Google has given me no help whatsoever, but I figure i've got until August to read up, learn and implement it!

 

Does anyone have any advice on where to start? Possibly some links that would help? Front end design i'm fine with, but anything to do with databases and/or indepth PHP is beyond my scope!

Afternoon all,

 

I'd like to try and set up a fantasy football league with some pals for the start of next season, however I don't have a clue where I would start. It would be web based and obviously database driven. Google has given me no help whatsoever, but I figure i've got until August to read up, learn and implement it!

 

Does anyone have any advice on where to start? Possibly some links that would help? Front end design i'm fine with, but anything to do with databases and/or indepth PHP is beyond my scope!

What type of things are u wanting to implement on the site?

I think it was bluedreamer who posted this link http://www.octavian.be/ofl/ might be useful

I'd like to implement something similar to what the Premier League Official game has - the ability to register users, hand out points for player starts, goals, deduct points for bookings/sending offs etc as well as listing all players in the division with each one given a price, maybe even include player stats (which could be pulled from somewhere?).

 

That sort of thing.

 

I appreciate it's a lot of work, but I like a challenge and would be a huge learning curve - jumping in the deep end so to speak.

 

I would ideally like to build it from scratch (call me a perfectionist!)

Does anybody have an further thoughts on this? I've noticed a few sites, but none that really give a clue on how to actually build one!

I'd better get learning then!

 

I think i've got a rough idea of what I need to do database wise, it's just plotting the best way of accomplishing it.

 

Hopefully it'll turn out to be something to be proud of - and useable!

 

Does anyone have any advice on where to start?

 

 

yeah, go to www.premierleague.com , its way easier

Just FYI it costs £4,120.00 + VAT to get a license to use premier league data in a fantasy football application. Per season.

Edited January 11, 201115 yr by Jock

I've made a start and just wondering if this is the correct way to go?

 

I've got a database called football (original, huh!) and a table called "player" with 6 fields, ID, name, club, position, value and points (image 1)

 

I've also created a very basic table in which to "upload" the player information to the database (see image 2)

 

Does this seem like the correct way to do it, or is there something fundamental that i'm missing?

Jock, where did you read that? Is that only applicable if the creator intends to charge for the game? I mean, this is only a bit of fun and no money will be made from it.

I've done work for some bookies before and I know that you need to pay to use any English or Scottish League data regardless if its for profit or not. If it for profit you need the betting license. http://www.football-dataco.com/licences/fantasy.htm?id=369 is the link to obtain a license.

 

If you made up your own fixtures/scores/results then I don't think you would need to pay for the license. Worth asking them before you continue anyway.

 

Anyway on to your DB schema, you need to rationalise your table. Teams would be in their own table, so would position, so a player would have the column team_id and position_id which would refer to the team & position tables. Then you would use the team table in every other table that needs teams, for example Fixtureswould be id | gameweek | home_team_id | away_team_id

 

You should try installing mysql workbench and try fleshing your schema out in that before going directly to phpmyadmin.

Thank you very much for the advice. I'll be looking at grabbing a download of mysql workbench later on and having a mess around with it.

if you want the users to be able to transfer players you'd need an individual column for each match week rather than overall score.

 

As mentioned before it shouldnt be dead hard, its just a case of a load of tables/databases.

Thanks Ric - Users would be able to transfer players in the real life transfer windows, so yeah, something like that would be need to be incorporated.

 

Would you guys mind having a quick look at the attached image? Am I on the right track? I'm trying to do as much reading as possible, but to be honest most of it isn't sticking yet.

Thanks Ric - Users would be able to transfer players in the real life transfer windows, so yeah, something like that would be need to be incorporated.

 

Would you guys mind having a quick look at the attached image? Am I on the right track? I'm trying to do as much reading as possible, but to be honest most of it isn't sticking yet.

 

Hi mate,

 

The first thing that jumps out at me is that you'll need two columns for team_id in your match table, one for the home team, one for the away team. You can then drop the ground_name column as this will be derived from the Team table.

 

I've had a quick stab at a schema for you in the attached file. The two primary key columns in the Players_For_Fixture table should also be Foreign Keys to their relevant tables.

 

 

Hope this helps to get you started. Good luck with it.

 

 

 

EDIT: - Have now uploaded a screen dump, for you mate. Not holding out much hope for the Hammers tonight tbh! :-)

Edited January 15, 201115 yr by LeeSalter

Y'know, it hadn't even occured to me about the home and away teams! I can understand now why people go on courses for this stuff!

 

I would be interested to see the schema you've put together though.

 

p.s - Good luck for later on (from a Gooner!)

Cheers Lee, that was a great help!

 

Sorry about the result btw lol

Cheers Lee, that was a great help!

 

Sorry about the result btw lol

 

 

Not as sorry as me mate! lol!

Sorry to drag up such an old thread, but I wondered if anyone would be able to help advise on something.

 

The game as a whole is making good prgress, however it's a little bland on the interactivity, it's mostly text with the odd image. What I would ideally like to do is add something similar to this, where when a player is selected, his shirt and name is automatically placed in his appropriate position on the field. How would I go about doing this? I've thought about the possibility of Ajax drag 'n drop, but are there any other methods?

 

At the moment, I have players sorted by team rather than position, so that is also something I need to accomplish.

 

I've had a brief look through the source, but couldn't pinpoint anything worthwhile.

Edited March 17, 201115 yr by MarkJenner

Hi Mark

 

I'm also creating a fantasy football competition. I am a 3rd year Multimedia student and it is an assignment for one of my units. The assignment requirements dictate that I use coldfusion with a Microsoft Access DB.

 

I have based it on our own A-League in Australia, foolishly thinking that a smaller league will be easier to create

 

Due to the restriction of time and talent I am currently focussing on the team selection process before the fixtures start. At the moment I have the following functionality:

• Member Registration
  
• Member Login
  
• Customised Team page based on Favourite Team Selection
  
• Trash Talk Forum (basic)
  

 

I have attached my DB relationship diagram. Hopefully this is correct and helps you out with your own project. Any thoughts?

My next step is to populate a team and join/create leagues. Any tips on how you have done this with your DB structure?

 

How are you travelling with your interactivity? My first thought for me was to use Flash, it which works well with coldfusion but thanks to Mr Jobs it won't work on Apple products...yet... so i'm trying to explore other techniques that I can use.

 

Cheers

Jay

Sorry to drag something randomly up.

 

I signed up to this site after reading this thread on a google search.

 

I am looking to follow the footsteps of the OP but was looking for some help on the issue and whether it would be worth it.

 

Budget is 'Okay' at best.

 

I wanted to see whether the licenses were actually true and if so how much they'd cost.

 

Thanks.