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