fortunato

 
--
-- Дамп данных таблицы `cms_users`
--
 
INSERT INTO `cms_users` (`id`, `group_id`, `login`, `nickname`, `password`, `email`, `icq`, `regdate`, `logdate`, `birthdate`, `is_locked`, `is_deleted`, `is_logged_once`, `rating`, `points`, `last_ip`, `status`, `status_date`, `invited_by`, `invdate`, `openid`, `balance`, `ref_id`) VALUES
(233, 1, 'AlyonaGorbunova', 'Блондинка.........', '***********', 'Gorbynova.AG@*********', '432228126', '2010-08-21 13:22:43', '2013-03-15 23:41:16', '1982-01-22', 0, 0, 1, 3886, 0, '94.41.156.251', '*******', '2013-01-29 12:51:33', NULL, NULL, NULL, 0, 0),
(6695, 1, 'alyonagorbunova', 'Алёна Горбунова', '**************', '', '', '2013-02-26 18:16:41', '2013-02-26 18:16:41', '0000-05-24', 0, 0, 1, 0, 0, '', NULL, NULL, NULL, NULL, 'http://vk.com/id261919**', 0, 0);
 
 

 
            while ($user = $inDB->fetch_assoc($users_result)){
 
            if ($user['id'] == $inUser->id) { continue; }
 
            if ($user['subscribe_type']=='priv' || $user['subscribe_type']=='both'){
                $message = 'Произошло обновление: <a href="'.$comment['target_link'].'">'.$comment['target_title'].'</a>';
                self::sendMessage(USER_UPDATER, $user['id'], $message);
            }
 
            if ($user['subscribe_type']=='mail' || $user['subscribe_type']=='both'){
                if (!$user['email']) { continue; }
                $user_letter = str_replace('{sitename}', $inConf->sitename, $letter);
                $user_letter = str_replace('{answerlink}', HOST.$comment['target_link'], $user_letter);
                $user_letter = str_replace('{pagetitle}', $comment['target_title'], $user_letter);
                $user_letter = str_replace('{date}', $postdate, $user_letter);
                $user_letter = str_replace('{author}', $comment['author'], $user_letter);
            //  $inCore->mailText($user['email'], $letter_title.' - '.$inConf->sitename, $user_letter);
                $subcomment = substr($comment['content'], 0, 1000);
                $user_letter = str_replace('{content}', $subcomment, $user_letter);
                $user_letter = str_replace('{p_id}', $comment['thread_id'], $user_letter);
 
				$user1 = $user['id'];
				$user2 = $inDB->get_fields('cms_users', "id = '$user1'", 'login');	
				$user_login = $user2['login'];
				$user_letter = str_replace('{user_login}', $user_login, $user_letter);
 
                $inCore->mailText($user['email'], 'Форум: '.$comment[target_title].' - '.$inConf->sitename, $user_letter,'text/html');
 
                unset($user_letter);
            }
 
        }
 
        return;
    }
 

 
        //либо получаем нужную тему форума и автора последнего сообщения
        if ($target == 'forum'){
            $comment_sql    = "SELECT   ft.title as target_title,
                                        ft.id as thread_id,
                                        ft.post_count,
                                        fp.id as post_id,
                                        u.nickname as author,
                                        fp.content as content
                               FROM cms_forum_threads ft, cms_forum_posts fp, cms_users u
                               WHERE fp.thread_id='{$target_id}' AND fp.thread_id=ft.id AND fp.user_id = u.id
                               ORDER BY fp.pubdate DESC
                               LIMIT 1";
            $f_c = $inCore->loadComponentConfig('forum');
        }