public function listAction() { if (isset($this->params['searchfor'])) { if ($this->params['searchfor'] === 'id') { $this->params['id'] = $this->params['seachtext']; $this->readAction(); exit; } } $this->params['page_title'] = $this->params['members_list_text']; $str = View::render('depositors_table/sort', $this->params, true); $str .= View::render('depositors_table/table_header', $this->params, true); $api_params = @array('controller' => 'depositor', 'action' => 'list', 'sortby' => $this->params['sortby'], 'sortorder' => $this->params['sortorder'], 'state' => $this->params['state'], 'page' => $this->params['page'], 'perpage' => $this->params['perpage'], 'search' => $this->params['search'], 'searchfor' => $this->params['searchfor'], 'seachtext' => $this->params['seachtext']); try { $data = $this->_API->sendRequest($api_params); } catch (Exception $e) { #catch any exceptions and report the problem @ErrorHandling::APIException('depo:list', $data, $api_params, $e, $this->params); } if (!empty($data['result'])) { foreach ($data['result'] as $d) { $col = function (&$str, $params, $field) { $str .= View::render('depositors_table/column', $params, true); $str .= $field; $str .= View::render('depositors_table/column_end', $params, true); }; $str .= View::render('depositors_table/row', $this->params, true); $col($str, $this->params, urldecode($d['depositor no.'])); $col($str, $this->params, urldecode($d['name'])); $col($str, $this->params, urldecode($d['surname'])); $col($str, $this->params, urldecode($d['mobile'])); $col($str, $this->params, urldecode($d['email'])); $col($str, $this->params, urldecode($d['hours no.'])); $col($str, $this->params, urldecode($d['state'])); $this->params['depositor_id'] = $d['depositor no.']; $col($str, $this->params, View::render('depositors_table/button', $this->params, true)); #details button $str .= View::render('depositors_table/row_end', $this->params, true); } } else { $str .= View::render('depositors_table/nodata', $this->params, true); } $str .= View::render('depositors_table/table_footer', $this->params, true); if ($data['pages'] > 1) { $url = 'index.php?' . $_SERVER['QUERY_STRING'] . '&page=1'; $page_url = 'index.php?' . $_SERVER['QUERY_STRING'] . '&page='; if (empty($this->params['perpage'])) { $this->params['perpage'] = 20; } Pagination::set($this->params, $data['page'], $data['pages'], $this->params['perpage'], $url, $page_url); $str .= Pagination::display(); } $this->render($str); }
break; case 'last': $sort = 'last_connect'; break; case 'msg': $sort = 'user_msg'; break; case 'alph': $sort = 'login'; break; default: $sort = 'timestamp'; } $get_mode = retrieve(GET, 'mode', '', TSTRING_UNCHANGE); $mode = $get_mode == 'asc' ? 'ASC' : 'DESC'; $unget = !empty($sort) && !empty($mode) ? '?sort=' . $get_sort . '&mode=' . $get_mode : ''; import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('PAGINATION' => ' <strong>' . $LANG['page'] . ' :</strong> ' . $Pagination->display('member' . url('.php' . (!empty($unget) ? $unget . '&' : '?') . 'p=%d', '-0-%d.php' . $unget), $nbr_member, 'p', 25, 3))); $result = $Sql->query_while("SELECT user_id, login, user_mail, user_show_mail, timestamp, user_msg, user_local, user_web, last_connect\n\tFROM " . PREFIX . "member\n\tWHERE user_aprob = 1\n\tORDER BY " . $sort . " " . $mode . $Sql->limit($Pagination->get_first_msg(25, 'p'), 25), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $user_web = !empty($row['user_web']) ? '<a href="' . $row['user_web'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/user_web.png" alt="' . $row['user_web'] . '" title="' . $row['user_web'] . '" /></a>' : ' '; $user_msg = !empty($row['user_msg']) ? $row['user_msg'] : '0'; $user_mail = $row['user_show_mail'] == 1 ? '<a href="mailto:' . $row['user_mail'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/email.png" alt="' . $row['user_mail'] . '" /></a>' : ' '; $row['last_connect'] = !empty($row['last_connect']) ? $row['last_connect'] : $row['timestamp']; $Template->assign_block_vars('member_list', array('PSEUDO' => $row['login'], 'MAIL' => $user_mail, 'MSG' => $user_msg, 'LOCAL' => !empty($row['user_local']) ? $row['user_local'] : ' ', 'LAST_CONNECT' => gmdate_format('date_format_short', $row['last_connect']), 'WEB' => $user_web, 'DATE' => gmdate_format('date_format_short', $row['timestamp']), 'U_USER_ID' => url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php'), 'U_USER_PM' => url('.php?pm=' . $row['user_id'], '-' . $row['user_id'] . '.php'))); } $Sql->query_close($result); $Template->pparse('member'); } require_once '../kernel/footer.php';
$img_announce .= $row['type'] == '1' ? '_post' : ''; $img_announce .= $row['type'] == '2' ? '_top' : ''; $img_announce .= $row['status'] == '0' && $row['type'] == '0' ? '_lock' : ''; if (!empty($row['last_view_id'])) { $last_msg_id = $row['last_view_id']; $last_page = 'idm=' . $row['last_view_id'] . '&'; $last_page_rewrite = '-0-' . $row['last_view_id']; } else { $last_msg_id = $row['last_msg_id']; $last_page = ceil($row['nbr_msg'] / $CONFIG_FORUM['pagination_msg']); $last_page_rewrite = $last_page > 1 ? '-' . $last_page : ''; $last_page = $last_page > 1 ? 'pt=' . $last_page . '&' : ''; } $rewrited_title = $CONFIG['rewrite'] == 1 ? '+' . url_encode_rewrite($row['title']) : ''; $last_msg = '<a href="topic' . url('.php?' . $last_page . 'id=' . $row['id'], '-' . $row['id'] . $last_page_rewrite . $rewrited_title . '.php') . '#m' . $last_msg_id . '" title=""><img src="../templates/' . get_utheme() . '/images/ancre.png" alt="" /></a>' . ' ' . $LANG['on'] . ' ' . gmdate_format('date_format', $row['last_timestamp']) . '<br /> ' . $LANG['by'] . ' ' . (!empty($row['last_login']) ? '<a class="small_link" href="../member/member' . url('.php?id=' . $row['last_user_id'], '-' . $row['last_user_id'] . '.php') . '">' . wordwrap_html($row['last_login'], 13) . '</a>' : '<em>' . $LANG['guest'] . '</em>'); $new_ancre = '<a href="topic' . url('.php?' . $last_page . 'id=' . $row['id'], '-' . $row['id'] . $last_page_rewrite . $rewrited_title . '.php') . '#m' . $last_msg_id . '" title=""><img src="../templates/' . get_utheme() . '/images/ancre.png" alt="" /></a>'; $Template->assign_block_vars('topics', array('C_IMG_POLL' => !empty($row['question']), 'C_IMG_TRACK' => !empty($row['idtrack']), 'C_DISPLAY_MSG' => $CONFIG_FORUM['activ_display_msg'] && $CONFIG_FORUM['icon_activ_display_msg'] && $row['display_msg'], 'C_HOT_TOPIC' => $row['type'] == '0' && $row['status'] != '0' && $row['nbr_msg'] > $CONFIG_FORUM['pagination_msg'], 'IMG_ANNOUNCE' => $img_announce, 'ANCRE' => $new_ancre, 'TYPE' => $type[$row['type']], 'TITLE' => ucfirst($row['title']), 'AUTHOR' => !empty($row['login']) ? '<a href="../member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '" class="small_link">' . $row['login'] . '</a>' : '<em>' . $LANG['guest'] . '</em>', 'DESC' => $row['subtitle'], 'PAGINATION_TOPICS' => $Pagination->display('topic' . url('.php?id=' . $row['id'] . '&pt=%d', '-' . $row['id'] . '-%d.php'), $row['nbr_msg'], 'pt', $CONFIG_FORUM['pagination_msg'], 2, 10, false), 'MSG' => $row['nbr_msg'] - 1, 'VUS' => $row['nbr_views'], 'U_TOPIC_VARS' => url('.php?id=' . $row['id'], '-' . $row['id'] . $rewrited_title . '.php'), 'U_LAST_MSG' => $last_msg, 'L_DISPLAY_MSG' => $CONFIG_FORUM['activ_display_msg'] && $row['display_msg'] ? $CONFIG_FORUM['display_msg'] : '')); } $Sql->query_close($result); $nbr_topics = $Sql->query("SELECT COUNT(*)\n\tFROM " . PREFIX . "forum_view v\n\tLEFT JOIN " . PREFIX . "forum_topics t ON t.id = v.idtopic\n\tWHERE t.last_timestamp >= '" . $max_time . "' AND v.user_id = '" . $User->get_attribute('user_id') . "'", __LINE__, __FILE__); if ($nbr_topics == 0) { $Template->assign_vars(array('C_NO_TOPICS' => true, 'L_NO_TOPICS' => '0 ' . $LANG['no_last_read'])); } $Template->assign_vars(array('FORUM_NAME' => $CONFIG_FORUM['forum_name'], 'SID' => SID, 'MODULE_DATA_PATH' => $Template->get_module_data_path('forum'), 'PAGINATION' => $Pagination->display('lastread' . url('.php?p=%d'), $nbr_topics, 'p', $CONFIG_FORUM['pagination_topic'], 3), 'LANG' => get_ulang(), 'U_CHANGE_CAT' => 'unread.php' . SID . '&token=' . $Session->get_token(), 'U_ONCHANGE' => url(".php?id=' + this.options[this.selectedIndex].value + '", "-' + this.options[this.selectedIndex].value + '.php"), 'U_ONCHANGE_CAT' => url("index.php?id=' + this.options[this.selectedIndex].value + '", "cat-' + this.options[this.selectedIndex].value + '.php"), 'U_FORUM_CAT' => '<a href="../forum/lastread.php' . SID . '">' . $LANG['show_last_read'] . '</a>', 'U_POST_NEW_SUBJECT' => '', 'L_FORUM_INDEX' => $LANG['forum_index'], 'L_FORUM' => $LANG['forum'], 'L_AUTHOR' => $LANG['author'], 'L_TOPIC' => $nbr_topics > 1 ? $LANG['topic_s'] : $LANG['topic'], 'L_MESSAGE' => $LANG['replies'], 'L_ANSWERS' => $LANG['answers'], 'L_VIEW' => $LANG['views'], 'L_LAST_MESSAGE' => $LANG['last_message'])); list($users_list, $total_admin, $total_modo, $total_member, $total_visit, $total_online) = forum_list_user_online("AND s.session_script = '/forum/lastread.php'"); $Template->assign_vars(array('TOTAL_ONLINE' => $total_online, 'USERS_ONLINE' => $total_online - $total_visit == 0 ? '<em>' . $LANG['no_member_online'] . '</em>' : $users_list, 'ADMIN' => $total_admin, 'MODO' => $total_modo, 'MEMBER' => $total_member, 'GUEST' => $total_visit, 'SELECT_CAT' => forum_list_cat(0, 0), 'L_USER' => $total_online > 1 ? $LANG['user_s'] : $LANG['user'], 'L_ADMIN' => $total_admin > 1 ? $LANG['admin_s'] : $LANG['admin'], 'L_MODO' => $total_modo > 1 ? $LANG['modo_s'] : $LANG['modo'], 'L_MEMBER' => $total_member > 1 ? $LANG['member_s'] : $LANG['member'], 'L_GUEST' => $total_visit > 1 ? $LANG['guest_s'] : $LANG['guest'], 'L_AND' => $LANG['and'], 'L_ONLINE' => strtolower($LANG['online']))); $Template->pparse('forum_topics'); } else { redirect(HOST . DIR . '/forum/index.php' . SID2); } include '../kernel/footer.php';
} import('util/pagination'); $Pagination = new Pagination(); $i = 0; $forum_cats = ''; foreach ($Bread_crumb->array_links as $key => $array) { if ($i == 2) { $forum_cats .= '<a href="' . $array[1] . '">' . $array[0] . '</a>'; } elseif ($i > 2) { $forum_cats .= ' » <a href="' . $array[1] . '">' . $array[0] . '</a>'; } $i++; } $check_group_edit_auth = $User->check_auth($CAT_FORUM[$id_get]['auth'], EDIT_CAT_FORUM); $nbr_topic = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "forum_topics WHERE idcat = '" . $id_get . "'", __LINE__, __FILE__); $Template->assign_vars(array('FORUM_NAME' => $CONFIG_FORUM['forum_name'], 'SID' => SID, 'MODULE_DATA_PATH' => $Template->get_module_data_path('forum'), 'PAGINATION' => $Pagination->display('forum' . url('.php?id=' . $id_get . '&p=%d', '-' . $id_get . '-%d.php'), $nbr_topic, 'p', $CONFIG_FORUM['pagination_topic'], 3), 'IDCAT' => $id_get, 'C_MASS_MODO_CHECK' => false, 'C_POST_NEW_SUBJECT' => $check_group_write_auth && !$locked_cat, 'U_MSG_SET_VIEW' => '<a class="small_link" href="../forum/action' . url('.php?read=1&f=' . $id_get, '') . '" title="' . $LANG['mark_as_read'] . '" onclick="javascript:return Confirm_read_topics();">' . $LANG['mark_as_read'] . '</a>', 'U_CHANGE_CAT' => 'forum' . url('.php?id=' . $id_get . '&token=' . $Session->get_token(), '-' . $id_get . $rewrited_title . '.php?token=' . $Session->get_token()), 'U_ONCHANGE' => url(".php?id=' + this.options[this.selectedIndex].value + '", "-' + this.options[this.selectedIndex].value + '.php"), 'U_ONCHANGE_CAT' => url("index.php?id=' + this.options[this.selectedIndex].value + '", "cat-' + this.options[this.selectedIndex].value + '.php"), 'U_FORUM_CAT' => $forum_cats, 'U_POST_NEW_SUBJECT' => 'post' . url('.php?new=topic&id=' . $id_get, ''), 'L_FORUM_INDEX' => $LANG['forum_index'], 'L_SUBFORUMS' => $LANG['sub_forums'], 'L_DISPLAY_UNREAD_MSG' => $LANG['show_not_reads'], 'L_FORUM' => $LANG['forum'], 'L_AUTHOR' => $LANG['author'], 'L_TOPIC' => $LANG['topic_s'], 'L_ANSWERS' => $LANG['replies'], 'L_MESSAGE' => $LANG['message_s'], 'L_VIEW' => $LANG['views'], 'L_LAST_MESSAGE' => $LANG['last_messages'], 'L_POST_NEW_SUBJECT' => $LANG['post_new_subject'], 'L_FOR_SELECTION' => $LANG['for_selection'], 'L_CHANGE_STATUT_TO' => sprintf($LANG['change_status_to'], $CONFIG_FORUM['display_msg']), 'L_CHANGE_STATUT_TO_DEFAULT' => $LANG['change_status_to_default'], 'L_MOVE_TO' => $LANG['move_to'], 'L_DELETE' => $LANG['delete'], 'L_LOCK' => $LANG['forum_lock'], 'L_UNLOCK' => $LANG['forum_unlock'], 'L_GO' => $LANG['go'])); $nbr_topics_display = 0; $result = $Sql->query_while("SELECT m1.login AS login, m2.login AS last_login, t.id, t.title, t.subtitle, t.user_id, t.nbr_msg, t.nbr_views, t.last_user_id , t.last_msg_id, t.last_timestamp, t.type, t.status, t.display_msg, v.last_view_id, p.question, tr.id AS idtrack\n\tFROM " . PREFIX . "forum_topics t\n\tLEFT JOIN " . PREFIX . "forum_view v ON v.user_id = '" . $User->get_attribute('user_id') . "' AND v.idtopic = t.id\n\tLEFT JOIN " . DB_TABLE_MEMBER . " m1 ON m1.user_id = t.user_id\n\tLEFT JOIN " . DB_TABLE_MEMBER . " m2 ON m2.user_id = t.last_user_id\n\tLEFT JOIN " . PREFIX . "forum_poll p ON p.idtopic = t.id\n\tLEFT JOIN " . PREFIX . "forum_track tr ON tr.idtopic = t.id AND tr.user_id = '" . $User->get_attribute('user_id') . "'\n\tWHERE t.idcat = '" . $id_get . "'\n\tORDER BY t.type DESC , t.last_timestamp DESC\n\t" . $Sql->limit($Pagination->get_first_msg($CONFIG_FORUM['pagination_topic'], 'p'), $CONFIG_FORUM['pagination_topic']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $type = array('2' => $LANG['forum_announce'] . ':', '1' => $LANG['forum_postit'] . ':', '0' => ''); $img_announce = 'announce'; $new_msg = false; if (!$is_guest) { $new_msg = false; if ($row['last_view_id'] != $row['last_msg_id'] && $row['last_timestamp'] >= $max_time_msg) { $img_announce = 'new_' . $img_announce; $new_msg = true; } } $img_announce .= $row['type'] == '1' ? '_post' : ''; $img_announce .= $row['type'] == '2' ? '_top' : '';
if (!in_array($criteria, array('entitled', 'module', 'status', 'creation_date', 'fixing_date', 'poster_id', 'fixer_id'))) { $criteria = 'current_status'; } $order = $order == 'desc' ? 'desc' : 'asc'; foreach (ContributionService::get_all_contributions($criteria, $order) as $this_contribution) { $creation_date = $this_contribution->get_creation_date(); $fixing_date = $this_contribution->get_fixing_date(); if ($User->check_auth($this_contribution->get_auth(), CONTRIBUTION_AUTH_BIT) || $User->get_attribute('user_id') == $this_contribution->get_poster_id()) { if ($num_contributions > CONTRIBUTIONS_PER_PAGE * ($pagination->get_current_page() - 1) && $num_contributions <= CONTRIBUTIONS_PER_PAGE * $pagination->get_current_page()) { $template->assign_block_vars('contributions', array('ENTITLED' => $this_contribution->get_entitled(), 'MODULE' => $this_contribution->get_module_name(), 'STATUS' => $this_contribution->get_status_name(), 'CREATION_DATE' => $creation_date->format(DATE_FORMAT_SHORT), 'FIXING_DATE' => $fixing_date->format(DATE_FORMAT_SHORT), 'POSTER' => $this_contribution->get_poster_login(), 'FIXER' => $this_contribution->get_fixer_login(), 'ACTIONS' => '', 'U_FIXER_PROFILE' => PATH_TO_ROOT . '/member/' . url('member.php?id=' . $this_contribution->get_fixer_id(), 'member-' . $this_contribution->get_fixer_id() . '.php'), 'U_POSTER_PROFILE' => PATH_TO_ROOT . '/member/' . url('member.php?id=' . $this_contribution->get_poster_id(), 'member-' . $this_contribution->get_poster_id() . '.php'), 'U_CONSULT' => PATH_TO_ROOT . '/member/' . url('contribution_panel.php?id=' . $this_contribution->get_id()), 'C_FIXED' => $this_contribution->get_status() == EVENT_STATUS_PROCESSED, 'C_PROCESSING' => $this_contribution->get_status() == EVENT_STATUS_BEING_PROCESSED)); } $num_contributions++; } } if ($num_contributions > 1) { $template->assign_vars(array('PAGINATION' => $pagination->display('contribution_panel.php?p=%d&criteria=' . $criteria . '&order=' . $order, $num_contributions - 1, 'p', CONTRIBUTIONS_PER_PAGE, 3))); } else { $template->assign_vars(array('C_NO_CONTRIBUTION' => true, 'L_NO_CONTRIBUTION_TO_DISPLAY' => $LANG['no_contribution'])); } define('NUMBER_OF_MODULES_PER_LINE', 4); $i_module = 0; foreach ($MODULES as $module_name => $module_infos) { $module_ini = load_ini_file(PATH_TO_ROOT . '/' . $module_name . '/lang/', get_ulang()); if (!empty($module_ini['contribution_interface'])) { if ($i_module % NUMBER_OF_MODULES_PER_LINE == 0) { $template->assign_block_vars('row', array()); } $template->assign_block_vars('row.module', array('WIDTH' => (int) (100.0 / NUMBER_OF_MODULES_PER_LINE), 'U_MODULE_LINK' => PATH_TO_ROOT . '/' . $module_name . '/' . url($module_ini['contribution_interface']), 'MODULE_ID' => $module_name, 'MODULE_NAME' => $module_ini['name'], 'LINK_TITLE' => sprintf($LANG['contribute_in_module_name'], $module_ini['name']))); $i_module++; } }
case 'alph': $sort = 'login'; break; case 'rank': $sort = 'level'; break; case 'aprob': $sort = 'user_aprob'; break; default: $sort = 'timestamp'; } $get_mode = retrieve(GET, 'mode', ''); $mode = $get_mode == 'asc' ? 'ASC' : 'DESC'; $unget = !empty($get_sort) && !empty($mode) ? '&sort=' . $get_sort . '&mode=' . $get_mode : ''; $Template->assign_vars(array('PAGINATION' => $Pagination->display('admin_members.php?p=%d' . $unget, $nbr_membre, 'p', 25, 3), 'THEME' => get_utheme(), 'LANG' => get_ulang(), 'KERNEL_EDITOR' => display_editor(), 'L_REQUIRE_MAIL' => $LANG['require_mail'], 'L_REQUIRE_PASS' => $LANG['require_pass'], 'L_REQUIRE_RANK' => $LANG['require_rank'], 'L_REQUIRE_LOGIN' => $LANG['require_pseudo'], 'L_REQUIRE_TEXT' => $LANG['require_text'], 'L_CONFIRM_DEL_USER' => $LANG['confirm_del_member'], 'L_CONFIRM_DEL_ADMIN' => $LANG['confirm_del_admin'], 'L_CONTENTS' => $LANG['content'], 'L_SUBMIT' => $LANG['submit'], 'L_UPDATE' => $LANG['update'], 'L_USERS_MANAGEMENT' => $LANG['members_management'], 'L_USERS_ADD' => $LANG['members_add'], 'L_USERS_CONFIG' => $LANG['members_config'], 'L_USERS_PUNISHMENT' => $LANG['members_punishment'], 'L_PSEUDO' => $LANG['pseudo'], 'L_PASSWORD' => $LANG['password'], 'L_MAIL' => $LANG['mail'], 'L_RANK' => $LANG['rank'], 'L_APROB' => $LANG['aprob'], 'L_USER' => $LANG['member'], 'L_MODO' => $LANG['modo'], 'L_ADMIN' => $LANG['admin'], 'L_SEARCH_USER' => $LANG['search_member'], 'L_JOKER' => $LANG['joker'], 'L_SEARCH' => $LANG['search'], 'L_WEBSITE' => $LANG['website'], 'L_REGISTERED' => $LANG['registered'], 'L_DELETE' => $LANG['delete'])); $result = $Sql->query_while("SELECT login, user_id, user_mail, timestamp, user_web, level, user_aprob\n\tFROM " . DB_TABLE_MEMBER . " \n\tORDER BY " . $sort . " " . $mode . $Sql->limit($Pagination->get_first_msg(25, 'p'), 25), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { switch ($row['level']) { case 0: $rank = $LANG['member']; break; case 1: $rank = $LANG['modo']; break; case 2: $rank = $LANG['admin']; break; default: 0; }
$Gallery->Resize_pics('pics/' . $row['path']); } $Template->assign_block_vars('cat.list', array('IDCAT' => $row['id'], 'CAT' => $row['name'], 'IMG' => '<img src="pics/thumbnails/' . $row['path'] . '" alt="" />', 'TR_START' => $tr_start, 'TR_END' => $tr_end, 'LOCK' => $row['status'] == 0 ? '<img class="valign_middle" src="../templates/' . get_utheme() . '/images/readonly.png" alt="" title="' . $LANG['gallery_lock'] . '" />' : '', 'L_NBR_PICS' => sprintf($LANG['nbr_pics_info_admin'], $row['nbr_pics'], $row['nbr_pics_unaprob']))); } $Sql->query_close($result); while (!is_int($i / $nbr_column_cats)) { $i++; $Template->assign_block_vars('cat.end_td', array('TD_END' => '<td class="row2" style="width:' . $column_width_cats . '%"> </td>', 'TR_END' => is_int($i / $nbr_column_cats) ? '</tr>' : '')); } } ##### Affichage des photos ##### if ($nbr_pics > 0) { $Template->assign_block_vars('pics', array('EDIT' => '<a href="admin_gallery_cat.php' . (!empty($idcat) ? '?id=' . $idcat : '') . '"><img class="valign_middle" src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/edit.png" alt="" /></a>', 'PICS_MAX' => !empty($idpics) ? '<img src="show_pics.php?id=' . $idpics . '&cat=' . $idcat . '" alt="" / >' : '')); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('PAGINATION_PICS' => $Pagination->display('admin_gallery.php?cat=' . $idcat . '&pp=%d', $nbr_pics, 'pp', $CONFIG_GALLERY['nbr_pics_max'], 3))); $array_cat_list = array(0 => '<option value="0" %s>' . $LANG['root'] . '</option>'); $result = $Sql->query_while("SELECT id, level, name \n\t\tFROM " . PREFIX . "gallery_cats\n\t\tORDER BY id_left", __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $margin = $row['level'] > 0 ? str_repeat('--------', $row['level']) : '--'; $array_cat_list[$row['id']] = '<option value="' . $row['id'] . '" %s>' . $margin . ' ' . $row['name'] . '</option>'; } $Sql->query_close($result); if (!empty($idpics)) { $result = $Sql->query_while("SELECT g.id, g.idcat, g.name, g.user_id, g.views, g.width, g.height, g.weight, g.timestamp, g.note, g.nbrnote, g.nbr_com, g.aprob, m.login\n\t\t\tFROM " . PREFIX . "gallery g\n\t\t\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = g.user_id\t\t\n\t\t\tWHERE g.idcat = '" . $idcat . "' AND g.id = '" . $idpics . "'\n\t\t\t" . $Sql->limit(0, 1), __LINE__, __FILE__); $info_pics = $Sql->fetch_assoc($result); if (!empty($info_pics['id'])) { $id_previous = 0; $id_next = 0; $nbr_pics_display_before = floor(($nbr_column_pics - 1) / 2); $nbr_pics_display_after = $nbr_column_pics - 1 - floor($nbr_pics_display_before);
$i = 0; $array_poll = array_combine($array_answer, $array_vote); foreach ($array_poll as $answer => $nbrvote) { $percent = number_round($nbrvote * 100 / $sum_vote, 1); $Template->assign_block_vars('answers', array('ID' => $i, 'ANSWER' => !empty($answer) ? $answer : '')); $Template->assign_block_vars('votes', array('ID' => $i, 'VOTES' => isset($nbrvote) ? $nbrvote : '', 'PERCENT' => isset($percent) ? $percent . '%' : '')); $i++; } $Template->assign_vars(array('MAX_ID' => $i)); $Template->pparse('admin_poll_management2'); } else { $Template->set_filenames(array('admin_poll_management' => 'poll/admin_poll_management.tpl')); $nbr_poll = $Sql->count_table('poll', __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('PAGINATION' => $Pagination->display('admin_poll.php?p=%d', $nbr_poll, 'p', 20, 3), 'LANG' => get_ulang(), 'L_CONFIRM_ERASE_POOL' => $LANG['confirm_del_poll'], 'L_POLL_MANAGEMENT' => $LANG['poll_management'], 'L_POLL_ADD' => $LANG['poll_add'], 'L_POLL_CONFIG' => $LANG['poll_config'], 'L_REQUIRE' => $LANG['require'], 'L_QUESTION' => $LANG['question'], 'L_POLLS' => $LANG['polls'], 'L_DATE' => $LANG['date'], 'L_ARCHIVED' => $LANG['archived'], 'L_PSEUDO' => $LANG['pseudo'], 'L_APROB' => $LANG['aprob'], 'L_UPDATE' => $LANG['update'], 'L_DELETE' => $LANG['delete'], 'L_SHOW' => $LANG['show'])); $result = $Sql->query_while("SELECT p.id, p.question, p.archive, p.timestamp, p.visible, p.start, p.end, m.login \n\tFROM " . PREFIX . "poll p\n\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON p.user_id = m.user_id\t\n\tORDER BY p.timestamp DESC \n\t" . $Sql->limit($Pagination->get_first_msg(20, 'p'), 20), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { if ($row['visible'] == 2) { $aprob = $LANG['waiting']; } elseif ($row['visible'] == 1) { $aprob = $LANG['yes']; } else { $aprob = $LANG['no']; } $archive = $row['archive'] == 1 ? $LANG['yes'] : $LANG['no']; $question = strlen($row['question']) > 45 ? substr($row['question'], 0, 45) . '...' : $row['question']; $visible = ''; if ($row['start'] > 0) { $visible .= gmdate_format('date_format_short', $row['start']); }
$mode = $get_mode == 'asc' ? 'ASC' : 'DESC'; $unget = !empty($get_sort) && !empty($mode) ? '?sort=' . $get_sort . '&mode=' . $get_mode : ''; import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('PAGINATION' => $Pagination->display('web' . url('.php' . (!empty($unget) ? $unget . '&' : '?') . 'cat=' . $idcat . '&p=%d', '-' . $idcat . '-0-%d.php' . (!empty($unget) ? '?' . $unget : '')), $nbr_web, 'p', $CONFIG_WEB['nbr_web_max'], 3))); import('content/note'); $result = $Sql->query_while("SELECT id, title, timestamp, compt, note, nbrnote, nbr_com\n\tFROM " . PREFIX . "web\n\tWHERE aprob = 1 AND idcat = '" . $idcat . "'\n\tORDER BY " . $sort . " " . $mode . $Sql->limit($Pagination->get_first_msg($CONFIG_WEB['nbr_web_max'], 'p'), $CONFIG_WEB['nbr_web_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $row['title'] = strlen($row['title']) > 45 ? substr(html_entity_decode($row['title'], ENT_COMPAT, 'ISO-8859-1'), 0, 45) . '...' : $row['title']; $Template->assign_block_vars('web', array('NAME' => $row['title'], 'CAT' => $CAT_WEB[$idcat]['name'], 'DATE' => gmdate_format('date_format_short', $row['timestamp']), 'COMPT' => $row['compt'], 'NOTE' => $row['nbrnote'] > 0 ? Note::display_img($row['note'], $CONFIG_WEB['note_max']) : '<em>' . $LANG['no_note'] . '</em>', 'COM' => $row['nbr_com'], 'U_WEB_LINK' => url('.php?cat=' . $idcat . '&id=' . $row['id'], '-' . $idcat . '-' . $row['id'] . '.php'))); } $Sql->query_close($result); $Template->pparse('web'); } else { $Template->set_filenames(array('web' => 'web/web.tpl')); $total_link = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "web_cat wc\n\tLEFT JOIN " . PREFIX . "web w ON w.idcat = wc.id\n\tWHERE w.aprob = 1 AND wc.aprob = 1 AND wc.secure <= '" . $User->get_attribute('level') . "'", __LINE__, __FILE__); $total_cat = $Sql->query("SELECT COUNT(*) as compt FROM " . PREFIX . "web_cat WHERE aprob = 1 AND secure <= '" . $User->get_attribute('level') . "'", __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $CONFIG_WEB['nbr_column'] = $total_cat > $CONFIG_WEB['nbr_column'] ? $CONFIG_WEB['nbr_column'] : $total_cat; $CONFIG_WEB['nbr_column'] = !empty($CONFIG_WEB['nbr_column']) ? $CONFIG_WEB['nbr_column'] : 1; $Template->assign_vars(array('C_WEB_CAT' => true, 'C_IS_ADMIN' => $User->check_level(ADMIN_LEVEL), 'PAGINATION' => $Pagination->display('web' . url('.php?p=%d', '-0-0-%d.php'), $total_cat, 'p', $CONFIG_WEB['nbr_cat_max'], 3), 'TOTAL_FILE' => $total_link, 'L_CATEGORIES' => $LANG['categories'], 'L_PROPOSE_LINK' => $LANG['propose_link'], 'L_HOW_LINK' => $LANG['how_link'], 'U_WEB_ADD' => url('.php?web=true'))); $column_width = floor(100 / $CONFIG_WEB['nbr_column']); $result = $Sql->query_while("SELECT aw.id, aw.name, aw.contents, aw.icon, COUNT(w.id) as count\n\tFROM " . PREFIX . "web_cat aw\n\tLEFT JOIN " . PREFIX . "web w ON w.idcat = aw.id AND w.aprob = 1\n\tWHERE aw.aprob = 1 AND aw.secure <= '" . $User->get_attribute('level') . "'\n\tGROUP BY aw.id\n\tORDER BY aw.class\n\t" . $Sql->limit($Pagination->get_first_msg($CONFIG_WEB['nbr_cat_max'], 'p'), $CONFIG_WEB['nbr_cat_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $Template->assign_block_vars('cat_list', array('WIDTH' => $column_width, 'TOTAL' => $row['count'], 'CAT' => $row['name'], 'CONTENTS' => $row['contents'], 'U_IMG_CAT' => !empty($row['icon']) ? '<a href="../web/web' . url('.php?cat=' . $row['id'], '-' . $row['id'] . '.php') . '"><img src="' . $row['icon'] . '" alt="" /></a><br />' : '', 'U_WEB_CAT' => url('.php?cat=' . $row['id'], '-' . $row['id'] . '.php'))); } $Sql->query_close($result); $Template->pparse('web'); } require_once '../kernel/footer.php';
$Template->assign_vars(array('C_GALLERY_PICS_MAX' => true, 'C_GALLERY_PICS_MODO' => $is_modo ? true : false, 'ID' => $info_pics['id'], 'IMG_MAX' => '<img src="show_pics' . url('.php?id=' . $g_idpics . '&cat=' . $g_idcat) . '" alt="" />', 'NAME' => '<span id="fi_' . $info_pics['id'] . '">' . $info_pics['name'] . '</span> <span id="fi' . $info_pics['id'] . '"></span>', 'POSTOR' => '<a class="small_link" href="../member/member' . url('.php?id=' . $info_pics['user_id'], '-' . $info_pics['user_id'] . '.php') . '">' . $info_pics['login'] . '</a>', 'DATE' => gmdate_format('date_format_short', $info_pics['timestamp']), 'VIEWS' => $info_pics['views'] + 1, 'DIMENSION' => $info_pics['width'] . ' x ' . $info_pics['height'], 'SIZE' => number_round($info_pics['weight'] / 1024, 1), 'COM' => Comments::com_display_link($info_pics['nbr_com'], '../gallery/gallery' . url('.php?cat=' . $info_pics['idcat'] . '&id=' . $info_pics['id'] . '&com=0&sort=' . $g_sort, '-' . $info_pics['idcat'] . '-' . $info_pics['id'] . '.php?com=0&sort=' . $g_sort), $info_pics['id'], 'gallery'), 'KERNEL_NOTATION' => $activ_note ? $Note->display_form() : '', 'COLSPAN' => $CONFIG_GALLERY['nbr_column'] + 2, 'CAT' => $cat_list, 'RENAME' => $html_protected_name, 'RENAME_CUT' => $html_protected_name, 'IMG_APROB' => get_ulang() . '/' . ($info_pics['aprob'] == 1 ? 'unvisible.png' : 'visible.png'), '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' => $LANG['unit_kilobytes'], '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' => $LANG['note'], 'L_COM' => $LANG['com'], 'L_EDIT' => $LANG['edit'], 'L_APROB_IMG' => $info_pics['aprob'] == 1 ? $LANG['unaprob'] : $LANG['aprob'], 'L_THUMBNAILS' => $LANG['thumbnails'], 'U_DEL' => url('.php?del=' . $info_pics['id'] . '&token=' . $Session->get_token() . '&cat=' . $g_idcat, '-' . $g_idcat . '.php?token=' . $Session->get_token() . '&del=' . $info_pics['id']), 'U_MOVE' => url('.php?id=' . $info_pics['id'] . '&token=' . $Session->get_token() . '&move=\' + this.options[this.selectedIndex].value', '-0-' . $info_pics['id'] . '.php?token=' . $Session->get_token() . '&move=\' + this.options[this.selectedIndex].value'), 'U_PREVIOUS' => $pos_pics > 0 ? '<a href="gallery' . url('.php?cat=' . $g_idcat . '&id=' . $id_previous, '-' . $g_idcat . '-' . $id_previous . '.php') . '#pics_max"><img src="../templates/' . get_utheme() . '/images/left.png" alt="" class="valign_middle" /></a> <a href="gallery' . url('.php?cat=' . $g_idcat . '&id=' . $id_previous, '-' . $g_idcat . '-' . $id_previous . '.php') . '#pics_max">' . $LANG['previous'] . '</a>' : '', 'U_NEXT' => $pos_pics < $i - 1 ? '<a href="gallery' . url('.php?cat=' . $g_idcat . '&id=' . $id_next, '-' . $g_idcat . '-' . $id_next . '.php') . '#pics_max">' . $LANG['next'] . '</a> <a href="gallery' . url('.php?cat=' . $g_idcat . '&id=' . $id_next, '-' . $g_idcat . '-' . $id_next . '.php') . '#pics_max"><img src="../templates/' . get_utheme() . '/images/right.png" alt="" class="valign_middle" /></a>' : '', 'U_LEFT_THUMBNAILS' => $pos_pics - $start_thumbnails > 0 ? '<span id="display_left"><a href="javascript:display_thumbnails(\'left\')"><img src="../templates/' . get_utheme() . '/images/left.png" class="valign_middle" alt="" /></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\')"><img src="../templates/' . get_utheme() . '/images/right.png" class="valign_middle" alt="" /></a></span>' : '<span id="display_right"></span>')); $i = 0; foreach ($array_pics as $pics) { if ($i >= $pos_pics - $start_thumbnails && $i <= $pos_pics + $end_thumbnails) { $Template->assign_block_vars('list_preview_pics', array('PICS' => $pics)); } $i++; } if (isset($_GET['com'])) { $Template->assign_vars(array('COMMENTS' => display_comments('gallery', $g_idpics, url('gallery.php?cat=' . $g_idcat . '&id=' . $g_idpics . '&com=%s', 'gallery-' . $g_idcat . '-' . $g_idpics . '.php?com=%s')))); } } } else { import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('C_GALLERY_MODO' => $is_modo ? true : false, 'PAGINATION_PICS' => $Pagination->display('gallery' . url('.php?pp=%d&cat=' . $g_idcat, '-' . $g_idcat . '+' . $rewrite_title . '.php?pp=%d'), $nbr_pics, 'pp', $CONFIG_GALLERY['nbr_pics_max'], 3), 'L_EDIT' => $LANG['edit'], 'L_VIEW' => $LANG['view'], 'L_VIEWS' => $LANG['views'])); import('content/note'); $is_connected = $User->check_level(MEMBER_LEVEL); $j = 0; $result = $Sql->query_while("SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob, g.width, g.height, g.user_id, g.views, g.note, g.nbrnote, g.nbr_com, g.aprob, m.login\n\t\t\tFROM " . PREFIX . "gallery g\n\t\t\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = g.user_id\n\t\t\tWHERE g.idcat = '" . $g_idcat . "' AND g.aprob = 1\n\t\t\t" . $g_sql_sort . "\n\t\t\t" . $Sql->limit($Pagination->get_first_msg($CONFIG_GALLERY['nbr_pics_max'], 'pp'), $CONFIG_GALLERY['nbr_pics_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { if (!file_exists('pics/thumbnails/' . $row['path'])) { $Gallery->Resize_pics('pics/' . $row['path']); } if ($CONFIG_GALLERY['display_pics'] == 3) { $display_link = HOST . DIR . '/gallery/show_pics' . url('.php?id=' . $row['id'] . '&cat=' . $row['idcat']) . '" rel="lightbox[1]" onmousedown="increment_view(' . $row['id'] . ');" title="' . str_replace('"', '', stripslashes($row['name'])); $display_name = HOST . DIR . '/gallery/show_pics' . url('.php?id=' . $row['id'] . '&cat=' . $row['idcat']) . '" rel="lightbox[2]" onmousedown="increment_view(' . $row['id'] . ');" title="' . str_replace('"', '', stripslashes($row['name'])); } elseif ($CONFIG_GALLERY['display_pics'] == 2) { $display_name = $display_link = 'javascript:increment_view(' . $row['id'] . ');display_pics_popup(\'' . HOST . DIR . '/gallery/show_pics' . url('.php?id=' . $row['id'] . '&cat=' . $row['idcat']) . '\', \'' . $row['width'] . '\', \'' . $row['height'] . '\')'; } elseif ($CONFIG_GALLERY['display_pics'] == 1) { $display_name = $display_link = 'javascript:increment_view(' . $row['id'] . ');display_pics(' . $row['id'] . ', \'' . HOST . DIR . '/gallery/show_pics' . url('.php?id=' . $row['id'] . '&cat=' . $row['idcat']) . '\')';
} } else { redirect(HOST . SCRIPT); } $Template->pparse('admin_groups_management2'); } elseif ($add) { $Template->set_filenames(array('admin_groups_management2' => 'admin/admin_groups_management2.tpl')); $img_groups = '<option value="" selected="selected">--</option>'; import('io/filesystem/folder'); $img_groups = '<option value="">--</option>'; $image_folder_path = new Folder(PATH_TO_ROOT . '/images/group'); foreach ($image_folder_path->get_files('`\\.(png|jpg|bmp|gif)$`i') as $image) { $file = $image->get_name(); $img_groups .= '<option value="' . $file . '">' . $file . '</option>'; } $Template->assign_vars(array('THEME' => get_utheme(), 'LANG' => get_ulang(), 'IMG_GROUPS' => $img_groups, 'C_ADD_GROUP' => true, 'L_REQUIRE_PSEUDO' => $LANG['require_pseudo'], 'L_REQUIRE_NAME' => $LANG['require_name'], 'L_CONFIRM_DEL_USER_GROUP' => $LANG['confirm_del_member_group'], 'L_GROUPS_MANAGEMENT' => $LANG['groups_management'], 'L_ADD_GROUPS' => $LANG['groups_add'], 'L_REQUIRE' => $LANG['require'], 'L_UPLOAD_GROUPS' => $LANG['upload_group'], 'L_UPLOAD_FORMAT' => $LANG['upload_rank_format'], 'L_UPLOAD' => $LANG['upload'], 'L_NAME' => $LANG['name'], 'L_IMG_ASSOC_GROUP' => $LANG['img_assoc_group'], 'L_IMG_ASSOC_GROUP_EXPLAIN' => $LANG['img_assoc_group_explain'], 'L_AUTH_FLOOD' => $LANG['auth_flood'], 'L_PM_GROUP_LIMIT' => $LANG['pm_group_limit'], 'L_PM_GROUP_LIMIT_EXPLAIN' => $LANG['pm_group_limit_explain'], 'L_DATA_GROUP_LIMIT' => $LANG['data_group_limit'], 'L_DATA_GROUP_LIMIT_EXPLAIN' => $LANG['data_group_limit_explain'], 'L_COLOR_GROUP' => $LANG['color_group'], 'L_COLOR_GROUP_EXPLAIN' => $LANG['color_group_explain'], 'L_MB' => $LANG['unit_megabytes'], 'L_YES' => $LANG['yes'], 'L_NO' => $LANG['no'], 'L_ADD' => $LANG['add'])); $Template->pparse('admin_groups_management2'); } else { $Template->set_filenames(array('admin_groups_management' => 'admin/admin_groups_management.tpl')); $nbr_group = $Sql->count_table("group", __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('PAGINATION' => $Pagination->display('admin_groups.php?p=%d', $nbr_group, 'p', 25, 3), 'THEME' => get_utheme(), 'LANG' => get_ulang(), 'KERNEL_EDITOR' => display_editor(), 'L_CONFIRM_DEL_GROUP' => $LANG['confirm_del_group'], 'L_GROUPS_MANAGEMENT' => $LANG['groups_management'], 'L_ADD_GROUPS' => $LANG['groups_add'], 'L_NAME' => $LANG['name'], 'L_IMAGE' => $LANG['image'], 'L_UPDATE' => $LANG['update'], 'L_DELETE' => $LANG['delete'])); $result = $Sql->query_while("SELECT id, name, img\n\tFROM " . DB_TABLE_GROUP . "\n\tORDER BY name\n\t" . $Sql->limit($Pagination->get_first_msg(25, 'p'), 25), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $Template->assign_block_vars('group', array('LINK' => url('.php?g=' . $row['id'], '-0.php?g=' . $row['id']), 'ID' => $row['id'], 'NAME' => $row['name'], 'IMAGE' => !empty($row['img']) ? '<img src="../images/group/' . $row['img'] . '" alt="" />' : '')); } $Sql->query_close($result); $Template->pparse('admin_groups_management'); } require_once '../admin/admin_footer.php';
} if (isset($stockage)) { $stockage = '&stockage=' . $stockage; } else { $stockage = ''; } if (isset($_POST['search'])) { $search = '&search=' . $_POST['search']; } elseif (isset($_GET['search'])) { $search = '&search=' . $_GET['search']; } else { $search = ''; } $pagination = new Pagination('?paged=%s' . $region . $appellation . $type . $stockage . $search, $current_page, $total_posts, $options); // On fait une instance de la classe Pagination $pagination->display(); // On affiche le rendu de la pagination switch ($total_posts) { //pas de résultats case '': echo ''; break; case 'index': echo ''; break; case 1: echo "<p id='nb-enregistrements'>" . $total_posts . ' résultat</p>'; break; default: echo "<p id='nb-enregistrements'>" . $total_posts . ' résultats</p>'; }
case 'incomplete': $errstr = $LANG['e_incomplete']; break; default: $errstr = ''; } if (!empty($errstr)) { $Errorh->handler($errstr, E_USER_NOTICE); } if ($captcha->is_available() && $CONFIG_GUESTBOOK['guestbook_verifcode']) { $Template->assign_vars(array('C_VERIF_CODE' => true, 'VERIF_CODE' => $captcha->display_form(), 'L_REQUIRE_VERIF_CODE' => $captcha->js_require())); } $nbr_guestbook = $Sql->count_table('guestbook', __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('UPDATE' => url('?token=' . $Session->get_token()), 'PAGINATION' => $Pagination->display('guestbook' . url('.php?p=%d'), $nbr_guestbook, 'p', 10, 3), 'KERNEL_EDITOR' => display_editor('guestbook_contents', $CONFIG_GUESTBOOK['guestbook_forbidden_tags']), 'L_ALERT_TEXT' => $LANG['require_text'], 'L_DELETE_MSG' => $LANG['alert_delete_msg'], 'L_ADD_MSG' => $LANG['add_msg'], 'L_REQUIRE' => $LANG['require'], 'L_MESSAGE' => $LANG['message'], 'L_VERIF_CODE' => $LANG['verif_code'], 'L_PSEUDO' => $LANG['pseudo'], 'L_SUBMIT' => $LANG['submit'], 'L_PREVIEW' => $LANG['preview'], 'L_RESET' => $LANG['reset'], 'L_ON' => $LANG['on'])); $array_ranks = array(-1 => $LANG['guest'], 0 => $LANG['member'], 1 => $LANG['modo'], 2 => $LANG['admin']); $Cache->load('ranks'); $j = 0; $result = $Sql->query_while("SELECT g.id, g.login, g.timestamp, m.user_id, m.login as mlogin, m.level, m.user_mail, m.user_show_mail, m.timestamp AS registered, m.user_avatar, m.user_msg, m.user_local, m.user_web, m.user_sex, m.user_msn, m.user_yahoo, m.user_sign, m.user_warning, m.user_ban, m.user_groups, s.user_id AS connect, g.contents\n\tFROM " . PREFIX . "guestbook g\n\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = g.user_id\n\tLEFT JOIN " . DB_TABLE_SESSIONS . " s ON s.user_id = g.user_id AND s.session_time > '" . (time() - $CONFIG['site_session_invit']) . "'\n\tGROUP BY g.id\n\tORDER BY g.timestamp DESC\n\t" . $Sql->limit($Pagination->get_first_msg(10, 'p'), 10), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $edit = ''; $del = ''; $is_guest = empty($row['user_id']); $is_modo = $User->check_level(MODO_LEVEL); $warning = ''; $readonly = ''; if ($is_modo && !$is_guest) { $warning = ' <a href="../member/moderation_panel' . url('.php?action=warning&id=' . $row['user_id']) . '" title="' . $LANG['warning_management'] . '"><img src="../templates/' . get_utheme() . '/images/admin/important.png" alt="' . $LANG['warning_management'] . '" class="valign_middle" /></a>'; $readonly = '<a href="../member/moderation_panel' . url('.php?action=punish&id=' . $row['user_id']) . '" title="' . $LANG['punishment_management'] . '"><img src="../templates/' . get_utheme() . '/images/readonly.png" alt="' . $LANG['punishment_management'] . '" class="valign_middle" /></a>'; }
$trend_img = 'up.png'; $sign = '+'; $trend = number_round($row['yesterday_visit'] * 100 / $average, 1) - 100; } elseif ($row['yesterday_visit'] < $average) { $trend_img = 'down.png'; $sign = '-'; $trend = 100 - number_round($row['yesterday_visit'] * 100 / $average, 1); } else { $trend_img = 'right.png'; $sign = '+'; $trend = 0; } $Template->assign_block_vars('keyword_list', array('ID' => $row['id'], 'KEYWORD' => $row['relative_url'], 'IMG_MORE' => '<img src="../templates/' . get_utheme() . '/images/upload/plus.png" alt="" onclick="XMLHttpRequest_referer(' . $row['id'] . ')" class="valign_middle" id="img_url' . $row['id'] . '" />', 'NBR_LINKS' => $row['count'], 'TOTAL_VISIT' => $row['total_visit'], 'AVERAGE_VISIT' => number_round($average, 1), 'LAST_UPDATE' => gmdate_format('date_format_short', $row['last_update']), 'TREND' => '<img src="../templates/' . get_utheme() . '/images/admin/' . $trend_img . '" alt="" class="valign_middle" /> (' . $sign . $trend . '%)')); } $Sql->query_close($result); $Template->assign_vars(array('C_STATS_KEYWORD' => true, 'PAGINATION' => $Pagination->display('stats' . url('.php?keyword=1&p=%d', '-keyword.php?p=%d'), $nbr_keyword, 'p', 15, 3), 'L_SEARCH_ENGINE' => $LANG['keyword_s'], 'L_TOTAL_VISIT' => $LANG['total_visit'], 'L_AVERAGE_VISIT' => $LANG['average_visit'], 'L_TREND' => $LANG['trend'], 'L_LAST_UPDATE' => $LANG['last_update'])); } elseif ($browser || $os || $user_lang) { include_once '../lang/' . get_ulang() . '/stats.php'; $path = '../images/stats/'; if (!empty($browser)) { $Template->assign_vars(array('C_STATS_BROWSERS' => true, 'GRAPH_RESULT' => !file_exists('../cache/browsers.png') ? '<img src="../kernel/framework/ajax/display_stats.php?browsers=1" alt="" />' : '<img src="../cache/browsers.png" alt="" />', 'L_BROWSERS' => $LANG['browser_s'])); $stats_menu = 'browsers'; $array_stats_info = $stats_array_browsers; $path = '../images/stats/browsers/'; } elseif (!empty($os)) { $Template->assign_vars(array('C_STATS_OS' => true, 'GRAPH_RESULT' => !file_exists('../cache/os.png') ? '<img src="../kernel/framework/ajax/display_stats.php?os=1" alt="" />' : '<img src="../cache/os.png" alt="" />', 'L_OS' => $LANG['os'])); $stats_menu = 'os'; $array_stats_info = $stats_array_os; $path = '../images/stats/os/'; } elseif (!empty($user_lang)) { $Template->assign_vars(array('C_STATS_LANG' => true, 'GRAPH_RESULT' => !file_exists('../cache/lang.png') ? '<img src="../kernel/framework/ajax/display_stats.php?lang=1" alt="" />' : '<img src="../cache/lang.png" alt="" />', 'L_LANG' => $LANG['stat_lang']));
</div> <?php if ($session->is_logged_in()) { ?> <a type="button" href="new/create" class="ui green button">Write a new story</a> <a type="button" href="new/random" data-inverted data-tooltip="Create a new story with generated content" class="ui orange button">Generate story</a> <?php } ?> <?php echo msgs(); ?> <br><br><hr> <h3>Stories</h3> <?php echo $pag->display(); ?> <div class="questions front-page" id="questions"> <?php if (count($qs) < 1) { echo "There are no stories in this section yet.<br>"; } else { foreach ($qs as $q) { if ($q->status != 1 && $q->uid != USER_ID) { continue; } $self = $q->uid === USER_ID ?: false; $commentsCount = count(Comment::get_comments($q->id)); $votes = QNA::get_votes($q->id); $votes = $votes ?: "0"; $reports_count = QNA::get_reports_count($q->id) ?: null;
$order = $order == 'desc' ? 'desc' : 'asc'; $alerts_list = AdministratorAlertService::get_all_alerts($criteria, $order, ($pagination->_get_var_page('p') - 1) * NUM_ALERTS_PER_PAGE, NUM_ALERTS_PER_PAGE); foreach ($alerts_list as $alert) { $img_type = ''; switch ($alert->get_priority()) { case ADMIN_ALERT_VERY_LOW_PRIORITY: $color = 'FFFFFF'; break; case ADMIN_ALERT_LOW_PRIORITY: $color = 'ECDBB7'; break; case ADMIN_ALERT_MEDIUM_PRIORITY: $color = 'F5D5C6'; break; case ADMIN_ALERT_HIGH_PRIORITY: $img_type = 'important.png'; $color = 'FFD5D1'; break; case ADMIN_ALERT_VERY_HIGH_PRIORITY: $img_type = 'errors_mini.png'; $color = 'F3A29B'; break; default: $color = 'FFFFFF'; } $creation_date = $alert->get_creation_date(); $template->assign_block_vars('alerts', array('C_PROCESSED' => $alert->get_status() == ADMIN_ALERT_STATUS_PROCESSED, 'FIXING_URL' => url(PATH_TO_ROOT . '/' . $alert->get_fixing_url()), 'NAME' => $alert->get_entitled(), 'PRIORITY' => $alert->get_priority_name(), 'STYLE' => 'background:#' . $color . ';', 'IMG' => !empty($img_type) ? '<img src="../templates/' . get_utheme() . '/images/admin/' . $img_type . '" alt="" class="valign_middle" />' : '', 'DATE' => $creation_date->format(DATE_FORMAT), 'ID' => $alert->get_id(), 'STATUS' => $alert->get_status())); } $template->assign_vars(array('C_EXISTING_ALERTS' => (bool) count($alerts_list), 'C_PAGINATION' => AdministratorAlertService::get_number_alerts() > NUM_ALERTS_PER_PAGE, 'PAGINATION' => $pagination->display('admin_alerts.php?p=%d&criteria=' . $criteria . '&order=' . $order, AdministratorAlertService::get_number_alerts(), 'p', NUM_ALERTS_PER_PAGE, 3), 'L_ADMIN_ALERTS' => $LANG['administrator_alerts'], 'L_TYPE' => $LANG['type'], 'L_DATE' => $LANG['date'], 'L_PRIORITY' => $LANG['priority'], 'L_ADMINISTRATOR_ALERTS_LIST' => $LANG['administrator_alerts_list'], 'L_ACTIONS' => $LANG['administrator_alerts_action'], 'L_NO_ALERT' => $LANG['no_administrator_alert'], 'L_CONFIRM_DELETE_ALERT' => $LANG['confirm_delete_administrator_alert'], 'L_DELETE' => $LANG['delete'], 'L_FIX' => $LANG['admin_alert_fix'], 'L_UNFIX' => $LANG['admin_alert_unfix'], 'C_ORDER_ENTITLED_ASC' => $criteria == 'entitled' && $order == 'asc', 'U_ORDER_ENTITLED_ASC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=entitled&order=asc'), 'C_ORDER_ENTITLED_DESC' => $criteria == 'entitled' && $order == 'desc', 'U_ORDER_ENTITLED_DESC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=entitled&order=desc'), 'C_ORDER_CREATION_DATE_ASC' => $criteria == 'creation_date' && $order == 'asc', 'U_ORDER_CREATION_DATE_ASC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=creation_date&order=asc'), 'C_ORDER_CREATION_DATE_DESC' => $criteria == 'creation_date' && $order == 'desc', 'U_ORDER_CREATION_DATE_DESC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=creation_date&order=desc'), 'C_ORDER_PRIORITY_ASC' => $criteria == 'priority' && $order == 'asc', 'U_ORDER_PRIORITY_ASC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=priority&order=asc'), 'C_ORDER_PRIORITY_DESC' => $criteria == 'priority' && $order == 'desc', 'U_ORDER_PRIORITY_DESC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=priority&order=desc'), 'C_ORDER_STATUS_ASC' => $criteria == 'current_status' && $order == 'asc', 'U_ORDER_STATUS_ASC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=current_status&order=asc'), 'C_ORDER_STATUS_DESC' => $criteria == 'current_status' && $order == 'desc', 'U_ORDER_STATUS_DESC' => url('admin_alerts.php?p=' . $pagination->_get_var_page('p') . '&criteria=current_status&order=desc'))); $template->parse(); require_once '../admin/admin_footer.php';
$idcat = retrieve(POST, 'idcat', 0); $compt = retrieve(POST, 'compt', 0); $aprob = retrieve(POST, 'aprob', 0); if (!empty($title) && !empty($url) && !empty($idcat)) { $Sql->query_inject("UPDATE " . PREFIX . "web SET title = '" . $title . "', contents = '" . $contents . "', url = '" . $url . "', idcat = '" . $idcat . "', compt = '" . $compt . "', aprob = '" . $aprob . "' WHERE id = '" . $id_post . "'", __LINE__, __FILE__); redirect(HOST . SCRIPT); } else { redirect(HOST . DIR . '/web/admin_web.php?id= ' . $id_post . '&error=incomplete#errorh'); } } elseif ($del && !empty($id)) { $Session->csrf_get_protect(); $Sql->query_inject("DELETE FROM " . PREFIX . "web WHERE id = '" . $id . "'", __LINE__, __FILE__); $Sql->query_inject("DELETE FROM " . DB_TABLE_COM . " WHERE idprov = '" . $id . "' AND script = 'web'", __LINE__, __FILE__); redirect(HOST . SCRIPT); } else { $Template->set_filenames(array('admin_web_management' => 'web/admin_web_management.tpl')); $nbr_web = $Sql->count_table('web', __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('PAGINATION' => $Pagination->display('admin_web.php?p=%d', $nbr_web, 'p', 25, 3), 'THEME' => get_utheme(), 'LANG' => get_ulang(), 'KERNEL_EDITOR' => display_editor(), 'L_WEB_ADD' => $LANG['web_add'], 'L_WEB_MANAGEMENT' => $LANG['web_management'], 'L_WEB_CAT' => $LANG['cat_management'], 'L_WEB_CONFIG' => $LANG['web_config'], 'L_DEL_ENTRY' => $LANG['delete_link'], 'L_LISTE' => $LANG['list'], 'L_NAME' => $LANG['name'], 'L_CATEGORY' => $LANG['category'], 'L_URL' => $LANG['url'], 'L_VIEW' => $LANG['view'], 'L_DATE' => $LANG['date'], 'L_APROB' => $LANG['aprob'], 'L_UPDATE' => $LANG['update'], 'L_DELETE' => $LANG['delete'])); $result = $Sql->query_while("SELECT d.*, ad.name \n\tFROM " . PREFIX . "web d \n\tLEFT JOIN " . PREFIX . "web_cat ad ON ad.id = d.idcat\n\tORDER BY timestamp DESC \n\t" . $Sql->limit($Pagination->get_first_msg(25, 'p'), 25), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $aprob = $row['aprob'] == 1 ? $LANG['yes'] : $LANG['no']; $title = $row['title']; $title = strlen($title) > 45 ? substr_html($title, 0, 45) . '...' : $title; $Template->assign_block_vars('web', array('IDWEB' => $row['id'], 'NAME' => $title, 'IDCAT' => $row['idcat'], 'CAT' => $row['name'], 'DATE' => gmdate_format('date_format_short', $row['timestamp']), 'APROBATION' => $aprob, 'COMPT' => $row['compt'])); } $Sql->query_close($result); $Template->pparse('admin_web_management'); } require_once '../admin/admin_footer.php';
$_GET['pt'] = ceil(($nbr_msg_before + 1) / $CONFIG_FORUM['pagination_msg']); } import('util/pagination'); $Pagination = new Pagination(); $i = 0; $forum_cats = ''; $Bread_crumb->remove_last(); foreach ($Bread_crumb->array_links as $key => $array) { if ($i == 2) { $forum_cats .= '<a href="' . $array[1] . '">' . $array[0] . '</a>'; } elseif ($i > 2) { $forum_cats .= ' » <a href="' . $array[1] . '">' . $array[0] . '</a>'; } $i++; } $Template->assign_vars(array('FORUM_NAME' => $CONFIG_FORUM['forum_name'], 'SID' => SID, 'MODULE_DATA_PATH' => $module_data_path, 'DESC' => !empty($topic['subtitle']) ? $topic['subtitle'] : '', 'PAGINATION' => $Pagination->display('topic' . url('.php?id=' . $id_get . '&pt=%d', '-' . $id_get . '-%d' . $rewrited_title . '.php'), $topic['nbr_msg'], 'pt', $CONFIG_FORUM['pagination_msg'], 3), 'THEME' => get_utheme(), 'LANG' => get_ulang(), 'USER_ID' => $topic['user_id'], 'ID' => $topic['idcat'], 'IDTOPIC' => $id_get, 'PAGE' => $page, 'TITLE_T' => ucfirst($topic['title']), 'DISPLAY_MSG' => $CONFIG_FORUM['activ_display_msg'] && $topic['display_msg'] ? $CONFIG_FORUM['display_msg'] . ' ' : '', 'U_MSG_SET_VIEW' => '<a class="small_link" href="../forum/action' . url('.php?read=1&f=' . $topic['idcat'], '') . '" title="' . $LANG['mark_as_read'] . '" onclick="javascript:return Confirm_read_topics();">' . $LANG['mark_as_read'] . '</a>', 'U_CHANGE_CAT' => 'topic' . url('.php?id=' . $id_get . '&token=' . $Session->get_token(), '-' . $id_get . $rewrited_cat_title . '.php?token=' . $Session->get_token()), 'U_ONCHANGE' => url(".php?id=' + this.options[this.selectedIndex].value + '", "-' + this.options[this.selectedIndex].value + '.php"), 'U_ONCHANGE_CAT' => url("index.php?id=' + this.options[this.selectedIndex].value + '", "cat-' + this.options[this.selectedIndex].value + '.php"), 'U_FORUM_CAT' => !empty($forum_cats) ? $forum_cats . ' »' : '', 'U_TITLE_T' => 'topic' . url('.php?id=' . $id_get, '-' . $id_get . $rewrited_title . '.php'), 'L_REQUIRE_MESSAGE' => $LANG['require_text'], 'L_DELETE_MESSAGE' => $LANG['alert_delete_msg'], 'L_GUEST' => $LANG['guest'], 'L_DELETE' => $LANG['delete'], 'L_EDIT' => $LANG['edit'], 'L_CUT_TOPIC' => $LANG['cut_topic'], 'L_EDIT_BY' => $LANG['edit_by'], 'L_PUNISHMENT_MANAGEMENT' => $LANG['punishment_management'], 'L_WARNING_MANAGEMENT' => $LANG['warning_management'], 'L_FORUM_INDEX' => $LANG['forum_index'], 'L_QUOTE' => $LANG['quote'], 'L_ON' => $LANG['on'], 'L_RESPOND' => $LANG['respond'], 'L_SUBMIT' => $LANG['submit'], 'L_PREVIEW' => $LANG['preview'], 'L_RESET' => $LANG['reset'])); $array_ranks = array(-1 => $LANG['guest_s'], 0 => $LANG['member_s'], 1 => $LANG['modo_s'], 2 => $LANG['admin_s']); list($track, $track_pm, $track_mail, $poll_done) = array(false, false, false, false); $Cache->load('ranks'); $page = retrieve(GET, 'pt', 0); $quote_last_msg = $page > 1 ? 1 : 0; $i = 0; $j = 0; $result = $Sql->query_while("SELECT msg.id, msg.timestamp, msg.timestamp_edit, msg.user_id_edit, m.user_id, m.user_groups, p.question, p.answers, p.voter_id, p.votes, p.type, m.login, m.level, m.user_mail, m.user_show_mail, m.timestamp AS registered, m.user_avatar, m.user_msg, m.user_local, m.user_web, m.user_sex, m.user_msn, m.user_yahoo, m.user_sign, m.user_warning, m.user_readonly, m.user_ban, m2.login as login_edit, s.user_id AS connect, tr.id AS trackid, tr.pm as trackpm, tr.track AS track, tr.mail AS trackmail, msg.contents\nFROM " . PREFIX . "forum_msg msg\nLEFT JOIN " . PREFIX . "forum_poll p ON p.idtopic = '" . $id_get . "'\nLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = msg.user_id\nLEFT JOIN " . DB_TABLE_MEMBER . " m2 ON m2.user_id = msg.user_id_edit\nLEFT JOIN " . PREFIX . "forum_track tr ON tr.idtopic = '" . $id_get . "' AND tr.user_id = '" . $User->get_attribute('user_id') . "'\nLEFT JOIN " . DB_TABLE_SESSIONS . " s ON s.user_id = msg.user_id AND s.session_time > '" . (time() - $CONFIG['site_session_invit']) . "' AND s.user_id != -1\nWHERE msg.idtopic = '" . $id_get . "'\t\nORDER BY msg.timestamp \n" . $Sql->limit($Pagination->get_first_msg($CONFIG_FORUM['pagination_msg'], 'pt') - $quote_last_msg, $CONFIG_FORUM['pagination_msg'] + $quote_last_msg), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $is_guest = empty($row['user_id']); $first_message = $row['id'] == $topic['first_msg_id'] ? true : false; list($edit, $del, $cut, $moderator) = array(false, false, false, false); if ($check_group_edit_auth || $User->get_attribute('user_id') == $row['user_id'] && !$is_guest && !$first_message) { list($edit, $del) = array(true, true); if ($check_group_edit_auth) {
$img_announce .= $row['type'] == '2' ? '_top' : ''; $img_announce .= $row['status'] == '0' && $row['type'] == '0' ? '_lock' : ''; if (!empty($row['last_view_id'])) { $last_msg_id = $row['last_view_id']; $last_page = 'idm=' . $row['last_view_id'] . '&'; $last_page_rewrite = '-0-' . $row['last_view_id']; } else { $last_msg_id = $row['last_msg_id']; $last_page = ceil($row['nbr_msg'] / $CONFIG_FORUM['pagination_msg']); $last_page_rewrite = $last_page > 1 ? '-' . $last_page : ''; $last_page = $last_page > 1 ? 'pt=' . $last_page . '&' : ''; } $rewrited_title = $CONFIG['rewrite'] == 1 ? '+' . url_encode_rewrite($row['title']) : ''; $last_msg = '<a href="topic' . url('.php?' . $last_page . 'id=' . $row['id'], '-' . $row['id'] . $last_page_rewrite . $rewrited_title . '.php') . '#m' . $last_msg_id . '" title=""><img src="../templates/' . get_utheme() . '/images/ancre.png" alt="" /></a>' . ' ' . $LANG['on'] . ' ' . gmdate_format('date_format', $row['last_timestamp']) . '<br /> ' . $LANG['by'] . ' ' . (!empty($row['last_login']) ? '<a class="small_link" href="../member/member' . url('.php?id=' . $row['last_user_id'], '-' . $row['last_user_id'] . '.php') . '">' . wordwrap_html($row['last_login'], 13) . '</a>' : '<em>' . $LANG['guest'] . '</em>'); $new_ancre = $new_msg === true && $User->get_attribute('user_id') !== -1 ? '<a href="topic' . url('.php?' . $last_page . 'id=' . $row['id'], '-' . $row['id'] . $last_page_rewrite . $rewrited_title . '.php') . '#m' . $last_msg_id . '" title=""><img src="../templates/' . get_utheme() . '/images/ancre.png" alt="" /></a>' : ''; $Template->assign_block_vars('topics', array('C_HOT_TOPIC' => $row['type'] == '0' && $row['status'] != '0' && $row['nbr_msg'] > $CONFIG_FORUM['pagination_msg'], 'ID' => $row['id'], 'INCR' => $nbr_topics_compt, 'CHECKED_PM' => $row['pm'] == 1 ? 'checked="checked"' : '', 'CHECKED_MAIL' => $row['mail'] == 1 ? 'checked="checked"' : '', 'IMG_ANNOUNCE' => $img_announce, 'ANCRE' => $new_ancre, 'POLL' => !empty($row['question']) ? '<img src="' . $Template->get_module_data_path('forum') . '/images/poll_mini.png" class="valign_middle" alt="" />' : '', 'TRACK' => '<img src="' . $Template->get_module_data_path('forum') . '/images/track_mini.png" class="valign_middle" alt="" />', 'DISPLAY_MSG' => $CONFIG_FORUM['activ_display_msg'] && $CONFIG_FORUM['icon_activ_display_msg'] && $row['display_msg'] ? '<img src="' . $Template->get_module_data_path('forum') . '/images/msg_display_mini.png" alt="" style="vertical-align:middle;" />' : '', 'TYPE' => $type[$row['type']], 'TITLE' => ucfirst($row['title']), 'AUTHOR' => !empty($row['login']) ? '<a href="../member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '" class="small_link">' . $row['login'] . '</a>' : '<em>' . $LANG['guest'] . '</em>', 'DESC' => $row['subtitle'], 'PAGINATION_TOPICS' => $Pagination->display('topic' . url('.php?id=' . $row['id'] . '&pt=%d', '-' . $row['id'] . '-%d.php'), $row['nbr_msg'], 'pt', $CONFIG_FORUM['pagination_msg'], 2, 10, false), 'MSG' => $row['nbr_msg'] - 1, 'VUS' => $row['nbr_views'], 'U_TOPIC_VARS' => url('.php?id=' . $row['id'], '-' . $row['id'] . $rewrited_title . '.php'), 'U_LAST_MSG' => $last_msg, 'L_DISPLAY_MSG' => $CONFIG_FORUM['activ_display_msg'] && $row['display_msg'] ? $CONFIG_FORUM['display_msg'] : '')); $nbr_topics_compt++; } $Sql->query_close($result); $nbr_topics = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "forum_topics t\n\tLEFT JOIN " . PREFIX . "forum_track tr ON tr.idtopic = t.id\n\tWHERE tr.user_id = '" . $User->get_attribute('user_id') . "'", __LINE__, __FILE__); if ($nbr_topics == 0) { $Template->assign_vars(array('C_NO_TRACKED_TOPICS' => true, 'L_NO_TRACKED_TOPICS' => '0 ' . $LANG['show_topic_track'])); } $l_topic = $nbr_topics > 1 ? $LANG['topic_s'] : $LANG['topic']; $Template->assign_vars(array('NBR_TOPICS' => $nbr_topics, 'FORUM_NAME' => $CONFIG_FORUM['forum_name'], 'SID' => SID, 'MODULE_DATA_PATH' => $Template->get_module_data_path('forum'), 'PAGINATION' => $Pagination->display('track' . url('.php?p=%d'), $nbr_topics, 'p', $CONFIG_FORUM['pagination_topic'], 3), 'LANG' => get_ulang(), 'U_MSG_SET_VIEW' => '<a class="small_link" href="../forum/action' . url('.php?read=1&favorite=1', '') . '" title="' . $LANG['mark_as_read'] . '" onclick="javascript:return Confirm_read_topics();">' . $LANG['mark_as_read'] . '</a>', 'U_CHANGE_CAT' => 'track.php' . SID . '&token=' . $Session->get_token(), 'U_ONCHANGE' => url(".php?id=' + this.options[this.selectedIndex].value + '", "-' + this.options[this.selectedIndex].value + '.php"), 'U_ONCHANGE_CAT' => url("index.php?id=' + this.options[this.selectedIndex].value + '", "cat-' + this.options[this.selectedIndex].value + '.php"), 'U_FORUM_CAT' => '<a href="../forum/track.php' . SID . '">' . $LANG['show_topic_track'] . '</a>', 'U_POST_NEW_SUBJECT' => '', 'U_TRACK_ACTION' => url('.php?p=' . $page . '&token=' . $Session->get_token()), 'L_FORUM_INDEX' => $LANG['forum_index'], 'L_AUTHOR' => $LANG['author'], 'L_FORUM' => $LANG['forum'], 'L_DELETE' => $LANG['delete'], 'L_MAIL' => $LANG['mail'], 'L_PM' => $LANG['pm'], 'L_EXPLAIN_TRACK' => $LANG['explain_track'], 'L_TOPIC' => $l_topic, 'L_MESSAGE' => $LANG['replies'], 'L_VIEW' => $LANG['views'], 'L_LAST_MESSAGE' => $LANG['last_message'], 'L_SUBMIT' => $LANG['submit'])); list($users_list, $total_admin, $total_modo, $total_member, $total_visit, $total_online) = forum_list_user_online("AND s.session_script = '/forum/track.php'"); $Template->assign_vars(array('TOTAL_ONLINE' => $total_online, 'USERS_ONLINE' => $total_online - $total_visit == 0 ? '<em>' . $LANG['no_member_online'] . '</em>' : $users_list, 'ADMIN' => $total_admin, 'MODO' => $total_modo, 'MEMBER' => $total_member, 'GUEST' => $total_visit, 'SELECT_CAT' => forum_list_cat(0, 0), 'L_USER' => $total_online > 1 ? $LANG['user_s'] : $LANG['user'], 'L_ADMIN' => $total_admin > 1 ? $LANG['admin_s'] : $LANG['admin'], 'L_MODO' => $total_modo > 1 ? $LANG['modo_s'] : $LANG['modo'], 'L_MEMBER' => $total_member > 1 ? $LANG['member_s'] : $LANG['member'], 'L_GUEST' => $total_visit > 1 ? $LANG['guest_s'] : $LANG['guest'], 'L_AND' => $LANG['and'], 'L_ONLINE' => strtolower($LANG['online']))); $Template->pparse('forum_track'); } else { redirect(HOST . DIR . '/forum/index.php' . SID2); }
function get_home_page() { global $Sql, $idartcat, $User, $Cache, $Bread_crumb, $Errorh, $CAT_ARTICLES, $CONFIG_ARTICLES, $LANG; require_once '../articles/articles_begin.php'; $tpl = new Template('articles/articles_cat.tpl'); if ($idartcat > 0) { if (!isset($CAT_ARTICLES[$idartcat]) || $CAT_ARTICLES[$idartcat]['aprob'] == 0) { $Errorh->handler('e_auth', E_USER_REDIRECT); } $cat_links = ''; foreach ($CAT_ARTICLES as $id => $array_info_cat) { if ($CAT_ARTICLES[$idartcat]['id_left'] >= $array_info_cat['id_left'] && $CAT_ARTICLES[$idartcat]['id_right'] <= $array_info_cat['id_right'] && $array_info_cat['level'] <= $CAT_ARTICLES[$idartcat]['level']) { $cat_links .= ' <a href="articles' . url('.php?cat=' . $id, '-' . $id . '.php') . '">' . $array_info_cat['name'] . '</a> »'; } } $clause_cat = " WHERE ac.id_left > '" . $CAT_ARTICLES[$idartcat]['id_left'] . "' AND ac.id_right < '" . $CAT_ARTICLES[$idartcat]['id_right'] . "' AND ac.level = '" . ($CAT_ARTICLES[$idartcat]['level'] + 1) . "' AND ac.aprob = 1"; } else { $cat_links = ''; $clause_cat = " WHERE ac.level = '0' AND ac.aprob = 1"; } if (!isset($CAT_ARTICLES[$idartcat]) || !$User->check_auth($CAT_ARTICLES[$idartcat]['auth'], READ_CAT_ARTICLES)) { $Errorh->handler('e_auth', E_USER_REDIRECT); } $nbr_articles = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "articles WHERE visible = 1 AND idcat = '" . $idartcat . "'", __LINE__, __FILE__); $total_cat = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "articles_cats ac " . $clause_cat, __LINE__, __FILE__); $rewrite_title = url_encode_rewrite($CAT_ARTICLES[$idartcat]['name']); $nbr_column_cats = $total_cat > $CONFIG_ARTICLES['nbr_column'] ? $CONFIG_ARTICLES['nbr_column'] : $total_cat; $nbr_column_cats = !empty($nbr_column_cats) ? $nbr_column_cats : 1; $column_width_cats = floor(100 / $nbr_column_cats); $is_admin = $User->check_level(ADMIN_LEVEL) ? true : false; $tpl->assign_vars(array('IDCAT' => $idartcat, 'C_IS_ADMIN' => $is_admin, 'COLUMN_WIDTH_CAT' => $column_width_cats, 'ADD_ARTICLES' => $is_admin ? (!empty($idartcat) ? '» ' : '') . '<a href="../articles/admin_articles_add.php"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/add.png" alt="" class="valign_middle" /></a>' : '', 'L_ARTICLES' => $LANG['articles'], 'L_DATE' => $LANG['date'], 'L_VIEW' => $LANG['views'], 'L_NOTE' => $LANG['note'], 'L_COM' => $LANG['com'], 'L_TOTAL_ARTICLE' => $nbr_articles > 0 ? sprintf($LANG['nbr_articles_info'], $nbr_articles) : '', 'L_NO_ARTICLES' => $nbr_articles == 0 ? $LANG['none_article'] : '', 'L_ARTICLES_INDEX' => $LANG['title_articles'], 'L_CATEGORIES' => $CAT_ARTICLES[$idartcat]['level'] >= 0 ? $LANG['sub_categories'] : $LANG['categories'], 'U_ARTICLES_CAT_LINKS' => trim($cat_links, ' »'), 'U_ARTICLES_ALPHA_TOP' => url('.php?sort=alpha&mode=desc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=alpha&mode=desc'), 'U_ARTICLES_ALPHA_BOTTOM' => url('.php?sort=alpha&mode=asc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=alpha&mode=asc'), 'U_ARTICLES_DATE_TOP' => url('.php?sort=date&mode=desc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=date&mode=desc'), 'U_ARTICLES_DATE_BOTTOM' => url('.php?sort=date&mode=asc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=date&mode=asc'), 'U_ARTICLES_VIEW_TOP' => url('.php?sort=view&mode=desc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=view&mode=desc'), 'U_ARTICLES_VIEW_BOTTOM' => url('.php?sort=view&mode=asc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=view&mode=asc'), 'U_ARTICLES_NOTE_TOP' => url('.php?sort=note&mode=desc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=note&mode=desc'), 'U_ARTICLES_NOTE_BOTTOM' => url('.php?sort=note&mode=asc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=note&mode=asc'), 'U_ARTICLES_COM_TOP' => url('.php?sort=com&mode=desc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=com&mode=desc'), 'U_ARTICLES_COM_BOTTOM' => url('.php?sort=com&mode=asc&cat=' . $idartcat, '-' . $idartcat . '+' . $rewrite_title . '.php?sort=com&mode=asc'))); $get_sort = retrieve(GET, 'sort', ''); switch ($get_sort) { case 'alpha': $sort = 'title'; break; case 'date': $sort = 'timestamp'; break; case 'view': $sort = 'views'; break; case 'note': $sort = 'note/' . $CONFIG_ARTICLES['note_max']; break; case 'com': $sort = 'nbr_com'; break; default: $sort = 'timestamp'; } $get_mode = retrieve(GET, 'mode', ''); $mode = $get_mode == 'asc' ? 'ASC' : 'DESC'; $unget = !empty($get_sort) && !empty($mode) ? '?sort=' . $get_sort . '&mode=' . $get_mode : ''; import('util/pagination'); $Pagination = new Pagination(); $unauth_cats_sql = array(); foreach ($CAT_ARTICLES as $id => $key) { if (!$User->check_auth($CAT_ARTICLES[$id]['auth'], READ_CAT_ARTICLES)) { $unauth_cats_sql[] = $id; } } $nbr_unauth_cats = count($unauth_cats_sql); $clause_unauth_cats = $nbr_unauth_cats > 0 ? " AND ac.id NOT IN (" . implode(', ', $unauth_cats_sql) . ")" : ''; ##### Catégories disponibles ##### if ($total_cat > 0) { $tpl->assign_vars(array('C_ARTICLES_CAT' => true, 'PAGINATION_CAT' => $Pagination->display('articles' . url('.php' . (!empty($unget) ? $unget . '&' : '?') . 'cat=' . $idartcat . '&pcat=%d', '-' . $idartcat . '-0+' . $rewrite_title . '.php?pcat=%d' . $unget), $total_cat, 'pcat', $CONFIG_ARTICLES['nbr_cat_max'], 3))); $i = 0; $result = $Sql->query_while("SELECT ac.id, ac.name, ac.contents, ac.icon, ac.nbr_articles_visible AS nbr_articles\n\t\t\tFROM " . PREFIX . "articles_cats ac\n\t\t\t" . $clause_cat . $clause_unauth_cats . "\n\t\t\tORDER BY ac.id_left\n\t\t\t" . $Sql->limit($Pagination->get_first_msg($CONFIG_ARTICLES['nbr_cat_max'], 'pcat'), $CONFIG_ARTICLES['nbr_cat_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $tpl->assign_block_vars('cat_list', array('IDCAT' => $row['id'], 'CAT' => $row['name'], 'DESC' => $row['contents'], 'ICON_CAT' => !empty($row['icon']) ? '<a href="articles' . url('.php?cat=' . $row['id'], '-' . $row['id'] . '+' . url_encode_rewrite($row['name']) . '.php') . '"><img src="' . $row['icon'] . '" alt="" class="valign_middle" /></a><br />' : '', 'EDIT' => $is_admin ? '<a href="admin_articles_cat.php?id=' . $row['id'] . '"><img class="valign_middle" src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/edit.png" alt="" /></a>' : '', 'L_NBR_ARTICLES' => sprintf($LANG['nbr_articles_info'], $row['nbr_articles']), 'U_CAT' => url('.php?cat=' . $row['id'], '-' . $row['id'] . '+' . url_encode_rewrite($row['name']) . '.php'))); } $Sql->query_close($result); } ##### Affichage des articles ##### if ($nbr_articles > 0) { $tpl->assign_vars(array('C_ARTICLES_LINK' => true, 'PAGINATION' => $Pagination->display('articles' . url('.php' . (!empty($unget) ? $unget . '&' : '?') . 'cat=' . $idartcat . '&p=%d', '-' . $idartcat . '-0-%d+' . $rewrite_title . '.php' . $unget), $nbr_articles, 'p', $CONFIG_ARTICLES['nbr_articles_max'], 3), 'CAT' => $CAT_ARTICLES[$idartcat]['name'])); import('content/note'); $result = $Sql->query_while("SELECT id, title, icon, timestamp, views, note, nbrnote, nbr_com\n\t\t\tFROM " . PREFIX . "articles\n\t\t\tWHERE visible = 1 AND idcat = '" . $idartcat . "'\n\t\t\tORDER BY " . $sort . " " . $mode . $Sql->limit($Pagination->get_first_msg($CONFIG_ARTICLES['nbr_articles_max'], 'p'), $CONFIG_ARTICLES['nbr_articles_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $fichier = strlen($row['title']) > 45 ? substr(html_entity_decode($row['title'], ENT_COMPAT, 'ISO-8859-1'), 0, 45) . '...' : $row['title']; $tpl->assign_block_vars('articles', array('NAME' => $row['title'], 'ICON' => !empty($row['icon']) ? '<a href="articles' . url('.php?id=' . $row['id'] . '&cat=' . $idartcat, '-' . $idartcat . '-' . $row['id'] . '+' . url_encode_rewrite($fichier) . '.php') . '"><img src="' . $row['icon'] . '" alt="" class="valign_middle" /></a>' : '', 'CAT' => $CAT_ARTICLES[$idartcat]['name'], 'DATE' => gmdate_format('date_format_short', $row['timestamp']), 'COMPT' => $row['views'], 'NOTE' => $row['nbrnote'] > 0 ? Note::display_img($row['note'], $CONFIG_ARTICLES['note_max'], 5) : '<em>' . $LANG['no_note'] . '</em>', 'COM' => $row['nbr_com'], 'U_ARTICLES_LINK' => url('.php?id=' . $row['id'] . '&cat=' . $idartcat, '-' . $idartcat . '-' . $row['id'] . '+' . url_encode_rewrite($fichier) . '.php'))); } $Sql->query_close($result); } return $tpl->parse(TRUE); }
<?php require_once '../admin/admin_begin.php'; load_module_lang('download'); define('TITLE', $LANG['administration']); require_once '../admin/admin_header.php'; $Cache->load('download'); $Template->set_filenames(array('admin_download_management' => 'download/admin_download_management.tpl')); $nbr_dl = $Sql->count_table('download', __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('THEME' => get_utheme(), 'LANG' => get_ulang(), 'PAGINATION' => $Pagination->display('admin_download.php?p=%d', $nbr_dl, 'p', 25, 3), 'L_DEL_ENTRY' => $LANG['del_entry'], 'L_DOWNLOAD_ADD' => $DOWNLOAD_LANG['download_add'], 'L_DOWNLOAD_MANAGEMENT' => $DOWNLOAD_LANG['download_management'], 'L_DOWNLOAD_CAT' => $LANG['cat_management'], 'L_DOWNLOAD_CONFIG' => $DOWNLOAD_LANG['download_config'], 'L_CATEGORY' => $LANG['category'], 'L_SIZE' => $LANG['size'], 'L_TITLE' => $LANG['title'], 'L_APROB' => $LANG['aprob'], 'L_UPDATE' => $LANG['update'], 'L_DELETE' => $LANG['delete'], 'L_DATE' => $LANG['date'], 'L_CONFIRM_DELETE' => str_replace('\'', '\\\'', $DOWNLOAD_LANG['confirm_delete_file']))); $result = $Sql->query_while("SELECT id, idcat, title, timestamp, approved, start, end, size\nFROM " . PREFIX . "download\nORDER BY timestamp DESC \n" . $Sql->limit($Pagination->get_first_msg(25, 'p'), 25), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { if ($row['approved'] == 1) { $aprob = $LANG['yes']; } else { $aprob = $LANG['no']; } $title =& $row['title']; $title = strlen($title) > 45 ? substr($title, 0, 45) . '...' : $title; $Template->assign_block_vars('list', array('TITLE' => $title, 'IDCAT' => $row['idcat'], 'CAT' => $row['idcat'] > 0 ? $DOWNLOAD_CATS[$row['idcat']]['name'] : $LANG['root'], 'PSEUDO' => !empty($row['login']) ? $row['login'] : $LANG['guest'], 'DATE' => gmdate_format('date_format_short', $row['timestamp']), 'SIZE' => $row['size'] >= 1 ? number_round($row['size'], 1) . ' ' . $LANG['unit_megabytes'] : number_round($row['size'] * 2524, 1) . ' ' . $LANG['unit_kilobytes'], 'APROBATION' => $aprob, 'U_FILE' => url('download.php?id=' . $row['id'], 'download-' . $row['id'] . '+' . url_encode_rewrite($row['title']) . '.php'), 'U_EDIT_FILE' => url('management.php?edit=' . $row['id']), 'U_DEL_FILE' => url('management.php?del=' . $row['id'] . '&token=' . $Session->get_token()))); } $Sql->query_close($result); include_once 'admin_download_menu.php'; $Template->pparse('admin_download_management'); require_once '../admin/admin_footer.php';
function display($integrated_in_environment = INTEGRATED_IN_ENVIRONMENT, $Template = false, $page_path_to_root = '') { global $Cache, $User, $Errorh, $Sql, $LANG, $CONFIG, $CONFIG_USER, $CONFIG_COM, $_array_rank, $_array_groups_auth, $Session; if ($integrated_in_environment) { $idcom_get = retrieve(GET, 'com', 0); $idcom_post = retrieve(POST, 'idcom', 0); $idcom = $idcom_post > 0 ? $idcom_post : $idcom_get; $this->set_arg($idcom); } $vars_simple = sprintf($this->vars, 0); $delcom = retrieve(GET, 'delcom', 0); $editcom = retrieve(GET, 'editcom', 0); $updatecom = retrieve(GET, 'updatecom', false); $path_redirect = $this->path . sprintf(str_replace('&', '&', $this->vars), 0) . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : ''); if (!is_object($Template) || strtolower(get_class($Template)) != 'template') { $Template = new Template('framework/content/com.tpl'); } if ($this->is_loaded()) { $Cache->load('com'); import('util/captcha'); $captcha = new Captcha(); $captcha->set_difficulty($CONFIG_COM['com_verif_code_difficulty']); ###########################Insertion############################## if (retrieve(POST, 'valid_com', false) && !$updatecom) { if ($User->get_attribute('user_readonly') > time()) { $Errorh->handler('e_auth', E_USER_REDIRECT); } $login = retrieve(POST, 'login', ''); $contents = retrieve(POST, 'contents', '', TSTRING_UNCHANGE); if (!empty($login) && !empty($contents)) { if ($this->lock_com >= 1 && !$User->check_level(MODO_LEVEL)) { redirect($path_redirect); } if ($User->check_level($CONFIG_COM['com_auth'])) { $check_time = $User->get_attribute('user_id') !== -1 && $CONFIG['anti_flood'] == 1 ? $Sql->query("SELECT MAX(timestamp) as timestamp FROM " . DB_TABLE_COM . " 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($path_redirect . '&errorh=flood#errorh'); } } if ($CONFIG_COM['com_verif_code'] && !$captcha->is_valid()) { redirect($path_redirect . '&errorh=verif#errorh'); } $contents = strparse($contents, $CONFIG_COM['forbidden_tags']); if (!check_nbr_links($login, 0)) { redirect($path_redirect . '&errorh=l_pseudo#errorh'); } if (!check_nbr_links($contents, $CONFIG_COM['max_link'])) { redirect($path_redirect . '&errorh=l_flood#errorh'); } $last_idcom = $this->add($contents, $login); redirect($path_redirect . '#m' . $last_idcom); } else { redirect($path_redirect . '&errorh=auth#errorh'); } } else { redirect($path_redirect . '&errorh=incomplete#errorh'); } } elseif ($updatecom || $delcom > 0 || $editcom > 0) { if ($User->get_attribute('user_readonly') > time()) { $Errorh->handler('e_auth', E_USER_REDIRECT); } $row = $Sql->query_array(DB_TABLE_COM, '*', "WHERE idcom = '" . $this->idcom . "' AND idprov = '" . $this->idprov . "' AND script = '" . $this->script . "'", __LINE__, __FILE__); $row['user_id'] = (int) $row['user_id']; if ($this->idcom != 0 && ($User->check_level(MODO_LEVEL) || $row['user_id'] === $User->get_attribute('user_id') && $User->get_attribute('user_id') !== -1)) { if ($delcom > 0) { $Session->csrf_get_protect(); $lastid_com = $this->del(); $lastid_com = !empty($lastid_com) ? '#m' . $lastid_com : ''; redirect($path_redirect . $lastid_com); } elseif ($editcom > 0) { $Template->assign_vars(array('CURRENT_PAGE_COM' => $integrated_in_environment, 'POPUP_PAGE_COM' => !$integrated_in_environment, 'AUTH_POST_COM' => true)); if ($row['user_id'] !== -1) { $Template->assign_vars(array('C_HIDDEN_COM' => true, 'LOGIN' => $User->get_attribute('login'))); } else { $Template->assign_vars(array('C_VISIBLE_COM' => true, 'LOGIN' => $row['login'])); } $Template->assign_vars(array('IDPROV' => $row['idprov'], 'IDCOM' => $row['idcom'], 'SCRIPT' => $this->script, 'CONTENTS' => unparse($row['contents']), 'DATE' => gmdate_format('date_format', $row['timestamp']), 'THEME' => get_utheme(), 'KERNEL_EDITOR' => display_editor($this->script . 'contents', $CONFIG_COM['forbidden_tags']), 'L_LANGUAGE' => substr(get_ulang(), 0, 2), 'L_EDIT_COMMENT' => $LANG['edit_comment'], 'L_REQUIRE_LOGIN' => $LANG['require_pseudo'], 'L_REQUIRE_TEXT' => $LANG['require_text'], 'L_DELETE_MESSAGE' => $LANG['alert_delete_msg'], 'L_LOGIN' => $LANG['pseudo'], 'L_MESSAGE' => $LANG['message'], 'L_RESET' => $LANG['reset'], 'L_PREVIEW' => $LANG['preview'], 'L_PREVIEW' => $LANG['preview'], 'L_SUBMIT' => $LANG['update'], 'U_ACTION' => $this->path . sprintf($this->vars, $this->idcom) . '&token=' . $Session->get_token() . '&updatecom=1' . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : ''))); } elseif ($updatecom) { $contents = retrieve(POST, 'contents', '', TSTRING_UNCHANGE); $login = retrieve(POST, 'login', ''); if (!empty($contents) && !empty($login)) { $contents = strparse($contents, $CONFIG_COM['forbidden_tags']); if (!check_nbr_links($contents, $CONFIG_COM['max_link'])) { redirect($path_redirect . '&errorh=l_flood#errorh'); } $this->update($contents, $login); redirect($path_redirect . '#m' . $this->idcom); } else { redirect($path_redirect . '&errorh=incomplete#errorh'); } } else { redirect($path_redirect . '&errorh=incomplete#errorh'); } } else { $Errorh->handler('e_auth', E_USER_REDIRECT); } } elseif (isset($_GET['lock']) && $User->check_level(MODO_LEVEL)) { $Session->csrf_get_protect(); if ($User->check_level(MODO_LEVEL)) { $lock = retrieve(GET, 'lock', 0); $this->lock($lock); } redirect($path_redirect . '#anchor_' . $this->script); } else { ###########################Affichage############################## $get_quote = retrieve(GET, 'quote', 0); $contents = ''; if ($get_quote > 0) { $info_com = $Sql->query_array(DB_TABLE_COM, 'login', 'contents', "WHERE script = '" . $this->script . "' AND idprov = '" . $this->idprov . "' AND idcom = '" . $get_quote . "'", __LINE__, __FILE__); $contents = '[quote=' . $info_com['login'] . ']' . $info_com['contents'] . '[/quote]'; } import('util/pagination'); $pagination = new Pagination(); $Template->assign_vars(array('ERROR_HANDLER' => '', 'CURRENT_PAGE_COM' => $integrated_in_environment, 'POPUP_PAGE_COM' => !$integrated_in_environment)); if ($User->check_level(MODO_LEVEL)) { $Template->assign_vars(array('COM_LOCK' => true, 'IMG' => $this->lock_com >= 1 ? 'unlock' : 'lock', 'L_LOCK' => $this->lock_com >= 1 ? $LANG['unlock'] : $LANG['lock'], 'U_LOCK' => $this->path . ($this->lock_com >= 1 ? $vars_simple . '&lock=0&token=' . $Session->get_token() : $vars_simple . '&lock=1&token=' . $Session->get_token()) . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : ''))); } $get_error = !empty($_GET['errorh']) ? trim($_GET['errorh']) : ''; $errno = E_USER_NOTICE; switch ($get_error) { case 'auth': $errstr = $LANG['e_unauthorized']; $errno = E_USER_WARNING; break; case 'verif': $errstr = $LANG['e_incorrect_verif_code']; $errno = E_USER_WARNING; break; case 'l_flood': $errstr = sprintf($LANG['e_l_flood'], $CONFIG_COM['max_link']); break; case 'l_pseudo': $errstr = $LANG['e_link_pseudo']; break; case 'flood': $errstr = $LANG['e_flood']; break; case 'incomplete': $errstr = $LANG['e_incomplete']; break; default: $errstr = ''; } $Errorh->set_template($Template); if (!empty($errstr)) { $Template->assign_vars(array('ERROR_HANDLER' => $Errorh->display($errstr, E_USER_NOTICE))); } if (!$this->lock_com || $User->check_level(MODO_LEVEL)) { if ($captcha->is_available() && $CONFIG_COM['com_verif_code']) { $Template->assign_vars(array('C_VERIF_CODE' => true, 'VERIF_CODE' => $captcha->display_form(), 'L_REQUIRE_VERIF_CODE' => $captcha->js_require())); } if ($User->check_level($CONFIG_COM['com_auth'])) { $Template->assign_vars(array('AUTH_POST_COM' => true)); } else { $Template->assign_vars(array('ERROR_HANDLER' => $Errorh->display($LANG['e_unauthorized'], E_USER_NOTICE))); } if ($User->get_attribute('user_id') !== -1) { $Template->assign_vars(array('C_HIDDEN_COM' => true, 'LOGIN' => $User->get_attribute('login'))); } else { $Template->assign_vars(array('C_VISIBLE_COM' => true, 'LOGIN' => $LANG['guest'])); } } else { $Template->assign_vars(array('ERROR_HANDLER' => $Errorh->display($LANG['com_locked'], E_USER_NOTICE))); } $get_pos = strpos($_SERVER['QUERY_STRING'], '&pc'); if ($get_pos) { $get_page = substr($_SERVER['QUERY_STRING'], 0, $get_pos) . '&pc'; } else { $get_page = $_SERVER['QUERY_STRING'] . '&pc'; } $is_modo = $User->check_level(MODO_LEVEL); $Template->assign_vars(array('C_COM_DISPLAY' => $this->get_attribute('nbr_com') > 0 ? true : false, 'C_IS_MODERATOR' => $is_modo, 'PAGINATION_COM' => $pagination->display($this->path . $vars_simple . '&pc=%d#anchor_' . $this->script, $this->nbr_com, 'pc', $CONFIG_COM['com_max'], 3), 'LANG' => get_ulang(), 'IDCOM' => '', 'IDPROV' => $this->idprov, 'SCRIPT' => $this->script, 'PATH' => SCRIPT, 'UPDATE' => $integrated_in_environment == true ? SID : '', 'VAR' => $vars_simple, 'KERNEL_EDITOR' => display_editor($this->script . 'contents', $CONFIG_COM['forbidden_tags']), 'C_BBCODE_TINYMCE_MODE' => $User->get_attribute('user_editor') == 'tinymce', 'L_XML_LANGUAGE' => $LANG['xml_lang'], 'L_TITLE' => $CONFIG['com_popup'] == 0 || $integrated_in_environment === true ? $LANG['title_com'] : '', 'THEME' => get_utheme(), 'CONTENTS' => unparse($contents), 'L_REQUIRE_LOGIN' => $LANG['require_pseudo'], 'L_REQUIRE_TEXT' => $LANG['require_text'], 'L_VERIF_CODE' => $LANG['verif_code'], 'L_DELETE_MESSAGE' => $LANG['alert_delete_msg'], 'L_ADD_COMMENT' => $LANG['add_comment'], 'L_PUNISHMENT_MANAGEMENT' => $LANG['punishment_management'], 'L_WARNING_MANAGEMENT' => $LANG['warning_management'], 'L_LOGIN' => $LANG['pseudo'], 'L_MESSAGE' => $LANG['message'], 'L_QUOTE' => $LANG['quote'], 'L_RESET' => $LANG['reset'], 'L_PREVIEW' => $LANG['preview'], 'L_SUBMIT' => $LANG['submit'], 'U_ACTION' => $this->path . sprintf($this->vars, $this->idcom) . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '') . '&token=' . $Session->get_token())); $array_ranks = array(-1 => $LANG['guest'], 0 => $LANG['member'], 1 => $LANG['modo'], 2 => $LANG['admin']); $Cache->load('ranks'); $j = 0; $result = $Sql->query_while("SELECT c.idprov, c.idcom, c.login, c.timestamp, m.user_id, m.login as mlogin, m.level, m.user_mail, m.user_show_mail, m.timestamp AS registered, m.user_avatar, m.user_msg, m.user_local, m.user_web, m.user_sex, m.user_msn, m.user_yahoo, m.user_sign, m.user_warning, m.user_ban, m.user_groups, s.user_id AS connect, c.contents\n\t\t\t\tFROM " . DB_TABLE_COM . " c\n\t\t\t\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = c.user_id\n\t\t\t\tLEFT JOIN " . DB_TABLE_SESSIONS . " s ON s.user_id = c.user_id AND s.session_time > '" . (time() - $CONFIG['site_session_invit']) . "'\n\t\t\t\tWHERE c.script = '" . $this->script . "' AND c.idprov = '" . $this->idprov . "'\n\t\t\t\tGROUP BY c.idcom\n\t\t\t\tORDER BY c.timestamp DESC\n\t\t\t\t" . $Sql->limit($pagination->get_first_msg($CONFIG_COM['com_max'], 'pc'), $CONFIG_COM['com_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { list($edit, $del) = array(false, false); $is_guest = empty($row['user_id']); if ($is_modo || $row['user_id'] == $User->get_attribute('user_id') && $User->get_attribute('user_id') !== -1) { list($edit, $del) = array(true, true); } if (!$is_guest) { $com_pseudo = '<a class="msg_link_pseudo" href="' . PATH_TO_ROOT . '/member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '" title="' . $row['mlogin'] . '"><span style="font-weight: bold;">' . wordwrap_html($row['mlogin'], 13) . '</span></a>'; } else { $com_pseudo = '<span style="font-style:italic;">' . (!empty($row['login']) ? wordwrap_html($row['login'], 13) : $LANG['guest']) . '</span>'; } $user_rank = $row['level'] === '0' ? $LANG['member'] : $LANG['guest']; $user_group = $user_rank; $user_rank_icon = ''; if ($row['level'] === '2') { $user_rank = $_array_rank[-2][0]; $user_group = $user_rank; $user_rank_icon = $_array_rank[-2][1]; } elseif ($row['level'] === '1') { $user_rank = $_array_rank[-1][0]; $user_group = $user_rank; $user_rank_icon = $_array_rank[-1][1]; } else { foreach ($_array_rank as $msg => $ranks_info) { if ($msg >= 0 && $msg <= $row['user_msg']) { $user_rank = $ranks_info[0]; $user_rank_icon = $ranks_info[1]; break; } } } $user_assoc_img = !empty($user_rank_icon) ? '<img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/ranks/' . $user_rank_icon . '" alt="" />' : ''; if (!empty($row['user_groups']) && $_array_groups_auth) { $user_groups = ''; $array_user_groups = explode('|', $row['user_groups']); foreach ($_array_groups_auth as $idgroup => $array_group_info) { if (is_numeric(array_search($idgroup, $array_user_groups))) { $user_groups .= !empty($array_group_info['img']) ? '<img src="' . PATH_TO_ROOT . '/images/group/' . $array_group_info['img'] . '" alt="' . $array_group_info['name'] . '" title="' . $array_group_info['name'] . '"/><br />' : $LANG['group'] . ': ' . $array_group_info['name']; } } } else { $user_groups = $LANG['group'] . ': ' . $user_group; } $user_online = !empty($row['connect']) ? 'online' : 'offline'; if (empty($row['user_avatar'])) { $user_avatar = $CONFIG_USER['activ_avatar'] == '1' && !empty($CONFIG_USER['avatar_url']) ? '<img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . $CONFIG_USER['avatar_url'] . '" alt="" />' : ''; } else { $user_avatar = '<img src="' . $row['user_avatar'] . '" alt="" />'; } $user_sex = ''; if ($row['user_sex'] == 1) { $user_sex = $LANG['sex'] . ': <img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/man.png" alt="" /><br />'; } elseif ($row['user_sex'] == 2) { $user_sex = $LANG['sex'] . ': <img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/woman.png" alt="" /><br />'; } $user_msg = $row['user_msg'] > 1 ? $LANG['message_s'] . ': ' . $row['user_msg'] : $LANG['message'] . ': ' . $row['user_msg']; if (!empty($row['user_local'])) { $user_local = $LANG['place'] . ': ' . $row['user_local']; $user_local = $user_local > 15 ? substr_html($user_local, 0, 15) . '...<br />' : $user_local . '<br />'; } else { $user_local = ''; } $contents = ucfirst(second_parse($row['contents'])); if (!$integrated_in_environment && !empty($page_path_to_root)) { $contents = str_replace('"' . $page_path_to_root . '/', '"' . PATH_TO_ROOT . '/', $contents); } $Template->assign_block_vars('com_list', array('ID' => $row['idcom'], 'CONTENTS' => $contents, 'DATE' => $LANG['on'] . ': ' . gmdate_format('date_format', $row['timestamp']), 'CLASS_COLOR' => $j % 2 == 0 ? '' : 2, 'USER_ONLINE' => '<img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . $user_online . '.png" alt="" class="valign_middle" />', 'USER_PSEUDO' => $com_pseudo, 'USER_RANK' => $row['user_warning'] < '100' || time() - $row['user_ban'] < 0 ? $user_rank : $LANG['banned'], 'USER_IMG_ASSOC' => $user_assoc_img, 'USER_AVATAR' => $user_avatar, 'USER_GROUP' => $user_groups, 'USER_DATE' => !$is_guest ? $LANG['registered_on'] . ': ' . gmdate_format('date_format_short', $row['registered']) : '', 'USER_SEX' => $user_sex, 'USER_MSG' => !$is_guest ? $user_msg : '', 'USER_LOCAL' => $user_local, 'USER_MAIL' => !empty($row['user_mail']) && $row['user_show_mail'] == '1' ? '<a href="mailto:' . $row['user_mail'] . '"><img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . get_ulang() . '/email.png" alt="' . $row['user_mail'] . '" title="' . $row['user_mail'] . '" /></a>' : '', 'USER_MSN' => !empty($row['user_msn']) ? '<a href="mailto:' . $row['user_msn'] . '"><img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . get_ulang() . '/msn.png" alt="' . $row['user_msn'] . '" title="' . $row['user_msn'] . '" /></a>' : '', 'USER_YAHOO' => !empty($row['user_yahoo']) ? '<a href="mailto:' . $row['user_yahoo'] . '"><img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . get_ulang() . '/yahoo.png" alt="' . $row['user_yahoo'] . '" title="' . $row['user_yahoo'] . '" /></a>' : '', 'USER_SIGN' => !empty($row['user_sign']) ? '____________________<br />' . second_parse($row['user_sign']) : '', 'USER_WEB' => !empty($row['user_web']) ? '<a href="' . $row['user_web'] . '"><img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . get_ulang() . '/user_web.png" alt="' . $row['user_web'] . '" title="' . $row['user_yahoo'] . '" /></a>' : '', 'USER_WARNING' => !empty($row['user_warning']) ? $row['user_warning'] : '0', 'C_COM_MSG_EDIT' => $del, 'C_COM_MSG_DEL' => $edit, 'U_COM_EDIT' => $this->path . sprintf($this->vars, $row['idcom']) . '&editcom=1' . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '') . '#anchor_' . $this->script, 'U_COM_DEL' => $this->path . sprintf($this->vars, $row['idcom']) . '&token=' . $Session->get_token() . '&delcom=1' . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '') . '#anchor_' . $this->script, 'U_COM_WARNING' => $is_modo && !$is_guest ? PATH_TO_ROOT . '/member/moderation_panel' . url('.php?action=warning&id=' . $row['user_id'] . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '')) . '" title="' . $LANG['warning_management'] : '', 'U_COM_PUNISHEMENT' => $is_modo && !$is_guest ? PATH_TO_ROOT . '/member/moderation_panel' . url('.php?action=punish&id=' . $row['user_id'] . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '')) . '" title="' . $LANG['punishment_management'] : '', 'U_USER_PM' => !$is_guest ? '<a href="' . PATH_TO_ROOT . '/member/pm' . url('.php?pm=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '"><img src="' . PATH_TO_ROOT . '/templates/' . get_utheme() . '/images/' . get_ulang() . '/pm.png" alt="" /></a>' : '', 'U_ANCHOR' => $this->path . $vars_simple . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '') . '#m' . $row['idcom'], 'U_QUOTE' => $this->path . sprintf($this->vars, $row['idcom']) . '&quote=' . $row['idcom'] . (!empty($page_path_to_root) && !$integrated_in_environment ? '&path_to_root=' . $page_path_to_root : '') . '#anchor_' . $this->script)); $j++; } $Sql->query_close($result); } return $Template->parse(TEMPLATE_STRING_MODE); } else { return 'error : class Comments loaded uncorrectly'; } }
if ($state == "visible") { $db_where = MEDIA_STATUS_APROBED; } elseif ($state == 'unvisible') { $db_where = MEDIA_STATUS_UNVISIBLE; } elseif ($state == 'unaprobed') { $db_where = MEDIA_STATUS_UNAPROBED; } else { $db_where = null; } if ($sub_cats) { $media_categories->build_children_id_list($cat, $array_cats, RECURSIVE_EXPLORATION, ADD_THIS_CATEGORY_IN_LIST, MEDIA_AUTH_READ); } } else { $cat = 0; $db_where = $sub_cats = null; $media_categories->build_children_id_list(0, $array_cats, RECURSIVE_EXPLORATION, ADD_THIS_CATEGORY_IN_LIST, MEDIA_AUTH_READ); } import('util/pagination'); $Pagination = new Pagination(); $nbr_media = 0; $result = $Sql->query_while("SELECT * FROM " . PREFIX . "media WHERE " . (!empty($array_cats) ? 'idcat IN (' . "'" . implode("', '", $array_cats) . "'" . ')' : 'idcat=' . (!empty($cat) ? $cat : 0)) . (is_null($db_where) ? '' : ' AND infos=' . $db_where) . " ORDER BY infos ASC, timestamp DESC" . $Sql->limit($Pagination->get_first_msg(NUM_MODO_MEDIA, 'p'), NUM_MODO_MEDIA), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $nbr_media++; $js_array[] = $row['id']; $Template->assign_block_vars('files', array('ID' => $row['id'], 'NAME' => $row['name'], 'U_FILE' => url('media.php?id=' . $row['id'], 'media-' . $row['id'] . '-' . $row['idcat'] . '+' . url_encode_rewrite($row['name']) . '.php'), 'U_EDIT' => url('media_action.php?edit=' . $row['id']), 'CAT' => !empty($MEDIA_CATS[$row['idcat']]) ? $MEDIA_CATS[$row['idcat']]['name'] : $LANG['unknow'], 'U_CAT' => url('media.php?cat=' . $row['idcat']), 'COLOR' => $row['infos'] == MEDIA_STATUS_UNVISIBLE ? '#FFEE99' : ($row['infos'] == MEDIA_STATUS_APROBED ? '#CCFFCC' : '#FFCCCC'), 'SHOW' => $row['infos'] == MEDIA_STATUS_APROBED ? ' checked="checked"' : '', 'HIDE' => $row['infos'] == MEDIA_STATUS_UNVISIBLE ? ' checked="checked"' : '', 'UNAPROBED' => $row['infos'] == MEDIA_STATUS_UNAPROBED ? ' checked="checked"' : '')); } $Sql->query_close($result); $Template->assign_vars(array('C_DISPLAY' => 1, 'L_FILTER' => $MEDIA_LANG['filter'], 'L_DISPLAY_FILE' => $MEDIA_LANG['display_file'], 'L_ALL' => $MEDIA_LANG['all_file'], 'SELECTED_ALL' => is_null($db_where) ? ' selected="selected"' : '', 'L_FVISIBLE' => $MEDIA_LANG['visible'], 'SELECTED_VISIBLE' => $db_where === MEDIA_STATUS_APROBED ? ' selected="selected"' : '', 'L_FUNVISIBLE' => $MEDIA_LANG['unvisible'], 'SELECTED_UNVISIBLE' => $db_where === MEDIA_STATUS_UNVISIBLE ? ' selected="selected"' : '', 'L_FUNAPROBED' => $MEDIA_LANG['unaprobed'], 'SELECTED_UNAPROBED' => $db_where === MEDIA_STATUS_UNAPROBED ? ' selected="selected"' : '', 'L_CATEGORIES' => $MEDIA_LANG['from_cats'], 'CATEGORIES_TREE' => $media_categories->build_select_form($cat, 'idcat', 'idcat', 0, MEDIA_AUTH_READ, $MEDIA_CATS[$cat]['auth']), 'L_INCLUDE_SUB_CATS' => $MEDIA_LANG['include_sub_cats'], 'SUB_CATS' => is_null($sub_cats) ? ' checked="checked"' : ($sub_cats ? ' checked="checked"' : ''), 'L_MODO_PANEL' => $LANG['modo_panel'], 'L_NAME' => $LANG['name'], 'L_CATEGORY' => $LANG['category'], 'L_VISIBLE' => $MEDIA_LANG['show_media_short'], 'L_UNVISIBLE' => $MEDIA_LANG['hide_media_short'], 'L_UNAPROBED' => $MEDIA_LANG['unaprobed_media_short'], 'L_DELETE' => $LANG['delete'], 'C_NO_MODERATION' => $nbr_media > 0 ? 0 : 1, 'L_NO_MODERATION' => $MEDIA_LANG['no_media_moderate'], 'L_CONFIRM_DELETE' => str_replace('\'', '\\\'', $MEDIA_LANG['confirm_delete_media']), 'L_CONFIRM_DELETE_ALL' => str_replace('\'', '\\\'', $MEDIA_LANG['confirm_delete_media_all']), 'L_LEGEND' => $MEDIA_LANG['legend'], 'L_FILE_UNAPROBED' => $MEDIA_LANG['file_unaprobed'], 'L_FILE_UNVISIBLE' => $MEDIA_LANG['file_unvisible'], 'L_FILE_VISIBLE' => $MEDIA_LANG['file_visible'], 'PAGINATION' => $Pagination->display('moderation_media.php?p=%d', $nbr_media, 'p', NUM_MODO_MEDIA, 3), 'L_SUBMIT' => $LANG['submit'], 'L_RESET' => $LANG['reset'], 'C_ADMIN' => $User->check_level(ADMIN_LEVEL), 'L_RECOUNT_MEDIA' => $MEDIA_LANG['recount_per_cat'], 'JS_ARRAY' => '"' . implode('", "', $js_array) . '"')); } $Template->pparse('media_moderation'); require_once '../kernel/footer.php';
<td title="<?php echo $user->activity; ?> "><?php echo get_timeago($user->activity); ?> </td> <td><?php echo $user->ip_address; ?> </td> </tr> <?php } ?> </tbody> </table> <br> <?php echo $pag->display(true); ?> </div> </div> </div> <?php include ROOT_PATH . 'inc/footer.php'; ?> </body> </html>
function index() { global $path; global $template; $conditionspre = ''; $conditionspost = ''; $conditionsselect = ''; $extratitle = ''; $orderby = "newest"; $order = 'created desc'; $defaultorder = 1; $nopagination = 0; $page = 1; $searchstringoriginal = ''; if (!empty($_GET['search'])) { $searchstringoriginal = sanitize($_GET['search'], "string"); } if (!empty($_GET['order'])) { if ($_GET['order'] == "votes") { $order = "votes desc"; $orderby = "votes"; $defaultorder = 0; } else { if ($_GET['order'] == "oldest") { $order = "created asc"; $orderby = "oldest"; $defaultorder = 0; } else { if ($_GET['order'] == "relevance") { $order = "score desc"; $orderby = "relevance"; $defaultorder = 0; } else { if ($_GET['order'] == "newest") { $defaultorder = 0; } } } } } if (!empty($_GET['page'])) { $page = sanitize($_GET['page'], "int"); } $type = ''; if (!empty($_GET['type'])) { $type = "&type=" . sanitize($_GET['type'], "string"); if (sanitize($_GET['type'], "string") == "unanswered") { // $conditionspost .= " questions.id NOT IN (select questions.id from questions,answers where questions.id = answers.questionid and answers.accepted = 1) and "; $conditionspost .= " questions.accepted = 0 and questions.kb = 0 and "; $extratitle = " " . _("not yet answered"); } else { $extratitle = " " . _("active"); $order = " updated desc "; $nopagination = 1; } } $template->set('nopagination', $nopagination); $search = ''; $searchstring = urldecode($searchstringoriginal); if (!empty($searchstringoriginal)) { $search = "&search=" . urlencode($searchstring); $conditionspost .= " MATCH(title, description) AGAINST ('" . escape($searchstring) . "') and "; $conditionsselect .= ",MATCH(title, description) AGAINST ('" . escape($searchstring) . "') AS score "; $extratitle = " " . _("showing") . " " . $searchstring; if ($defaultorder == 1) { $orderby = "relevance"; $order = 'score desc'; } } $template->set('searchstring', $searchstring); $tag = ''; if (!empty($_GET['tag'])) { $tag = "&tag=" . createSlug($_GET['tag']); $conditionspre .= ",tags_questions, tags"; $conditionspost .= " tags_questions.questionid = questions.id and tags.id = tags_questions.tagid and tags.tag LIKE '" . escape(createSlug($_GET['tag'])) . "' and "; $extratitle = " " . _("tagged") . " " . createSlug($_GET['tag']); } $offset = ($page - 1) * QUESTIONS_PER_PAGE; $sql = "select count(questions.id) count from questions {$conditionspre} WHERE {$conditionspost} 1"; $query = mysql_query($sql); $result = mysql_fetch_array($query); $template->set('questionscount', $result['count']); $paging = new Pagination(); $paging->set('urlscheme', '?order=' . $orderby . $tag . $type . $search . '&page=%page%'); $paging->set('perpage', QUESTIONS_PER_PAGE); $paging->set('page', $page); $paging->set('total', $result['count']); $paging->set('order', $orderby); $paging->set('search', $search); $template->set('pagination', $paging->display()); $paging->set('urlscheme', '?order=%label%' . $tag . $type . $search . '&page=1'); $template->set('orderOptions', $paging->displayOptions()); $template->set('extratitle', $extratitle); $sql = "select questions.* {$conditionsselect} from questions {$conditionspre} WHERE {$conditionspost} 1 order by {$order}, created desc LIMIT " . QUESTIONS_PER_PAGE . " OFFSET {$offset}"; $query = mysql_query($sql); $questions = array(); while ($result = mysql_fetch_array($query)) { $sql_nest = "select tag from tags_questions, tags where questionid = '" . escape($result['id']) . "' and tags.id = tags_questions.tagid order by tag"; $query_nest = mysql_query($sql_nest); $tags = array(); while ($result_nest = mysql_fetch_array($query_nest)) { $tags[] = $result_nest['tag']; } $description = truncate(trim(sanitize(Markdown($result['description']), "string"))); if (!empty($searchstring)) { $description = highlight(excerpt(trim(sanitize(Markdown($result['description']), "string")), $searchstring), $searchstring); $result['title'] = highlight($result['title'], $searchstring); } $questions[] = array("title" => $result['title'], "created" => $result['created'], "updated" => $result['updated'], "userid" => $result['userid'], "link" => $result['link'], "slug" => $result['slug'], "answers" => $result['answers'], "accepted" => $result['accepted'], "kb" => $result['kb'], "votes" => $result['votes'], "id" => $result['id'], "tags" => $tags, "description" => $description); } $template->set('questions', $questions); }
$del = !empty($_GET['del']) ? true : false; $edit = !empty($_GET['edit']) ? true : false; $idcom = retrieve(GET, 'id', 0); $module = retrieve(GET, 'module', ''); $Template->set_filenames(array('admin_com_management' => 'admin/admin_com_management.tpl')); $Cache->load('com'); $array_com = array(); $result = $Sql->query_while("SELECT script, COUNT(*) as total\nFROM " . DB_TABLE_COM . " \nGROUP BY script", __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $array_com[$row['script']] = $row['total']; } $Sql->query_close($result); import('util/pagination'); $Pagination = new Pagination(); $nbr_com = !empty($module) ? !empty($array_com[$module]) ? $array_com[$module] : 0 : $Sql->count_table('com', __LINE__, __FILE__); $Template->assign_vars(array('THEME' => get_utheme(), 'LANG' => get_ulang(), 'PAGINATION_COM' => $Pagination->display('admin_com.php?pc=%d', $nbr_com, 'pc', $CONFIG_COM['com_max'], 3), 'L_DISPLAY_RECENT' => $LANG['display_recent_com'], 'L_DISPLAY_TOPIC_COM' => $LANG['display_topic_com'], 'L_CONFIRM_DELETE' => $LANG['alert_delete_msg'], 'L_EDIT' => $LANG['edit'], 'L_DELETE' => $LANG['delete'], 'L_COM' => $LANG['com'], 'L_COM_MANAGEMENT' => $LANG['com_management'], 'L_COM_CONFIG' => $LANG['com_config'])); import('io/filesystem/folder'); $folder_path = new Folder('../'); foreach ($folder_path->get_folders('`^[a-z0-9_ -]+$`i') as $modules) { $modulef = $modules->get_name(); if (@file_exists('../' . $modulef . '/lang/' . get_ulang() . '/config.ini')) { $info_module = load_ini_file('../' . $modulef . '/lang/', get_ulang()); if (isset($info_module['info']) && !empty($info_module['com'])) { $Template->assign_block_vars('modules_com', array('MODULES' => $info_module['name'] . (isset($array_com[$info_module['com']]) ? ' (' . $array_com[$info_module['com']] . ')' : ' (0)'), 'U_MODULES' => $info_module['com'])); } } } $Cache->load('ranks'); $cond = !empty($module) ? "WHERE script = '" . $module . "'" : ''; $result = $Sql->query_while("SELECT c.idprov, c.idcom, c.login, c.user_id, c.timestamp, c.script, c.path, m.login as mlogin, m.level, m.user_mail, m.user_show_mail, m.timestamp AS registered, m.user_avatar, m.user_msg, m.user_local, m.user_web, m.user_sex, m.user_msn, m.user_yahoo, m.user_sign, m.user_warning, m.user_ban, m.user_groups, s.user_id AS connect, c.contents\nFROM " . DB_TABLE_COM . " c\nLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = c.user_id\nLEFT JOIN " . DB_TABLE_SESSIONS . " s ON s.user_id = c.user_id AND s.session_time > '" . (time() - $CONFIG['site_session_invit']) . "'\n" . $cond . "\nGROUP BY c.idcom\nORDER BY c.timestamp DESC\n" . $Sql->limit($Pagination->get_first_msg($CONFIG_COM['com_max'], 'pc'), $CONFIG_COM['com_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) {
foreach ($row as $field_name => $field_value) { $Template->assign_block_vars('line.field', array('FIELD' => '<strong>' . $field_name . '</strong>', 'CLASS' => 'row1')); } $Template->assign_block_vars('line', array()); } $j = 0; foreach ($row as $field_name => $field_value) { if ($j == 0 && !empty($primary_key)) { $Template->assign_block_vars('line.field', array('FIELD' => '<a href="admin_database_tools.php?table=' . $table . '&field=' . $field_name . '&value=' . $field_value . '&action=update&token=' . $Session->get_token() . '" title="' . $LANG['update'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/edit.png" alt="" class="valign_middle" /></a> <a href="admin_database_tools.php?table=' . $table . '&field=' . $field_name . '&value=' . $field_value . '&action=delete&token=' . $Session->get_token() . '" onclick="javascript:return Confirm_del_entry()" title="' . $LANG['delete'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/delete.png" alt="" class="valign_middle" /></a>', 'CLASS' => 'row1', 'STYLE' => '')); } $Template->assign_block_vars('line.field', array('FIELD' => str_replace("\n", '<br />', strprotect($field_value, HTML_PROTECT, ADDSLASHES_NONE)), 'CLASS' => 'row2', 'STYLE' => is_numeric($field_value) ? 'text-align:right;' : '')); $j++; } $i++; } $Template->assign_vars(array('C_DATABASE_TABLE_DATA' => true, 'C_DATABASE_TABLE_STRUCTURE' => false, 'QUERY' => Sql::indent_query($query), 'QUERY_HIGHLIGHT' => Sql::highlight_query($query), 'PAGINATION' => $Pagination->display('admin_database_tools.php?table=' . $table . '&action=data&p=%d', $nbr_lines, 'p', 30, 3), 'L_REQUIRE' => $LANG['require'], 'L_EXPLAIN_QUERY' => $LANG['db_query_explain'], 'L_CONFIRM_QUERY' => $LANG['db_confirm_query'], 'L_EXECUTE' => $LANG['db_submit_query'], 'L_RESULT' => $LANG['db_query_result'], 'L_PAGE' => $LANG['page'], 'L_EXECUTED_QUERY' => $LANG['db_executed_query'])); } elseif (!empty($table) && $action == 'delete') { $Session->csrf_get_protect(); $field = retrieve(GET, 'field', ''); $value = retrieve(GET, 'value', ''); if (!empty($value) && !empty($field)) { $Sql->query_inject("DELETE FROM " . $table . " WHERE " . $field . " = '" . $value . "'", __LINE__, __FILE__); } redirect(HOST . DIR . '/database/admin_database_tools.php?table=' . $table . '&action=data'); } elseif (!empty($table) && $action == 'update') { $Session->csrf_get_protect(); $table_structure = $backup->extract_table_structure(array($table)); $value = retrieve(GET, 'value', ''); $field = retrieve(GET, 'field', ''); $submit = retrieve(POST, 'submit', ''); if (!empty($submit)) {
<option value="trash"><?php _e('Remove', 'wp-sms'); ?> </option> </select> <input value="<?php _e('Apply', 'wp-sms'); ?> " name="doaction" id="doaction" class="button-secondary action" type="submit"/> </div> <br class="clear"> </div> </form> <?php if ($get_result) { ?> <div class="pagination-log"> <?php echo $Pagination->display(); ?> <p id="result-log"> <?php echo ' ' . __('Page', 'wp-sms') . ' ' . $Pagination->getCurrentPage() . ' ' . __('From', 'wp-sms') . ' ' . $Pagination->getTotalPages(); ?> </p> </div> <?php } ?> </div>
$where_search = retrieve(GET, 'where', ''); $where_search = !(empty($where_search) || $where_search == 'contents') ? 'contents' : 'title'; $page = retrieve(GET, 'page', 1); $page = $page <= 0 ? 1 : $page; $Template->set_filenames(array('wiki_search' => 'wiki/search.tpl')); $Template->assign_vars(array('L_SEARCH' => $LANG['wiki_search'], 'L_KEY_WORDS' => $LANG['wiki_search_key_words'], 'TARGET' => url('search.php?token=' . $Session->get_token()), 'KEY_WORDS' => $search_string, 'L_SEARCH_RESULT' => $LANG['wiki_search_result'], 'ARTICLE_TITLE' => $LANG['title'], 'RELEVANCE' => $LANG['wiki_search_relevance'], 'SELECTED_TITLE' => $where_search == 'title' ? 'checked="checked"' : '', 'SELECTED_CONTENTS' => $where_search != 'title' ? 'checked="checked"' : '', 'L_TITLE' => $LANG['title'], 'L_CONTENTS' => $LANG['content'])); if (!empty($search_string)) { $title_search = "SELECT title, encoded_title, MATCH(title) AGAINST('" . $search_string . "') AS relevance\n\t\tFROM " . PREFIX . "wiki_articles\n\t\tWHERE MATCH(title) AGAINST('" . $search_string . "') \n\t\tORDER BY relevance DESC"; $contents_search = "SELECT a.title, a.encoded_title, MATCH(c.content) AGAINST('" . $search_string . "') AS relevance\n\t\tFROM " . PREFIX . "wiki_articles a\n\t\tLEFT JOIN " . PREFIX . "wiki_contents c ON c.id_contents = a.id\n\t\tWHERE MATCH(c.content) AGAINST('" . $search_string . "') \n\t\tORDER BY relevance DESC"; $query = $where_search == 'title' ? $title_search : $contents_search; $query_rows = $where_search == 'title' ? "SELECT COUNT(*) FROM " . PREFIX . "wiki_articles WHERE MATCH(title) AGAINST('" . $search_string . "')" : "SELECT COUNT(*) \t\tFROM " . PREFIX . "wiki_articles a\n\t\tLEFT JOIN " . PREFIX . "wiki_contents c ON c.id_contents = a.id\n\t\tWHERE MATCH(c.content) AGAINST('" . $search_string . "')"; $result = $Sql->query_while($query, __LINE__, __FILE__); $num_rows = $Sql->num_rows($result, $query_rows, __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $pages_links = $Pagination->display('search' . url('.php?search=' . $search_string . '&where=' . $where_search . '&page=%d'), $num_rows, 'page', 10, 3); if ($num_rows > 0) { $Template->assign_block_vars('search_result', array('PAGES' => !empty($pages_links) ? $pages_links : ' ')); } else { $Errorh->handler($LANG['wiki_empty_search'], E_NOTICE); } $i = 1; while ($row = $Sql->fetch_assoc($result)) { if ($i > ($page - 1) * 10 && $i <= $page * 10) { $Template->assign_block_vars('search_result.item', array('TITLE' => $row['title'], 'U_TITLE' => url('wiki.php?title=' . $row['encoded_title'], $row['encoded_title']), 'RELEVANCE' => number_round($row['relevance'] / 5.5, 2) * 100 . ' %')); } $i++; if ($i > $page * 10) { break; } }
$Bread_crumb->add($LANG['member_msg'], 'membermsg.php' . SID); define('TITLE', $LANG['member_msg']); require_once '../kernel/header.php'; $memberId = retrieve(GET, 'id', 0, TUNSIGNED_INT); $script = retrieve(GET, 'script', ''); if (!empty($memberId)) { $Template->set_filenames(array('membermsg' => 'member/membermsg.tpl')); import('modules/modules_discovery_service'); $modulesLoader = new ModulesDiscoveryService(); $modules = $modulesLoader->get_available_modules('get_member_msg_link'); foreach ($modules as $module) { $img = $module->functionality('get_member_msg_img'); $Template->assign_block_vars('available_modules_msg', array('NAME_USER_MSG' => $module->functionality('get_member_msg_name'), 'IMG_USER_MSG' => $img, 'C_IMG_USER_MSG' => !empty($img) ? true : false, 'U_LINK_USER_MSG' => $module->functionality('get_member_msg_link', array($memberId)))); } $Template->assign_vars(array('L_USER_MSG' => $LANG['member_msg'], 'L_USER_MSG_DISPLAY' => $LANG['member_msg_display'], 'L_COMMENTS' => $LANG['com_s'], 'L_BACK' => $LANG['back'], 'U_BACK' => url('.php?id=' . $memberId, '-' . $memberId . '.php'), 'U_USER_MSG' => url('.php?id=' . $memberId), 'U_COMMENTS' => url('.php?id=' . $memberId . '&script=com'))); if (!empty($script)) { import('util/pagination'); $Pagination = new Pagination(); $nbr_msg = $Sql->query("SELECT COUNT(*) FROM " . DB_TABLE_COM . " WHERE user_id = '" . $memberId . "'", __LINE__, __FILE__); $Template->assign_vars(array('C_START_MSG' => true, 'PAGINATION' => $Pagination->display('membermsg.php?pmsg=%d', $nbr_msg, 'pmsg', 25, 3), 'L_GO_MSG' => $LANG['go_msg'], 'L_ON' => $LANG['on'])); $result = $Sql->query_while("SELECT c.timestamp, c.script, c.path, m.login, s.user_id AS connect, c.contents\n\t\tFROM " . DB_TABLE_COM . " c\n\t\tLEFT JOIN " . DB_TABLE_MEMBER . " m ON m.user_id = c.user_id\n\t\tLEFT JOIN " . DB_TABLE_SESSIONS . " s ON s.user_id = c.user_id AND s.session_time > '" . (time() - $CONFIG['site_session_invit']) . "'\n\t\tWHERE m.user_id = '" . $memberId . "'\n\t\tORDER BY c.timestamp DESC \n\t\t" . $Sql->limit($Pagination->get_first_msg(25, 'pmsg'), 25), __LINE__, __FILE__); $row = $Sql->fetch_assoc($result); while ($row = $Sql->fetch_assoc($result)) { $Template->assign_block_vars('msg_list', array('USER_PSEUDO' => '<a class="msg_link_pseudo" href="../member/member' . url('.php?id=' . $memberId, '-' . $memberId . '.php') . '"><span class="text_strong">' . wordwrap_html($row['login'], 13) . '</span></a>', 'USER_ONLINE' => '<img src="../templates/' . get_utheme() . '/images/' . (!empty($row['connect']) ? 'online' : 'offline') . '.png" alt="" class="valign_middle" />', 'DATE' => gmdate_format('date_format', $row['timestamp']), 'CONTENTS' => ucfirst(second_parse($row['contents'])), 'U_TITLE' => url($row['path'] . '#' . $row['script']))); } } $Template->pparse('membermsg'); } else { redirect(HOST . DIR . '/member/member.php'); } require_once '../kernel/footer.php';