<?php
// ClanSphere 2009 - www.clansphere.net
// $Id: listcat.php 3009 2009-05-03 14:57:11Z hajo $

$cs_lang = cs_translate('files');
require_once 'mods/clansphere/filetype.php';

$data = array();

$files_size = '';

empty($_REQUEST['start']) ? $start = 0 : $start = $_REQUEST['start'];
$categories_id = $_REQUEST['where'];
settype($categories_id,'integer');
$where = "categories_id = '" . $categories_id . "'";

$cs_sort[1] = 'files_name DESC';
$cs_sort[2] = 'files_name ASC';
$cs_sort[3] = 'files_time DESC';
$cs_sort[4] = 'files_time ASC';
$cs_sort[5] = 'files_size DESC';
$cs_sort[6] = 'files_size ASC';
empty($_REQUEST['sort']) ? $sort = 2 : $sort = $_REQUEST['sort'];
$order = $cs_sort[$sort];

$categories = cs_sql_select(__FILE__,'categories','categories_name'," categories_id = '" . $categories_id . "'");
$data['category']['name'] = $categories['categories_name'];
$data['category']['count'] = cs_sql_count(__FILE__,'files',$where);

$data['category']['paginator'] = cs_pages('files','listcat',$data['category'][' count'],$start,$categories_id,$sort);

$from = 'files fls INNER JOIN {pre}_users usr ON fls.users_id = usr.users_id';
$select = 'fls.files_name AS files_name, fls.users_id AS users_id, usr.users_nick';
$select .= ' AS users_nick, usr.users_active AS users_active, fls.files_time AS files_time, fls.files_id AS files_id, fls.files_mirror AS files_mirror';
$select .= ', fls.files_mirror AS files_mirror, fls.files_size AS files_size, fls.files_count AS files_count, fls.files_mirror AS files_mirror, fls.files_previews AS files_previews, fls.files_version AS files_version, fls.files_description AS files_description';
$cs_files = cs_sql_select(__FILE__,$from,$select,$where,$order,$start,$account['users_l imit']);
$files_loop = count($cs_files);

$data['sort']['name'] = cs_sort('files','listcat',$start,$categories_id,1,$sort);
$data['sort']['date'] = cs_sort('files','listcat',$start,$categories_id,3,$sort);
$data['sort']['big'] = cs_sort('files','listcat',$start,$categories_id,5,$sort);

$data['files'] = array();

for($run=0; $run<$files_loop; $run++) {

$data['files'][$run]['id'] = $cs_files[$run]['files_id'];
$data['files'][$run]['name'] = $cs_files[$run]['files_name'];
$data['files'][$run]['version'] = cs_secure($cs_files[$run]['files_version']);
$data['files'][$run]['user'] = $cs_files[$run]['users_nick'];
$data['files'][$run]['date'] = cs_date('unix',$cs_files[$run]['files_time'],1);
$data['files'][$run]['size'] = '';
$data['files'][$run]['description'] = cs_secure($cs_files[$run]['files_description'],1,1);

$data['files'][$run]['count'] = cs_secure($cs_files[$run]['files_count']);

$data['files'][$run]['size'] = cs_filesize($cs_files[$run]['files_size']);

// START PREVIEW ADDED BY Ramires
$data['files'][$run]['if']['preview'] = false;
if(!empty($cs_files[$run]['files_previews'])) {
$data['files'][$run]['if']['preview'] = true;

$files_pics = explode("\n",$cs_files[$run]['files_previews']);
$count = 0;
foreach($files_pics AS $pic) {
$data['files'][$run]['previews'][$count]['image'] = cs_html_img('uploads/files/thumb-' . $pic);
$data['files'][$run]['previews'][$count]['path'] = 'uploads/files/picture-' . $pic;
$count++;
}
}
// STOP PREVIEW ADDED BY Ramires

$data['files'][$run]['filetypes'] = array();
$files_mirror = $cs_files[$run]['files_mirror'];
$temp = explode("-----", $files_mirror);
$temp_loop = count($temp);
$file_typ_array = array();
$run_3 = '0';
for ($run_2 = 1; $run_2 < $temp_loop; $run_2++) {
$temp_a = explode("\n", $temp[$run_2]);
if(in_array($temp_a['3'],$file_typ_array,TRUE)) {} else {
$file_typ_array[$run_3] = $temp_a['3'];
$run_3++;
}
}
$loop_file_typ_array = count($file_typ_array);
for ($run_2 = 0; $run_2 < $loop_file_typ_array; $run_2++) {
$ext = $file_typ_array[$run_2];

$data['files'][$run]['filetypes'][$run_2]['icon'] = cs_filetype($ext);
}
// START DOWNLOAD BUTTON ADDED BY Ramires
$data['files'][$run]['mirrors'] = array();
$files_mirror = $cs_files[$run]['files_mirror'];
$temp = explode("-----", $files_mirror);
$temp_loop2 = count($temp);

if (isset($_REQUEST['target']))
{
$files_cells = array('files_count');
$files_save = array(++$cs_file[$run]['files_count']);
cs_sql_update(__FILE__,'files',$files_cells,$files_save,$file_id);
$temp_a = explode("\n", $temp[$_REQUEST['target']]);
$select_mirrow = $temp_a['1'];
header("location:".$select_mirrow."");
}

require_once 'mods/clansphere/filetype.php';

for ($run_4 = 1; $run_4 < $temp_loop2; $run_4++)
{

$temp_a = explode("\n", $temp[$run_4]);
if($account['access_files'] >= $temp_a['4'])
{
$data['files'][$run]['mirrors'][$run_4-1]['name'] = empty($temp_a['2']) ? $temp_a['1'] : $temp_a['2'];
$data['files'][$run]['mirrors'][$run_4-1]['id'] = $run_4;

$data['files'][$run]['mirrors'][$run_4-1]['filetype_ima ge'] = cs_filetype($temp_a['3']);
$data['files'][$run]['mirrors'][$run_4-1]['filetype_nam e'] = $temp_a['3'];
}
}
// STOP DOWNLOAD BUTTON ADDED BY Ramires
}

echo cs_subtemplate(__FILE__,$data,'files','listcat');

|

|

|