profile picture to the gallery file

[eynesilli]

<?php
define('WCS',true);
include('../core/main.inc');
header_type();
cleardata();
if(ipbanned(ip(),browser())){
if(!shield(getuid_sid($sid))){
echo head_tag("Ip Bloke!!!",0,0);
echo ipbanned_msg();
echo foot_tag();
exit();
}
}
if(!islogged($sid)){
echo head_tag("Hata!!!",0,0);
echo session_expired();
echo foot_tag();
exit();
}
if(banned(getuid_sid($sid))){
echo head_tag("Hata!!!",1,getnick_sid($sid));
echo banned_msg($sid);
echo foot_tag();
exit();
}
mysql_query("UPDATE users SET browser='".browser()."', ipaddress='".ip()."', host='".subno()."' WHERE id='".getuid_sid($sid)."'");

/////////////////////////profile picture to the gallery file/////////////////////////

if($action==1)
{
addonline(getuid_sid($sid),"Avatar","");
echo head_tag(getnick_sid($sid)."@Ayarlar/Avatar",1,getnick_sid($sid));
$title="<strong>Ayarlar/Avatar</strong>";
$main="<div align=".align().">";
$count=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM gallery_files WHERE mood='1' AND id='".$id."'"));
$mood=mysql_fetch_array(mysql_query("SELECT path FROM gallery_files WHERE id='".$id."'"));
$res=mysql_query("UPDATE profiles SET picture='".$mood[0]."' WHERE uid='".getuid_sid($sid)."'");
if(($res)&&($count[0]!=0)){$main.="<img src=\"../images/ok.gif\" alt=\"o\"/><br />Nik Resmi Kayıt Edildi<br />\n";}
else{$main.="<img src=\"../images/error.gif\" alt=\"x\"/><br />Veritabanı Hatası!<br />\n";}
$main.="<br />\n";
if($rid!=""){$main.="[<a href=\"../chat/chat.php?sid=$sid$chatlink\">$rname</a>]<br />\n";}
$main.="[<a $key5 href=\"../settings/settings.php?sid=$sid\">KiÅŸisel Ayarlar</a>]<br />\n";
$main.="<img src=\"../images/banner_2.gif\" alt=\"-------\"/><br />
[<a $key6 href=\"../inbox/inbox.php?sid=$sid\">Mesajkutusu</a>]
[<a $key7 href=\"../buds/buds.php?sid=$sid\">ArkadaÅŸ List</a>]<br />
[<a $key8 href=\"../chat/public.php?sid=$sid\">Chat</a>]
[<a $key9 href=\"../forums/forums.php?sid=$sid\">Forum</a>]<br />
[<a $key0 href=\"../main.php?sid=$sid\"><img src=\"../images/home.gif\" alt=\"\"/>Aana Sayfa</a>]<br />
<img src=\"../images/banner_2.gif\" alt=\"-------\"/>\n";
$main.="</div>\n";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
exit();
}


///////////////////////////////////////////////


<?php
define('WCS',true);
include('../core/main.inc');
header_type();
cleardata();
if(ipbanned(ip(),browser())){
if(!shield(getuid_sid($sid))){
echo head_tag("Ip Bloke!!!",0,0);
echo ipbanned_msg();
echo foot_tag();
exit();
}
}
if(!islogged($sid)){
echo head_tag("Hata!!!",0,0);
echo session_expired();
echo foot_tag();
exit();
}
if(banned(getuid_sid($sid))){
echo head_tag("Hata!!!",1,getnick_sid($sid));
echo banned_msg($sid);
echo foot_tag();
exit();
}
mysql_query("UPDATE users SET browser='".browser()."', ipaddress='".ip()."', host='".subno()."' WHERE id='".getuid_sid($sid)."'");

/////////////////////////VIEW CATEGORY/////////////////////////

addonline(getuid_sid($sid),"Galeri","");
echo head_tag(getnick_sid($sid)."@Galeri",1,getnick_sid($sid));
$title="<b><i>Galeri</i></b>";
$main="<p align=".align().">\n";
$active=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM gallery_categories WHERE id='".$id."' AND active='0'"));
if($active[0]==1){
$main.="<p align=".align().">Bu Kategori şu anda devre dışıdır.</p>\n";
$main.="<p align=".align().">$fivekey<a $key5 href=\"./downloads.php?sid=$sid\">Geri</a></p>\n";
$L1="$sixkey<a $key6 href=\"../inbox/inbox.php?sid=$sid\">Gelen Kutusu</a>";
$L2="$sevenkey<a $key7 href=\"../buds/buds.php?sid=$sid\">ArkadaÅŸ List</a>";
$L3="$eightkey<a $key8 href=\"../chat/public.php?sid=$sid\">Chat</a>";
$L4="$ninekey<a $key9 href=\"../forums/forums.php?sid=$sid\">Forum</a>";
$L5="$zerokey<a $key0 href=\"../main.php?sid=$sid\"><img src=\"../images/home.gif\" alt=\"\"/>Ana Sayfa</a>";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
exit;
}
if($page==""||$page<=0)$page=1;
$num_items=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM gallery_files WHERE category='".$id."'"));
if($num_items[0]==0)$num_items[0]=0;
$items_per_page=10;
$num_pages=ceil($num_items[0]/$items_per_page);
if($page>$num_pages)$page=$num_pages;
$limit_start=($page-1)*$items_per_page;
if($num_items[0]==0)$limit_start=0;
$sql="SELECT id, uid, filename, path, hits FROM gallery_files WHERE category='".$id."' ORDER BY filename LIMIT $limit_start, $items_per_page";
$items=mysql_query($sql);
$main.=mysql_error();
if(mysql_num_rows($items)>0){
while($item=mysql_fetch_array($items))
{
$file=explode("gallery/",$item[3]);
if(filesize($file[1])>1048575){
$size=round(filesize($file[1])/1048576,1)." Mb";
}else if(filesize($file[1])>1023){
$size=round(filesize($file[1])/1024,1)." Kb";
}else{
$size=filesize($file[1])." Bytes";
}
$filename=explode(".",$item[2]);
$nick=explode("(",$item[2]);
$main.="<img src=\"../gallery/$item[2]\"width=\"100\" height=\"100\" alt=\"$item[2]\"/>
<br /><a href=\"./get.php?id=$item[0]&amp;sid=$sid\">$filename[0].".getext($file[1])."</a> $size\n";
$main.="<a href=\"avatar.php?action=1&amp;id=$item[0]&amp;sid=$sid\">$item[1]</a>\n";
if(gallery_tools(getuid_sid($sid))||getnick_sid($sid)==$nick[0]){
$main.=" <a href=\"./delete.php?id=$item[0]&amp;sid=$sid\">[sil]</a><br />";
}
$main.="<small>Bu Resim <strong>$item[4]</strong> Defa Ä°ndirildi</small>\n";
}
if($page>1){
$main.="<a href=\"./viewcategory.php?id=$id&amp;page=".($page-1)."&amp;sid=$sid\"><img src=\"../images/prev.gif\" alt=\"-------\"/></a> ";
}
if($page<$num_pages){
if($page==1)$main.="";
$main.="<a href=\"./viewcategory.php?id=$id&amp;page=".($page+1)."&amp;sid=$sid\"><img src=\"../images/next.gif\" alt=\"-------\"/></a>\n";
}
$main.="<br />Sayfa - $page/$num_pages<br />\n";
if($num_pages>2){$main.=getjumper("viewcategory","id","$id",$sid);}
}else{
$main.="Bu Kategoriye Resim Yüklenilmemiş...
<br />\n";
}
$main.="[<a href=\"./gallery.php?sid=$sid\">Galeri</a>]<br />\n";
$main.="<img src=\"../images/banner_2.gif\" alt=\"-------\"/><br />\n";
$main.="[<a $key6 href=\"../inbox/inbox.php?sid=$sid\">mesajlar</a>]\n";
$main.="[<a $key7 href=\"../buds/buds.php?sid=$sid\">ArkadaÅŸ List</a>]<br />\n";
$main.="[<a $key8 href=\"../chat/public.php?sid=$sid\">Chat</a>]\n";
$main.="[<a $key9 href=\"../forums/forums.php?sid=$sid\">Forum</a>]<br />\n";
$main.="[<a $key0 href=\"../main.php?sid=$sid\"><img src=\"../images/home.gif\" alt=\"\"/>Aana Sayfa</a>]<br />\n";
$main.="<img src=\"../images/banner_2.gif\" alt=\"-------\"/></div>\n";
echo xhtml($sid,$title,1,$L1,$L2,$L3,$L4,$L5,0,0,0,$main);
echo foot_tag();
exit;
?>

Added after 5 minutes:

1 _file to comment?
2_Anyone can see friends while downloading a file, or