| include ("logo.html") ?> |
include ("header.html"); ?>
|
|
|
if(isset($_GET[auth]))
{
$auth_name=strtoupper($_GET[auth]);
$query1="SELECT id FROM dlm_files WHERE author='$auth_name'";
$result1=mysql_query($query1);
$num_files=mysql_numrows($result1);
echo "$auth_name Collection: $num_files files ";
echo "Leave Comment for $auth_name
";
if ($num_files>30)
{
$n=number_format($num_files/30);
echo "Pages: ";
for ($i=0;$i<=$n;$i++)
{
$ii=$i+1;
echo " |";
}
echo " ";
}
$rows="limit 30";
if(isset($_GET[page]))
{
$page=$_GET[page];
$start=$page*30;
$rows="limit $start,30";
}
$query = "SELECT * FROM dlm_files WHERE author='$auth_name' ORDER BY id desc $rows";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
?>
| Filename |
Artist |
Type |
Size (Mb) |
Hits |
Comment |
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
extract($row);
if ($type=='Mp3')
{
$go='mp3.php?artist='.$artist.'&lang='.$language;
}
elseif ($type=='Clips')
{
$go='clips.php?artist='.$artist;
}
elseif ($type=='Movies')
{
$go='movies.php?title='.$artist;
}
elseif ($type=='Concerts')
{
$go='concerts.php?title='.$artist;
}
elseif ($type=='Pics')
{
$go='show_pics.php?artist='.$artist;
}
elseif ($type=='googlevideo')
{
$go='google_videos.php?id='.$id;
}
$name_file = array_pop(explode ("/", $path));
$name_file = substr($name_file,0,35);
$query4 = "select * from posts where file_id='$id'";
$result4 = mysql_query($query4) or die("Query failed : " . mysql_error());
$n4 = mysql_numrows($result4);
?>
if (eregi("(\.jpe?g|\.gif)",$name_file))
{
echo " ";
}
elseif (($name_file=='Lyrics')|($name_file=='News'))
{
echo "$header";
}
else
{
if (is_file($path))
{
$size=number_format((filesize($path)/1048576),1);
}
else
{$size=$uploadsize;}
if($comment=='flv')
{
echo "$name_file";
}
else
{
echo "$name_file";
}
}
?>
|
echo "$artist | "; ?>
echo "$type"; ?> |
echo "$size"; ?> |
echo $hits; ?> |
echo "$n4 Comments"; ?> |
}
echo " ";
}
elseif(isset($_GET[read]))
{
echo "";
$file_id=($_GET[read]);
$query1 = "SELECT * FROM dlm_files WHERE id='$file_id'";
$result1 = mysql_query($query1) or die("Query failed : " . mysql_error());
$row1 = mysql_fetch_array($result1,MYSQL_ASSOC);
if(mysql_num_rows($result1)>0)
{
extract($row1);
}
$author1=ucfirst($author);
$header=ucfirst($header);
$filename=array_pop(explode("/",$path));
if (eregi("(\.jpe?g|\.gif|\.png|\.bmp)",$filename))
{
$path_ar=explode("/",$path);
$n = sizeof($path_ar);
$old_folder = $path_ar[$n-2];
mysql_query("update dlm_files set hits=hits+1 WHERE id='$file_id'");
$today = date("Y-m-d");
mysql_query("update hits set hit_count=hit_count+1 where file_id='$file_id' and date='$today'") or die (mysql_error());
if (mysql_affected_rows()==0)
{
mysql_query("insert into hits (file_id,date,hit_count) values ('$file_id','$today','1')");
}
$filename_size=rawurlencode($filename);
$img_link="http://www.$host.com/$old_folder/$filename_size";
if ($host=='uzfiles')
{
$img_link="http://www.$host.com/".$path_ar[1]."/".$path_ar[2]."/".$filename_size;
}
//echo $img_link;
$artist=strtoupper($artist);
list($width, $height, $type, $attr) = getimagesize($img_link);
if ($width>800)
{
$x=800/$width;
$width=$x*$width;
$height=$x*$height;
}
$img_link=" ";
if ($host=='uzfiles')
{
$img_link=" ";
}
echo "$artist $img_link";
echo "Posted by: $author1 | ";
}
elseif (($path=='Lyrics')|($path=='News'))
{
echo "
|
$comment
Posted by: $author1
$date
|
";
}
else
{
?>
";
if((eregi("\.mp3",$path))|($type=='Mp3'))
{
echo "Play this song
";
}
?>
|
}
echo "| ";
?>
Add to Favorites
echo " | ";
echo " ";
$posts_table_width='800';
$posts_user_width='100';
$posts_comment_width='700';
$text_area_cols = '97';
$category = 'files';
include("post_read_comments.php");
}
///////////////////////////////////////////////////////////////////
/////// To Post messages
/////////////////////////////////////////////////////////////////////
elseif(isset($_POST[post]))
{
//unset($_SESSION['visit_ads']);
$today = date("Y-m-d H:i:s");
$id_file = $_POST[id_file];
$category = $_POST[category];
$message = $_POST[comment];
$private = $_POST['private'];
$message = strip_tags($message);
//$message = ucfirst(strtolower($message));
$message = htmlspecialchars($message);
$message = nl2br($message);
$message = ereg_replace("'","`",$message);
$poster = $_POST[poster];
$poster = htmlspecialchars($poster);
if ( ($poster!=="") && ($message!=="") && ($poster!=="dawoody")&&!preg_match("/http:/",$poster) )
{
$sql = "INSERT INTO posts (id, file_id, poster, message, date_posted, category, user_ip, private) VALUES ('','$id_file','$poster','$message','$today','$category','$user_ip', '$private')";
mysql_query($sql)
or die ("Query failed");
if ($category=='members')
{
$current_time = time();
mysql_query("update members set lastguestpost='$current_time' where login='$id_file'");
}
}
$ref=$_SERVER['HTTP_REFERER'];
?>
}
////////////////////////////////////////////////////////////////////////////
/// To list all members
///////////////////////////////////////////////////////////////////////////
elseif(isset($_GET[act]))
{
$query = "SELECT DISTINCT login FROM members ORDER BY login";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{extract($row);
echo "$login ";
}
}
else
{
if (isset($_GET[month]))
{
$month=$_GET[month];
}
?>
Best Collection |
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
Register to Participate
List all members
|
|
|
|
|
|
$query="SELECT id, sum(points) as points, author, count( * ) as count FROM dlm_files where date like '%$month%' and author!='UzFiles' GROUP BY author order by points desc";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$n=mysql_numrows($result);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
extract($row);
$author1[]=ucfirst($author);
$author2[]=($author);
$points1[]=$points;
$count1[]=$count;
}
for ($i=0;$i<$n;$i++)
{
$ii=$i+1;
?>
|
echo "$ii."; ?>
|
|
echo "$count1[$i]" ?>
|
echo "$date" ?>
|
echo "$points1[$i]" ?>
|
}
echo " ";
}
?>
|
|
| include ("footer.inc"); ?> |