Euro Championships

@strophe18

Could you be so nice and paste here also data form table ‘*_wcup_match’
Once you have all the dates set, it would be much easier to import on my website.
Thank you in advance

DaFone

@Dafon,
no problem:

NSERT INTO yourname_wcup_match (match_id, match_no, kickoff, home_team_id, away_team_id, home_goals, away_goals, home_penalties, away_penalties, venue_id, is_result, extra_time, stage_id, scored, wwhen) VALUES
(1, 1, ‘2016-06-10 19:00:00’, 2, 3, 0, 0, 0, 0, 8, 0, 0, 1, 1, ‘2016-04-30 09:38:29’),
(2, 2, ‘2016-06-11 13:00:00’, 1, 5, 0, 0, 0, 0, 3, 0, 0, 1, 1, ‘2016-04-30 09:38:38’),
(3, 4, ‘2016-06-11 16:00:00’, 9, 8, 0, 0, 0, 0, 2, 0, 0, 6, 1, ‘2016-04-30 09:38:57’),
(4, 3, ‘2016-06-11 19:00:00’, 6, 7, 0, 0, 0, 0, 6, 0, 0, 6, 1, ‘2016-04-30 09:38:48’),
(5, 5, ‘2016-06-12 13:00:00’, 17, 14, 0, 0, 0, 0, 1, 0, 0, 8, 1, ‘2016-04-30 09:39:05’),
(6, 6, ‘2016-06-12 16:00:00’, 12, 11, 0, 0, 0, 0, 7, 0, 0, 7, 1, ‘2016-04-30 09:39:12’),
(7, 7, ‘2016-06-12 19:00:00’, 10, 13, 0, 0, 0, 0, 4, 0, 0, 7, 1, ‘2016-04-30 09:39:27’),
(8, 8, ‘2016-06-13 13:00:00’, 16, 15, 0, 0, 0, 0, 10, 0, 0, 8, 1, ‘2016-04-30 09:39:37’),
(9, 9, ‘2016-06-13 16:00:00’, 20, 21, 0, 0, 0, 0, 8, 0, 0, 9, 1, ‘2016-04-30 09:39:48’),
(10, 10, ‘2016-06-13 19:00:00’, 18, 19, 0, 0, 0, 0, 5, 0, 0, 9, 1, ‘2016-04-30 09:39:57’),
(11, 11, ‘2016-06-14 16:00:00’, 22, 23, 0, 0, 0, 0, 2, 0, 0, 12, 1, ‘2016-04-30 09:40:05’),
(12, 12, ‘2016-06-14 19:00:00’, 25, 24, 0, 0, 0, 0, 9, 0, 0, 12, 1, ‘2016-04-30 09:40:15’);

Don’t forget to change “yourname” with your own name.

@strophe18

Thanks a lot !!

Still under construction, but here is my site:
https://dafone.pl/euro2016/

Cheers

OK, here are all 36 matches from group stage.
Enjoy ??

INSERT INTO ‘YOURNAME_wcup_match’ (‘match_id’, ‘match_no’, ‘kickoff’, home_team_id’, ‘away_team_id’, ‘home_goals’, ‘away_goals’, ‘home_penalties’, ‘away_penalties’, ‘venue_id’, ‘is_result’, ‘extra_time’, ‘stage_id’, ‘scored’, ‘wwhen’) VALUES
(1, 1, ‘2016-06-10 19:00:00’, 2, 3, 0, 0, 0, 0, 8, 0, 0, 1, 1, ‘2016-04-30 07:38:29’),
(2, 2, ‘2016-06-11 13:00:00’, 1, 5, 0, 0, 0, 0, 3, 0, 0, 1, 1, ‘2016-04-30 07:38:38’),
(3, 4, ‘2016-06-11 16:00:00’, 9, 8, 0, 0, 0, 0, 2, 0, 0, 6, 1, ‘2016-04-30 07:38:57’),
(4, 3, ‘2016-06-11 19:00:00’, 6, 7, 0, 0, 0, 0, 6, 0, 0, 6, 1, ‘2016-04-30 07:38:48’),
(5, 5, ‘2016-06-12 13:00:00’, 17, 14, 0, 0, 0, 0, 1, 0, 0, 8, 1, ‘2016-04-30 07:39:05’),
(6, 6, ‘2016-06-12 16:00:00’, 12, 11, 0, 0, 0, 0, 7, 0, 0, 7, 1, ‘2016-04-30 07:39:12’),
(7, 7, ‘2016-06-12 19:00:00’, 10, 13, 0, 0, 0, 0, 4, 0, 0, 7, 1, ‘2016-04-30 07:39:27’),
(8, 8, ‘2016-06-13 13:00:00’, 16, 15, 0, 0, 0, 0, 10, 0, 0, 8, 1, ‘2016-04-30 07:39:37’),
(9, 9, ‘2016-06-13 16:00:00’, 20, 21, 0, 0, 0, 0, 8, 0, 0, 9, 1, ‘2016-04-30 07:39:48’),
(10, 10, ‘2016-06-13 19:00:00’, 18, 19, 0, 0, 0, 0, 5, 0, 0, 9, 1, ‘2016-04-30 07:39:57’),
(11, 11, ‘2016-06-14 16:00:00’, 22, 23, 0, 0, 0, 0, 2, 0, 0, 12, 1, ‘2016-04-30 07:40:05’),
(12, 12, ‘2016-06-14 19:00:00’, 25, 24, 0, 0, 0, 0, 9, 0, 0, 12, 1, ‘2016-04-30 07:40:15’),
(13, 13, ‘2016-06-15 13:00:00’, 7, 8, 0, 0, 0, 0, 4, 0, 0, 6, 0, ‘2016-05-13 07:52:08’),
(14, 14, ‘2016-06-15 16:00:00’, 3, 5, 0, 0, 0, 0, 1, 0, 0, 1, 0, ‘2016-05-13 07:52:49’),
(15, 15, ‘2016-06-15 19:00:00’, 2, 1, 0, 0, 0, 0, 6, 0, 0, 1, 0, ‘2016-05-13 07:53:16’),
(16, 16, ‘2016-06-16 13:00:00’, 6, 9, 0, 0, 0, 0, 3, 0, 0, 6, 0, ‘2016-05-13 07:54:07’),
(17, 17, ‘2016-06-16 16:00:00’, 13, 11, 0, 0, 0, 0, 5, 0, 0, 7, 0, ‘2016-05-13 07:54:39’),
(18, 18, ‘2016-06-16 19:00:00’, 10, 12, 0, 0, 0, 0, 8, 0, 0, 7, 0, ‘2016-05-13 07:55:22’),
(19, 19, ‘2016-06-17 13:00:00’, 19, 21, 0, 0, 0, 0, 10, 0, 0, 9, 0, ‘2016-05-13 07:56:23’),
(20, 20, ‘2016-06-17 16:00:00’, 15, 14, 0, 0, 0, 0, 9, 0, 0, 8, 0, ‘2016-05-13 07:56:56’),
(21, 21, ‘2016-06-17 19:00:00’, 16, 17, 0, 0, 0, 0, 7, 0, 0, 8, 0, ‘2016-05-13 07:57:23’),
(22, 22, ‘2016-06-18 13:00:00’, 18, 20, 0, 0, 0, 0, 2, 0, 0, 9, 0, ‘2016-05-13 07:58:03’),
(23, 23, ‘2016-06-18 16:00:00’, 24, 23, 0, 0, 0, 0, 6, 0, 0, 12, 0, ‘2016-05-13 07:58:27’),
(24, 24, ‘2016-06-18 19:00:00’, 25, 22, 0, 0, 0, 0, 1, 0, 0, 12, 0, ‘2016-05-13 07:59:05’),
(25, 25, ‘2016-06-19 19:00:00’, 3, 1, 0, 0, 0, 0, 5, 0, 0, 1, 0, ‘2016-05-13 08:00:32’),
(26, 26, ‘2016-06-19 19:00:00’, 5, 2, 0, 0, 0, 0, 4, 0, 0, 1, 0, ‘2016-05-13 08:01:01’),
(27, 27, ‘2016-06-20 19:00:00’, 7, 9, 0, 0, 0, 0, 10, 0, 0, 6, 0, ‘2016-05-13 08:01:55’),
(28, 28, ‘2016-06-20 19:00:00’, 8, 6, 0, 0, 0, 0, 9, 0, 0, 6, 0, ‘2016-05-13 08:02:26’),
(29, 29, ‘2016-06-21 16:00:00’, 13, 12, 0, 0, 0, 0, 6, 0, 0, 7, 0, ‘2016-05-13 08:03:10’),
(30, 30, ‘2016-06-21 16:00:00’, 11, 10, 0, 0, 0, 0, 1, 0, 0, 7, 0, ‘2016-05-13 08:03:44’),
(31, 31, ‘2016-06-21 19:00:00’, 15, 17, 0, 0, 0, 0, 3, 0, 0, 8, 0, ‘2016-05-13 08:04:15’),
(32, 32, ‘2016-06-21 19:00:00’, 14, 16, 0, 0, 0, 0, 2, 0, 0, 8, 0, ‘2016-05-13 08:04:38’),
(33, 33, ‘2016-06-22 16:00:00’, 24, 22, 0, 0, 0, 0, 8, 0, 0, 12, 0, ‘2016-05-13 08:05:42’),
(34, 34, ‘2016-06-22 16:00:00’, 23, 25, 0, 0, 0, 0, 5, 0, 0, 12, 0, ‘2016-05-13 08:06:18’),
(35, 35, ‘2016-06-22 19:00:00’, 19, 20, 0, 0, 0, 0, 4, 0, 0, 9, 0, ‘2016-05-13 08:10:11’),
(36, 36, ‘2016-06-22 19:00:00’, 21, 18, 0, 0, 0, 0, 7, 0, 0, 9, 0, ‘2016-05-13 08:11:03’);

@strophe18

Thank you for your initial work.
The full set of data :

table YOURNAME_wcup_match

—
— Structure de la table YOURNAME_wcup_match
—

CREATE TABLE IF NOT EXISTS YOURNAME_wcup_match (
match_id int(11) NOT NULL AUTO_INCREMENT,
match_no int(11) NOT NULL,
kickoff datetime NOT NULL,
home_team_id int(11) NOT NULL,
away_team_id int(11) NOT NULL,
home_goals int(11) NOT NULL,
away_goals int(11) NOT NULL,
home_penalties int(11) NOT NULL,
away_penalties int(11) NOT NULL,
venue_id int(11) NOT NULL,
is_result tinyint(1) NOT NULL DEFAULT ‘0’,
extra_time tinyint(1) NOT NULL DEFAULT ‘0’,
stage_id int(11) NOT NULL,
scored tinyint(1) NOT NULL DEFAULT ‘0’,
wwhen timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (match_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52 ;

—
— Contenu de la table YOURNAME_wcup_match
—

INSERT INTO YOURNAME_wcup_match (match_id, match_no, kickoff, home_team_id, away_team_id, home_goals, away_goals, home_penalties, away_penalties, venue_id, is_result, extra_time, stage_id, scored, wwhen) VALUES
(1, 1, ‘2016-06-10 19:00:00’, 2, 3, 0, 0, 0, 0, 8, 0, 0, 1, 1, ‘2016-05-12 21:31:43’),
(2, 2, ‘2016-06-11 13:00:00’, 1, 5, 0, 0, 0, 0, 3, 0, 0, 1, 1, ‘2016-04-30 07:38:38’),
(3, 4, ‘2016-06-11 16:00:00’, 9, 8, 0, 0, 0, 0, 2, 0, 0, 6, 1, ‘2016-04-30 07:38:57’),
(4, 3, ‘2016-06-11 19:00:00’, 6, 7, 0, 0, 0, 0, 6, 0, 0, 6, 1, ‘2016-04-30 07:38:48’),
(5, 5, ‘2016-06-12 13:00:00’, 17, 14, 0, 0, 0, 0, 1, 0, 0, 8, 1, ‘2016-04-30 07:39:05’),
(6, 6, ‘2016-06-12 16:00:00’, 12, 11, 0, 0, 0, 0, 7, 0, 0, 7, 1, ‘2016-04-30 07:39:12’),
(7, 7, ‘2016-06-12 19:00:00’, 10, 13, 0, 0, 0, 0, 4, 0, 0, 7, 1, ‘2016-04-30 07:39:27’),
(8, 8, ‘2016-06-13 13:00:00’, 16, 15, 0, 0, 0, 0, 10, 0, 0, 8, 1, ‘2016-04-30 07:39:37’),
(9, 9, ‘2016-06-13 16:00:00’, 20, 21, 0, 0, 0, 0, 8, 0, 0, 9, 1, ‘2016-04-30 07:39:48’),
(10, 10, ‘2016-06-13 19:00:00’, 18, 19, 0, 0, 0, 0, 5, 0, 0, 9, 1, ‘2016-04-30 07:39:57’),
(11, 11, ‘2016-06-14 16:00:00’, 22, 23, 0, 0, 0, 0, 2, 0, 0, 12, 1, ‘2016-04-30 07:40:05’),
(12, 12, ‘2016-06-14 19:00:00’, 25, 24, 0, 0, 0, 0, 9, 0, 0, 12, 1, ‘2016-04-30 07:40:15’),
(13, 13, ‘2016-06-15 13:00:00’, 7, 8, 0, 0, 0, 0, 4, 0, 0, 6, 0, ‘2016-05-13 06:58:35’),
(14, 14, ‘2016-06-15 16:00:00’, 3, 5, 0, 0, 0, 0, 1, 0, 0, 1, 0, ‘2016-05-13 06:59:30’),
(15, 15, ‘2016-06-15 19:00:00’, 2, 1, 0, 0, 0, 0, 6, 0, 0, 1, 0, ‘2016-05-13 07:00:02’),
(16, 16, ‘2016-06-16 13:00:00’, 6, 9, 0, 0, 0, 0, 3, 0, 0, 6, 0, ‘2016-05-13 07:00:52’),
(17, 17, ‘2016-06-16 16:00:00’, 13, 11, 0, 0, 0, 0, 5, 0, 0, 7, 0, ‘2016-05-13 07:01:34’),
(18, 18, ‘2016-06-16 19:00:00’, 10, 12, 0, 0, 0, 0, 8, 0, 0, 7, 0, ‘2016-05-13 07:02:12’),
(19, 19, ‘2016-06-17 13:00:00’, 19, 21, 0, 0, 0, 0, 10, 0, 0, 9, 0, ‘2016-05-13 07:02:56’),
(20, 20, ‘2016-06-17 16:00:00’, 15, 14, 0, 0, 0, 0, 9, 0, 0, 8, 0, ‘2016-05-13 07:03:44’),
(21, 21, ‘2016-06-17 19:00:00’, 16, 17, 0, 0, 0, 0, 7, 0, 0, 8, 0, ‘2016-05-13 07:04:22’),
(22, 22, ‘2016-06-18 13:00:00’, 18, 20, 0, 0, 0, 0, 2, 0, 0, 9, 0, ‘2016-05-13 07:05:51’),
(23, 23, ‘2016-06-18 16:00:00’, 24, 23, 0, 0, 0, 0, 6, 0, 0, 12, 0, ‘2016-05-13 07:06:33’),
(24, 24, ‘2016-06-18 19:00:00’, 25, 22, 0, 0, 0, 0, 1, 0, 0, 12, 0, ‘2016-05-13 07:07:07’),
(25, 25, ‘2016-06-19 19:00:00’, 3, 1, 0, 0, 0, 0, 5, 0, 0, 1, 0, ‘2016-05-13 07:08:05’),
(26, 26, ‘2016-06-19 19:00:00’, 5, 2, 0, 0, 0, 0, 4, 0, 0, 1, 0, ‘2016-05-13 08:21:49’),
(27, 27, ‘2016-06-20 19:00:00’, 7, 9, 0, 0, 0, 0, 10, 0, 0, 6, 0, ‘2016-05-13 07:09:23’),
(28, 28, ‘2016-06-20 19:00:00’, 8, 6, 0, 0, 0, 0, 9, 0, 0, 6, 0, ‘2016-05-13 07:09:58’),
(29, 29, ‘2016-06-21 16:00:00’, 13, 12, 0, 0, 0, 0, 6, 0, 0, 7, 0, ‘2016-05-13 07:10:35’),
(30, 30, ‘2016-06-21 16:00:00’, 11, 10, 0, 0, 0, 0, 1, 0, 0, 7, 0, ‘2016-05-13 07:11:02’),
(31, 31, ‘2016-06-21 19:00:00’, 15, 17, 0, 0, 0, 0, 3, 0, 0, 8, 0, ‘2016-05-13 07:11:33’),
(32, 32, ‘2016-06-21 19:00:00’, 14, 16, 0, 0, 0, 0, 2, 0, 0, 8, 0, ‘2016-05-13 07:12:12’),
(33, 33, ‘2016-06-22 16:00:00’, 24, 22, 0, 0, 0, 0, 8, 0, 0, 12, 0, ‘2016-05-13 07:13:15’),
(34, 34, ‘2016-06-22 16:00:00’, 23, 25, 0, 0, 0, 0, 5, 0, 0, 12, 0, ‘2016-05-13 07:13:54’),
(35, 35, ‘2016-06-22 19:00:00’, 19, 20, 0, 0, 0, 0, 4, 0, 0, 9, 0, ‘2016-05-13 07:14:30’),
(36, 36, ‘2016-06-22 19:00:00’, 21, 18, 0, 0, 0, 0, 7, 0, 0, 9, 0, ‘2016-05-13 07:15:20’),
(37, 37, ‘2016-06-25 13:00:00’, 26, 27, 0, 0, 0, 0, 9, 0, 0, 2, 0, ‘2016-05-13 08:29:59’),
(38, 38, ‘2016-06-25 16:00:00’, 28, 29, 0, 0, 0, 0, 1, 0, 0, 2, 0, ‘2016-05-13 08:30:03’),
(39, 39, ‘2016-06-25 19:00:00’, 30, 31, 0, 0, 0, 0, 3, 0, 0, 2, 0, ‘2016-05-13 08:30:10’),
(40, 40, ‘2016-06-26 13:00:00’, 32, 33, 0, 0, 0, 0, 5, 0, 0, 2, 0, ‘2016-05-13 08:30:14’),
(41, 41, ‘2016-06-26 16:00:00’, 34, 35, 0, 0, 0, 0, 4, 0, 0, 2, 0, ‘2016-05-13 08:30:17’),
(42, 42, ‘2016-06-26 19:00:00’, 36, 37, 0, 0, 0, 0, 10, 0, 0, 2, 0, ‘2016-05-13 08:30:20’),
(43, 43, ‘2016-06-27 16:00:00’, 38, 39, 0, 0, 0, 0, 8, 0, 0, 2, 0, ‘2016-05-13 08:30:24’),
(44, 44, ‘2016-06-27 19:00:00’, 40, 41, 0, 0, 0, 0, 7, 0, 0, 2, 0, ‘2016-05-13 08:30:27’),
(45, 45, ‘2016-06-30 19:00:00’, 42, 44, 0, 0, 0, 0, 6, 0, 0, 3, 0, ‘2016-05-13 09:11:57’),
(46, 46, ‘2016-07-01 19:00:00’, 43, 47, 0, 0, 0, 0, 4, 0, 0, 3, 0, ‘2016-05-13 09:12:29’),
(47, 47, ‘2016-07-02 19:00:00’, 46, 48, 0, 0, 0, 0, 2, 0, 0, 3, 0, ‘2016-05-13 09:12:54’),
(48, 48, ‘2016-07-03 19:00:00’, 45, 49, 0, 0, 0, 0, 8, 0, 0, 3, 0, ‘2016-05-13 09:13:17’),
(49, 49, ‘2016-07-06 19:00:00’, 50, 51, 0, 0, 0, 0, 5, 0, 0, 4, 1, ‘2016-05-13 09:29:38’),
(50, 50, ‘2016-07-07 19:00:00’, 52, 53, 0, 0, 0, 0, 6, 0, 0, 4, 0, ‘2016-05-13 09:14:16’),
(51, 51, ‘2016-07-10 19:00:00’, 54, 55, 0, 0, 0, 0, 8, 0, 0, 5, 0, ‘2016-05-13 09:14:54’);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

table YOURNAME_wcup_team

—
— Structure de la table YOURNAME_wcup_team
—

CREATE TABLE IF NOT EXISTS YOURNAME_wcup_team (
team_id int(20) NOT NULL AUTO_INCREMENT,
name varchar(64) NOT NULL,
country char(3) NOT NULL,
team_url varchar(255) NOT NULL,
group_order int(11) NOT NULL,
wwhen timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (team_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

—
— Contenu de la table YOURNAME_wcup_team
—

INSERT INTO YOURNAME_wcup_team (team_id, name, country, team_url, group_order, wwhen) VALUES
(1, ‘Albanie’, ‘alb’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=2/index.html’, 0, ‘2016-01-27 17:51:35’),
(2, ‘France’, ‘fra’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=43/index.html’, 0, ‘2016-01-27 17:51:44’),
(3, ‘Roumanie’, ‘rou’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=113/index.html’, 0, ‘2016-01-27 17:51:52’),
(5, ‘Suisse’, ‘sui’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=128/index.html’, 0, ‘2016-01-27 17:58:06’),
(6, ‘Angleterre’, ‘eng’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=39/index.html’, 0, ‘2016-01-27 17:58:24’),
(7, ‘Russie’, ‘rus’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=57451/index.html’, 0, ‘2016-01-27 17:58:55’),
(8, ‘Slovaquie’, ‘svk’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=58836/index.html’, 0, ‘2016-01-27 17:59:15’),
(9, ‘Pays de Galles’, ‘wal’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=144/index.html’, 0, ‘2016-01-27 17:59:33’),
(10, ‘Allemagne’, ‘ger’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=47/index.html’, 0, ‘2016-01-27 18:00:09’),
(11, ‘Irlande du Nord’, ‘nir’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=63/index.html’, 0, ‘2016-01-27 18:01:30’),
(12, ‘Pologne’, ‘pol’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=109/index.html’, 0, ‘2016-01-27 18:01:44’),
(13, ‘Ukraine’, ‘ukr’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=57166/index.html’, 0, ‘2016-01-27 18:02:19’),
(14, ‘Croatie’, ‘cro’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=56370/index.html’, 0, ‘2016-01-27 18:02:43’),
(15, ‘République Tchèque’, ‘cze’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=58837/index.html’, 0, ‘2016-01-27 18:09:38’),
(16, ‘Espagne’, ‘esp’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=122/index.html’, 0, ‘2016-01-27 18:05:54’),
(17, ‘Turquie’, ‘tur’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=135/index.html’, 0, ‘2016-01-27 18:05:42’),
(18, ‘Belgique’, ‘bel’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=13/index.html’, 0, ‘2016-01-27 18:06:15’),
(19, ‘Italie’, ‘ita’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=66/index.html’, 0, ‘2016-01-27 18:06:32’),
(20, ‘République d”Irlande’, ‘irl’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=64/index.html’, 0, ‘2016-01-27 18:06:53’),
(21, ‘Suède’, ‘swe’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=127/index.html’, 0, ‘2016-01-27 18:07:20’),
(22, ‘Autriche’, ‘aut’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=8/index.html’, 0, ‘2016-01-27 18:07:37’),
(23, ‘Hongrie’, ‘hun’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=57/index.html’, 0, ‘2016-01-27 18:08:05’),
(24, ‘Islande’, ‘isl’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=58/index.html’, 0, ‘2016-01-27 18:08:26’),
(25, ‘Portugal’, ‘por’, ‘https://fr.uefa.com/uefaeuro/season=2016/teams/team=110/index.html’, 0, ‘2016-01-27 18:08:37’),
(26, ‘2e Groupe A’, ‘2A’, ”, 0, ‘2016-05-13 07:54:21’),
(27, ‘2e Groupe C’, ‘2C’, ”, 0, ‘2016-05-13 07:54:44’),
(28, ‘1er Groupe B’, ‘1B’, ”, 0, ‘2016-05-13 07:54:55’),
(29, ‘3e Groupe A/C/D’, ‘3AC’, ”, 0, ‘2016-05-13 07:55:13’),
(30, ‘1er Groupe D’, ‘1D’, ”, 0, ‘2016-05-13 07:55:22’),
(31, ‘3e Groupe B/E/F’, ‘3BE’, ”, 0, ‘2016-05-13 07:55:39’),
(32, ‘1er Groupe A’, ‘1A’, ”, 0, ‘2016-05-13 07:55:56’),
(33, ‘3e Groupe C/D/E’, ‘3CD’, ”, 0, ‘2016-05-13 07:56:16’),
(34, ‘1er Groupe C’, ‘1C’, ”, 0, ‘2016-05-13 07:56:30’),
(35, ‘3e Groupe A/B/F’, ‘3AB’, ”, 0, ‘2016-05-13 07:56:46’),
(36, ‘1er Groupe F’, ‘1F’, ”, 0, ‘2016-05-13 07:56:57’),
(37, ‘2e Groupe E’, ‘2E’, ”, 0, ‘2016-05-13 07:57:13’),
(38, ‘1er Groupe E’, ‘1E’, ”, 0, ‘2016-05-13 07:57:24’),
(39, ‘2e Groupe D’, ‘2D’, ”, 0, ‘2016-05-13 07:57:35’),
(40, ‘2e Groupe B’, ‘2B’, ”, 0, ‘2016-05-13 07:57:45’),
(41, ‘2e Groupe F’, ‘2F’, ”, 0, ‘2016-05-13 07:57:54’),
(42, ‘Vainqueur Match 37’, ‘V37’, ”, 0, ‘2016-05-13 09:08:38’),
(43, ‘Vainqueur Match 38’, ‘V38’, ”, 0, ‘2016-05-13 09:08:46’),
(44, ‘Vainqueur Match 39’, ‘V39’, ”, 0, ‘2016-05-13 09:08:58’),
(45, ‘Vainqueur Match 40’, ‘V40’, ”, 0, ‘2016-05-13 09:09:14’),
(46, ‘Vainqueur Match 41’, ‘V41’, ”, 0, ‘2016-05-13 09:09:26’),
(47, ‘Vainqueur Match 42’, ‘V42’, ”, 0, ‘2016-05-13 09:09:37’),
(48, ‘Vainqueur Match 43’, ‘V43’, ”, 0, ‘2016-05-13 09:09:48’),
(49, ‘Vainqueur Match 44’, ‘V44’, ”, 0, ‘2016-05-13 09:10:04’),
(50, ‘Vainqueur Match 45’, ‘V45’, ”, 0, ‘2016-05-13 09:10:15’),
(51, ‘Vainqueur Match 46’, ‘V46’, ”, 0, ‘2016-05-13 09:10:27’),
(52, ‘Vainqueur Match 47’, ‘V47’, ”, 0, ‘2016-05-13 09:10:39’),
(53, ‘Vainqueur Match 48’, ‘V48’, ”, 0, ‘2016-05-13 09:10:56’),
(54, ‘Finaliste 1’, ‘F1’, ”, 0, ‘2016-05-13 09:11:09’),
(55, ‘Finaliste 2’, ‘F2’, ”, 0, ‘2016-05-13 09:11:19’);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

And for the knock-out table you need to update :
/wp-content/plugins/world-cup-predictor/wcp-reports.class.php

On line 576
match_no > 36"; // TODO - Yuck 36

And the full table that start on line 624

<table cellspacing=”0″ cellpadding=”0″ border=”0″ class=”knockout”>
<tbody><tr>
<td height=”5″></td>
<td bgcolor=”#f2f2f2″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” colspan=”2″>{$this->stage(37)}</td>
<td colspan=”2″></td>
<td bgcolor=”#f2f2f2″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” colspan=”2″>{$this->stage(45)}</td>
<td colspan=”2″></td>
<td bgcolor=”#f2f2f2″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” colspan=”2″>{$this->stage(49)}</td>
<td colspan=”2″></td>
<td bgcolor=”#f2f2f2″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” colspan=”2″>{$this->stage(51)}</td>
</tr>
<tr>
<td height=”5″></td>
<td width=”170″> </td>
<td width=”40″> </td>
<td width=”10″> </td>
<td width=”10″> </td>
<td width=”170″> </td>
<td width=”40″> </td>
<td width=”10″> </td>
<td width=”10″> </td>
<td width=”170″> </td>
<td width=”40″> </td>
<td width=”10″> </td>
<td width=”10″> </td>
<td width=”170″> </td>
<td width=”40″> </td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#37 – {$this->venue(37)}</td>
<td style=”border-style: solid; border-color: black; border-width: 0pt 0pt 1px;” rowspan=”4″> </td>
<td style=”border-style: solid; border-color: black; border-width: 0pt 0pt 1px;” rowspan=”7″> </td>
<td rowspan=”3″ colspan=”2″></td>
<td style=”border-style: solid; border-color: black; border-width: 0pt 0pt 1px;” rowspan=”7″> </td>
<td style=”border-style: solid; border-color: black; border-width: 0pt 0pt 1px;” rowspan=”13″> </td>
<td rowspan=”9″ colspan=”2″></td>
<td style=”border-style: solid; border-color: black; border-width: 0pt 0pt 1px;” rowspan=”13″> </td>
<td style=”border-style: solid; border-color: black; border-width: 0pt 0pt 1px;” rowspan=”25″> </td>
<td rowspan=”21″ colspan=”2″></td>
</tr>
<tr>
<td height=”5″></td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(37)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(37)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#45 – {$this->venue(45)}</td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(37)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(37)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(45)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(45)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#39 – {$this->venue(39)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”12″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(45)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(45)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”12″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(39)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(39)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”6″ colspan=”2″></td>
<td rowspan=”2″ colspan=”2″>#49 – {$this->venue(49)}</td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(39)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(39)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(49)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(49)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#38 – {$this->venue(38)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”24″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(49)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(49)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”24″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(38)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(38)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#46 – {$this->venue(46)}</td>
<td rowspan=”18″ colspan=”2″></td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″> {$this->away_team(38)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″> {$this->away_score(38)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(46)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(46)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#42 – {$this->venue(42)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”12″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(46)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(46)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”12″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(42)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″> {$this->home_score(42)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”6″ colspan=”2″></td>
<td rowspan=”2″ colspan=”2″>#51 – {$this->venue(51)}</td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(42)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(42)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(51)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(51)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#41 – {$this->venue(41)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 0pt;” rowspan=”23″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(51)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(51)}</td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(41)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(41)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#47 – {$this->venue(47)}</td>
<td rowspan=”10″ colspan=”2″></td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(41)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(41)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(47)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(47)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#43 – {$this->venue(43)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”12″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(47)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(47)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”12″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(43)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(43)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”6″ colspan=”2″></td>
<td rowspan=”2″ colspan=”2″>#50 – {$this->venue(50)}</td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(43)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(43)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 1px;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(50)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(50)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#40 – {$this->venue(40)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 0pt;” rowspan=”11″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(50)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(50)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 0pt;” rowspan=”11″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(40)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(40)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#48 – {$this->venue(48)}</td>
<td rowspan=”9″ colspan=”2″></td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(40)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(40)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 3px 1px 0pt;” rowspan=”6″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(48)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(48)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”2″ colspan=”2″>#44 – {$this->venue(44)}</td>
</tr>
<tr>
<td height=”5″></td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 0pt;” rowspan=”5″> </td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(48)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(48)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 0pt;” rowspan=”5″> </td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_team(44)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->home_score(44)}</td>
</tr>
<tr>
<td height=”5″></td>
<td rowspan=”3″ colspan=”2″></td>
<td rowspan=”3″ colspan=”2″></td>
</tr>
<tr>
<td height=”5″></td>
<td bgcolor=”#f9f9f9″ style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_team(44)}</td>
<td bgcolor=”#f9f9f9″ align=”center” style=”border: 1px solid rgb(170, 170, 170);” rowspan=”2″>{$this->away_score(44)}</td>
<td style=”border-style: solid; border-color: black; border-width: 2px 0pt 0pt;” rowspan=”2″> </td>
</tr>
<tr>
<td height=”5″></td>
</tr>
</tbody></table>

@djulmeedia

Great job !!

Thanx

@strophe18
je peux t’envoyer un mail, j’ai une proposition pour toi.
Si oui, à quelle adresse ?