phppickem icon indicating copy to clipboard operation
phppickem copied to clipboard

Published 20 hours ago • verified publisher icon rothkj1022

Schedule Refresh

Open oderuyter opened this issue 7 years ago • 14 comments

Any clue how to get a schedule refresh between seasons?

oderuyter avatar Jun 21 '17 08:06 oderuyter

This is what I did for the 2017 season. I cleaned out last years Pics, Pick Summary and Schedule and added this years schedule. I cheated a little bit. The Los Angeles Chargers is still "SD", but I renamed the team from San Diego Chargers to Los Angeles Chargers in the nflp_teams tables.

I hope this helps out someone, this has been a great game for the past few years for me, and I wanted to contribute something...

-- ---------------------------- -- Table structure for nflp_picks`

DROP TABLE IF EXISTS nflp_picks; CREATE TABLE nflp_picks ( userID int(11) NOT NULL, gameID int(11) NOT NULL, pickID varchar(10) NOT NULL, points int(11) NOT NULL DEFAULT '1', PRIMARY KEY (userID,gameID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Table structure for nflp_picksummary

DROP TABLE IF EXISTS nflp_picksummary; CREATE TABLE nflp_picksummary ( weekNum int(11) NOT NULL DEFAULT '0', userID int(11) NOT NULL DEFAULT '0', tieBreakerPoints int(11) NOT NULL DEFAULT '0', showPicks tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (weekNum,userID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- Table structure for nflp_schedule

DROP TABLE IF EXISTS nflp_schedule; CREATE TABLE nflp_schedule ( gameID int(11) NOT NULL AUTO_INCREMENT, weekNum int(11) NOT NULL, gameTimeEastern datetime DEFAULT NULL, homeID varchar(10) NOT NULL, homeScore int(11) DEFAULT NULL, visitorID varchar(10) NOT NULL, visitorScore int(11) DEFAULT NULL, overtime tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (gameID), KEY GameID (gameID), KEY HomeID (homeID), KEY VisitorID (visitorID) ) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Records of nflp_schedule

INSERT INTO nflp_schedule (gameID, weekNum, gameTimeEastern, homeID, homeScore, visitorID, visitorScore, overtime) VALUES (1, 1, '2017-09-07 20:30:00', 'NE', NULL, 'KC', NULL, 0), (2, 1, '2017-09-10 13:00:00', 'DET', NULL, 'ARI', NULL, 0), (3, 1, '2017-09-10 13:00:00', 'CHI', NULL, 'ATL', NULL, 0), (4, 1, '2017-09-10 13:00:00', 'CIN', NULL, 'BAL', NULL, 0), (5, 1, '2017-09-10 13:00:00', 'HOU', NULL, 'JAX', NULL, 0), (6, 1, '2017-09-10 13:00:00', 'BUF', NULL, 'NYJ', NULL, 0), (7, 1, '2017-09-10 13:00:00', 'TEN', NULL, 'OAK', NULL, 0), (8, 1, '2017-09-10 13:00:00', 'WAS', NULL, 'PHI', NULL, 0), (9, 1, '2017-09-10 13:00:00', 'CLE', NULL, 'PIT', NULL, 0), (10, 1, '2017-09-10 13:00:00', 'MIA', NULL, 'TB', NULL, 0), (11, 1, '2017-09-10 16:05:00', 'LA', NULL, 'IND', NULL, 0), (12, 1, '2017-09-10 16:25:00', 'SF', NULL, 'CAR', NULL, 0), (13, 1, '2017-09-10 16:25:00', 'GB', NULL, 'SEA', NULL, 0), (14, 1, '2017-09-10 20:30:00', 'DAL', NULL, 'NYG', NULL, 0), (15, 1, '2017-09-11 19:10:00', 'MIN', NULL, 'NO', NULL, 0), (16, 1, '2017-09-11 22:20:00', 'DEN', NULL, 'SD', NULL, 0), (17, 2, '2017-09-14 20:25:00', 'CIN', NULL, 'HOU', NULL, 0), (18, 2, '2017-09-17 13:00:00', 'IND', NULL, 'ARI', NULL, 0), (19, 2, '2017-09-17 13:00:00', 'CAR', NULL, 'BUF', NULL, 0), (20, 2, '2017-09-17 13:00:00', 'TB', NULL, 'CHI', NULL, 0), (21, 2, '2017-09-17 13:00:00', 'BAL', NULL, 'CLE', NULL, 0), (22, 2, '2017-09-17 13:00:00', 'PIT', NULL, 'MIN', NULL, 0), (23, 2, '2017-09-17 13:00:00', 'NO', NULL, 'NE', NULL, 0), (24, 2, '2017-09-17 13:00:00', 'KC', NULL, 'PHI', NULL, 0), (25, 2, '2017-09-17 13:00:00', 'JAX', NULL, 'TEN', NULL, 0), (26, 2, '2017-09-17 16:05:00', 'SD', NULL, 'MIA', NULL, 0), (27, 2, '2017-09-17 16:05:00', 'OAK', NULL, 'NYJ', NULL, 0), (28, 2, '2017-09-17 16:25:00', 'DEN', NULL, 'DAL', NULL, 0), (29, 2, '2017-09-17 16:25:00', 'SEA', NULL, 'SF', NULL, 0), (30, 2, '2017-09-17 16:25:00', 'LA', NULL, 'WAS', NULL, 0), (31, 2, '2017-09-17 20:30:00', 'ATL', NULL, 'GB', NULL, 0), (32, 2, '2017-09-18 20:30:00', 'NYG', NULL, 'DET', NULL, 0), (33, 3, '2017-09-21 20:25:00', 'SF', NULL, 'LA', NULL, 0), (34, 3, '2017-09-24 09:30:00', 'JAX', NULL, 'BAL', NULL, 0), (35, 3, '2017-09-24 13:00:00', 'DET', NULL, 'ATL', NULL, 0), (36, 3, '2017-09-24 13:00:00', 'IND', NULL, 'CLE', NULL, 0), (37, 3, '2017-09-24 13:00:00', 'BUF', NULL, 'DEN', NULL, 0), (38, 3, '2017-09-24 13:00:00', 'NE', NULL, 'HOU', NULL, 0), (39, 3, '2017-09-24 13:00:00', 'NYJ', NULL, 'MIA', NULL, 0), (40, 3, '2017-09-24 13:00:00', 'CAR', NULL, 'NO', NULL, 0), (41, 3, '2017-09-24 13:00:00', 'PHI', NULL, 'NYG', NULL, 0), (42, 3, '2017-09-24 13:00:00', 'CHI', NULL, 'PIT', NULL, 0), (43, 3, '2017-09-24 13:00:00', 'MIN', NULL, 'TB', NULL, 0), (44, 3, '2017-09-24 16:05:00', 'TEN', NULL, 'SEA', NULL, 0), (45, 3, '2017-09-24 16:25:00', 'GB', NULL, 'CIN', NULL, 0), (46, 3, '2017-09-24 16:25:00', 'SD', NULL, 'KC', NULL, 0), (47, 3, '2017-09-24 20:30:00', 'WAS', NULL, 'OAK', NULL, 0), (48, 3, '2017-09-25 20:30:00', 'ARI', NULL, 'DAL', NULL, 0), (49, 4, '2017-09-28 20:25:00', 'GB', NULL, 'CHI', NULL, 0), (50, 4, '2017-10-01 09:30:00', 'MIA', NULL, 'NO', NULL, 0), (51, 4, '2017-10-01 13:00:00', 'ATL', NULL, 'BUF', NULL, 0), (52, 4, '2017-10-01 13:00:00', 'NE', NULL, 'CAR', NULL, 0), (53, 4, '2017-10-01 13:00:00', 'CLE', NULL, 'CIN', NULL, 0), (54, 4, '2017-10-01 13:00:00', 'MIN', NULL, 'DET', NULL, 0), (55, 4, '2017-10-01 13:00:00', 'NYJ', NULL, 'JAX', NULL, 0), (56, 4, '2017-10-01 13:00:00', 'DAL', NULL, 'LA', NULL, 0), (57, 4, '2017-10-01 13:00:00', 'BAL', NULL, 'PIT', NULL, 0), (58, 4, '2017-10-01 13:00:00', 'HOU', NULL, 'TEN', NULL, 0), (59, 4, '2017-10-01 16:05:00', 'TB', NULL, 'NYG', NULL, 0), (60, 4, '2017-10-01 16:05:00', 'SD', NULL, 'PHI', NULL, 0), (61, 4, '2017-10-01 16:05:00', 'ARI', NULL, 'SF', NULL, 0), (62, 4, '2017-10-01 16:25:00', 'DEN', NULL, 'OAK', NULL, 0), (63, 4, '2017-10-01 20:30:00', 'SEA', NULL, 'IND', NULL, 0), (64, 4, '2017-10-02 20:30:00', 'KC', NULL, 'WAS', NULL, 0), (65, 5, '2017-10-05 20:25:00', 'TB', NULL, 'NE', NULL, 0), (66, 5, '2017-10-08 13:00:00', 'PHI', NULL, 'ARI', NULL, 0), (67, 5, '2017-10-08 13:00:00', 'CIN', NULL, 'BUF', NULL, 0), (68, 5, '2017-10-08 13:00:00', 'DET', NULL, 'CAR', NULL, 0), (69, 5, '2017-10-08 13:00:00', 'PIT', NULL, 'JAX', NULL, 0), (70, 5, '2017-10-08 13:00:00', 'NYG', NULL, 'SD', NULL, 0), (71, 5, '2017-10-08 13:00:00', 'CLE', NULL, 'NYJ', NULL, 0), (72, 5, '2017-10-08 13:00:00', 'IND', NULL, 'SF', NULL, 0), (73, 5, '2017-10-08 13:00:00', 'MIA', NULL, 'TEN', NULL, 0), (74, 5, '2017-10-08 16:05:00', 'OAK', NULL, 'BAL', NULL, 0), (75, 5, '2017-10-08 16:05:00', 'LA', NULL, 'SEA', NULL, 0), (76, 5, '2017-10-08 16:25:00', 'DAL', NULL, 'GB', NULL, 0), (77, 5, '2017-10-08 20:30:00', 'HOU', NULL, 'KC', NULL, 0), (78, 5, '2017-10-09 20:30:00', 'CHI', NULL, 'MIN', NULL, 0), (79, 6, '2017-10-12 20:25:00', 'CAR', NULL, 'PHI', NULL, 0), (80, 6, '2017-10-15 13:00:00', 'BAL', NULL, 'CHI', NULL, 0), (81, 6, '2017-10-15 13:00:00', 'HOU', NULL, 'CLE', NULL, 0), (82, 6, '2017-10-15 13:00:00', 'NO', NULL, 'DET', NULL, 0), (83, 6, '2017-10-15 13:00:00', 'MIN', NULL, 'GB', NULL, 0), (84, 6, '2017-10-15 13:00:00', 'ATL', NULL, 'MIA', NULL, 0), (85, 6, '2017-10-15 13:00:00', 'NYJ', NULL, 'NE', NULL, 0), (86, 6, '2017-10-15 13:00:00', 'WAS', NULL, 'SF', NULL, 0), (87, 6, '2017-10-15 16:05:00', 'JAX', NULL, 'LA', NULL, 0), (88, 6, '2017-10-15 16:05:00', 'ARI', NULL, 'TB', NULL, 0), (89, 6, '2017-10-15 16:25:00', 'OAK', NULL, 'SD', NULL, 0), (90, 6, '2017-10-15 16:25:00', 'KC', NULL, 'PIT', NULL, 0), (91, 6, '2017-10-15 20:30:00', 'DEN', NULL, 'NYG', NULL, 0), (92, 6, '2017-10-16 20:30:00', 'TEN', NULL, 'IND', NULL, 0), (93, 7, '2017-10-19 20:25:00', 'OAK', NULL, 'KC', NULL, 0), (94, 7, '2017-10-22 13:00:00', 'LA ', NULL, 'ARI', NULL, 0), (95, 7, '2017-10-22 13:00:00', 'MIN', NULL, 'BAL', NULL, 0), (96, 7, '2017-10-22 13:00:00', 'CHI', NULL, 'CAR', NULL, 0), (97, 7, '2017-10-22 13:00:00', 'PIT', NULL, 'CIN', NULL, 0), (98, 7, '2017-10-22 13:00:00', 'IND', NULL, 'JAX', NULL, 0), (99, 7, '2017-10-22 13:00:00', 'GB', NULL, 'NO', NULL, 0), (100, 7, '2017-10-22 13:00:00', 'MIA', NULL, 'NYJ', NULL, 0), (101, 7, '2017-10-22 13:00:00', 'BUF', NULL, 'TB', NULL, 0), (102, 7, '2017-10-22 13:00:00', 'CLE', NULL, 'TEN', NULL, 0), (103, 7, '2017-10-22 16:05:00', 'SF', NULL, 'DAL', NULL, 0), (104, 7, '2017-10-22 16:25:00', 'SD', NULL, 'DEN', NULL, 0), (105, 7, '2017-10-22 16:25:00', 'NYG', NULL, 'SEA', NULL, 0), (106, 7, '2017-10-22 20:30:00', 'NE', NULL, 'ATL', NULL, 0), (107, 7, '2017-10-23 20:30:00', 'PHI', NULL, 'WAS', NULL, 0), (108, 8, '2017-10-26 20:25:00', 'BAL', NULL, 'MIA', NULL, 0), (109, 8, '2017-10-29 09:30:00', 'CLE', NULL, 'MIN', NULL, 0), (110, 8, '2017-10-29 13:00:00', 'NYJ', NULL, 'ATL', NULL, 0), (111, 8, '2017-10-29 13:00:00', 'TB', NULL, 'CAR', NULL, 0), (112, 8, '2017-10-29 13:00:00', 'NO', NULL, 'CHI', NULL, 0), (113, 8, '2017-10-29 13:00:00', 'CIN', NULL, 'IND', NULL, 0), (114, 8, '2017-10-29 13:00:00', 'NE', NULL, 'SD', NULL, 0), (115, 8, '2017-10-29 13:00:00', 'BUF', NULL, 'OAK', NULL, 0), (116, 8, '2017-10-29 13:00:00', 'PHI', NULL, 'SF', NULL, 0), (117, 8, '2017-10-29 16:05:00', 'SEA', NULL, 'HOU', NULL, 0), (118, 8, '2017-10-29 16:25:00', 'WAS', NULL, 'DAL', NULL, 0), (119, 8, '2017-10-29 20:30:00', 'DET', NULL, 'PIT', NULL, 0), (120, 8, '2017-10-30 20:30:00', 'KC', NULL, 'DEN', NULL, 0), (121, 9, '2017-11-02 20:25:00', 'NYJ', NULL, 'BUF', NULL, 0), (122, 9, '2017-11-05 13:00:00', 'CAR', NULL, 'ATL', NULL, 0), (123, 9, '2017-11-05 13:00:00', 'TEN', NULL, 'BAL', NULL, 0), (124, 9, '2017-11-05 13:00:00', 'JAX', NULL, 'CIN', NULL, 0), (125, 9, '2017-11-05 13:00:00', 'PHI', NULL, 'DEN', NULL, 0), (126, 9, '2017-11-05 13:00:00', 'HOU', NULL, 'IND', NULL, 0), (127, 9, '2017-11-05 13:00:00', 'NYG', NULL, 'LA', NULL, 0), (128, 9, '2017-11-05 13:00:00', 'NO', NULL, 'TB', NULL, 0), (129, 9, '2017-11-05 16:05:00', 'SF', NULL, 'ARI', NULL, 0), (130, 9, '2017-11-05 16:05:00', 'SEA', NULL, 'WAS', NULL, 0), (131, 9, '2017-11-05 16:25:00', 'DAL', NULL, 'KC', NULL, 0), (132, 9, '2017-11-05 20:30:00', 'MIA', NULL, 'OAK', NULL, 0), (133, 9, '2017-11-06 20:30:00', 'GB', NULL, 'DET', NULL, 0), (134, 10, '2017-11-09 20:25:00', 'ARI', NULL, 'SEA', NULL, 0), (135, 10, '2017-11-12 13:00:00', 'TEN', NULL, 'CIN', NULL, 0), (136, 10, '2017-11-12 13:00:00', 'DET', NULL, 'CLE', NULL, 0), (137, 10, '2017-11-12 13:00:00', 'CHI', NULL, 'GB', NULL, 0), (138, 10, '2017-11-12 13:00:00', 'JAX', NULL, 'SD', NULL, 0), (139, 10, '2017-11-12 13:00:00', 'WAS', NULL, 'MIN', NULL, 0), (140, 10, '2017-11-12 13:00:00', 'BUF', NULL, 'NO', NULL, 0), (141, 10, '2017-11-12 13:00:00', 'TB', NULL, 'NYJ', NULL, 0), (142, 10, '2017-11-12 13:00:00', 'IND', NULL, 'PIT', NULL, 0), (143, 10, '2017-11-12 16:05:00', 'LA', NULL, 'HOU', NULL, 0), (144, 10, '2017-11-12 16:25:00', 'ATL', NULL, 'DAL', NULL, 0), (145, 10, '2017-11-12 16:25:00', 'SF', NULL, 'NYG', NULL, 0), (146, 10, '2017-11-12 20:30:00', 'DEN', NULL, 'NE', NULL, 0), (147, 10, '2017-11-13 20:30:00', 'CAR', NULL, 'MIA', NULL, 0), (148, 11, '2017-11-16 20:25:00', 'PIT', NULL, 'TEN', NULL, 0), (149, 11, '2017-11-19 13:00:00', 'HOU', NULL, 'ARI', NULL, 0), (150, 11, '2017-11-19 13:00:00', 'GB', NULL, 'BAL', NULL, 0), (151, 11, '2017-11-19 13:00:00', 'CHI', NULL, 'DET', NULL, 0), (152, 11, '2017-11-19 13:00:00', 'CLE', NULL, 'JAX', NULL, 0), (153, 11, '2017-11-19 13:00:00', 'NYG', NULL, 'KC', NULL, 0), (154, 11, '2017-11-19 13:00:00', 'MIN', NULL, 'LA', NULL, 0), (155, 11, '2017-11-19 13:00:00', 'NO', NULL, 'WAS', NULL, 0), (156, 11, '2017-11-19 16:05:00', 'SD', NULL, 'BUF', NULL, 0), (157, 11, '2017-11-19 16:25:00', 'DEN', NULL, 'CIN', NULL, 0), (158, 11, '2017-11-19 16:25:00', 'OAK', NULL, 'NE', NULL, 0), (159, 11, '2017-11-19 20:30:00', 'DAL', NULL, 'PHI', NULL, 0), (160, 11, '2017-11-20 20:30:00', 'SEA', NULL, 'ATL', NULL, 0), (161, 12, '2017-11-23 12:30:00', 'DET', NULL, 'MIN', NULL, 0), (162, 12, '2017-11-23 16:30:00', 'DAL', NULL, 'SD', NULL, 0), (163, 12, '2017-11-23 20:30:00', 'WAS', NULL, 'NYG', NULL, 0), (164, 12, '2017-11-26 13:00:00', 'KC', NULL, 'BUF', NULL, 0), (165, 12, '2017-11-26 13:00:00', 'NYJ', NULL, 'CAR', NULL, 0), (166, 12, '2017-11-26 13:00:00', 'PHI', NULL, 'CHI', NULL, 0), (167, 12, '2017-11-26 13:00:00', 'CIN', NULL, 'CLE', NULL, 0), (168, 12, '2017-11-26 13:00:00', 'NE', NULL, 'MIA', NULL, 0), (169, 12, '2017-11-26 13:00:00', 'ATL', NULL, 'TB', NULL, 0), (170, 12, '2017-11-26 13:00:00', 'IND', NULL, 'TEN', NULL, 0), (171, 12, '2017-11-26 16:05:00', 'LA', NULL, 'NO', NULL, 0), (172, 12, '2017-11-26 16:05:00', 'SF', NULL, 'SEA', NULL, 0), (173, 12, '2017-11-26 16:25:00', 'OAK', NULL, 'DEN', NULL, 0), (174, 12, '2017-11-26 16:25:00', 'ARI', NULL, 'JAX', NULL, 0), (175, 12, '2017-11-26 20:30:00', 'PIT', NULL, 'GB', NULL, 0), (176, 12, '2017-11-27 20:30:00', 'BAL', NULL, 'HOU', NULL, 0), (177, 13, '2017-11-30 20:25:00', 'DAL', NULL, 'WAS', NULL, 0), (178, 13, '2017-12-03 13:00:00', 'NO', NULL, 'CAR', NULL, 0), (179, 13, '2017-12-03 13:00:00', 'MIA', NULL, 'DEN', NULL, 0), (180, 13, '2017-12-03 13:00:00', 'BAL', NULL, 'DET', NULL, 0), (181, 13, '2017-12-03 13:00:00', 'TEN', NULL, 'HOU', NULL, 0), (182, 13, '2017-12-03 13:00:00', 'JAX', NULL, 'IND', NULL, 0), (183, 13, '2017-12-03 13:00:00', 'NYJ', NULL, 'KC', NULL, 0), (184, 13, '2017-12-03 13:00:00', 'ATL', NULL, 'MIN', NULL, 0), (185, 13, '2017-12-03 13:00:00', 'BUF', NULL, 'NE', NULL, 0), (186, 13, '2017-12-03 13:00:00', 'CHI', NULL, 'SF', NULL, 0), (187, 13, '2017-12-03 13:00:00', 'GB', NULL, 'TB', NULL, 0), (188, 13, '2017-12-03 16:05:00', 'SD', NULL, 'CLE', NULL, 0), (189, 13, '2017-12-03 16:25:00', 'ARI', NULL, 'LA', NULL, 0), (190, 13, '2017-12-03 16:25:00', 'OAK', NULL, 'NYG', NULL, 0), (191, 13, '2017-12-03 20:30:00', 'SEA', NULL, 'PHI', NULL, 0), (192, 13, '2017-12-04 20:30:00', 'CIN', NULL, 'PIT', NULL, 0), (193, 14, '2017-12-07 20:25:00', 'ATL', NULL, 'NO', NULL, 0), (194, 14, '2017-12-10 13:00:00', 'CIN', NULL, 'CHI', NULL, 0), (195, 14, '2017-12-10 13:00:00', 'TB', NULL, 'DET', NULL, 0), (196, 14, '2017-12-10 13:00:00', 'CLE', NULL, 'GB', NULL, 0), (197, 14, '2017-12-10 13:00:00', 'BUF', NULL, 'IND', NULL, 0), (198, 14, '2017-12-10 13:00:00', 'CAR', NULL, 'MIN', NULL, 0), (199, 14, '2017-12-10 13:00:00', 'KC', NULL, 'OAK', NULL, 0), (200, 14, '2017-12-10 13:00:00', 'HOU', NULL, 'SF', NULL, 0), (201, 14, '2017-12-10 13:00:00', 'JAX', NULL, 'SEA', NULL, 0), (202, 14, '2017-12-10 16:05:00', 'DEN', NULL, 'NYJ', NULL, 0), (203, 14, '2017-12-10 16:05:00', 'ARI', NULL, 'TEN', NULL, 0), (204, 14, '2017-12-10 16:05:00', 'SD', NULL, 'WAS', NULL, 0), (205, 14, '2017-12-10 16:25:00', 'NYG', NULL, 'DAL', NULL, 0), (206, 14, '2017-12-10 16:25:00', 'LA', NULL, 'PHI', NULL, 0), (207, 14, '2017-12-10 20:30:00', 'PIT', NULL, 'BAL', NULL, 0), (208, 14, '2017-12-11 20:30:00', 'MIA', NULL, 'NE', NULL, 0), (209, 15, '2017-12-14 20:25:00', 'IND', NULL, 'DEN', NULL, 0), (210, 15, '2017-12-16 16:30:00', 'DET', NULL, 'CHI', NULL, 0), (211, 15, '2017-12-16 20:25:00', 'KC', NULL, 'SD', NULL, 0), (212, 15, '2017-12-17 13:00:00', 'WAS', NULL, 'ARI', NULL, 0), (213, 15, '2017-12-17 13:00:00', 'CLE', NULL, 'BAL', NULL, 0), (214, 15, '2017-12-17 13:00:00', 'MIN', NULL, 'CIN', NULL, 0), (215, 15, '2017-12-17 13:00:00', 'CAR', NULL, 'GB', NULL, 0), (216, 15, '2017-12-17 13:00:00', 'JAX', NULL, 'HOU', NULL, 0), (217, 15, '2017-12-17 13:00:00', 'BUF', NULL, 'MIA', NULL, 0), (218, 15, '2017-12-17 13:00:00', 'NO', NULL, 'NYJ', NULL, 0), (219, 15, '2017-12-17 13:00:00', 'NYG', NULL, 'PHI', NULL, 0), (220, 15, '2017-12-17 16:05:00', 'SEA', NULL, 'LA', NULL, 0), (221, 15, '2017-12-17 16:25:00', 'PIT', NULL, 'NE', NULL, 0), (222, 15, '2017-12-17 16:25:00', 'SF', NULL, 'TEN', NULL, 0), (223, 15, '2017-12-17 20:30:00', 'OAK', NULL, 'DAL', NULL, 0), (224, 15, '2017-12-17 20:30:00', 'TB', NULL, 'ATL', NULL, 0), (225, 16, '2017-12-23 16:30:00', 'BAL', NULL, 'IND', NULL, 0), (226, 16, '2017-12-23 20:30:00', 'GB', NULL, 'MIN', NULL, 0), (227, 16, '2017-12-24 13:00:00', 'NO', NULL, 'ATL', NULL, 0), (228, 16, '2017-12-24 13:00:00', 'NE', NULL, 'BUF', NULL, 0), (229, 16, '2017-12-24 13:00:00', 'CHI', NULL, 'CLE', NULL, 0), (230, 16, '2017-12-24 13:00:00', 'WAS', NULL, 'DEN', NULL, 0), (231, 16, '2017-12-24 13:00:00', 'CIN', NULL, 'DET', NULL, 0), (232, 16, '2017-12-24 13:00:00', 'NYJ', NULL, 'SD', NULL, 0), (233, 16, '2017-12-24 13:00:00', 'TEN', NULL, 'LA', NULL, 0), (234, 16, '2017-12-24 13:00:00', 'KC', NULL, 'MIA', NULL, 0), (235, 16, '2017-12-24 13:00:00', 'CAR', NULL, 'TB', NULL, 0), (236, 16, '2017-12-24 16:05:00', 'SF', NULL, 'JAX', NULL, 0), (237, 16, '2017-12-24 16:25:00', 'ARI', NULL, 'NYG', NULL, 0), (238, 16, '2017-12-24 16:25:00', 'DAL', NULL, 'SEA', NULL, 0), (239, 16, '2017-12-25 16:30:00', 'HOU', NULL, 'PIT', NULL, 0), (240, 16, '2017-12-25 20:30:00', 'PHI', NULL, 'OAK', NULL, 0), (241, 17, '2017-12-31 13:00:00', 'MIA', NULL, 'BUF', NULL, 0), (242, 17, '2017-12-31 13:00:00', 'ATL', NULL, 'CAR', NULL, 0), (243, 17, '2017-12-31 13:00:00', 'MIN', NULL, 'CHI', NULL, 0), (244, 17, '2017-12-31 13:00:00', 'BAL', NULL, 'CIN', NULL, 0), (245, 17, '2017-12-31 13:00:00', 'PIT', NULL, 'CLE', NULL, 0), (246, 17, '2017-12-31 13:00:00', 'PHI', NULL, 'DAL', NULL, 0), (247, 17, '2017-12-31 13:00:00', 'DET', NULL, 'GB', NULL, 0), (248, 17, '2017-12-31 13:00:00', 'IND', NULL, 'HOU', NULL, 0), (249, 17, '2017-12-31 13:00:00', 'TEN', NULL, 'JAX', NULL, 0), (250, 17, '2017-12-31 13:00:00', 'TB', NULL, 'NO', NULL, 0), (251, 17, '2017-12-31 13:00:00', 'NE', NULL, 'NYJ', NULL, 0), (252, 17, '2017-12-31 13:00:00', 'NYG', NULL, 'WAS', NULL, 0), (253, 17, '2017-12-31 16:25:00', 'SEA', NULL, 'ARI', NULL, 0), (254, 17, '2017-12-31 16:25:00', 'DEN', NULL, 'KC', NULL, 0), (255, 17, '2017-12-31 16:25:00', 'SD', NULL, 'OAK', NULL, 0), (256, 17, '2017-12-31 16:25:00', 'LA', NULL, 'SF', NULL, 0);`

canon2k5 avatar Aug 04 '17 03:08 canon2k5

Well It worked :) Thanks

However little concerned that the "Load Scores option isn't going to work and I'm going to end up keying them all in every Monday morning - any ideas?

oderuyter avatar Aug 04 '17 10:08 oderuyter

Do we know what the new abbreviations will be for both LA teams? To avoid the manual conversion as @oderuyter mentioned, it might be better in the long run to update them.

Edit: Looks like its going to be 'LAR' for the rams, and now 'LAC' for the chargers

gregostrowski avatar Aug 06 '17 20:08 gregostrowski

@gregostrowski SD -> LAC - Chargers LA -> LAR - Rams Don't forget to change in the schedule script above and in the teams table

oderuyter avatar Aug 07 '17 07:08 oderuyter

Thanks for this @canon2k5 and everyone else who contributed...

jvdreamworker avatar Aug 21 '17 20:08 jvdreamworker

Here the full SQL script with the proper changes in the teams section:

`-- Table structure for nflp_teams DROP TABLE IF EXISTS nflp_teams; CREATE TABLE IF NOT EXISTS nflp_teams (

teamID varchar(10) NOT NULL,

divisionID int(11) NOT NULL,

city varchar(50) DEFAULT NULL,

team varchar(50) DEFAULT NULL,

displayName varchar(50) DEFAULT NULL,

PRIMARY KEY (teamID),

KEY ID (teamID)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Records of nflp_schedule

INSERT INTO nflp_teams (teamID, divisionID, city, team, displayName) VALUES

('ARI', 8, 'Arizona', 'Cardinals', NULL),

('ATL', 6, 'Atlanta', 'Falcons', NULL),

('BAL', 1, 'Baltimore', 'Ravens', NULL),

('BUF', 3, 'Buffalo', 'Bills', NULL),

('CAR', 6, 'Carolina', 'Panthers', NULL),

('CHI', 5, 'Chicago', 'Bears', NULL),

('CIN', 1, 'Cincinnati', 'Bengals', NULL),

('CLE', 1, 'Cleveland', 'Browns', NULL),

('DAL', 7, 'Dallas', 'Cowboys', NULL),

('DEN', 4, 'Denver', 'Broncos', NULL),

('DET', 5, 'Detroit', 'Lions', NULL),

('GB', 5, 'Green Bay', 'Packers', NULL),

('HOU', 2, 'Houston', 'Texans', NULL),

('IND', 2, 'Indianapolis', 'Colts', NULL),

('JAX', 2, 'Jacksonville', 'Jaguars', NULL),

('KC', 4, 'Kansas City', 'Chiefs', NULL),

('MIA', 3, 'Miami', 'Dolphins', NULL),

('MIN', 5, 'Minnesota', 'Vikings', NULL),

('NE', 3, 'New England', 'Patriots', NULL),

('NO', 6, 'New Orleans', 'Saints', NULL),

('NYG', 7, 'New York', 'Giants', 'NY Giants'),

('NYJ', 3, 'New York', 'Jets', 'NY Jets'),

('OAK', 4, 'Oakland', 'Raiders', NULL),

('PHI', 7, 'Philadelphia', 'Eagles', NULL),

('PIT', 1, 'Pittsburgh', 'Steelers', NULL),

('LAC', 4, 'Los Angeles', 'Chargers', NULL),

('SEA', 8, 'Seattle', 'Seahawks', NULL),

('SF', 8, 'San Francisco', '49ers', NULL),

('LAR', 8, 'Los Angeles', 'Rams', NULL),

('TB', 6, 'Tampa Bay', 'Buccaneers', NULL),

('TEN', 2, 'Tennessee', 'Titans', NULL),

('WAS', 7, 'Washington', 'Redskins', NULL);

-- Table structure for nflp_teams

DROP TABLE IF EXISTS nflp_picks; CREATE TABLE nflp_picks ( userID int(11) NOT NULL, gameID int(11) NOT NULL, pickID varchar(10) NOT NULL, points int(11) NOT NULL DEFAULT '1', PRIMARY KEY (userID,gameID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Table structure for nflp_picksummary

DROP TABLE IF EXISTS nflp_picksummary; CREATE TABLE nflp_picksummary ( weekNum int(11) NOT NULL DEFAULT '0', userID int(11) NOT NULL DEFAULT '0', tieBreakerPoints int(11) NOT NULL DEFAULT '0', showPicks tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (weekNum,userID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- Table structure for nflp_schedule

DROP TABLE IF EXISTS nflp_schedule; CREATE TABLE nflp_schedule ( gameID int(11) NOT NULL AUTO_INCREMENT, weekNum int(11) NOT NULL, gameTimeEastern datetime DEFAULT NULL, homeID varchar(10) NOT NULL, homeScore int(11) DEFAULT NULL, visitorID varchar(10) NOT NULL, visitorScore int(11) DEFAULT NULL, overtime tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (gameID), KEY GameID (gameID), KEY HomeID (homeID), KEY VisitorID (visitorID) ) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Records of nflp_schedule

INSERT INTO nflp_schedule (gameID, weekNum, gameTimeEastern, homeID, homeScore, visitorID, visitorScore, overtime) VALUES (1, 1, '2017-09-07 20:30:00', 'NE', NULL, 'KC', NULL, 0), (2, 1, '2017-09-10 13:00:00', 'DET', NULL, 'ARI', NULL, 0), (3, 1, '2017-09-10 13:00:00', 'CHI', NULL, 'ATL', NULL, 0), (4, 1, '2017-09-10 13:00:00', 'CIN', NULL, 'BAL', NULL, 0), (5, 1, '2017-09-10 13:00:00', 'HOU', NULL, 'JAX', NULL, 0), (6, 1, '2017-09-10 13:00:00', 'BUF', NULL, 'NYJ', NULL, 0), (7, 1, '2017-09-10 13:00:00', 'TEN', NULL, 'OAK', NULL, 0), (8, 1, '2017-09-10 13:00:00', 'WAS', NULL, 'PHI', NULL, 0), (9, 1, '2017-09-10 13:00:00', 'CLE', NULL, 'PIT', NULL, 0), (10, 1, '2017-09-10 13:00:00', 'MIA', NULL, 'TB', NULL, 0), (11, 1, '2017-09-10 16:05:00', 'LAR', NULL, 'IND', NULL, 0), (12, 1, '2017-09-10 16:25:00', 'SF', NULL, 'CAR', NULL, 0), (13, 1, '2017-09-10 16:25:00', 'GB', NULL, 'SEA', NULL, 0), (14, 1, '2017-09-10 20:30:00', 'DAL', NULL, 'NYG', NULL, 0), (15, 1, '2017-09-11 19:10:00', 'MIN', NULL, 'NO', NULL, 0), (16, 1, '2017-09-11 22:20:00', 'DEN', NULL, 'LAC', NULL, 0), (17, 2, '2017-09-14 20:25:00', 'CIN', NULL, 'HOU', NULL, 0), (18, 2, '2017-09-17 13:00:00', 'IND', NULL, 'ARI', NULL, 0), (19, 2, '2017-09-17 13:00:00', 'CAR', NULL, 'BUF', NULL, 0), (20, 2, '2017-09-17 13:00:00', 'TB', NULL, 'CHI', NULL, 0), (21, 2, '2017-09-17 13:00:00', 'BAL', NULL, 'CLE', NULL, 0), (22, 2, '2017-09-17 13:00:00', 'PIT', NULL, 'MIN', NULL, 0), (23, 2, '2017-09-17 13:00:00', 'NO', NULL, 'NE', NULL, 0), (24, 2, '2017-09-17 13:00:00', 'KC', NULL, 'PHI', NULL, 0), (25, 2, '2017-09-17 13:00:00', 'JAX', NULL, 'TEN', NULL, 0), (26, 2, '2017-09-17 16:05:00', 'LAC', NULL, 'MIA', NULL, 0), (27, 2, '2017-09-17 16:05:00', 'OAK', NULL, 'NYJ', NULL, 0), (28, 2, '2017-09-17 16:25:00', 'DEN', NULL, 'DAL', NULL, 0), (29, 2, '2017-09-17 16:25:00', 'SEA', NULL, 'SF', NULL, 0), (30, 2, '2017-09-17 16:25:00', 'LAR', NULL, 'WAS', NULL, 0), (31, 2, '2017-09-17 20:30:00', 'ATL', NULL, 'GB', NULL, 0), (32, 2, '2017-09-18 20:30:00', 'NYG', NULL, 'DET', NULL, 0), (33, 3, '2017-09-21 20:25:00', 'SF', NULL, 'LAR', NULL, 0), (34, 3, '2017-09-24 09:30:00', 'JAX', NULL, 'BAL', NULL, 0), (35, 3, '2017-09-24 13:00:00', 'DET', NULL, 'ATL', NULL, 0), (36, 3, '2017-09-24 13:00:00', 'IND', NULL, 'CLE', NULL, 0), (37, 3, '2017-09-24 13:00:00', 'BUF', NULL, 'DEN', NULL, 0), (38, 3, '2017-09-24 13:00:00', 'NE', NULL, 'HOU', NULL, 0), (39, 3, '2017-09-24 13:00:00', 'NYJ', NULL, 'MIA', NULL, 0), (40, 3, '2017-09-24 13:00:00', 'CAR', NULL, 'NO', NULL, 0), (41, 3, '2017-09-24 13:00:00', 'PHI', NULL, 'NYG', NULL, 0), (42, 3, '2017-09-24 13:00:00', 'CHI', NULL, 'PIT', NULL, 0), (43, 3, '2017-09-24 13:00:00', 'MIN', NULL, 'TB', NULL, 0), (44, 3, '2017-09-24 16:05:00', 'TEN', NULL, 'SEA', NULL, 0), (45, 3, '2017-09-24 16:25:00', 'GB', NULL, 'CIN', NULL, 0), (46, 3, '2017-09-24 16:25:00', 'LAC', NULL, 'KC', NULL, 0), (47, 3, '2017-09-24 20:30:00', 'WAS', NULL, 'OAK', NULL, 0), (48, 3, '2017-09-25 20:30:00', 'ARI', NULL, 'DAL', NULL, 0), (49, 4, '2017-09-28 20:25:00', 'GB', NULL, 'CHI', NULL, 0), (50, 4, '2017-10-01 09:30:00', 'MIA', NULL, 'NO', NULL, 0), (51, 4, '2017-10-01 13:00:00', 'ATL', NULL, 'BUF', NULL, 0), (52, 4, '2017-10-01 13:00:00', 'NE', NULL, 'CAR', NULL, 0), (53, 4, '2017-10-01 13:00:00', 'CLE', NULL, 'CIN', NULL, 0), (54, 4, '2017-10-01 13:00:00', 'MIN', NULL, 'DET', NULL, 0), (55, 4, '2017-10-01 13:00:00', 'NYJ', NULL, 'JAX', NULL, 0), (56, 4, '2017-10-01 13:00:00', 'DAL', NULL, 'LAR', NULL, 0), (57, 4, '2017-10-01 13:00:00', 'BAL', NULL, 'PIT', NULL, 0), (58, 4, '2017-10-01 13:00:00', 'HOU', NULL, 'TEN', NULL, 0), (59, 4, '2017-10-01 16:05:00', 'TB', NULL, 'NYG', NULL, 0), (60, 4, '2017-10-01 16:05:00', 'LAC', NULL, 'PHI', NULL, 0), (61, 4, '2017-10-01 16:05:00', 'ARI', NULL, 'SF', NULL, 0), (62, 4, '2017-10-01 16:25:00', 'DEN', NULL, 'OAK', NULL, 0), (63, 4, '2017-10-01 20:30:00', 'SEA', NULL, 'IND', NULL, 0), (64, 4, '2017-10-02 20:30:00', 'KC', NULL, 'WAS', NULL, 0), (65, 5, '2017-10-05 20:25:00', 'TB', NULL, 'NE', NULL, 0), (66, 5, '2017-10-08 13:00:00', 'PHI', NULL, 'ARI', NULL, 0), (67, 5, '2017-10-08 13:00:00', 'CIN', NULL, 'BUF', NULL, 0), (68, 5, '2017-10-08 13:00:00', 'DET', NULL, 'CAR', NULL, 0), (69, 5, '2017-10-08 13:00:00', 'PIT', NULL, 'JAX', NULL, 0), (70, 5, '2017-10-08 13:00:00', 'NYG', NULL, 'LAC', NULL, 0), (71, 5, '2017-10-08 13:00:00', 'CLE', NULL, 'NYJ', NULL, 0), (72, 5, '2017-10-08 13:00:00', 'IND', NULL, 'SF', NULL, 0), (73, 5, '2017-10-08 13:00:00', 'MIA', NULL, 'TEN', NULL, 0), (74, 5, '2017-10-08 16:05:00', 'OAK', NULL, 'BAL', NULL, 0), (75, 5, '2017-10-08 16:05:00', 'LAR', NULL, 'SEA', NULL, 0), (76, 5, '2017-10-08 16:25:00', 'DAL', NULL, 'GB', NULL, 0), (77, 5, '2017-10-08 20:30:00', 'HOU', NULL, 'KC', NULL, 0), (78, 5, '2017-10-09 20:30:00', 'CHI', NULL, 'MIN', NULL, 0), (79, 6, '2017-10-12 20:25:00', 'CAR', NULL, 'PHI', NULL, 0), (80, 6, '2017-10-15 13:00:00', 'BAL', NULL, 'CHI', NULL, 0), (81, 6, '2017-10-15 13:00:00', 'HOU', NULL, 'CLE', NULL, 0), (82, 6, '2017-10-15 13:00:00', 'NO', NULL, 'DET', NULL, 0), (83, 6, '2017-10-15 13:00:00', 'MIN', NULL, 'GB', NULL, 0), (84, 6, '2017-10-15 13:00:00', 'ATL', NULL, 'MIA', NULL, 0), (85, 6, '2017-10-15 13:00:00', 'NYJ', NULL, 'NE', NULL, 0), (86, 6, '2017-10-15 13:00:00', 'WAS', NULL, 'SF', NULL, 0), (87, 6, '2017-10-15 16:05:00', 'JAX', NULL, 'LAR', NULL, 0), (88, 6, '2017-10-15 16:05:00', 'ARI', NULL, 'TB', NULL, 0), (89, 6, '2017-10-15 16:25:00', 'OAK', NULL, 'LAC', NULL, 0), (90, 6, '2017-10-15 16:25:00', 'KC', NULL, 'PIT', NULL, 0), (91, 6, '2017-10-15 20:30:00', 'DEN', NULL, 'NYG', NULL, 0), (92, 6, '2017-10-16 20:30:00', 'TEN', NULL, 'IND', NULL, 0), (93, 7, '2017-10-19 20:25:00', 'OAK', NULL, 'KC', NULL, 0), (94, 7, '2017-10-22 13:00:00', 'LA ', NULL, 'ARI', NULL, 0), (95, 7, '2017-10-22 13:00:00', 'MIN', NULL, 'BAL', NULL, 0), (96, 7, '2017-10-22 13:00:00', 'CHI', NULL, 'CAR', NULL, 0), (97, 7, '2017-10-22 13:00:00', 'PIT', NULL, 'CIN', NULL, 0), (98, 7, '2017-10-22 13:00:00', 'IND', NULL, 'JAX', NULL, 0), (99, 7, '2017-10-22 13:00:00', 'GB', NULL, 'NO', NULL, 0), (100, 7, '2017-10-22 13:00:00', 'MIA', NULL, 'NYJ', NULL, 0), (101, 7, '2017-10-22 13:00:00', 'BUF', NULL, 'TB', NULL, 0), (102, 7, '2017-10-22 13:00:00', 'CLE', NULL, 'TEN', NULL, 0), (103, 7, '2017-10-22 16:05:00', 'SF', NULL, 'DAL', NULL, 0), (104, 7, '2017-10-22 16:25:00', 'LAC', NULL, 'DEN', NULL, 0), (105, 7, '2017-10-22 16:25:00', 'NYG', NULL, 'SEA', NULL, 0), (106, 7, '2017-10-22 20:30:00', 'NE', NULL, 'ATL', NULL, 0), (107, 7, '2017-10-23 20:30:00', 'PHI', NULL, 'WAS', NULL, 0), (108, 8, '2017-10-26 20:25:00', 'BAL', NULL, 'MIA', NULL, 0), (109, 8, '2017-10-29 09:30:00', 'CLE', NULL, 'MIN', NULL, 0), (110, 8, '2017-10-29 13:00:00', 'NYJ', NULL, 'ATL', NULL, 0), (111, 8, '2017-10-29 13:00:00', 'TB', NULL, 'CAR', NULL, 0), (112, 8, '2017-10-29 13:00:00', 'NO', NULL, 'CHI', NULL, 0), (113, 8, '2017-10-29 13:00:00', 'CIN', NULL, 'IND', NULL, 0), (114, 8, '2017-10-29 13:00:00', 'NE', NULL, 'LAC', NULL, 0), (115, 8, '2017-10-29 13:00:00', 'BUF', NULL, 'OAK', NULL, 0), (116, 8, '2017-10-29 13:00:00', 'PHI', NULL, 'SF', NULL, 0), (117, 8, '2017-10-29 16:05:00', 'SEA', NULL, 'HOU', NULL, 0), (118, 8, '2017-10-29 16:25:00', 'WAS', NULL, 'DAL', NULL, 0), (119, 8, '2017-10-29 20:30:00', 'DET', NULL, 'PIT', NULL, 0), (120, 8, '2017-10-30 20:30:00', 'KC', NULL, 'DEN', NULL, 0), (121, 9, '2017-11-02 20:25:00', 'NYJ', NULL, 'BUF', NULL, 0), (122, 9, '2017-11-05 13:00:00', 'CAR', NULL, 'ATL', NULL, 0), (123, 9, '2017-11-05 13:00:00', 'TEN', NULL, 'BAL', NULL, 0), (124, 9, '2017-11-05 13:00:00', 'JAX', NULL, 'CIN', NULL, 0), (125, 9, '2017-11-05 13:00:00', 'PHI', NULL, 'DEN', NULL, 0), (126, 9, '2017-11-05 13:00:00', 'HOU', NULL, 'IND', NULL, 0), (127, 9, '2017-11-05 13:00:00', 'NYG', NULL, 'LAR', NULL, 0), (128, 9, '2017-11-05 13:00:00', 'NO', NULL, 'TB', NULL, 0), (129, 9, '2017-11-05 16:05:00', 'SF', NULL, 'ARI', NULL, 0), (130, 9, '2017-11-05 16:05:00', 'SEA', NULL, 'WAS', NULL, 0), (131, 9, '2017-11-05 16:25:00', 'DAL', NULL, 'KC', NULL, 0), (132, 9, '2017-11-05 20:30:00', 'MIA', NULL, 'OAK', NULL, 0), (133, 9, '2017-11-06 20:30:00', 'GB', NULL, 'DET', NULL, 0), (134, 10, '2017-11-09 20:25:00', 'ARI', NULL, 'SEA', NULL, 0), (135, 10, '2017-11-12 13:00:00', 'TEN', NULL, 'CIN', NULL, 0), (136, 10, '2017-11-12 13:00:00', 'DET', NULL, 'CLE', NULL, 0), (137, 10, '2017-11-12 13:00:00', 'CHI', NULL, 'GB', NULL, 0), (138, 10, '2017-11-12 13:00:00', 'JAX', NULL, 'LAC', NULL, 0), (139, 10, '2017-11-12 13:00:00', 'WAS', NULL, 'MIN', NULL, 0), (140, 10, '2017-11-12 13:00:00', 'BUF', NULL, 'NO', NULL, 0), (141, 10, '2017-11-12 13:00:00', 'TB', NULL, 'NYJ', NULL, 0), (142, 10, '2017-11-12 13:00:00', 'IND', NULL, 'PIT', NULL, 0), (143, 10, '2017-11-12 16:05:00', 'LAR', NULL, 'HOU', NULL, 0), (144, 10, '2017-11-12 16:25:00', 'ATL', NULL, 'DAL', NULL, 0), (145, 10, '2017-11-12 16:25:00', 'SF', NULL, 'NYG', NULL, 0), (146, 10, '2017-11-12 20:30:00', 'DEN', NULL, 'NE', NULL, 0), (147, 10, '2017-11-13 20:30:00', 'CAR', NULL, 'MIA', NULL, 0), (148, 11, '2017-11-16 20:25:00', 'PIT', NULL, 'TEN', NULL, 0), (149, 11, '2017-11-19 13:00:00', 'HOU', NULL, 'ARI', NULL, 0), (150, 11, '2017-11-19 13:00:00', 'GB', NULL, 'BAL', NULL, 0), (151, 11, '2017-11-19 13:00:00', 'CHI', NULL, 'DET', NULL, 0), (152, 11, '2017-11-19 13:00:00', 'CLE', NULL, 'JAX', NULL, 0), (153, 11, '2017-11-19 13:00:00', 'NYG', NULL, 'KC', NULL, 0), (154, 11, '2017-11-19 13:00:00', 'MIN', NULL, 'LAR', NULL, 0), (155, 11, '2017-11-19 13:00:00', 'NO', NULL, 'WAS', NULL, 0), (156, 11, '2017-11-19 16:05:00', 'LAC', NULL, 'BUF', NULL, 0), (157, 11, '2017-11-19 16:25:00', 'DEN', NULL, 'CIN', NULL, 0), (158, 11, '2017-11-19 16:25:00', 'OAK', NULL, 'NE', NULL, 0), (159, 11, '2017-11-19 20:30:00', 'DAL', NULL, 'PHI', NULL, 0), (160, 11, '2017-11-20 20:30:00', 'SEA', NULL, 'ATL', NULL, 0), (161, 12, '2017-11-23 12:30:00', 'DET', NULL, 'MIN', NULL, 0), (162, 12, '2017-11-23 16:30:00', 'DAL', NULL, 'LAC', NULL, 0), (163, 12, '2017-11-23 20:30:00', 'WAS', NULL, 'NYG', NULL, 0), (164, 12, '2017-11-26 13:00:00', 'KC', NULL, 'BUF', NULL, 0), (165, 12, '2017-11-26 13:00:00', 'NYJ', NULL, 'CAR', NULL, 0), (166, 12, '2017-11-26 13:00:00', 'PHI', NULL, 'CHI', NULL, 0), (167, 12, '2017-11-26 13:00:00', 'CIN', NULL, 'CLE', NULL, 0), (168, 12, '2017-11-26 13:00:00', 'NE', NULL, 'MIA', NULL, 0), (169, 12, '2017-11-26 13:00:00', 'ATL', NULL, 'TB', NULL, 0), (170, 12, '2017-11-26 13:00:00', 'IND', NULL, 'TEN', NULL, 0), (171, 12, '2017-11-26 16:05:00', 'LAR', NULL, 'NO', NULL, 0), (172, 12, '2017-11-26 16:05:00', 'SF', NULL, 'SEA', NULL, 0), (173, 12, '2017-11-26 16:25:00', 'OAK', NULL, 'DEN', NULL, 0), (174, 12, '2017-11-26 16:25:00', 'ARI', NULL, 'JAX', NULL, 0), (175, 12, '2017-11-26 20:30:00', 'PIT', NULL, 'GB', NULL, 0), (176, 12, '2017-11-27 20:30:00', 'BAL', NULL, 'HOU', NULL, 0), (177, 13, '2017-11-30 20:25:00', 'DAL', NULL, 'WAS', NULL, 0), (178, 13, '2017-12-03 13:00:00', 'NO', NULL, 'CAR', NULL, 0), (179, 13, '2017-12-03 13:00:00', 'MIA', NULL, 'DEN', NULL, 0), (180, 13, '2017-12-03 13:00:00', 'BAL', NULL, 'DET', NULL, 0), (181, 13, '2017-12-03 13:00:00', 'TEN', NULL, 'HOU', NULL, 0), (182, 13, '2017-12-03 13:00:00', 'JAX', NULL, 'IND', NULL, 0), (183, 13, '2017-12-03 13:00:00', 'NYJ', NULL, 'KC', NULL, 0), (184, 13, '2017-12-03 13:00:00', 'ATL', NULL, 'MIN', NULL, 0), (185, 13, '2017-12-03 13:00:00', 'BUF', NULL, 'NE', NULL, 0), (186, 13, '2017-12-03 13:00:00', 'CHI', NULL, 'SF', NULL, 0), (187, 13, '2017-12-03 13:00:00', 'GB', NULL, 'TB', NULL, 0), (188, 13, '2017-12-03 16:05:00', 'LAC', NULL, 'CLE', NULL, 0), (189, 13, '2017-12-03 16:25:00', 'ARI', NULL, 'LAR', NULL, 0), (190, 13, '2017-12-03 16:25:00', 'OAK', NULL, 'NYG', NULL, 0), (191, 13, '2017-12-03 20:30:00', 'SEA', NULL, 'PHI', NULL, 0), (192, 13, '2017-12-04 20:30:00', 'CIN', NULL, 'PIT', NULL, 0), (193, 14, '2017-12-07 20:25:00', 'ATL', NULL, 'NO', NULL, 0), (194, 14, '2017-12-10 13:00:00', 'CIN', NULL, 'CHI', NULL, 0), (195, 14, '2017-12-10 13:00:00', 'TB', NULL, 'DET', NULL, 0), (196, 14, '2017-12-10 13:00:00', 'CLE', NULL, 'GB', NULL, 0), (197, 14, '2017-12-10 13:00:00', 'BUF', NULL, 'IND', NULL, 0), (198, 14, '2017-12-10 13:00:00', 'CAR', NULL, 'MIN', NULL, 0), (199, 14, '2017-12-10 13:00:00', 'KC', NULL, 'OAK', NULL, 0), (200, 14, '2017-12-10 13:00:00', 'HOU', NULL, 'SF', NULL, 0), (201, 14, '2017-12-10 13:00:00', 'JAX', NULL, 'SEA', NULL, 0), (202, 14, '2017-12-10 16:05:00', 'DEN', NULL, 'NYJ', NULL, 0), (203, 14, '2017-12-10 16:05:00', 'ARI', NULL, 'TEN', NULL, 0), (204, 14, '2017-12-10 16:05:00', 'LAC', NULL, 'WAS', NULL, 0), (205, 14, '2017-12-10 16:25:00', 'NYG', NULL, 'DAL', NULL, 0), (206, 14, '2017-12-10 16:25:00', 'LAR', NULL, 'PHI', NULL, 0), (207, 14, '2017-12-10 20:30:00', 'PIT', NULL, 'BAL', NULL, 0), (208, 14, '2017-12-11 20:30:00', 'MIA', NULL, 'NE', NULL, 0), (209, 15, '2017-12-14 20:25:00', 'IND', NULL, 'DEN', NULL, 0), (210, 15, '2017-12-16 16:30:00', 'DET', NULL, 'CHI', NULL, 0), (211, 15, '2017-12-16 20:25:00', 'KC', NULL, 'LAC', NULL, 0), (212, 15, '2017-12-17 13:00:00', 'WAS', NULL, 'ARI', NULL, 0), (213, 15, '2017-12-17 13:00:00', 'CLE', NULL, 'BAL', NULL, 0), (214, 15, '2017-12-17 13:00:00', 'MIN', NULL, 'CIN', NULL, 0), (215, 15, '2017-12-17 13:00:00', 'CAR', NULL, 'GB', NULL, 0), (216, 15, '2017-12-17 13:00:00', 'JAX', NULL, 'HOU', NULL, 0), (217, 15, '2017-12-17 13:00:00', 'BUF', NULL, 'MIA', NULL, 0), (218, 15, '2017-12-17 13:00:00', 'NO', NULL, 'NYJ', NULL, 0), (219, 15, '2017-12-17 13:00:00', 'NYG', NULL, 'PHI', NULL, 0), (220, 15, '2017-12-17 16:05:00', 'SEA', NULL, 'LAR', NULL, 0), (221, 15, '2017-12-17 16:25:00', 'PIT', NULL, 'NE', NULL, 0), (222, 15, '2017-12-17 16:25:00', 'SF', NULL, 'TEN', NULL, 0), (223, 15, '2017-12-17 20:30:00', 'OAK', NULL, 'DAL', NULL, 0), (224, 15, '2017-12-17 20:30:00', 'TB', NULL, 'ATL', NULL, 0), (225, 16, '2017-12-23 16:30:00', 'BAL', NULL, 'IND', NULL, 0), (226, 16, '2017-12-23 20:30:00', 'GB', NULL, 'MIN', NULL, 0), (227, 16, '2017-12-24 13:00:00', 'NO', NULL, 'ATL', NULL, 0), (228, 16, '2017-12-24 13:00:00', 'NE', NULL, 'BUF', NULL, 0), (229, 16, '2017-12-24 13:00:00', 'CHI', NULL, 'CLE', NULL, 0), (230, 16, '2017-12-24 13:00:00', 'WAS', NULL, 'DEN', NULL, 0), (231, 16, '2017-12-24 13:00:00', 'CIN', NULL, 'DET', NULL, 0), (232, 16, '2017-12-24 13:00:00', 'NYJ', NULL, 'LAC', NULL, 0), (233, 16, '2017-12-24 13:00:00', 'TEN', NULL, 'LAR', NULL, 0), (234, 16, '2017-12-24 13:00:00', 'KC', NULL, 'MIA', NULL, 0), (235, 16, '2017-12-24 13:00:00', 'CAR', NULL, 'TB', NULL, 0), (236, 16, '2017-12-24 16:05:00', 'SF', NULL, 'JAX', NULL, 0), (237, 16, '2017-12-24 16:25:00', 'ARI', NULL, 'NYG', NULL, 0), (238, 16, '2017-12-24 16:25:00', 'DAL', NULL, 'SEA', NULL, 0), (239, 16, '2017-12-25 16:30:00', 'HOU', NULL, 'PIT', NULL, 0), (240, 16, '2017-12-25 20:30:00', 'PHI', NULL, 'OAK', NULL, 0), (241, 17, '2017-12-31 13:00:00', 'MIA', NULL, 'BUF', NULL, 0), (242, 17, '2017-12-31 13:00:00', 'ATL', NULL, 'CAR', NULL, 0), (243, 17, '2017-12-31 13:00:00', 'MIN', NULL, 'CHI', NULL, 0), (244, 17, '2017-12-31 13:00:00', 'BAL', NULL, 'CIN', NULL, 0), (245, 17, '2017-12-31 13:00:00', 'PIT', NULL, 'CLE', NULL, 0), (246, 17, '2017-12-31 13:00:00', 'PHI', NULL, 'DAL', NULL, 0), (247, 17, '2017-12-31 13:00:00', 'DET', NULL, 'GB', NULL, 0), (248, 17, '2017-12-31 13:00:00', 'IND', NULL, 'HOU', NULL, 0), (249, 17, '2017-12-31 13:00:00', 'TEN', NULL, 'JAX', NULL, 0), (250, 17, '2017-12-31 13:00:00', 'TB', NULL, 'NO', NULL, 0), (251, 17, '2017-12-31 13:00:00', 'NE', NULL, 'NYJ', NULL, 0), (252, 17, '2017-12-31 13:00:00', 'NYG', NULL, 'WAS', NULL, 0), (253, 17, '2017-12-31 16:25:00', 'SEA', NULL, 'ARI', NULL, 0), (254, 17, '2017-12-31 16:25:00', 'DEN', NULL, 'KC', NULL, 0), (255, 17, '2017-12-31 16:25:00', 'LAC', NULL, 'OAK', NULL, 0), (256, 17, '2017-12-31 16:25:00', 'LAR', NULL, 'SF', NULL, 0);`

elwerto avatar Aug 28 '17 22:08 elwerto

Hi everyone,

I would like to continue with PHP Pick Em and creating the install.sql for every new season. I was wondering how you populate all of the dates that they teams play (in the Records of nflp_schedule section) and if there is a way of auto generating that so one could copy it into the new install.sql file?

Thank you, Karynn

karynnglli avatar Aug 09 '18 23:08 karynnglli

The short answer is you will need to drop your picks and schedule tables of last years data and upload this years schedule into the schedule table.

Attached is a file with the 2018 schedule. You might need to update LA to LAR since the Rams are now labeled as LAR (same as last year).

2018_NFL_Schedule_SQL.txt

gregostrowski avatar Aug 10 '18 00:08 gregostrowski

Hi gregostrowski,

Thank you for posting the new 2018 schedule for the "install" process.

Yes, I understand and know how to drop my picks and schedule tables of last years data and upload the 2018 year schedule (that you most graciously provided, again thank you) into the schedule table.

HOWEVER, I would like to know who to make the 2018_NFL_Schedule_SQL.txt that you posted, and specifically, generating the "Records of nflp_schedule" section.

The reason why I want to know how to make that is in case I have to make the new season's schedule, and know one else knows how. Would you be able to help me with that, please, by offering some insights?

karynnglli avatar Aug 10 '18 01:08 karynnglli

Sorry, I don't have a good answer for you. I found the schedule already made on another pickem site that has forums.

gregostrowski avatar Aug 10 '18 01:08 gregostrowski

Ah, thank you. Can I ask you where you got it from and how, then?

karynnglli avatar Aug 10 '18 01:08 karynnglli

http://nflpickemscript.com make an account to view the forums

gregostrowski avatar Aug 10 '18 01:08 gregostrowski

Again, thank you for the information. I will do so. I still want to figure out how to create my own script for the future, but still, this is an awesome place to start. I really appreciate all of you help, gregostrowski!

karynnglli avatar Aug 10 '18 01:08 karynnglli

I found at least one problem with the previous file so I redid it, manually / Excel. Anyway, here's my version of the file. If you find errors, definitely let me know. In the file from above, CHI is playing in game ID 197 and also 200 in the same week. It seemed like there were a few other problems, but I can't remember. 2018_NFL_Schedule_SQL_20180826.txt

searnhardt avatar Aug 27 '18 03:08 searnhardt