Need MAJOR help..automating certain fields
HI all...
Not sure if this is the right place or not, if not, I apologize.
But what I want to do is create a site like a fantasy football site where stats are automatically calculated and automated.
If any of you are into Football and play a fantasy league online, then you know what I am talking about. such as Yahoo fantasy football, CBS sportsline, nfl.com, etc...
Their stats update automatically...You can do team transactions that update..say for instant you have X and want to drop X for Y......well if Y was not available it would tell you...if Y was available it would add him to your team and drop X.....
Does that make sense? Anyone see where Im going with this?
Thanks for all the help.
Jj
JeevesBond posted this at 11:54 — 30th August 2005.
He has: 3,956 posts
Joined: Jun 2002
So how is it working at the moment? Are you using any kind of server-side scripting or editing everything with HTML? If you are using server-side scripting what language and what RDBMS?
We know where you're going with this but need to clarify what you've got already and also what skill level you're at.
Welcome to the forums btw
a Padded Cell our articles site!
jp0509 posted this at 22:08 — 30th August 2005.
She has: 5 posts
Joined: Aug 2005
Sorry, I am doing everything (stats) by hand and just entering them in using simple html. I just wanted to see if I could have it automated.
I'm not really good on this kind of designing, so I don't know what I would be getting myself into let alone, what I would need to try.
Skill Level - I guess Newbie (I know Javascripting, some PHP and of course HTML)...
JeevesBond posted this at 22:46 — 30th August 2005.
He has: 3,956 posts
Joined: Jun 2002
Ok, thanks for that! The next questions are:
What server side scripting language(s) does your host support?
What RDBMS does your host support (e.g. MySQL, Microsoft SQL Server, Postgre etc)?
Preferably go for PHP (I can see you've learnt a little of this - that's good) and MySQL - it's the killer combination of the moment
The simple answer to your question is: "Yes." It just depends on how much you're willing to learn, this is going to get quite involved!
Out of interest have you drawn up any requirements for this new site? This could just be a quick list of what a user of the site will be able to do, no need to do anything too complex. This will give you the start of a roadmap, not only that, you'll be able to derive what you need to learn in order to develop the site.
a Padded Cell our articles site!
jp0509 posted this at 23:32 — 30th August 2005.
She has: 5 posts
Joined: Aug 2005
Wow, ok....
I am willing to learn whatever it takes to get it done. Just the kind of person I am. Whatever the easiest way to learn. I imagine it's not here...That would be alot of board space
As far as what my host offers, they offer PHP & MySQL (godaddy.com).
For the requirements, I hav not really thought about it yet since I was not sure if what I wanted could be done.
I guess what I invision is having a user create teams with players, and each week the system will add up the points for each player.
Now my question would be is this....Since I want the points added up from stats from the main football site (not sure we are allowed to say other site names, but highly popular football site)..Can I filter in those stats into my site or is that something I will have to do manually?
Sorry for all the questions and may seem ignorent, I have just not fooled with this part of designing yet. I have taught myself everything I know so far...well not myself, help of friends....I meant did not need school.. LOL
Thanks so much.
Jj
JeevesBond posted this at 12:53 — 3rd September 2005.
He has: 3,956 posts
Joined: Jun 2002
Don't worry about it, that's what we're here for! I've taken a while to reply to your post, so apologies for that
Have (finally!) managed to find a reasonable PHHP/MySQL tutorial, if this doesn't help then there are plenty of others around if you do a bit of searching: http://codewalkers.com/tutorials.php?show=9
Also invaluable references are:
PHP Web Site and
MySQL Documentation
In addition to that tutorial, you'll need to know a bit about:
You're correct, I can't just tell you everything you need to know, what you're embarking upon isn't an easy task and will take some time commitment!
Heh, depends upon the policy the site has, and whether they provide any easy/standard way of getting the results dynamically (also think about whether they're likely to change anything in their feed which could break your site before hacking around in their code, hence the need for a standards based way of getting the results). The best way to exchange this data is an XML Application of some description, there's no way of knowing whether they do produce this or would allow you to use it without looking and asking.
Hope this helps, and sorry I didn't reply sooner!
a Padded Cell our articles site!
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.