public function updateDatabase()
{
$fileTempAdmin = BASE . 'temp/admin.php';
if (is_file($fileTempAdmin)) {
$cFile = file_get_contents($fileTempAdmin);
$cOutFile = unserialize($cFile);
$adm_email = $cOutFile['email'];
}
$fileTempDatabase = BASE . 'temp/database.php';
if (is_file($fileTempDatabase)) {
$cFileDatabase = file_get_contents($fileTempDatabase);
if ($cOutFileDatabase = unserialize($cFileDatabase)) {
$sql_host = $cOutFileDatabase['hote'];
$sql_db = $cOutFileDatabase['name'];
$sql_login = $cOutFileDatabase['login'];
$sql_pwd = $cOutFileDatabase['password'];
}
$db = new CRUD($sql_host, $sql_db, $sql_login, $sql_pwd);
$fileTempWebsite = BASE . 'temp/website.php';
if (is_file($fileTempWebsite)) {
$cFileWebiste = file_get_contents($fileTempWebsite);
if ($cOutFileWebsite = unserialize($cFileWebiste)) {
$dataTrad['title'] = $cOutFileWebsite['title'];
$dataTrad['slogan'] = $cOutFileWebsite['slogan'];
$dataTrad['description'] = $cOutFileWebsite['description'];
$dataTrad['copyright'] = $cOutFileWebsite['copyright'];
$dataTrad['year'] = $cOutFileWebsite['year'];
$dataTrad['keywords'] = $cOutFileWebsite['keywords'];
$dataTrad['date_modification'] = time();
if (!empty($cOutFile)) {
$fileTempUser = BASE . 'temp/_fromUser.php';
if (is_file($fileTempUser)) {
$dataFileUser = file_get_contents($fileTempUser);
if ($dataUser = unserialize($dataFileUser)) {
$dataUserId = $dataUser['user_id'];
$login = $cOutFile['email'];
$crypto = $this->_cryptMe($cOutFile['password']);
$queryUser['login'] = $login;
$queryUser['password'] = $crypto['password'];
$queryUser['salt'] = $crypto['salt'];
$db->dbQU($dataUserId, $queryUser, '_users');
$queryUserInfo['email'] = $login;
$queryUserInfo['langue'] = $_SESSION['doorgetsLanguage'];
$db->dbQU($dataUserId, $queryUserInfo, '_users_info');
$arrGroupeLangue = array();
foreach ($this->doorgets->allLanguages as $key_language => $label) {
$dataTrad['langue'] = $key_language;
$db->dbQD($key_language, '_website_traduction', 'langue', '=', '');
$arrGroupeLangue[$key_language] = $db->dbQI($dataTrad, '_website_traduction');
}
$lgActuel = $this->doorgets->getLanguage();
$dataWebsite['version_doorgets'] = '7.0';
$dataWebsite['langue'] = $lgActuel;
$dataWebsite['langue_front'] = $lgActuel;
$dataWebsite['langue_groupe'] = serialize(array($lgActuel => $lgActuel));
$dataWebsite['horaire'] = $this->doorgets->getTimeZone();
$dataWebsite['email'] = $adm_email;
$db->dbQU(1, $dataWebsite, '_website');
}
}
}
}
}
}
}
public function updateDatabase($data = array())
{
$adm_email = $data['user_email'];
$sql_host = $data['database_host'];
$sql_db = $data['database_name'];
$sql_login = $data['database_login'];
$sql_pwd = $data['database_password'];
$db = new CRUD($sql_host, $sql_db, $sql_login, $sql_pwd);
$dataTrad['title'] = $data['website_title'];
$dataTrad['slogan'] = $data['website_slogan'];
$dataTrad['description'] = $data['website_meta_description'];
$dataTrad['copyright'] = $data['website_copyright'];
$dataTrad['year'] = $data['website_year_creation'];
$dataTrad['keywords'] = $data['website_meta_keywords'];
$dataTrad['date_modification'] = time();
$fileTempUser = BASE . 'temp/_fromUser.php';
if (is_file($fileTempUser)) {
$dataFileUser = file_get_contents($fileTempUser);
if ($dataUser = unserialize($dataFileUser)) {
$dataUserId = $dataUser['user_id'];
$login = $data['user_email'];
$crypto = $this->_cryptMe($data['user_password']);
$queryUser['login'] = $login;
$queryUser['password'] = $crypto['password'];
$queryUser['salt'] = $crypto['salt'];
$db->dbQU($dataUserId, $queryUser, '_users');
$queryUserInfo['email'] = $login;
$queryUserInfo['langue'] = $data['langue'];
$db->dbQU($dataUserId, $queryUserInfo, '_users_info');
$arrGroupeLangue = array();
foreach ($this->allLanguages as $key_language => $label) {
$dataTrad['langue'] = $key_language;
$db->dbQD($key_language, '_website_traduction', 'langue', '=', '');
$arrGroupeLangue[$data['langue']] = $db->dbQI($dataTrad, '_website_traduction');
}
$dataWebsite['version_doorgets'] = '7.0';
$dataWebsite['langue'] = $data['langue'];
$dataWebsite['langue_front'] = $data['langue'];
$dataWebsite['langue_groupe'] = serialize(array($data['langue'] => $data['langue']));
$dataWebsite['horaire'] = $data['timezone'];
$dataWebsite['email'] = $adm_email;
$db->dbQU(1, $dataWebsite, '_website');
}
}
}
if ($userId == 0) {
$userExists = $crud->dbQS($email, '_users', 'login');
if (!empty($userExists)) {
$UserFacebookEntity->setIdUser($userExists['id']);
$UserFacebookEntity->save();
$userInfoExists = $crud->dbQS($userExists['id'], '_users_info', 'id_user');
if (!empty($userInfoExists)) {
// Connect user
$_token = md5(uniqid(mt_rand(), true));
$_SESSION['doorgets_user']['id'] = $userInfoExists['id_user'];
$_SESSION['doorgets_user']['groupe'] = $userInfoExists['network'];
$_SESSION['doorgets_user']['login'] = $userExists['login'];
$_SESSION['doorgets_user']['password'] = $userExists['password'];
$_SESSION['doorgets_user']['langue'] = $userInfoExists['langue'];
$_SESSION['doorgets_user']['token'] = $_token;
$crud->dbQU($userExists['id'], array('token' => $_token), '_users');
FlashInfo::set(':)');
}
} else {
header('Location: ' . BASE_URL . 'dg-user/' . $urlTraduction . '?controller=authentification&action=register');
exit;
}
}
} else {
$_SESSION = array();
header('Location: ' . BASE_URL . 'dg-user/' . $urlTraduction . '?controller=authentification&action=register&ss');
exit;
}
header('Location: ' . $url);
exit;
} else {
