Example #1
0
 function getAllPosts()
 {
     $sql = "SELECT t1.id as post_id,t1.title as post_title,t1.small_text,t1.full_text,t1.creation_date,t1.comments,t1.views,t2.name as catalog_name,t3.title as blog_name,t3.user_id,t4.name as tag_name FROM blog_post t1\r\n\t\t\t\t\tINNER JOIN ub_tree t2 ON t1.ub_tree_id = t2.id\r\n\t\t\t\t\tINNER JOIN blog t3 ON t2.blog_id = t3.id\r\n\t\t\t\t\tLEFT JOIN bc_tag t4 ON t1.bc_tag_id = t4.id\r\n\t\t\t\t\tORDER BY t1.creation_date\r\n\t\t\t \t\tDESC LIMIT ?d, ?d";
     $result = Project::getDatabase()->selectPage($this->_countRecords, $sql, $this->_pager->getStartLimit(), $this->_pager->getPageSize());
     $this->updatePagerAmount();
     return $result;
 }
Example #2
0
 function getUserWarningCount($user_id)
 {
     $DE = Project::getDatabase();
     $sql = "\r\n                SELECT count(*) as c\r\n                FROM warning\r\n                WHERE user_id = '" . $user_id . "'\r\n            ";
     $result = $DE->selectRow($sql);
     return $result['c'];
 }
 /**
  * Читает строку таблицы "social_pos_criteria_votes"
  * $p_spos_id        - ID Соц. позиции
  * $p_scriteria_id - ID Критерия
  */
 public function GetIDBy($p_spos_id = 0, $p_scriteria_id = 0)
 {
     $v_spos_id = (int) $p_spos_id;
     $v_scriteria_id = (int) $p_scriteria_id;
     $sql = "\r\n      SELECT *\r\n        FROM `social_pos_criteria_votes` s\r\n       WHERE s.`social_pos_id` = ?d and s.`social_criteria_id` = ?d";
     $result = Project::getDatabase()->select($sql, $v_spos_id, $v_scriteria_id);
     return $result[0]['id'];
 }
Example #4
0
 function setRelation($user1_id, $user2_id, $text)
 {
     if (Project::getDatabase()->select("SELECT * FROM `users_relations` WHERE `user1_id`=?d AND `user2_id`=?d", $user1_id, $user2_id)) {
         Project::getDatabase()->query("UPDATE `users_relations` SET `text`=?s WHERE `user1_id`=?d AND `user2_id`=?d", htmlspecialchars($text), $user1_id, $user2_id);
     } else {
         Project::getDatabase()->query("INSERT INTO `users_relations` SET `text`=?s, `user1_id`=?d, `user2_id`=?d", htmlspecialchars($text), $user1_id, $user2_id);
     }
 }
 public function loadWhere($articleTreeId, $dataBegin = null, $dataEnd = null)
 {
     $sql = "SELECT * FROM {$this->_table} a WHERE a.`id_article_tree` = ?d ";
     $dataBegin !== null ? $sql .= "AND ((a.`data_begin` <= '{$dataBegin}' AND a.`data_end` > '{$dataBegin}') " : "";
     $dataEnd !== null ? $sql .= "OR (a.`data_end` >= '{$dataEnd}' AND a.`data_begin` < '{$dataEnd}'))" : ")";
     //die($sql);
     return Project::getDatabase()->select($sql, $articleTreeId);
 }
Example #6
0
 function loadByLabel($label)
 {
     $DE = Project::getDatabase();
     $result = array();
     $result = $DE->selectRow("SELECT * FROM " . $this->_table . " WHERE label = ?", $label);
     $this->bind($result);
     return $result;
 }
Example #7
0
 function loadDefault($admin = true)
 {
     $DE = Project::getDatabase();
     $result = array();
     $result = $DE->selectRow("SELECT * FROM " . $this->_table . " WHERE `default`=1 AND admin=?d LIMIT 1", $admin);
     $this->bind($result);
     return $result;
 }
Example #8
0
 public function loadByParentId($id)
 {
     $id = (int) $id;
     $DE = Project::getDatabase();
     $parent = $DE->selectRow("SELECT * FROM {$this->_table} WHERE id = ?d", $id);
     $result = $DE->select("SELECT * FROM {$this->_table} WHERE {$this->_table}.key like '" . $parent['key'] . "%' AND {$this->_table}.level = ?d AND {$this->_table}.active = 1 order by 'key'", $parent['level'] + 1);
     return $result;
 }
Example #9
0
 function getDefaultService()
 {
     // TODO:: caching
     $DE = Project::getDatabase();
     $result = array();
     $result = $DE->selectRow("SELECT * FROM " . $this->_table . " WHERE client_id = ?d AND `default` = 1", $this->_client_id);
     $this->bind($result);
     return $result;
 }
Example #10
0
 /**  Вставка записи в таблицу `bookmarks_tags_links`
  * $p_bookmark_id - ID закладки
  * $p_tag_id      - ID тега
  */
 public function insertTagLink($p_bookmark_id, $p_tag_id)
 {
     $v_bookmark_id = (int) $p_bookmark_id;
     $v_tag_id = (int) $p_tag_id;
     if ($v_bookmark_id > 0 and $v_tag_id > 0) {
         $sql = "INSERT INTO `bookmarks_tags_links` VALUES (null, ?d, ?d)";
         Project::getDatabase()->query($sql, $v_bookmark_id, $v_tag_id);
     }
 }
Example #11
0
 /**
  * Функция возвращает количество строк в таблице в зависимости от условия WHERE
  * Необходима для определения наличия комментариев к соц.позиции для конкретного пользователя
  */
 public function GetCountRecComment($p_user = 0, $p_social_pos_id = 0)
 {
     if ((int) $p_user == 0 or $p_social_pos_id == 0) {
         return 0;
     }
     $sql = "\n      SELECT count(*) as cnt \n      FROM `social_comments` s \n      WHERE s.`user_id`=?d and s.`social_pos_id`=?d\n    ";
     $result = Project::getDatabase()->select($sql, (int) $p_user, (int) $p_social_pos_id);
     return $result[0]['cnt'];
 }
Example #12
0
 public function loadQuestion($id)
 {
     $id = (int) $id;
     $sql = "SELECT " . "questions.`id`," . "questions.`questions_cat_id`," . "questions.`a_count`," . "questions.`q_text`," . "questions.`user_id`," . "questions.`creation_date`," . "users.`login` " . "FROM questions " . "LEFT JOIN users " . "ON questions.`user_id` = users.id " . "WHERE questions.`id` = ?d";
     //die($sql);
     $result = Project::getDatabase()->selectRow($sql, $id);
     $this->bind($result);
     return $result;
 }
Example #13
0
 function exists($name)
 {
     $sql = "SELECT * " . " FROM  bc_tag " . " WHERE " . " param_group_id = ?d" . " AND LOWER(name) = LOWER(?)";
     $rez = Project::getDatabase()->selectRow($sql, $name);
     if (count($rez) === 0) {
         return false;
     } else {
         return $rez;
     }
 }
Example #14
0
 function exists($group_id, $param_name)
 {
     $DE = Project::getDatabase();
     $sql = "SELECT * " . " FROM  param " . " WHERE " . " param_group_id = ?d" . " AND LOWER(param.name) = LOWER(?)";
     $rez = $DE->selectRow($sql, $group_id, $param_name);
     if (count($rez) === 0) {
         return false;
     } else {
         return $rez;
     }
 }
Example #15
0
 function getCorrespondenceBetweenUsers($aUsersID)
 {
     $DE = Project::getDatabase();
     $result = array();
     if ($aUsersID) {
         $sUsersId = implode(",", $aUsersID);
         $sql = "\r\n            SELECT messages.*, messages.id as messages_id,\r\n               u_author.login as author_login\r\n            FROM messages\r\n            INNER JOIN users as u_author\r\n                ON u_author.id = messages.author_id\r\n            WHERE messages.author_id IN (" . $sUsersId . ") AND messages.recipient_id IN (" . $sUsersId . ") AND (messages.is_deleted = '0' OR messages.is_deleted = '1')";
         $sql .= " ORDER BY messages.send_date ";
         $result = $DE->select($sql);
     }
     return $result;
 }
 function changeSubscribe($user_id, $tree_id)
 {
     if ($user_id > 0 && $tree_id > 0) {
         $result = Project::getDatabase()->selectRow("SELECT * FROM " . $this->_table . " WHERE user_id=?d AND ub_tree_id=?d ", (int) $user_id, (int) $tree_id);
         $this->bind($result);
         if ((int) $this->id > 0) {
             Project::getDatabase()->query("DELETE FROM " . $this->_table . " WHERE id=?d", (int) $this->id);
         } else {
             $this->user_id = $user_id;
             $this->ub_tree_id = $tree_id;
             $this->save();
         }
     }
 }
Example #17
0
 public static function canVote($user_id, $photo_id)
 {
     $user_id = (int) $user_id;
     $photo_id = (int) $photo_id;
     if ($user_id > 0 && $photo_id > 0) {
         $sql = "SELECT id FROM photo_vote WHERE user_id=?d AND photo_id=?d";
         $rs = Project::getDatabase()->selectCell($sql, $user_id, $photo_id);
         if ((int) $rs > 0) {
             return false;
         } else {
             return true;
         }
     }
     return false;
 }
Example #18
0
 function loadByTypeControllerAction($user_type_id, $controller_id, $action_id)
 {
     if ($this->_load_all_cahce === true) {
         $cache = Project::getDatabaseManager()->getCache();
         if ($cache !== null) {
             $list = $cache->get($this->getCachePrefix('_list_controller_action_user_type_' . $user_type_id . $controller_id . $action_id));
             if (is_array($list)) {
                 return $list;
             }
         }
     }
     $DE = Project::getDatabase();
     $result = $DE->selectRow("SELECT * FROM " . $this->_table . " WHERE user_type_id = ?d AND controller_id=?d AND action_id = ?d", (int) $user_type_id, (int) $controller_id, (int) $action_id);
     $this->bind($result);
     if ($this->_load_all_cahce === true) {
         $cache = Project::getDatabaseManager()->getCache();
         if ($cache !== null) {
             $cache->set($this->getCachePrefix('_list_controller_action_user_type_' . $user_type_id . $controller_id . $action_id), $result);
         }
     }
     return $result;
 }
Example #19
0
 function loadAll($userid, $logged_user_id, $sortName = 'a.creation_date', $sortOrder = 'DESC', $defaultSortName = "id", $filter_ids = array())
 {
     $userid = (int) $userid;
     if (is_null($sortName)) {
         $sortName = $defaultSortName;
     }
     $DE = Project::getDatabase();
     $this->checkPager();
     $sortOrder = $this->getSortDirection($sortOrder);
     if ($userid > 0) {
         $om = 1;
     } else {
         $om = "a.is_onmain = 1";
     }
     if ($userid > 0) {
         $u = "a.user_id = " . $userid;
     } else {
         $u = 1;
     }
     $sql = "SELECT " . "a.id as id," . "a.name as name," . "a.creation_date as creation_date," . "u.login as login," . "p.thumbnail as thumbnail," . "IF (rate.voices > 0, rate.rating/rate.voices, 0) as album_rating," . "a.user_id as user_id," . "a.access as access," . "a.is_onmain as is_onmain " . " FROM album as a " . " LEFT JOIN users u ON u.id=a.user_id " . " LEFT JOIN photo p ON p.id=a.thumbnail_id AND p.album_id=a.id " . " LEFT JOIN photo rate ON rate.album_id = a.id AND rate.is_rating > 0 " . " WHERE " . " " . $om . " " . " AND " . $u . " " . " AND ( (a.access=" . ACCESS::ALL . ") OR (?d AND a.access=" . ACCESS::FRIEND . ") OR (a.user_id=?d AND a.access=" . ACCESS::MYSELF . ") )" . " GROUP BY id " . " ORDER BY {$sortName} {$sortOrder}  LIMIT ?d, ?d ";
     $result = $DE->selectPage($this->_countRecords, $sql, (int) Project::getUser()->isFriend(), $logged_user_id, $this->_pager->getStartLimit(), $this->_pager->getPageSize());
     $this->updatePagerAmount();
     return $result;
 }
Example #20
0
 function getList($user_id)
 {
     $sql = "SELECT * FROM moods WHERE user_id=?d";
     return Project::getDatabase()->select($sql, (int) $user_id);
 }
Example #21
0
 public function __construct()
 {
     parent::__construct('groups');
     $this->db = Project::getDatabase();
     $this->_caches(true, true, true);
 }
Example #22
0
 /** 
   Для дерева категорий определена сортировка в алфавитном порядке:
    как в родительских категориях(level_item=0), так и в дочерних (level_item=1)
 */
 public function loadCategoryList()
 {
     $sql = "\r\n      SELECT\r\n        bt.*,\r\n        IF (bt.`parent_id`=0, 0, 1) level_item,\r\n        IF (bt.`parent_id`=0, bt.`name`, CONCAT(bt1.`name`, '_', bt.`name`)) field_order\r\n      FROM `bookmarks_tree` bt LEFT JOIN `bookmarks_tree` bt1 ON bt.`parent_id` = bt1.`id`\r\n      WHERE bt.`active` = 1\r\n      ORDER BY field_order\r\n    ";
     $result = Project::getDatabase()->select($sql);
     return $result;
 }
Example #23
0
 function save()
 {
     $DE = Project::getDatabase();
     $DE->query('UPDATE ' . $this->_table . ' SET ?a WHERE id = ?d', $this->_data, $this->id);
     return $this->id;
 }
Example #24
0
 public function loadByArticleId($id)
 {
     $id = (int) $id;
     $sql = "SELECT * FROM article_pages WHERE article_id = ?d";
     return Project::getDatabase()->select($sql, $id);
 }
Example #25
0
 function getStateNameById($id)
 {
     return Project::getDatabase()->selectCell("SELECT name FROM " . $this->_table . " WHERE id=?d ORDER BY name", (int) $id);
 }
Example #26
0
 function getInterests($user_id)
 {
     $sql = "SELECT I.`name` FROM " . $this->_table . " as IC LEFT JOIN `interests` as I ON IC.`interest_id`=I.`id` WHERE IC.`user_id`=?";
     return Project::getDatabase()->selectCol($sql, (int) $user_id);
 }
Example #27
0
 public function getProductPlaces()
 {
     $sql = "SELECT id AS ARRAY_KEY_1,full_name FROM social_products_places ORDER BY id";
     $result = Project::getDatabase()->select($sql);
     return $result;
 }
Example #28
0
 function exists($interest_id)
 {
     return (int) Project::getDatabase()->selectCell("SELECT id FROM interests WHERE id=?d", $interest_id);
 }
Example #29
0
 public function truncateTable($table_name)
 {
     $DE = Project::getDatabase();
     $sql = "\r\n                TRUNCATE TABLE `{$table_name}`\r\n            ";
     $result = $DE->query($sql);
     return $result;
 }
Example #30
0
 /** 
   Для дерева категорий определена сортировка в алфавитном порядке:
    как в родительских категориях(level_item=0), так и в дочерних (level_item=1)
 */
 public function loadCategoryList()
 {
     $sql = "\r\n      SELECT\r\n        st.*,\r\n        IF (st.`parent_id`=0, 0, 1) level_item,\r\n        IF (st.`parent_id`=0, st.`name`, CONCAT(st1.`name`, '_', st.`name`)) field_order\r\n      FROM `social_tree` st LEFT JOIN `social_tree` st1 ON st.`parent_id` = st1.`id`\r\n      ORDER BY field_order\r\n    ";
     $result = Project::getDatabase()->select($sql);
     return $result;
 }