 |
phpffl.com
phpFFL - Fantasy Football League Manager
|
| View previous topic :: View next topic |
| Author |
Message |
orangekid
Joined: 16 Sep 2006
Posts: 174
|
 Posted: Mon Jan 04, 2010 9:37 am Post subject: Hey Dano---Post Season Stats? |
 |
|
Just wondering if you will be running stats for the post season this year?
OK I'll beg, please, please, please  |
|
| Back to top |
|
 |
bobster-65
Joined: 05 Sep 2008
Posts: 33
|
| Posted: Tue Jan 05, 2010 4:40 pm Post subject: Re: Hey Dano---Post Season Stats? |
|
|
| orangekid wrote: | Just wondering if you will be running stats for the post season this year?
OK I'll beg, please, please, please |
hey, you beat me to it this year 
btw, I chatted with Dano yesterday. He said it was doable and just to remind him later in the week via PM. |
|
| Back to top |
|
|
dab-5
Joined: 08 Jan 2010
Posts: 2
|
| Posted: Fri Jan 08, 2010 4:51 pm Post subject: how do I make the post season a new season |
|
|
| I want to run a playoof league. I created a new league added all the teams and scoring, but how do I get it to download the schedule, and make it ralize this is a new seaason...week 1 shows games for sept...or should it be week 18. |
|
| Back to top |
|
|
orangekid
Joined: 16 Sep 2006
Posts: 174
|
| Posted: Fri Jan 08, 2010 5:30 pm Post subject: Re: how do I make the post season a new season |
|
|
| dab-5 wrote: | | I want to run a playoof league. I created a new league added all the teams and scoring, but how do I get it to download the schedule, and make it ralize this is a new seaason...week 1 shows games for sept...or should it be week 18. |
This week would be week 18. you'll have to find this function in
program_files/global/functions/global_functions.php
function get_number_weeks_season()
{
//replace with dynamic code when nfl_schedules table is setup
return 17;
}
function get_number_games_season()
{
//replace with dynamic code when nfl_schedules table is setup
return 17;
}
and change both 17 to something like 21 if you are going to pull stats all the way through the superbowl.
then the games have to be manually added to your data base.
i'll try to pull an SQL later from my DB and post it for you.
each week the games will have to be added as they are set up.
then it is just a matter of pulling the stats either fron the automated scripts under admin or run a cron or task schedular depending on the OS you use. |
|
| Back to top |
|
|
orangekid
Joined: 16 Sep 2006
Posts: 174
|
| Posted: Fri Jan 08, 2010 5:39 pm Post subject: |
|
|
I see Dano has the feed all set for this weekend, THANKS< DANO  i'll double check mine and post back later. |
|
| Back to top |
|
|
orangekid
Joined: 16 Sep 2006
Posts: 174
|
| Posted: Fri Jan 08, 2010 7:45 pm Post subject: |
|
|
Here is a DB dump for you to get this weeks games in your DB.
Be sure to change the "database" to the name that you use
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 08, 2010 at 06:31 PM
-- Server version: 5.1.37
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `INSERT YOUR DB NAME HERE`
--
-- --------------------------------------------------------
--
-- Table structure for table `league_schedules`
--
CREATE TABLE IF NOT EXISTS `league_schedules` (
`ID` varchar(20) NOT NULL DEFAULT 'yyyymmdd_AWY@HOM',
`seasonID` varchar(8) NOT NULL DEFAULT 'yyyy',
`week` tinyint(2) unsigned NOT NULL DEFAULT '0',
`kickoff` time NOT NULL DEFAULT '00:00:00',
`status` varchar(15) NOT NULL DEFAULT 'Scheduled',
`awayscore` tinyint(3) unsigned NOT NULL DEFAULT '0',
`homescore` tinyint(3) unsigned NOT NULL DEFAULT '0',
`gamedata` text,
`dataparser` varchar(50) NOT NULL DEFAULT '',
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`game_date` datetime DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `seasonID` (`seasonID`),
KEY `kickoff` (`kickoff`),
KEY `status` (`status`),
KEY `week_gamedate` (`week`,`game_date`),
KEY `week_ID` (`week`,`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `league_schedules`
--
INSERT INTO `league_schedules` (`ID`, `seasonID`, `week`, `kickoff`, `status`, `awayscore`, `homescore`, `gamedata`, `dataparser`, `modified`, `game_date`) VALUES
('20100109_NYJ@CIN', '2009', 18, '16:30:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-09 16:30:00'),
('20100109_PHI@DAL', '2009', 18, '20:00:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-09 20:00:00'),
('20100110_BAL@NE', '2009', 18, '13:00:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-10 13:00:00'),
('20100110_GB@ARI', '2009', 18, '16:40:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-10 16:40:00'); |
|
| Back to top |
|
|
bobster-65
Joined: 05 Sep 2008
Posts: 33
|
| Posted: Sat Jan 09, 2010 6:21 pm Post subject: |
|
|
Working like a charm Dano!! Thank you again for taking time to run Post Season Stats!!  |
|
| Back to top |
|
|
dab-5
Joined: 08 Jan 2010
Posts: 2
|
| Posted: Tue Jan 12, 2010 8:15 am Post subject: |
|
|
| thanks orangekid, thanks everyone, worked great, when is week 2 normally available |
|
| Back to top |
|
|
El-Chupacabra
Joined: 05 Jun 2008
Posts: 209
Location: FL, USA
|
| Posted: Tue Jan 12, 2010 10:20 am Post subject: |
|
|
| dab-5 wrote: | | thanks orangekid, thanks everyone, worked great, when is week 2 normally available |
I believe we have to manually update the schedule ourselves:
| Code: |
INSERT INTO `league_schedules` (`ID`, `seasonID`, `week`, `kickoff`, `status`, `awayscore`, `homescore`, `gamedata`, `dataparser`, `modified`, `game_date`) VALUES
('20100116_ARI@NO', '2009', 19, '16:30:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-16 16:30:00'),
('20100116_BAL@IND', '2009', 19, '20:15:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-16 20:15:00'),
('20100117_DAL@MIN', '2009', 19, '13:00:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-17 13:00:00'),
('20100117_NYJ@SD', '2009', 19, '16:40:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-17 16:40:00');
|
_________________
My "hacks":
|
|
| Back to top |
|
|
orangekid
Joined: 16 Sep 2006
Posts: 174
|
| Posted: Wed Jan 13, 2010 6:48 pm Post subject: |
|
|
Yes we'll have to update all the game schedules ourselves.
I forgot that the pro-bowl is b4 the Superbowl this year.......so there will be 22 weeks to the season to get through the Superbowl this year. |
|
| Back to top |
|
|
bobster-65
Joined: 05 Sep 2008
Posts: 33
|
| Posted: Mon Jan 18, 2010 10:19 am Post subject: |
|
|
another flawless post season weekend!
Huge Thank You to Dano for doing this!!! |
|
| Back to top |
|
|
El-Chupacabra
Joined: 05 Jun 2008
Posts: 209
Location: FL, USA
|
| Posted: Tue Jan 19, 2010 12:01 pm Post subject: |
|
|
Week 20, NFL Playoff's Championship Round:
| Code: |
INSERT INTO `league_schedules` (`ID`, `seasonID`, `week`, `kickoff`, `status`, `awayscore`, `homescore`, `gamedata`, `dataparser`, `modified`, `game_date`) VALUES
('20100124_MIN@NO', '2009', 20, '15:00:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-24 15:00:00'),
('20100124_NYJ@IND', '2009', 20, '18:40:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-24 18:40:00');
|
_________________
My "hacks":
|
|
| Back to top |
|
|
orangekid
Joined: 16 Sep 2006
Posts: 174
|
| Posted: Tue Jan 26, 2010 6:13 pm Post subject: |
|
|
INSERT INTO `league_schedules` (`ID`, `seasonID`, `week`, `kickoff`, `status`, `awayscore`, `homescore`, `gamedata`, `dataparser`, `modified`, `game_date`) VALUES
('20100131_AFC@NFC', '2009', 21, '19:20:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-01-31 19:20:00'),
('20100207_NO@IND', '2009', 22, '18:25:00', 'Scheduled', 0, 0, '', '', '2009-08-09 14:11:22', '2010-02-07 18:25:00');
That should be it for the year then !!! |
|
| Back to top |
|
|
orangekid
Joined: 16 Sep 2006
Posts: 174
|
| Posted: Sat Feb 06, 2010 11:04 pm Post subject: |
|
|
Anybody talk to Dano about pulling stats for the Superbowl?
I sent him a PM but haven't heard anything  |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
