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(' ', '"', '&', '&', '\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> </p>
<p> </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>
<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" />
<INPUT class=button type=submit value=Ekle name=send_button> </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.
bot yazdırcak şu anda maddi durumumda yok 