views:

93

answers:

3
+1  Q: 

Fantasy Draft Tool

I'm attempting to mitigate some of the fantasy football draft issues I've had the last few years by creating my own drafting tool. The major requirement, similar to the major draft tools out there (ESPN, Yahoo, CBS Sports, NFL, etc) is to allow people to log in and participate in the draft. I'd like for the draft to be started by an Admin, and be running regardless of if anyone else logs in or logs out, it just needs to run; draft status, draft clock, next team to choose.

I'm familiar with PHP and MySQL however, I'm not thinking this will be enough as I can't maintain the state of the draft using PHP...at least I don't think so to handle this. What would be the recommended avenues to pursue to handle the above requirement?

A: 

I just started writing one for kicks a few days ago using PHP, MySQL, and Ajax Push Engine (APE).

APE's site is down right now, but check it out when it's up: http://www.ape-project.org/

Tim Ridgely
So you handle the "draft" in MySQL and handle team on the clock and team on deck and past selections all in MySQL?
Seth
I store draft information in MySQL. This includes: user information, user assignment to each draft slot, and player selections.Clock information (countdown, next player on clock, etc.) is handled within APE. Additionally, whenever a player makes a selection, I have APE send a message to the "channel" to let all the clients update.
Tim Ridgely
That is pretty much what I am looking at doing. Seems like APE is a good option as it is prebuilt and allows for the communication between server and app that I require. Do you have plans of expanding the project outside of just a fun project?
Seth
A: 

I would suggest an outside process to run the draft itself. It would place the necessary data in the DB and PHP can be used to act on this data.

The major challenge would be the coordination between that outside process and PHP.

The outside process could be something like a perl script, which could be kicked off with a cron job.

George Marian
A: 

You can have realtime interaction without ajax by using websocket, i wrote a realtime app just like gchat with it, it's pretty realiable apart from flash requeriments.

Rodrigo