function curr_file($file_id)
{
global $db, $tpf, $settings, $code;
$file = $db->fetch_one_array("select * from {$tpf}files where file_id='{$file_id}'");
if (!$file) {
$file['is_del'] = 1;
} else {
$file['dl'] = create_down_url($file);
$in_extract = $code == md5($file['file_key']) ? 1 : 0;
$file['username'] = $file['p_name'] = @$db->result_first("select username from {$tpf}users where userid='{$file['userid']}' limit 1");
$rs = $db->fetch_one_array("select folder_id,folder_name from {$tpf}folders where userid='{$file['userid']}' and folder_id='{$file['folder_id']}'");
$file['file_category'] = $rs['folder_name'] ? '<a href="' . urr("space", "username="******"&folder_id=" . $rs['folder_id']) . '" target="_blank">' . $rs['folder_name'] . '</a>' : '- ' . __('uncategory') . ' -';
$file_key = trim($file['file_key']);
$tmp_ext = $file['file_extension'] ? '.' . $file['file_extension'] : "";
$file_extension = $file['file_extension'];
$file_ext = get_real_ext($file_extension);
$file['file_description'] = str_replace('<br>', LF, $file[file_description]);
$file['a_space'] = urr("space", "username="******"Y-m-d", $file['file_time']);
$file['credit_down'] = $file['file_credit'] ? (int) $file['file_credit'] : (int) $settings['credit_down'];
$file['username'] = $file[user_hidden] ? __('hidden') : ($file['username'] ? '<a href="' . $file['a_space'] . '">' . $file['username'] . '</a>' : __('hidden'));
$file['file_downs'] = $file['stat_hidden'] ? __('hidden') : get_discount($file[userid], $file['file_downs']);
$file['file_views'] = $file['stat_hidden'] ? __('hidden') : get_discount($file[userid], $file['file_views']);
$file['file_url'] = $settings['phpdisk_url'] . urr("viewfile", "file_id={$file['file_id']}");
if (get_plans(get_profile($file[userid], 'plan_id'), 'open_second_page') == 3) {
$file['a_downfile'] = urr("download", "file_id={$file_id}&key=" . random(32));
$file['a_downfile2'] = urr("download", "file_id={$file_id}&key=" . random(32));
}
}
return $file;
}
function curr_file($file_id)
{
global $db, $tpf, $settings;
$file = $db->fetch_one_array("select * from {$tpf}files where file_id='{$file_id}' and is_del=0");
if (!$file) {
$file['is_del'] = 1;
$file['file_name'] = __('visited_tips');
} else {
$file[dl] = create_down_url($file);
$file['is_del'] = 0;
$file_key = trim($file['file_key']);
$tmp_ext = $file['file_extension'] ? '.' . $file['file_extension'] : "";
$file_extension = $file['file_extension'];
$file_ext = get_real_ext($file_extension);
$file_description = $file['file_description'];
$file['file_description'] = nl2br($file['file_description']);
$file['a_space'] = urr("space", "username="******"viewfile", "file_id={$file['file_id']}");
return $file;
}
}
$ins = array('scope' => $scope, 'word' => $word, 'search_time' => $timestamp, 'total_count' => 1, 'file_ids' => '', 'ip' => $onlineip);
$db->query("insert into {$tpf}search_index set " . $db->sql_array($ins) . ";");
}
break;
}
$perpage = 20;
$rs = $db->fetch_one_array("select count(*) as total_num from {$sql_do}");
$total_num = $rs['total_num'];
$start_num = ($pg - 1) * $perpage;
$q = $db->query("select fl.userid,file_id,file_key,file_name,file_extension,file_size,file_time,server_oid,file_store_path,file_real_name,is_image,file_downs,file_views,u.username from {$sql_do} order by {$sql_order} limit {$start_num},{$perpage}");
$files_array = array();
while ($rs = $db->fetch_array($q)) {
$tmp_ext = $rs['file_extension'] ? '.' . $rs['file_extension'] : "";
$rs['file_thumb'] = get_file_thumb($rs);
$rs['file_name_all'] = str_ireplace($word, '<span class=txtred>' . $word . '</span>', filter_word($rs['file_name'] . $tmp_ext));
$rs[file_name] = filter_word($rs['file_name'] . $tmp_ext);
$rs['file_size'] = get_size($rs['file_size']);
$rs['file_time'] = date("Y-m-d", $rs['file_time']);
$rs['a_downfile'] = urr("downfile", "file_id={$rs['file_id']}&file_key={$rs['file_key']}");
$rs['a_viewfile'] = urr("viewfile", "file_id={$rs['file_id']}");
$rs[file_description] = clear_html($rs[file_description], 50);
$rs['a_space'] = urr("space", "username=" . rawurlencode($rs['username']));
//$file_ids .= $rs['file_id'].',';
$files_array[] = $rs;
}
$db->free($q);
unset($rs);
$n_t = $n == 'asc' ? 'desc' : 'asc';
$u_t = $u == 'asc' ? 'desc' : 'asc';
$s_t = $s == 'asc' ? 'desc' : 'asc';
$t_t = $t == 'asc' ? 'desc' : 'asc';
unset($rs);
return $file_ids;
}
$file_ids = get_file_ids($tag);
$file_ids = substr($file_ids, -1) == ',' ? substr($file_ids, 0, -1) : $file_ids;
if (!$file_ids) {
header("Location: " . urr("tag", ""));
exit;
}
$sql_do = "{$tpf}files where file_id in ({$file_ids})";
$rs = $db->fetch_one_array("select count(*) as total_num from {$sql_do}");
$total_num = $rs['total_num'];
$start_num = ($pg - 1) * $perpage;
$q = $db->query("select file_id,file_key,file_name,file_extension,file_size,file_time,server_oid,file_store_path,file_real_name,is_image from {$sql_do} order by file_id desc limit {$start_num},{$perpage}");
$files_array = array();
while ($rs = $db->fetch_array($q)) {
$tmp_ext = $rs['file_extension'] ? '.' . $rs['file_extension'] : "";
$rs['file_thumb'] = get_file_thumb($rs);
$rs['file_name_all'] = filter_word($rs['file_name'] . $tmp_ext);
$rs['file_name'] = cutstr(filter_word($rs['file_name'] . $tmp_ext), 35);
$rs['file_size'] = get_size($rs['file_size']);
$rs['file_time'] = custom_time("Y-m-d", $rs['file_time']);
$rs['a_viewfile'] = urr("viewfile", "file_id={$rs['file_id']}");
$files_array[] = $rs;
}
$db->free($q);
unset($rs);
$page_nav = multi($total_num, $perpage, $pg, urr("tag", "tag=" . rawurlencode($tag)));
}
require_once template_echo('pd_tag', $user_tpl_dir);
include PHPDISK_ROOT . "./includes/footer.inc.php";
$in_front = true;
$title = __('extract_file') . ' - ' . $settings['site_title'];
include PHPDISK_ROOT . "./includes/header.inc.php";
switch ($action) {
case 'file_extract':
form_auth(gpc('formhash', 'P', ''), formhash());
$extract_code = trim(gpc('extract_code', 'P', ''));
if (strlen($extract_code) == 8) {
$rs = $db->fetch_one_array("select fl.*,u.username from {$tpf}files fl,{$tpf}users u where u.userid=fl.userid and file_key='{$extract_code}'");
if ($rs) {
$tmp_ext = $rs['file_extension'] ? '.' . $rs['file_extension'] : "";
$rs[a_space] = urr("space", "username="******"Y-m-d H:i", $rs['file_time']);
$rs['a_viewfile'] = urr("viewfile", "file_id={$rs[file_id]}");
$rs[file_description] = clear_html(filter_word($rs[file_description]), 50);
$files_array[] = $rs;
} else {
$sysmsg[] = __('extract_code_not_found');
}
unset($rs);
}
require_once template_echo('pd_extract', $user_tpl_dir);
break;
default:
require_once template_echo('pd_extract', $user_tpl_dir);
}
include PHPDISK_ROOT . "./includes/footer.inc.php";
$sql_do = " {$tpf}files fl," . get_table_day_down() . " dd,{$tpf}users u where fl.file_id=dd.file_id and fl.userid=u.userid {$cate_sql} and dd.d_week='{$d_val}' and fl.is_del=0";
} else {
$sql_do = " {$tpf}files fl," . get_table_day_down() . " dd,{$tpf}users u where fl.file_id=dd.file_id and fl.userid=u.userid {$cate_sql} and dd.{$o_type}='{$d_val}' and fl.is_del=0";
}
}
$rs = $db->fetch_one_array("select count(*) as total_num from {$sql_do}");
$total_num = $rs['total_num'];
$start_num = ($pg - 1) * $perpage;
if ($o_type == 'd_all') {
$q = $db->query("select fl.*,u.username from {$sql_do} group by file_id order by fl.file_downs desc,file_id desc limit {$start_num},{$perpage}");
} else {
$q = $db->query("select fl.*,u.username from {$sql_do} group by file_id order by fl.file_downs desc,fl.file_id desc limit {$start_num},{$perpage}");
}
$files_array = array();
while ($rs = $db->fetch_array($q)) {
$tmp_ext = $rs['file_extension'] ? '.' . $rs['file_extension'] : "";
$rs['file_thumb'] = get_file_thumb($rs);
$rs['file_name_all'] = filter_word($rs['file_name'] . $tmp_ext);
$rs['file_name'] = cutstr(filter_word($rs['file_name'] . $tmp_ext), 80);
$rs['file_size'] = get_size($rs['file_size']);
$rs[file_description] = clear_html(filter_word($rs['file_description']), 80);
$rs['file_time'] = date("Y-m-d", $rs['file_time']);
$rs['a_viewfile'] = urr("viewfile", "file_id={$rs['file_id']}");
$rs[a_space] = urr("space", "username="******"hotfile.php?o_type={$o_type}&cate_id=" . $cate_id);
require_once template_echo('pd_hotfile', $user_tpl_dir);
include PHPDISK_ROOT . "./includes/footer.inc.php";
function get_day_down_file($stat_time, $stat_type = 'd_day', $cate_id = 0, $uid = 0, $num = 10)
{
global $db, $tpf;
$sql_uid = $uid ? " and dd.userid='{$uid}'" : '';
$q = $db->query("select fl.file_id,file_name,file_extension,file_time,file_size from {$tpf}files fl," . get_table_day_down() . " dd where dd.{$stat_type}='{$stat_time}' and fl.file_id=dd.file_id and in_share=1 and cate_id='{$cate_id}' and is_del=0 {$sql_uid} order by dd.down_count desc limit {$num}");
$file = array();
while ($rs = $db->fetch_array($q)) {
$tmp_ext = $rs['file_extension'] ? '.' . $rs['file_extension'] : "";
$rs['file_name'] = filter_word($rs['file_name'] . $tmp_ext);
$rs['a_viewfile'] = urr("viewfile", "file_id={$rs['file_id']}");
$rs['file_time'] = is_today($rs['file_time']) ? '<span class="txtred" style="float:right">' . date('m/d', $rs['file_time']) . '</span>' : '<span class="txtgray" style="float:right">' . date('m/d', $rs['file_time']) . '</span>';
$rs['file_icon'] = file_icon($rs['file_extension']);
$rs[file_size] = '<span class="txtgray" style="float:right">' . get_size($rs[file_size]) . '</span>';
$file[] = $rs;
}
$db->free($q);
unset($rs);
return $file;
}
