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 {