y con todo el codigo podrias saber ke falla:
Código PHP:
<?php
function showlistform( )
{
global $baseUrl;
global $baseWeb;
global $input;
global $db;
global $ThumbFile;
global $SERVERS;
global $ThumbUploadForm;
$db->setQuery( "select * from setting limit 1 " );
$db->query( );
$SET = $db->loadRow( );
$db->setQuery( "select * from server" );
$db->query( );
$SERVERS = $db->loadRowList( "server_id" );
$mode = intval( $input[mode] );
$input[s] = intval( $input[s] );
$cols = 4;
$header = array( );
if ( $orderad != "ASC" && $orderad != "DESC" )
{
$orderad = "";
}
if ( isset( $input[search] ) )
{
$orderby = $_SESSION[img_orderby] = $input[img_orderby];
$orderad = $_SESSION[img_AD] = $input[img_AD];
$_SESSION[img_field] = $input[img_field];
$_SESSION[img_func] = $input[img_func];
$_SESSION[img_values] = $input[img_values];
$_SESSION[img_field2] = $input[img_field2];
$_SESSION[img_func2] = $input[img_func2];
$_SESSION[img_values2] = $input[img_values2];
$_SESSION[img_pages] = $input[img_pages];
$_SESSION[img_mode] = $input[img_mode];
$_SESSION[img_server] = $input[img_server];
$_SESSION[img_filter] = $input[img_filter];
$_SESSION[img_mode] = $input[img_mode];
$_SESSION[img_thumb] = $input[img_thumb];
}
$orderby = $_SESSION[img_orderby];
$orderad = $_SESSION[img_AD];
$mode = intval( $_SESSION[img_mode] == 1 );
$per_num = intval( $_SESSION[img_pages] );
if ( $per_num == 0 )
{
$_SESSION[img_pages] = $per_num = 20;
}
if ( $orderby )
{
$order = "ORDER BY $orderby $orderad ";
}
if ( ( $_SESSION[img_field] ) != "" && $_SESSION[img_func] != "" && $_SESSION[img_field] != "u.username" && $_SESSION[img_field] != "f.uid" )
{
if ( $_SESSION[img_field] == "f.time" )
{
$condition = "{$_SESSION['img_field']} {$_SESSION['img_func']} '".$db->getescaped( strtotime( $_SESSION[img_values]." 00:00:00" ) )."'";
}
else
{
$condition = "{$_SESSION['img_field']} {$_SESSION['img_func']} '".$db->getescaped( $_SESSION[img_values] )."'";
}
}
if ( $_SESSION[img_field2] != "" && $_SESSION[img_func2] != "" && $_SESSION[img_field2] != "u.username" && $_SESSION[img_field2] != "f.uid" )
{
if ( $_SESSION[img_field2] == "f.time" )
{
$condition2 = "{$_SESSION['img_field2']} {$_SESSION['img_func2']} '".$db->getescaped( strtotime( $_SESSION[img_values2]." 00:00:00" ) )."'";
}
else
{
$condition2 = "{$_SESSION['img_field2']} {$_SESSION['img_func2']} '".$db->getescaped( $_SESSION[img_values2] )."'";
}
$condition .= $condition ? " AND ".$condition2 : $condition2;
}
if ( $_SESSION[img_field] == "u.username" )
{
$db->setquery( "select id,user from users where user='{$_SESSION['img_values']}'" );
$db->query( );
$caption = $db->loadRow( );
$header[caption] = $caption[user];
$condition .= $condition == "" ? " f.uid='{$caption['id']}'" : " and f.uid='{$caption['id']}'";
}
if ( $_SESSION[img_field] == "f.uid" )
{
$condition .= $condition == "" ? " f.uid='{$_SESSION['img_values']}'" : " and f.uid='{$_SESSION['img_values']}'";
$db->setQuery( "select id,user from users where id='{$_SESSION['img_values']}'" );
$db->query( );
$caption = $db->loadRow( );
$header[caption] = $caption[user];
}
if ( is_numeric( $_SESSION[img_server] ) && $_SESSION[img_server] != 0 )
{
$condition .= $condition == "" ? " f.server_id='{$_SESSION['img_server']}'" : " and f.server_id='{$_SESSION['img_server']}'";
}
$condition .= $condition == "" ? "1" : "";
if ( $_SESSION[img_filter] == "deleted" )
{
$filter = "f.deleted=1";
}
else if ( $_SESSION[img_filter] == "validated" )
{
$filter = "f.validate=1 and f.deleted=0";
}
else if ( $_SESSION[img_filter] == "validate" )
{
$filter = "f.deleted=0 and f.validate=0";
}
else
{
$filter = "1";
}
if ( $_SESSION[img_thumb] == "0" )
{
$filter2 = "f.thumb=0";
}
else if ( $_SESSION[img_thumb] == 1 )
{
$filter2 = "f.thumb=1";
}
else
{
$filter2 = "1";
}
$db->setQuery( "select count(f.id) as total from files as f\r\n where $condition and $filter and $filter2" );
$db->query( );
$tmp = $db->loadRow( );
$header[total] = $tmp[total];
$db->setquery( "select f.*,g.cron_days,g.cron_views,g.cron_enabled,u.user,s.name as servername,s.domain\r\n from files as f\r\n left join users as u on u.id=f.uid\r\n left join groups as g on u.gid=g.id\r\n left join server as s on f.server_id=s.server_id\r\n where {$condition} and {$filter} and {$filter2}\r\n {$order} limit {$input['s']},{$per_num}" );
$db->setquery( "select f.*\r\n from files as f\r\n where {$condition} and {$filter} and {$filter2}\r\n {$order} limit {$input['s']},{$per_num}" );
$db->query( );
$rows = $db->loadRowList( );
$cur_page = $input[s] / $per_num;
$info = array( "total"=>$tmp[total], "page"=>$per_num, "cur_page"=>$cur_page, "baseUrl"=>$baseUrl."&admin=images&$uid&$order2" );
$pageLinks = buildpagelinks( $info );
if ( $mode == 1 )
{
showimgth2( $header );
}
else
{
showimgth( $header );
}
$i = 0;
$nums = count( $rows );
foreach ( $rows as $row )
{
$SERVER = $SERVERS[$row[server_id]];
$row[domain] = $SERVER[domain];
$row[http] = $SERVER[http];
$row[servername] = $SERVER[name];
$row[mod_status] = $SERVER[mod_status];
$data = $row;
$sourceWeb = $row[http].$row[domain];
$urls = geturls( $SERVER[upload_dir]."/".$row[file], $sourceWeb, $row[thumb] );
extract( $urls );
$data[thumburl] = $thumburl;
$data[fileurl] = $fileurl;
$urls = getdownloadurl( $row, "dyn" );
extract( $urls );
$data[downloadurl] = $downloadurl;
$type = getext( $row[name], "_" );
$data[style] = "validate";
if ( $_SESSION[img_field] == "u.username" )
{
$data[user] = $caption[user] ? $caption[user] : "GUEST";
}
else
{
$data[user] = $row[uid] ? $row[uid] : "GUEST";
}
$data[time] = date( "M.d,Y", $row[time] );
$data[expires] = date( "M.d,Y", $row[time] + $row[cron_days] * 24 * 60 * 60 ) ? date( "M.d,Y", $row[time] + $row[cron_days] * 24 * 60 * 60 ) : "Never";
$data[lastdownload] = date( "M.d,Y", $row[lastdownload] ) ? date( "M.d,Y", $row[lastdownload] ) : "No yet!";
$data[bandwidth] = convertsize( $row[bandwidth] );
$data[size] = convertsize( $row[size] );
$data[filelink] = "<a href='{$fileurl}' title='click to download file' target=blank>{$row['name']}</a>(From <a href='?&admin=set&act=banip&ip={$row['ip']}' title='BAN {$row['ip']}'>{$row['ip']}</a>)";
..........................................................................
?>
Mientras probare con lo ke me has dicho.
Pero si encontraras una mejor solucion por favor comunicamelo.
23/03/2008, 12:49
