function getMessage($id)
 {
     $result = $this->where(array('id' => (int) $id))->fetchAll();
     if (sizeof($result) == 0) {
         return false;
     }
     $value = $result[0];
     $userModel = new connectionUserModel();
     $messageModel = new connectionMessageModel();
     $source = $messageModel->getFromId($value['message_id']);
     if (!$source) {
         return false;
     }
     $message = array();
     $message['id'] = (int) $value['id'];
     $message['type'] = $value['type'];
     $message['from'] = $userModel->getFromId($source['from']);
     $message['to'] = $userModel->getFromId($source['to']);
     $message['date'] = $value['date'];
     $message['state'] = $source['state'];
     $message['text'] = $source['text'];
     $message['attachment'] = isset($source['attachment']) ? $source['attachment'] : array();
     $message['str_date'] = date("d.m.Y h:i:s", $value['date']);
     return $message;
 }
 function execute()
 {
     $user_id = Request::get('user_id');
     $model = new connectionUserModel();
     $user = $model->getFromId((int) $user_id);
     if (!$user || $user['status'] != connectionUserModel::STATUS_PUBLISHED) {
         $this->showNotFound();
         return;
     }
     $userInfo = $model->getInfo((int) $user['id']);
     $fieldsModel = new connectionFieldsModel();
     $this->setSeoPage('profile');
     return array('user_profile' => $userInfo, 'video' => connectionUserVideoModel::create()->where(array('user' => (int) $user_id, 'status' => 'published'))->sort('date', -1)->fetchAll(), 'fields' => array('info' => $fieldsModel->getGroupLocale('info', Language::getActiveLanguageISO(), true), 'interest' => $fieldsModel->getGroupLocale('interest', Language::getActiveLanguageISO(), true)));
 }