public function loginAction()
{
if (Tools::isPost()) {
$email = Tools::getValue('email');
$password = Tools::getValue('password');
$sql = "select ID, UniversalID, PasswordHash from Users where (UniversalType = 1) and (email = '{$email}');";
$user = GetMainConnection()->query($sql)->fetch();
if (!empty($user['ID'])) {
if (VerifyPassword($password, $user['PasswordHash'])) {
unset($password);
$sql = "update Users " . "set RememberMe = '" . POSTBoolAsSQLStr('RememberMeEdt') . "' " . "where (ID = " . $user['ID'] . ");";
GetMainConnection()->exec($sql);
if (LoginUsingUniversalID($user['UniversalID'])) {
if (empty($_SESSION['login_redirect'])) {
return AddAlertMessage('success', 'Добро пожаловать!', '/');
} else {
$vRedirect = $_SESSION['login_redirect'];
unset($_SESSION['login_redirect']);
Redirect($vRedirect);
}
}
} else {
unset($password);
AddAlertMessage('danger', 'Неверный e-mail или пароль.');
}
} else {
unset($password);
AddAlertMessage('danger', 'E-mail не найден.');
}
}
// https://developers.facebook.com/docs/php/gettingstarted/5.0.0
// https://developers.facebook.com/docs/php/Facebook/5.0.0
// http://25labs.com/tutorial-integrate-facebook-connect-to-your-website-using-php-sdk-v-3-x-x-which-uses-graph-api/
require_once PATH_SITE_ROOT . 'core/facebook-php-sdk-v4-5.0-dev/src/Facebook/autoload.php';
$facebook = new Facebook\Facebook(['app_id' => facebook_app_id, 'app_secret' => facebook_app_secret, 'default_graph_version' => facebook_graph_version]);
$helper = $facebook->getRedirectLoginHelper();
$permissions = ['email'];
// optional
$FB_LoginUrl = $helper->getLoginUrl('http://karapuz.life/app/common/facebook_login_callback.php', $permissions);
$VK_LoginUrl = 'https://oauth.vk.com/authorize?client_id=' . vk_app_id . '&scope=offline,email&redirect_uri=' . urlencode('http://karapuz.life/app/common/vk_login_callback.php') . '&response_type=code';
$this->view->setVars(array('FB_LoginUrl' => $FB_LoginUrl, 'VK_LoginUrl' => $VK_LoginUrl));
$this->view->breadcrumbs = array(array('url' => '/auth/login', 'title' => 'Вход на сайт'));
$this->view->meta = array('meta_title' => 'Войти на сайт', 'meta_description' => 'Войти на сайт', 'meta_keywords' => '');
$this->view->generate();
}
}
$sql = "select ID " . "from ArticleComments " . "where (ArticleID = {$id}) " . "and (UnknownUserGUID = '{$vUnknownUserGUID}') " . "and (UserID = {$vUserID}) " . "and (Comment = '{$Comment}');";
$rec = GetMainConnection()->query($sql)->fetch();
if (empty($rec['ID'])) {
$sql = "insert into ArticleComments(ArticleID, UnknownUserGUID, UserID, UserName, CommentDate, Comment) " . "values({$id}, '{$vUnknownUserGUID}', {$vUserID}, '{$UserName}', '" . GetLocalDateTimeAsSQLStr() . "', '{$Comment}');";
GetMainConnection()->exec($sql);
/*$sql = "insert into CatalogRatings(CatalogItemID, UserID, UnknownUserGUID, Rating1, Rating2, Rating3) ".
"select * from (select $id as C1, $vUserIDForIns as C2, $vUnknownUserGUIDForIns as C3, $Rating1 as C4, $Rating2 as C5, $Rating3 as C6) AS tmp ".
"where not exists ( ".
"select ID ".
"from CatalogRatings ".
"where (CatalogItemID = $id) ".
"and (UserID $vUserID) ".
"and (UnknownUserGUID $vUnknownUserGUID) ".
") limit 1;";*/
if (POSTBoolAsSQLStr('PriorNotifyStateEdt') != $IsNotifyRecipientActive) {
if ($IsNotifyRecipientActive == '1') {
Emails_AddNotifyRecipient(1, $id, $OwnerEmail);
} else {
Emails_DeleteNotifyRecipient(1, $id, $OwnerEmail);
}
}
$sql = "select CategoryID, Name from Articles where (ID = {$id});";
$rec = GetMainConnection()->query($sql)->fetch();
$vBodyParam = array('[year]' => date("Y", time()), '[name]' => $UserName, '[msgbody]' => $Comment, '[doclink]' => URL . 'articles/c-' . $rec['CategoryID'] . '/a-' . $id, '[unsubscribe]' => URL . 'email/unsubscribe/' . Encrypt_Blowfish('1||' . $id, EMAIL_BLOWFISHGUID));
$vBody = Emails_PrepareBodyUseTemplate('article_comment', $vBodyParam);
Emails_AddNotify(1, $id, 'Новый комментарий к статье: "' . $rec['Name'] . '"', $vBody, $OwnerEmail);
/*$content = array(
'title' => 'Re: '.$rec['MessageSubject'],
'template' => 'answercontactus',
'data' => array('[year]' => date("Y",time()),
