Merhaba arkadaþlar ben sayyac etiket botunu scriptime dahil etmek istiyorum bulabildigim dosya sadece þudur.. index.php si ile config var birde sayyac.php diye bir dosya var sql dosyasý yok sanýrým onu kendimiz yarakmak zorundayýz.. ama benim saten scriptim var

sql bilgileri ise þu þekilde.
Alýntý
DROP TABLE IF EXISTS `jokes`;
CREATE TABLE `jokes` (
`id` int(6) NOT NULL auto_increment,
`category` varchar(255) default NULL,
`joke` text,
`dateadded` timestamp NOT NULL default CURRENT_TIMESTAMP,
`votestar1` int(6) NOT NULL default '0',
`votestar2` int(6) NOT NULL default '0',
`votestar3` int(6) NOT NULL default '0',
`votestar4` int(6) NOT NULL default '0',
`votestar5` int(6) NOT NULL default '0',
`votestartotal` int(7) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `Category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9990 ;
sql ye uyduracagým php koduda bu þekilde
Alýntý
<?
include("config.php");
mysql_connect($server,$dbuser,$pass);
mysql_select_db($dbname);
 
function cevir($url)
{
$url = trim($url);
$url = strtolower($url);
$find = array('', '');
$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;
}
//istediðiniz kadar çoðaltabilirsiniz.
$site[1]="canlisexizle";
$site[2]="vizle18";
 
$r=$_GET[r];
$ch3 = curl_init();
curl_setopt($ch3, CURLOPT_URL, 'http://www.sayyac.com/extreme.php?stat=6&login='.$site[$r]);
curl_setopt($ch3, CURLOPT_POST, 0);
curl_setopt($ch3, CURLOPT_HEADER, 1);
curl_setopt($ch3, CURLOPT_FOLLOWLOCATION, 0);
curl_setopt($ch3, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch3, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3");
curl_setopt($ch3, CURLOPT_REFERER, "http://www.google.com.tr");
curl_setopt($ch3, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch3, CURLOPT_TIMEOUT, 30);
 
 
curl_exec($ch3);
$finish = curl_exec($ch3);
curl_close($ch3);
 
 
preg_match_all('#<td class="bgffd bold sides5 nowrap">Google:&nbsp;&nbsp;<a class="tdnone" target="_blank" href="(.*)">(.*)</a>#',$finish,$baslik);
$m="0";
while($m<=20) {
 
 
$aranan=$baslik[2][$m];
$aranan=str_replace(array("Åž","ÅŸ","Ç","ç","İ" ,"Ü","ü","Ö","ö","Äž","ÄŸ","ı"),array("Þ","þ" ,"Ç","ç","Ý","Ü","ü","Ö","ö","Ð","ð","ý"),$aranan) ;
$td=mysql_query("select * from tag WHERE baslik='$aranan'");
$td_row=mysql_fetch_array($td);
$url=cevir($aranan);
if($td_row[baslik]=="" && $aranan!="") { mysql_query("insert into tag values('','$aranan','$url',NOW())"); }
 
$bg=mysql_query("select * from tag");
 
 
$m++;
}
$toplam=mysql_num_rows($bg);
$ra=$_GET[r]+1;
if($_GET[r]==count($site)) { $ra="1"; }
echo $ra;
?>
bunu nasýl yapabilirim yada birisi yapabilirmi?

not: yardým edene güncel siteden link verebilirim.