Файловый менеджер - Редактировать - /var/www/iplanru/data/old/www/i-plan.ru/administrator/components/com_zoo/helpers/category.php
Назад
<?php /** * @package ZOO * @author YOOtheme http://www.yootheme.com * @copyright Copyright (C) YOOtheme GmbH * @license http://www.gnu.org/licenses/gpl.html GNU/GPL */ /** * The category helper class. * * @package Component.Helpers * @since 2.0 */ class CategoryHelper extends AppHelper { /** * Method to retrieve item's related category ids. * * @param int $item_id The items id * @param boolean $published Include published categories only * * @return array category ids * * @since 2.0 */ public function getItemsRelatedCategoryIds($item_id, $published = false) { // select item to category relations $query = 'SELECT b.id' .' FROM '.ZOO_TABLE_CATEGORY_ITEM.' AS a' .' JOIN '.ZOO_TABLE_CATEGORY.' AS b ON a.category_id = b.id' .' WHERE a.item_id='.(int) $item_id .($published == true ? ' AND b.published = 1' : '') .' UNION SELECT 0' .' FROM '.ZOO_TABLE_CATEGORY_ITEM.' AS a' .' WHERE a.item_id='.(int) $item_id.' AND a.category_id = 0'; return $this->app->database->queryResultArray($query); } /** * Method to add category related items. * * @param int $item_id The items id * @param array $categories category ids * * @return boolean true on success * * @since 2.0 */ public function saveCategoryItemRelations($item_id, $categories) { //init vars $db = $this->app->database; if (!is_array($categories)) { $categories = array($categories); } $categories = array_unique($categories); // delete category to item relations $query = "DELETE FROM ".ZOO_TABLE_CATEGORY_ITEM ." WHERE item_id=".(int) $item_id; // execute database query $db->query($query); $query_string = '(%s,'.(int) $item_id.')'; $category_strings = array(); foreach ($categories as $category) { if (is_numeric($category)) { $category_strings[] = sprintf($query_string, $category); } } // add category to item relations // insert relation to database if (!empty($category_strings)) { $query = "INSERT INTO ".ZOO_TABLE_CATEGORY_ITEM ." (category_id, item_id) VALUES ".implode(',', $category_strings); // execute database query $db->query($query); } return true; } /** * Method to delete category related items. * * @param int $category_id The category id * * @return int number of affected rows * * @since 2.0 */ public function deleteCategoryItemRelations($category_id) { // delete category to item relations $query = "DELETE FROM ".ZOO_TABLE_CATEGORY_ITEM ." WHERE category_id = ".(int) $category_id; // execute database query return $this->app->database->query($query); } }
| ver. 1.4 |
Github
|
.
| PHP 5.4.45-1~dotdeb+6.1 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка