$query['LIMIT'] = "{$start}, {$perpage}";
$result = $SQL->build($query);
while ($row = $SQL->fetch_array($result)) {
//make new lovely arrays !!
$g_sz[$row['id']] = isset($_POST['gsz' . $row['id']]) ? $_POST['gsz' . $row['id']] : $row['gust_size'];
$u_sz[$row['id']] = isset($_POST['usz' . $row['id']]) ? $_POST['usz' . $row['id']] : $row['user_size'];
$arr[] = array('id' => $row['id'], 'name' => $row['ext'], 'group' => ch_g(false, $row['group_id'], true), 'g_size' => round($g_sz[$row['id']] / 1024), 'g_allow' => (int) $row['gust_allow'] ? true : false, 'u_size' => round($u_sz[$row['id']] / 1024), 'u_allow' => (int) $row['user_allow'] ? true : false, 'ug_allow' => $row['gust_allow'] && $row['user_allow'] ? true : false);
}
$SQL->freeresult($result_p);
$SQL->freeresult($result);
} else {
$no_results = true;
}
//pages
$total_pages = $Pager->getTotalPages();
$arr_paging = $Pager->print_nums(basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php'));
$gr_exts_arr = ch_g('new_ext_group', 9);
//after submit
if (isset($_POST['submit'])) {
if (!is_array($_POST['gsz'])) {
$_POST['gsz'] = array();
}
$affected = false;
foreach ($_POST['gsz'] as $n => $v) {
$update_query = array('UPDATE' => "{$dbprefix}exts", 'SET' => "gust_size = '" . round(intval($_POST['gsz'][$n]) * 1024) . "', " . "gust_allow = '" . (isset($_POST['gal'][$n]) ? 1 : 0) . "', " . "user_size = '" . round(intval($_POST['usz'][$n]) * 1024) . "', " . "user_allow = '" . (isset($_POST['ual'][$n]) ? 1 : 0) . "'", 'WHERE' => "id=" . intval($n));
$SQL->build($update_query);
if ($SQL->affected()) {
$affected = true;
}
}
//delete cache ..
$send = send_mail($to, $message, $subject, $config['sitemail'], $config['sitename']);
if ($send) {
//
//We will redirect to pages of results and show info msg there !
//
kleeja_admin_info($lang['IS_SEND_MAIL'], true, '', true, basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&page=' . (isset($_GET['page']) ? intval($_GET['page']) : 1) . '&sent=' . $row['id']);
} else {
kleeja_admin_err($lang['ERR_SEND_MAIL'], true, '', true, basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&page=' . (isset($_GET['page']) ? intval($_GET['page']) : 1) . '&sent=' . $row['id']);
}
}
}
}
$SQL->freeresult($result);
} else {
$no_results = true;
}
//if deleted
if (sizeof($del_nums)) {
$query_del = array('DELETE' => "{$dbprefix}reports", 'WHERE' => "id IN('" . implode("', '", $del_nums) . "')");
$SQL->build($query_del);
}
$total_pages = $Pager->getTotalPages();
$page_nums = $Pager->print_nums(basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php'), 'onclick="javascript:get_kleeja_link($(this).attr(\'href\'), \'#content\'); return false;"');
//after submit
if (isset($_POST['submit'])) {
$text = $SQL->affected() ? $lang['REPORTS_UPDATED'] : $lang['NO_UP_CHANGE_S'];
$text .= '<script type="text/javascript"> setTimeout("get_kleeja_link(\'' . $action . '\'); check_msg_and_reports();", 2000);</script>' . "\n";
kleeja_admin_info($text, true, '', true, $action);
}
//secondary menu
$go_menu = array('general' => array('name' => $lang['R_REPORTS'], 'link' => basename(ADMIN_PATH) . '?cp=f_reports&smt=general', 'goto' => 'general', 'current' => $current_smt == 'general'), 'show_h24' => array('name' => $lang['SHOW_FROM_24H'], 'link' => basename(ADMIN_PATH) . '?cp=f_reports&smt=show_h24', 'goto' => 'show_h24', 'current' => $current_smt == 'show_h24'), 'del_d30' => array('name' => $lang['DELETE_EARLIER_30DAYS'], 'link' => basename(ADMIN_PATH) . '?cp=f_reports&smt=del_d30', 'goto' => 'del_d30', 'current' => $current_smt == 'del_d30', 'confirm' => true), 'del_all' => array('name' => $lang['DELETE_ALL'], 'link' => basename(ADMIN_PATH) . '?cp=f_reports&smt=del_all', 'goto' => 'del_all', 'current' => $current_smt == 'del_all', 'confirm' => true));
$affected = true;
}
}
}
*/
} else {
$no_results = true;
}
#update f_lastvisit
if (!$is_search) {
if (filter_exists('i_lastvisit', 'filter_uid')) {
update_filter('i_lastvisit', time());
} else {
insert_filter('lastvisit', time(), false, false, '', 'i_lastvisit');
}
}
//pages
$total_pages = $Pager->getTotalPages();
$page_nums = $Pager->print_nums(basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . (isset($_GET['last_visit']) ? '&last_vists=' . intval($_GET['last_visit']) : ''), 'onclick="javascript:get_kleeja_link($(this).attr(\'href\'), \'#content\'); return false;"');
$current_page = $Pager->currentPage;
}
/*
//after submit
if(isset($_POST['submit']))
{
$text = ($affected ? $lang['FILES_UPDATED'] : $lang['NO_UP_CHANGE_S']) .
'<script type="text/javascript"> setTimeout("get_kleeja_link(\'' . basename(ADMIN_PATH) . '?cp=' . basename(__file__, '.php') .
'&page=' . (isset($_GET['page']) ? intval($_GET['page']) : '1') . '\');", 2000);</script>' . "\n";
$stylee = "admin_info";
}*/
$sizes += $row['size'];
}
}
}
$SQL->freeresult($result);
if (isset($_POST['submit'])) {
//no files to delete
if (isset($ids) && sizeof($ids)) {
$query_del = array('DELETE' => "{$dbprefix}files", 'WHERE' => "id IN (" . implode(',', $ids) . ")");
$SQL->build($query_del);
//update number of stats
$update_query = array('UPDATE' => "{$dbprefix}stats", 'SET' => "sizes=sizes-{$sizes}, files=files-{$num}");
$SQL->build($update_query);
if ($SQL->affected()) {
$affected = true;
delete_cache('data_stats');
}
}
}
} else {
//no result ..
$no_results = true;
}
//some vars
$total_pages = $Pager->getTotalPages();
$page_nums = $Pager->print_nums($page_action);
//after submit
if (isset($_POST['submit'])) {
$text = ($affected ? $lang['FILES_UPDATED'] : $lang['NO_UP_CHANGE_S']) . '<meta HTTP-EQUIV="REFRESH" content="2; url=' . $action . '">' . "\n";
$stylee = "admin_info";
}
$affected = true;
delete_cache('data_stats');
}
}
//update
$admin[$row['id']] = isset($_POST['ad_' . $row['id']]) ? 1 : 0;
$user_salt = substr(kleeja_base64_encode(pack("H*", sha1(mt_rand()))), 0, 7);
$pass[$row['id']] = $pass[$row['id']] != '' ? "password = '******'id']]) . $user_salt) . "', password_salt='" . $user_salt . "'," : '';
$update_query = array('UPDATE' => "{$dbprefix}users", 'SET' => "name = '" . $SQL->escape($name[$row['id']]) . "',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tmail = '" . $SQL->escape($mail[$row['id']]) . "',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t" . $pass[$row['id']] . "\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tadmin = " . intval($admin[$row['id']]) . ",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tclean_name = '" . $SQL->escape($usrcp->cleanusername($name[$row['id']])) . "'", 'WHERE' => 'id=' . $row['id']);
$SQL->build($update_query);
if ($SQL->affected()) {
$affected = true;
}
}
}
$SQL->freeresult($result);
} else {
$no_results = true;
}
//pages
$total_pages = $Pager->getTotalPages();
$page_nums = $Pager->print_nums(basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . (isset($_GET['search']) ? '&search=' . strip_tags($_GET['search']) : ''));
//if not noraml user system
$user_not_normal = (int) $config['user_system'] != 1 ? true : false;
//after submit
if (isset($_POST['submit']) || isset($_POST['newuser'])) {
$text = ($affected ? $lang['USERS_UPDATED'] : $lang['NO_UP_CHANGE_S']) . '<meta HTTP-EQUIV="REFRESH" content="0; url=' . basename(ADMIN_PATH) . '?cp=';
$text .= basename(__FILE__, '.php') . '&page=' . (isset($_GET['page']) ? intval($_GET['page']) : 1) . (isset($_GET['search']) ? '&search=' . strip_tags($_GET['search']) : '');
$text .= (isset($_GET['admin']) && $_GET['admin'] == '1' ? '&admin=1' : '') . '">' . "\n";
$stylee = "admin_info";
}
$titlee = $lang['FILECP'];
$H_FORM_KEYS = kleeja_add_form_key('filecp');
//no logon before
if (!$usrcp->name()) {
kleeja_info($lang['PLACE_NO_YOU'], $lang['USER_PLACE']);
}
//te get files and update them !!
$query = array('SELECT' => 'f.id ,f.name, f.real_filename, f.type, f.folder, f.size', 'FROM' => "{$dbprefix}files f", 'WHERE' => 'f.user='******'ORDER BY' => 'f.id DESC');
//pager
$result_p = $SQL->build($query);
$nums_rows = $SQL->num_rows($result_p);
$currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1;
$Pager = new SimplePager($perpage, $nums_rows, $currentPage);
$start = $Pager->getStartRow();
$linkgoto = $config['siteurl'] . ($config['mod_writer'] ? 'filecp' : 'ucp.php?go=filecp');
$page_nums = $Pager->print_nums($linkgoto);
$action = "ucp.php?go=filecp&page={$currentPage}";
$total_pages = $Pager->getTotalPages();
//now, there is no result
$no_results = false;
if ($nums_rows != 0) {
$query['LIMIT'] = "{$start}, {$perpage}";
($hook = kleeja_run_hook('qr_select_files_in_filecp')) ? eval($hook) : null;
//run hook
$result = $SQL->build($query);
$sizes = $num = 0;
$i = $currentPage * $perpage - $perpage;
while ($row = $SQL->fetch_array($result)) {
$del[$row['id']] = isset($_POST['del_' . $row['id']]) ? $_POST['del_' . $row['id']] : '';
$file_info = array('::ID::' => $row['id'], '::NAME::' => $row['name'], '::DIR::' => $row['folder'], '::FNAME::' => $row['real_filename']);
$is_image = in_array(strtolower(trim($row['type'])), array('gif', 'jpg', 'jpeg', 'bmp', 'png', 'tiff', 'tif')) ? true : false;
#for username in integrated user system
if ($row['user'] != '-1' and (int) $config['user_system'] != 1) {
if (!in_array($row['user'], $ids_and_names)) {
$row['username'] = $usrcp->usernamebyid($row['user']);
$ids_and_names[$row['user']] = $row['username'];
} else {
$row['username'] = $ids_and_names[$row['user']];
}
}
//make new lovely arrays !!
$arr[] = array('id' => $row['id'], 'name' => "<a title=\" " . ($row['real_filename'] == '' ? $row['name'] : $row['real_filename']) . "\" href=\"./" . PATH . $row['folder'] . "/" . $row['name'] . "\" target=\"blank\">" . ($row['real_filename'] == '' ? strlen($row['name']) > 20 ? substr($row['name'], 0, 20) . '...' : $row['name'] : (strlen($row['real_filename']) > 20 ? substr($row['real_filename'], 0, 20) . '...' : $row['real_filename'])) . "</a>", 'size' => Customfile_size($row['size']), 'ups' => $row['uploads'], 'direct' => $row['id_form'] == 'direct' ? true : false, 'time_human' => kleeja_date($row['time']), 'time' => kleeja_date($row['time'], false), 'type' => $row['type'], 'typeicon' => file_exists(PATH . "images/filetypes/" . $row['type'] . ".png") ? PATH . "images/filetypes/" . $row['type'] . ".png" : PATH . 'images/filetypes/file.png', 'folder' => $row['folder'], 'report' => $row['report'] > 4 ? "<span style=\"color:red;font-weight:bold\">" . $row['report'] . "</span>" : $row['report'], 'user' => $row['user'] == '-1' ? $lang['GUST'] : '<a href="' . $userfile . '" target="_blank">' . $row['username'] . '</a>', 'ip' => '<a href="http://www.ripe.net/whois?form_type=simple&full_query_string=&searchtext=' . $row['user_ip'] . '&do_search=Search" target="_new">' . $row['user_ip'] . '</a>', 'showfilesbyip' => basename(ADMIN_PATH) . '?cp=h_search&s_input=1&s_value=' . $row['user_ip']);
$del[$row['id']] = isset($_POST['del_' . $row['id']]) ? $_POST['del_' . $row['id']] : '';
}
$SQL->freeresult($result);
} else {
//no result ..
$no_results = true;
}
#update f_lastvisit
if (!$is_search) {
if (filter_exists('f_lastvisit', 'filter_uid')) {
update_filter('f_lastvisit', time());
} else {
insert_filter('lastvisit', time(), false, false, '', 'f_lastvisit');
}
}
//some vars
$total_pages = $Pager->getTotalPages();
$page_nums = $Pager->print_nums($page_action, 'onclick="javascript:get_kleeja_link($(this).attr(\'href\'), \'#content\'); return false;"');
$current_page = $Pager->currentPage;
}
}
if (!$data_user['show_my_filecp'] && $usrcp->id() != $user_id && !user_can('enter_acp')) {
kleeja_info($lang['USERFILE_CLOSED'], $lang['CLOSED_FEATURE']);
}
$query = array('SELECT' => 'f.id, f.name, f.real_filename, f.folder, f.type, f.uploads, f.time, f.size', 'FROM' => "{$dbprefix}files f", 'WHERE' => 'f.user='******'ORDER BY' => 'f.id DESC');
//pager
$perpage = 16;
$result_p = $SQL->build($query);
$nums_rows = $SQL->num_rows($result_p);
$currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1;
$Pager = new SimplePager($perpage, $nums_rows, $currentPage);
$start = $Pager->getStartRow();
$your_fileuser = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $usrcp->id() . '.html' : 'ucp.php?go=fileuser&id=' . $usrcp->id());
$total_pages = $Pager->getTotalPages();
$linkgoto = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $user_id . '.html' : 'ucp.php?go=fileuser&id=' . $user_id);
$page_nums = $Pager->print_nums(str_replace('.html', '', $linkgoto));
$no_results = true;
if ((int) $config['user_system'] != 1 && $usrcp->id() != $user_id) {
$data_user['name'] = $usrcp->usernamebyid($user_id);
}
$user_name = !$data_user['name'] ? false : $data_user['name'];
#set page title
$titlee = $lang['FILEUSER'] . ': ' . $user_name;
#there is result ? show them
if ($nums_rows != 0) {
$no_results = false;
$query['LIMIT'] = "{$start}, {$perpage}";
($hook = kleeja_run_hook('qr_select_files_in_fileuser')) ? eval($hook) : null;
//run hook
$result = $SQL->build($query);
$i = $currentPage * $perpage - $perpage;
$no_results = false;
if ($nums_rows > 0) {
$query['SELECT'] = 'id, name, founder, group_id, last_visit';
$query['LIMIT'] = "{$start}, {$perpage}";
$result = $SQL->build($query);
while ($row = $SQL->fetch_array($result)) {
$userfile = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $row['id'] . '.html' : 'ucp.php?go=fileuser&id=' . $row['id']);
$arr[] = array('id' => $row['id'], 'name' => $row['name'], 'userfile_link' => $userfile, 'delusrfile_link' => $row['founder'] && (int) $userinfo['founder'] == 0 ? false : basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&deleteuserfile=' . $row['id'] . (isset($_GET['page']) ? '&page=' . intval($_GET['page']) : ''), 'delusr_link' => $userinfo['id'] == $row['id'] || $row['founder'] && (int) $userinfo['founder'] == 0 ? false : basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&del_user='******'id'] . (isset($_GET['page']) ? '&page=' . intval($_GET['page']) : ''), 'editusr_link' => $row['founder'] && (int) $userinfo['founder'] == 0 ? false : basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&smt=edit_user&uid=' . $row['id'] . (isset($_GET['page']) ? '&page=' . intval($_GET['page']) : ''), 'founder' => (int) $row['founder'], 'last_visit' => empty($row['last_visit']) ? $lang['NOT_YET'] : kleeja_date($row['last_visit']), 'group' => str_replace(array('{lang.ADMINS}', '{lang.USERS}', '{lang.GUESTS}'), array($lang['ADMINS'], $lang['USERS'], $lang['GUESTS']), $d_groups[$row['group_id']]['data']['group_name']));
}
$SQL->freeresult($result);
} else {
$no_results = true;
}
//pages
$total_pages = $Pager->getTotalPages();
$page_nums = $Pager->print_nums(basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . (isset($_GET['search_id']) ? '&search_id=' . htmlspecialchars($_GET['search_id']) : '') . (isset($_GET['qg']) ? '&qg=' . intval($_GET['qg']) : '') . (isset($_GET['smt']) ? '&smt=' . $current_smt : ''), 'onclick="javascript:get_kleeja_link($(this).attr(\'href\'), \'#content\'); return false;"');
$show_results = true;
break;
#editing a user, form
#editing a user, form
case 'edit_user':
//is exists ?
if (!isset($userid)) {
$userid = intval($_GET['uid']);
if (!$SQL->num_rows($SQL->query("SELECT * FROM {$dbprefix}users WHERE id=" . $userid))) {
kleeja_admin_err('ERROR-NO-USER-FOUND', true, '', true, basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php'));
}
}
$query = array('SELECT' => 'name, mail, group_id, founder, show_my_filecp', 'FROM' => "{$dbprefix}users", 'WHERE' => 'id=' . $userid);
$result = $SQL->build($query);
$udata = $SQL->fetch_array($result);
