<?
date_default_timezone_set('Europe/Istanbul');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" />
<title>Mp3 Bot</title>
<SCRIPT language="JavaScript" type="text/javascript">
<!--
  function TumunuSec()
  {
    for (var i=0;i<document.form1.elements.length;i++)
    {
      var e=document.form1.elements[i];
      if (e.name != 'Sec')
        e.checked=document.form1.Sec.checked;
    }
  }
//-->
</SCRIPT>
</head>

<body>
<?php
function karakter($param){
    $param = str_replace("Ç", "Ç", $param);
    $param = str_replace("ç", "ç", $param);
    $param = str_replace("İ", "İ", $param);
    $param = str_replace("ı", "ı", $param);
    $param = str_replace("Ğ", "Ğ", $param);
    $param = str_replace("ğ", "ğ", $param);
    $param = str_replace("Ö", "Ö", $param);
    $param = str_replace("ö", "ö", $param);
    $param = str_replace("Ü", "Ü", $param);
    $param = str_replace("ü", "ü", $param);
    $param = str_replace("Ş", "Ş", $param);
    $param = str_replace("ş", "ş", $param);
    return $param;
}
////////////////////// AYARLAR //////////////////////////////////////
$host="localhost";
$user="music";
$pass="bari25er";
$db="Esunus_music";

    mysql_connect($host,$user,$pass) or die ("Kullanici adi veya sifre yanlistir.");
    mysql_select_db($db) or die ("Veritabani bulunamadi.");
    mysql_query("SET NAMES 'latin5'");  
    mysql_query("SET CHARACTER SET latin5");  
set_time_limit(0);

function baglan($url){
$oturum = curl_init();
curl_setopt($oturum, CURLOPT_URL, $url);
$browser = $_SERVER['HTTP_USER_AGENT'];
curl_setopt($oturum, CURLOPT_USERAGENT, $browser);
curl_setopt($oturum, CURLOPT_HEADER, 0);
curl_setopt($oturum,CURLOPT_REFERER,"http://www.bedavamp3.co.uk/");
curl_setopt($oturum, CURLOPT_RETURNTRANSFER, true);
$source=curl_exec($oturum);
curl_close($oturum);
return $source;
}
function sef($s) {
    $tr = array('ş','Ş','ı','İ','ğ','Ğ','ü','Ü','ö','Ö','Ç','ç');
    $eng = array('s','s','i','i','g','g','u','u','o','o','c','c');
    $s = str_replace($tr,$eng,$s);
    $s = strtolower($s);
    $s = preg_replace('/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;.+?;/', '', $s);
    $s = preg_replace('/[^%a-z0-9 _-]/', '', $s);
    $s = preg_replace('/\s+/', '-', $s);
    $s = preg_replace('|-+|', '-', $s);
    $s = trim($s, '-');
    return $s;
}
 function trle($karekter){
return $karakter;
}
function trle2($karakter) {
return $karakter;
}

/////////////////////////// Ayarlar Bitti ///////////////////////////////////
$islem=@$_GET['islem'];
$son=@$_GET['son'];
if($islem!="cek") {
?>
<form id="form2" name="form2" method="post" action="?islem=cek">
  <table align="center" width="523" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #3399FF;">
    <tr>
      <td width="17" height="50"></td>
      <td width="205">Şarkıcı Adı</td>
      <td width="8" height="50">:</td>
      <td width="291" height="50">
        <select name="site_link" id="site_link" style="border:1px solid #3399FF;">
<?php
$file1=baglan("http://www.bedavamp3.co.uk/turListele.php?typeID=1&sort=1&page=1"); // Yerli

    preg_match('|(.+?)Bulunan Şarkıcı: <b>(.+?)</b>(.+?)|is',$file1,$a);
    $a=ceil($a[2]/50);
    for($s=1;$s<=$a;$s++) {
$file3=baglan("http://www.bedavamp3.co.uk/turListele.php?typeID=1&sort=1&page=".$s); // Yerli Sayfalar
    preg_match_all('|onmouseout="hideddrivetip\(\)" href="bilgi/(.+?)"><b>(.+?)</b></a><br />|is',$file3,$z);
        for($o=0;$o<count($z[1]);$o++) {
        echo '<option value="'.$z[1][$o].'~'.$z[2][$o].'">'.$z[2][$o].'</option>';    
        }
    }
    
$file2=baglan("http://www.bedavamp3.co.uk/turListele.php?typeID=2&sort=1&page=1"); // Yabancı
    preg_match('|(.+?)Bulunan Şarkıcı: <b>(.+?)</b>(.+?)|is',$file2,$b);
    $b=ceil($b[2]/50);
    for($x=1;$x<=$b;$x++) {
$file4=baglan("http://www.bedavamp3.co.uk/turListele.php?typeID=2&page=".$x); // Yabancı Sayfalar
    preg_match_all('|onmouseout="hideddrivetip\(\)" href="bilgi/(.+?)"><b>(.+?)</b></a><br />|is',$file4,$m);
        for($y=0;$y<count($m[1]);$y++) {
        echo '<option value="'.$m[1][$y].'~'.$m[2][$y].'">'.$m[2][$y].'</option>';    
        }
    }

?>              </select></td>
    </tr>
    <tr>
      <td height="50"></td>
      <td height="50">Kaydedilecek Kategori</td>
      <td height="50">:</td>
      <td height="50">
      <select name="kat" id="kat" style="border:1px solid #3399FF;">
      <?php
      $s1=mysql_query("SELECT * FROM kategoriler order by kategoriadi ASC");
      while($r1=mysql_fetch_array($s1)) {
      $kname=$r1['kategoriadi'];
                      echo '<option value="'.$kname.'">'.$kname.'</option>';
      }
      ?>
      </select>      </td>
    </tr>
        <tr>
      <td height="50"></td>
      <td height="50" colspan="2" align="right"><input type="submit" name="button" style="border:1px solid #0099FF; color:#0099FF; background-color:#FFFFFF;" id="button" value="Çekelim!" /></td>
    </tr>
    <tr>
      <td height="50"></td>
      <td height="50" colspan="2" align="right"><input type="submit" name="button" style="border:1px solid #0099FF; color:#0099FF; background-color:#FFFFFF;" id="button" value="Çekelim!" /></td>
    </tr>
</table>
</form>
<?php
}else{
if($son!="kaydet"){
?>
<form id="form1" name="form1" method="post" action="?islem=cek&son=kaydet">
  <table align="center" width="500" border="0" cellspacing="0" cellpadding="0" style="border:#0099FF solid 1px;">
    <tr>
      <td style="background-color:#3399FF; color:#FFFFFF;" align="center" width="50" height="35"><input type="checkbox" name="Sec" value="" onClick="TumunuSec();"></td>
      <td style="background-color:#3399FF; color:#FFFFFF;" width="450" >Başlık</td>
    </tr>

<?php
$sitelink=$_POST['site_link'];
$kat=$_POST['kat'];
$bol=explode('~',$sitelink);
$sarkici=$bol[1];
$k=substr($bol[0],0,-5);
$t=substr_count($k,'-');
$k=explode('-',$k);
$say=$k[$t];
$side="http://www.bedavamp3.co.uk/mp3Listele.php?artistID=".$say."&page=1";
$file5=baglan($side);

    preg_match('|Bulunan Şarkı: <b>(.+?)</b>|is',$file5,$kk);
    $g=ceil($kk[1]/50);

if ($g > 1) {
    for($v=1;$v<=$g;$v++) {
    $file2=baglan("http://www.bedavamp3.co.uk/mp3Listele.php?artistID=".$say."&page=".$v);
    preg_match_all('|<td><a href="(.+?)-(.[0-9]+).html"><b>(.+?)</b></a><br /> <font class="mp3d">|is',$file2,$c);
for($o=0;$o<count($c[1]);$o++) {
$sarkiadi=$c[3][$o];
$id=$c[2][$o];
$link='http://www.bedavamp3.co.uk/mp3Yukleniyor.php?mp3ID='.$id;
$file3=baglan($link);
    preg_match('|<a href="(.+?)" class="link" border="0">|is',$file3,$d);
$mp3=$d[1];
$toplam=$sarkici.'~'.$sarkiadi.'~'.$mp3; ?>
  <tr><td width="50" height="30" align="center" style="border-bottom:#0099FF solid 1px;"><input name="secilenler[]" type="checkbox" value="<?=$toplam;?>" /></td>
      <td width="450" style="border-bottom:#0099FF solid 1px;"><br><?=$sarkici;?> - <?=$sarkiadi;?><br><br></td></tr>

<?php
}
}

}else{
    $file2=baglan("http://www.bedavamp3.co.uk/mp3Listele.php?artistID=".$say."&page=1");
    preg_match_all('|<td><a href="(.+?)-(.[0-9]+).html"><b>(.+?)</b></a><br /> <font class="mp3d">|is',$file2,$c);
for($o=0;$o<count($c[1]);$o++) {
$sarkiadi=$c[3][$o];
$id=$c[2][$o];
$link='http://www.bedavamp3.co.uk/mp3Yukleniyor.php?mp3ID='.$id;
$file3=baglan($link);
    preg_match('|<a href="(.+?)" class="link" border="0">|is',$file3,$d);
$mp3=str_replace(' ','%20',$d[1]);
$ad = $sarkici.'-'.$sarkiadi;
$sef = sef($ad);
$toplam=$sarkici.'~'.$sarkiadi.'~'.$mp3; ?>
  <tr><td width="50" height="30" align="center" style="border-bottom:#0099FF solid 1px;"><input name="secilenler[]" type="checkbox" value="<?=$toplam;?>" /></td>
      <td width="450" style="border-bottom:#0099FF solid 1px;"><br><?=$sarkici;?> - <?=$sarkiadi;?> - <?=$mp3;?> - <?=$sef; ?><br><br></td></tr>

<?php
} 
}
?>
     <tr>
      <td colspan="4">
      <input name="kat" type="hidden" value="<?=$kat;?>" />
        <center><br /><input type="submit" name="Submit" value="Kaydet" style="border:1px solid #0099FF; color:#0099FF; background-color:#FFFFFF;" /></center><br />
      </td>
    </tr>
  </table>
</form>
<?php
}else{
?>
  <table align="center" width="500" border="0" cellspacing="0" cellpadding="0" style="border:#0099FF solid 1px;">
<?php
$sec=@$_POST['secilenler'];
$kid=$_POST['kat'];
if(isset($sec)) {?>
    <tr>
      <td style="background-color:#3399FF; color:#FFFFFF;" align="center" width="50" height="35"></td>
      <td style="background-color:#3399FF; color:#FFFFFF;" width="450" >Seçilen Mp3'ler</td>
    </tr>
<?php
for($i=0;$i<count($sec);$i++) {
$parca=explode('~',$sec[$i]);
$sarkici=$parca[0];
$sarkici = karakter($sarkici);
$sarki=$parca[1];
$sarki = karakter($sarki);
$mp3=$parca[2];
$baslik=trle2($sarkici.' '.$sarki);
$seobaslik=sef($parca[0].'-'.$parca[1]);
$sanatci_sql = mysql_query("SELECT * FROM sanatcilar WHERE ad='$sarkici'");
$sonccc = mysql_num_rows($sanatci_sql);
$baslik = karakter($baslik);

if($sonccc==0) {
$kcc = "0";
$yaz = mysql_query("INSERT INTO sanatcilar SET ad='$sarkici',kac='$kcc'");
}
$sonuc=$mp3;
$kontrol=mysql_num_rows(mysql_query("SELECT * FROM mp3 WHERE ad='$baslik'"));
if($kontrol==0) {
    $time = mktime();
    $sanatcz = mysql_fetch_assoc(mysql_query("SELECT * FROM sanatcilar WHERE ad='$sarkici'"));
    $zxc = $sanatcz['id'];
$q = mysql_query("INSERT INTO mp3 (ad,sef,src,tarih,sanatci) values ('$baslik','$seobaslik','$mp3','$time','$zxc')");
if($q) {

$art = $sanatcz['kac']+1;
$gn = mysql_query("UPDATE sanatcilar SET kac='$art' WHERE ad='$sarkici'");
 echo '<tr><td width="50" height="30" align="center" style="border-bottom:#0099FF solid 1px;"></td>
       <td width="450" style="border-bottom:#0099FF solid 1px;"><br>'.$baslik.' <u>Eklendi</u><br><br></td></tr>';

}else{
 echo '<tr><td width="50" height="30" align="center" style="border-bottom:#0099FF solid 1px;"></td>
       <td width="450" style="border-bottom:#0099FF solid 1px;"><br>'.$baslik.' - '.$seobaslik.' - '.$mp3.' <u><b>Eklenemedi</b></u><br><br></td></tr>';
}
}else {
     echo '<tr><td width="50" height="30" align="center" style="border-bottom:#0099FF solid 1px;"></td>
       <td width="450" style="border-bottom:#0099FF solid 1px;"><br>'.$baslik.' <u><b>Zaten var.</b></u><br><br></td></tr>';
}
}
}else{
 echo '<tr><td width="50" height="30" align="center" style="border-bottom:#0099FF solid 1px;"></td>
       <td width="450" style="border-bottom:#0099FF solid 1px;"><br><b>Hiç Mp3 Seçmediniz.</b><br><br></td></tr>';
}

}
?>
  </table>
<?php
}
?>
</body>
</html>

burda ne gibi bir değişiklik yapmam lazım?