Tekil Mesaj gösterimi - wp bot yardim php anlayan arkadaslar iceri

Konu wp bot yardim php anlayan arkadaslar iceri
02-04-2009, 17:17:35
Üyeliği durduruldu
merhaba arkadaslar php yeni yeni ögrenmeye calisiyorum fakat bu isin üstesinden gelemedim, elimde bir arkadasin ücretsiz paylastigi wp bot var, sarki sözleri icin, bot wp sisteme sarki sözlerini cekerken sadece sarki ismini baslik olarak aliyor ama ben sarkici ismi ve sarki sözü ile cekmesini istiyorum bir cok deneme yaptim fakat sonuca ulasamadim yardimci olursaniz cok makbule gecer.
Buda kodlar;
<?php
# h4ckinger
#NetDeviLz 2008 Co. 
#Te&thorn;ekkürler Liz0ziM
#www.h4ckinger.org
include "wp-config.php";
$site="http://www.cekileceksite.com/";
$mysqlhost=;
$mysqlad=;
$mysqlpass=;
$mysqldb=;
$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'");
// SEF URL Fonksiyonumuz
function seo($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('í', '&yacute;', 'ì', 'î', 'ï', 'I', '&Yacute;', 'Í', 'Ì', 'Î', 'Ï');
    $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('&thorn;', '&THORN;');
    $url = str_replace ($find, 's', $url);
    $find = array('&eth;', '&ETH;');
    $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 arayi_al($kaynak, $ref_bas, $ref_son){
	$cikti_bas=explode($ref_bas,$kaynak);
	
	for($a=1;$a<count($cikti_bas);$a++){
		$cikti_son[] = explode($ref_son,$cikti_bas[$a]);
	}

	for($b=0;$b<count($cikti_bas);$b++){
		$sonuc[$b] = $cikti_son[$b][0];
	}

	if(empty($sonuc)){
	die("Ara Alinamadi");
	}else{
	return $sonuc;
	}
}
	function cek($ursa){
		$ch = curl_init();
		$zaman = 0;
		curl_setopt ($ch, CURLOPT_URL, $ursa);
		curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
		curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $zaman);
		$rmx = curl_exec($ch);
		curl_close($ch);
		
		return $rmx;
	}
?>
<form method="POST" action="">
<SELECT NAME="kat">
<?
$cek=mysql_query("SELECT *
FROM wp_term_taxonomy
WHERE taxonomy='category'");
while($veri=mysql_fetch_array($cek))
{
$nos=$veri[term_id];
$sorgu=mysql_query("SELECT name
FROM wp_terms
WHERE term_id='$nos'");
while($v=mysql_fetch_array($sorgu))
{
?>
<OPTION VALUE="<? echo $nos; ?>"><? echo $v[name]; ?></OPTION>
<?
}
}

echo mysql_error();

?>
</SELECT> Kategori:<br />
<SELECT NAME="ekleyen">
<? $ciz=mysql_query("select ID,user_login from wp_users");
while($uye=mysql_fetch_array($ciz))
{
?>
<OPTION VALUE="<? echo $uye[ID]; ?>"><? echo $uye[user_login]; ?></OPTION>
<?
}
?>
</SELECT> Sözü Ekleyen <br />

<input name="kelime" type="text" /> Aranacak Sözcük Kelime <br />
<input type="submit" value="Eklemeye Ba&thorn;la"/><br />
</form>
<?

if(isset($_POST[kat]))
{






$kategori=$_POST[kat];
$kelime=$_POST[kelime];

$ekleyen=$_POST[ekleyen];
$saniye=date("H:i:s");
$gun=date('Y-m-d');
$tarih=$gun." ".$saniye;

$ara=$_POST[kelime]; #aranacak sanatç&yacute;
$kelime=iconv("ISO-8859-9","UTF-8",trim($kelime));
$sarkiciismi=$ara;
$kaynak=cek($site.urlencode($ara));
#echo $kaynak;
$linkler=arayi_al($kaynak,'+<a class="slinks" href="','" title="');
foreach($linkler as $link){
$icer=cek($site.$link);
$sarkiismi=arayi_al($icer,'<td><font color="#FFC243">&nbsp;<b>','</b></font></td>');
$sarkiismi=$sarkiismi[0];
$orta=arayi_al($icer,'<span class="sarki_22">','</span>');
$orta=preg_replace('/<div class="saklan"(.*?)<\/div>/i','',$orta[0]);

echo $sarkiciismi."<br>".$sarkiismi."<br>".$orta; // buraya sql sorgunuzu kendinize göre yaz&yacute;n




/**/


$taglar="$sarkiciismi $sarkiismi tag1 tag 2 buraya taglar ";

#$ad=iconv("UTF-8","ISO-8859-9",trim(addslashes($sarkiismi)));
$ad=trim(addslashes($sarkiismi));
$tags=trim($taglar);
$aciklama=iconv("UTF-8","ISO-8859-9",trim(addslashes($orta)));
$sxc=seo($ad);
$mesaj=$orta;


$toto=mysql_query("select * from wp_posts where post_title='$ad' AND post_name='$sxc'");
if(mysql_num_rows($toto)==0)
{
mysql_query("insert into wp_posts (post_author ,post_date ,	post_date_gmt ,	post_content 	,post_title 	,post_category 	,	post_status 	,comment_status 	,ping_status 		,post_name 		,post_modified 	,post_modified_gmt 	,post_parent 	,	menu_order ,	post_type 	,comment_count) VALUES('$ekleyen','$tarih','$tarih','$mesaj','$ad','0','publish','open','open','$sxc','$time','$time','0','0','post','0')");
echo "<b>".$ad."</b> sözü eklendi<br>";
mysql_query("insert into wp_term_relationships (object_id , term_taxonomy_id) VALUES('$postum',$kategori)");
$alsana=mysql_query("select term_taxonomy_id,count from wp_term_taxonomy where term_taxonomy_id='$kategori'");
$bulsana=mysql_result($alsana,0,"count")+1;
mysql_query("update wp_term_taxonomy set count='$bulsana' where term_taxonomy_id='$kategori'");

$dd=mysql_query("select * from wp_posts where post_title='$ad' AND post_name='$sxc'");
$postum=mysql_result($dd,0,"ID");
echo mysql_error();  
$f=explode(" ",$tags);
$g=count($f);
for($z=0;$z<=$g;$z++)
{
$name=trim($f[$z]);
$slug=seo($name);
$dogu=mysql_query("select name,slug from wp_terms where slug='$slug'");
if(mysql_num_rows($dogu)==0)
{
mysql_query("insert into wp_terms (name,slug) VALUES('$name','$slug')");
}
echo mysql_error();
$s=mysql_query("select name,slug,term_id from wp_terms where slug='$slug'");
echo mysql_error();
$xc=mysql_result($s,0,"term_id");
mysql_query("insert into wp_term_taxonomy (term_id,taxonomy) VALUES('$xc','post_tag')");
$c=mysql_query("select term_taxonomy_id,term_id from wp_term_taxonomy where term_id='$xc'");
$xy=mysql_result($c,0,"term_taxonomy_id");
mysql_query("insert into wp_term_relationships (object_id , term_taxonomy_id) VALUES('$postum','$xy')");
}
}
/**/
}
}
?>