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; }
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']; }
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); }
function loadByLabel($label) { $DE = Project::getDatabase(); $result = array(); $result = $DE->selectRow("SELECT * FROM " . $this->_table . " WHERE label = ?", $label); $this->bind($result); return $result; }
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; }
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; }
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; }
/** Вставка записи в таблицу `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); } }
/** * Функция возвращает количество строк в таблице в зависимости от условия 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']; }
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; }
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; } }
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; } }
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(); } } }
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; }
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; }
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; }
function getList($user_id) { $sql = "SELECT * FROM moods WHERE user_id=?d"; return Project::getDatabase()->select($sql, (int) $user_id); }
public function __construct() { parent::__construct('groups'); $this->db = Project::getDatabase(); $this->_caches(true, true, true); }
/** Для дерева категорий определена сортировка в алфавитном порядке: как в родительских категориях(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; }
function save() { $DE = Project::getDatabase(); $DE->query('UPDATE ' . $this->_table . ' SET ?a WHERE id = ?d', $this->_data, $this->id); return $this->id; }
public function loadByArticleId($id) { $id = (int) $id; $sql = "SELECT * FROM article_pages WHERE article_id = ?d"; return Project::getDatabase()->select($sql, $id); }
function getStateNameById($id) { return Project::getDatabase()->selectCell("SELECT name FROM " . $this->_table . " WHERE id=?d ORDER BY name", (int) $id); }
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); }
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; }
function exists($interest_id) { return (int) Project::getDatabase()->selectCell("SELECT id FROM interests WHERE id=?d", $interest_id); }
public function truncateTable($table_name) { $DE = Project::getDatabase(); $sql = "\r\n TRUNCATE TABLE `{$table_name}`\r\n "; $result = $DE->query($sql); return $result; }
/** Для дерева категорий определена сортировка в алфавитном порядке: как в родительских категориях(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; }