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