public static function edit($pin_id, $data)
{
$pin_info = self::getPin($pin_id);
if (!$pin_info) {
return;
}
$db = JO_Db::getDefaultAdapter();
$date_modified = WM_Date::format(time(), 'yy-mm-dd H:i:s');
$board_info = Model_Boards::getBoard($data['board_id']);
$source_id = Model_Source::getSourceByUrl($data['from']);
/* price */
$price = $pin_info['price'];
if (preg_match('/(\\$|\\£|\\€|\\¥|\\₪|zł|\\฿)([\\s]{0,2})?(?:(?:\\d{1,5}(?:\\,\\d{3})+)|(?:\\d+))(?:\\.\\d{2})?/', $data['price'], $match)) {
$price_tmp = trim(str_replace(trim($match[1]), '', $match[0]));
$currency = self::getCurrencyBySimbol(trim($match[1]));
if ($currency) {
$price = round($price_tmp / $currency, 4);
}
}
$data['is_video'] = 'false';
$help_video = new Helper_AutoEmbed();
if ($help_video->parseUrl($data['from'])) {
$data['is_video'] = 'true';
}
$is_update = $db->update('pins', array('category_id' => (string) $board_info['category_id'], 'board_id' => $data['board_id'], 'date_modified' => $date_modified, 'from' => $data['from'], 'from_md5' => md5($data['from']), 'description' => $data['description'], 'price' => $price, 'is_video' => $data['is_video'] == 'true' ? 1 : 0, 'source_id' => isset($data['source_id']) ? $data['source_id'] : $source_id, 'date_modified' => new JO_Db_Expr('NOW()')), array('pin_id = ?' => $pin_id));
$spl = JO_Utf8::str_word_split(strip_tags(html_entity_decode($data['description'], ENT_QUOTES, 'utf-8')), self::$searchWordLenght);
$words = array();
foreach ($spl as $word) {
$word = mb_strtolower($word, 'utf-8');
if (!in_array($word, self::common()) && $word[0] . $word[1] != '&#') {
$words[$word] = $word;
}
}
foreach ($words as $word => $data1) {
$dic_id = $db->fetchOne($db->select()->from('pins_dictionary', 'dic_id')->where('word = ?', $word));
if (!$dic_id) {
$db->insert('pins_dictionary', array('word' => $word));
$dic_id = $db->lastInsertId();
}
if ($dic_id) {
$db->insert('pins_invert', array('pin_id' => $pin_id, 'dic_id' => $dic_id));
}
}
if ($pin_info['board_id'] != $data['board_id']) {
//mahame i slagame ot stariq i v noviq/////
Model_Boards::updateLatestPins($pin_info['board_id']);
Model_Boards::updateLatestPins($data['board_id']);
$board_info2 = Model_Boards::getBoard($pin_info['board_id']);
if ($board_info2['cover'] == $pin_id) {
$db->update('boards', array('cover' => 0), array('board_id = >' => $pin_info['board_id']));
}
}
Model_Users::updateLatestPins($pin_info['user_id']);
self::deleteCache($pin_info);
}
public function upload_mobileAction()
{
$this->noViewRenderer(true);
$this->noLayout(true);
$request = $this->getRequest();
if (JO_Registry::get('isMobile') && JO_Session::get('upload_from_file') && file_exists(BASE_PATH . JO_Session::get('upload_from_file'))) {
$image = "<img src='" . JO_Session::get('upload_from_file') . "'>";
$boards = Model_Boards::getBoards(array('filter_user_id' => JO_Session::get('user[user_id]'), 'order' => 'boards.sort_order', 'sort' => 'ASC', 'friendly' => JO_Session::get('user[user_id]')));
$data['boards'] = $boards;
$data['image'] = $image;
$data['phrases'] = array('create_board' => $this->translate("Create New Board"), 'upload_button' => $this->translate("Upload"), 'select_board' => $this->translate("Select Board"), 'textarea_validation' => $this->translate("Please add a description"), 'board_validation' => $this->translate("Please add a board title"), 'notEmptyMsg' => $this->translate("Please choose board"));
echo JO_Json::encode((object) $data);
}
}
public static function returnHtmlDetail()
{
//XPER: función que carga PIN
static $view = null, $model_images = null, $request = null;
if ($view === null) {
$view = JO_View::getInstance();
}
if ($model_images === null) {
$model_images = new Helper_Images();
}
if ($request === null) {
$request = JO_Request::getInstance();
}
//$request = $this->getRequest();
//////////// Categories ////////////
$view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$view->categories[] = $category;
}
//////////// Age ////////////
$view->ages = array();
$ages = Model_Users::getAge();
$view->ages = $ages;
//////////// Level ////////////
$view->levels = array();
$levels = Model_Users::getLevel();
$view->levels = $levels;
$user_data = Model_Users::getActivateUser(JO_Session::get('user[user_id]'));
$view->user_data = $user_data;
if (JO_Registry::get('isMobile')) {
$view->urlmensajes = WM_Router::create($request->getBaseUrl() . '?controller=users&action=mensajes&user_id=' . $request->getRequest('board_user'));
}
//gender
if ($request->issetPost('gender')) {
$view->gender = $request->getRequest('gender');
} elseif (isset($user_data['gender'])) {
$view->gender = $user_data['gender'];
} else {
$view->gender = "";
}
//location
if ($request->issetPost('location')) {
$view->location = $request->getPost('location');
} elseif (isset($user_data['location'])) {
$view->location = $user_data['location'];
} else {
$view->location = '';
}
//sport category
if ($request->issetPost('sport_category')) {
$view->sport_category = $request->getPost('sport_category');
if ($request->getPost('sport_category') != "") {
$view->cat_title = Model_Boards::getCategoryTitle($request->getPost('sport_category'));
}
} elseif (isset($user_data['sport_category'])) {
$view->sport_category = $user_data['sport_category'];
$view->cat_title = Model_Boards::getCategoryTitle($user_data['sport_category']);
} else {
$view->cat_title = '';
$view->sport_category = '';
}
//age
if ($request->issetPost('age')) {
$view->age = $request->getPost('age');
if ($request->getPost('age') != "") {
$view->age_title = Model_Users::getAgeTitle($request->getPost('age'));
}
} elseif (isset($user_data['age'])) {
$view->age = $user_data['age'];
$view->age_title = Model_Users::getAgeTitle($user_data['age']);
} else {
$view->age_title = '';
$view->age = '';
}
//level
if ($request->issetPost('level')) {
$view->level = $request->getPost('level');
if ($request->getPost('level') != "") {
$view->level_title = Model_Users::getLevelTitle($request->getPost('level'));
}
} elseif (isset($user_data['level'])) {
$view->level = $user_data['level'];
$view->level_title = Model_Users::getLevelTitle($user_data['level']);
} else {
$view->level_title = '';
$view->level = '';
}
//comment
if ($request->issetPost('comment')) {
$view->comment = $request->getPost('comment');
} elseif (isset($user_data['comment'])) {
$view->comment = $user_data['comment'];
} else {
$view->comment = '';
}
//$view->form_action = WM_Router::create( $request->getBaseUrl() . '?controller=addpin&action=get_images' );
//$view->from_url = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=activatePopup' );
$view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=users&action=activateDetail');
//$view->popup_main_box = $view->render('activatePopup','users');
$view->popup_main_box = $view->render('activateDetail', 'users');
return $view->render('activateDetail', 'users');
}
public static function deleteUser($user_id)
{
$db = JO_Db::getDefaultAdapter();
$user_info = self::getUser($user_id);
if (!$user_info) {
return;
}
/*if($user_info['store'] == 's3') {
self::deleteImagesAmazon($user_info['avatar']);
} else {
if($user_info['avatar']) {
$model_image = new Helper_Images();
$model_image->deleteImages($user_info['avatar']);
}
}*/
$query = $db->select()->from('boards')->where('user_id = ?', (string) $user_id);
$rows = $db->fetchAll($query);
if ($rows) {
foreach ($rows as $row) {
Model_Boards::delete($row['board_id']);
}
}
$ext = Model_Extensions_Install::getByMethod('user_login');
$front = JO_Front::getInstance();
foreach ($ext as $login) {
$model = $front->formatModuleName('model_' . $login . '_users');
$instance = new $model();
$instance->deleteByUserId($user_id);
}
$db->query("DELETE FROM url_alias WHERE query = 'user_id=" . (string) $user_id . "'");
$db->delete('users_boards', array('user_id = ?' => (string) $user_id));
$db->delete('shared_content', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('following_id = ?' => (string) $user_id));
$db->delete('users_history', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_history', array('to_user_id = ?' => (string) $user_id));
$db->delete('users', array('user_id = ?' => (string) $user_id));
}
public function registerAction()
{
$request = $this->getRequest();
$_SESSION["deportes_url"] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=register');
$this->view->deportes = WM_Router::create($request->getBaseUrl() . '?controller=users&action=deportes');
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
//////////// User Type ////////////
$this->view->user_types = array();
$user_types = Model_Users::getUserType(array('filter_status' => 1));
foreach ($user_types as $user_type) {
$user_type['subuser_types'] = Model_Users::getSubUserType($user_type['user_type_id']);
$this->view->user_types[] = $user_type;
}
$this->view->user_sports = array();
$users_sports = Model_Users::getUserSports(0);
$i = 0;
foreach ($users_sports as $user_sports) {
if ($user_sports['sport_category'] != 1) {
if (!Model_Boards::isCategoryParent($user_sports['sport_category'])) {
$this->view->user_sports[] = Model_Boards::getCategoryTitle($user_sports['sport_category']);
$i++;
}
}
}
//$this->view->sportcounter = $i;
if (JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]')));
}
$shared_content = Model_Users::checkSharedContent($request->getParam('key'), $request->getParam('user_id'));
if (!JO_Registry::get('enable_free_registration')) {
if (!$shared_content) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=landing'));
}
} else {
$this->view->fb_register = null;
$fb_ses = JO_Registry::get('facebookapi');
$session = $fb_ses->getUser();
if (JO_Registry::get('oauth_fb_key') && JO_Registry::get('oauth_fb_secret')) {
$this->view->fb_register = $this->facebook->getLoginUrl(array('redirect_uri' => WM_Router::create($request->getBaseUrl() . '?controller=facebook&action=login'), 'req_perms' => 'email,user_birthday,status_update,user_videos,user_status,user_photos,offline_access,read_friendlists'));
}
}
if (JO_Registry::get('oauth_in_key')) {
$this->view->instagram_register = WM_Router::create($this->getRequest()->getBaseUrl() . '?controller=instagram&action=register&next=' . urlencode(WM_Router::create($request->getBaseUrl() . '?controller=instagram&action=register')));
}
$this->view->error = false;
if ($request->isPost()) {
$validate = new Helper_Validate();
$validate->_set_rules($request->getPost('username'), $this->translate('Username'), 'not_empty;min_length[3];max_length[100];username');
$validate->_set_rules($request->getPost('firstname'), $this->translate('First name'), 'not_empty;min_length[3];max_length[100]');
//$validate->_set_rules($request->getPost('lastname'), $this->translate('Last name'), 'not_empty;min_length[3];max_length[100]');
$validate->_set_rules($request->getPost('email'), $this->translate('Email'), 'not_empty;min_length[5];max_length[100];email');
$validate->_set_rules($request->getPost('password'), $this->translate('Password'), 'not_empty;min_length[4];max_length[30]');
$validate->_set_rules($request->getPost('password2'), $this->translate('Confirm password'), 'not_empty;min_length[4];max_length[30]');
if (!isset($_SESSION['token'])) {
if ($request->issetPost('type_user')) {
if ($request->getPost('type_user') != 1 && $request->getPost('type_user') != 5 && $request->getPost('type_user') != 12) {
$validate->_set_rules($request->getPost('location'), $this->translate('Location'), 'not_empty;min_length[3];max_length[100]');
}
}
//is_nan() sino
/* if($request->getPost('sport_category_1') == "" && $request->getPost('sport_category_2') == "" && $request->getPost('sport_category_3') == "") {
$validate->_set_rules($request->getPost('sport_category'), $this->translate('Category_id'), 'not_empty;min_length[3];max_length[100]');
} */
$validate->_set_rules($request->getPost('sports'), $this->translate('Category_id1'), 'not_empty;min_length[3];max_length[100]');
//$validate->_set_rules($request->getPost('sport_category_2'), $this->translate('Category_id2'), 'not_empty;min_length[3];max_length[100]');
//$validate->_set_rules($request->getPost('sport_category_3'), $this->translate('Category_id3'), 'not_empty;min_length[3];max_length[100]');
$validate->_set_rules($request->getPost('type_user'), $this->translate('User_type_id'), 'not_empty;min_length[1];max_length[100]');
}
if ($validate->_valid_form()) {
if (md5($request->getPost('password')) != md5($request->getPost('password2'))) {
$validate->_set_form_errors($this->translate('Password and Confirm Password should be the same'));
$validate->_set_valid_form(false);
}
if (Model_Users::isExistEmail($request->getPost('email'))) {
$validate->_set_form_errors($this->translate('This e-mail address is already used'));
$validate->_set_valid_form(false);
}
if (Model_Users::isExistUsername($request->getPost('username'))) {
$validate->_set_form_errors($this->translate('This username is already used'));
$validate->_set_valid_form(false);
}
}
if ($validate->_valid_form()) {
$reg_key = sha1($request->getPost('email') . $request->getPost('username'));
$lat = $request->getPost('lat');
$len = $request->getPost('len');
/*
while (Model_Users::getUsersLatLen($lat, $len))
{
$posLat = strpos($lat, ".");
$longLat = strlen(substr((string) $lat, $posLat));
$cantLat = 0;
for ($i = 0; $i < ($longLat - 4); $i++)
{
if ($i == 0)
{
$cantLat .= ".0";
} else
{
$cantLat .= "0";
}
}
$cantLat .= "1";
$lat = $lat + $cantLat;
$posLen = strpos($len, ".");
$longLen = strlen(substr((string) $len, $posLen));
$cantLen = 0;
for ($i = 0; $i < ($longLen - 4); $i++)
{
if ($i == 0)
{
$cantLen .= ".0";
} else
{
$cantLen .= "0";
}
}
$cantLen .= "1";
$len = $len + $cantLen;
}
*/
$result = Model_Users::create(array('username' => $request->getPost('username'), 'firstname' => $request->getPost('firstname'), 'lastname' => $request->getPost('lastname'), 'email' => $request->getPost('email'), 'password' => $request->getPost('password'), 'delete_email' => isset($shared_content['email']) ? $shared_content['email'] : '', 'delete_code' => isset($shared_content['if_id']) ? $shared_content['if_id'] : '', 'following_user' => isset($shared_content['user_id']) ? $shared_content['user_id'] : '', 'facebook_id' => isset($shared_content['facebook_id']) ? $shared_content['facebook_id'] : 0, 'location' => $request->getPost('location') != "Introduce una ubicación" ? $request->getPost('location') : "", 'sport_category_1' => $request->getPost('sport_category_1'), 'sport_category_2' => $request->getPost('sport_category_2'), 'sport_category_3' => $request->getPost('sport_category_3'), 'type_user' => $request->getPost('type_user'), 'lat' => $lat, 'len' => $len, 'confirmed' => '0', 'regkey' => $reg_key));
if ($result) {
for ($i = 0; $i <= $request->getPost('locationcounter'); $i++) {
$location = 'location' . $i;
$lat = 'lat' . $i;
$len = 'len' . $i;
if ($request->issetPost($location)) {
if ($request->getPost($location) != "") {
$lat = $request->getPost($lat);
$len = $request->getPost($len);
/*
while (Model_Users::getLocationUsersLatLen($lat, $len))
{
$posLat = strpos($lat, ".");
$longLat = strlen(substr((string) $lat, $posLat));
$cantLat = 0;
for ($x = 0; $x < ($longLat - 4); $x++)
{
if ($x == 0)
{
$cantLat .= ".0";
} else
{
$cantLat .= "0";
}
}
$cantLat .= "1";
$lat = $lat + $cantLat;
$posLen = strpos($len, ".");
$longLen = strlen(substr((string) $len, $posLen));
$cantLen = 0;
for ($y = 0; $y < ($longLen - 4); $y++)
{
if ($y == 0)
{
$cantLen .= ".0";
} else
{
$cantLen .= "0";
}
}
$cantLen .= "1";
$len = $len + $cantLen;
}
*/
if (Model_Users::createUsersLocation($result, $request->getPost($location), $lat, $len)) {
}
}
}
}
if (Model_Users::editUserSports($result)) {
}
if (self::sendMail($result)) {
self::loginInit($result);
}
} else {
$this->view->error = $this->translate('There was a problem with the record. Please try again!');
}
} else {
$this->view->error = $validate->_get_error_messages();
}
}
$this->view->baseUrl = $request->getBaseUrl();
if ($request->issetPost('email')) {
$this->view->email = $request->getPost('email');
} else {
if (isset($shared_content['email'])) {
$this->view->email = $shared_content['email'];
} else {
$this->view->email = '';
}
}
if ($request->issetPost('firstname')) {
$this->view->firstname = $request->getPost('firstname');
} else {
$this->view->firstname = '';
}
if ($request->issetPost('lastname')) {
$this->view->lastname = $request->getPost('lastname');
} else {
$this->view->lastname = '';
}
if ($request->issetPost('username')) {
$this->view->username = $request->getPost('username');
} else {
$this->view->username = '';
}
$this->view->password = $request->getPost('password');
$this->view->password2 = $request->getPost('password2');
$this->view->location = '';
if ($request->issetPost('location')) {
$this->view->location = $request->getPost('location');
} else {
$this->view->location = '';
}
//lat
$this->view->lat = '';
if ($request->issetPost('lat')) {
$this->view->lat = $request->getPost('lat');
} else {
$this->view->lat = '';
}
//len
$this->view->len = '';
if ($request->issetPost('len')) {
$this->view->len = $request->getPost('len');
} else {
$this->view->len = '';
}
$this->view->cat_title1 = '';
$this->view->sport_category_1 = '';
if ($request->issetPost('sport_category_1')) {
$this->view->sport_category_1 = $request->getPost('sport_category_1');
if ($request->getPost('sport_category_1') != "") {
if ($request->getPost('sport_category_1') == 1) {
$this->view->cat_title1 = "Todo";
} else {
$this->view->cat_title1 = Model_Boards::getCategoryTitle($request->getPost('sport_category_1'));
}
}
} else {
$this->view->sport_category_1 = '';
}
$this->view->cat_title2 = '';
$this->view->sport_category_2 = '';
if ($request->issetPost('sport_category_2')) {
$this->view->sport_category_2 = $request->getPost('sport_category_2');
if ($request->getPost('sport_category_2') != "") {
if ($request->getPost('sport_category_2') == 1) {
$this->view->cat_title2 = "Todo";
} else {
$this->view->cat_title2 = Model_Boards::getCategoryTitle($request->getPost('sport_category_2'));
}
}
} else {
$this->view->sport_category_2 = '';
}
$this->view->cat_title3 = '';
$this->view->sport_category_3 = '';
if ($request->issetPost('sport_category_3')) {
$this->view->sport_category_3 = $request->getPost('sport_category_3');
if ($request->getPost('sport_category_3') != "") {
if ($request->getPost('sport_category_3') == 1) {
$this->view->cat_title3 = "Todo";
} else {
$this->view->cat_title3 = Model_Boards::getCategoryTitle($request->getPost('sport_category_3'));
}
}
} else {
$this->view->sport_category_3 = '';
}
$this->view->usertype_title = '';
$this->view->type_user = '';
if ($request->issetPost('type_user')) {
$this->view->type_user = $request->getPost('type_user');
if ($request->getPost('type_user') != "") {
$this->view->usertype_title = Model_Users::getUserTypeTitle($request->getPost('type_user'));
}
} else {
$this->view->type_user = '';
}
//////////// User location ////////////
$this->view->user_location = array();
$this->view->locationcounter = 0;
if ($request->issetPost('location1')) {
$user_location = array();
for ($i = 1; $i <= $request->getPost('locationcounter'); $i++) {
$location = 'location' . $i;
$lat = 'lat' . $i;
$len = 'len' . $i;
if ($request->issetPost($location)) {
if ($request->getPost($location) != "") {
$user_location[] = $request->getPost($location);
}
}
}
$this->view->user_location = $user_location;
$this->view->locationcounter = $request->getPost('locationcounter');
} else {
$this->view->locationcounter = 0;
}
// si llama a los deportes
if (isset($_SESSION["email"])) {
$this->view->email = $_SESSION["email"];
$_SESSION["email"] = null;
}
if (isset($_SESSION["firstname"])) {
$this->view->firstname = $_SESSION["firstname"];
$_SESSION["firstname"] = null;
}
if (isset($_SESSION["username"])) {
$this->view->username = $_SESSION["username"];
$_SESSION["username"] = null;
}
if (isset($_SESSION["password"])) {
$this->view->password = $_SESSION["password"];
$_SESSION["password"] = null;
}
if (isset($_SESSION["password2"])) {
$this->view->password2 = $_SESSION["password2"];
$_SESSION["password2"] = null;
}
if (isset($_SESSION["location"])) {
$this->view->location = $_SESSION["location"];
$_SESSION["location"] = null;
}
if (isset($_SESSION["lat"])) {
$this->view->lat = $_SESSION["lat"];
$_SESSION["lat"] = null;
}
if (isset($_SESSION["len"])) {
$this->view->len = $_SESSION["len"];
$_SESSION["len"] = null;
}
if (isset($_SESSION["type_user"])) {
if ($_SESSION["type_user"] != "") {
$this->view->type_user = $_SESSION["type_user"];
$this->view->usertype_title = Model_Users::getUserTypeTitle($_SESSION["type_user"]);
}
$_SESSION["type_user"] = null;
}
if (isset($_SESSION["location1"])) {
$user_location = array();
for ($i = 1; $i <= $_SESSION['locationcounter']; $i++) {
$location = 'location' . $i;
$lat = 'lat' . $i;
$len = 'len' . $i;
if (isset($_SESSION[$location])) {
if ($_SESSION[$location] != "") {
$user_location[] = $_SESSION[$location];
$_SESSION[$location] = null;
}
}
}
$this->view->user_location = $user_location;
$this->view->locationcounter = $_SESSION['locationcounter'];
$_SESSION['locationcounter'] = null;
}
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part');
}
private function getForm()
{
$request = $this->getRequest();
$pin_id = $request->getRequest('id');
$pin_info = Model_Pins::getPin($pin_id);
if (!$pin_info) {
$this->redirect($this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/pins/');
}
if ($request->issetPost('description')) {
$this->view->description = $request->issetPost('description');
} else {
$this->view->description = $pin_info['description'];
}
if ($request->issetPost('from')) {
$this->view->from = $request->issetPost('from');
} else {
$this->view->from = $pin_info['from'];
}
if ($request->issetPost('board_id')) {
$this->view->board_id = $request->issetPost('board_id');
} else {
$this->view->board_id = $pin_info['board_id'];
}
$this->view->pin_id = $pin_id;
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $pin_id);
$this->view->boards = Model_Boards::getBoards(array('filter_user_id' => $pin_info['user_id'], 'sort' => 'asc', 'order' => 'p.title'));
}
public function sendWeeklyAction()
{
$request = $this->getRequest();
$this->view->base_href = $request->getBaseUrl();
$this->view->site_name = JO_Registry::get('site_name');
$this->view->on_facebook = JO_Registry::get('config_on_facebook');
$this->view->site_logo = $this->view->base_href . 'data/images/logo.png';
if (JO_Registry::get('site_logo') && file_exists(BASE_PATH . '/uploads' . JO_Registry::get('site_logo'))) {
$this->view->site_logo = $this->view->base_href . 'uploads' . JO_Registry::get('site_logo');
}
$this->view->settings = WM_Router::create($this->view->base_href . '?controller=prefs');
$goodies = Model_Pages::getPage(JO_Registry::get('page_goodies'));
if ($goodies) {
//$this->view->pin_it = WM_Router::create($this->view->base_href . '?controller=pages&action=read&page_id=' . JO_Registry::get('page_goodies'));
$this->view->pin_it = 'http://amatteur.com/apps';
}
$this->view->pages = array();
$page = Model_Pages::getPage(JO_Registry::get('page_privacy_policy'));
if ($page) {
$this->view->pages[] = array('title' => $page['title'], 'href' => WM_Router::create($this->view->base_href . '?controller=pages&action=read&page_id=' . JO_Registry::get('page_privacy_policy')));
}
$page = Model_Pages::getPage(JO_Registry::get('page_terms'));
if ($page) {
$this->view->pages[] = array('title' => $page['title'], 'href' => WM_Router::create($this->view->base_href . '?controller=pages&action=read&page_id=' . JO_Registry::get('page_privacy_policy')));
}
$histories = Model_History::getHistoryToday(array('week_range' => WM_Date::x_week_range($this->now)));
$no_avatar = JO_Registry::get('no_avatar');
if ($histories) {
$model_images = new Helper_Images();
/* BOARDS */
$this->view->popular_bards = array();
$populars = Model_Boards::getBoards(array('start' => 0, 'limit' => 6, 'sort' => 'DESC', 'order' => 'boards.total_views', 'where' => new JO_Db_Expr('pins > 4')));
if ($populars) {
foreach ($populars as $board) {
$board['href'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board['user_id'] . '&board_id=' . $board['board_id']);
$board['thumbs'] = array();
$get_big = false;
for ($i = 0; $i < 5; $i++) {
$image = isset($board['pins_array'][$i]) ? $board['pins_array'][$i]['image'] : false;
if ($image) {
if ($get_big) {
$size = '_A';
} else {
$size = '_C';
$get_big = true;
}
$data_img = call_user_func(array(Helper_Pin::formatUploadModule($board['pins_array'][$i]['store']), 'getPinImage'), $board['pins_array'][$i], $size);
if ($data_img) {
$board['thumbs'][] = $data_img['image'];
} else {
$board['thumbs'][] = false;
}
} else {
$board['thumbs'][] = false;
}
}
$board['user'] = Model_Users::getUser($board['user_id']);
$board['user']['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $board['user_id']);
$avatar = Helper_Uploadimages::avatar($board['user'], '_A');
$board['user']['avatar'] = $avatar['image'];
$this->view->popular_bards[] = $board;
}
}
/* VIDEO */
// $this->view->video = array();
// $video = Model_Pins::getPins(array(
// 'start' => 0,
// 'limit' => 1,
// 'filter_is_video' => 1
// ));
//
// if($video) {
// foreach($video AS $pin) {
// $pin['thumb'] = $model_images->resizeWidth($pin['image'], 194);
// $pin['thumb_width'] = $model_images->getSizes('width');
// $pin['thumb_height'] = $model_images->getSizes('height');
// $pin['description'] = Helper_Pin::descriptionFix($pin['description']);
// $pin['href'] = WM_Router::create( $request->getBaseUrl() . '?controller=pin&pin_id=' . $pin['pin_id'] );
//
// }
// }
/* HISTORY */
foreach ($histories as $history) {
if (!isset($history['store'])) {
continue;
}
$avatar = Helper_Uploadimages::avatar($history, '_B');
$history['avatar'] = $avatar['image'];
$history['user_followers'] = WM_Router::create($this->view->base_href . '?controller=users&action=followers&user_id=' . $history['user_id']);
$history['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $history['user_id']);
$history['history_comments_total'] = count($history['history_comments']);
$history['history_follow_total'] = count($history['history_follow']);
$history['history_like_total'] = count($history['history_like']);
$history['history_repin_total'] = count($history['history_repin']);
$history['history_event_total'] = count($history['history_event']);
/////comments
if ($history['history_comments_total']) {
foreach ($history['history_comments'] as $k => $v) {
if (!isset($v['store'])) {
continue;
}
$avatar = Helper_Uploadimages::avatar($v, '_A');
$history['history_comments'][$k]['avatar'] = $avatar['image'];
$history['history_comments'][$k]['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $v['user_id']);
}
}
/////follow
if ($history['history_follow_total']) {
foreach ($history['history_follow'] as $k => $v) {
if (!isset($v['store'])) {
continue;
}
$avatar = Helper_Uploadimages::avatar($v, '_A');
$history['history_follow'][$k]['avatar'] = $avatar['image'];
$history['history_follow'][$k]['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $v['user_id']);
}
}
/////like
if ($history['history_like_total']) {
foreach ($history['history_like'] as $k => $v) {
if (!isset($v['store'])) {
continue;
}
$avatar = Helper_Uploadimages::avatar($v, '_A');
$history['history_like'][$k]['avatar'] = $avatar['image'];
$history['history_like'][$k]['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $v['user_id']);
}
}
/////repin
if ($history['history_repin_total']) {
foreach ($history['history_repin'] as $k => $v) {
if (!isset($v['store'])) {
continue;
}
$avatar = Helper_Uploadimages::avatar($v, '_A');
$history['history_repin'][$k]['avatar'] = $avatar['image'];
$history['history_repin'][$k]['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $v['user_id']);
}
}
////events
if ($history['history_event_total']) {
foreach ($history['history_event'] as $k => $v) {
if (!isset($v['store'])) {
continue;
}
$avatar = Helper_Uploadimages::event($v, '_A');
$history['history_event'][$k]['avatar'] = $avatar['image'];
$history['history_event'][$k]['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $v['user_id']);
}
}
$this->view->events = array();
$this->view->event = array();
$dataEvents = array('filter_cron' => $history['user_id']);
$events = Model_Events::getEvents($dataEvents);
if ($events) {
foreach ($events as $key => $event) {
$href = "";
$view = JO_View::getInstance();
$view->loged = JO_Session::get('user[user_id]');
$model_images = new Helper_Images();
$avatar = Helper_Uploadimages::avatar($event, '_B');
$event['avatar'] = $avatar['image'];
$event['thumbs'] = $avatar['image'];
$event["sport_category"] = Model_Boards::getCategoryTitle($event["sport_category"]);
$data = array('filter_user_id' => $event["user_id"]);
$users = Model_Users::getUsers($data);
if ($users) {
$event['fullname'] = $users[0]["fullname"];
$event['href'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $event['user_id']);
$href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $event['user_id']);
}
//$view->boxeventdetail = WM_Router::create($request->getBaseUrl() . '?controller=events&action=boxeventdetail&event_id=' . $event['event_id']);
$view->boxeventdetail = WM_Router::create($request->getBaseUrl() . '?controller=events&action=indexeventBoxDetail&event_id=' . $event['event_id']);
$this->view->event[] = $event;
$view->event = $event;
$this->view->events[] = $view->render('boxEvent', 'events');
}
}
/* PINS */
$likes = Model_History::getHistory(array('history_action' => Model_History::LIKEPIN, 'start' => 0, 'limit' => 30), 'from_user_id', $history['user_id']);
$history['pins_likes'] = array();
if ($likes) {
$temp = array();
foreach ($likes as $like) {
$temp[$like['pin_id']] = $like['pin_id'];
}
if ($temp) {
$pins = Model_Pins::getPins(array('start' => 0, 'limit' => 9, 'filter_id_in' => implode(',', $temp)));
if ($pins) {
foreach ($pins as $pin) {
$image = call_user_func(array(Helper_Pin::formatUploadModule($pin['store']), 'getPinImage'), $pin, '_B');
if ($image) {
$pin['thumb'] = $image['image'];
$pin['thumb_width'] = $image['width'];
$pin['thumb_height'] = $image['height'];
} else {
continue;
}
$pin['description'] = Helper_Pin::descriptionFix($pin['description']);
$pin['href'] = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $pin['pin_id']);
$pin['onto_href'] = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $pin['user_id'] . '&board_id=' . $pin['board_id']);
$pin['price_formated'] = WM_Currency::format($pin['price']);
$avatar = Helper_Uploadimages::avatar($pin['user'], '_A');
$pin['user']['avatar'] = $avatar['image'];
$pin['user']['profile'] = WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $pin['user_id']);
$pin['via_profile'] = array();
if ($pin['via'] && $pin['user_via']) {
$pin['via_profile'] = array('profile' => WM_Router::create($this->view->base_href . '?controller=users&action=profile&user_id=' . $pin['via']), 'fullname' => $pin['user_via']['fullname']);
}
$history['pins_likes'][] = $pin;
}
}
}
}
$this->view->history = $history;
$html = $this->view->render('sendWeekly', 'crons');
Model_Email::send($history['email'], JO_Registry::get('noreply_mail'), sprintf($this->translate('Weekly %s'), $this->view->site_name), $html);
}
}
}
public function repinAction()
{
$request = $this->getRequest();
$pin_id = $request->getRequest('pin_id');
$pin_info = Model_Pins::getPin($pin_id);
if (!$pin_info) {
$this->forward('error', 'error404');
}
$model_images = new Helper_Images();
$this->view->title = $pin_info['title'];
$this->view->price = $pin_info['price'];
$image = Helper_Uploadimages::pin($pin_info, '_B');
if ($image) {
$this->view->media = $image['original'];
} else {
$this->view->media = false;
}
$this->view->is_video = $pin_info['is_video'] ? 'true' : 'false';
$this->view->is_article = $pin_info['is_article'] ? 'true' : 'false';
$this->view->from = $pin_info['from'];
$this->view->description = $pin_info['description'];
$this->view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&action=repin&pin_id=' . $pin_id);
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=create');
$boards = Model_Boards::getBoards(array('filter_user_id' => JO_Session::get('user[user_id]'), 'order' => 'boards.sort_order', 'sort' => 'ASC', 'friendly' => JO_Session::get('user[user_id]')));
$this->view->boards = array();
if ($boards) {
foreach ($boards as $board) {
$this->view->boards[] = array('board_id' => $board['board_id'], 'title' => $board['title']);
}
}
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
$this->view->popup_main_box = $this->view->render('repin', 'pin');
$this->view->is_article = $pin_info['is_article'] ? 'true' : 'false';
if ($request->isPost()) {
$result = Model_Pins::create(array('title' => $pin_info['title'], 'from' => $pin_info['from'], 'image' => $this->view->media, 'is_video' => $pin_info['is_video'] ? 'true' : 'false', 'is_article' => $pin_info['is_article'] ? 'true' : 'false', 'description' => $request->getPost('message'), 'price' => $request->getPost('price'), 'board_id' => $request->getPost('board_id'), 'via' => $pin_info['user_id'], 'repin_from' => $pin_info['pin_id'], 'from_repin' => $pin_info['from']));
if ($result) {
$this->view->pin_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$this->view->popup_main_box = $this->view->render('success', 'addpin');
//add history
Model_History::addHistory($pin_info['user_id'], Model_History::REPIN, $result);
if ($pin_info['user']['email_interval'] == 1 && $pin_info['user']['repins_email']) {
$this->view->user_info = $pin_info['user'];
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->text_email = $this->translate('repin your');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $pin_id);
Model_Email::send($pin_info['user']['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('repin your pin'), $this->view->render('repin_pin', 'mail'));
}
}
}
$this->setViewChange('index');
if ($request->isXmlHttpRequest()) {
$this->noViewRenderer(true);
echo $this->view->popup_main_box;
$this->view->is_popup = true;
} else {
$this->view->pins_details = $this->view->popup_main_box;
$this->view->is_popup = false;
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part', 'left_part' => 'pin/left_part');
}
}
public function deleteAction()
{
$request = $this->getRequest();
$board_id = $request->getRequest('board_id');
$board_info = Model_Boards::getBoard($board_id);
if (!$board_info) {
$this->forward('error', 'error404');
}
if ($board_info['user_id'] != JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=boards&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']));
} else {
$del = new Model_Boards_Delete($board_id);
if ($del->affected_rows) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $board_info['user_id']));
} else {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=boards&action=edit&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']));
}
}
}
public function indexAction()
{
ini_set('memory_limit', '4200M');
$this->noViewRenderer(true);
ignore_user_abort(true);
for ($i = 1; $i < 5; $i++) {
$html = @file_get_contents('http://pinterest.com/?page=' . $i);
if ($html) {
$dom = new JO_Html_Dom();
$dom->load($html);
$hrefs = $dom->find('.PinImage');
if ($hrefs) {
foreach ($hrefs as $href) {
$price = 0;
$url = JO_Url_Relativetoabsolute::toAbsolute('http://pinterest.com/?page=' . $i, $href->href);
$html2 = @file_get_contents($url);
if ($html2) {
$dom = new JO_Html_Dom();
$dom->load($html2);
$board = $dom->find('h3.serif a', 0)->innertext;
$image = $dom->find('#pinCloseupImage', 0)->src;
$description = $dom->find('#PinCaption', 0)->innertext;
$description = explode('<', $description);
$description = $description[0];
$from = $dom->find('#PinSource a', 0)->href;
$usernames = $dom->find('#PinnerName a', 0)->innertext;
$avatar = $dom->find('#PinnerImage img', 0)->src;
$username = trim($dom->find('#PinnerName a', 0)->href, '/');
$price_o = $dom->find('.buyable', 0);
if ($price_o) {
$price = $price_o->innertext;
}
$user_id = Model_Users::getUserByName($username, $usernames, $avatar);
if (!$user_id) {
continue;
}
WM_Users::initSession($user_id);
$board_id = Model_Boards::getBoardId(trim($board));
$price_f = 0;
if (preg_match('/([0-9.]{1,})/', $price, $m)) {
$price_f = $m[1];
}
$pin_id = Model_Pins::create(array('board_id' => $board_id, 'description' => htmlspecialchars($description, ENT_QUOTES, 'utf-8'), 'image' => (string) $image, 'price' => (double) $price, 'from' => urldecode($from), 'public' => '1'));
$commm = $dom->find('.PinComments .comment');
if ($commm) {
foreach ($commm as $com) {
$avatar = $com->find('.CommenterImage img', 0)->src;
$usernames = $com->find('.CommenterName', 0)->innertext;
$username = trim($com->find('.CommenterName', 0)->href, '/');
$text = explode('<br />', $com->find('.CommenterMeta', 0)->innertext);
$text = isset($text[1]) ? $text[1] : '';
if ($text) {
$user_id = Model_Users::getUserByName($username, $usernames, $avatar);
if (!$user_id) {
continue;
}
WM_Users::initSession($user_id);
$pin_info = Model_Pins::getPin($pin_id);
Model_Pins::addComment(array('write_comment' => $text, 'pin_id' => $pin_id), $pin_info['latest_comments']);
}
}
sleep(1);
}
sleep(1);
}
}
}
}
}
}
public function indexAction()
{
$request = $this->getRequest();
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
//////////// User Type ////////////
$this->view->user_types = array();
$user_types = Model_Users::getUserType(array('filter_status' => 1));
foreach ($user_types as $user_type) {
$user_type['subuser_types'] = Model_Users::getSubUserType($user_type['user_type_id']);
$this->view->user_types[] = $user_type;
}
/////////// activate //////////
$_SESSION["activate_url"] = WM_Router::create($request->getBaseUrl() . '?controller=settings');
$this->view->popup_activate = WM_Router::create($request->getBaseUrl() . '?controller=users&action=activate');
$_SESSION["deportes_url"] = WM_Router::create($request->getBaseUrl() . '?controller=settings');
$this->view->deportes = WM_Router::create($request->getBaseUrl() . '?controller=users&action=deportes');
$this->view->user_sports = array();
$users_sports = Model_Users::getUserSports(JO_Session::get('user[user_id]'));
$i = 0;
foreach ($users_sports as $user_sports) {
if ($user_sports['sport_category'] != 1) {
if (!Model_Boards::isCategoryParent($user_sports['sport_category'])) {
$this->view->user_sports[] = Model_Boards::getCategoryTitle($user_sports['sport_category']);
$i++;
}
}
}
$this->view->sportcounter = $i;
$user_data = Model_Users::getUser(JO_Session::get('user[user_id]'));
$upload = new JO_Upload_SessionStore();
$upload->setName('upload_avatar');
$info = $upload->getFileInfo();
if (JO_Session::get('successfu_edite')) {
$this->view->successfu_edite = true;
JO_Session::clear('successfu_edite');
}
if ($request->isPost()) {
$validate = new Helper_Validate();
$validate->_set_rules($request->getPost('username'), $this->translate('Username'), 'not_empty;min_length[3];max_length[100];username');
$validate->_set_rules($request->getPost('firstname'), $this->translate('First name'), 'not_empty;min_length[3];max_length[100]');
//$validate->_set_rules($request->getPost('lastname'), $this->translate('Last name'), 'not_empty;min_length[3];max_length[100]');
$validate->_set_rules($request->getPost('email'), $this->translate('Email'), 'not_empty;min_length[5];max_length[100];email');
if ($request->issetPost('type_user')) {
if ($request->getPost('type_user') != 1 && $request->getPost('type_user') != 5 && $request->getPost('type_user') != 12) {
$validate->_set_rules($request->getPost('location'), $this->translate('Location'), 'not_empty;min_length[3];max_length[100]');
}
}
$validate->_set_rules($request->getPost('sports'), $this->translate('Category_id1'), 'not_empty;min_length[3];max_length[100]');
//is_nan() sino
/*
if($request->getPost('sport_category_1') == "" && $request->getPost('sport_category_2') == "" && $request->getPost('sport_category_3') == "") {
$validate->_set_rules($request->getPost('sport_category'), $this->translate('Category_id'), 'not_empty;min_length[3];max_length[100]');
}
* */
//$validate->_set_rules($request->getPost('sport_category_1'), $this->translate('Category_id1'), 'not_empty;min_length[3];max_length[100]');
//$validate->_set_rules($request->getPost('sport_category_2'), $this->translate('Category_id2'), 'not_empty;min_length[3];max_length[100]');
//$validate->_set_rules($request->getPost('sport_category_3'), $this->translate('Category_id3'), 'not_empty;min_length[3];max_length[100]');
$validate->_set_rules($request->getPost('type_user'), $this->translate('User_type_id'), 'not_empty;min_length[1];max_length[100]');
$data = $request->getPost();
if ($validate->_valid_form()) {
if (Model_Users::isExistEmail($request->getPost('email'), JO_Session::get('user[email]'))) {
$validate->_set_form_errors($this->translate('This e-mail address is already used'));
$validate->_set_valid_form(false);
}
if (Model_Users::isExistUsername($request->getPost('username'), JO_Session::get('user[username]'))) {
$validate->_set_form_errors($this->translate('This username is already used'));
$validate->_set_valid_form(false);
}
}
if ($validate->_valid_form()) {
$data['dont_search_index'] = (int) $request->issetPost('dont_search_index');
$data['facebook_timeline'] = (int) $request->issetPost('facebook_timeline');
if ($info) {
if (!@file_exists(BASE_PATH . '/cache/avatar/') || !is_dir(BASE_PATH . '/cache/avatar/')) {
mkdir(BASE_PATH . '/cache/avatar/');
}
$filename = BASE_PATH . '/cache/avatar/' . md5(mt_rand() . time()) . $upload->get_extension($info['name']);
if (file_put_contents($filename, $info['data'])) {
$data['avatar'] = $filename;
}
}
$new_email_key = md5(JO_Session::get('user[email]') . mt_rand() . time());
if (JO_Session::get('user[email]') != $request->getPost('email')) {
$data['new_email_key'] = $new_email_key;
} else {
$data['new_email_key'] = '';
}
$data['new_email'] = $data['email'];
unset($data['email']);
/*
$lat = $data['lat'];
$len = $data['len'];
while(Model_Users::getUsersLatLen($lat,$len))
{
$posLat = strpos($lat, ".");
$longLat = strlen(substr((string)$lat, $posLat));
$cantLat = 0;
for ($i = 0; $i < ($longLat - 4); $i++)
{
if ($i == 0)
{
$cantLat .= ".0";
}
else
{
$cantLat .= "0";
}
}
$cantLat .= "1";
$lat = $lat + $cantLat;
$posLen = strpos($len, ".");
$longLen = strlen(substr((string)$len, $posLen));
$cantLen = 0;
for ($i = 0; $i < ($longLen - 4); $i++)
{
if ($i == 0)
{
$cantLen .= ".0";
}
else
{
$cantLen .= "0";
}
}
$cantLen .= "1";
$len = $len + $cantLen;
}
$data['lat'] = $lat;
$data['len'] = $len;
*/
if (Model_Users::edit(JO_Session::get('user[user_id]'), $data)) {
JO_Session::set('successfu_edite', true);
$upload->getFileInfo(true);
if (JO_Session::get('user[email]') != $request->getPost('email')) {
$this->view->verify_email_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=login&user_id=' . JO_Session::get('user[user_id]') . '&verify=' . $new_email_key);
$this->view->user_info = $user_data;
Model_Email::send($request->getPost('email'), JO_Registry::get('noreply_mail'), $this->translate('Please verify your email'), $this->view->render('verify_email', 'mail'));
}
if (!Model_Users::getUserTypeNotOthers($user_data['type_user'])) {
$data['activate'] = 0;
//borrar activate
if (Model_Users::createActivate(JO_Session::get('user[user_id]'), $data)) {
}
}
if (Model_Users::deleteUsersLocation(JO_Session::get('user[user_id]'))) {
for ($i = 0; $i <= $request->getPost('locationcounter'); $i++) {
$location = 'location' . $i;
$lat = 'lat' . $i;
$len = 'len' . $i;
if ($request->issetPost($location)) {
if ($request->getPost($location) != "") {
$lat = $request->getPost($lat);
$len = $request->getPost($len);
while (Model_Users::getLocationUsersLatLen($lat, $len)) {
$posLat = strpos($lat, ".");
$longLat = strlen(substr((string) $lat, $posLat));
$cantLat = 0;
for ($i = 0; $i < $longLat - 4; $i++) {
if ($i == 0) {
$cantLat .= ".0";
} else {
$cantLat .= "0";
}
}
$cantLat .= "1";
$lat = $lat + $cantLat;
$posLen = strpos($len, ".");
$longLen = strlen(substr((string) $len, $posLen));
$cantLen = 0;
for ($i = 0; $i < $longLen - 4; $i++) {
if ($i == 0) {
$cantLen .= ".0";
} else {
$cantLen .= "0";
}
}
$cantLen .= "1";
$len = $len + $cantLen;
}
if (Model_Users::createUsersLocation(JO_Session::get('user[user_id]'), $request->getPost($location), $lat, $len)) {
}
}
}
}
}
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=settings'));
} else {
$this->view->error = $this->translate('There was a problem with the record. Please try again!');
}
} else {
$this->view->error = $validate->_get_error_messages();
}
foreach ($data as $k => $v) {
if (isset($user_data[$k])) {
$user_data[$k] = $v;
}
}
}
if ($info) {
$user_data['avatar'] = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=temporary_avatar&s=' . microtime(true));
$user_data['has_avatar'] = true;
} else {
$avatar = Helper_Uploadimages::avatar($user_data, '_B');
$user_data['avatar'] = $avatar['image'] . '?s=' . microtime(true);
$user_data['has_avatar'] = @getimagesize($user_data['avatar']) ? true : false;
}
//////////// User location ////////////
$this->view->user_location = array();
$this->view->user_lat = array();
$this->view->user_len = array();
$this->view->locationcounter = 0;
if ($request->issetPost('location1')) {
$user_location = array();
$user_lat = array();
$user_len = array();
for ($i = 1; $i <= $request->getPost('locationcounter'); $i++) {
$location = 'location' . $i;
$lat = 'lat' . $i;
$len = 'len' . $i;
if ($request->issetPost($location)) {
if ($request->getPost($location) != "") {
$user_location[] = $request->getPost($location);
$user_lat[] = $request->getPost($lat);
$user_len[] = $request->getPost($len);
}
}
}
$this->view->user_location = $user_location;
$this->view->user_lat = $user_lat;
$this->view->user_len = $user_len;
$this->view->locationcounter = $request->getPost('locationcounter');
} else {
$users_location = Model_Users::getUserLocation(JO_Session::get('user[user_id]'));
$i = 0;
foreach ($users_location as $user_location) {
$this->view->user_location[] = $user_location['location'];
$this->view->user_lat[] = $user_location['lat'];
$this->view->user_len[] = $user_location['len'];
$i++;
}
$this->view->locationcounter = $i;
}
$this->view->location = '';
if ($request->issetPost('location')) {
$this->view->location = $request->getPost('location');
} else {
$this->view->location = '';
}
$this->view->cat_title1 = '';
$this->view->sport_category_1 = '';
if ($request->issetPost('sport_category_1')) {
$this->view->sport_category_1 = $request->getPost('sport_category_1');
if ($request->getPost('sport_category_1') != "") {
if ($request->getPost('sport_category_1') == 1) {
$this->view->cat_title1 = "Todo";
} else {
$this->view->cat_title1 = Model_Boards::getCategoryTitle($request->getPost('sport_category_1'));
}
}
} else {
if ($user_data['sport_category_1'] != "") {
$this->view->sport_category_1 = $user_data['sport_category_1'];
if ($user_data['sport_category_1'] == 1) {
$this->view->cat_title1 = "Todo";
} else {
$this->view->cat_title1 = Model_Boards::getCategoryTitle($user_data['sport_category_1']);
}
}
}
$this->view->cat_title2 = '';
$this->view->sport_category_2 = '';
if ($request->issetPost('sport_category_2')) {
$this->view->sport_category_2 = $request->getPost('sport_category_2');
if ($request->getPost('sport_category_2') != "") {
if ($request->getPost('sport_category_2') == 1) {
$this->view->cat_title2 = "Todo";
} else {
$this->view->cat_title2 = Model_Boards::getCategoryTitle($request->getPost('sport_category_2'));
}
}
} elseif ($user_data['sport_category_2'] != "") {
$this->view->sport_category_2 = $user_data['sport_category_2'];
if ($user_data['sport_category_2'] == 1) {
$this->view->cat_title2 = "Todo";
} else {
$this->view->cat_title2 = Model_Boards::getCategoryTitle($user_data['sport_category_2']);
}
}
$this->view->cat_title3 = '';
$this->view->sport_category_3 = '';
if ($request->issetPost('sport_category_3')) {
$this->view->sport_category_3 = $request->getPost('sport_category_3');
if ($request->getPost('sport_category_3') != "") {
if ($request->getPost('sport_category_3') == 1) {
$this->view->cat_title3 = "Todo";
} else {
$this->view->cat_title3 = Model_Boards::getCategoryTitle($request->getPost('sport_category_3'));
}
}
} elseif ($user_data['sport_category_3'] != "") {
$this->view->sport_category_3 = $user_data['sport_category_3'];
if ($user_data['sport_category_3'] == 1) {
$this->view->cat_title3 = "Todo";
} else {
$this->view->cat_title3 = Model_Boards::getCategoryTitle($user_data['sport_category_3']);
}
}
$this->view->usertype_title = '';
$this->view->type_user = '';
if ($request->issetPost('type_user')) {
$this->view->type_user = $request->getPost('type_user');
if ($request->getPost('type_user') != "") {
$this->view->usertype_title = Model_Users::getUserTypeTitle($request->getPost('type_user'));
}
} elseif ($user_data['type_user'] != "") {
$this->view->type_user = $user_data['type_user'];
$this->view->usertype_title = Model_Users::getUserTypeTitle($user_data['type_user']);
}
if ($request->issetPost('activate')) {
$this->view->activate = $request->getPost('activate');
} else {
$activate = Model_Users::getActivateUser(JO_Session::get('user[user_id]'));
if ($activate) {
$this->view->activate = $activate["activate"];
} else {
$this->view->activate = "";
}
}
$this->view->instagram_enable = JO_Registry::get('oauth_in_key');
$this->view->twitteroauth_enable = JO_Registry::get('oauth_tw_key');
$this->view->facebook_enable = JO_Registry::get('oauth_fb_key');
$this->view->user_data = $user_data;
$this->view->form_action = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=upload_avatar');
$this->view->invites_fb = WM_Router::create($request->getBaseUrl() . '?controller=invites&action=facebook');
$this->view->facebook_connect = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=facebook_connect');
$this->view->twitter_connect = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=twitter_connect');
$this->view->instagram_connect = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=instagram_connect');
$this->view->instagram_fetch = WM_Router::create($request->getBaseUrl() . '?controller=instagram&action=media');
$this->view->instagram_fetch_cron = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=instagram_cron');
$this->view->facebook_connect_avatar = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=facebook_connect_avatar');
$this->view->check_username = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=check_username');
$this->view->delete_username = WM_Router::create($request->getBaseUrl() . '?controller=users&action=delete&user_id=' . $user_data['user_id']);
$this->view->facebook_connect2 = WM_Router::create($request->getBaseUrl() . '?controller=settings&action=facebook_connect2');
$this->view->prefs_action = WM_Router::create($request->getBaseUrl() . '?controller=prefs');
$this->view->new_password = WM_Router::create($request->getBaseUrl() . '?controller=password&action=change');
$this->view->site_name = JO_Registry::get('site_name');
$this->view->base_href = $request->getBaseUrl();
$this->view->delete_account = '';
if (JO_Registry::get('delete_account')) {
$page_description = Model_Pages::getPage(JO_Registry::get('delete_account'));
if ($page_description) {
$this->view->delete_account = html_entity_decode($page_description['description'], ENT_QUOTES, 'utf-8');
}
}
// si llama a los deportes
if (isset($_SESSION["email"])) {
$this->view->email = $_SESSION["email"];
$_SESSION["email"] = null;
}
if (isset($_SESSION["firstname"])) {
$this->view->firstname = $_SESSION["firstname"];
$_SESSION["firstname"] = null;
}
if (isset($_SESSION["username"])) {
$this->view->username = $_SESSION["username"];
$_SESSION["username"] = null;
}
if (isset($_SESSION["password"])) {
$this->view->password = $_SESSION["password"];
$_SESSION["password"] = null;
}
if (isset($_SESSION["password2"])) {
$this->view->password2 = $_SESSION["password2"];
$_SESSION["password2"] = null;
}
if (isset($_SESSION["info"])) {
$this->view->info = $_SESSION["info"];
$_SESSION["info"] = null;
}
if (isset($_SESSION["location"])) {
$this->view->location = $_SESSION["location"];
$_SESSION["location"] = null;
}
if (isset($_SESSION["lat"])) {
$this->view->lat = $_SESSION["lat"];
$_SESSION["lat"] = null;
}
if (isset($_SESSION["len"])) {
$this->view->len = $_SESSION["len"];
$_SESSION["len"] = null;
}
if (isset($_SESSION["type_user"])) {
if ($_SESSION["type_user"] != "") {
$this->view->type_user = $_SESSION["type_user"];
$this->view->usertype_title = Model_Users::getUserTypeTitle($_SESSION["type_user"]);
}
$_SESSION["type_user"] = null;
}
if (isset($_SESSION["location1"])) {
$user_location = array();
for ($i = 1; $i <= $_SESSION['locationcounter']; $i++) {
$location = 'location' . $i;
if (isset($_SESSION[$location])) {
if ($_SESSION[$location] != "") {
$user_location[] = $_SESSION[$location];
$_SESSION[$location] = null;
}
}
}
$this->view->user_location = $user_location;
$this->view->locationcounter = $_SESSION['locationcounter'];
$_SESSION['locationcounter'] = null;
}
$this->view->children = array('header_part' => 'layout/header_part', 'footer_part' => 'layout/footer_part');
}
public function accinvAction()
{
$this->noViewRenderer(true);
$request = $this->getRequest();
if (!JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl()));
}
if ($request->getRequest('board_id') and $request->getRequest('ub_id') and $request->getRequest('type')) {
$ubinfo = Model_Boards::getUsersBoard(array('board_id' => $request->getRequest('board_id'), 'ub_id' => $request->getRequest('ub_id')));
if ($ubinfo) {
if ($request->getRequest('type') == 'accept') {
Model_Boards::acceptUsersBoard($request->getRequest('ub_id'));
} elseif ($request->getRequest('type') == 'decline') {
Model_Boards::deleteUsersBoard($request->getRequest('ub_id'));
}
}
}
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]')));
}
public function pinMediaCallbackAction()
{
$request = $this->getRequest();
if (JO_Session::get('user[user_id]')) {
$media = Model_Instagram::getMedia($request->getPost('media_id'));
if ($media) {
if ($media['user_id'] == JO_Session::get('user[user_id]')) {
$result = Model_Pins::create(array('title' => $media['title'], 'from' => $media['from'], 'image' => $media['media'], 'description' => $media['title'], 'board_id' => JO_Session::get('instagram_media[board_id]')));
if ($result) {
Model_Instagram::setPinMedia($media['media_id'], $result);
Model_History::addHistory(JO_Session::get('user[user_id]'), Model_History::ADDPIN, $result);
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if ($group) {
$users = explode(',', $group);
foreach ($users as $user_id) {
if ($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if ($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if ($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send($user_data['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'), $this->view->render('group_board', 'mail'));
}
}
}
}
$this->view->ok = true;
} else {
$this->view->error = $this->translate('There was a problem with the record. Please try again!');
}
} else {
$this->view->error = $this->translate('Private media!');
}
} else {
$this->view->error = $this->translate('Media not found!');
}
} else {
$this->view->location = WM_Router::create($request->getBaseUrl() . '?controller=users&action=login');
}
echo $this->renderScript('json');
}
public function uploadAction()
{
$this->noViewRenderer(true);
$request = $this->getRequest();
$response = $this->getResponse();
$page = (int) $request->getRequest('page');
if ($page < 1) {
$page = 1;
}
$callback = $request->getRequest('callback');
if (!preg_match('/^([a-z0-9_.]{1,})$/', $callback)) {
$callback = false;
}
if (isset($_POST['token']) && $_POST['token'] == md5($_POST['userId'])) {
$_SESSION['token'] = $_POST['token'];
JO_Session::set('token', $_POST['token']);
// $token = $request->getRequest('token');
// $user_id = $request->getRequest('userId');
// $folderName = $request->getRequest('folderName');
// $categoryId = $request->getRequest('categoryId');
//
// $token = $request->getRequest('token');
//$user_id = $request->getRequest('userId');
// error_log("token " .$token);
// error_log("user " . md5($user_id));
// error_log("session " . $_SESSION['token']) ;
// if (isset($token) && $token == md5($user_id))
// {
// $_SESSION['token'] = $token;
$return = array();
//print_r("files " . var_dump($_FILES)) ;
//print_r("request " .var_dump($_REQUEST));
//error_log("1file name " . $_FILES["file"]["tmp_name"] . " uploads " . $_REQUEST["image"]);
//error_log("2file name " . $_FILES["uploadedfile"]["name"] . " uploads " . $_REQUEST["image"]);
//$this->view->form_action = WM_Router::create( $request->getBaseUrl() . '?controller=addpin&action=upload_images' );
//$this->view->upload_action = WM_Router::create( $request->getBaseUrl() . '?controller=addpin&action=upload_imagesView' );
//$this->view->popup_main_box = $this->view->render('fromfile','addpin');
if (JO_Session::get('upload_from_file')) {
@unlink(BASE_PATH . JO_Session::get('upload_from_file'));
JO_Session::clear('upload_from_file');
JO_Session::clear('upload_from_file_name');
}
$image = $request->getFile('file');
if (!$image) {
$return = array('error' => 10, 'description' => $this->translate('There is no file selected'));
} else {
$temporary = '/cache/review/';
$upload_folder = BASE_PATH . $temporary;
$upload = new Helper_Upload();
$upload->setFile($image)->setExtension(array('.jpg', '.jpeg', '.png', '.gif'))->setUploadDir($upload_folder);
$new_name = md5(time() . serialize($image));
if ($upload->upload($new_name)) {
$info = $upload->getFileInfo();
if ($info) {
$this->view->from_url = WM_Router::create($request->getBaseUrl() . '?controller=addpin&action=fromfile');
// $this->view->file = $image['name'];
// $this->view->full_path = $temporary . $info['name'];
$this->view->success = 1;
//$this->view->render('upload_images', 'addpin');
JO_Session::set('upload_from_file', $temporary . $info['name']);
JO_Session::set('upload_from_file_name', $image['name']);
} else {
$return = array('error' => 11, 'description' => $this->translate('An unknown error'));
}
} else {
$return = array('error' => 12, 'description' => $upload->getError());
}
}
if ($request->isPost()) {
$result = Model_Pins::create(array('title' => $request->getPost('title'), 'from' => '', 'image' => BASE_PATH . JO_Session::get('upload_from_file'), 'is_video' => $request->getPost('is_video'), 'is_article' => $request->getPost('is_article'), 'description' => $request->getPost('message'), 'price' => $request->getPost('price'), 'board_id' => $request->getPost('board_id'), 'user_id' => $request->getPost('userId')));
if ($result) {
Model_History::addHistory(0, Model_History::ADDPIN, $result);
if (JO_Registry::get('isMobile')) {
//$this->redirect('/');
}
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if ($group) {
$users = explode(',', $group);
foreach ($users as $user_id) {
if ($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if ($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if ($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send($user_data['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'), $this->view->render('group_board', 'mail'));
}
}
}
}
$this->view->pin_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$this->view->popup_main_box = $this->view->render('success', 'addpin');
if (JO_Session::get('upload_from_file')) {
@unlink(BASE_PATH . JO_Session::get('upload_from_file'));
JO_Session::clear('upload_from_file');
JO_Session::clear('upload_from_file_name');
}
}
}
/*
//$_FILES-> name type tmp_name error size
//'image' => BASE_PATH . JO_Session::get('upload_from_file'),
if( $request->isPost() ) {
$this->view->form_action = WM_Router::create( $request->getBaseUrl() . '?controller=addpin&action=upload_images' );
$this->view->upload_action = WM_Router::create( $request->getBaseUrl() . '?controller=addpin&action=upload_imagesView' );
$this->view->popup_main_box = $this->view->render('fromfile','addpin');
$url_m = $request->getPost('image');
if(strpos($url_m, '.jpg?')) {
$url_m = explode('?', $url_m);
$url_m = $url_m[0];
}
error_log("3file name " . $_FILES["file"]["tmp_name"] . " url_m " . $url_m);
$url_m = $_FILES;
$result = Model_Pins::create(array(
'title' => $request->getPost('title'),
'from' => $request->getPost('from'),
'image' => $url_m,
'is_video' => 0, //$request->getPost('is_video'),
'is_article' => 0, //$request->getPost('is_article'),
'description' => $request->getPost('message'),
'price' => $request->getPost('price'),
'board_id' => $request->getPost('board_id')
));
if($result) {
Model_History::addHistory(JO_Session::get('user[user_id]'), Model_History::ADDPIN, $result);
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if($group) {
$users = explode(',',$group);
foreach($users AS $user_id) {
if($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create( $request->getBaseUrl() . '?controller=pin&pin_id=' . $result );
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send(
$user_data['email'],
JO_Registry::get('noreply_mail'),
JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'),
$this->view->render('group_board', 'mail')
);
}
}
}
}
$this->view->pin_url = WM_Router::create( $request->getBaseUrl() . '?controller=pin&pin_id=' . $result );
$this->view->popup_main_box = $this->view->render('success','addpin');
}
}
*/
} else {
//no existe la sesión / no existe el dato recibido por post / el token no es igual.
$return = array('error' => 401, 'description' => $this->translate('wrong token'));
}
if ($callback) {
$return = $callback . '(' . JO_Json::encode($return) . ')';
} else {
$response->addHeader('Cache-Control: no-cache, must-revalidate');
$response->addHeader('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
$response->addHeader('Content-type: application/json');
$return = JO_Json::encode($return);
}
$response->appendBody($return);
}
public static function isFollow($data = array())
{
if (!(string) JO_Session::get('user[user_id]')) {
return false;
}
$db = JO_Db::getDefaultAdapter();
$query = $db->select()->from('users_following', 'COUNT(users_following_id)')->where('user_id = ?', (string) JO_Session::get('user[user_id]'))->limit(1);
if (isset($data['user_id'])) {
$query->where('following_id = ?', (string) $data['user_id']);
}
if (isset($data['board_id'])) {
$query->where('board_id = ?', (string) $data['board_id']);
}
// if(isset($data['ub_id'])) {
// $query->where('ub_id = ?', (string)$data['ub_id']);
// }
$result = $db->fetchOne($query);
if (!$result) {
if (isset($data['board_id'])) {
$board_info = Model_Boards::getBoard($data['board_id']);
} elseif (isset($data['user_id'])) {
$board_info = array('user_id' => $data['user_id']);
}
if (isset($board_info['user_id'])) {
$result = Model_Users::isFollowUser($board_info['user_id']);
if ($result) {
$is_ignore = self::isIgnoreFollow($data);
if ($is_ignore) {
$result = false;
}
}
}
} else {
$is_ignore = self::isIgnoreFollow($data);
if ($is_ignore) {
$result = false;
}
}
return $result;
}
public static function getBoardPins($board_id, $limit = 12, $thumb = 75)
{
static $result = array(), $model_images = null, $request = null;
if (isset($result[$board_id])) {
return $result[$board_id];
}
if ($model_images === null) {
$model_images = new Helper_Images();
}
if ($request === null) {
$request = JO_Request::getInstance();
}
$pins = Model_Pins::getPins(array('filter_board_id' => $board_id, 'start' => 0, 'limit' => $limit));
$data = array();
if ($pins) {
foreach ($pins as $pin) {
$image = Helper_Uploadimages::pin($pin, '_A');
if ($image) {
$data[] = array('board' => Model_Boards::getBoardWithoutUser($board_id), 'thumb' => $image['image'], 'href' => WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $pin['user_id'] . '&board_id=' . $pin['board_id']));
}
}
}
$result[$board_id] = $data;
return $data;
}
public function allowInvateAction()
{
$this->noViewRenderer(true);
$request = $this->getRequest();
if (!JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl()));
}
if ($request->getRequest('board_id') && $request->getRequest('type')) {
$board_info = new Model_Boards_Board($request->getRequest('board_id'));
if ($board_info->count()) {
$users = explode(',', $board_info['board_users_not_allow']);
if (in_array(JO_Session::get('user[user_id]'), $users)) {
if ($request->getRequest('type') == 'accept') {
Model_Boards::acceptUsersBoard($request->getRequest('board_id'));
} elseif ($request->getRequest('type') == 'decline') {
Model_Boards::deleteUsersBoard($request->getRequest('board_id'));
}
}
}
}
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]')));
}
public static function getPins($data = array(), &$pin_ids = array())
{
$db = JO_Db::getDefaultAdapter();
$cache_live = (int) JO_Registry::get('config_cache_live');
if ($cache_live && isset($data['filter_rand']) && $data['filter_rand'] == true && isset($data['start']) && isset($data['limit'])) {
$check = $db->select()->from('cache_index')->where('start_limit = ?', $data['start'] . '.' . $data['limit'])->where('`date` >= ?', time())->limit(1);
$cache = $db->fetchRow($check);
if ($cache) {
$results = JO_Json::decode($cache['data'], true);
if ($results && is_array($results)) {
$return = array();
foreach ($results as $result) {
if (self::pinIsExist($result['pin_id'])) {
$return[] = $result;
}
}
return $return;
}
}
} elseif ($cache_live && isset($data['filter_like_repin_comment']) && $data['filter_like_repin_comment'] == true && isset($data['start']) && isset($data['limit'])) {
$check = $db->select()->from('cache_popular')->where('start_limit = ?', $data['start'] . '.' . $data['limit'])->where('`date` >= ?', time())->limit(1);
$cache = $db->fetchRow($check);
if ($cache) {
$results = JO_Json::decode($cache['data'], true);
if ($results && is_array($results)) {
$return = array();
foreach ($results as $result) {
if (self::pinIsExist($result['pin_id'])) {
$return[] = $result;
}
}
return $return;
}
}
}
if (isset($data['filter_likes']) && $data['filter_likes']) {
$query = $db->select()->from('pins', array('pins.*', 'gift' => new JO_Db_Expr('pins.price > 0.0000')))->where('pins.pin_id IN (SELECT pins_likes.pin_id FROM pins_likes WHERE user_id = ?)', $data['filter_likes']);
} else {
$query = $db->select()->from('pins', array('pins.*', 'gift' => new JO_Db_Expr('pins.price > 0.0000')));
}
$query = self::FilterBuilder($query, $data);
if (isset($data['start']) && isset($data['limit'])) {
if ($data['start'] < 0) {
$data['start'] = 0;
}
$query->limit($data['limit'], $data['start']);
}
if (isset($data['sort']) && strtolower($data['sort']) == 'asc') {
$sort = ' ASC';
} else {
$sort = ' DESC';
}
$allow_sort = array('pins.pin_id', 'pins.views');
if (isset($data['order']) && in_array($data['order'], $allow_sort)) {
$query->order($data['order'] . $sort);
} elseif (isset($data['order']) && $data['order'] instanceof JO_Db_Expr) {
$query->order($data['order']);
} else {
$query->order('pins.pin_id' . $sort);
}
$start = microtime(true);
//echo $query.'<hr />';
$results = $db->fetchAll($query);
$results_array = array();
if ($results) {
foreach ($results as $result) {
$userinfo = Model_Users::getUser($result['user_id'], false, Model_Users::$allowed_fields);
if ($userinfo) {
$result['user_via'] = $result['via'] ? Model_Users::getUser($result['via'], false, Model_Users::$allowed_fields) : false;
$result['user'] = $userinfo;
$result['board'] = Model_Boards::getBoardTitle($result['board_id']);
$result['latest_comments'] = $result['comments'] ? Model_Comments::getLatestComments($result['latest_comments']) : array();
$result['liked'] = $result['likes'] ? self::pinIsLiked($result['pin_id']) : 0;
$results_array[] = $result;
// array_push($pin_ids, $result['pin_id']);
}
}
}
// var_dump( microtime(true)-JO_Registry::get('start_microtime') ); exit;
return $results_array;
}
public function indexAction()
{
$request = $this->getRequest();
if (!JO_Session::get('user[user_id]')) {
$this->redirect(WM_Router::create($request->getBaseUrl() . '?controller=users&action=login&popup=true&next=' . urlencode($request->getFullUrl())));
}
$this->view->createBoard = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=create');
$boards = Model_Boards::getBoards(array('filter_user_id' => JO_Session::get('user[user_id]'), 'order' => 'boards.sort_order', 'sort' => 'ASC', 'friendly' => JO_Session::get('user[user_id]')));
$this->view->boards = array();
if ($boards) {
foreach ($boards as $board) {
$this->view->boards[] = array('board_id' => $board['board_id'], 'title' => $board['title']);
}
}
//////////// Categories ////////////
$this->view->categories = array();
$categories = Model_Categories::getCategories(array('filter_status' => 1));
foreach ($categories as $category) {
$category['subcategories'] = Model_Categories::getSubcategories($category['category_id']);
$this->view->categories[] = $category;
}
$this->view->title = JO_Utf8::convertToUtf8($request->getQuery('title'));
$this->view->url = JO_Utf8::convertToUtf8(urldecode($request->getQuery('url')));
$this->view->media = JO_Utf8::convertToUtf8($request->getQuery('media'));
$this->view->is_video = JO_Utf8::convertToUtf8($request->getQuery('is_video'));
$this->view->description = JO_Utf8::convertToUtf8($request->getQuery('description'));
$this->view->charset = JO_Utf8::convertToUtf8($request->getQuery('charset'));
if (!trim($this->view->description)) {
$this->view->description = $this->view->title;
}
if (JO_Session::get('success_added')) {
$this->view->pin_url = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . JO_Session::get('success_added'));
$this->setViewChange('success');
JO_Session::clear('success_added');
} else {
if ($request->isPost()) {
$result = Model_Pins::create(array('title' => $this->view->title, 'from' => $this->view->url, 'image' => $this->view->media, 'is_video' => $this->view->is_video, 'description' => $request->getPost('message'), 'price' => $request->getPost('price'), 'board_id' => $request->getPost('board_id'), 'pinmarklet' => 1));
if ($result) {
Model_History::addHistory(0, Model_History::ADDPIN, $result);
$session_user = JO_Session::get('user[user_id]');
$group = Model_Boards::isGroupBoard($request->getPost('board_id'));
if ($group) {
$users = explode(',', $group);
foreach ($users as $user_id) {
if ($user_id != $session_user) {
$user_data = Model_Users::getUser($user_id);
if ($user_data && $user_data['email_interval'] == 1 && $user_data['groups_pin_email']) {
$this->view->user_info = $user_data;
$this->view->profile_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . JO_Session::get('user[user_id]'));
$this->view->full_name = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
$this->view->pin_href = WM_Router::create($request->getBaseUrl() . '?controller=pin&pin_id=' . $result);
$board_info = Model_Boards::getBoard($request->getPost('board_id'));
if ($board_info) {
$this->view->board_title = $board_info['title'];
$this->view->board_href = WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board_info['user_id'] . '&board_id=' . $board_info['board_id']);
}
Model_Email::send($user_data['email'], JO_Registry::get('noreply_mail'), JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]') . ' ' . $this->translate('added new pin to a group board'), $this->view->render('group_board', 'mail'));
}
}
}
}
JO_Session::set('success_added', $result);
$this->redirect($request->getBaseUrl() . '?controller=bookmarklet');
}
}
}
}
public static function returnHtmlDetail($event, $banners = false)
{
//XPER: función que carga PIN
static $view = null, $model_images = null, $request = null;
if ($view === null) {
$view = JO_View::getInstance();
}
if ($model_images === null) {
$model_images = new Helper_Images();
}
if ($request === null) {
$request = JO_Request::getInstance();
}
/*
$next_pin = Model_Pins::getNextPin($event['event_id']);
if($next_pin) {
$view->next_navigation_pin = WM_Router::create( $request->getBaseUrl() . '?controller=pin&event_id=' . $next_pin['event_id'] );
}
$prev_pin = Model_Pins::getPrevPin($event['event_id']);
if($prev_pin) {
$view->prev_navigation_pin = WM_Router::create( $request->getBaseUrl() . '?controller=pin&event_id=' . $prev_pin['event_id'] );
}
*/
$image = call_user_func(array(self::formatUploadModule($event['store']), 'getEventImage'), $event, '_B');
if ($image) {
$event['thumb'] = $image['image'];
$event['thumb_width'] = $image['width'];
$event['thumb_height'] = $image['height'];
$event['original_image'] = $image['original'];
} else {
JO_Action::getInstance()->forward('error', 'error404');
}
$image = call_user_func(array(self::formatUploadModule($event['store']), 'getEventImage'), $event, '_D');
if ($image) {
$event['popup'] = $image['image'];
$event['popup_width'] = $image['width'];
$event['popup_height'] = $image['height'];
$event['original_image'] = $image['original'];
} else {
//JO_Action::getInstance()->forward('error', 'error404');
$image = call_user_func(array(self::formatUploadModule($event['store']), 'getEventImage'), $event, '_B');
if ($image) {
$event['popup'] = $image['image'];
$event['popup_width'] = $image['width'];
$event['popup_height'] = $image['height'];
$event['original_image'] = $image['original'];
}
}
$event_description = self::descriptionFix($event['description']);
$event['real_description'] = self::descriptionFix($event['description']);
$event['description'] = self::descriptionFix($event['description']);
$event['href'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=indexeventBoxDetail&event_id=' . $event['event_id']);
//$event['date_event'] = Model_Events::cambiafyh_espanol($event['date_event']);
$event["sport_category"] = Model_Boards::getCategoryTitle($event["sport_category"]);
$page = (int) $request->getRequest('page');
if ($page < 1) {
$page = 1;
}
$data = array('start' => JO_Registry::get('config_front_limit') * $page - JO_Registry::get('config_front_limit'), 'limit' => JO_Registry::get('config_front_limit'), 'filter_user_id' => $event["user_id"]);
$users = Model_Users::getUsers($data);
if ($users) {
$event['fullname'] = $users[0]["fullname"];
$event['descriptionUser'] = $users[0]["description"];
$avataruser = Helper_Uploadimages::avatar($users[0], '_B');
$event['avataruser'] = $avataruser['image'];
$event['userHref'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $event['user_id']);
$href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $event['user_id']);
}
$event['pinmarklet_href'] = WM_Router::create($request->getBaseUrl() . '?controller=pages&action=read&page_id=' . JO_Registry::get('page_pinmarklet'));
//$event['onto_href'] = WM_Router::create( $request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $event['user_id'] . '&board_id=' . $event['board_id'] );
//$event['price_formated'] = WM_Currency::format($event['price']);
// esto es del autor del evento
/*
$view->author = $event['user_id'];
$avatar = Helper_Uploadimages::avatar($event['user_id'], '_A');
$view->author['avatar'] = $avatar['image'];
$view->author['profile'] = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $event['user_id'] );
*
*
*/
//comentarios
$view->comments = array();
if ($event['latest_comments']) {
foreach ($event['latest_comments'] as $key => $comment) {
if (!isset($comment['user']['store'])) {
unset($event['latest_comments'][$key]);
continue;
}
$avatar = Helper_Uploadimages::avatar($comment['user'], '_A');
$comment['user']['avatar'] = $avatar['image'];
$comment['user']['profile'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $comment['user_id']);
$comment['delete'] = '';
if (!Model_Events::commentIsReported($comment['comment_id'])) {
$comment['report'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=reportComment&comment_id=' . $comment['comment_id']);
} else {
$comment['report'] = '';
}
if (JO_Session::get('user[user_id]')) {
if (JO_Session::get('user[is_admin]') || JO_Session::get('user[user_id]') == $comment['user_id']) {
$comment['delete'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=deleteComment&comment_id=' . $comment['comment_id']);
}
}
$view->comments[] = $comment;
}
}
$view->get_user_friends = WM_Router::create($request->getBaseUrl() . '?controller=users&action=friends');
$view->totalFollow = WM_Router::create($request->getBaseUrl() . '?controller=events&action=totalFollow');
// no se pa que vale
/*
$view->via = array();
$view->via_repin = array();
if($event['via'] && $event['user_via']) {
$view->via = array(
'profile' => WM_Router::create( $request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $event['via'] ),
'fullname' => $event['user_via']['fullname']
);
}
$view->replin_info = false;
if($request->isXmlHttpRequest()) {
$view->target_repin = false;
if($event['repin_from']) {
$event_repin = Model_Pins::getPin($event['repin_from']);
if($event_repin) {
$view->source = array();
$view->source['source'] = $event_repin['board'];
$event['from'] = WM_Router::create( $request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $event_repin['user_id'] . '&board_id=' . $event_repin['board_id'] );
$view->target_repin = true;
} else {
$view->source = Model_Source::getSource($event['source_id']);
}
} else {
$view->source = Model_Source::getSource($event['source_id']);
}
} else {
$view->source = Model_Source::getSource($event['source_id']);
if($event['repin_from']) {
$repina = Model_Pins::getPin($event['repin_from']);
if($repina) {
$view->replin_info = array(
'pin_href' => WM_Router::create( $request->getBaseUrl() . '?controller=pin&event_id=' . $event['repin_from'] ),
'profile' => WM_Router::create( $request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $repina['user_id'] ),
'fullname' => $repina['user']['fullname']
);
}
}
}
if($event['from'] && !preg_match('/^https?:\/\//',$event['from'])) {
$event['from'] = 'http://' . $event['from'];
}
if($event['from_repin'] && !preg_match('/^https?:\/\//',$event['from_repin'])) {
$event['from_repin'] = 'http://' . $event['from_repin'];
}
$event['onto_board'] = $event['onto_board2'] = array();
$event['originally_pinned'] = $event['originally_pinned2'] = array();
*/
/*
if($request->isXmlHttpRequest()) {
$event['onto_board'] = self::getBoardPins($event['board_id']);
$event['originally_pinned'] = self::getOriginallyPinned( $event['via']?$event['via']:$event['user_id'] );
} else {
$event['onto_board2'] = self::getBoardPins($event['board_id']);
$event['originally_pinned2'] = self::getOriginallyPinned( $event['via']?$event['via']:$event['user_id'] );
}
if($view->source && $request->isXmlHttpRequest()) {
$event['source_pins'] = self::getSourcePins($event['source_id']);
} else {
$event['source_pins'] = array();
}
$event['boardIsFollow'] = Model_Users::isFollow(array(
'board_id' => $event['board_id']
));
$event['userIsFollow'] = Model_Users::isFollowUser($event['user_id']);
if($event['via']) {
$event['userViaIsFollow'] = Model_Users::isFollowUser($event['via']);
} else {
$event['userViaIsFollow'] = Model_Users::isFollowUser($event['user_id']);
}
$event['userFollowIgnore'] = $event['user_id'] == JO_Session::get('user[user_id]');
$event['userViaFollowIgnore'] = ($event['via']?$event['via']:$event['user_id']) == JO_Session::get('user[user_id]');
$view->follow = WM_Router::create( $request->getBaseUrl() . '?controller=boards&action=follow&user_id=' . $event['user_id'] . '&board_id=' . $event['board_id'] );
$view->follow_user = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=follow&user_id=' . $event['user_id'] );
if($event['via']) {
$view->follow_user_via = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=follow&user_id=' . $event['via'] );
} else {
$view->follow_user_via = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=follow&user_id=' . $event['user_id'] );
}
$view->get_user_friends = WM_Router::create( $request->getBaseUrl() . '?controller=users&action=friends' );
if(JO_Session::get('user[user_id]')) {
$view->enable_follow = $event['user_id'] != JO_Session::get('user[user_id]');
} else {
$view->enable_follow = false;
}
*/
if (JO_Session::get('user[user_id]')) {
$event['url_like'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=like&event_id=' . $event['event_id']);
$event['url_repin'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=repin&event_id=' . $event['event_id']);
$event['url_comment'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=comment&event_id=' . $event['event_id']);
$event['comment'] = WM_Router::create($request->getBaseUrl() . '?controller=events&action=comment&event_id=' . $event['event_id']);
$event['edit'] = JO_Session::get('user[user_id]') == $event['user_id'] ? WM_Router::create($request->getBaseUrl() . '?controller=events&action=events&event_id=' . $event['event_id']) : false;
} else {
$event['url_like'] = $event['url_repin'] = $event['url_comment'] = $event['comment'] = WM_Router::create($request->getBaseUrl() . '?controller=landing');
$event['edit'] = false;
}
/*
$likes = self::getPinLikes($event['event_id']);
$event['likes'] = $likes['data'];
$event['likes_total'] = $likes['total'];
$event['repins'] = self::getRePins($event['event_id']);
$event['pinIsReported'] = Model_Pins::pinIsReported($event['event_id']);
$date_dif = array_shift( WM_Date::dateDiff($event['date_added'], time()) );
$event['date_dif'] = $date_dif;
*/
$view->loged = JO_Session::get('user[user_id]');
$view->owner = JO_Session::get('user[user_id]') == $event["user_id"];
$view->site_name = JO_Registry::get('site_name');
if ($view->loged) {
$avatar = Helper_Uploadimages::avatar(JO_Session::get('user'), '_A');
$view->self_avatar = $avatar['image'];
$view->self_profile = WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $view->loged);
$view->self_fullname = JO_Session::get('user[firstname]') . ' ' . JO_Session::get('user[lastname]');
}
/*
if($event['is_video']) {
$auto = new Helper_AutoEmbed();
if( $event['repin_from'] && $auto->parseUrl($event['from_repin']) ) {
$auto->setWidth('100%');
$auto->setHeight('350');
$event['video_code'] = $auto->getEmbedCode();
$attr = $auto->getObjectAttribs();
$event['thumb_width'] = $attr['width'];
$event['thumb_height'] = $attr['height'];
} else {
if( $auto->parseUrl($event['from']) ) {
$auto->setWidth('100%');
$auto->setHeight('350');
$event['video_code'] = $auto->getEmbedCode();
$attr = $auto->getObjectAttribs();
$event['thumb_width'] = $attr['width'];
$event['thumb_height'] = $attr['height'];
} else {
$event['is_video'] = false;
}
}
} else
{
$auto = new Helper_AutoEmbed();
if( $event['repin_from'] && $auto->parseUrl($event['from_repin']) ) {
$auto->setWidth('100%');
$auto->setHeight('350');
$event['video_code'] = $auto->getEmbedCode();
$attr = $auto->getObjectAttribs();
$event['thumb_width'] = $attr['width'];
$event['thumb_height'] = $attr['height'];
$event['is_video'] = true;
} else if( $auto->parseUrl($event['from']) ) {
$auto->setWidth('100%');
$auto->setHeight('350');
$event['video_code'] = $auto->getEmbedCode();
$attr = $auto->getObjectAttribs();
$event['thumb_width'] = $attr['width'];
$event['thumb_height'] = $attr['height'];
$event['is_video'] = true;
} else {
$event['is_video'] = false;
}
}
*/
$view->event_url = WM_Router::create($request->getBaseUrl() . '?controller=events&action=indexeventBoxDetail&event_id=' . $event['event_id']);
//WM_Router::create( $request->getBaseUrl() . '?controller=events&event_id=' . $event['event_id'] );
$view->login_href = WM_Router::create($request->getBaseUrl() . '?controller=users&action=login&next=' . urlencode($event['href']));
$view->like_event = WM_Router::create($request->getBaseUrl() . '?controller=events&action=like&event_id=' . $event['event_id'] . '&userio_id=' . $event['user_id']);
$view->eventIsLike = Model_Events::isLikeEvent($event['event_id'], JO_Session::get('user[user_id]'));
$view->editEvent_url = WM_Router::create($request->getBaseUrl() . '?controller=events&action=add?event_id=' . $event['event_id']);
$view->follow_event = WM_Router::create($request->getBaseUrl() . '?controller=events&action=follow&event_id=' . $event['event_id'] . '&userio_id=' . $event['user_id']);
$view->eventIsFollow = Model_Events::isFollowEvent($event['event_id'], JO_Session::get('user[user_id]'));
//Model_Pins::updateViewed($event['event_id']);
JO_Layout::getInstance()->meta_title = $event['eventname'] . ' - ' . strip_tags(html_entity_decode($event_description));
JO_Layout::getInstance()->placeholder('pin_url', $view->event_url);
JO_Layout::getInstance()->placeholder('pin_description', $event_description);
$params = array();
$params['content'] = html_entity_decode($event_description . ' ' . $event['eventname'], ENT_QUOTES, 'UTF-8');
//page content
$keywords = new WM_Keywords($params);
$get_keywords = $keywords->get_keywords();
if ($get_keywords) {
JO_Layout::getInstance()->placeholder('keywords', $get_keywords);
}
JO_Layout::getInstance()->placeholder('pin_image', $event['thumb']);
JO_Layout::getInstance()->placeholder('board_title', $event['eventname']);
/*
$view->banners = array();
if($banners) {
foreach($banners AS $banner1) {
foreach($banner1 AS $e) {
$e['html'] = html_entity_decode($e['html']);
$view->banners[] = $e;
}
}
}
*/
$view->event = $event;
return $view->render('eventBoxDetail', 'events');
}
public static function deleteUser($user_id)
{
$db = JO_Db::getDefaultAdapter();
$user_info = self::getUser($user_id);
if (!$user_info) {
return;
}
if ($user_info['store'] == 's3') {
self::deleteImagesAmazon($user_info['avatar']);
} else {
if ($user_info['avatar']) {
$model_image = new Helper_Images();
$model_image->deleteImages($user_info['avatar']);
}
}
$query = $db->select()->from('boards')->where('user_id = ?', (string) $user_id);
$rows = $db->fetchAll($query);
if ($rows) {
foreach ($rows as $row) {
Model_Boards::delete($row['board_id']);
}
}
$db->query("DELETE FROM url_alias WHERE query = 'user_id=" . (string) $user_id . "'");
$db->delete('users_boards', array('user_id = ?' => (string) $user_id));
$db->delete('shared_content', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('user_id = ?' => (string) $user_id));
$db->delete('users_following', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_ignore', array('following_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('user_id = ?' => (string) $user_id));
$db->delete('users_following_user', array('following_id = ?' => (string) $user_id));
$db->delete('users_history', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_history', array('to_user_id = ?' => (string) $user_id));
$db->delete('users_agenda', array('user_id = ?' => (string) $user_id));
$db->delete('users_activate', array('user_id = ?' => (string) $user_id));
$db->delete('users_location', array('user_id = ?' => (string) $user_id));
$db->delete('users_sports', array('user_id = ?' => (string) $user_id));
$db->delete('users_messages', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_messages', array('to_user_id = ?' => (string) $user_id));
$db->delete('users_mails', array('from_user_id = ?' => (string) $user_id));
$db->delete('users_mails_to', array('user_id = ?' => (string) $user_id));
$db->delete('users_likes', array('user_id = ?' => (string) $user_id));
$db->delete('users', array('user_id = ?' => (string) $user_id));
}
private function getForm()
{
$request = $this->getRequest();
$board_id = $request->getRequest('id');
$board_info = Model_Boards::getBoard($board_id);
if ($board_info) {
$this->view->board_id = $board_id;
// $this->view->title = $board_info['title'];
/*$this->view->type = $user_info['type'];*/
/*$this->view->username = $user_info['username'];*/
// $this->view->names = $user_info['firstname'] . ' ' . $user_info['lastname'];
/*$this->view->email = $user_info['email'];*/
// $this->view->status = $user_info['status'];
// $this->view->profile_url = WM_Router::create( $this->getRequest()->getBaseUrl() . '?controller=users&action=profile&user_id=' . $user_id );
}
if ($request->getPost('title')) {
$this->view->title = $request->getPost('title');
} elseif (isset($board_info)) {
$this->view->title = $board_info['title'];
} else {
$this->view->title = '';
}
if ($request->getPost('description')) {
$this->view->description = $request->getPost('description');
} elseif (isset($board_info)) {
$this->view->description = $board_info['description'];
} else {
$this->view->description = '';
}
if ($request->getPost('category_id')) {
$this->view->category_id = $request->getPost('category_id');
} elseif (isset($board_info)) {
$this->view->category_id = $board_info['category_id'];
} else {
$this->view->category_id = '';
}
if ($request->getPost('keyword')) {
$this->view->keyword = $request->getPost('keyword');
} elseif (isset($board_info)) {
$this->view->keyword = $board_info['keyword'];
} else {
$this->view->keyword = '';
}
$this->view->categories = Model_Categories::getCategories();
}
public function autocompleteAction()
{
$request = $this->getRequest();
$this->view->items = array();
if (JO_Session::get('user[user_id]') && $request->getPost('value')) {
$friends = Model_Users::getUserFriends(array('filter_username' => $request->getPost('value')));
if ($friends) {
$model_images = new Helper_Images();
foreach ($friends as $friend) {
if (!isset($friend['store'])) {
continue;
}
$avatar = Helper_Uploadimages::avatar($friend, '_A');
$this->view->items[] = array('image' => $avatar['image'], 'label' => $friend['fullname'], 'value' => $friend['user_id'], 'href' => WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $friend['user_id']), 'username' => $friend['username']);
}
}
$boards = Model_Boards::getBoards(array('filter_user_id' => JO_Session::get('user[user_id]'), 'friendly' => JO_Session::get('user[user_id]'), 'filter_title' => $request->getPost('value'), 'sort' => 'asc', 'order' => 'boards.title'));
if ($boards) {
foreach ($boards as $board) {
$this->view->items[] = array('image' => $request->getBaseUrl() . 'data/images/typeahead_board.png', 'label' => $board['title'], 'value' => $board['board_id'], 'href' => WM_Router::create($request->getBaseUrl() . '?controller=boards&action=view&user_id=' . $board['user_id'] . '&board_id=' . $board['board_id']), 'username' => $board['title']);
}
}
}
$this->view->items[] = array('search_for' => 1, 'label' => sprintf($this->translate('Search for %s'), $request->getPost('value')), 'href' => WM_Router::create($request->getBaseUrl() . '?controller=search&q=' . $request->getPost('value')));
if ($request->isXmlHttpRequest()) {
echo $this->renderScript('json');
} else {
$this->forward('error', 'error404');
}
}
public function sort_orderAction()
{
$request = $this->getRequest();
$page = (int) $request->getRequest('page');
if ($page < 1) {
$page = 1;
}
$plus = (int) (JO_Registry::get('config_front_limit') * $page) - JO_Registry::get('config_front_limit');
if ($request->isXmlHttpRequest()) {
if (JO_Session::get('user[user_id]')) {
$ids = $request->getPost('ids');
if ($ids) {
foreach ($ids as $sort_order => $id) {
Model_Boards::sort_order($id, $sort_order + $plus);
}
$this->view->ok = $this->translate('The arrangement is saved!');
}
}
} else {
$this->forward('error', 'error404');
}
echo $this->renderScript('json');
}
