Pour mettre à jour PhpMyNewsLetter, cliquez sur le lien qui vous est proposé.
Chaque lien amènera à une action de mise à jour.
Ce script est fait pour vous aider, il a été testé et est fonctionnel.
Toutefois, selon votre installation, des bugs peuvent survenir. Merci de passer par le forum pour support :
Forum.';
echo '
To update PhpMyNewsLetter, please click the link that is offered
Each link will be an update step.
This script is done to help you, it has been tested and is fully functional.
However, depending on your installation, bugs may occur. Thank you to pass through the support forum :
Forum.
';
if (version_compare(PHP_VERSION, '5.3.0', '>')) {
echo "
PHP : " . phpversion() . " OK
";
} else {
echo "
PHP : " . phpversion() . " obsolète / obsolete
";
}
if (extension_loaded('imap')) {
echo "
module imap OK
";
} else {
echo "
module imap absent / missing
";
}
if (extension_loaded('curl')) {
echo "
module curl OK
";
} else {
echo "
module curl absent / missing
";
}
if (is_file('include/config.php')) {
echo "
config.php OK
";
$tab_return = checkVersion($VERSION_NEW);
echo "
Version à upgrader / Version to upgrade : ".$VERSION_TO_UPGRADE."
";
echo "
Version disponible : ".$tab_return[1]."
";
if (version_compare($VERSION_TO_UPGRADE, $VERSION_REQUIRED, '==')) {
if($tab_return[0]==true) {
echo "
Version " . $tab_return[1] . " disponible / available
";
echo "
Préfixe des tables / tables prefix : $PREFIX
";
echo "
";
} else {
echo "
Pas de nouvelle version disponible / no update available
";
}
} elseif (version_compare($VERSION_TO_UPGRADE, $VERSION_NEW, '==')) {
echo "
PhpMyNewsLetter : dernière version déjà installée
";
} elseif (version_compare($VERSION_TO_UPGRADE, $VERSION_REQUIRED, '<')) {
echo "
PhpMyNewsLetter obsolète / obsolete (".$VERSION_REQUIRED." min)
";
}
} else {
die("
config.php non trouvé, merci de placer upgrade.php à la racine de votre installation PhpMyNewsLetter !
config.php not found, please move upgrade.php in the PhpMyNewsLetter installation path !
");
}
break;
case 'files':
if (mkdir($PATH_BACKUP_CURRENT_VERSION, 0755)) {
if (!zipData('.', $PATH_BACKUP_CURRENT_VERSION . '/backup_' . $VERSION_TO_UPGRADE . '.zip')) {
unlink($PATH_BACKUP_CURRENT_VERSION . '/backup_' . $VERSION_TO_UPGRADE . '.zip');
rmdir($PATH_BACKUP_CURRENT_VERSION);
die("
Erreur lors du zip de la version courante !
Error while create zip of current version !
");
} else {
echo "
Sauvegarde des fichiers de la version courante OK !
Backup current version OK !
$PATH_BACKUP_CURRENT_VERSION/backup_$VERSION_TO_UPGRADE.zip
";
echo "
";
}
} else {
die("
Erreur à la création du répertoire de sauvegarde : ".$PATH_BACKUP_CURRENT_VERSION."/ !
Vérifiez les droits et relancez la procédure d'upgrade uniquement par un F5 (rafraichissement de la page)
Error while create path for backup : ".$PATH_BACKUP_CURRENT_VERSION."/ ! Check your config and restart upgrade only with F5 ! (refresh the page)
");
}
break;
case 'sql':
if (!is_dir($PATH_BACKUP_CURRENT_VERSION)) {
die("
Erreur répertoire de sauvegarde : ".$PATH_BACKUP_CURRENT_VERSION."/ ! Répertoire inconnu
Error while create path for backup : ".$PATH_BACKUP_CURRENT_VERSION."/ ! Bad path
");
}
new BackupMySQL(array(
'host' => $hostname,
'username' => $login,
'passwd' => $pass,
'dbname' => $database,
'dossier' => $PATH_BACKUP_CURRENT_VERSION . '/',
'prefixe' => $PREFIX
));
echo "
";
break;
case 'wget':
include_once ('include/config.php');
if (!is_dir($PATH_BACKUP_CURRENT_VERSION)) {
die("
Erreur sur vérification du répertoire de travail : $PATH_BACKUP_CURRENT_VERSION/ ! Répertoire inconnu
Error while checking for working path : $PATH_BACKUP_CURRENT_VERSION/ ! Bad path
");
}
$URL_FILE_NEW_VERSION = 'https://www.phpmynewsletter.com/download_phpmynewsletter.php?v=' . getVersion($VERSION_NEW);
if ($data = file_get_contents($URL_FILE_NEW_VERSION)) {
if (file_put_contents($FILE_TO_UNZIP, $data)) {
echo "
Téléchargement nouvelle version OK !
Download new version OK !
";
} else {
die("
Erreur sur écriture du fichier téléchargé !
Error while writing downloaded file !
");
}
} else {
die("
Erreur sur téléchargement du nouveau fichier !
Error while downloading new file !
");
}
echo "
";
break;
case 'uncompress':
if (!is_dir($PATH_BACKUP_CURRENT_VERSION)) {
die("
Erreur sur vérification du répertoire de travail : $PATH_BACKUP_CURRENT_VERSION/ ! Répertoire inconnu
Error while checking for working path : $PATH_BACKUP_CURRENT_VERSION/ ! Bad path
");
}
if (unzip($FILE_TO_UNZIP, __DIR__.'/')) {
echo "
Unzip et installation nouvelle version OK !
Unzip and install new version OK !
";
}
else {
die("
Erreur sur décompression et installation de la nouvelle version !
Error while unzip and install new version !
");
}
echo "
";
break;
case 'upgradesql':
$my = new mysqli($hostname, $login, $pass, $database);
$my->query( "SET sql_mode = '';" );
$sql_archives_fields = "ALTER TABLE `" . $PREFIX . "archives`
ADD `sender_email` VARCHAR(255) NOT NULL,
ADD `draft` LONGTEXT NOT NULL,
ADD `preheader` TEXT NOT NULL,
CHANGE `message` `message` LONGTEXT NOT NULL,
CHANGE `list_id` `list_id` INT(4) NOT NULL DEFAULT '0',
CHANGE `subject` `subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
ADD KEY `sender_email` (`sender_email`);";
if ($my->query($sql_archives_fields )) {
echo "
Mise à jour / update table " . $PREFIX . "archives OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "archives en erreur / failed !
$sql_archives_fields
");
}
$sql_autosave_fields = "ALTER TABLE `" . $PREFIX . "autosave`
CHANGE `list_id` `list_id` INT(4) NOT NULL DEFAULT '0',
ADD `draft` LONGTEXT NOT NULL,
ADD `sender_email` VARCHAR(255) NOT NULL,
ADD `preheader` text NOT NULL,
CHANGE `subject` `subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;";
if ($my->query($sql_autosave_fields )) {
echo "
Mise à jour / update table " . $PREFIX . "autosave OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "autosave en erreur / failed !
$sql_autosave_fields
");
}
$sql_create_codes = "CREATE TABLE IF NOT EXISTS `" . $PREFIX . "codes` (
`code` VARCHAR(2) NOT NULL,
`lat` DECIMAL(10,8) NOT NULL,
`long` DECIMAL(11,8) UNSIGNED NOT NULL,
`country` VARCHAR(50) NOT NULL,
`color` VARCHAR(7) NOT NULL,
KEY `code` (`code`),
KEY `lat` (`lat`),
KEY `long` (`long`),
KEY `country` (`country`),
KEY `color` (`color`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if ($my->query($sql_create_codes)) {
echo "
Création / create table " . $PREFIX . "codes OK !
";
} else {
die("
Création / create table " . $PREFIX . "codes en erreur / failed !
$sql_create_codes
");
}
$sql_load_codes = 'INSERT INTO `' . $PREFIX . 'codes` (`code`, `lat`, `long`, `country`, `color`) VALUES
("AD", "42.50000000", "1.50000000", "Andorra", "#d8854f"),
("AE", "24.00000000", "54.00000000", "United Arab Emirates", "#eea638"),
("AF", "33.00000000", "65.00000000", "Afghanistan", "#eea638"),
("AG", "17.05000000", "-61.80000000", "Antigua and Barbuda", "#a7a737"),
("AI", "18.25000000", "-63.16670000", "Anguilla", "#a7a737"),
("AL", "41.00000000", "20.00000000", "Albania", "#d8854f"),
("AM", "40.00000000", "45.00000000", "Armenia", "#d8854f"),
("AO", "-12.50000000", "18.50000000", "Angola", "#de4c4f"),
("AQ", "-90.00000000", "0.00000000", "Antarctica", "#98d84e"),
("AR", "-34.00000000", "-64.00000000", "Argentina", "#86a965"),
("AS", "-14.33330000", "-170.00000000", "American Samoa", "#8aabb0"),
("AT", "47.33330000", "13.33330000", "Austria", "#d8854f"),
("AU", "-27.00000000", "133.00000000", "Australia", "#8aabb0"),
("AW", "12.50000000", "-69.96670000", "Aruba", "#86a965"),
("AZ", "40.50000000", "47.50000000", "Azerbaijan", "#d8854f"),
("BA", "44.00000000", "18.00000000", "Bosnia and Herzegovina", "#d8854f"),
("BB", "13.16670000", "-59.53330000", "Barbados", "#a7a737"),
("BD", "24.00000000", "90.00000000", "Bangladesh", "#eea638"),
("BE", "50.83330000", "4.00000000", "Belgium", "#d8854f"),
("BF", "13.00000000", "-2.00000000", "Burkina Faso", "#de4c4f"),
("BG", "43.00000000", "25.00000000", "Bulgaria", "#d8854f"),
("BH", "26.00000000", "50.55000000", "Bahrain", "#eea638"),
("BI", "-3.50000000", "30.00000000", "Burundi", "#de4c4f"),
("BJ", "9.50000000", "2.25000000", "Benin", "#de4c4f"),
("BM", "32.33330000", "-64.75000000", "Bermuda", "#a7a737"),
("BN", "4.50000000", "114.66670000", "Brunei", "#eea638"),
("BO", "-17.00000000", "-65.00000000", "Bolivia", "#86a965"),
("BR", "-10.00000000", "-55.00000000", "Brazil", "#86a965"),
("BS", "24.25000000", "-76.00000000", "Bahamas", "#a7a737"),
("BT", "27.50000000", "90.50000000", "Bhutan", "#eea638"),
("BV", "-54.43330000", "3.40000000", "Bouvet Island", "#de4c4f"),
("BW", "-22.00000000", "24.00000000", "Botswana", "#de4c4f"),
("BY", "53.00000000", "28.00000000", "Belarus", "#d8854f"),
("BZ", "17.25000000", "-88.75000000", "Belize", "#a7a737"),
("CA", "54.00000000", "-100.00000000", "Canada", "#a7a737"),
("CC", "-12.50000000", "96.83330000", "Cocos (Keeling) Islands (the)", "#8aabb0"),
("CD", "0.00000000", "25.00000000", "Congo, Dem. Rep.", "#de4c4f"),
("CF", "7.00000000", "21.00000000", "Central African Rep.", "#de4c4f"),
("CG", "-1.00000000", "15.00000000", "Congo, Rep.", "#de4c4f"),
("CH", "47.00000000", "8.00000000", "Switzerland", "#d8854f"),
("CI", "8.00000000", "-5.00000000", "Cote d\'Ivoire", "#de4c4f"),
("CK", "-21.23330000", "-159.76670000", "Cook Islands (the)", "#a7a737"),
("CL", "-30.00000000", "-71.00000000", "Chile", "#86a965"),
("CM", "6.00000000", "12.00000000", "Cameroon", "#de4c4f"),
("CN", "35.00000000", "105.00000000", "China", "#eea638"),
("CO", "4.00000000", "-72.00000000", "Colombia", "#86a965"),
("CR", "10.00000000", "-84.00000000", "Costa Rica", "#a7a737"),
("CU", "21.50000000", "-80.00000000", "Cuba", "#a7a737"),
("CV", "16.00000000", "-24.00000000", "Cape Verde", "#de4c4f"),
("CX", "-10.50000000", "105.66670000", "Christmas Island", "#eea638"),
("CY", "35.00000000", "33.00000000", "Cyprus", "#d8854f"),
("CZ", "49.75000000", "15.50000000", "Czech Republic", "#d8854f"),
("DE", "51.00000000", "9.00000000", "Germany", "#d8854f"),
("DJ", "11.50000000", "43.00000000", "Djibouti", "#de4c4f"),
("DK", "56.00000000", "10.00000000", "Denmark", "#d8854f"),
("DM", "15.41670000", "-61.33330000", "Dominica", "#a7a73"),
("DO", "19.00000000", "-70.66670000", "Dominican Republic", "#a7a737"),
("DZ", "28.00000000", "3.00000000", "Algeria", "#de4c4f"),
("EC", "-2.00000000", "-77.50000000", "Ecuador", "#86a965"),
("EE", "59.00000000", "26.00000000", "Estonia", "#d8854f"),
("EG", "27.00000000", "30.00000000", "Egypt", "#de4c4f"),
("EH", "24.50000000", "-13.00000000", "Western Sahara", "#d8854f"),
("ER", "15.00000000", "39.00000000", "Eritrea", "#de4c4f"),
("ES", "40.00000000", "-4.00000000", "Spain", "#d8854f"),
("ET", "8.00000000", "38.00000000", "Ethiopia", "#de4c4f"),
("FI", "62.00000000", "26.00000000", "Finland", "#d8854f"),
("FJ", "-18.00000000", "175.00000000", "Fiji", "#8aabb0"),
("FK", "-51.75000000", "-59.00000000", "Falkland Islands", "#86a965"),
("FM", "6.91670000", "158.25000000", "Micronesia", "#eea638"),
("FO", "62.00000000", "-7.00000000", "Faroe Islands", "#d8854f"),
("FR", "46.00000000", "2.00000000", "France", "#d8854f"),
("GA", "-1.00000000", "11.75000000", "Gabon", "#de4c4f"),
("GB", "54.00000000", "-2.00000000", "United Kingdom", "#d8854f"),
("GD", "12.11670000", "-61.66670000", "Grenada", "#a7a737"),
("GE", "42.00000000", "43.50000000", "Georgia", "#d8854f"),
("GF", "4.00000000", "-53.00000000", "French Guiana", "#86a965"),
("GH", "8.00000000", "-2.00000000", "Ghana", "#de4c4f"),
("GI", "36.18330000", "-5.36670000", "Gibraltar", "#d8854f"),
("GL", "72.00000000", "-40.00000000", "Greenland", "#d14ed8"),
("GM", "13.46670000", "-16.56670000", "Gambia", "#de4c4f"),
("GN", "11.00000000", "-10.00000000", "Guinea", "#de4c4f"),
("GP", "16.25000000", "-61.58330000", "Guadeloupe", "#a7a737"),
("GQ", "2.00000000", "10.00000000", "Equatorial Guinea", "#de4c4f"),
("GR", "39.00000000", "22.00000000", "Greece", "#d8854f"),
("GS", "-54.50000000", "-37.00000000", "South Georgia and the South Sandwich Islands", "#86a965"),
("GT", "15.50000000", "-90.25000000", "Guatemala", "#a7a737"),
("GU", "13.46670000", "144.78330000", "Guam", "#eea638"),
("GW", "12.00000000", "-15.00000000", "Guinea-Bissau", "#de4c4f"),
("GY", "5.00000000", "-59.00000000", "Guyana", "#86a965"),
("HK", "22.25000000", "114.16670000", "Hong Kong", "#eea638"),
("HM", "-53.10000000", "72.51670000", "Heard Island and McDonald Islands", "#98d84e"),
("HN", "15.00000000", "-86.50000000", "Honduras", "#a7a737"),
("HR", "45.16670000", "15.50000000", "Croatia", "#d8854f"),
("HT", "19.00000000", "-72.41670000", "Haiti", "#a7a737"),
("HU", "47.00000000", "20.00000000", "Hungary", "#d8854f"),
("ID", "-5.00000000", "120.00000000", "Indonesia", "#eea638"),
("IE", "53.00000000", "-8.00000000", "Ireland", "#d8854f"),
("IL", "31.50000000", "34.75000000", "Israel", "#eea638"),
("IN", "20.00000000", "77.00000000", "India", "#eea638"),
("IO", "-6.00000000", "71.50000000", "British Indian Ocean Territory", "#eea638"),
("IQ", "33.00000000", "44.00000000", "Iraq", "#eea638"),
("IR", "32.00000000", "53.00000000", "Iran", "#eea638"),
("IS", "65.00000000", "-18.00000000", "Iceland", "#d8854f"),
("IT", "42.83330000", "12.83330000", "Italy", "#d8854f"),
("JM", "18.25000000", "-77.50000000", "Jamaica", "#a7a737"),
("JO", "31.00000000", "36.00000000", "Jordan", "#eea638"),
("JP", "36.00000000", "138.00000000", "Japan", "#eea638"),
("KE", "1.00000000", "38.00000000", "Kenya", "#de4c4f"),
("KG", "41.00000000", "75.00000000", "Kyrgyzstan", "#eea638"),
("KH", "13.00000000", "105.00000000", "Cambodia", "#eea638"),
("KI", "1.41670000", "173.00000000", "Kiribati", "#8aabb0"),
("KM", "-12.16670000", "44.25000000", "Comoros", "#de4c4f"),
("KN", "17.33330000", "-62.75000000", "Saint Kitts and Nevis", "#a7a737"),
("KP", "40.00000000", "127.00000000", "Korea, Dem. Rep.", "#eea638"),
("KR", "37.00000000", "127.50000000", "Korea, Republic of", "#eea638"),
("KW", "29.33750000", "47.65810000", "Kuwait", "#eea638"),
("KY", "19.50000000", "-80.50000000", "Cayman Islands", "#a7a737"),
("KZ", "48.00000000", "68.00000000", "Kazakhstan", "#eea638"),
("LA", "18.00000000", "105.00000000", "Laos", "#eea638"),
("LB", "33.83330000", "35.83330000", "Lebanon", "#eea638"),
("LC", "13.88330000", "-61.13330000", "Saint Lucia", "#a7a737"),
("LI", "47.16670000", "9.53330000", "Liechtenstein", "#d8854f"),
("LK", "7.00000000", "81.00000000", "Sri Lanka", "#eea638"),
("LR", "6.50000000", "-9.50000000", "Liberia", "#de4c4f"),
("LS", "-29.50000000", "28.50000000", "Lesotho", "#de4c4f"),
("LT", "55.00000000", "24.00000000", "Lithuania", "#d8854f"),
("LU", "49.75000000", "6.00000000", "Luxembourg", "#d8854f"),
("LV", "57.00000000", "25.00000000", "Latvia", "#d8854f"),
("LY", "25.00000000", "17.00000000", "Libya", "#de4c4f"),
("MA", "32.00000000", "-5.00000000", "Morocco", "#de4c4f"),
("MC", "43.73330000", "7.40000000", "Monaco", "#d8854f"),
("MD", "47.00000000", "29.00000000", "Moldova", "#d8854f"),
("ME", "42.50000000", "19.40000000", "Montenegro", "#d8854f"),
("MG", "-20.00000000", "47.00000000", "Madagascar", "#de4c4f"),
("MH", "9.00000000", "168.00000000", "Marshall Islands", "#eea638"),
("MK", "41.83330000", "22.00000000", "Macedonia, FYR", "#d8854f"),
("ML", "17.00000000", "-4.00000000", "Mali", "#de4c4f"),
("MM", "22.00000000", "98.00000000", "Myanmar", "#eea638"),
("MN", "46.00000000", "105.00000000", "Mongolia", "#eea638"),
("MO", "22.16670000", "113.55000000", "Macao", "#eea638"),
("MP", "15.20000000", "145.75000000", "Northern Mariana Islands", "#eea638"),
("MQ", "14.66670000", "-61.00000000", "Martinique", "#a7a737"),
("MR", "20.00000000", "-12.00000000", "Mauritania", "#de4c4f"),
("MS", "16.75000000", "-62.20000000", "Montserrat", "#a7a737"),
("MT", "35.83330000", "14.58330000", "Malta", "#d8854f"),
("MU", "-20.28330000", "57.55000000", "Mauritius", "#de4c4f"),
("MV", "3.25000000", "73.00000000", "Maldives", "#eea638"),
("MW", "-13.50000000", "34.00000000", "Malawi", "#de4c4f"),
("MX", "23.00000000", "-102.00000000", "Mexico", "#a7a737"),
("MY", "2.50000000", "112.50000000", "Malaysia", "#eea638"),
("MZ", "-18.25000000", "35.00000000", "Mozambique", "#de4c4f"),
("NA", "-22.00000000", "17.00000000", "Namibia", "#de4c4f"),
("NC", "-21.50000000", "165.50000000", "New Caledonia", "#a7a737"),
("NE", "16.00000000", "8.00000000", "Niger", "#de4c4f"),
("NF", "-29.03330000", "167.95000000", "Norfolk Island", "#8aabb0"),
("NG", "10.00000000", "8.00000000", "Nigeria", "#de4c4f"),
("NI", "13.00000000", "-85.00000000", "Nicaragua", "#a7a737"),
("NL", "52.50000000", "5.75000000", "Netherlands", "#d8854f"),
("NO", "62.00000000", "10.00000000", "Norway", "#d8854f"),
("NP", "28.00000000", "84.00000000", "Nepal", "#eea638"),
("NR", "-0.53330000", "166.91670000", "Nauru", "#8aabb0"),
("NU", "-19.03330000", "-169.86670000", "Niue", "#8aabb0"),
("NZ", "-41.00000000", "174.00000000", "New Zealand", "#8aabb0"),
("OM", "21.00000000", "57.00000000", "Oman", "#eea638"),
("PA", "9.00000000", "-80.00000000", "Panama", "#a7a737"),
("PE", "-10.00000000", "-76.00000000", "Peru", "#86a965"),
("PF", "-15.00000000", "-140.00000000", "French Polynesia", "#a7a737"),
("PG", "-6.00000000", "147.00000000", "Papua New Guinea", "#8aabb0"),
("PH", "13.00000000", "122.00000000", "Philippines", "#eea638"),
("PK", "30.00000000", "70.00000000", "Pakistan", "#eea638"),
("PL", "52.00000000", "20.00000000", "Poland", "#d8854f"),
("PM", "46.83330000", "-56.33330000", "Saint Pierre and Miquelon", "#a7a737"),
("PR", "18.25000000", "-66.50000000", "Puerto Rico", "#a7a737"),
("PS", "32.00000000", "35.25000000", "Palestinian Territory", "#eea638"),
("PT", "39.50000000", "-8.00000000", "Portugal", "#d8854f"),
("PW", "7.50000000", "134.50000000", "Palau", "#eea638"),
("PY", "-23.00000000", "-58.00000000", "Paraguay", "#86a965"),
("QA", "25.50000000", "51.25000000", "Qatar", "#eea638"),
("RE", "-21.10000000", "55.60000000", "Reunion", "#de4c4f"),
("RO", "46.00000000", "25.00000000", "Romania", "#d8854f"),
("RS", "44.00000000", "21.00000000", "Serbia", "#d8854f"),
("RU", "60.00000000", "100.00000000", "Russian Federation", "#d8854f"),
("RW", "-2.00000000", "30.00000000", "Rwanda", "#de4c4f"),
("SA", "25.00000000", "45.00000000", "Saudi Arabia", "#eea638"),
("SB", "-8.00000000", "159.00000000", "Solomon Islands", "#8aabb0"),
("SC", "-4.58330000", "55.66670000", "Seychelles", "#de4c4f"),
("SD", "15.00000000", "30.00000000", "Sudan", "#de4c4f"),
("SE", "62.00000000", "15.00000000", "Sweden", "#d8854f"),
("SG", "1.36670000", "103.80000000", "Singapore", "#eea638"),
("SH", "-15.93330000", "-5.70000000", "Saint Helena, Ascension and Tristan da Cunha", "#de4c4f"),
("SI", "46.00000000", "15.00000000", "Slovenia", "#d8854f"),
("SJ", "78.00000000", "20.00000000", "Svalbard and Jan Mayen", "#d14ed8"),
("SK", "48.66670000", "19.50000000", "Slovakia", "#d8854f"),
("SL", "8.50000000", "-11.50000000", "Sierra Leone", "#de4c4f"),
("SM", "43.76670000", "12.41670000", "San Marino", "#d8854f"),
("SN", "14.00000000", "-14.00000000", "Senegal", "#de4c4f"),
("SO", "10.00000000", "49.00000000", "Somalia", "#de4c4f"),
("SR", "4.00000000", "-56.00000000", "Suri", "#86a965"),
("ST", "1.00000000", "7.00000000", "Sao Tome and Principe", "#de4c4f"),
("SV", "13.83330000", "-88.91670000", "El Salvador", "#a7a737"),
("SY", "35.00000000", "38.00000000", "Syria", "#eea638"),
("SZ", "-26.50000000", "31.50000000", "Swaziland", "#de4c4f"),
("TC", "21.75000000", "-71.58330000", "Turks and Caicos Islands", "#a7a737"),
("TD", "15.00000000", "19.00000000", "Chad", "#de4c4f"),
("TF", "-43.00000000", "67.00000000", "French Southern Territories", "#98d84e"),
("TG", "8.00000000", "1.16670000", "Togo", "#de4c4f"),
("TH", "15.00000000", "100.00000000", "Thailand", "#eea638"),
("TJ", "39.00000000", "71.00000000", "Tajikistan", "#eea638"),
("TK", "-9.00000000", "-172.00000000", "Tokelau", "#8aabb0"),
("TM", "40.00000000", "60.00000000", "Turkmenistan", "#eea638"),
("TN", "34.00000000", "9.00000000", "Tunisia", "#de4c4f"),
("TO", "-20.00000000", "-175.00000000", "Tonga", "#8aabb0"),
("TR", "39.00000000", "35.00000000", "Turkey", "#d8854f"),
("TT", "11.00000000", "-61.00000000", "Trinidad and Tobago", "#a7a737"),
("TV", "-8.00000000", "178.00000000", "Tuvalu", "#8aabb0"),
("TW", "23.50000000", "121.00000000", "Taiwan", "#eea638"),
("TZ", "-6.00000000", "35.00000000", "Tanzania", "#de4c4f"),
("UA", "49.00000000", "32.00000000", "Ukraine", "#d8854f"),
("UG", "1.00000000", "32.00000000", "Uganda", "#de4c4f"),
("UM", "19.28330000", "166.60000000", "United States Minor Outlying Islands", "#eea638"),
("US", "38.00000000", "-97.00000000", "United States", "#a7a737"),
("UY", "-33.00000000", "-56.00000000", "Uruguay", "#86a965"),
("UZ", "41.00000000", "64.00000000", "Uzbekistan", "#eea638"),
("VA", "41.90000000", "12.45000000", "Holy See", "#d8854f"),
("VC", "13.25000000", "-61.20000000", "Saint Vincent and the Grenadines", "#a7a737"),
("VE", "8.00000000", "-66.00000000", "Venezuela", "#86a965"),
("VG", "18.50000000", "-64.50000000", "Virgin Islands", "#a7a737"),
("VI", "18.33330000", "-64.83330000", "Virgin Islands", "#a7a737"),
("VN", "16.00000000", "106.00000000", "Vietnam", "#eea638"),
("VU", "-16.00000000", "167.00000000", "Vanuatu", "#8aabb0"),
("WF", "-13.30000000", "-176.20000000", "Wallis and Futuna", "#a7a737"),
("WS", "-13.58330000", "-172.33330000", "Samoa", "#8aabb0"),
("YE", "15.00000000", "48.00000000", "Yemen, Rep.", "#eea638"),
("YT", "-12.83330000", "45.16670000", "Mayotte", "#de4c4f"),
("ZA", "-29.00000000", "24.00000000", "South Africa", "#de4c4f"),
("ZM", "-15.00000000", "30.00000000", "Zambia", "#de4c4f"),
("ZW", "-20.00000000", "30.00000000", "Zimbabwe", "#de4c4f"),
("MF", "18.40000000", "-63.40000000", "Saint Martin", "#a7a737"),
("CW", "9.30000000", "72.52600000", "Curacao", "#86a965");';
if ($my->query($sql_load_codes )) {
echo "
Chargement / loading table " . $PREFIX . "codes OK !
";
} else {
die("
Chargement / loading table " . $PREFIX . "codes en erreur / failed !
$sql_load_codes
");
}
$sql_config_sending = "ALTER TABLE `" . $PREFIX . "config`
CHANGE `sending_method` `sending_method` ENUM('smtp','lbsmtp','php_mail',
'php_mail_infomaniak','smtp_gmail_tls','smtp_gmail_ssl',
'smtp_mutu_ovh','smtp_mutu_1and1','smtp_mutu_gandi',
'smtp_mutu_online','smtp_mutu_infomaniak','smtp_over_tls',
'smtp_over_ssl'),
ADD `end_task` ENUM( '0', '1' ) NOT NULL default '1',
ADD `lost_pass` varchar(64) NOT NULL,
ADD `table_senders` varchar(255) NOT NULL,
ADD `table_users` varchar(255) NOT NULL,
ADD `table_codes` varchar(255) NOT NULL;";
if ($my->query($sql_config_sending)) {
echo "
Mise à jour / update table " . $PREFIX . "config sending_method OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "config sending_method en erreur / failed !
$sql_config_sending
");
}
$sql_update_config = "UPDATE `" . $PREFIX . "config` SET table_senders='" . $PREFIX . "senders',
table_users='" . $PREFIX . "users', table_codes='" . $PREFIX . "codes';";
if ($my->query($sql_update_config)) {
echo "
Mise à jour nouvelles valeurs / update table new values " . $PREFIX . "config OK !
";
} else {
die("
Mise à jour nouvelles valeurs / update table new values " . $PREFIX . "config en erreur / failed !
$sql_update_config
");
}
$sql_crontab_fields = "ALTER TABLE `" . $PREFIX . "crontab`
CHANGE `etat` `etat` ENUM('scheduled', 'running', 'done', 'deleted'),
CHANGE `mail_body` `mail_body` LONGTEXT NOT NULL,
CHANGE `list_id` `list_id` INT(4) NOT NULL DEFAULT '0',
CHANGE `mail_subject` `mail_subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;";
if ($my->query($sql_crontab_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "crontab OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "crontab en erreur / failed !
$sql_crontab_fields
");
}
$sql_email_fields = "ALTER TABLE `" . $PREFIX . "email`
CHANGE `type` `type` ENUM('','autoreply','blocked','generic','soft','hard','temporary','unsub','by_admin'),
CHANGE `list_id` `list_id` INT(4) NOT NULL DEFAULT '0';";
if ($my->query($sql_email_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "email OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "email en erreur / failed !
$sql_email_fields
");
}
$sql_email_deleted_fields = "ALTER TABLE `" . $PREFIX . "email_deleted`
CHANGE `type` `type` ENUM('','autoreply','blocked','generic','soft','hard','temporary','unsub','by_admin'),
CHANGE `list_id` `list_id` INT(4) NOT NULL DEFAULT '0';";
if ($my->query($sql_email_deleted_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "email_deleted OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "email_deleted en erreur / failed !
$sql_email_deleted_fields
");
}
$sql_drop_index_email_deleted="ALTER TABLE `" . $PREFIX . "email_deleted`
DROP INDEX unique_email_by_list";
if ($my->query($sql_drop_index_email_deleted)) {
echo "
Mise à jour / update table `" . $PREFIX . "email_deleted` OK !
";
} else {
echo "
Mise à jour / update table index unique_email_by_list déjà faite / ever done !
";
}
$sql_listsconfig_fields = "ALTER TABLE `" . $PREFIX . "listsconfig`
CHANGE `subject` `subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
CHANGE `subscription_subject` `subscription_subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
CHANGE `welcome_subject` `welcome_subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
CHANGE `quit_subject` `quit_subject` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';";
if ($my->query($sql_listsconfig_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "listsconfig OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "listsconfig en erreur / failed !
$sql_listsconfig_fields
");
}
$sql_send_fields = "ALTER TABLE `" . $PREFIX . "send`
CHANGE `id_list` `id_list` INT(4) NOT NULL DEFAULT '0';";
if ($my->query($sql_send_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "send OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "send en erreur / failed !
$sql_send_fields
");
}
$sql_create_senders = "CREATE TABLE IF NOT EXISTS `" . $PREFIX . "senders` (
`id_sender` varchar(255) CHARACTER SET utf8 NOT NULL,
`name_organisation` varchar(255) CHARACTER SET utf8 NOT NULL,
`email` varchar(255) CHARACTER SET utf8 NOT NULL,
`email_reply` varchar(255) CHARACTER SET utf8 NOT NULL,
`smtp` varchar(255) CHARACTER SET utf8 NOT NULL,
`smtp_port` int(5) NOT NULL,
`smtp_option` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT 'notls',
`smtp_auth` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`smtp_user` varchar(255) CHARACTER SET utf8 NOT NULL,
`smtp_password` varchar(255) CHARACTER SET utf8 NOT NULL,
`bounce_email` varchar(255) CHARACTER SET utf8 NOT NULL,
`bounce_server` varchar(255) CHARACTER SET utf8 NOT NULL,
`bounce_user` varchar(255) CHARACTER SET utf8 NOT NULL,
`bounce_password` varchar(255) CHARACTER SET utf8 NOT NULL,
`bounce_service` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT 'imap',
`bounce_port` int(5) NOT NULL,
`bounce_option` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT 'notls',
`last_send` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if ($my->query($sql_create_senders)) {
echo "
Création / create table " . $PREFIX . "senders OK !
";
} else {
die("
Création / create table " . $PREFIX . "senders en erreur / failed !
$sql_create_senders
");
}
$sql_senders_fields = "ALTER TABLE `" . $PREFIX . "senders`
ADD UNIQUE KEY `email` (`email`), ADD KEY `last_send` (`last_send`);";
if ($my->query($sql_senders_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "email OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "email en erreur / failed !
$sql_senders_fields
");
}
$sql_send_suivi_fields = "ALTER TABLE `" . $PREFIX . "send_suivi`
CHANGE `list_id` `list_id` INT(4) NOT NULL DEFAULT '0';";
if ($my->query($sql_send_suivi_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "send_suivi OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "send_suivi en erreur / failed !
$sql_send_suivi_fields
");
}
$sql_track_fields = "ALTER TABLE `" . $PREFIX . "track`
ADD `lat` decimal(10,8) NOT NULL,
ADD `lng` decimal(11,8) UNSIGNED NOT NULL,
ADD `city` varchar(255) NOT NULL,
ADD `postal_code` varchar(255) NOT NULL,
ADD `region` varchar(255) NOT NULL,
ADD `country` varchar(255) NOT NULL,
ADD KEY `lat` (`lat`),
ADD KEY `lng` (`lng`),
ADD KEY `city` (`city`),
ADD KEY `postal_code` (`postal_code`),
ADD KEY `region` (`region`),
ADD KEY `country` (`country`);";
if ($my->query($sql_track_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "track OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "track en erreur / failed !
$sql_track_fields
");
}
$sql_track_links_fields = "ALTER TABLE `" . $PREFIX . "track_links`
ADD `dt_track_link` DATETIME,
ADD KEY `dt_track_link` (`dt_track_link`);";
if ($my->query($sql_track_links_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "track_links OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "track_links en erreur / failed !
$sql_track_links_fields
");
}
$sql_upload_fields = "ALTER TABLE `" . $PREFIX . "upload`
CHANGE `name` `name` VARCHAR(2000) DEFAULT NULL;";
if ($my->query($sql_upload_fields)) {
echo "
Mise à jour / update table " . $PREFIX . "upload OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "upload en erreur / failed !
$sql_upload_fields
");
}
$sql_create_smtp = "CREATE TABLE IF NOT EXISTS `" . $PREFIX . "smtp` (
`smtp_id` int(7) NOT NULL,
`smtp_name` text NOT NULL,
`smtp_url` varchar(255) NOT NULL,
`smtp_user` text CHARACTER SET utf8mb4 NOT NULL,
`smtp_pass` text NOT NULL,
`smtp_port` int(5) unsigned NOT NULL,
`smtp_secure` text NOT NULL,
`smtp_limite` int(4) unsigned NOT NULL,
`smtp_used` int(4) unsigned NOT NULL,
`smtp_date_create` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`smtp_date_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`id_use` int(6) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if ($my->query($sql_create_smtp)) {
echo "
Mise à jour / update table " . $PREFIX . "smtp OK !
";
} else {
die("
Mise à jour / update table " . $PREFIX . "smtp en erreur / failed !
$sql_create_smtp
");
}
$sql_create_users = "CREATE TABLE IF NOT EXISTS `" . $PREFIX . "users` (
`id_user` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(64) NOT NULL,
`listes` varchar(1) NOT NULL DEFAULT 'Y',
`abonnes` varchar(1) NOT NULL DEFAULT 'Y',
`redaction` varchar(1) NOT NULL DEFAULT 'Y',
`envois` varchar(1) NOT NULL DEFAULT 'Y',
`stats` varchar(1) NOT NULL DEFAULT 'Y',
`bounce` varchar(1) NOT NULL DEFAULT 'Y',
`liste` int(4) unsigned NOT NULL,
`log` varchar(1) NOT NULL DEFAULT 'Y',
KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if ($my->query($sql_create_users)) {
echo "
Création / create table " . $PREFIX . "users OK !
";
} else {
die("
Création / create table " . $PREFIX . "users en erreur / failed !
$sql_create_users
");
}
$configfile = "Création du fichier config.php / create file config.php OK !";
} else {
echo "
Erreur de création du fichier de config :
$configfile !
";
}
echo "
";
break;
case 'thatsallfolks':
echo "
Fin de la mise à jour / End of the update OK !
";
echo '
La mise à jour est terminée !
Vous devez vous connecter avec votre email administrateur et votre mot de passe.
Les anciens fichiers de la version mise à jour ont été sauvegardés dans le répertoire ' . $PATH_BACKUP_CURRENT_VERSION . '/, fichiers et base de données.
En cas de problèmes, le support est sur le forum : Forum
Je souhaite sincèrement que vous apprécierez la nouvelle version de PhpMyNewsLetter !
Arnaud';
echo '
Update is OK !
Now, you have to connect with your email admin and your password.
Backup files and database are stored in ' . $PATH_BACKUP_CURRENT_VERSION . '/ directory.
If troubles, please feel free to ask for support on the official board : Forum
I really hop you will enjoy to use this new version of PhpMyNewsLetter !
Arnaud
';
echo '
';
break;
default:
die("
Oups ! Page inconnue !
Oups ! Unknown page
");
break;
}
?>