public function get_search_request($args) { $search = $args['search']; $weight = isset($args['weight']) && is_numeric($args['weight']) ? $args['weight'] : 1; require_once PATH_TO_ROOT . '/pages/pages_defines.php'; $categories = PagesCategoriesCache::load()->get_categories(); $unauth_cats = ''; if (!AppContext::get_current_user()->check_auth(PagesConfig::load()->get_authorizations(), READ_PAGE)) { $unauth_cats .= '0,'; } foreach ($categories as $id => $cat) { if (!AppContext::get_current_user()->check_auth($cat['auth'], READ_PAGE)) { $unauth_cats .= $id . ','; } } $unauth_cats = !empty($unauth_cats) ? " AND p.id_cat NOT IN (" . trim($unauth_cats, ',') . ")" : ''; $results = array(); $result = PersistenceContext::get_querier()->select("SELECT " . $args['id_search'] . " AS `id_search`,\r\n\t\tp.id AS `id_content`,\r\n\t\tp.title AS `title`,\r\n\t\t( 2 * FT_SEARCH_RELEVANCE(p.title, '" . $args['search'] . "') + FT_SEARCH_RELEVANCE(p.contents, '" . $args['search'] . "') ) / 3 * " . $weight . " AS `relevance`,\r\n\t\tCONCAT('" . PATH_TO_ROOT . "/pages/pages.php?title=',p.encoded_title) AS `link`,\r\n\t\tp.auth AS `auth`\r\n\t\tFROM " . PREFIX . "pages p\r\n\t\tWHERE ( FT_SEARCH(title, '" . $args['search'] . "') OR FT_SEARCH(contents, '" . $args['search'] . "') )" . $unauth_cats . "\r\n\t\tLIMIT 100 OFFSET 0"); while ($row = $result->fetch()) { if (!empty($row['auth'])) { $auth = unserialize($row['auth']); if (!AppContext::get_current_user()->check_auth($auth, READ_PAGE)) { unset($row['auth']); array_push($results, $row); } } else { unset($row['auth']); array_push($results, $row); } } $result->dispose(); return $results; }
function get_feeds_list() { global $LANG; require_once PATH_TO_ROOT . '/pages/pages_functions.php'; $cats_tree = new FeedsCat('pages', 0, $LANG['root']); $categories = PagesCategoriesCache::load()->get_categories(); build_pages_cat_children($cats_tree, array_values($categories)); $feeds = new FeedsList(); $feeds->add_feed($cats_tree, Feed::DEFAULT_FEED_NAME); return $feeds; }
private function get_view() { global $Bread_crumb, $LANG, $pages; $pages_config = PagesConfig::load(); //Configuration des authorisations $config_authorizations = $pages_config->get_authorizations(); require_once PATH_TO_ROOT . '/pages/pages_begin.php'; $tpl = new FileTemplate('pages/index.tpl'); $num_pages = PersistenceContext::get_querier()->count(PREFIX . "pages", 'WHERE redirect = 0'); $num_coms = CommentsService::get_number_and_lang_comments('pages', $pages['id']); $tpl->put_all(array('NUM_PAGES' => sprintf($LANG['pages_num_pages'], $num_pages), 'NUM_COMS' => sprintf($LANG['pages_num_coms'], $num_coms, $num_pages > 0 ? $num_coms / $num_pages : 0), 'L_EXPLAIN_PAGES' => $LANG['pages_explain'], 'L_STATS' => $LANG['pages_stats'])); //Liste des dossiers de la racine $root = ''; foreach (PagesCategoriesCache::load()->get_categories() as $key => $cat) { if ($cat['id_parent'] == 0) { //Autorisation particulière ? $special_auth = !empty($cat['auth']); //Vérification de l'autorisation d'éditer la page if ($special_auth && AppContext::get_current_user()->check_auth($cat['auth'], READ_PAGE) || !$special_auth && AppContext::get_current_user()->check_auth($config_authorizations, READ_PAGE)) { $root .= '<li><a href="javascript:open_cat(' . $key . '); show_pages_cat_contents(' . $cat['id_parent'] . ', 0);"><i class="fa fa-folder"></i>' . stripslashes($cat['title']) . '</a></li>'; } } } //Liste des fichiers de la racine $result = PersistenceContext::get_querier()->select("SELECT title, id, encoded_title, auth\r\n\t\t\tFROM " . PREFIX . "pages\r\n\t\t\tWHERE id_cat = 0 AND is_cat = 0\r\n\t\t\tORDER BY is_cat DESC, title ASC"); while ($row = $result->fetch()) { //Autorisation particulière ? $special_auth = !empty($row['auth']); $array_auth = unserialize($row['auth']); //Vérification de l'autorisation d'éditer la page if ($special_auth && AppContext::get_current_user()->check_auth($array_auth, READ_PAGE) || !$special_auth && AppContext::get_current_user()->check_auth($config_authorizations, READ_PAGE)) { $root .= '<li><a href="' . PagesUrlBuilder::get_link_item($row['encoded_title']) . '"><i class="fa fa-file"></i>' . stripslashes($row['title']) . '</a></li>'; } } $result->dispose(); $tpl->put_all(array('TITLE' => $LANG['pages'], 'L_ROOT' => $LANG['pages_root'], 'ROOT_CONTENTS' => $root, 'L_CATS' => $LANG['pages_cats_tree'], 'L_EXPLORER' => $LANG['pages_explorer'], 'SELECTED_CAT' => 0, 'CAT_0' => 'selected', 'CAT_LIST' => '')); $contents = ''; $result = PersistenceContext::get_querier()->select("SELECT c.id, p.title, p.encoded_title\r\n\t\tFROM " . PREFIX . "pages_cats c\r\n\t\tLEFT JOIN " . PREFIX . "pages p ON p.id = c.id_page\r\n\t\tWHERE c.id_parent = 0\r\n\t\tORDER BY p.title ASC"); while ($row = $result->fetch()) { $sub_cats_number = PersistenceContext::get_querier()->count(PREFIX . "pages_cats", 'WHERE id_parent=:id_parent', array('id_parent' => $row['id'])); if ($sub_cats_number > 0) { $tpl->assign_block_vars('list', array('DIRECTORY' => '<li class="sub"><a class="parent" href="javascript:show_pages_cat_contents(' . $row['id'] . ', 0);"><i class="fa fa-plus-square-o" id="img2_' . $row['id'] . '"></i><i class="fa fa-folder" id ="img_' . $row['id'] . '"></i></a><a id="class_' . $row['id'] . '" href="javascript:open_cat(' . $row['id'] . ');">' . stripslashes($row['title']) . '</a><span id="cat_' . $row['id'] . '"></li>')); } else { $tpl->assign_block_vars('list', array('DIRECTORY' => '<li class="sub"><a id="class_' . $row['id'] . '" href="javascript:open_cat(' . $row['id'] . ');"><i class="fa fa-folder"></i>' . stripslashes($row['title']) . '</a><span id="cat_' . $row['id'] . '"></span></li>')); } } $result->dispose(); return $tpl; }
private function create_module_map_sections($id_cat, $auth_mode) { global $LANG; $pages_config = PagesConfig::load(); $categories_cache = PagesCategoriesCache::load(); $categories = $categories_cache->get_categories(); //Configuration des authorisations $config_authorizations = $pages_config->get_authorizations(); $this_category = new SitemapLink($categories[$id_cat]['title'], new Url('/pages/' . url('pages.php?title=' . Url::encode_rewrite($categories[$id_cat]['title']), Url::encode_rewrite($categories[$id_cat]['title'])))); $category = new SitemapSection($this_category); $i = 0; $keys = array_keys($categories); $num_cats = $categories_cache->get_number_categories(); $properties = array(); for ($j = 0; $j < $num_cats; $j++) { $id = $keys[$j]; $properties = $categories[$id]; if ($auth_mode == Sitemap::AUTH_PUBLIC) { $this_auth = is_array($properties['auth']) ? Authorizations::check_auth(RANK_TYPE, User::VISITOR_LEVEL, $properties['auth'], READ_PAGE) : Authorizations::check_auth(RANK_TYPE, User::VISITOR_LEVEL, $config_authorizations, READ_PAGE); } elseif ($auth_mode == Sitemap::AUTH_USER) { if (AppContext::get_current_user()->get_level() == User::ADMIN_LEVEL) { $this_auth = true; } else { $this_auth = is_array($properties['auth']) ? Authorizations::check_auth(RANK_TYPE, AppContext::get_current_user()->get_level(), $properties['auth'], READ_PAGE) : Authorizations::check_auth(RANK_TYPE, AppContext::get_current_user()->get_level(), $config_authorizations, READ_PAGE); } } if ($this_auth && $id != 0 && $properties['id_parent'] == $id_cat) { $category->add($this->create_module_map_sections($id, $auth_mode)); $i++; } } if ($i == 0) { $category = $this_category; } return $category; }
require_once '../kernel/begin.php'; AppContext::get_session()->no_session_location(); //Permet de ne pas mettre jour la page dans la session. require_once '../pages/pages_begin.php'; require_once '../kernel/header_no_display.php'; $request = AppContext::get_request(); $id_cat = $request->get_postint('id_cat', 0); $select_cat = $request->get_getint('select_cat', 0); $selected_cat = $request->get_postint('selected_cat', 0); $display_select_link = $request->get_getint('display_select_link', 0); $open_cat = $request->get_postint('open_cat', 0); $root = $request->get_getint('root', 0); //Configuration des authorisations $config_authorizations = $pages_config->get_authorizations(); $categories = PagesCategoriesCache::load()->get_categories(); //Listage des répertoires dont le répertoire parent est connu if ($id_cat != 0) { echo '<ul>'; //On sélectionne les répetoires dont l'id parent est connu $result = PersistenceContext::get_querier()->select("SELECT c.id, p.title, p.encoded_title, p.auth\n\tFROM " . PREFIX . "pages_cats c\n\tLEFT JOIN " . PREFIX . "pages p ON p.id = c.id_page\n\tWHERE c.id_parent = :id\n\tORDER BY title ASC", array('id' => $id_cat)); while ($row = $result->fetch()) { //Autorisation particulière ? $special_auth = !empty($row['auth']); //Vérification de l'autorisation d'éditer la page if ($special_auth && AppContext::get_current_user()->check_auth($row['auth'], READ_PAGE) || !$special_auth && AppContext::get_current_user()->check_auth($config_authorizations, READ_PAGE)) { //On compte le nombre de catégories présentes pour savoir si on donne la possibilité de faire un sous dossier $sub_cats_number = PersistenceContext::get_querier()->count(PREFIX . "pages_cats", 'WHERE id_parent=:id_parent', array('id_parent' => $row['id'])); //Si cette catégorie contient des sous catégories, on propose de voir son contenu if ($sub_cats_number > 0) { echo '<li class="sub"><a class="parent" href="javascript:show_pages_cat_contents(' . $row['id'] . ', ' . ($display_select_link != 0 ? 1 : 0) . ');"><i class="fa fa-plus-square-o" id="img2_' . $row['id'] . '"></i><i class="fa fa-folder" id="img_' . $row['id'] . '"></i></a><a id="class_' . $row['id'] . '" href="javascript:' . ($display_select_link != 0 ? 'select_cat' : 'open_cat') . '(' . $row['id'] . ');">' . stripslashes($row['title']) . '</a><span id="cat_' . $row['id'] . '"></span></li>';
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. * ###################################################*/ require_once '../kernel/begin.php'; $encoded_title = retrieve(GET, 'title', ''); $id_com = retrieve(GET, 'id', 0); include_once 'pages_begin.php'; include_once 'pages_functions.php'; //Configuration des authorisations $config_authorizations = $pages_config->get_authorizations(); $categories_cache = PagesCategoriesCache::load(); $db_querier = PersistenceContext::get_querier(); //Requêtes préliminaires utiles par la suite if (!empty($encoded_title)) { try { $page_infos = $db_querier->select_single_row(PREFIX . 'pages', array('id', 'title', 'auth', 'is_cat', 'id_cat', 'hits', 'count_hits', 'activ_com', 'redirect', 'contents', 'display_print_link'), 'WHERE encoded_title = :encoded_title', array('encoded_title' => $encoded_title)); } catch (RowNotFoundException $e) { $error_controller = PHPBoostErrors::unexisting_page(); DispatchManager::redirect($error_controller); } $num_rows = !empty($page_infos['title']) ? 1 : 0; if ($page_infos['redirect'] > 0) { $redirect_title = stripslashes($page_infos['title']); $redirect_id = $page_infos['id']; try { $page_infos = $db_querier->select_single_row(PREFIX . 'pages', array('id', 'title', 'auth', 'is_cat', 'id_cat', 'hits', 'count_hits', 'activ_com', 'redirect', 'contents', 'display_print_link'), 'WHERE id = :id', array('id' => $page_infos['redirect']));
function pages_find_subcats(&$array, $id_cat) { //On parcourt les catégories et on détermine les catégories filles foreach (PagesCategoriesCache::load()->get_categories() as $key => $cat) { if ($value['id_parent'] == $id_cat) { $array[] = $key; //On rappelle la fonction pour la catégorie fille pages_find_subcats($array, $key); } } }
* ###################################################*/ require_once '../kernel/begin.php'; require_once '../pages/pages_begin.php'; define('TITLE', $LANG['pages_explorer']); $cat = retrieve(GET, 'cat', 0); $Bread_crumb->add($LANG['pages'], url('pages.php')); $Bread_crumb->add($LANG['pages_explorer'], url('explorer.php')); require_once '../kernel/header.php'; //Configuration des authorisations $config_authorizations = $pages_config->get_authorizations(); $tpl = new FileTemplate('pages/explorer.tpl'); $module_data_path = $tpl->get_pictures_data_path(); //Liste des dossiers de la racine $root = ''; foreach (PagesCategoriesCache::load()->get_categories() as $key => $cat) { if ($cat['id_parent'] == 0) { //Autorisation particulière ? $special_auth = !empty($cat['auth']); //Vérification de l'autorisation d'éditer la page if ($special_auth && AppContext::get_current_user()->check_auth($cat['auth'], READ_PAGE) || !$special_auth && AppContext::get_current_user()->check_auth($config_authorizations, READ_PAGE)) { $root .= '<li><a href="javascript:open_cat(' . $key . '); show_pages_cat_contents(' . $cat['id_parent'] . ', 0);"><i class="fa fa-folder"></i>' . stripslashes($cat['title']) . '</a></li>'; } } } //Liste des fichiers de la racine $result = PersistenceContext::get_querier()->select("SELECT title, id, encoded_title, auth\n\tFROM " . PREFIX . "pages\n\tWHERE id_cat = 0 AND is_cat = 0\n\tORDER BY is_cat DESC, title ASC"); while ($row = $result->fetch()) { //Autorisation particulière ? $special_auth = !empty($row['auth']); $array_auth = unserialize($row['auth']);