function get_cache() { global $Sql; $code = 'global $CONFIG_POLL;' . "\n"; $CONFIG_POLL = unserialize($Sql->query("SELECT value FROM " . DB_TABLE_CONFIGS . " WHERE name = 'poll'", __LINE__, __FILE__)); $CONFIG_POLL = is_array($CONFIG_POLL) ? $CONFIG_POLL : array(); $code .= '$CONFIG_POLL = ' . var_export($CONFIG_POLL, true) . ';' . "\n"; $_array_poll = ''; if (!empty($CONFIG_POLL['poll_mini']) && is_array($CONFIG_POLL['poll_mini'])) { foreach ($CONFIG_POLL['poll_mini'] as $key => $idpoll) { $poll = $Sql->query_array(PREFIX . 'poll', 'id', 'question', 'votes', 'answers', 'type', "WHERE id = '" . $idpoll . "' AND archive = 0 AND visible = 1", __LINE__, __FILE__); if (!empty($poll['id'])) { $array_answer = explode('|', $poll['answers']); $array_vote = explode('|', $poll['votes']); $total_vote = array_sum($array_vote); $total_vote = $total_vote == 0 ? 1 : $total_vote; $array_votes = array_combine($array_answer, $array_vote); foreach ($array_votes as $answer => $nbrvote) { $array_votes[$answer] = number_round($nbrvote * 100 / $total_vote, 1); } $_array_poll .= $key . ' => array(\'id\' => ' . var_export($poll['id'], true) . ', \'question\' => ' . var_export($poll['question'], true) . ', \'votes\' => ' . var_export($array_votes, true) . ', \'total\' => ' . var_export($total_vote, true) . ', \'type\' => ' . var_export($poll['type'], true) . '),' . "\n"; } } } $code .= "\n" . 'global $_array_poll;' . "\n\n" . '$_array_poll = array(' . $_array_poll . ');'; return $code; }
function poll_mini($position, $block) { global $Cache, $LANG, $CONFIG_POLL, $_array_poll; $Cache->load('poll'); if (!empty($CONFIG_POLL['poll_mini']) && $CONFIG_POLL['poll_mini'] != array() && strpos(SCRIPT, '/poll/poll.php') === false) { load_module_lang('poll'); $poll_mini = $_array_poll[array_rand($_array_poll)]; $tpl = new Template('poll/poll_mini.tpl'); import('core/menu_service'); MenuService::assign_positions_conditions($tpl, $block); #####################R�sultats###################### $array_cookie = isset($_COOKIE[$CONFIG_POLL['poll_cookie']]) ? explode('/', $_COOKIE[$CONFIG_POLL['poll_cookie']]) : array(); if (in_array($poll_mini['id'], $array_cookie)) { $tpl->assign_vars(array('THEME' => get_utheme(), 'MODULE_DATA_PATH' => $tpl->get_module_data_path('poll'), 'L_MINI_POLL' => $LANG['mini_poll'], 'L_VOTE' => $poll_mini['total'] > 1 ? $LANG['poll_vote_s'] : $LANG['poll_vote'])); $tpl->assign_block_vars('result', array('QUESTION' => $poll_mini['question'], 'VOTES' => $poll_mini['total'])); foreach ($poll_mini['votes'] as $answer => $width) { $tpl->assign_block_vars('result.answers', array('ANSWERS' => $answer, 'WIDTH' => number_round($width, 0), 'PERCENT' => $width)); } } else { #####################Questions###################### $tpl->assign_vars(array('L_MINI_POLL' => $LANG['mini_poll'], 'L_VOTE' => $LANG['poll_vote'], 'L_POLL_RESULT' => $LANG['poll_result'], 'U_POLL_RESULT' => url('.php?id=' . $poll_mini['id'] . '&r=1', '-' . $poll_mini['id'] . '-1.php'))); global $Session; $tpl->assign_block_vars('question', array('ID' => url('.php?id=' . $poll_mini['id'] . '&token=' . $Session->get_token(), '-' . $poll_mini['id'] . '.php?token=' . $Session->get_token()), 'QUESTION' => $poll_mini['question'])); $z = 0; if ($poll_mini['type'] == '1') { foreach ($poll_mini['votes'] as $answer => $width) { $tpl->assign_block_vars('question.radio', array('NAME' => $z, 'ANSWERS' => $answer)); $z++; } } elseif ($poll_mini['type'] == '0') { foreach ($poll_mini['votes'] as $answer => $width) { $tpl->assign_block_vars('question.checkbox', array('NAME' => $z, 'ANSWERS' => $answer)); $z++; } } } return $tpl->parse(TEMPLATE_STRING_MODE); } return ''; }
$cut = !$first_message ? true : false; $moderator = !$is_guest ? true : false; } } elseif ($User->get_attribute('user_id') == $row['user_id'] && !$is_guest && $first_message) { $edit = true; } if (!empty($row['question']) && $poll_done === false) { $Template->assign_vars(array('C_POLL_EXIST' => true, 'QUESTION' => $row['question'], 'U_POLL_RESULT' => url('.php?id=' . $id_get . '&r=1&pt=' . $page), 'U_POLL_ACTION' => url('.php?id=' . $id_get . '&p=' . $page . '&token=' . $Session->get_token()), 'L_POLL' => $LANG['poll'], 'L_VOTE' => $LANG['poll_vote'], 'L_RESULT' => $LANG['poll_result'])); $array_voter = explode('|', $row['voter_id']); if (in_array($User->get_attribute('user_id'), $array_voter) || !empty($_GET['r']) || $User->get_attribute('user_id') === -1) { $array_answer = explode('|', $row['answers']); $array_vote = explode('|', $row['votes']); $sum_vote = array_sum($array_vote); $sum_vote = $sum_vote == 0 ? 1 : $sum_vote; foreach ($array_answer as $key => $answer) { $Template->assign_block_vars('poll_result', array('ANSWERS' => $answer, 'NBRVOTE' => $array_vote[$key], 'WIDTH' => number_round($array_vote[$key] * 100 / $sum_vote, 1) * 4, 'PERCENT' => number_round($array_vote[$key] * 100 / $sum_vote, 1))); } } else { $Template->assign_vars(array('C_POLL_QUESTION' => true)); $z = 0; $array_answer = explode('|', $row['answers']); if ($row['type'] == 0) { foreach ($array_answer as $answer) { $Template->assign_block_vars('poll_radio', array('NAME' => $z, 'TYPE' => 'radio', 'ANSWERS' => $answer)); $z++; } } elseif ($row['type'] == 1) { foreach ($array_answer as $answer) { $Template->assign_block_vars('poll_checkbox', array('NAME' => 'forumpoll' . $z, 'TYPE' => 'checkbox', 'ANSWERS' => $answer)); $z++; }
<?php require_once '../kernel/begin.php'; require_once '../forum/forum_begin.php'; require_once '../forum/forum_tools.php'; $Bread_crumb->add($CONFIG_FORUM['forum_name'], 'index.php' . SID); $Bread_crumb->add($LANG['stats'], ''); define('TITLE', $LANG['title_forum'] . ' - ' . $LANG['stats']); require_once '../kernel/header.php'; $Template->set_filenames(array('forum_stats' => 'forum/forum_stats.tpl', 'forum_top' => 'forum/forum_top.tpl', 'forum_bottom' => 'forum/forum_bottom.tpl')); $total_day = number_round((time() - $CONFIG['start']) / (3600 * 24), 0); $timestamp_today = @mktime(0, 0, 1, gmdate_format('m'), gmdate_format('d'), gmdate_format('y')); $sum = $Sql->query_array(PREFIX . "forum_cats", "SUM(nbr_topic) as total_topics", "SUM(nbr_msg) as total_msg", "WHERE level <> 0 AND level < 2 AND aprob = 1", __LINE__, __FILE__); $total_day = max(1, $total_day); $nbr_topics_day = number_round($sum['total_topics'] / $total_day, 1); $nbr_msg_day = number_round($sum['total_msg'] / $total_day, 1); $nbr_topics_today = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "forum_topics t\nJOIN " . PREFIX . "forum_msg m ON m.id = t.first_msg_id\nWHERE m.timestamp > '" . $timestamp_today . "'", __LINE__, __FILE__); $nbr_msg_today = $Sql->query("SELECT COUNT(*) FROM " . PREFIX . "forum_msg WHERE timestamp > '" . $timestamp_today . "'", __LINE__, __FILE__); $Template->assign_vars(array('FORUM_NAME' => $CONFIG_FORUM['forum_name'], 'SID' => SID, 'MODULE_DATA_PATH' => $Template->get_module_data_path('forum'), 'NBR_TOPICS' => $sum['total_topics'], 'NBR_MSG' => $sum['total_msg'], 'NBR_TOPICS_DAY' => $nbr_topics_day, 'NBR_MSG_DAY' => $nbr_msg_day, 'NBR_TOPICS_TODAY' => $nbr_topics_today, 'NBR_MSG_TODAY' => $nbr_msg_today, 'L_FORUM_INDEX' => $LANG['forum_index'], 'L_FORUM' => $LANG['forum'], 'L_STATS' => $LANG['stats'], 'L_NBR_TOPICS' => $sum['total_topics'] > 1 ? $LANG['topic_s'] : $LANG['topic'], 'L_NBR_MSG' => $sum['total_msg'] > 1 ? $LANG['message_s'] : $LANG['message'], 'L_NBR_TOPICS_DAY' => $LANG['nbr_topics_day'], 'L_NBR_MSG_DAY' => $LANG['nbr_msg_day'], 'L_NBR_TOPICS_TODAY' => $LANG['nbr_topics_today'], 'L_NBR_MSG_TODAY' => $LANG['nbr_msg_today'], 'L_LAST_MSG' => $LANG['forum_last_msg'], 'L_POPULAR' => $LANG['forum_popular'], 'L_ANSWERS' => $LANG['forum_nbr_answers'])); $auth_cats = ''; if (is_array($CAT_FORUM)) { foreach ($CAT_FORUM as $idcat => $key) { if (!$User->check_auth($CAT_FORUM[$idcat]['auth'], READ_CAT_FORUM)) { $auth_cats .= $idcat . ','; } } $auth_cats = !empty($auth_cats) ? " AND c.id NOT IN (" . trim($auth_cats, ',') . ")" : ''; } $result = $Sql->query_while("SELECT t.id, t.title, c.id as cid, c.auth\nFROM " . PREFIX . "forum_topics t\nLEFT JOIN " . PREFIX . "forum_cats c ON c.id = t.idcat\nWHERE c.level != 0 AND c.aprob = 1 " . $auth_cats . "\nORDER BY t.last_timestamp DESC\n" . $Sql->limit(0, 10), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $Template->assign_block_vars('last_msg', array('U_TOPIC_ID' => url('.php?id=' . $row['id'], '-' . $row['id'] . '.php'), 'TITLE' => $row['title']));
###### Régénération du cache dela configuration ####### $Cache->Generate_file('uploads'); $Cache->Generate_file('htaccess'); redirect(HOST . SCRIPT); } else { $Template->set_filenames(array('admin_files_config' => 'admin/admin_files_config.tpl')); $Cache->load('uploads'); $CONFIG_UPLOADS['auth_extensions'] = !empty($CONFIG_UPLOADS['auth_extensions']) && is_array($CONFIG_UPLOADS['auth_extensions']) ? $CONFIG_UPLOADS['auth_extensions'] : array(); $array_ext_sup = $CONFIG_UPLOADS['auth_extensions']; $array_extensions_type = array($LANG['files_image'] => array('jpg', 'jpeg', 'bmp', 'gif', 'png', 'tif', 'svg', 'ico'), $LANG['files_archives'] => array('rar', 'zip', 'gz'), $LANG['files_text'] => array('txt', 'doc', 'docx', 'pdf', 'ppt', 'xls', 'odt', 'odp', 'ods', 'odg', 'odc', 'odf', 'odb', 'xcf'), $LANG['files_media'] => array('flv', 'mp3', 'ogg', 'mpg', 'mov', 'swf', 'wav', 'wmv', 'midi', 'mng', 'qt'), $LANG['files_prog'] => array('c', 'h', 'cpp', 'java', 'py', 'css', 'html', 'xml'), $LANG['files_misc'] => array('ttf', 'tex', 'rtf', 'psd')); $i = 0; $auth_extensions = ''; foreach ($array_extensions_type as $file_type => $array_extensions) { $auth_extensions .= '<optgroup label="' . $file_type . '">'; foreach ($array_extensions as $key => $extension) { $extension_key = array_search($extension, $CONFIG_UPLOADS['auth_extensions']); $selected = $extension_key !== false ? ' selected="selected"' : ''; $auth_extensions .= '<option value="' . $extension . '" id="ext' . $i . '"' . $selected . '>' . $extension . '</option>'; if (isset($array_ext_sup[$extension_key])) { unset($array_ext_sup[$extension_key]); } $i++; } $auth_extensions .= '</optgroup>'; } $array_ranks = array(0 => $LANG['member'], 1 => $LANG['modo'], 2 => $LANG['admin']); $array_auth = isset($CONFIG_UPLOADS['auth_files']) ? $CONFIG_UPLOADS['auth_files'] : array(); $Template->assign_vars(array('NBR_EXTENSIONS' => $i, 'AUTH_FILES' => Authorizations::generate_select(AUTH_FILES, $array_auth, array(2 => true)), 'SIZE_LIMIT' => isset($CONFIG_UPLOADS['size_limit']) ? number_round($CONFIG_UPLOADS['size_limit'] / 1024, 2) : '0.5', 'BANDWIDTH_PROTECT_ENABLED' => $CONFIG_UPLOADS['bandwidth_protect'] == 1 ? 'checked="checked"' : '', 'BANDWIDTH_PROTECT_DISABLED' => $CONFIG_UPLOADS['bandwidth_protect'] == 0 ? 'checked="checked"' : '', 'AUTH_EXTENSIONS' => $auth_extensions, 'AUTH_EXTENSIONS_SUP' => implode(', ', $array_ext_sup), 'L_MB' => $LANG['unit_megabytes'], 'L_FILES_MANAGEMENT' => $LANG['files_management'], 'L_CONFIG_FILES' => $LANG['files_config'], 'L_REQUIRE' => $LANG['require'], 'L_AUTH_FILES' => $LANG['auth_files'], 'L_SIZE_LIMIT' => $LANG['size_limit'], 'L_BANDWIDTH_PROTECT' => $LANG['bandwidth_protect'], 'L_BANDWIDTH_PROTECT_EXPLAIN' => $LANG['bandwidth_protect_explain'], 'L_AUTH_EXTENSIONS' => $LANG['auth_extensions'], 'L_EXTEND_EXTENSIONS' => $LANG['extend_extensions'], 'L_EXTEND_EXTENSIONS_EXPLAIN' => $LANG['extend_extensions_explain'], 'L_SELECT_ALL' => $LANG['select_all'], 'L_SELECT_NONE' => $LANG['select_none'], 'L_ACTIV' => $LANG['activ'], 'L_UNACTIV' => $LANG['unactiv'], 'L_UPDATE' => $LANG['update'], 'L_RESET' => $LANG['reset'])); $Template->pparse('admin_files_config'); } require_once '../admin/admin_footer.php';
case 'gif': case 'bmp': list($width_source, $height_source) = @getimagesize('../upload/' . $row['path']); $size_img = ' (' . $width_source . 'x' . $height_source . ')'; $width_source = !empty($width_source) ? $width_source + 30 : 0; $height_source = !empty($height_source) ? $height_source + 30 : 0; $bbcode = '[img]/upload/' . $row['path'] . '[/img]'; $link = '<a class="com" href="javascript:popup_upload(\'' . $row['id'] . '\', ' . $width_source . ', ' . $height_source . ', \'yes\')">'; break; case 'mp3': $bbcode = '[sound]/upload/' . $row['path'] . '[/sound]'; $link = '<a class="com" href="javascript:popup_upload(\'' . $row['id'] . '\', 220, 10, \'no\')">'; break; default: $bbcode = '[url=/upload/' . $row['path'] . ']' . $row['name'] . '[/url]'; $link = '<a class="com" href="../upload/' . $row['path'] . '">'; } $Template->assign_block_vars('files', array('ID' => $row['id'], 'IMG' => '<img src="../templates/' . get_utheme() . '/images/upload/' . $get_img_mimetype['img'] . '" alt="" />', 'URL' => $link, 'NAME' => $name_cut, 'RENAME_FILE' => '<span id="fihref' . $row['id'] . '"><a href="javascript:display_rename_file(\'' . $row['id'] . '\', \'' . addslashes($row['name']) . '\', \'' . addslashes($name_cut) . '\');" title="' . $LANG['edit'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/edit.png" alt="" style="vertical-align:middle;" /></a></span>', 'FILETYPE' => $get_img_mimetype['filetype'] . $size_img, 'BBCODE' => '<input size="25" type="text" class="text" onclick="select_div(\'text_' . $row['id'] . '\');" id="text_' . $row['id'] . '" style="margin-top:2px;cursor:pointer;" value="' . $bbcode . '" />', 'SIZE' => $row['size'] > 1024 ? number_round($row['size'] / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($row['size'], 0) . ' ' . $LANG['unit_kilobytes'], 'DATE' => gmdate_format('date_format', $row['timestamp']), 'LOGIN' => '<a href="../member/member.php?id=' . $row['user_id'] . '">' . $row['login'] . '</a>', 'U_MOVE' => '.php?movefi=' . $row['id'] . '&f=' . $folder . '&fm=' . $row['user_id'])); $total_folder_size += $row['size']; $total_files++; } $Sql->query_close($result); } $total_size = $Sql->query("SELECT SUM(size) FROM " . PREFIX . "upload", __LINE__, __FILE__); $Template->assign_vars(array('TOTAL_SIZE' => $total_size > 1024 ? number_round($total_size / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($total_size, 0) . ' ' . $LANG['unit_kilobytes'], 'TOTAL_FOLDER_SIZE' => $total_folder_size > 1024 ? number_round($total_folder_size / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($total_folder_size, 0) . ' ' . $LANG['unit_kilobytes'], 'TOTAL_FOLDERS' => $total_directories, 'TOTAL_FILES' => $total_files)); if ($total_directories == 0 && $total_files == 0 && (!empty($folder) || !empty($show_member))) { $Template->assign_vars(array('C_EMPTY_FOLDER' => true, 'L_EMPTY_FOLDER' => $LANG['empty_folder'])); } $Template->pparse('admin_files_management'); } require_once '../admin/admin_footer.php';
if ($ban < 60) { $delay_ban = $ban . ' ' . ($ban > 1 ? $LANG['minutes'] : $LANG['minute']); } elseif ($ban < 1440) { $delay_ban = number_round($ban / 60, 0); $delay_ban = $delay_ban . ' ' . ($delay_ban > 1 ? $LANG['hours'] : $LANG['hour']); } elseif ($ban < 10080) { $delay_ban = number_round($ban / 1440, 0); $delay_ban = $delay_ban . ' ' . ($delay_ban > 1 ? $LANG['days'] : $LANG['day']); } elseif ($ban < 43200) { $delay_ban = number_round($ban / 10080, 0); $delay_ban = $delay_ban . ' ' . ($delay_ban > 1 ? $LANG['weeks'] : $LANG['week']); } elseif ($ban < 525600) { $delay_ban = number_round($ban / 43200, 0); $delay_ban = $delay_ban . ' ' . ($delay_ban > 1 ? $LANG['months'] : $LANG['month']); } else { $delay_ban = number_round($ban / 525600, 0); $delay_ban = $delay_ban . ' ' . ($delay_ban > 1 ? $LANG['years'] : $LANG['year']); } } else { $delay_ban = 0 . ' ' . $LANG['minutes']; } $errstr = $LANG['e_member_ban'] . ' ' . $delay_ban; break; case 'e_member_ban_w': $errstr = $LANG['e_member_ban_w']; break; case 'e_unexist_member': $errstr = $LANG['e_unexist_member']; break; case 'e_unactiv_member': $errstr = $LANG['e_unactiv_member'];
<?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';
$Sql->optimize_tables($selected_tables); $Errorh->handler(sprintf($LANG['db_succes_optimize_tables'], implode(', ', $selected_tables)), E_USER_NOTICE); } } if (!empty($_GET['error'])) { if (trim($_GET['error']) == 'backup_success' && !empty($_GET['file'])) { $Errorh->handler(sprintf($LANG['db_backup_success'], $_GET['file'], $_GET['file']), E_USER_NOTICE); } } $i = 0; list($nbr_rows, $nbr_data, $nbr_free) = array(0, 0, 0); foreach ($backup->get_tables_properties_list() as $key => $table_info) { $free = number_round($table_info['data_free'] / 1024, 1); $data = number_round(($table_info['data_length'] + $table_info['index_lenght']) / 1024, 1); $free = $free > 1024 ? number_round($free / 1024, 1) . ' MB' : $free . ' kB'; $data = $data > 1024 ? number_round($data / 1024, 1) . ' MB' : $data . ' kB'; $Template->assign_block_vars('table_list', array('TABLE_NAME' => $table_info['name'], 'TABLE_ENGINE' => $table_info['engine'], 'TABLE_ROWS' => $table_info['rows'], 'TABLE_DATA' => $data != 0 ? $data : '-', 'TABLE_FREE' => $free != 0 ? $free : '-', 'TABLE_COLLATION' => $table_info['collation'], 'I' => $i)); $nbr_rows += $table_info['rows']; $nbr_free += $table_info['data_free']; $nbr_data += $table_info['data_length'] + $table_info['index_lenght']; $i++; } $nbr_free = number_round($nbr_free / 1024, 1); $nbr_data = number_round($nbr_data / 1024, 1); $nbr_free = $nbr_free > 1024 ? number_round($nbr_free / 1024, 1) . ' Mo' : $nbr_free . ' Ko'; $nbr_data = $nbr_data > 1024 ? number_round($nbr_data / 1024, 1) . ' Mo' : $nbr_data . ' Ko'; $Template->assign_vars(array('C_DATABASE_INDEX' => true, 'TARGET' => url('admin_database.php?token=' . $Session->get_token()), 'NBR_TABLES' => $backup->get_tables_number(), 'NBR_ROWS' => $nbr_rows, 'NBR_DATA' => $nbr_data, 'NBR_FREE' => $nbr_free, 'L_EXPLAIN' => $LANG['db_explain_actions'], 'L_DB_RESTORE' => $LANG['db_restore'], 'L_RESTORE_FROM_SERVER' => $LANG['db_restore_from_server'], 'L_FILE_LIST' => $LANG['db_view_file_list'], 'L_RESTORE_FROM_UPLOADED_FILE' => sprintf($LANG['import_file_explain'], ini_get('upload_max_filesize')), 'L_RESTORE_NOW' => $LANG['db_restore'], 'L_TABLE_LIST' => $LANG['db_table_list'], 'L_TABLE_NAME' => $LANG['db_table_name'], 'L_TABLE_ROWS' => $LANG['db_table_rows'], 'L_TABLE_ENGINE' => $LANG['db_table_engine'], 'L_TABLE_COLLATION' => $LANG['db_table_collation'], 'L_TABLE_DATA' => $LANG['db_table_data'], 'L_TABLE_FREE' => $LANG['db_table_free'], 'L_SELECTED_TABLES' => $LANG['db_selected_tables'], 'L_ALL' => $LANG['db_select_all'], 'ACTION_FOR_SELECTION' => $LANG['db_for_selected_tables'], 'L_OPTIMIZE' => $LANG['db_optimize'], 'L_REPAIR' => $LANG['db_repair'], 'L_BACKUP' => $LANG['db_backup'])); } } $Template->pparse('admin_database_management'); require_once '../admin/admin_footer.php';
$Template->assign_vars(array('C_POLL_MAIN' => true, 'EDIT' => $edit, 'U_ARCHIVE' => $show_archives, 'L_POLL' => $LANG['poll'], 'L_POLL_MAIN' => $LANG['poll_main'])); $result = $Sql->query_while("SELECT id, question \n\tFROM " . PREFIX . "poll \n\tWHERE archive = 0 AND visible = 1\n\tORDER BY id DESC", __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $Template->assign_block_vars('list', array('U_POLL_ID' => url('.php?id=' . $row['id'], '-' . $row['id'] . '.php'), 'QUESTION' => $row['question'])); } $Sql->query_close($result); $Template->pparse('poll'); } elseif ($archives) { $Template->set_filenames(array('poll' => 'poll/poll.tpl')); $nbrarchives = $Sql->query("SELECT COUNT(*) as id FROM " . PREFIX . "poll WHERE archive = 1 AND visible = 1", __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); $Template->assign_vars(array('C_POLL_ARCHIVES' => true, 'SID' => SID, 'THEME' => get_utheme(), 'C_IS_ADMIN' => $User->check_level(ADMIN_LEVEL), 'PAGINATION' => $Pagination->display('poll' . url('.php?p=%d', '-0-0-%d.php'), $nbrarchives, 'p', 10, 3), 'MODULE_DATA_PATH' => $Template->get_module_data_path('poll'), 'L_ALERT_DELETE_POLL' => $LANG['alert_delete_poll'], 'L_ARCHIVE' => $LANG['archives'], 'L_BACK_POLL' => $LANG['poll_back'], 'L_ON' => $LANG['on'], 'L_EDIT' => $LANG['edit'], 'L_DELETE' => $LANG['delete'])); $result = $Sql->query_while("SELECT id, question, votes, answers, type, timestamp\n\tFROM " . PREFIX . "poll\n\tWHERE archive = 1 AND visible = 1\n\tORDER BY timestamp DESC\n\t" . $Sql->limit($Pagination->get_first_msg(10, 'archives'), 10), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $array_answer = explode('|', $row['answers']); $array_vote = explode('|', $row['votes']); $sum_vote = array_sum($array_vote); $sum_vote = $sum_vote == 0 ? 1 : $sum_vote; $Template->assign_block_vars('list', array('ID' => $row['id'], 'QUESTION' => $row['question'], 'EDIT' => '<a href="../poll/admin_poll' . url('.php?id=' . $row['id']) . '" title="' . $LANG['edit'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/edit.png" class="valign_middle" /></a>', 'DEL' => ' <a href="../poll/admin_poll' . url('.php?delete=1&id=' . $row['id']) . '" title="' . $LANG['delete'] . '" onclick="javascript:return Confirm();"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/delete.png" class="valign_middle" /></a>', 'VOTE' => $sum_vote, 'DATE' => gmdate_format('date_format'), 'L_VOTE' => $sum_vote > 1 ? $LANG['poll_vote_s'] : $LANG['poll_vote'])); $array_poll = array_combine($array_answer, $array_vote); foreach ($array_poll as $answer => $nbrvote) { $Template->assign_block_vars('list.result', array('ANSWERS' => $answer, 'NBRVOTE' => $nbrvote, 'WIDTH' => number_round($nbrvote * 100 / $sum_vote, 1) * 4, 'PERCENT' => number_round($nbrvote * 100 / $sum_vote, 1), 'L_VOTE' => $nbrvote > 1 ? $LANG['poll_vote_s'] : $LANG['poll_vote'])); } } $Sql->query_close($result); $Template->pparse('poll'); } else { $Errorh->handler('e_unexist_page', E_USER_REDIRECT); } require_once '../kernel/footer.php';
$sort = 'note'; $selected_fields['note'] = ' selected="selected"'; break; default: $sort = 'timestamp'; $selected_fields['date'] = ' selected="selected"'; } $mode = $get_mode == 'asc' ? 'ASC' : 'DESC'; if ($mode == 'ASC') { $selected_fields['asc'] = ' selected="selected"'; } else { $selected_fields['desc'] = ' selected="selected"'; } $unget = !empty($get_sort) && !empty($mode) ? '?sort=' . $get_sort . '&mode=' . $get_mode : ''; $Template->assign_vars(array('L_FILE' => $DOWNLOAD_LANG['file'], 'L_ALPHA' => $DOWNLOAD_LANG['sort_alpha'], 'L_SIZE' => $LANG['size'], 'L_DATE' => $LANG['date'], 'L_DOWNLOAD' => $DOWNLOAD_LANG['download'], 'L_POPULARITY' => $DOWNLOAD_LANG['popularity'], 'L_DESC' => $LANG['desc'], 'L_ASC' => $LANG['asc'], 'L_NOTE' => $LANG['note'], 'L_ORDER_BY' => $DOWNLOAD_LANG['order_by'], 'L_CONFIRM_DELETE_FILE' => str_replace('\'', '\\\'', $DOWNLOAD_LANG['confirm_delete_file']), 'SELECTED_ALPHA' => $selected_fields['alpha'], 'SELECTED_SIZE' => $selected_fields['size'], 'SELECTED_DATE' => $selected_fields['date'], 'SELECTED_HITS' => $selected_fields['hits'], 'SELECTED_NOTE' => $selected_fields['note'], 'SELECTED_ASC' => $selected_fields['asc'], 'SELECTED_DESC' => $selected_fields['desc'])); import('util/pagination'); $Pagination = new Pagination(); import('content/note'); import('content/comments'); $Template->assign_vars(array('PAGINATION' => $Pagination->display(url('download.php' . (!empty($unget) ? $unget . '&' : '?') . 'cat=' . $category_id . '&p=%d', 'category-' . $category_id . '-%d.php' . $unget), $nbr_files, 'p', $CONFIG_DOWNLOAD['nbr_file_max'], 3), 'C_FILES' => true, 'TARGET_ON_CHANGE_ORDER' => $CONFIG['rewrite'] ? 'category-' . $category_id . '.php?' : 'download.php?cat=' . $category_id . '&')); $result = $Sql->query_while("SELECT id, title, timestamp, size, count, note, nbrnote, nbr_com, image, short_contents\n\t\tFROM " . PREFIX . "download\n\t\tWHERE visible = 1 AND approved = 1 AND idcat = '" . $category_id . "'\n\t\tORDER BY " . $sort . " " . $mode . $Sql->limit($Pagination->get_first_msg($CONFIG_DOWNLOAD['nbr_file_max'], 'p'), $CONFIG_DOWNLOAD['nbr_file_max']), __LINE__, __FILE__); while ($row = $Sql->fetch_assoc($result)) { $Template->assign_block_vars('file', array('NAME' => $row['title'], 'IMG_NAME' => str_replace('"', '\\"', $row['title']), 'C_DESCRIPTION' => !empty($row['short_contents']), 'DESCRIPTION' => second_parse($row['short_contents']), 'DATE' => sprintf($DOWNLOAD_LANG['add_on_date'], gmdate_format('date_format_short', $row['timestamp'])), 'COUNT_DL' => sprintf($DOWNLOAD_LANG['downloaded_n_times'], $row['count']), 'NOTE' => $row['nbrnote'] > 0 ? Note::display_img($row['note'], $CONFIG_DOWNLOAD['note_max'], 5) : '<em>' . $LANG['no_note'] . '</em>', 'SIZE' => $row['size'] >= 1 ? number_round($row['size'], 1) . ' ' . $LANG['unit_megabytes'] : number_round($row['size'], 1) * 1024 . ' ' . $LANG['unit_kilobytes'], 'C_IMG' => !empty($row['image']), 'IMG' => $row['image'], 'U_DOWNLOAD_LINK' => url('download.php?id=' . $row['id'], 'download-' . $row['id'] . '+' . url_encode_rewrite($row['title']) . '.php'), 'U_ADMIN_EDIT_FILE' => url('management.php?edit=' . $row['id']), 'U_ADMIN_DELETE_FILE' => url('management.php?del=' . $row['id'] . '&token=' . $Session->get_token()), 'U_COM_LINK' => Comments::com_display_link($row['nbr_com'], '../download/download' . url('.php?id=' . $row['id'] . '&com=0', '-' . $row['id'] . '+' . url_encode_rewrite($row['title']) . '.php?com=0'), $row['id'], 'download'))); } $Sql->query_close($result); } else { $Template->assign_vars(array('L_NO_FILE_THIS_CATEGORY' => $DOWNLOAD_LANG['none_download'], 'C_NO_FILE' => true)); } $Template->pparse('download'); } require_once '../kernel/footer.php';
$trend_img = 'down.png'; $sign = '-'; $trend = 100 - number_round($row['yesterday_visit'] * 100 / $average, 1); } else { $trend_img = 'right.png'; $sign = '+'; $trend = 0; } echo '<table style="width:100%;border:none;border-collapse:collapse;"> <tr> <td style="text-align:center;"> ' . ucfirst($row['url']) . ' </td> <td style="width:112px;text-align:center;"> ' . $row['total_visit'] . ' </td> <td style="width:112px;text-align:center;"> ' . number_round($average, 1) . ' </td> <td style="width:102px;text-align:center;"> ' . gmdate_format('date_format_short', $row['last_update']) . ' </td> <td style="width:105px;"> <img src="../templates/' . get_utheme() . '/images/admin/' . $trend_img . '" alt="" class="valign_middle" /> (' . $sign . $trend . '%) </td> </tr> </table>'; } $Sql->query_close($result); $Sql->close(); }
$tinymce = '<a href="' . PATH_TO_ROOT . '/upload/' . $row['path'] . '">' . $row['name'] . '</a>'; $link = 'javascript:popup_upload(\'' . $row['id'] . '\', 220, 10, \'no\')'; break; default: $bbcode = '[url=/upload/' . $row['path'] . ']' . $row['name'] . '[/url]'; $tinymce = '<a href="' . PATH_TO_ROOT . '/upload/' . $row['path'] . '">' . $row['name'] . '</a>'; $link = '../upload/' . $row['path']; } $is_bbcode_editor = $editor == BBCODE_LANGUAGE; $inserted_code = $User->get_attribute('user_editor') == BBCODE_LANGUAGE ? addslashes($bbcode) : htmlentities($tinymce, ENT_COMPAT, 'ISO-8859-1'); $displayed_code = $is_bbcode_editor ? $bbcode : '/upload/' . $row['path']; $inserted_code = $is_bbcode_editor ? addslashes($bbcode) : htmlentities($tinymce, ENT_COMPAT, 'ISO-8859-1'); $Template->assign_block_vars('files', array('ID' => $row['id'], 'IMG' => '<img src="../templates/' . get_utheme() . '/images/upload/' . $get_img_mimetype['img'] . '" alt="" />', 'URL' => $link, 'TITLE' => str_replace('"', '\\"', $row['name']), 'NAME' => $name_cut, 'RENAME_FILE' => '<span id="fihref' . $row['id'] . '"><a href="javascript:display_rename_file(\'' . $row['id'] . '\', \'' . addslashes($row['name']) . '\', \'' . addslashes($name_cut) . '\');" title="' . $LANG['edit'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/edit.png" alt="" class="valign_middle" /></a></span>', 'FILETYPE' => $get_img_mimetype['filetype'] . $size_img, 'BBCODE' => '<input size="25" type="text" class="text" onclick="select_div(\'text_' . $row['id'] . '\');" id="text_' . $row['id'] . '" style="margin-top:2px;cursor:pointer;" value="' . $displayed_code . '" />', 'SIZE' => $row['size'] > 1024 ? number_round($row['size'] / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($row['size'], 0) . ' ' . $LANG['unit_kilobytes'], 'INSERT' => !empty($popup) ? '<a href="javascript:insert_popup(\'' . $inserted_code . '\')" title="' . $LANG['popup_insert'] . '"><img src="../templates/' . get_utheme() . '/images/upload/insert.png" alt="" class="valign_middle" /></a>' : '', 'DATE' => gmdate_format('date_format', $row['timestamp']), 'LOGIN' => '<a href="../member/member.php?id=' . $row['user_id'] . '">' . $row['login'] . '</a>', 'U_MOVE' => url('.php?movefi=' . $row['id'] . '&f=' . $folder . $popup))); $total_folder_size += $row['size']; $total_files++; } $Sql->query_close($result); $group_limit = $User->check_max_value(DATA_GROUP_LIMIT, $CONFIG_UPLOADS['size_limit']); $unlimited_data = $group_limit === -1 || $User->check_level(ADMIN_LEVEL); $total_size = !empty($folder) ? $Uploads->Member_memory_used($User->get_attribute('user_id')) : $Sql->query("SELECT SUM(size) FROM " . DB_TABLE_UPLOAD . " WHERE user_id = '" . $User->get_attribute('user_id') . "'", __LINE__, __FILE__); $Template->assign_vars(array('PERCENT' => !$unlimited_data ? '(' . number_round($total_size / $group_limit, 3) * 100 . '%)' : '', 'SIZE_LIMIT' => !$unlimited_data ? $group_limit > 1024 ? number_round($group_limit / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($group_limit, 0) . ' ' . $LANG['unit_kilobytes'] : $LANG['illimited'], 'TOTAL_SIZE' => $total_size > 1024 ? number_round($total_size / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($total_size, 0) . ' ' . $LANG['unit_kilobytes'], 'TOTAL_FOLDER_SIZE' => $total_folder_size > 1024 ? number_round($total_folder_size / 1024, 2) . ' ' . $LANG['unit_megabytes'] : number_round($total_folder_size, 0) . ' ' . $LANG['unit_kilobytes'], 'TOTAL_FOLDERS' => $total_directories, 'TOTAL_FILES' => $total_files)); if ($total_directories == 0 && $total_files == 0) { $Template->assign_vars(array('C_EMPTY_FOLDER' => true, 'L_EMPTY_FOLDER' => $LANG['empty_folder'])); } $Template->pparse('upload'); } if (empty($popup)) { require_once '../kernel/footer.php'; } else { require_once '../kernel/footer_no_display.php'; }
$Template->assign_vars(array('C_STATS_ROBOTS' => true, 'L_ERASE_RAPPORT' => $LANG['erase_rapport'], 'L_ERASE' => $LANG['erase'], 'L_COLORS' => $LANG['colors'], 'L_VIEW_NUMBER' => $LANG['number_r_visit'], 'L_LAST_UPDATE' => $LANG['last_update'])); $file = @fopen('../cache/robots.txt', 'r'); $robot_serial = @fgets($file); $array_robot = !empty($robot_serial) ? unserialize($robot_serial) : array('other' => 0); $stats_array = array(); $array_date = array(0 => 0, 1 => 0, 2 => 0); if (is_array($array_robot)) { foreach ($array_robot as $key => $value) { $array_info = explode('/', $value); if (isset($array_info[0]) && isset($array_info[1])) { $stats_array[$array_info[0]] = $array_info[1]; $array_date[$array_info[0]] = array(substr($array_info[2], 2, 2), substr($array_info[2], 4, 2), substr($array_info[2], 6, 2)); } } } import('util/images_stats'); $Stats = new Stats(); $Stats->load_data($stats_array, 'ellipse'); $stats_info = array('Google bot' => 'google.gif', 'Yahoo Slurp' => 'yahoo.gif', 'Msn bot' => 'msn.gif', 'Voila' => 'voila.gif', 'Gigablast' => 'gigablast.gif', 'Ia archiver' => 'ia_archiver.gif', 'Exalead' => 'exalead.gif'); foreach ($Stats->data_stats as $key => $angle_value) { if (isset($stats_info[$key])) { $array_color = $Stats->array_allocated_color[$Stats->_image_color_allocate_dark(false, NO_ALLOCATE_COLOR)]; $name = ucfirst(str_replace(array('_', '.gif'), array(' ', ' '), $stats_info[$key])); $Template->assign_block_vars('list', array('COLOR' => 'RGB(' . $array_color[0] . ', ' . $array_color[1] . ', ' . $array_color[2] . ')', 'IMG' => !empty($stats_info[$key]) ? '<img src="../images/stats/bot/' . $stats_info[$key] . '" alt="' . $name . '" />' : '', 'VIEWS' => number_round($angle_value * $Stats->nbr_entry / 360, 0), 'PERCENT' => number_round($angle_value / 3.6, 1), 'DATE' => gmdate_format('date_format_short', mktime(0, 0, 0, $array_date[$key][1], $array_date[$key][2], $array_date[$key][0])), 'L_NAME' => $name == 'Other' ? $LANG['other'] : $name)); } } } else { $Template->assign_vars(array('C_STATS_SITE' => true, 'START' => gmdate_format('date_format_short', $CONFIG['start']), 'VERSION' => $CONFIG['version'], 'L_START' => $LANG['start'], 'L_VERSION' => $LANG['version'])); } $Template->pparse('admin_stats_management'); require_once '../admin/admin_footer.php';
function to_string($digits = 3) { $this->stop(); return number_round($this->duration, $digits); }
function strtotimestamp($str, $date_format) { global $CONFIG, $User; list($month, $day, $year) = array(0, 0, 0); $array_timestamp = explode('/', $str); $array_date = explode('/', $date_format); for ($i = 0; $i < 3; $i++) { switch ($array_date[$i]) { case 'd': $day = isset($array_timestamp[$i]) ? numeric($array_timestamp[$i]) : 0; break; case 'm': $month = isset($array_timestamp[$i]) ? numeric($array_timestamp[$i]) : 0; break; case 'y': $year = isset($array_timestamp[$i]) ? numeric($array_timestamp[$i]) : 0; break; } } if (checkdate($month, $day, $year)) { $timestamp = @mktime(0, 0, 1, $month, $day, $year); } else { $timestamp = time(); } $serveur_hour = number_round(date('Z') / 3600, 0) - date('I'); $timezone = $User->get_attribute('user_timezone') - $serveur_hour; if ($timezone != 0) { $timestamp -= $timezone * 3600; } return $timestamp > 0 ? $timestamp : time(); }
$array_js .= 'array_pics[' . $i . '][\'path\'] = \'' . $row['path'] . "';\n"; $i++; } $Sql->query_close($result); if ($thumbnails_before < $nbr_pics_display_before) { $end_thumbnails += $nbr_pics_display_before - $thumbnails_before; } if ($thumbnails_after < $nbr_pics_display_after) { $start_thumbnails += $nbr_pics_display_after - $thumbnails_after; } $Template->assign_vars(array('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_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_EDIT' => $LANG['edit'], 'L_APROB_IMG' => $info_pics['aprob'] == 1 ? $LANG['unaprob'] : $LANG['aprob'], 'L_THUMBNAILS' => $LANG['thumbnails'])); $cat_list = ''; foreach ($array_cat_list as $key_cat => $option_value) { $cat_list .= $key_cat == $info_pics['idcat'] ? sprintf($option_value, 'selected="selected"') : sprintf($option_value, ''); } $Template->assign_block_vars('pics.pics_max', array('ID' => $info_pics['id'], 'IMG' => '<img src="show_pics.php?id=' . $idpics . '&cat=' . $idcat . '" alt="" / >', 'NAME' => '<span id="fi_' . $info_pics['id'] . '">' . $info_pics['name'] . '</span> <span id="fi' . $info_pics['id'] . '"></span>', 'POSTOR' => '<a class="com" 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), 'COLSPAN' => $CONFIG_GALLERY['nbr_column'] + 2, 'CAT' => $cat_list, 'RENAME' => addslashes($info_pics['name']), 'RENAME_CUT' => addslashes($info_pics['name']), 'IMG_APROB' => $info_pics['aprob'] == 1 ? 'unvisible.png' : 'visible.png', 'U_DEL' => 'php?del=' . $info_pics['id'] . '&cat=' . $idcat . '&token=' . $Session->get_token(), 'U_MOVE' => '.php?id=' . $info_pics['id'] . '&token=' . $Session->get_token() . '&move=\' + this.options[this.selectedIndex].value', 'U_PREVIOUS' => $pos_pics > 0 ? '<a href="admin_gallery.php?cat=' . $idcat . '&id=' . $id_previous . '#pics_max"><img src="../templates/' . get_utheme() . '/images/left.png" alt="" class="valign_middle" /></a> <a href="admin_gallery.php?cat=' . $idcat . '&id=' . $id_previous . '#pics_max">' . $LANG['previous'] . '</a>' : '', 'U_NEXT' => $pos_pics < $i - 1 ? '<a href="admin_gallery.php?cat=' . $idcat . '&id=' . $id_next . '#pics_max">' . $LANG['next'] . '</a> <a href="admin_gallery.php?cat=' . $idcat . '&id=' . $id_next . '#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('pics.pics_max.list_preview_pics', array('PICS' => $pics)); } $i++; } } } else { $j = 0; $result = $Sql->query_while("SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob, g.width, g.height, m.login, m.user_id\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 = '" . $idcat . "' \n\t\t\tORDER BY g.timestamp \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']); }
$Stats = new Stats(); $Stats->load_data($stats_array, 'ellipse', 5); arsort($Stats->data_stats); $array_stats_tmp = array(); $array_order = array(); $percent_other = 0; foreach ($Stats->data_stats as $value_name => $angle_value) { if (!isset($array_stats_info[$value_name]) || $value_name == 'other') { $value_name = 'other'; $angle_value += $percent_other; $percent_other += $angle_value; $stats_img = !empty($array_stats_info['other'][1]) ? '<img src="' . $path . $array_stats_info['other'][1] . '" alt="' . $LANG['other'] . '" />' : '<img src="../templates/' . get_utheme() . '/images/stats/other.png" alt="' . $LANG['other'] . '" />'; $name_stats = $LANG['other']; } else { $stats_img = !empty($array_stats_info[$value_name][1]) ? '<img src="' . $path . $array_stats_info[$value_name][1] . '" alt="' . $array_stats_info[$value_name][0] . '" />' : '-'; $name_stats = $array_stats_info[$value_name][0]; } if (!isset($array_order[$value_name])) { $array_color = $Stats->array_allocated_color[$Stats->_image_color_allocate_dark(false, NO_ALLOCATE_COLOR)]; $array_stats_tmp[$value_name] = array($name_stats, $array_color, $stats_img); $array_order[$value_name] = $angle_value; } } foreach ($array_order as $value_name => $angle_value) { $Template->assign_block_vars('list', array('COLOR' => 'RGB(' . trim(implode(', ', $array_stats_tmp[$value_name][1]), ', ') . ')', 'IMG' => $array_stats_tmp[$value_name][2], 'L_NAME' => $array_stats_tmp[$value_name][0], 'PERCENT' => number_round($angle_value / 3.6, 1))); } } else { $Template->assign_vars(array('C_STATS_SITE' => true, 'START' => gmdate_format('date_format_short', $CONFIG['start']), 'VERSION' => $CONFIG['version'], 'L_START' => $LANG['start'], 'L_VERSION' => $LANG['version'])); } $Template->pparse('stats'); require_once '../kernel/footer.php';
$Cache->generate_file('modules'); $Cache->load('modules', RELOAD_CACHE); import('core/menu_service'); MenuService::enable_all(true); $modules_menu = MenuService::website_modules(VERTICAL_MENU); MenuService::move($modules_menu, BLOCK_POSITION__LEFT, false); MenuService::change_position($modules_menu, -$modules_menu->get_block_position()); MenuService::save($modules_menu); $Cache->generate_all_files(); $Cache->load('themes', RELOAD_CACHE); $Cache->Generate_file('css'); $Sql->close(); redirect(HOST . FILE . add_lang('?step=' . (STEP_SITE_CONFIG + 1), true)); } $template->assign_vars(array('C_SITE_CONFIG' => true, 'SITE_URL' => $server_name, 'SITE_PATH' => $server_path)); $site_timezone = number_round(date('Z') / 3600, 0) - (int) date('I'); for ($i = -12; $i <= 14; $i++) { $timezone_name = ''; if ($i === 0) { $timezone_name = 'GMT'; } elseif ($i > 0) { $timezone_name = 'GMT + ' . $i; } else { $timezone_name = 'GMT - ' . -$i; } $template->assign_block_vars('timezone', array('NAME' => $timezone_name, 'VALUE' => $i, 'SELECTED' => $i === $site_timezone ? 'selected="selected"' : '')); } $template->assign_vars(array('IMG_THEME' => DISTRIBUTION_THEME, 'U_PREVIOUS_STEP' => add_lang('install.php?step=' . (STEP_SITE_CONFIG - 1)), 'U_CURRENT_STEP' => add_lang('install.php?step=' . STEP_SITE_CONFIG), 'L_SITE_CONFIG' => $LANG['site_config_title'], 'L_SITE_CONFIG_EXPLAIN' => $LANG['site_config_explain'], 'L_YOUR_SITE' => $LANG['your_site'], 'L_SITE_URL' => $LANG['site_url'], 'L_SITE_URL_EXPLAIN' => $LANG['site_url_explain'], 'L_SITE_PATH' => $LANG['site_path'], 'L_SITE_PATH_EXPLAIN' => $LANG['site_path_explain'], 'L_SITE_NAME' => $LANG['site_name'], 'L_SITE_TIMEZONE' => $LANG['site_timezone'], 'L_SITE_TIMEZONE_EXPLAIN' => $LANG['site_timezone_explain'], 'L_SITE_DESCRIPTION' => $LANG['site_description'], 'L_SITE_DESCRIPTION_EXPLAIN' => $LANG['site_description_explain'], 'L_SITE_KEYWORDS' => $LANG['site_keywords'], 'L_SITE_KEYWORDS_EXPLAIN' => $LANG['site_keywords_explain'], 'L_PREVIOUS_STEP' => $LANG['previous_step'], 'L_NEXT_STEP' => $LANG['next_step'], 'L_REQUIRE_SITE_URL' => $LANG['require_site_url'], 'L_REQUIRE_SITE_NAME' => $LANG['require_site_name'], 'L_CONFIRM_SITE_URL' => $LANG['confirm_site_url'], 'L_CONFIRM_SITE_PATH' => $LANG['confirm_site_path'])); break; case STEP_ADMIN_ACCOUNT: $template->assign_block_vars('admin', array());
foreach ($array_cat_list as $key_cat => $option_value) { $cat_list .= $key_cat == $info_pics['idcat'] ? sprintf($option_value, 'selected="selected"') : sprintf($option_value, ''); } $activ_note = $CONFIG_GALLERY['activ_note'] == 1 && $User->check_level(MEMBER_LEVEL); if ($activ_note) { import('content/note'); $Note = new Note('gallery', $info_pics['id'], url('.php?cat=' . $info_pics['idcat'] . '&id=' . $info_pics['id'], '-' . $info_pics['idcat'] . '-' . $info_pics['id'] . '.php'), $CONFIG_GALLERY['note_max'], '', NOTE_DISPLAY_NOTE); } if ($thumbnails_before < $nbr_pics_display_before) { $end_thumbnails += $nbr_pics_display_before - $thumbnails_before; } if ($thumbnails_after < $nbr_pics_display_after) { $start_thumbnails += $nbr_pics_display_after - $thumbnails_after; } $html_protected_name = strprotect($info_pics['name'], HTML_PROTECT, ADDSLASHES_FORCE); $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']));
$Bread_crumb->add($DOWNLOAD_CATS[$id_cat_for_download]['name'], url('download.php?cat=' . $id_cat_for_download, 'category-' . $id_cat_for_download . '+' . url_encode_rewrite($DOWNLOAD_CATS[$id_cat_for_download]['name']) . '.php')); if (!empty($DOWNLOAD_CATS[$id_cat_for_download]['auth'])) { $auth_read = $auth_read && $User->check_auth($DOWNLOAD_CATS[$id_cat_for_download]['auth'], DOWNLOAD_READ_CAT_AUTH_BIT); } $id_cat_for_download = (int) $DOWNLOAD_CATS[$id_cat_for_download]['id_parent']; } if (!$auth_read) { $Errorh->handler('e_auth', E_USER_REDIRECT); } if (empty($info_file['url'])) { $Errorh->handler('e_unexist_file_download', E_USER_REDIRECT); } if ($info_file['force_download'] == DOWNLOAD_FORCE_DL && strpos($info_file['url'], '://') === false) { $info_file['url'] = second_parse_url($info_file['url']); $filesize = @filesize($info_file['url']); $filesize = $filesize !== false ? $filesize : (!empty($info_file) ? number_round($info_file['size'] * 1048576, 0) : false); if ($filesize !== false) { header('Content-Length: ' . $filesize); } header('content-type:application/force-download'); header('Content-Disposition:attachment;filename="' . substr(strrchr($info_file['url'], '/'), 1) . '"'); header('Expires:0'); header('Cache-Control:must-revalidate'); header('Pragma:public'); if (@readfile($info_file['url']) === false) { redirect($info_file['url']); } } else { redirect($info_file['url']); } } else {
} elseif ($get_error == 'already_group') { $Errorh->handler($LANG['e_already_group'], E_USER_NOTICE); } $nbr_member_group = $Sql->query("SELECT COUNT(*) FROM " . DB_TABLE_MEMBER . " WHERE user_groups = '" . $group['id'] . "'", __LINE__, __FILE__); import('util/pagination'); $Pagination = new Pagination(); 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(); $selected = $file == $group['img'] ? ' selected="selected"' : ''; $img_groups .= '<option value="' . $file . '"' . $selected . '>' . $file . '</option>'; } $array_group = unserialize($group['auth']); $Template->assign_vars(array('NAME' => $group['name'], 'IMG' => $group['img'], 'GROUP_ID' => $idgroup, 'PAGINATION' => $Pagination->display('admin_groups.php?id=' . $idgroup . '&p=%d', $nbr_member_group, 'p', 25, 3), 'THEME' => get_utheme(), 'LANG' => get_ulang(), 'IMG_GROUPS' => $img_groups, 'C_EDIT_GROUP' => true, 'AUTH_FLOOD_ENABLED' => $array_group['auth_flood'] == 1 ? 'checked="checked"' : '', 'AUTH_FLOOD_DISABLED' => $array_group['auth_flood'] == 0 ? 'checked="checked"' : '', 'PM_GROUP_LIMIT' => $array_group['pm_group_limit'], 'DATA_GROUP_LIMIT' => number_round($array_group['data_group_limit'] / 1024, 2), 'COLOR_GROUP' => $group['color'], 'L_REQUIRE_PSEUDO' => $LANG['require_pseudo'], 'L_REQUIRE_LOGIN' => $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_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_YES' => $LANG['yes'], 'L_NO' => $LANG['no'], 'L_ADD' => $LANG['add'], 'L_MB' => $LANG['unit_megabytes'], 'L_MBR_GROUP' => $LANG['mbrs_group'], 'L_PSEUDO' => $LANG['pseudo'], 'L_SEARCH' => $LANG['search'], 'L_UPDATE' => $LANG['update'], 'L_RESET' => $LANG['reset'], 'L_DELETE' => $LANG['delete'], 'L_ADD_MBR_GROUP' => $LANG['add_mbr_group'])); $members = $Sql->query("SELECT members FROM " . DB_TABLE_GROUP . " WHERE id = '" . numeric($group['id']) . "'", __LINE__, __FILE__); $members = explode('|', $members); foreach ($members as $key => $user_id) { $login = $Sql->query("SELECT login FROM " . DB_TABLE_MEMBER . " WHERE user_id = '" . numeric($user_id) . "'", __LINE__, __FILE__); if (!empty($login)) { $Template->assign_block_vars('member', array('USER_ID' => $user_id, 'LOGIN' => $login, 'U_USER_ID' => url('.php?id=' . $user_id, '-' . $user_id . '.php'))); } } } 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>';
$table_structure = $backup->extract_table_structure(array($table)); if (!isset($backup->tables[$table])) { redirect(HOST . DIR . '/database/admin_database.php'); } foreach ($table_structure['fields'] as $fields_info) { $primary_key = false; foreach ($table_structure['index'] as $index_info) { if ($index_info['type'] == 'PRIMARY KEY' && in_array($fields_info['name'], explode(',', $index_info['fields']))) { $primary_key = true; break; } } $Template->assign_block_vars('field', array('FIELD_NAME' => $primary_key ? '<span style="text-decoration:underline">' . $fields_info['name'] . '<span>' : $fields_info['name'], 'FIELD_TYPE' => $fields_info['type'], 'FIELD_ATTRIBUTE' => $fields_info['attribute'], 'FIELD_NULL' => $fields_info['null'] ? '<strong>' . $LANG['yes'] . '</strong>' : $LANG['no'], 'FIELD_DEFAULT' => $fields_info['default'], 'FIELD_EXTRA' => $fields_info['extra'])); } foreach ($table_structure['index'] as $index_info) { $Template->assign_block_vars('index', array('INDEX_NAME' => $index_info['name'], 'INDEX_TYPE' => $index_info['type'], 'INDEX_FIELDS' => str_replace(',', '<br />', $index_info['fields']))); } $free = number_round($backup->tables[$table]['data_free'] / 1024, 1); $data = number_round($backup->tables[$table]['data_length'] / 1024, 1); $index = number_round($backup->tables[$table]['index_lenght'] / 1024, 1); $total = $index + $data; $l_total = $total > 1024 ? number_round($total / 1024, 1) . ' MB' : $total . ' kB'; $free = $free > 1024 ? number_round($free / 1024, 1) . ' MB' : $free . ' kB'; $data = $data > 1024 ? number_round($data / 1024, 1) . ' MB' : $data . ' kB'; $index = $index > 1024 ? number_round($index / 1024, 1) . ' MB' : $index . ' kB'; $Template->assign_vars(array('C_DATABASE_TABLE_STRUCTURE' => true, 'C_DATABASE_TABLE_DATA' => false, 'C_AUTOINDEX' => !empty($backup->tables[$table]['auto_increment']) ? true : false, 'TABLE_ENGINE' => $backup->tables[$table]['engine'], 'TABLE_ROW_FORMAT' => $backup->tables[$table]['row_format'], 'TABLE_ROWS' => $backup->tables[$table]['rows'], 'TABLE_DATA' => $data != 0 ? $data : '-', 'TABLE_INDEX' => $index != 0 ? $index : '-', 'TABLE_TOTAL_SIZE' => $total != 0 ? $l_total : '-', 'TABLE_FREE' => $free != 0 ? '<span style="color:red">' . $free . '</span>' : '-', 'TABLE_COLLATION' => $backup->tables[$table]['collation'], 'TABLE_AUTOINCREMENT' => $backup->tables[$table]['auto_increment'], 'TABLE_CREATION_DATE' => gmdate_format('date_format_long', strtotime($backup->tables[$table]['create_time'])), 'TABLE_LAST_UPDATE' => gmdate_format('date_format_long', strtotime($backup->tables[$table]['update_time'])), 'L_TABLE_FIELD' => $LANG['db_table_field'], 'L_TABLE_TYPE' => $LANG['type'], 'L_TABLE_ATTRIBUTE' => $LANG['db_table_attribute'], 'L_TABLE_NULL' => $LANG['db_table_null'], 'L_TABLE_DEFAULT' => $LANG['default'], 'L_TABLE_EXTRA' => $LANG['db_table_extra'], 'L_TABLE_NAME' => $LANG['db_table_name'], 'L_TABLE_ROWS' => $LANG['db_table_rows'], 'L_TABLE_ROWS_FORMAT' => $LANG['db_table_rows_format'], 'L_TABLE_ENGINE' => $LANG['db_table_engine'], 'L_TABLE_COLLATION' => $LANG['db_table_collation'], 'L_TABLE_DATA' => $LANG['db_table_data'], 'L_TABLE_TOTAL' => $LANG['total'], 'L_INDEX_NAME' => $LANG['name'], 'L_TABLE_INDEX' => $LANG['db_table_index'], 'L_TABLE_FREE' => $LANG['db_table_free'], 'L_STATISTICS' => $LANG['stats'], 'L_OPTIMIZE' => $LANG['db_optimize'], 'L_AUTOINCREMENT' => $LANG['db_autoincrement'], 'L_LAST_UPDATE' => $LANG['last_update'], 'L_CREATION_DATE' => $LANG['creation_date'], 'L_OPTIMIZE' => $LANG['db_optimize'], 'L_SIZE' => $LANG['size'])); } else { redirect(HOST . DIR . '/database/admin_database.php'); } $Template->pparse('admin_database_tools'); require_once '../admin/admin_footer.php';
} elseif (!empty($id)) { $Template->set_filenames(array('admin_poll_management2' => 'poll/admin_poll_management2.tpl')); $row = $Sql->query_array(PREFIX . 'poll', '*', "WHERE id = '" . $id . "'", __LINE__, __FILE__); $Template->assign_vars(array('IDPOLL' => $row['id'], 'QUESTIONS' => $row['question'], 'TYPE_UNIQUE' => $row['type'] == '1' ? 'checked="checked"' : '', 'TYPE_MULTIPLE' => $row['type'] == '0' ? 'checked="checked"' : '', 'ARCHIVES_ENABLED' => $row['archive'] == '1' ? 'checked="checked"' : '', 'ARCHIVES_DISABLED' => $row['archive'] == '0' ? 'checked="checked"' : '', 'CURRENT_DATE' => gmdate_format('date_format_short', $row['timestamp']), 'DAY_RELEASE_S' => !empty($row['start']) ? gmdate_format('d', $row['start']) : '', 'MONTH_RELEASE_S' => !empty($row['start']) ? gmdate_format('m', $row['start']) : '', 'YEAR_RELEASE_S' => !empty($row['start']) ? gmdate_format('Y', $row['start']) : '', 'DAY_RELEASE_E' => !empty($row['end']) ? gmdate_format('d', $row['end']) : '', 'MONTH_RELEASE_E' => !empty($row['end']) ? gmdate_format('m', $row['end']) : '', 'YEAR_RELEASE_E' => !empty($row['end']) ? gmdate_format('Y', $row['end']) : '', 'DAY_DATE' => !empty($row['timestamp']) ? gmdate_format('d', $row['timestamp']) : '', 'MONTH_DATE' => !empty($row['timestamp']) ? gmdate_format('m', $row['timestamp']) : '', 'YEAR_DATE' => !empty($row['timestamp']) ? gmdate_format('Y', $row['timestamp']) : '', 'VISIBLE_WAITING' => $row['visible'] == 2 || !empty($row['end']) ? 'checked="checked"' : '', 'VISIBLE_ENABLED' => $row['visible'] == 1 && empty($row['end']) ? 'checked="checked"' : '', 'VISIBLE_UNAPROB' => $row['visible'] == 0 ? 'checked="checked"' : '', 'START' => !empty($row['start']) ? gmdate_format('date_format_short', $row['start']) : '', 'END' => !empty($row['end']) ? gmdate_format('date_format_short', $row['end']) : '', 'HOUR' => gmdate_format('H', $row['timestamp']), 'MIN' => gmdate_format('i', $row['timestamp']), 'DATE' => gmdate_format('date_format_short', $row['timestamp']), 'L_REQUIRE_QUESTION' => $LANG['require_question'], 'L_REQUIRE_ANSWER' => $LANG['require_answer'], 'L_REQUIRE_ANSWER_TYPE' => $LANG['require_answer_type'], '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_ANSWER_TYPE' => $LANG['answer_type'], 'L_ANSWERS' => $LANG['answers'], 'L_SINGLE' => $LANG['single'], 'L_MULTIPLE' => $LANG['multiple'], 'L_ARCHIVED' => $LANG['archived'], 'L_YES' => $LANG['yes'], 'L_NO' => $LANG['no'], 'L_NUMBER_VOTE' => $LANG['number_vote'], 'L_DATE' => $LANG['date'], 'L_POLL_DATE' => $LANG['poll_date'], 'L_RELEASE_DATE' => $LANG['release_date'], 'L_IMMEDIATE' => $LANG['immediate'], 'L_UNAPROB' => $LANG['unaprob'], 'L_UNTIL' => $LANG['until'], 'L_UPDATE' => $LANG['update'], 'L_RESET' => $LANG['reset'], 'L_DELETE' => $LANG['delete'])); $get_error = retrieve(GET, 'error', ''); if ($get_error == 'incomplete') { $Errorh->handler($LANG['incomplete'], E_USER_NOTICE); } $array_answer = explode('|', $row['answers']); $array_vote = explode('|', $row['votes']); $sum_vote = array_sum($array_vote); $sum_vote = $sum_vote == 0 ? 1 : $sum_vote; $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) {
$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; } } } $Template->pparse('wiki_search'); require_once '../kernel/footer.php';
while ($row = $Sql->fetch_assoc($result)) { $title = $row['title']; if (!empty($row['title'])) { $title = strlen(html_entity_decode($row['title'], ENT_COMPAT, 'ISO-8859-1')) > 45 ? substr_html($row['title'], 0, 45) . '...' : $row['title']; } $rewrited_title = $CONFIG['rewrite'] == 1 ? '+' . url_encode_rewrite($row['title']) : ''; $relevance = max($row['relevance'], $row['relevance2']); $contents = $row['contents']; if ($colorate_result) { $array_search = explode(' ', $search); foreach ($array_search as $token) { $contents = preg_replace_callback('`(.*)(' . preg_quote($token) . ')(.*)`isU', 'token_colorate', $contents); $title = preg_replace_callback('`(.*)(' . preg_quote($token) . ')(.*)`isU', 'token_colorate', $title); } } $Template->assign_block_vars('list', array('USER_ONLINE' => '<img src="../templates/' . get_utheme() . '/images/' . (!empty($row['connect']) && $row['user_id'] !== -1 ? 'online' : 'offline') . '.png" alt="" class="valign_middle" />', 'USER_PSEUDO' => !empty($row['login']) ? '<a class="msg_link_pseudo" href="../member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') . '">' . wordwrap_html($row['login'], 13) . '</a>' : '<em>' . $LANG['guest'] . '</em>', 'CONTENTS' => second_parse($contents), 'RELEVANCE' => $relevance > $max_relevance ? '100' : number_round($relevance * 100 / $max_relevance, 2), 'DATE' => gmdate_format('d/m/y', $row['timestamp']), 'U_TITLE' => '<a class="small_link" href="../forum/topic' . url('.php?id=' . $row['idtopic'], '-' . $row['idtopic'] . $rewrited_title . '.php') . '#m' . $row['msgid'] . '">' . ucfirst($title) . '</a>')); $check_result = true; } $Sql->query_close($result); if ($check_result !== true) { $Errorh->handler($LANG['no_result'], E_USER_NOTICE); } else { $Template->assign_vars(array('C_FORUM_SEARCH' => true)); } } else { $Errorh->handler($LANG['invalid_req'], E_USER_NOTICE); } } elseif (!empty($valid_search)) { $Errorh->handler($LANG['invalid_req'], E_USER_WARNING); } list($users_list, $total_admin, $total_modo, $total_member, $total_visit, $total_online) = forum_list_user_online("AND s.session_script = '/forum/search.php'");