if (isFormValid()) {
if (isset($_GET['infosNotification']) and $_GET['infosNotification'] == 'on') {
include_once INSTALL_PATH . '/classes/ToolsInstall.php';
$smtpChecked = trim($_GET['infosMailMethod']) == 'smtp';
$smtpServer = $_GET['smtpSrv'];
$subject = $_GET['infosShop'] . " - " . $_GET['mailSubject'];
$type = 'text/html';
$to = $_GET['infosEmail'];
$from = "no-reply@" . ToolsInstall::getHttpHost(false, true, true);
$smtpLogin = $_GET['smtpLogin'];
$smtpPassword = $_GET['smtpPassword'];
$smtpPort = $_GET['smtpPort'];
//'default','secure'
$smtpEncryption = $_GET['smtpEnc'];
//"tls","ssl","off"
$content = ToolsInstall::getNotificationMail($_GET['infosShop'], INSTALLER__PS_BASE_URI_ABSOLUTE, INSTALLER__PS_BASE_URI_ABSOLUTE . "img/logo.jpg", ToolsInstall::strtoupper($_GET['infosFirstname']), $_GET['infosName'], $_GET['infosPassword'], $_GET['infosEmail']);
$result = @ToolsInstall::sendMail($smtpChecked, $smtpServer, $content, $subject, $type, $to, $from, $smtpLogin, $smtpPassword, $smtpPort, $smtpEncryption);
}
}
//Insert configuration parameters into the database
$error['infosInsertSQL'] = '';
if (isFormValid()) {
$sqlParams = array();
$sqlParams[] = "INSERT IGNORE INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_SHOP_DOMAIN', '" . Tools::getHttpHost() . "', NOW(), NOW())";
$sqlParams[] = "INSERT IGNORE INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_SHOP_DOMAIN_SSL', '" . Tools::getHttpHost() . "', NOW(), NOW())";
$sqlParams[] = "INSERT IGNORE INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_INSTALL_VERSION', '" . pSQL(INSTALL_VERSION) . "', NOW(), NOW())";
$sqlParams[] = "INSERT IGNORE INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_SHOP_NAME', '" . pSQL($_GET['infosShop']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT IGNORE INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_SHOP_EMAIL', '" . pSQL($_GET['infosEmail']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT IGNORE INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_METHOD', '" . pSQL($_GET['infosMailMethod'] == "smtp" ? "2" : "1") . "', NOW(), NOW())";
$sqlParams[] = 'UPDATE ' . _DB_PREFIX_ . 'configuration SET value = \'' . pSQL($_GET['isoCode']) . '\' WHERE name = \'PS_LOCALE_LANGUAGE\'';
$sqlParams[] = 'UPDATE ' . _DB_PREFIX_ . 'configuration SET value = \'' . (int) $_GET['catalogMode'] . '\' WHERE name = \'PS_CATALOG_MODE\'';
$sqlParams = array();
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_SHOP_NAME', '" . pSQL($_GET['infosShop']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_SHOP_EMAIL', '" . pSQL($_GET['infosEmail']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_METHOD', '" . pSQL($_GET['infosMailMethod'] == "smtp" ? "2" : "1") . "', NOW(), NOW())";
$sqlParams[] = 'UPDATE ' . _DB_PREFIX_ . 'configuration SET value = (SELECT id_lang FROM ' . _DB_PREFIX_ . 'lang WHERE iso_code = \'' . pSQL($_GET['isoCode']) . '\') WHERE name = \'PS_LANG_DEFAULT\'';
if (intval($_GET['infosCountry']) != 0) {
$sqlParams[] = 'UPDATE ' . _DB_PREFIX_ . 'configuration SET value = ' . intval($_GET['infosCountry']) . ' WHERE name = \'PS_COUNTRY_DEFAULT\'';
}
if (isset($_GET['infosMailMethod']) and $_GET['infosMailMethod'] == "smtp") {
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_SERVER', '" . pSQL($_GET['smtpSrv']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_USER', '" . pSQL($_GET['smtpLogin']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_PASSWD', '" . pSQL($_GET['smtpPassword']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_SMTP_ENCRYPTION', '" . pSQL($_GET['smtpEnc']) . "', NOW(), NOW())";
$sqlParams[] = "INSERT INTO " . _DB_PREFIX_ . "configuration (name, value, date_add, date_upd) VALUES ('PS_MAIL_SMTP_PORT', '" . pSQL($_GET['smtpPort']) . "', NOW(), NOW())";
}
$sqlParams[] = 'INSERT INTO ' . _DB_PREFIX_ . 'employee (id_employee, lastname, firstname, email, passwd, last_passwd_gen, active, id_profile) VALUES (NULL, \'' . pSQL(ToolsInstall::strtoupper($_GET['infosName'])) . '\', \'' . pSQL(ToolsInstall::ucfirst($_GET['infosFirstname'])) . '\', \'' . pSQL($_GET['infosEmail']) . '\', \'' . md5(pSQL(_COOKIE_KEY_ . $_GET['infosPassword'])) . '\', \'' . date('Y-m-d h:i:s', strtotime('-360 minutes')) . '\', 1, 1)';
$sqlParams[] = 'INSERT INTO ' . _DB_PREFIX_ . 'contact (id_contact, email) VALUES (NULL, \'' . pSQL($_GET['infosEmail']) . '\'), (NULL, \'' . pSQL($_GET['infosEmail']) . '\')';
$dbInstance = Db::getInstance();
foreach ($sqlParams as $query) {
if (!$dbInstance->Execute($query)) {
$error['infosInsertSQL'] = '11';
}
}
unset($dbInstance);
}
//////////////////////////
// Building XML Response//
//////////////////////////
echo '<shopConfig>' . "\n";
foreach ($error as $key => $line) {
echo '<field id="' . $key . '" result="' . ($line != "" ? 'fail' : 'ok') . '" error="' . $line . '" />' . "\n";
