Tekil Mesaj gösterimi - video scripti arama sorunu

Konu video scripti arama sorunu
15-03-2009, 12:48:19
mrb arkadaşlar.

kullandığım video scriptinde videoları arayınca bir sorun yaşıyorum bulunan videolar tabloya sığmıyor...
resim:
bulunan videoları nasıl tabloya sığdırırım ? ayrıca video_ara.php'deki botları kaldırmak istiyorum şimdiden teşekkürler.

video_ara.php'deki kodlar:
<? 
include "bilgiler.php";

if (empty($kelime)) $kelime=$HTTP_GET_VARS["kelime"];

$bottaara=0;
$baslik=$kelime ." filmlerini t&yacute;kla izle";
$tag=$kelime ." videosu,".$kelime ." videolar&yacute;,".$kelime ." izle";
$linkarkasi="/video_ara.php?video=izle&kelime=".$kelime."&bot_id=".$b_bot_id;


if (!empty($kelime)) {
	
	$bakk=mysql_query("select * from kelimeler where kelime='".str_replace("@"," ",$kelime)."'");
	$kacadet = mysql_num_rows($bakk);
	if ($kacadet>0) {
		$row = mysql_fetch_array($bakk);
		mysql_query("update kelimeler set aranma=aranma+1 where kelime_id='". $row["kelime_id"] . "'");
	}else {
		mysql_query("insert into kelimeler set aranma='1',ap='p',kelime='".str_replace("@"," ",$kelime)."'");
	}
}


?>
<html>
<head>
<? include "taglar.php" ?>
</head>
<link  rel="stylesheet" href="css/style.css" type="text/css">
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0">
<table id="videolari" border="0" width="100%" height="100%" cellspacing="0" cellpadding="0">
	<tr>
		<td class="banner" valign="top">
			<? include "videolari_banner.php" ?>
		</td>
	</tr>
	<tr>
		<td class="sayfa_orta" valign="top" align="center">
		<table border="0" width="768" id="videosu" cellspacing="0" cellpadding="0" >
			<tr>
				<td valign="top">

				
				<table border="0" width="100%" id="videosu" cellspacing="0" cellpadding="0" style="margin-top:10px;">
					<tr>
						<td>
				<table border="0" width="100%" id="izle" cellspacing="0" cellpadding="0">
					<tr>
						<td width="30"><img border="0" src="/images/mavi_baslik_sol.gif" width="30" height="26"></td>
						<td background="/images/mavi_baslik.gif" width="120" style="padding-left:4px;">
						<font size="2"><b>A</b></font><b><font size="2">Arama Sonuçlar&yacute;</font></b></td>
						<td width="8"><img border="0" src="/images/mavi_baslik_sag1.gif" width="8" height="26"></td>
						<td background="/images/mavi_baslik_zemin.gif">&nbsp;</td>
						<td width="7"><img border="0" src="/images/mavi_baslik_sag2.gif" width="7" height="26"></td>
					</tr>
				</table>
						</td>
					</tr>
					<tr>
						<td class="mavi_zemin">
<?
if ($b_bot_id=="99") {
$eksql="";
$eklimit="";
	if (empty($kelime)) {
		$eksql="";
		$eklimit="limit 10";
?>
<div align="center"><br><b>Arama Hatas&yacute; :</b> Aranacak kelime yaz&yacute;lmad&yacute;&eth;&yacute; için
	<b>Son Eklenen 10 Video</b> listelenmi&thorn;tir. <br>
	Lütfen aranacak keliyemi yaz&yacute;n&yacute;z<br></div>
<?
}else {
	$eksql=" and (baslik LIKE '%$kelime%' or tag LIKE '%$kelime%' )  ";
	$eklimit="";
}
?>

<?
		$sayfa=$HTTP_GET_VARS["sayfa"];
		if (empty($sayfa)) $sayfa=1;
		if (!is_numeric($sayfa)) $sayfa=1;
		$liss=mysql_query("select kategori,baslik,gosterim,video_id,resim,tag from videolar where ap='a' $eksql order by video_id desc $eklimit");
		$kacadet = mysql_num_rows($liss);
		if (empty($kacadet)) $kacadet=0;
		$listesayisi=10;
		$sayfa_baslangic=$listesayisi*($sayfa-1);
		$shesap=$kacadet/$listesayisi;
		if (floatval($shesap)>intval($shesap)) { $shesap=intval($shesap)+1; } else { $shesap=intval($shesap); }
		if (intval($shesap)==0) $shesap=1;


			$izz=mysql_query("select kategori,baslik,gosterim,video_id,resim,tag from videolar where ap='a' $eksql order by video_id desc limit $sayfa_baslangic,$listesayisi");
			$kacadet1 = mysql_num_rows($izz);
			
if ($kacadet1==0) {
?>
<div align="center"><br><?=$kurumadi?> 'de <b>"<?=str_replace("@"," ",$kelime)?>"</b> kelimesine uygun sonuç bulunamad&yacute;.<br>
	<br>
</div>
<?
$bottaara=0;
}
else {
if (strlen($kelime)>0) {
?>
<div align="left" style="margin-bottom:7px;width:100%;"><b>"<?=$kelime?>"</b> kelimesi geçen <b><?=$kacadet?> video</b> bulundu.</div>
<?
}

					while ( $row = mysql_fetch_array($izz) ) { 
						$kategori=kategoribul($row["kategori"]);
						$kategoritemiz=$kategori;
						$kategoritemiz=karaktertemizle($kategoritemiz);
					?>
					<div class="mavi_video_zemin" style="width:285px;height:110px;">
					<d<div class="mavi_video_zemin" style="width:285px;height:110px;">
					<div style="float:left;"><a href="video/<?=$row["video_id"]?>/<?=karaktertemizle($row["baslik"])?>.videosu"><img border="0" style="margin:5px 0px 0px 5px;" src="<?=$row["resim"]?>" width="130" height="97"></a></div>
					<div style="float:left;">
					<div class="video_aciklama" style="float:none;margin:0px;padding-left:5px;background-image:url(images/mavi_video_zemin.gif);background-position:bottom;background-repeat:repeat-x;width:145px;margin-top:5px;">
					<b><a title="<?=($row["baslik"])?>" href="video/<?=$row["video_id"]?>/<?=karaktertemizle($row["baslik"])?>.videosu"><?=kisalt($row["baslik"],20)?></a><br><a title="<?=str_replace("ler","",str_replace("lar","",$kategori))?> videolar&yacute;" href="videolar/<?=$row["kategori"]?>/1/<?=$kategoritemiz?>"><?=$kategori?></a></b><br>
					<!--
					<b><?//number_format($row["gosterim"],0, ",", ".");?></b> kez izlendi--></div>
					<div class="taglar"><?=tagla($row["tag"],50)?></div>
					</div>
					</div>
					<?
					}
	}
					mysql_free_result($izz);
					?>
					
<?
} else { 
$bottaara=0;
}


if ($b_bot_id=="1") {

	$feed = "http://www.youtube.com/api2_rest?method=youtube.videos.list_by_tag&dev_id=Hfe9iDwcSyM&tag=".temizle($kelime)."&page=1&per_page=20";
	$dom = getFeed($feed);

	If (!$dom) {
	    echo "XML Hatas&yacute;: Video bulunamad&yacute;.";
	    return;
	} else {
		$videos = $dom->getElementsByTagName('video');
		
		foreach ($videos as $video)
		{
			$v_bot_video_id=$video->getElementsByTagName("id")->item(0)->textContent;
			$v_baslik=$video->getElementsByTagName("title")->item(0)->textContent;
			$v_sure  = $video->getElementsByTagName("length_seconds")->item(0)->textContent;
			$v_puan  = $video->getElementsByTagName("rating_avg")->item(0)->textContent;
			$v_gosterim= $video->getElementsByTagName("view_count")->item(0)->textContent;;
			$v_aciklama= $video->getElementsByTagName("description")->item(0)->textContent;
			$v_tag = $video->getElementsByTagName("tags")->item(0)->textContent;
			
			$v_kategori=$video->getElementsByTagName("channel")->item(0)->textContent;

			$v_resim = $video->getElementsByTagName("thumbnail_url")->item(0)->textContent;;	
		
		$v_baslik =decode(str_replace("'","\'",$v_baslik));
		$v_sure =decode(str_replace("'","\'",$v_sure));
		$v_puan =decode(str_replace("'","\'",$v_puan));
		$v_aciklama =decode(str_replace("'","\'",$v_aciklama));
		$v_tag =decode(str_replace(" ",",",str_replace("'","\'",$v_tag)));
		$v_kategori =decode(str_replace("'","\'",$v_kategori));
		$v_resim =decode(str_replace("'","\'",$v_resim));
		
		$v_baslik_temiz=$v_baslik;
		$v_baslik_temiz=karaktertemizle($v_baslik_temiz);
?>

			<div class="mavi_video_zemin" style="width:577px;height:110px;margin-right:0px;">
			<div style="float:left;"><a href="/video_izle.php?bot_id=<?=$b_bot_id?>&bot_video_id=<?=$v_bot_video_id?>"><img border="0" style="margin:5px 0px 0px 5px;" src="<?=$v_resim?>" width="130" height="97"></a></div>
			<div style="float:left;">
			<div class="video_aciklama" style="float:none;margin:0px;padding-left:5px;background-image:url(/images/mavi_video_zemin.gif);background-position:bottom;background-repeat:repeat-x;width:437px;margin-top:5px;">
			<b><a title="<?=$v_baslik?>" href="/video_izle.php?bot_id=<?=$b_bot_id?>&bot_video_id=<?=$v_bot_video_id?>"><?=kisalt($v_baslik,200)?></a><br><?=$bot[$b_bot_id]?></b><br><b><?=number_format($v_gosterim,0, ",", ".")?></b> kez izlendi</div>
			<div class="taglar" style="width:437px;"><?=tagla($v_tag,250)?></div>
			</div>
			</div>          
<? 
		}
    }

}


if ($bottaara==0 && $b_bot_id=="2") {
	$feed = "http://www.metacafe.com/tags/".temizle($kelime)."/rss.xml";
	$dom = getFeed($feed);

	If (!$dom) {
	    echo "XML Hatas&yacute;: Video bulunamad&yacute;.";
	    return;
	} else {
		$videos = $dom->getElementsByTagName("item");
		foreach ($videos as $video)
		{
			$v_bot_video_id = $video->getElementsByTagName("id")->item(0)->textContent;
			$v_baslik=$video->getElementsByTagName("title")->item(0)->textContent;
			$sureal = $video->getElementsByTagName("content");
			$v_sure = $sureal->item(0)->getAttribute("duration");
			$v_puan=$video->getElementsByTagName("rank")->item(0)->textContent;
			$v_gosterim="";
			$v_aciklama=$video->getElementsByTagName("description")->item(0)->textContent;
			$v_tag = $video->getElementsByTagNameNS("http://search.yahoo.com/mrss/", "keywords")->item(0)->textContent;;
			$v_kategori=$video->getElementsByTagName("category")->item(0)->textContent;
			$foto = $video->getElementsByTagNameNS("http://search.yahoo.com/mrss/", "thumbnail");
			$v_resim = $foto->item(0)->getAttribute("url");	
			
			
			$v_baslik =decode(str_replace("'","\'",$v_baslik));
			$v_sure =decode(str_replace("'","\'",$v_sure));
			$v_puan =decode(str_replace("'","\'",$v_puan));
			//$v_gosterim =str_replace("'","\'",$v_gosterim);
			$v_aciklama =decode(str_replace("'","\'",$v_aciklama));
			$v_tag =decode(str_replace("'","\'",$v_tag));
			$v_kategori =decode(str_replace("'","\'",$v_kategori));
			$v_resim =decode(str_replace("'","\'",$v_resim));
		
			$v_baslik_temiz=$v_baslik;
			$v_baslik_temiz=karaktertemizle($v_baslik_temiz);
?>

			<div class="mavi_video_zemin" style="width:577px;height:110px;margin-right:0px;">
			<div style="float:left;"><a href="/video_izle.php?bot_id=<?=$b_bot_id?>&bot_video_id=<?=$v_bot_video_id?>"><img border="0" style="margin:5px 0px 0px 5px;" src="<?=$v_resim?>" width="130" height="97"></a></div>
			<div style="float:left;">
			<div class="video_aciklama" style="float:none;margin:0px;padding-left:5px;background-image:url(/images/mavi_video_zemin.gif);background-position:bottom;background-repeat:repeat-x;width:437px;margin-top:5px;">
			<b><a title="<?=$v_baslik?>" href="/video_izle.php?bot_id=<?=$b_bot_id?>&bot_video_id=<?=$v_bot_video_id?>"><?=kisalt($v_baslik,200)?></a><br>MetaCafe</b><br><!--<b><?//number_format($v_gosterim,0, ",", ".")?></b> kez izlendi--></div>
			<div class="taglar" style="width:437px;"><?=tagla($v_tag,250)?></div>
			</div>
			</div>          
<? 
    }

}
}
?>

						</td>
					</tr>
					<tr>
						<td class="mavi_zemin" align="center">
							<?=SayfalamaGetir($sayfa,$shesap,$linkarkasi) ?>
						</td>
					</tr>
				</table>
				
				</td>
				<td width="7" valign="top">&nbsp;</td>
				<td width="170" valign="top">
					<? include "videolari_sag.php" ?>
				</td>
			</tr>
		</table>
				<? include "videolari_alt.php" ?>
		</td>
	</tr>
</table>
</body>

</html>
<? include "baglantikes.php" ?>