search

rothkj1022 / phppickem

PHP Pick 'Em is a free php web application that allows you to host a weekly NFL pick 'em football pool on your website.
MIT License
30 stars 57 forks source link

Schedule Refresh #36

Open oderuyter opened 7 years ago

oderuyter commented 7 years ago

Any clue how to get a schedule refresh between seasons?

canon2k5 commented 7 years ago

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 fornflp_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);`

oderuyter commented 7 years ago

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?

gregostrowski commented 7 years ago

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

oderuyter commented 7 years ago

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

jvdreamworker commented 7 years ago

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

elwerto commented 7 years ago

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);`

karynnglli commented 6 years ago

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

gregostrowski commented 6 years ago

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

karynnglli commented 6 years ago

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?

gregostrowski commented 6 years ago

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

karynnglli commented 6 years ago

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

gregostrowski commented 6 years ago

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

karynnglli commented 6 years ago

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!

searnhardt commented 6 years ago

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