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';
