function faq_mini($position, $block)
{
global $Cache, $Template, $FAQ_LANG, $FAQ_CATS, $RANDOM_QUESTIONS;
load_module_lang('faq');
$Cache->load('faq');
include_once PATH_TO_ROOT . '/faq/faq_begin.php';
include_once PATH_TO_ROOT . '/faq/faq_cats.class.php';
$tpl = new Template('faq/faq_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
$no_random_question = array('L_FAQ_RANDOM_QUESTION' => $FAQ_LANG['random_question'], 'FAQ_QUESTION' => $FAQ_LANG['no_random_question'], 'U_FAQ_QUESTION' => TPL_PATH_TO_ROOT . '/faq/' . url('faq.php'));
if (empty($RANDOM_QUESTIONS)) {
$tpl->assign_vars($no_random_question);
return $tpl->parse(TEMPLATE_STRING_MODE);
}
$random_question = $RANDOM_QUESTIONS[array_rand($RANDOM_QUESTIONS)];
$faq_cats = new FaqCats();
$i = 0;
while (!$faq_cats->check_auth($random_question['idcat']) && $i < 5) {
$random_question = $RANDOM_QUESTIONS[array_rand($RANDOM_QUESTIONS)];
$i++;
}
if ($i < 5 && !empty($random_question['question'])) {
$tpl->assign_vars(array('L_FAQ_RANDOM_QUESTION' => $FAQ_LANG['random_question'], 'FAQ_QUESTION' => $random_question['question'], 'U_FAQ_QUESTION' => PATH_TO_ROOT . '/faq/' . ($random_question['idcat'] > 0 ? url('faq.php?id=' . $random_question['idcat'] . '&question=' . $random_question['id'], 'faq-' . $random_question['idcat'] . '+' . url_encode_rewrite($FAQ_CATS[$random_question['idcat']]['name']) . '.php?question=' . $random_question['id']) . '#q' . $random_question['id'] : url('faq.php?question=' . $random_question['id'], 'faq.php?question=' . $random_question['id']) . '#q' . $random_question['id'])));
} else {
$tpl->assign_vars($no_random_question);
}
return $tpl->parse(TEMPLATE_STRING_MODE);
}
function get_feed_data_struct($idcat = 0, $name = '')
{
global $Cache, $Sql, $LANG, $CONFIG, $CONFIG_NEWS;
import('content/syndication/feed_data');
import('util/date');
import('util/url');
load_module_lang('news');
$data = new FeedData();
$data->set_title($LANG['xml_news_desc'] . ' ' . $CONFIG['server_name']);
$data->set_date(new Date());
$data->set_link(new Url('/syndication.php?m=news&cat=' . $idcat));
$data->set_host(HOST);
$data->set_desc($LANG['xml_news_desc'] . ' ' . $CONFIG['server_name']);
$data->set_lang($LANG['xml_lang']);
$Cache->load('news');
$result = $Sql->query_while("SELECT id, title, contents, timestamp, img\n FROM " . PREFIX . "news\n WHERE visible = 1\n ORDER BY timestamp DESC" . $Sql->limit(0, 2 * $CONFIG_NEWS['pagination_news']), __LINE__, __FILE__);
while ($row = $Sql->fetch_assoc($result)) {
$item = new FeedItem();
$item->set_title($row['title']);
$link = new Url('/news/news' . url('.php?id=' . $row['id'], '-0-' . $row['id'] . '+' . url_encode_rewrite($row['title']) . '.php'));
$item->set_link($link);
$item->set_guid($link);
$item->set_desc(second_parse($row['contents']));
$item->set_date(new Date(DATE_TIMESTAMP, TIMEZONE_SYSTEM, $row['timestamp']));
$item->set_image_url($row['img']);
$data->add_item($item);
}
$Sql->query_close($result);
return $data;
}
private function get_module_map($auth_mode)
{
global $LANG;
include PATH_TO_ROOT . '/pages/pages_defines.php';
load_module_lang('pages');
$pages_config = PagesConfig::load();
$categories_cache = PagesCategoriesCache::load();
$categories = $categories_cache->get_categories();
//Configuration des authorisations
$config_authorizations = $pages_config->get_authorizations();
$pages_link = new SitemapLink($LANG['pages'], new Url('/pages/explorer.php'), Sitemap::FREQ_DEFAULT, Sitemap::PRIORITY_MAX);
$module_map = new ModuleMap($pages_link, 'pages');
$id_cat = 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) {
$module_map->add($this->create_module_map_sections($id, $auth_mode));
}
}
return $module_map;
}
function guestbook_mini($position, $block)
{
global $LANG, $Cache, $_guestbook_rand_msg;
if (strpos(SCRIPT, '/guestbook/guestbook.php') === false) {
load_module_lang('guestbook');
$Cache->load('guestbook');
###########################Affichage##############################
$tpl = new Template('guestbook/guestbook_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
$rand = array_rand($_guestbook_rand_msg);
$guestbook_rand = isset($_guestbook_rand_msg[$rand]) ? $_guestbook_rand_msg[$rand] : array();
if ($guestbook_rand === array()) {
$tpl->assign_vars(array('C_ANY_MESSAGE_GESTBOOK' => false, 'L_RANDOM_GESTBOOK' => $LANG['title_guestbook'], 'L_NO_MESSAGE_GESTBOOK' => $LANG['no_message_guestbook']));
} else {
if ($guestbook_rand['user_id'] != -1) {
$guestbook_login = '******' . TPL_PATH_TO_ROOT . '/member/member' . url('.php?id=' . $guestbook_rand['user_id'], '-' . $guestbook_rand['user_id'] . '.php') . '" title="' . $guestbook_rand['login'] . '"><span style="font-weight:bold;">' . wordwrap_html($guestbook_rand['login'], 13) . '</span></a>';
} else {
$guestbook_login = '******' . (!empty($guestbook_rand['login']) ? wordwrap_html($guestbook_rand['login'], 13) : $LANG['guest']) . '</span>';
}
$tpl->assign_vars(array('C_ANY_MESSAGE_GESTBOOK' => true, 'L_RANDOM_GESTBOOK' => $LANG['title_guestbook'], 'RAND_MSG_ID' => $guestbook_rand['id'], 'RAND_MSG_CONTENTS' => strlen($guestbook_rand['contents']) > 149 ? ucfirst($guestbook_rand['contents']) . ' <a href="' . TPL_PATH_TO_ROOT . '/guestbook/guestbook.php" class="small_link">' . $LANG['guestbook_more_contents'] . '</a>' : ucfirst($guestbook_rand['contents']), 'RAND_MSG_LOGIN' => $guestbook_login, 'L_BY' => $LANG['by']));
}
return $tpl->parse(TEMPLATE_STRING_MODE);
}
return '';
}
public function get_content()
{
global $LANG;
load_module_lang('search');
$search = retrieve(REQUEST, 'q', '');
$tpl = new FileTemplate('search/search_mini.tpl');
$tpl->put_all(array('TEXT_SEARCHED' => !empty($search) ? stripslashes(retrieve(REQUEST, 'q', '')) : '', 'WARNING_LENGTH_STRING_SEARCH' => addslashes($LANG['warning_length_string_searched']), 'L_SEARCH' => $LANG['search'], 'U_FORM_VALID' => url(TPL_PATH_TO_ROOT . '/search/search.php#results'), 'L_ADVANCED_SEARCH' => $LANG['advanced_search'], 'U_ADVANCED_SEARCH' => url(TPL_PATH_TO_ROOT . '/search/search.php')));
return $tpl;
}
function newsletter_mini($position, $block)
{
global $LANG, $User;
load_module_lang('newsletter');
$tpl = new Template('newsletter/newsletter_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
$tpl->assign_vars(array('SUBSCRIBE' => $LANG['subscribe'], 'UNSUBSCRIBE' => $LANG['unsubscribe'], 'USER_MAIL' => $User->get_attribute('user_mail') != '' ? $User->get_attribute('user_mail') : '', 'L_NEWSLETTER' => $LANG['newsletter'], 'L_SUBMIT' => $LANG['submit'], 'L_ARCHIVES' => $LANG['archives']));
return $tpl->parse(TEMPLATE_STRING_MODE);
}
public function get_actions_tree_links()
{
global $LANG;
load_module_lang('search');
//Chargement de la langue du module.
$tree = new ModuleTreeLinks();
$tree->add_link(new AdminModuleLink($LANG['search_config'], new Url('/search/admin_search.php')));
$tree->add_link(new AdminModuleLink($LANG['weights.manage'], new Url('/search/admin_search.php?weighting=true')));
return $tree;
}
function search_mini($position, $block)
{
global $LANG;
load_module_lang('search');
$search = retrieve(REQUEST, 'q', '');
$tpl = new Template('search/search_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
$tpl->assign_vars(array('TITLE_SEARCH' => TITLE, 'SEARCH' => $LANG['title_search'], 'TEXT_SEARCHED' => !empty($search) ? stripslashes(retrieve(REQUEST, 'q', '')) : $LANG['search'] . '...', 'WARNING_LENGTH_STRING_SEARCH' => addslashes($LANG['warning_length_string_searched']), 'L_SEARCH' => $LANG['search'], 'U_FORM_VALID' => url(TPL_PATH_TO_ROOT . '/search/search.php#results'), 'L_ADVANCED_SEARCH' => $LANG['advanced_search'], 'U_ADVANCED_SEARCH' => url(TPL_PATH_TO_ROOT . '/search/search.php')));
return $tpl->parse(TEMPLATE_STRING_MODE);
}
public function get_search_form($args = null)
{
require_once PATH_TO_ROOT . '/kernel/begin.php';
load_module_lang('wiki');
global $LANG;
$tpl = new FileTemplate('wiki/wiki_search_form.tpl');
if (!isset($args['WikiWhere']) || !in_array($args['WikiWhere'], explode(',', 'title,contents,all'))) {
$args['WikiWhere'] = 'title';
}
$tpl->put_all(array('L_WHERE' => $LANG['wiki_search_where'], 'IS_TITLE_SELECTED' => $args['WikiWhere'] == 'title' ? ' selected="selected"' : '', 'IS_CONTENTS_SELECTED' => $args['WikiWhere'] == 'contents' ? ' selected="selected"' : '', 'IS_ALL_SELECTED' => $args['WikiWhere'] == 'all' ? ' selected="selected"' : '', 'L_TITLE' => $LANG['wiki_search_where_title'], 'L_CONTENTS' => $LANG['wiki_search_where_contents']));
return $tpl->render();
}
public function get_menu_content()
{
global $LANG;
//Chargement de la langue du module.
load_module_lang('stats');
$tpl = new FileTemplate('stats/stats_mini.tpl');
$stats_cache = StatsCache::load();
$l_member_registered = $stats_cache->get_stats_properties('nbr_members') > 1 ? $LANG['member_registered_s'] : $LANG['member_registered'];
$group_color = User::get_group_color($stats_cache->get_stats_properties('last_member_groups'), $stats_cache->get_stats_properties('last_member_level'));
$tpl->put_all(array('L_MORE_STAT' => $LANG['more_stats'], 'L_USER_REGISTERED' => sprintf($l_member_registered, $stats_cache->get_stats_properties('nbr_members')), 'L_LAST_REGISTERED_USER' => $LANG['last_member'], 'U_LINK_LAST_USER' => '<a href="' . UserUrlBuilder::profile($stats_cache->get_stats_properties('last_member_id'))->rel() . '" class="' . UserService::get_level_class($stats_cache->get_stats_properties('last_member_level')) . '"' . (!empty($group_color) ? ' style="color:' . $group_color . '"' : '') . '>' . $stats_cache->get_stats_properties('last_member_login') . '</a>'));
return $tpl->render();
}
function online_mini($position, $block)
{
if (strpos(SCRIPT, '/online/online.php') === false) {
global $LANG, $Cache, $Sql, $CONFIG, $CONFIG_ONLINE;
load_module_lang('online');
$Cache->load('online');
$tpl = new Template('online/online_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
list($count_visit, $count_member, $count_modo, $count_admin) = array(0, 0, 0, 0);
$i = 0;
$array_class = array('member', 'modo', 'admin');
$result = $Sql->query_while("SELECT s.user_id, s.level, s.session_time, m.user_groups, m.login\n \tFROM " . DB_TABLE_SESSIONS . " s\n \tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = s.user_id\n \tWHERE s.session_time > '" . (time() - $CONFIG['site_session_invit']) . "'\n \tORDER BY " . $CONFIG_ONLINE['display_order_online'], __LINE__, __FILE__);
while ($row = $Sql->fetch_assoc($result)) {
if ($i < $CONFIG_ONLINE['online_displayed']) {
if ($row['level'] !== '-1') {
$group_color = User::get_group_color($row['user_groups'], $row['level']);
$tpl->assign_block_vars('online', array('USER' => '<a href="' . TPL_PATH_TO_ROOT . '/member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '" class="' . $array_class[$row['level']] . '"' . (!empty($group_color) ? ' style="color:' . $group_color . '"' : '') . '>' . wordwrap_html($row['login'], 19) . '</a><br />'));
$i++;
}
}
switch ($row['level']) {
case '-1':
$count_visit++;
break;
case '0':
$count_member++;
break;
case '1':
$count_modo++;
break;
case '2':
$count_admin++;
break;
}
}
$Sql->query_close($result);
$count_visit = empty($count_visit) && empty($count_member) && empty($count_modo) && empty($count_admin) ? '1' : $count_visit;
$total = $count_visit + $count_member + $count_modo + $count_admin;
$total_member = $count_member + $count_modo + $count_admin;
$member_online = $LANG['member_s'] . ' ' . strtolower($LANG['online']);
$more = '<br /><a href="../online/online.php' . SID . '" title="' . $member_online . '">' . $member_online . '</a><br />';
$more = $total_member > $CONFIG_ONLINE['online_displayed'] ? $more : '';
$l_guest = $count_visit > 1 ? $LANG['guest_s'] : $LANG['guest'];
$l_member = $count_member > 1 ? $LANG['member_s'] : $LANG['member'];
$l_modo = $count_modo > 1 ? $LANG['modo_s'] : $LANG['modo'];
$l_admin = $count_admin > 1 ? $LANG['admin_s'] : $LANG['admin'];
$tpl->assign_vars(array('VISIT' => $count_visit, 'USER' => $count_member, 'MODO' => $count_modo, 'ADMIN' => $count_admin, 'MORE' => $more, 'TOTAL' => $total, 'L_VISITOR' => $l_guest, 'L_USER' => $l_member, 'L_MODO' => $l_modo, 'L_ADMIN' => $l_admin, 'L_ONLINE' => $LANG['online'], 'L_TOTAL' => $LANG['total']));
return $tpl->parse(TEMPLATE_STRING_MODE);
}
return '';
}
public function get_actions_tree_links()
{
global $LANG;
load_module_lang('poll');
//Chargement de la langue du module.
$tree = new ModuleTreeLinks();
$manage_poll_link = new AdminModuleLink($LANG['poll.manage'], new Url('/poll/admin_poll.php'));
$manage_poll_link->add_sub_link(new AdminModuleLink($LANG['poll.manage'], new Url('/poll/admin_poll.php')));
$manage_poll_link->add_sub_link(new AdminModuleLink($LANG['poll_add'], new Url('/poll/admin_poll_add.php')));
$tree->add_link($manage_poll_link);
$tree->add_link(new AdminModuleLink(LangLoader::get_message('configuration', 'admin'), new Url('/poll/admin_poll_config.php')));
return $tree;
}
function stats_mini($position, $block)
{
global $LANG, $Cache, $nbr_members, $last_member_id, $last_member_login;
load_module_lang('stats');
#########################Stats.tpl###########################
$tpl = new Template('stats/stats_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
$Cache->load('stats');
$l_member_registered = $nbr_members > 1 ? $LANG['member_registered_s'] : $LANG['member_registered'];
$tpl->assign_vars(array('SID' => SID, 'L_STATS' => $LANG['stats'], 'L_MORE_STAT' => $LANG['more_stats'], 'L_USER_REGISTERED' => sprintf($l_member_registered, $nbr_members), 'L_LAST_REGISTERED_USER' => $LANG['last_member'], 'U_LINK_LAST_USER' => '<a href="' . HOST . DIR . '/member/member' . url('.php?id=' . $last_member_id, '-' . $last_member_id . '.php') . '">' . $last_member_login . '</a>'));
return $tpl->parse(TEMPLATE_STRING_MODE);
}
public function get_menu_content()
{
global $LANG;
$poll_config = PollConfig::load();
$config_cookie_name = $poll_config->get_cookie_name();
$polls = PollMiniMenuCache::load()->get_polls();
//Chargement de la langue du module.
load_module_lang('poll');
$rand = array_rand($polls);
$poll_mini = $polls[$rand];
//Sondage aléatoire.
$tpl = new FileTemplate('poll/poll_mini.tpl');
#####################Résultats######################
//Si le cookie existe, on redirige vers les resulats, sinon on prend en compte le vote (vérification par ip plus tard).
$array_cookie = array();
if (AppContext::get_request()->has_cookieparameter($config_cookie_name)) {
$array_cookie = explode('/', AppContext::get_request()->get_cookie($config_cookie_name));
}
if (in_array($poll_mini['id'], $array_cookie)) {
$tpl->put_all(array('L_VOTE' => $poll_mini['total'] > 1 ? $LANG['poll_vote_s'] : $LANG['poll_vote']));
$tpl->assign_block_vars('result', array('QUESTION' => $poll_mini['question'], 'VOTES' => $poll_mini['total']));
foreach ($poll_mini['votes'] as $answer => $width) {
$tpl->assign_block_vars('result.answers', array('ANSWERS' => $answer, 'WIDTH' => NumberHelper::round($width, 0), 'PERCENT' => $width));
}
} else {
#####################Questions######################
$tpl->put_all(array('L_MINI_POLL' => $LANG['mini_poll'], 'L_VOTE' => $LANG['poll_vote'], 'L_POLL_RESULT' => $LANG['poll_result'], 'U_POLL_RESULT' => url('.php?id=' . $poll_mini['id'] . '&r=1', '-' . $poll_mini['id'] . '-1.php')));
$tpl->assign_block_vars('question', array('ID' => url('.php?id=' . $poll_mini['id'], '-' . $poll_mini['id'] . '.php'), 'QUESTION' => $poll_mini['question']));
$z = 0;
if ($poll_mini['type'] == '1') {
if (is_array($poll_mini['votes'])) {
// FIXME should always be an array, needs to patch cache generation
foreach ($poll_mini['votes'] as $answer => $width) {
$tpl->assign_block_vars('question.radio', array('NAME' => $z, 'ANSWERS' => $answer));
$z++;
}
}
} elseif ($poll_mini['type'] == '0') {
foreach ($poll_mini['votes'] as $answer => $width) {
$tpl->assign_block_vars('question.checkbox', array('NAME' => $z, 'ANSWERS' => $answer));
$z++;
}
}
}
return $tpl->render();
}
private function get_view()
{
global $Bread_crumb, $LANG, $encoded_title, $id_article, $article_infos, $id_cat;
load_module_lang('wiki');
include_once PATH_TO_ROOT . '/wiki/wiki_functions.php';
$bread_crumb_key = 'wiki';
require_once PATH_TO_ROOT . '/wiki/wiki_bread_crumb.php';
$config = WikiConfig::load();
$tpl = new FileTemplate('wiki/index.tpl');
if ($config->get_number_articles_on_index() > 1) {
$result = PersistenceContext::get_querier()->select("SELECT a.title, a.encoded_title, a.id\r\n\t\t\tFROM " . PREFIX . "wiki_articles a\r\n\t\t\tLEFT JOIN " . PREFIX . "wiki_contents c ON c.id_contents = a.id_contents\r\n\t\t\tWHERE a.redirect = 0\r\n\t\t\tORDER BY c.timestamp DESC\r\n\t\t\tLIMIT :number_articles_on_index OFFSET 0", array('number_articles_on_index' => $config->get_number_articles_on_index()));
$tpl->assign_block_vars('last_articles', array('C_ARTICLES' => $result->get_rows_count(), 'L_ARTICLES' => $LANG['wiki_last_articles_list']));
$i = 0;
while ($row = $result->fetch()) {
$tpl->assign_block_vars('last_articles.list', array('ARTICLE' => $row['title'], 'TR' => $i > 0 && $i % 2 == 0 ? '</tr><tr>' : '', 'U_ARTICLE' => url('wiki.php?title=' . $row['encoded_title'], $row['encoded_title'])));
$i++;
}
$result->dispose();
if ($i == 0) {
$tpl->put_all(array('L_NO_ARTICLE' => '<td class="center" colspan="2">' . $LANG['wiki_no_article'] . '</td>'));
}
}
//Affichage de toutes les catégories si c'est activé
if ($config->are_categories_displayed_on_index()) {
$tpl->assign_block_vars('cat_list', array('L_CATS' => $LANG['wiki_cats_list']));
$i = 0;
foreach (WikiCategoriesCache::load()->get_categories() as $id => $cat) {
//Si c'est une catégorie mère
if ($cat['id_parent'] == 0) {
$tpl->assign_block_vars('cat_list.list', array('CAT' => stripslashes($cat['title']), 'U_CAT' => url('wiki.php?title=' . $cat['encoded_title'], $cat['encoded_title'])));
$i++;
}
}
if ($i == 0) {
$tpl->put_all(array('L_NO_CAT' => $LANG['wiki_no_cat']));
}
}
$tpl->put_all(array('TITLE' => $config->get_wiki_name() ? $config->get_wiki_name() : $LANG['wiki'], 'INDEX_TEXT' => $config->get_index_text() ? FormatingHelper::second_parse(wiki_no_rewrite($config->get_index_text())) : $LANG['wiki_empty_index'], 'L_EXPLORER' => $LANG['wiki_explorer'], 'U_EXPLORER' => url('explorer.php')));
$page_type = 'index';
include PATH_TO_ROOT . '/wiki/wiki_tools.php';
$tpl->put('wiki_tools', $tools_tpl);
return new StringTemplate($tpl->render());
}
public function get_feed_data_struct($idcat = 0, $name = '')
{
$querier = PersistenceContext::get_querier();
global $LANG;
load_module_lang('wiki');
$categories = WikiCategoriesCache::load()->get_categories();
$config = WikiConfig::load();
$parameters = array('limit' => 20);
if ($idcat > 0 && array_key_exists($idcat, $categories)) {
$desc = sprintf($LANG['wiki_rss_cat'], stripslashes($categories[$idcat]['title']));
$where = 'AND a.id_cat = :idcat';
$parameters['idcat'] = $idcat;
} else {
$desc = sprintf($LANG['wiki_rss_last_articles'], $config->get_wiki_name() ? $config->get_wiki_name() : $LANG['wiki']);
$where = '';
}
$data = new FeedData();
$data->set_title($config->get_wiki_name() ? $config->get_wiki_name() : $LANG['wiki']);
$data->set_date(new Date());
$data->set_link(SyndicationUrlBuilder::rss('wiki', $idcat));
$data->set_host(HOST);
$data->set_desc($desc);
$data->set_lang($LANG['xml_lang']);
// Last news
$results = $querier->select('SELECT a.title, a.encoded_title, c.content, c.timestamp
FROM ' . PREFIX . 'wiki_articles a
LEFT JOIN ' . PREFIX . 'wiki_contents c ON c.id_contents = a.id_contents
WHERE a.redirect = 0 ' . $where . '
ORDER BY c.timestamp DESC LIMIT :limit OFFSET 0', $parameters);
// Generation of the feed's items
foreach ($results as $row) {
$item = new FeedItem();
$item->set_title($row['title']);
$link = new Url('/wiki/' . url('wiki.php?title=' . $row['encoded_title'], $row['encoded_title']));
$item->set_link($link);
$item->set_guid($link);
$item->set_desc(FormatingHelper::second_parse($row['content']));
$item->set_date(new Date($row['timestamp'], Timezone::SERVER_TIMEZONE));
$data->add_item($item);
}
$results->dispose();
return $data;
}
public function get_actions_tree_links()
{
global $LANG;
load_module_lang('wiki');
//Chargement de la langue du module.
require_once PATH_TO_ROOT . '/wiki/wiki_auth.php';
$id_cat = AppContext::get_request()->get_getstring('id_cat', 0);
$current_user = AppContext::get_current_user();
$config = WikiConfig::load();
$tree = new ModuleTreeLinks();
$tree->add_link(new AdminModuleLink(LangLoader::get_message('configuration', 'admin'), new Url('/wiki/admin_wiki.php')));
$tree->add_link(new AdminModuleLink($LANG['authorizations'], new Url('/wiki/admin_wiki_groups.php')));
$tree->add_link(new ModuleLink($LANG['wiki_create_article'], new Url('/wiki/post.php' . ($id_cat > 0 ? '?id_parent=' . $id_cat : '')), $current_user->check_auth($config->get_authorizations(), WIKI_CREATE_ARTICLE)));
$tree->add_link(new ModuleLink($LANG['wiki_create_cat'], new Url('/wiki/post.php?type=cat' . ($id_cat > 0 ? '&id_parent=' . $id_cat : '')), $current_user->check_auth($config->get_authorizations(), WIKI_CREATE_CAT)));
if ($current_user->check_level(User::MEMBER_LEVEL)) {
$tree->add_link(new ModuleLink($LANG['wiki_followed_articles'], new Url('/wiki/favorites.php')));
}
$tree->add_link(new ModuleLink($LANG['wiki_explorer_short'], new Url('/wiki/explorer.php')));
return $tree;
}
public function get_actions_tree_links()
{
global $LANG;
load_module_lang('pages');
//Chargement de la langue du module.
require_once PATH_TO_ROOT . '/pages/pages_defines.php';
$current_user = AppContext::get_current_user();
$config = PagesConfig::load();
$tree = new ModuleTreeLinks();
$manage_ranks_link = new AdminModuleLink($LANG['pages_manage'], new Url('/pages/pages.php'));
$manage_ranks_link->add_sub_link(new AdminModuleLink($LANG['pages_manage'], new Url('/pages/pages.php')));
$manage_ranks_link->add_sub_link(new AdminModuleLink($LANG['pages_create'], new Url('/pages/post.php')));
$tree->add_link($manage_ranks_link);
$tree->add_link(new AdminModuleLink(LangLoader::get_message('configuration', 'admin'), new Url('/pages/admin_pages.php')));
if (!$current_user->check_level(User::ADMIN_LEVEL)) {
$tree->add_link(new ModuleLink($LANG['pages_create'], new Url('/pages/post.php'), $current_user->check_auth($config->get_authorizations(), EDIT_PAGE)));
}
$tree->add_link(new ModuleLink($LANG['pages_redirection_manage'], new Url('/pages/action.php'), $current_user->check_auth($config->get_authorizations(), EDIT_PAGE)));
$tree->add_link(new ModuleLink($LANG['pages_explorer'], new Url('/pages/explorer.php'), $current_user->check_auth($config->get_authorizations(), EDIT_PAGE)));
return $tree;
}
private function get_module_map($auth_mode)
{
global $LANG;
load_module_lang('wiki');
$categories_cache = WikiCategoriesCache::load();
$categories = $categories_cache->get_categories();
$wiki_link = new SitemapLink($LANG['wiki'], new Url('/wiki/wiki.php'), Sitemap::FREQ_DEFAULT, Sitemap::PRIORITY_LOW);
$module_map = new ModuleMap($wiki_link, 'wiki');
$id_cat = 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 ($id != 0 && $properties['id_parent'] == $id_cat) {
$module_map->add($this->create_module_map_sections($id, $auth_mode));
}
}
return $module_map;
}
function poll_mini($position, $block)
{
global $Cache, $LANG, $CONFIG_POLL, $_array_poll;
$Cache->load('poll');
if (!empty($CONFIG_POLL['poll_mini']) && $CONFIG_POLL['poll_mini'] != array() && strpos(SCRIPT, '/poll/poll.php') === false) {
load_module_lang('poll');
$poll_mini = $_array_poll[array_rand($_array_poll)];
$tpl = new Template('poll/poll_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
#####################R�sultats######################
$array_cookie = isset($_COOKIE[$CONFIG_POLL['poll_cookie']]) ? explode('/', $_COOKIE[$CONFIG_POLL['poll_cookie']]) : array();
if (in_array($poll_mini['id'], $array_cookie)) {
$tpl->assign_vars(array('THEME' => get_utheme(), 'MODULE_DATA_PATH' => $tpl->get_module_data_path('poll'), 'L_MINI_POLL' => $LANG['mini_poll'], 'L_VOTE' => $poll_mini['total'] > 1 ? $LANG['poll_vote_s'] : $LANG['poll_vote']));
$tpl->assign_block_vars('result', array('QUESTION' => $poll_mini['question'], 'VOTES' => $poll_mini['total']));
foreach ($poll_mini['votes'] as $answer => $width) {
$tpl->assign_block_vars('result.answers', array('ANSWERS' => $answer, 'WIDTH' => number_round($width, 0), 'PERCENT' => $width));
}
} else {
#####################Questions######################
$tpl->assign_vars(array('L_MINI_POLL' => $LANG['mini_poll'], 'L_VOTE' => $LANG['poll_vote'], 'L_POLL_RESULT' => $LANG['poll_result'], 'U_POLL_RESULT' => url('.php?id=' . $poll_mini['id'] . '&r=1', '-' . $poll_mini['id'] . '-1.php')));
global $Session;
$tpl->assign_block_vars('question', array('ID' => url('.php?id=' . $poll_mini['id'] . '&token=' . $Session->get_token(), '-' . $poll_mini['id'] . '.php?token=' . $Session->get_token()), 'QUESTION' => $poll_mini['question']));
$z = 0;
if ($poll_mini['type'] == '1') {
foreach ($poll_mini['votes'] as $answer => $width) {
$tpl->assign_block_vars('question.radio', array('NAME' => $z, 'ANSWERS' => $answer));
$z++;
}
} elseif ($poll_mini['type'] == '0') {
foreach ($poll_mini['votes'] as $answer => $width) {
$tpl->assign_block_vars('question.checkbox', array('NAME' => $z, 'ANSWERS' => $answer));
$z++;
}
}
}
return $tpl->parse(TEMPLATE_STRING_MODE);
}
return '';
}
function get_feed_data_struct($idcat = 0)
{
global $Cache, $Sql, $LANG, $MEDIA_LANG, $CONFIG, $MEDIA_CONFIG, $MEDIA_CATS;
$Cache->load('media');
load_module_lang('media');
require_once PATH_TO_ROOT . '/media/media_constant.php';
require_once PATH_TO_ROOT . '/media/media_cats.class.php';
import('content/syndication/feed_data');
import('util/date');
import('util/url');
$data = new FeedData();
$data->set_title($MEDIA_LANG['xml_media_desc']);
$data->set_date(new Date());
$data->set_link(new Url('/syndication.php?m=media&cat=' . $idcat));
$data->set_host(HOST);
$data->set_desc($MEDIA_LANG['xml_media_desc']);
$data->set_lang($LANG['xml_lang']);
$data->set_auth_bit(MEDIA_AUTH_READ);
$cats = new MediaCats();
$children_cats = array();
$cats->build_children_id_list($idcat, $children_cats, RECURSIVE_EXPLORATION, ADD_THIS_CATEGORY_IN_LIST);
$result = $Sql->query_while("SELECT id, idcat, name, contents, timestamp FROM " . PREFIX . "media WHERE infos = '" . MEDIA_STATUS_APROBED . "' AND idcat IN (" . implode($children_cats, ',') . " ) ORDER BY timestamp DESC" . $Sql->limit(0, $MEDIA_CONFIG['pagin']), __LINE__, __FILE__);
while ($row = $Sql->fetch_assoc($result)) {
$item = new FeedItem();
$link = new Url('/media/media' . url('.php?id=' . $row['id'], '-' . $row['id'] . '+' . url_encode_rewrite($row['name']) . '.php'));
$item->set_title($row['name']);
$item->set_link($link);
$item->set_guid($link);
$item->set_desc(second_parse($row['contents']));
$item->set_date(new Date(DATE_TIMESTAMP, TIMEZONE_SYSTEM, $row['timestamp']));
$item->set_image_url($MEDIA_CATS[$row['idcat']]['image']);
$item->set_auth($cats->compute_heritated_auth($row['idcat'], MEDIA_AUTH_READ, AUTH_PARENT_PRIORITY));
$data->add_item($item);
}
$Sql->query_close($result);
return $data;
}
function get_feed_data_struct($idcat = 0, $name = '')
{
global $LANG;
$querier = PersistenceContext::get_querier();
$pages_config = PagesConfig::load();
if (!defined('READ_PAGE')) {
require_once PATH_TO_ROOT . '/pages/pages_defines.php';
}
load_module_lang('pages');
$data = new FeedData();
$data->set_title($LANG['pages_rss_desc']);
$data->set_date(new Date());
$data->set_link(SyndicationUrlBuilder::rss('pages', $idcat));
$data->set_host(HOST);
$data->set_desc($LANG['pages_rss_desc']);
$data->set_lang($LANG['xml_lang']);
$data->set_auth_bit(READ_PAGE);
$where_clause = !empty($idcat) ? ' WHERE p.id_cat = :idcat' : '';
$results = $querier->select('SELECT p.*
FROM ' . PREFIX . 'pages p ' . $where_clause . '
ORDER BY p.timestamp DESC LIMIT :limit OFFSET 0', array('idcat' => $idcat, 'limit' => 10));
// Generation of the feed's items
foreach ($results as $row) {
$item = new FeedItem();
$link = new Url(PagesUrlBuilder::get_link_item($row['encoded_title']));
$item->set_title(stripslashes($row['title']));
$item->set_link($link);
$item->set_guid($link);
$item->set_desc(preg_replace('`\\[page\\](.+)\\[/page\\]`U', '<br /><strong>$1</strong><hr />', FormatingHelper::second_parse($row['contents'])));
$item->set_date(new Date($row['timestamp'], Timezone::SERVER_TIMEZONE));
$item->set_auth(empty($row['auth']) ? $pages_config->get_authorizations() : unserialize($row['auth']));
$data->add_item($item);
}
$results->dispose();
return $data;
}
<?php
require_once '../kernel/begin.php';
include_once '../wiki/wiki_functions.php';
load_module_lang('wiki');
define('ALTERNATIVE_CSS', 'wiki');
require_once '../wiki/wiki_auth.php';
$random = retrieve(GET, 'random', false);
$id_auth = retrieve(GET, 'auth', 0);
$wiki_status = retrieve(GET, 'status', 0);
$move = retrieve(GET, 'move', 0);
$rename = retrieve(GET, 'rename', 0);
$redirect = retrieve(GET, 'redirect', 0);
$create_redirection = retrieve(GET, 'create_redirection', 0);
$idcom = retrieve(GET, 'idcom', 0);
$del_article = retrieve(GET, 'del', 0);
if ($id_auth > 0) {
define('TITLE', $LANG['wiki_auth_management']);
$article_infos = $Sql->query_array(PREFIX . 'wiki_articles', 'id', 'title', 'encoded_title', 'auth', 'is_cat', 'id_cat', "WHERE id = '" . $id_auth . "'", __LINE__, __FILE__);
if (!$User->check_auth($_WIKI_CONFIG['auth'], WIKI_RESTRICTION)) {
$Errorh->handler('e_auth', E_USER_REDIRECT);
}
} elseif ($wiki_status > 0) {
define('TITLE', $LANG['wiki_status_management']);
$article_infos = $Sql->query_array(PREFIX . 'wiki_articles', '*', "WHERE id = " . $wiki_status, __LINE__, __FILE__);
$general_auth = empty($article_infos['auth']) ? true : false;
$article_auth = !empty($article_infos['auth']) ? unserialize($article_infos['auth']) : array();
if (!((!$general_auth || $User->check_auth($_WIKI_CONFIG['auth'], WIKI_STATUS)) && ($general_auth || $User->check_auth($article_auth, WIKI_STATUS)))) {
$Errorh->handler('e_auth', E_USER_REDIRECT);
}
} elseif ($move > 0) {
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* 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.
*
###################################################*/
if (defined('PHPBOOST') !== true) {
exit;
}
load_module_lang('forum');
//Chargement de la langue du module.
$config = ForumConfig::load();
require_once PATH_TO_ROOT . '/forum/forum_defines.php';
//Supprime les menus suivant configuration du site.
$columns_disabled = ThemesManager::get_theme(AppContext::get_current_user()->get_theme())->get_columns_disabled();
if ($config->is_left_column_disabled()) {
$columns_disabled->set_disable_left_columns(true);
}
if ($config->is_right_column_disabled()) {
$columns_disabled->set_disable_right_columns(true);
}
//Fonction du forum.
require_once PATH_TO_ROOT . '/forum/forum_functions.php';
private function build_view()
{
global $LANG, $Bread_crumb;
load_module_lang('gallery');
$g_idpics = retrieve(GET, 'id', 0);
$g_views = retrieve(GET, 'views', false);
$g_notes = retrieve(GET, 'notes', false);
$g_sort = retrieve(GET, 'sort', '');
$g_sort = !empty($g_sort) ? 'sort=' . $g_sort : '';
//Récupération du mode d'ordonnement.
if (preg_match('`([a-z]+)_([a-z]+)`', $g_sort, $array_match)) {
$g_type = $array_match[1];
$g_mode = $array_match[2];
} else {
list($g_type, $g_mode) = array('date', 'desc');
}
$comments_topic = new GalleryCommentsTopic();
$config = GalleryConfig::load();
$category = $this->get_category();
$categories = GalleryService::get_categories_manager()->get_categories_cache()->get_childrens($category->get_id());
$authorized_categories = GalleryService::get_authorized_categories($category->get_id());
$Gallery = new Gallery();
$nbr_pics = $this->db_querier->count(GallerySetup::$gallery_table, 'WHERE idcat=:idcat AND aprob = 1', array('idcat' => $category->get_id()));
$total_cat = count($categories);
//On crée une pagination si le nombre de catégories est trop important.
$page = AppContext::get_request()->get_getint('p', 1);
$pagination = new ModulePagination($page, $total_cat, $config->get_categories_number_per_page());
$pagination->set_url(new Url('/gallery/gallery.php?p=%d&cat=' . $category->get_id() . '&id=' . $g_idpics . '&' . $g_sort));
if ($pagination->current_page_is_empty() && $page > 1) {
$error_controller = PHPBoostErrors::unexisting_page();
DispatchManager::redirect($error_controller);
}
//Colonnes des catégories.
$nbr_column_cats = $total_cat > $config->get_columns_number() ? $config->get_columns_number() : $total_cat;
$nbr_column_cats = !empty($nbr_column_cats) ? $nbr_column_cats : 1;
$column_width_cats = floor(100 / $nbr_column_cats);
//Colonnes des images.
$nbr_column_pics = $nbr_pics > $config->get_columns_number() ? $config->get_columns_number() : $nbr_pics;
$nbr_column_pics = !empty($nbr_column_pics) ? $nbr_column_pics : 1;
$column_width_pics = floor(100 / $nbr_column_pics);
$is_admin = AppContext::get_current_user()->check_level(User::ADMIN_LEVEL);
$is_modo = GalleryAuthorizationsService::check_authorizations($category->get_id())->moderation();
$module_data_path = $this->tpl->get_pictures_data_path();
$rewrite_title = Url::encode_rewrite($category->get_name());
##### Catégorie disponibles #####
$nbr_cat_displayed = 0;
if ($total_cat > 0 && empty($g_idpics)) {
$this->tpl->put('C_GALLERY_CATS', true);
$j = 0;
$result = $this->db_querier->select('SELECT @id_cat:= gallery_cats.id, gallery_cats.*,
(SELECT COUNT(*) FROM ' . GallerySetup::$gallery_table . '
WHERE idcat IN (
@id_cat,
(SELECT GROUP_CONCAT(id SEPARATOR \',\') FROM ' . GallerySetup::$gallery_cats_table . ' WHERE id_parent = @id_cat),
(SELECT GROUP_CONCAT(childs.id SEPARATOR \',\') FROM ' . GallerySetup::$gallery_cats_table . ' parents
INNER JOIN ' . GallerySetup::$gallery_cats_table . ' childs ON parents.id = childs.id_parent
WHERE parents.id_parent = @id_cat)
)
AND aprob = 1
) AS nbr_pics
FROM ' . GallerySetup::$gallery_cats_table . ' gallery_cats
WHERE id_parent = :id_category
AND id IN :authorized_categories
ORDER BY id_parent, c_order
LIMIT :number_items_per_page OFFSET :display_from', array('id_category' => $category->get_id(), 'authorized_categories' => $authorized_categories, 'number_items_per_page' => $pagination->get_number_items_per_page(), 'display_from' => $pagination->get_display_from()));
while ($row = $result->fetch()) {
$category_image = new Url($row['image']);
$this->tpl->assign_block_vars('sub_categories_list', array('C_CATEGORY_IMAGE' => !empty($row['image']), 'CATEGORY_NAME' => $row['name'], 'CATEGORY_IMAGE' => $category_image->rel(), 'PICTURES_NUMBER' => sprintf($LANG['nbr_pics_info'], $row['nbr_pics']), 'U_CATEGORY' => GalleryUrlBuilder::get_link_cat($row['id'], $row['name'])));
$nbr_cat_displayed++;
}
$result->dispose();
}
$category_description = FormatingHelper::second_parse($category->get_description());
$this->tpl->put_all(array('C_ROOT_CATEGORY' => $category->get_id() == Category::ROOT_CATEGORY, 'C_CATEGORY_DESCRIPTION' => $category_description, 'C_SUB_CATEGORIES' => $nbr_cat_displayed > 0, 'C_SUBCATEGORIES_PAGINATION' => $pagination->has_several_pages(), 'SUBCATEGORIES_PAGINATION' => $pagination->display(), 'ARRAY_JS' => '', 'NBR_PICS' => 0, 'MAX_START' => 0, 'START_THUMB' => 0, 'END_THUMB' => 0, 'COLUMNS_NUMBER' => $nbr_column_pics, 'CATS_COLUMNS_WIDTH' => $column_width_cats, 'COLUMN_WIDTH_PICS' => $column_width_pics, 'CATEGORY_DESCRIPTION' => $category_description, 'U_EDIT_CATEGORY' => $category->get_id() == Category::ROOT_CATEGORY ? GalleryUrlBuilder::configuration()->rel() : GalleryUrlBuilder::edit_category($category->get_id())->rel(), 'CAT_ID' => $category->get_id(), 'DISPLAY_MODE' => $config->get_pics_enlargement_mode(), 'GALLERY' => $category->get_id() != Category::ROOT_CATEGORY ? $this->lang['module_title'] . ' - ' . $category->get_name() : $this->lang['module_title'], 'HEIGHT_MAX' => $config->get_mini_max_height(), 'WIDTH_MAX' => $column_width_pics, 'MODULE_DATA_PATH' => $module_data_path, 'L_APROB' => $LANG['aprob'], 'L_UNAPROB' => $LANG['unaprob'], 'L_FILE_FORBIDDEN_CHARS' => $LANG['file_forbidden_chars'], 'L_TOTAL_IMG' => $category->get_id() != Category::ROOT_CATEGORY ? sprintf($LANG['total_img_cat'], $nbr_pics) : '', 'L_ADD_IMG' => $LANG['add_pic'], 'L_GALLERY' => $this->lang['module_title'], 'L_CATEGORIES' => $category->get_id_parent() >= 0 ? $LANG['sub_album'] : $LANG['album'], 'L_NAME' => $LANG['name'], 'L_EDIT' => LangLoader::get_message('edit', 'common'), 'L_MOVETO' => $LANG['moveto'], 'L_DELETE' => LangLoader::get_message('delete', 'common'), 'L_SUBMIT' => $LANG['submit'], 'L_ALREADY_VOTED' => $LANG['already_vote'], 'L_ORDER_BY' => LangLoader::get_message('sort_by', 'common') . (isset($LANG[$g_type]) ? ' ' . strtolower($LANG[$g_type]) : ''), 'L_DIRECTION' => $LANG['direction'], 'L_DISPLAY' => LangLoader::get_message('display', 'common'), 'U_INDEX' => url('.php'), 'U_BEST_VIEWS' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?views=1&cat=' . $category->get_id(), '-' . $category->get_id() . '.php?views=1'), 'U_BEST_NOTES' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?notes=1&cat=' . $category->get_id(), '-' . $category->get_id() . '.php?notes=1'), 'U_ASC' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?cat=' . $category->get_id() . '&sort=' . $g_type . '_' . 'asc', '-' . $category->get_id() . '.php?sort=' . $g_type . '_' . 'asc'), 'U_DESC' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?cat=' . $category->get_id() . '&sort=' . $g_type . '_' . 'desc', '-' . $category->get_id() . '.php?sort=' . $g_type . '_' . 'desc'), 'U_ORDER_BY_NAME' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?sort=name_desc&cat=' . $category->get_id(), '-' . $category->get_id() . '+' . $rewrite_title . '.php?sort=name_desc'), 'U_ORDER_BY_DATE' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?sort=date_desc&cat=' . $category->get_id(), '-' . $category->get_id() . '+' . $rewrite_title . '.php?sort=date_desc'), 'U_ORDER_BY_VIEWS' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?sort=views_desc&cat=' . $category->get_id(), '-' . $category->get_id() . '+' . $rewrite_title . '.php?sort=views_desc'), 'U_ORDER_BY_NOTES' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?sort=notes_desc&cat=' . $category->get_id(), '-' . $category->get_id() . '+' . $rewrite_title . '.php?sort=notes_desc'), 'U_ORDER_BY_COM' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?sort=com_desc&cat=' . $category->get_id(), '-' . $category->get_id() . '+' . $rewrite_title . '.php?sort=com_desc'), 'L_BEST_VIEWS' => $LANG['best_views'], 'L_BEST_NOTES' => $LANG['best_notes'], 'L_ASC' => $LANG['asc'], 'L_DESC' => $LANG['desc'], 'L_DATE' => LangLoader::get_message('date', 'date-common'), 'L_VIEWS' => $LANG['views'], 'L_NOTES' => LangLoader::get_message('notes', 'common'), 'L_COM' => $LANG['com_s']));
##### Affichage des photos #####
if ($nbr_pics > 0) {
switch ($g_type) {
case 'name':
$sort_type = 'g.name';
break;
case 'date':
$sort_type = 'g.timestamp';
break;
case 'views':
$sort_type = 'g.views';
break;
case 'notes':
$sort_type = 'notes.average_notes';
break;
case 'com':
$sort_type = 'com.number_comments';
break;
default:
$sort_type = 'g.timestamp';
}
switch ($g_mode) {
case 'desc':
$sort_mode = 'DESC';
break;
case 'asc':
$sort_mode = 'ASC';
break;
default:
$sort_mode = 'DESC';
}
$g_sql_sort = ' ORDER BY ' . $sort_type . ' ' . $sort_mode;
if ($g_views) {
$g_sql_sort = ' ORDER BY g.views DESC';
} elseif ($g_notes) {
$g_sql_sort = ' ORDER BY notes.average_notes DESC';
}
$this->tpl->put('C_GALLERY_PICS', true);
//Affichage d'une photo demandée.
if (!empty($g_idpics)) {
$info_pics = $this->db_querier->select_single_row_query("SELECT g.*, m.display_name, m.groups, m.level, notes.average_notes, notes.number_notes, note.note\n\t\t\t\t\tFROM " . GallerySetup::$gallery_table . " g\n\t\t\t\t\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = g.user_id\n\t\t\t\t\tLEFT JOIN " . DB_TABLE_COMMENTS_TOPIC . " com ON com.id_in_module = g.id AND com.module_id = 'gallery'\n\t\t\t\t\tLEFT JOIN " . DB_TABLE_AVERAGE_NOTES . " notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'\n\t\t\t\t\tLEFT JOIN " . DB_TABLE_NOTE . " note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = :user_id\n\t\t\t\t\tWHERE g.idcat = :idcat AND g.id = :id AND g.aprob = 1\n\t\t\t\t\t" . $g_sql_sort, array('user_id' => AppContext::get_current_user()->get_id(), 'idcat' => $category->get_id(), 'id' => $g_idpics));
if (!empty($info_pics['id'])) {
$Bread_crumb->add(stripslashes($info_pics['name']), PATH_TO_ROOT . '/gallery/gallery' . url('.php?cat=' . $info_pics['idcat'] . '&id=' . $info_pics['id'], '-' . $info_pics['idcat'] . '-' . $info_pics['id'] . '.php'));
//Affichage miniatures.
$id_previous = 0;
$id_next = 0;
$nbr_pics_display_before = floor(($nbr_column_pics - 1) / 2);
//Nombres de photos de chaque côté de la miniature de la photo affichée.
$nbr_pics_display_after = $nbr_column_pics - 1 - floor($nbr_pics_display_before);
list($i, $reach_pics_pos, $pos_pics, $thumbnails_before, $thumbnails_after, $start_thumbnails, $end_thumbnails) = array(0, false, 0, 0, 0, $nbr_pics_display_before, $nbr_pics_display_after);
$array_pics = array();
$array_js = 'var array_pics = new Array();';
$result = $this->db_querier->select("SELECT g.id, g.idcat, g.path\n\t\t\t\t\tFROM " . GallerySetup::$gallery_table . " g\n\t\t\t\t\tWHERE g.idcat = :idcat AND g.aprob = 1\n\t\t\t\t\t" . $g_sql_sort, array('idcat' => $category->get_id()));
while ($row = $result->fetch()) {
//Si la miniature n'existe pas (cache vidé) on regénère la miniature à partir de l'image en taille réelle.
if (!file_exists(PATH_TO_ROOT . '/gallery/pics/thumbnails/' . $row['path'])) {
$Gallery->Resize_pics(PATH_TO_ROOT . '/gallery/pics/' . $row['path']);
}
//Redimensionnement + création miniature
//Affichage de la liste des miniatures sous l'image.
$array_pics[] = '<td class="center" style="height:' . ($config->get_mini_max_height() + 16) . 'px"><span id="thumb' . $i . '"><a href="gallery' . url('.php?cat=' . $row['idcat'] . '&id=' . $row['id'] . '&sort=' . $g_sort, '-' . $row['idcat'] . '-' . $row['id'] . '.php?sort=' . $g_sort) . '#pics_max' . '"><img src="pics/thumbnails/' . $row['path'] . '" alt="' . $row['path'] . '" /></a></span></td>';
if ($row['id'] == $g_idpics) {
$reach_pics_pos = true;
$pos_pics = $i;
} else {
if (!$reach_pics_pos) {
$thumbnails_before++;
$id_previous = $row['id'];
} else {
$thumbnails_after++;
if (empty($id_next)) {
$id_next = $row['id'];
}
}
}
$array_js .= 'array_pics[' . $i . '] = new Array();' . "\n";
$array_js .= 'array_pics[' . $i . '][\'link\'] = \'' . GalleryUrlBuilder::get_link_item($row['idcat'], $row['id']) . '#pics_max' . "';\n";
$array_js .= 'array_pics[' . $i . '][\'path\'] = \'' . $row['path'] . "';\n";
$i++;
}
$result->dispose();
$activ_note = $config->is_notation_enabled() && AppContext::get_current_user()->check_level(User::MEMBER_LEVEL);
if ($activ_note) {
//Affichage notation.
$notation = new Notation();
$notation->set_module_name('gallery');
$notation->set_id_in_module($info_pics['id']);
$notation->set_notation_scale($config->get_notation_scale());
$notation->set_number_notes($info_pics['number_notes']);
$notation->set_average_notes($info_pics['average_notes']);
$notation->set_user_already_noted(!empty($info_pics['note']));
}
if ($thumbnails_before < $nbr_pics_display_before) {
$end_thumbnails += $nbr_pics_display_before - $thumbnails_before;
}
if ($thumbnails_after < $nbr_pics_display_after) {
$start_thumbnails += $nbr_pics_display_after - $thumbnails_after;
}
$html_protected_name = $info_pics['name'];
$comments_topic->set_id_in_module($info_pics['id']);
$comments_topic->set_url(new Url('/gallery/gallery.php?cat=' . $category->get_id() . '&id=' . $g_idpics . '&com=0'));
//Liste des catégories.
$search_category_children_options = new SearchCategoryChildrensOptions();
$search_category_children_options->add_authorizations_bits(Category::READ_AUTHORIZATIONS);
$search_category_children_options->add_authorizations_bits(Category::WRITE_AUTHORIZATIONS);
$categories_tree = GalleryService::get_categories_manager()->get_select_categories_form_field($info_pics['id'] . 'cat', '', $info_pics['idcat'], $search_category_children_options);
$method = new ReflectionMethod('AbstractFormFieldChoice', 'get_options');
$method->setAccessible(true);
$categories_tree_options = $method->invoke($categories_tree);
$cat_list = '';
foreach ($categories_tree_options as $option) {
$cat_list .= $option->display()->render();
}
$group_color = User::get_group_color($info_pics['groups'], $info_pics['level']);
//Affichage de l'image et de ses informations.
$this->tpl->put_all(array('C_GALLERY_PICS_MAX' => true, 'C_GALLERY_PICS_MODO' => $is_modo, 'C_AUTHOR_DISPLAYED' => $config->is_author_displayed(), 'C_VIEWS_COUNTER_ENABLED' => $config->is_views_counter_enabled(), 'C_TITLE_ENABLED' => $config->is_title_enabled(), 'C_COMMENTS_ENABLED' => $config->are_comments_enabled(), 'C_NOTATION_ENABLED' => $config->is_notation_enabled(), 'ID' => $info_pics['id'], 'NAME' => '<span id="fi_' . $info_pics['id'] . '">' . stripslashes($info_pics['name']) . '</span> <span id="fi' . $info_pics['id'] . '"></span>', 'POSTOR' => '<a class="small ' . UserService::get_level_class($info_pics['level']) . '"' . (!empty($group_color) ? ' style="color:' . $group_color . '"' : '') . ' href="' . UserUrlBuilder::profile($info_pics['user_id'])->rel() . '">' . $info_pics['display_name'] . '</a>', 'DATE' => Date::to_format($info_pics['timestamp'], Date::FORMAT_DAY_MONTH_YEAR), 'VIEWS' => $info_pics['views'] + 1, 'DIMENSION' => $info_pics['width'] . ' x ' . $info_pics['height'], 'SIZE' => NumberHelper::round($info_pics['weight'] / 1024, 1), 'L_COMMENTS' => CommentsService::get_number_and_lang_comments('gallery', $info_pics['id']), 'KERNEL_NOTATION' => $activ_note ? NotationService::display_active_image($notation) : '', 'COLSPAN' => $config->get_columns_number() + 2, 'CAT' => $cat_list, 'RENAME' => $html_protected_name, 'RENAME_CUT' => $html_protected_name, 'IMG_APROB' => $info_pics['aprob'] == 1 ? 'fa fa-eye-slash' : 'fa fa-eye', 'ARRAY_JS' => $array_js, 'NBR_PICS' => $i - 1, 'MAX_START' => $i - 1 - $nbr_column_pics, 'START_THUMB' => $pos_pics - $start_thumbnails > 0 ? $pos_pics - $start_thumbnails : 0, 'END_THUMB' => $pos_pics + $end_thumbnails, 'L_KB' => LangLoader::get_message('unit.kilobytes', 'common'), 'L_INFORMATIONS' => $LANG['informations'], 'L_NAME' => $LANG['name'], 'L_POSTOR' => $LANG['postor'], 'L_VIEWS' => $LANG['views'], 'L_ADD_ON' => $LANG['add_on'], 'L_DIMENSION' => $LANG['dimension'], 'L_SIZE' => $LANG['size'], 'L_NOTE' => LangLoader::get_message('note', 'common'), 'L_COM' => $LANG['com'], 'L_EDIT' => LangLoader::get_message('edit', 'common'), 'L_APROB_IMG' => $info_pics['aprob'] == 1 ? $LANG['unaprob'] : $LANG['aprob'], 'L_THUMBNAILS' => $LANG['thumbnails'], 'U_DEL' => url('gallery.php?del=' . $info_pics['id'] . '&token=' . AppContext::get_session()->get_token() . '&cat=' . $category->get_id()), 'U_MOVE' => url('gallery.php?id=' . $info_pics['id'] . '&token=' . AppContext::get_session()->get_token() . '&move=\' + this.options[this.selectedIndex].value'), 'U_PREVIOUS' => $pos_pics > 0 ? '<a href="' . GalleryUrlBuilder::get_link_item($category->get_id(), $id_previous) . '#pics_max"><i class="fa fa-arrow-left fa-2x"></i></a> <a href="' . GalleryUrlBuilder::get_link_item($category->get_id(), $id_previous) . '#pics_max">' . $LANG['previous'] . '</a>' : '', 'U_NEXT' => $pos_pics < $i - 1 ? '<a href="' . GalleryUrlBuilder::get_link_item($category->get_id(), $id_next) . '#pics_max">' . $LANG['next'] . '</a> <a href="' . GalleryUrlBuilder::get_link_item($category->get_id(), $id_next) . '#pics_max"><i class="fa fa-arrow-right fa-2x"></i></a>' : '', 'U_LEFT_THUMBNAILS' => $pos_pics - $start_thumbnails > 0 ? '<span id="display_left"><a href="javascript:display_thumbnails(\'left\')"><i class="fa fa-arrow-left fa-2x"></i></a></span>' : '<span id="display_left"></span>', 'U_RIGHT_THUMBNAILS' => $pos_pics - $start_thumbnails <= $i - 1 - $nbr_column_pics ? '<span id="display_right"><a href="javascript:display_thumbnails(\'right\')"><i class="fa fa-arrow-right fa-2x"></i></a></span>' : '<span id="display_right"></span>', 'U_COMMENTS' => GalleryUrlBuilder::get_link_item($info_pics['idcat'], $info_pics['id'], 0, $g_sort) . '#comments-list', 'U_IMG_MAX' => 'show_pics.php?id=' . $info_pics['id'] . '&cat=' . $info_pics['idcat']));
//Affichage de la liste des miniatures sous l'image.
$i = 0;
foreach ($array_pics as $pics) {
if ($i >= $pos_pics - $start_thumbnails && $i <= $pos_pics + $end_thumbnails) {
$this->tpl->assign_block_vars('list_preview_pics', array('PICS' => $pics));
}
$i++;
}
//Commentaires
if (AppContext::get_request()->get_getint('com', 0) == 0 && $config->are_comments_enabled()) {
$this->tpl->put_all(array('COMMENTS' => CommentsService::display($comments_topic)->render()));
}
}
} else {
$sort = retrieve(GET, 'sort', '');
//On crée une pagination si le nombre de photos est trop important.
$page = AppContext::get_request()->get_getint('pp', 1);
$pagination = new ModulePagination($page, $nbr_pics, $config->get_pics_number_per_page());
$pagination->set_url(new Url('/gallery/gallery.php?pp=%d' . (!empty($sort) ? '&sort=' . $sort : '') . '&cat=' . $category->get_id()));
if ($pagination->current_page_is_empty() && $page > 1) {
$error_controller = PHPBoostErrors::unexisting_page();
DispatchManager::redirect($error_controller);
}
$this->tpl->put_all(array('C_GALLERY_MODO' => $is_modo, 'C_PICTURE_NAME_DISPLAYED' => $config->is_title_enabled(), 'C_AUTHOR_DISPLAYED' => $config->is_author_displayed(), 'C_VIEWS_COUNTER_ENABLED' => $config->is_views_counter_enabled(), 'C_COMMENTS_ENABLED' => $config->are_comments_enabled(), 'C_PAGINATION' => $pagination->has_several_pages(), 'PAGINATION' => $pagination->display(), 'L_EDIT' => LangLoader::get_message('edit', 'common'), 'L_VIEW' => $LANG['view'], 'L_VIEWS' => $LANG['views']));
$is_connected = AppContext::get_current_user()->check_level(User::MEMBER_LEVEL);
$j = 0;
$result = $this->db_querier->select("SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob, g.width, g.height, g.user_id, g.views, g.aprob, m.display_name, m.groups, m.level, notes.average_notes, notes.number_notes, note.note\n\t\t\t\tFROM " . GallerySetup::$gallery_table . " g\n\t\t\t\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = g.user_id\n\t\t\t\tLEFT JOIN " . DB_TABLE_COMMENTS_TOPIC . " com ON com.id_in_module = g.id AND com.module_id = 'gallery'\n\t\t\t\tLEFT JOIN " . DB_TABLE_AVERAGE_NOTES . " notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'\n\t\t\t\tLEFT JOIN " . DB_TABLE_NOTE . " note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = :user_id\n\t\t\t\tWHERE g.idcat = :idcat AND g.aprob = 1\n\t\t\t\t" . $g_sql_sort . "\n\t\t\t\tLIMIT :number_items_per_page OFFSET :display_from", array('user_id' => AppContext::get_current_user()->get_id(), 'idcat' => $category->get_id(), 'number_items_per_page' => $pagination->get_number_items_per_page(), 'display_from' => $pagination->get_display_from()));
while ($row = $result->fetch()) {
//Si la miniature n'existe pas (cache vidé) on regénère la miniature à partir de l'image en taille réelle.
if (!file_exists(PATH_TO_ROOT . '/gallery/pics/thumbnails/' . $row['path'])) {
$Gallery->Resize_pics(PATH_TO_ROOT . '/gallery/pics/' . $row['path']);
}
//Redimensionnement + création miniature
$onclick = '';
//Affichage de l'image en grand.
if ($config->get_pics_enlargement_mode() == GalleryConfig::FULL_SCREEN) {
$display_link = PATH_TO_ROOT . '/gallery/pics/' . $row['path'] . '" onmousedown="increment_view(' . $row['id'] . ');" title="' . str_replace('"', '', stripslashes($row['name']));
} elseif ($config->get_pics_enlargement_mode() == GalleryConfig::POPUP) {
$onclick = 'increment_view(' . $row['id'] . ');display_pics_popup(\'' . PATH_TO_ROOT . '/gallery/show_pics' . url('.php?id=' . $row['id'] . '&cat=' . $row['idcat']) . '\', \'' . $row['width'] . '\', \'' . $row['height'] . '\');return false;';
$display_link = '';
} elseif ($config->get_pics_enlargement_mode() == GalleryConfig::RESIZE) {
$onclick = 'increment_view(' . $row['id'] . ');display_pics(' . $row['id'] . ', \'' . PATH_TO_ROOT . '/gallery/show_pics' . url('.php?id=' . $row['id'] . '&cat=' . $row['idcat']) . '\');return false;';
$display_link = '';
} else {
$onclick = true;
$display_link = url('gallery.php?cat=' . $row['idcat'] . '&id=' . $row['id'], 'gallery-' . $row['idcat'] . '-' . $row['id'] . '.php') . '#pics_max';
}
//Liste des catégories.
$search_category_children_options = new SearchCategoryChildrensOptions();
$search_category_children_options->add_authorizations_bits(Category::READ_AUTHORIZATIONS);
$search_category_children_options->add_authorizations_bits(Category::WRITE_AUTHORIZATIONS);
$categories_tree = GalleryService::get_categories_manager()->get_select_categories_form_field($row['id'] . 'cat', '', $row['idcat'], $search_category_children_options);
$method = new ReflectionMethod('AbstractFormFieldChoice', 'get_options');
$method->setAccessible(true);
$categories_tree_options = $method->invoke($categories_tree);
$cat_list = '';
foreach ($categories_tree_options as $option) {
$cat_list .= $option->display()->render();
}
$notation = new Notation();
$notation->set_module_name('gallery');
$notation->set_notation_scale($config->get_notation_scale());
$notation->set_id_in_module($row['id']);
$notation->set_number_notes($row['number_notes']);
$notation->set_average_notes($row['average_notes']);
$notation->set_user_already_noted(!empty($row['note']));
$group_color = User::get_group_color($row['groups'], $row['level']);
$comments_topic->set_id_in_module($row['id']);
$html_protected_name = $row['name'];
$this->tpl->assign_block_vars('pics_list', array('C_IMG_APROB' => $row['aprob'] == 1, 'C_OPEN_TR' => is_int($j++ / $nbr_column_pics), 'C_CLOSE_TR' => is_int($j / $nbr_column_pics), 'ID' => $row['id'], 'APROB' => $row['aprob'], 'PATH' => $row['path'], 'NAME' => stripslashes($row['name']), 'SHORT_NAME' => TextHelper::wordwrap_html(stripslashes($row['name']), 22, ' '), 'POSTOR' => $LANG['by'] . (!empty($row['display_name']) ? ' <a class="small ' . UserService::get_level_class($row['level']) . '"' . (!empty($group_color) ? ' style="color:' . $group_color . '"' : '') . ' href="' . UserUrlBuilder::profile($row['user_id'])->rel() . '">' . $row['display_name'] . '</a>' : ' ' . $LANG['guest']), 'VIEWS' => $row['views'], 'L_VIEWS' => $row['views'] > 1 ? $LANG['views'] : $LANG['view'], 'L_COMMENTS' => CommentsService::get_number_and_lang_comments('gallery', $row['id']), 'KERNEL_NOTATION' => $config->is_notation_enabled() && $is_connected ? NotationService::display_active_image($notation) : NotationService::display_static_image($notation), 'CAT' => $cat_list, 'ONCLICK' => $onclick, 'RENAME' => $html_protected_name, 'RENAME_CUT' => $html_protected_name, 'L_APROB_IMG' => $row['aprob'] == 1 ? $LANG['unaprob'] : $LANG['aprob'], 'U_PICTURE_LINK' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?cat=' . $row['idcat'] . '&id=' . $row['id'], '-' . $row['idcat'] . '-' . $row['id'] . '.php'), 'U_PICTURE' => PATH_TO_ROOT . '/gallery/pics/thumbnails/' . $row['path'], 'U_DEL' => url('gallery.php?del=' . $row['id'] . '&token=' . AppContext::get_session()->get_token() . '&cat=' . $category->get_id()), 'U_MOVE' => url('gallery.php?id=' . $row['id'] . '&token=' . AppContext::get_session()->get_token() . '&move=\' + this.options[this.selectedIndex].value'), 'U_DISPLAY' => $display_link, 'U_COMMENTS' => PATH_TO_ROOT . '/gallery/gallery' . url('.php?cat=' . $row['idcat'] . '&id=' . $row['id'] . '&com=0', '-' . $row['idcat'] . '-' . $row['id'] . '.php?com=0') . '#comments-list'));
}
$result->dispose();
//Création des cellules du tableau si besoin est.
while (!is_int($j / $nbr_column_pics)) {
$this->tpl->assign_block_vars('end_table', array('TD_END' => '<td class="td-end" style="width:' . $column_width_pics . '%"> </td>', 'TR_END' => is_int(++$j / $nbr_column_pics) ? '</tr>' : ''));
}
}
}
}
<?php
require_once '../admin/admin_begin.php';
load_module_lang('articles');
define('TITLE', $LANG['administration']);
require_once '../admin/admin_header.php';
$idcat = retrieve(GET, 'idcat', 0);
define('READ_CAT_ARTICLES', 0x1);
define('WRITE_CAT_ARTICLES', 0x2);
define('EDIT_CAT_ARTICLES', 0x4);
if (!empty($_POST['add'])) {
$Cache->load('articles');
$parent_category = retrieve(POST, 'category', 0);
$name = retrieve(POST, 'name', '');
$contents = retrieve(POST, 'desc', '');
$icon = retrieve(POST, 'icon', '');
$aprob = retrieve(POST, 'aprob', 0);
$array_auth_all = Authorizations::build_auth_array_from_form(READ_CAT_ARTICLES);
if (!empty($name)) {
if (isset($CAT_ARTICLES[$parent_category])) {
$list_parent_cats = '';
$result = $Sql->query_while("SELECT id\n\t\t\tFROM " . PREFIX . "articles_cats \n\t\t\tWHERE id_left <= '" . $CAT_ARTICLES[$parent_category]['id_left'] . "' AND id_right >= '" . $CAT_ARTICLES[$parent_category]['id_right'] . "'", __LINE__, __FILE__);
while ($row = $Sql->fetch_assoc($result)) {
$list_parent_cats .= $row['id'] . ', ';
}
$Sql->query_close($result);
$list_parent_cats = trim($list_parent_cats, ', ');
if (empty($list_parent_cats)) {
$clause_parent = "id = '" . $parent_category . "'";
} else {
$clause_parent = "id IN (" . $list_parent_cats . ")";
<?php
require_once '../admin/admin_begin.php';
load_module_lang('gallery');
define('TITLE', $LANG['administration']);
require_once '../admin/admin_header.php';
$Cache->load('gallery');
include_once '../gallery/gallery.class.php';
$Gallery = new Gallery();
$idcat = !empty($_GET['cat']) ? numeric($_GET['cat']) : 0;
$idcat_post = !empty($_POST['idcat_post']) ? numeric($_POST['idcat_post']) : 0;
$add_pic = !empty($_GET['add']) ? numeric($_GET['add']) : 0;
$nbr_pics_post = !empty($_POST['nbr_pics']) ? numeric($_POST['nbr_pics']) : 0;
if (isset($_FILES['gallery']) && isset($_POST['idcat_post'])) {
$dir = 'pics/';
import('io/upload');
$Upload = new Upload($dir);
$idpic = 0;
if (is_writable($dir)) {
if ($_FILES['gallery']['size'] > 0) {
$Upload->file('gallery', '`([a-z0-9()_-])+\\.(jpg|gif|png)+$`i', UNIQ_NAME, $CONFIG_GALLERY['weight_max']);
if (!empty($Upload->error)) {
redirect(HOST . DIR . '/gallery/admin_gallery_add.php?error=' . $Upload->error . '#errorh');
} else {
$path = $dir . $Upload->filename['gallery'];
$error = $Upload->validate_img($path, $CONFIG_GALLERY['width_max'], $CONFIG_GALLERY['height_max'], DELETE_ON_ERROR);
if (!empty($error)) {
redirect(HOST . DIR . '/gallery/admin_gallery_add.php?error=' . $error . '#errorh');
} else {
$Gallery->Resize_pics($path);
if (!empty($Gallery->error)) {
function parse_search_result(&$result_data)
{
global $CONFIG, $LANG, $CONFIG_USER;
load_module_lang('forum');
$tpl = new Template('forum/forum_generic_results.tpl');
$tpl->assign_vars(array('L_ON' => $LANG['on'], 'L_TOPIC' => $LANG['topic']));
$rewrited_title = $CONFIG['rewrite'] == 1 ? '+' . url_encode_rewrite($result_data['title']) : '';
$tpl->assign_vars(array('USER_ONLINE' => '<img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . (!empty($result_data['connect']) && $result_data['user_id'] !== -1 ? 'online' : 'offline') . '.png" alt="" class="valign_middle" />', 'U_USER_PROFILE' => !empty($result_data['user_id']) ? PATH_TO_ROOT . '/member/member' . url('.php?id=' . $result_data['user_id'], '-' . $result_data['user_id'] . '.php') : '', 'USER_PSEUDO' => !empty($result_data['login']) ? wordwrap_html($result_data['login'], 13) : $LANG['guest'], 'U_TOPIC' => PATH_TO_ROOT . '/forum/topic' . url('.php?id=' . $result_data['topic_id'], '-' . $result_data['topic_id'] . $rewrited_title . '.php') . '#m' . $result_data['msg_id'], 'TITLE' => ucfirst($result_data['title']), 'DATE' => gmdate_format('d/m/y', $result_data['date']), 'CONTENTS' => second_parse($result_data['contents']), 'USER_AVATAR' => '<img src="' . ($CONFIG_USER['activ_avatar'] == '1' && !empty($result_data['avatar']) ? $result_data['avatar'] : PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . $CONFIG_USER['avatar_url']) . '" alt="" />'));
return $tpl->parse(TEMPLATE_STRING_MODE);
}
function shoutbox_mini($position, $block)
{
global $Cache, $LANG, $User, $CONFIG_SHOUTBOX, $nbr_members, $last_member_id, $last_member_login, $Sql;
if (strpos(SCRIPT, '/shoutbox/shoutbox.php') === false) {
load_module_lang('shoutbox');
$Cache->load('shoutbox');
###########################Insertion##############################
$shoutbox = retrieve(POST, 'shoutbox', false);
if ($shoutbox) {
if ($User->get_attribute('user_readonly') > time()) {
$Errorh->handler('e_readonly', E_USER_REDIRECT);
}
$shout_pseudo = substr(retrieve(POST, 'shout_pseudo', $LANG['guest']), 0, 25);
$shout_contents = retrieve(POST, 'shout_contents', '', TSTRING_UNCHANGE);
if (!empty($shout_pseudo) && !empty($shout_contents)) {
if ($User->check_level($CONFIG_SHOUTBOX['shoutbox_auth'])) {
$check_time = $User->get_attribute('user_id') !== -1 && $CONFIG['anti_flood'] == 1 ? $Sql->query("SELECT MAX(timestamp) as timestamp FROM " . PREFIX . "shoutbox WHERE user_id = '" . $User->get_attribute('user_id') . "'", __LINE__, __FILE__) : '';
if (!empty($check_time) && !$User->check_max_value(AUTH_FLOOD)) {
if ($check_time >= time() - $CONFIG['delay_flood']) {
redirect(HOST . DIR . '/shoutbox/shoutbox.php' . url('?error=flood', '', '&'));
}
}
$shout_contents = strparse($shout_contents, $CONFIG_SHOUTBOX['shoutbox_forbidden_tags']);
if (!check_nbr_links($shout_pseudo, 0)) {
redirect(HOST . DIR . '/shoutbox/shoutbox.php' . url('?error=lp_flood', '', '&'));
}
if (!check_nbr_links($shout_contents, $CONFIG_SHOUTBOX['shoutbox_max_link'])) {
redirect(HOST . DIR . '/shoutbox/shoutbox.php' . url('?error=l_flood', '', '&'));
}
$Sql->query_inject("INSERT INTO " . PREFIX . "shoutbox (login, user_id, level, contents, timestamp) VALUES ('" . $shout_pseudo . "', '" . $User->get_attribute('user_id') . "', '" . $User->get_attribute('level') . "', '" . $shout_contents . "', '" . time() . "')", __LINE__, __FILE__);
redirect(HOST . url(SCRIPT . '?' . QUERY_STRING, '', '&'));
} else {
redirect(HOST . DIR . '/shoutbox/shoutbox.php' . url('?error=auth', '', '&'));
}
}
}
###########################Affichage##############################
$tpl = new Template('shoutbox/shoutbox_mini.tpl');
import('core/menu_service');
MenuService::assign_positions_conditions($tpl, $block);
if ($User->get_attribute('user_id') !== -1) {
$tpl->assign_vars(array('SHOUTBOX_PSEUDO' => $User->get_attribute('login'), 'C_HIDDEN_SHOUT' => true));
} else {
$tpl->assign_vars(array('SHOUTBOX_PSEUDO' => $LANG['guest'], 'C_VISIBLE_SHOUT' => true));
}
$refresh_delay = empty($CONFIG_SHOUTBOX['shoutbox_refresh_delay']) ? 60 : $CONFIG_SHOUTBOX['shoutbox_refresh_delay'];
$tpl->assign_vars(array('SID' => SID, 'SHOUT_REFRESH_DELAY' => (int) max($refresh_delay, 0), 'L_ALERT_TEXT' => $LANG['require_text'], 'L_ALERT_UNAUTH_POST' => $LANG['e_unauthorized'], 'L_ALERT_FLOOD' => $LANG['e_flood'], 'L_ALERT_LINK_FLOOD' => sprintf($LANG['e_l_flood'], $CONFIG_SHOUTBOX['shoutbox_max_link']), 'L_ALERT_LINK_PSEUDO' => $LANG['e_link_pseudo'], 'L_ALERT_INCOMPLETE' => $LANG['e_incomplete'], 'L_ALERT_READONLY' => $LANG['e_readonly'], 'L_DELETE_MSG' => $LANG['alert_delete_msg'], 'L_SHOUTBOX' => $LANG['title_shoutbox'], 'L_MESSAGE' => $LANG['message'], 'L_PSEUDO' => $LANG['pseudo'], 'L_SUBMIT' => $LANG['submit'], 'L_REFRESH' => $LANG['refresh'], 'L_ARCHIVES' => $LANG['archives']));
$array_class = array('member', 'modo', 'admin');
$result = $Sql->query_while("SELECT id, login, user_id, level, contents\n \tFROM " . PREFIX . "shoutbox\n \tORDER BY timestamp DESC\n \t" . $Sql->limit(0, 25), __LINE__, __FILE__);
while ($row = $Sql->fetch_assoc($result)) {
$row['user_id'] = (int) $row['user_id'];
if ($User->check_level(MODO_LEVEL) || $row['user_id'] === $User->get_attribute('user_id') && $User->get_attribute('user_id') !== -1) {
$del_message = '<script type="text/javascript"><!--
document.write(\'<a href="javascript:Confirm_del_shout(' . $row['id'] . ');" title="' . $LANG['delete'] . '"><img src="' . TPL_PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/delete_mini.png" alt="" /></a>\');
--></script><ins><noscript><p><a href="' . TPL_PATH_TO_ROOT . '/shoutbox/shoutbox' . url('.php?del=true&id=' . $row['id']) . '"><img src="' . TPL_PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/delete_mini.png" alt="" /></a></p></noscript></ins>';
} else {
$del_message = '';
}
if ($row['user_id'] !== -1) {
$row['login'] = $del_message . ' <a style="font-size:10px;" class="' . $array_class[$row['level']] . '" href="' . TPL_PATH_TO_ROOT . '/member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '">' . (!empty($row['login']) ? wordwrap_html($row['login'], 16) : $LANG['guest']) . '</a>';
} else {
$row['login'] = $del_message . ' <span class="text_small" style="font-style: italic;">' . (!empty($row['login']) ? wordwrap_html($row['login'], 16) : $LANG['guest']) . '</span>';
}
$tpl->assign_block_vars('shout', array('IDMSG' => $row['id'], 'PSEUDO' => $row['login'], 'CONTENTS' => ucfirst(second_parse($row['contents']))));
}
$Sql->query_close($result);
return $tpl->parse(TEMPLATE_STRING_MODE);
}
return '';
}
function get_home_page()
{
global $Sql, $User, $Template, $Cache, $Bread_crumb, $_WIKI_CONFIG, $_WIKI_CATS, $LANG;
load_module_lang('wiki');
include_once '../wiki/wiki_functions.php';
$bread_crumb_key = 'wiki';
require_once '../wiki/wiki_bread_crumb.php';
unset($Template);
$Template = new Template();
$Template->set_filenames(array('wiki' => 'wiki/wiki.tpl', 'index' => 'wiki/index.tpl'));
$Template->assign_vars(array('WIKI_PATH' => $Template->get_module_data_path('wiki')));
if ($_WIKI_CONFIG['last_articles'] > 1) {
$result = $Sql->query_while("SELECT a.title, a.encoded_title, a.id\n\t\t\tFROM " . PREFIX . "wiki_articles a\n\t\t\tLEFT JOIN " . PREFIX . "wiki_contents c ON c.id_contents = a.id_contents\n\t\t\tWHERE a.redirect = 0\n\t\t\tORDER BY c.timestamp DESC\n\t\t\tLIMIT 0, " . $_WIKI_CONFIG['last_articles'], __LINE__, __FILE__);
$articles_number = $Sql->num_rows($result, "SELECT COUNT(*) FROM " . PREFIX . "wiki_articles WHERE encoded_title = '" . $encoded_title . "'", __LINE__, __FILE__);
$Template->assign_block_vars('last_articles', array('L_ARTICLES' => $LANG['wiki_last_articles_list'], 'RSS' => $articles_number > 0 ? '<a href="{PATH_TO_ROOT}/syndication.php?m=wiki"><img src="../templates/' . get_utheme() . '/images/rss.png" alt="RSS" /></a>' : ''));
$i = 0;
while ($row = $Sql->fetch_assoc($result)) {
$Template->assign_block_vars('last_articles.list', array('ARTICLE' => $row['title'], 'TR' => $i > 0 && $i % 2 == 0 ? '</tr><tr>' : '', 'U_ARTICLE' => url('wiki.php?title=' . $row['encoded_title'], $row['encoded_title'])));
$i++;
}
if ($articles_number == 0) {
$Template->assign_vars(array('L_NO_ARTICLE' => '<td style="text-align:center;" class="row2">' . $LANG['wiki_no_article'] . '</td>'));
}
}
if ($_WIKI_CONFIG['display_cats'] != 0) {
$Template->assign_block_vars('cat_list', array('L_CATS' => $LANG['wiki_cats_list']));
$i = 0;
foreach ($_WIKI_CATS as $id => $infos) {
if ($infos['id_parent'] == 0) {
$Template->assign_block_vars('cat_list.list', array('CAT' => $infos['name'], 'U_CAT' => url('wiki.php?title=' . url_encode_rewrite($infos['name']), url_encode_rewrite($infos['name']))));
$i++;
}
}
if ($i == 0) {
$Template->assign_vars(array('L_NO_CAT' => $LANG['wiki_no_cat']));
}
}
$Template->assign_vars(array('TITLE' => !empty($_WIKI_CONFIG['wiki_name']) ? $_WIKI_CONFIG['wiki_name'] : $LANG['wiki'], 'INDEX_TEXT' => !empty($_WIKI_CONFIG['index_text']) ? second_parse(wiki_no_rewrite($_WIKI_CONFIG['index_text'])) : $LANG['wiki_empty_index'], 'L_EXPLORER' => $LANG['wiki_explorer'], 'U_EXPLORER' => url('explorer.php'), 'WIKI_PATH' => $Template->get_module_data_path('wiki')));
$page_type = 'index';
include '../wiki/wiki_tools.php';
$tmp = $Template->pparse('wiki', TRUE);
return $tmp;
}
