Tekil Mesaj gösterimi - Php bot

Konu Php bot

04-09-2009, 05:28:51

ZMD

Arkadaşlar yahoo.comdan verileri çekmek için internette birisinin paylaştığı bir bot vardı toplu olarak içinde 8 tane filan vardı bu botu siteme kurdugumda herşeyi yaptım ettim arama yerine yazıyorum herşey çıkıyor tamam ama fakat kategori yerleri ve ekle butonuna bastıgım zaman mysql name örnek

asd_asd.video eklenemedi diyor asd_asd sql ında video table ı arıyor ve phpmyadmin'den table açarken .(nokta) kabul etmiyor bildiğiniz üzere.kurcaladım fakat pek bir şey bulamadım. birde siz göz atarsanız hem arkadaslarımıza faydalı bir şey olur.
Botun code'u

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>
Yahoo video Bot
</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
</head><body style="text-align: center">
<?

include "wp-config.php";
$mysqlhost=DB_HOST; // MYSQL HOST
$mysqlad=DB_USER; // Mysql Kullanýcý Adý
$mysqlpass=DB_PASSWORD; // Mysql Þifresi
$mysqldb=DB_NAME; // Mysql Database Adý
$con = mysql_connect($mysqlhost,$mysqlad,$mysqlpass);
if (!$con)
  {
  die('Data Baseye Baglanamadim: ' . mysql_error());
  }mysql_select_db($mysqldb, $con);
mysql_query("SET NAMES 'latin5'");
mysql_query("SET character_set_connection = 'latin5'");
mysql_query("SET character_set_client = 'latin5'");
mysql_query("SET character_set_results = 'latin5'");


//Bunu sayfanın en üst kısmına koyarsanız iyi olur
$saymaya_basla = acilma_suresi();
$page = $_GET['page'];
$kelime = $_GET['kelime'];
$max=100;
if (!$page) $page=1;
$alt=($page - 1) * $max;
$et = explode(",",$etiketler);
$cek = rand(0,count($et));
if(!$kelime) $kelime = $et[$cek];
		$aranan = urlencode($kelime);


function birdensuna($sayi,$maximum) { 
    if ( $sayi >= 1 AND $sayi <= $maximum ) { return $sayi; } 
    else { return $maximum; } 
} 

function DosyaAl($url){
		//$ch = curl_init();
		//$timeout = 0;
		//curl_setopt ($ch, CURLOPT_URL, $url);
		//curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
		//curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
		//$xml = curl_exec($ch);
		//curl_close($ch);
		//if(!$xml) die('Baglantı Hatası');
		$xml = file_get_contents($url);
		return $xml;
}
function seoyap($text) {
$text = trim($text);
$search = array('Ç','ç','Ğ','ğ','ı','İ','Ö','ö','Ş','ş','Ü','ü');
$replace = array('C','c','G','g','i','I','O','o','S','s','U','u');
$text = str_replace($search,$replace,$text);
return $text;
}

function trsil($url)
{
    $url = trim($url);
    $url = strtolower($url);
    $find = array('<b>', '</b>');
    $url = str_replace ($find, '', $url);
    $url = preg_replace('/<(\/{0,1})img(.*?)(\/{0,1})\>/', 'image', $url);
    $find = array(' ', '&quot;', '&amp;', '&', '\r\n', '\n', '/', '\\', '+', '<', '>');
    $url = str_replace ($find, '-', $url);
    $find = array('é', 'è', 'ë', 'ê', 'É', 'È', 'Ë', 'Ê');
    $url = str_replace ($find, 'e', $url);
    $find = array('í', 'ì', 'î', 'ï', 'I', 'Í', 'Ì', 'Î', 'Ï');
    $url = str_replace ($find, 'i', $url);
    $find = array('ó', 'ö', 'Ö', 'ò', 'ô', 'Ó', 'Ò', 'Ô');
    $url = str_replace ($find, 'o', $url);
    $find = array('á', 'ä', 'â', 'à', 'â', 'Ä', 'Â', 'Á', 'À', 'Â');
    $url = str_replace ($find, 'a', $url);
    $find = array('ú', 'ü', 'Ü', 'ù', 'û', 'Ú', 'Ù', 'Û');
    $url = str_replace ($find, 'u', $url);
    $find = array('ç', 'Ç');
    $url = str_replace ($find, 'c', $url);
    $find = array('þ', 'Þ');
    $url = str_replace ($find, 's', $url);
    $find = array('ð', 'Ð');
    $url = str_replace ($find, 'g', $url);
    $find = array('/[^a-z0-9\-<>]/', '/[\-]+/', '/<[^>]*>/');
    $repl = array('', '-', '');
    $url = preg_replace ($find, $repl, $url);
    $url = str_replace ('--', '-', $url);
    return $url;
}

function kucult($deger){
$str1=array('530','420');
$str2=array('450','370');
$deger=str_replace($str1,$str2,$deger);
return $deger;
}
function acilma_suresi (){
$time = explode( " ", microtime());
$usec = (double)$time[0];
$sec = (double)$time[1];
return $sec + $usec;
}



$ix = $_POST['ix'];
if($ix == "1"){
$adi = seoyap($_POST['adi']);
$kategori = $_POST['kategori'];
$aciklama = $_POST['aciklama'];
$resim = $_POST['resim'];
$kod = kucult($_POST['kod']);
$tarih = time();
$sef = trsil($adi) ;

$ferhat=mysql_query("INSERT INTO video_ (kid,name,aciklama,resim,etiket,embed,sef) values ('$kategori','$adi','$aciklama','$resim','$adi','$kod','$sef')");
if($ferhat){
echo "<script>alert('Video eklendi!!')</script>";}
else {echo "Eklenemedi ".mysql_error();}
}else{
?>	
<p>&nbsp;</p>
<p>&nbsp;</p>
<HTML><HEAD><TITLE> | Yönetim Paneli</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-9">
<LINK href="../img/style2.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
.style1 {color: #626BE2}
.style2 {color: #A80675}
.style3 {color: #C31009; }
.style4 {color: #178B28; }
-->
</style>

<base target="_self">
<body style="background-image: url('img/back.jpg')">
	<p align="center"><b><font color="#FFFFFF" size="3">Yahoo Bot (Movie - Film)</font></p>
<FORM NAME="form" METHOD="GET" ACTION="">
              <div align="center"><font face="Tahoma" size="2" class="ara">
              <input type="text" name="kelime" class="ara" size="40" value="<?echo "$aranan";?>">
              </font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" name="onay" value="Aramaya Başla" />
<BR>
              </div></FORM>
              
              <?
		
				$data=DosyaAl('http://video.yahoo.com/search/?p='.$aranan);	
		if(eregi("<div class=\"result\">",$data)) {
		$bol = explode("<div class=\"result\">",$data);
		if(count($bol)-1<$max) {
		$git = count($bol)-1;
		}else{
		$git = $max;}
		for ($i=1;$i<=$git;$i++) {

		preg_match("'clipid=\"(.*?)\"'si",$bol[$i], $clipid);
		preg_match("'id=\"playHere_(.*?)\"'si",$bol[$i], $id);
		preg_match("'<img src=\"(.*?)\" width'si",$bol[$i], $resim);		
		preg_match("'<p class=\"resultDesc\">(.*?)</p>'si",$bol[$i], $aciklama);
		preg_match("'alt=\"(.*?)\"'si",$bol[$i], $adi);
		


?>	

<HTML><HEAD><TITLE> | Yönetim Paneli</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-9">
<LINK href="../img/style2.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
.style1 {color: #626BE2}
.style2 {color: #A80675}
.style3 {color: #C31009; }
.style4 {color: #178B28; }
-->
</style>

<base target="_self">
<body style="background-image: url('img/back.jpg')">
	<p align="center">
	<FORM action=yahoo.php
                method=post><input type=hidden name=ix value=1>
              <div class="post" style="padding-top: 5px;">
                <h2 class="title" align="center"><font color="#FFFFFF" size="3">isim:</font>
                <input name="adi" class="field" id="adi" 
                  style="WIDTH: 200px; HEIGHT: 20px" value="<?=$adi[1];?>" size="10" />
               <font color="#FFFFFF" size="3"> Link: </font>
                <input name="" class="field" 
                  style="WIDTH: 200px; HEIGHT: 20px" value="http://video.yahoo.com/watch/<?=$id[1];?>/<?=$clipid[1];?>" size="10" />
                &nbsp;&nbsp;&nbsp;<INPUT class=button type=submit value=Ekle name=send_button>&nbsp;&nbsp;&nbsp;</h2>
                <div class="entry">
                <table border="0" width='67%'>
                  <tr>
                    <td valign="top" width='217'><div align="center"><img border="0" src="<?=str_replace('320x240','160x120',$resim[1]);?>" alt="<?=$adi[1];?>" height="103" width="138" /><br><br></div>
                        <table cellspacing="0" cellpadding="0" width="220" align="left" 
              border="0">
                          <tbody>
                            <tr height="25">
                              <td width="84" align="left">
								<p align="center"><b><font color="#FFFFFF" size="3">Kategori :</font></b></td>
                              <td width="136">
								<p align="center"><select name="kategori" id="kategori">
<?

$q2=mysql_query("Select * from kategori");
while($r2=mysql_fetch_array($q2))
{
echo "<option value='$r2[id]'>$r2[name]</option>";
}
?></select>
                            </td>
                            </tr>
                          </tbody>
                    </table></td>
                    <td width="272" valign="top"><p align="center"><font color="#FFFFFF" size="3"><strong>Aciklama:</strong></font></p>
                        <p align="center">
                          <textarea class="field" style="WIDTH: 272; HEIGHT: 159" name="aciklama" rows="5" cols="40"><?=strip_tags(str_replace(' style="display:none;"','',str_replace('>','',$aciklama[1])));?>
                          </textarea></p></td>
                    <td width="329" valign="top"><p align="center"><strong><font color="#FFFFFF" size="3">Embed Kodu:</font></strong></p>
                        <p align="center">
                          <textarea class="field" style="WIDTH: 329; HEIGHT: 159" name="kod" rows="5" cols="40" id="kod"><div><object width="530" height="420"><param name="movie" value="http://d.yimg.com/static.video.yahoo.com/yep/YV_YEP.swf?ver=2.2.17" /><param name="allowFullScreen" value="true" /><param name="bgcolor" value="#FFFFFF" /><param name="flashVars" value="id=<?=$clipid[1];?>&vid=<?=$id[1];?>&lang=en-us&intl=us&thumbUrl=&embed=1" /><embed src="http://d.yimg.com/static.video.yahoo.com/yep/YV_YEP.swf?ver=2.2.17" type="application/x-shockwave-flash" width="530" height="420" allowFullScreen="true" bgcolor="#000000" flashVars="id=<?=$clipid[1];?>&vid=<?=$id[1];?>&lang=en-us&intl=us&thumbUrl=&embed=1" ></embed></object></div><img src="<?=$resim[1];?>" width="0" height="0" />
                          </textarea>
                          <br />
                          <strong><font color="#FFFFFF" size="3">Resim Konumu</font></strong>:
                          <input name="resim" class="field" id="resim" 
                  style="WIDTH: 200px; HEIGHT: 20px" value="<?=$resim[1];?>"  size="10" />
                      </p></td>
                  </tr>
                </table>
              </div>
			   </FORM>
              <center>
                <font color="#FFFFFF" size="3">----------------------------------------------------------------------------------------------------------------------------------------------------</center>
              </font></body>
			  </html>
			  <? } } } ?>
              <BR>
<BR>

</body>
</html>

kurcaladıgım sonucda

$ferhat=mysql_query("INSERT INTO video_(kid,name,aciklama,resim,etiket,embed,sef) values ('$kategori','$adi','$aciklama','$resim','$adi','$kod','$sef')");
if($ferhat){

olay burda bitiyor galiba pek anlayamadım ama yardımcı olursanız sevinirim.