arkadaşlar kodal bu sql sini yazdıramadım yazan arkadaşlar yardım ederse çok memlun olurum..

function ucwords_tr($deger) 
{ 
$deger = split(" ",trim($deger)); 
$deger_tr = ""; 

for($x=0; $x < count($deger); $x++) 
{ 
$deger_bas = substr($deger[$x],0,1); 
$deger_son = substr($deger[$x],1); 
$deger_bas = strtoupper_tr($deger_bas); 

$deger_tr .= $deger_bas.$deger_son." "; 
} 

$deger_tr = trim($deger_tr); 

return $deger_tr; 
} 

function strtolower_tr($deger) 
{ 
$deger = str_replace("Ç","ç",$deger); 
$deger = str_replace("Ð","ð",$deger); 
$deger = str_replace("I","ý",$deger); 
$deger = str_replace("Ý","i",$deger); 
$deger = str_replace("Ö","ö",$deger); 
$deger = str_replace("Ü","ü",$deger); 
$deger = str_replace("Þ","þ",$deger); 

$deger = strtolower($deger); 
$deger = trim($deger); 

return $deger; 
} 

function strtoupper_tr($deger) 
{ 
$deger = str_replace("ç","Ç",$deger); 
$deger = str_replace("ð","Ð",$deger); 
$deger = str_replace("ý","I",$deger); 
$deger = str_replace("i","Ý",$deger); 
$deger = str_replace("ö","Ö",$deger); 
$deger = str_replace("ü","Ü",$deger); 
$deger = str_replace("þ","Þ",$deger); 

$deger = strtoupper($deger); 
$deger = trim($deger); 

return $deger; 
} 

switch ($a)
{
case 'calistir':

function konumatik($adres, $kategori, $kayitno)
    {
    $url_kontrol = @fsockopen("www.internethaber.com", 80, $errno, $errstr, 30);
    if($url_kontrol)
        {
        $s = $kayitno;
        $kaynak = file_get_contents($adres);
        preg_match_all('#<div class="inner_2"><a href="news_detail\.php\?id=(.*?)">#i',$kaynak,$baslik);
        preg_match_all('#<div class="item"><a href="news_detail\.php\?id=(.*?)" onmouseover#i',$kaynak,$manset);
        for ($i=0; $i< count($manset[1]); $i++)
            {
            $array[] = $manset[1][$i];
            }

        for ($i=0; $i< count($baslik[1]); $i++)
            {
            $array[] = $baslik[1][$i];
            }

        $array = array_reverse($array);

        foreach($array as $value)
            {
            $sql = mysql_query("SELECT COUNT(*) FROM sed_forum_posts WHERE shid='".$value."'");
            $alr = mysql_result($sql,0,"COUNT(*)");
            $sql_topics = mysql_query("SELECT COUNT(*) FROM sed_forum_topics WHERE shid='".$value."'");
            $alr2 = mysql_result($sql_topics,0,"COUNT(*)");
            if ($alr<1 && alr2<1)
                {
            $devam = file_get_contents("http://www.internethaber.com/news_detail.php?id=".$value);
            preg_match('#<div class="title">(.*?)</div>#si',$devam,$baslik);
            preg_match('#<div id="news_content" class="content content_12">(.*?)</div>#si',$devam,$icerik);
            preg_match('#<div class="image"><img src="\.(.*?)" align="left"#si',$devam,$resim);
            preg_match('#<div class="short_content">(.*?)</div>#si',$devam,$aciklama);
            //mysql_query("INSERT INTO kategorisel (s_hid, s_tarih, s_kat, s_baslik, s_resim, s_aciklama, s_icerik) VALUES ('".$value."', '".time()."', 'Ekonomi', '".strip_tags(prep($baslik[1]))."', 'http://www.internethaber.com".prep($resim[1])."', '".prep($aciklama[1])."', '".prep($icerik[1])."')");
                if (strlen($icerik[1])>160)
                    {
                    $sql = sed_sql_query("INSERT into sed_forum_topics
                    (ft_state,
                    ft_mode,
                    ft_sticky,
                    ft_sectionid,
                    ft_title,
                    ft_creationdate,
                    ft_updated,
                    ft_postcount,
                    ft_viewcount,
                    ft_firstposterid,
                    ft_firstpostername,
                    ft_lastposterid,
                    ft_lastpostername,
                    shid,
                    habermi)
                    VALUES
                    ('0',
                    '0',
                    '0',
                    '$s',
                    '".strip_tags(sed_sql_prep(ucwords_tr($baslik[1])))."',
                    '".time()."',
                    '".time()."',
                    1,
                    0,
                    520,
                    'KonuMatik',
                    520,
                    'KonuMatik',
                    '".$value."',
                    '1')");
        
                    $sql = sed_sql_query("SELECT ft_id FROM sed_forum_topics WHERE 1 ORDER BY ft_id DESC LIMIT 1");
                    $row = sed_sql_fetcharray($sql);
                    $q = $row['ft_id'];
                    setlocale(LC_CTYPE,'tr_TR','tr','turkish');
                    $sql = sed_sql_query("INSERT into sed_forum_posts
                    (fp_topicid,
                    fp_sectionid,
                    fp_posterid,
                    fp_postername,
                    fp_creation,
                    fp_updated,
                    fp_text,
                    fp_posterip,
                    shid)
                    VALUES
                    ('".$q."',
                    '".$s."',
                    '520',
                    'KonuMatik',
                    '".time()."',
                    '".time()."',
                    '<img src=\"http://www.internethaber.com".sed_sql_prep($resim[1])."\" alt=\"\" width=\"250\" height=\"190\" style=\"float: left;margin: 3px 15px 0 0;border: 1px solid #000000;\" /><h2>".strip_tags(sed_sql_prep(ucwords_tr($baslik[1])))."</h2><font style=\"font-size:9px;color:#868686;\">".dunbugun(date("Y-m-d H:i", time()), $tarihver)."</font><h3>".sed_sql_prep($aciklama[1])."</h3>".sed_sql_prep($icerik[1])."',
                    '127.0.0.1',
                    '".$value."')");
                    $kayit1++;
                    }
                }
            
            }


    if ($kayit1>0)
        {
        $sql = sed_sql_query("UPDATE sed_users SET user_postcount=user_postcount+".$kayit1." WHERE user_id='520'");
        sed_forum_sectionsetlast($s);
        }

    if (empty($kayit1))
        {
        $kayit_sonuc = "Yeni haber bulunamadý.";
        }
        else
        {
        $kayit_sonuc = "Yeni eklenen haber sayýsý ".$kayit1;
        }
    $sonuc = "$kategori kategorisi için kontrol/güncelleme baþarýyla tamamlandý.<br />".$kayit_sonuc;
    return $sonuc;
    }
    else
    {
    $sonuc = "Internethaber.com ile baðlantý saðlanamadý. (ping isteði yanýtsýz kaldý)";
    return $sonuc;
    }
    }
    $plugin_body = konumatik($adres, $kategori, $kayitno);
    $plugin_body .= "<br /><br /><br />Diðer kategorileri güncellemek için <a href=\"admin.php?m=tools&p=konumatik\">týklayýn</a>";
    break;


    default:
    $plugin_body .= "<h2>Konumatik</h2>";
    $plugin_body .= "Ekonomi Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=3&interstitial=true&kategori=ekonomi&kayitno=20\">Güncelle</a><br /><br />";
    $plugin_body .= "Medya Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=19&interstitial=true&kategori=medya&kayitno=21\">Güncelle</a><br /><br />";
    $plugin_body .= "Siyaset Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=4&interstitial=true&kategori=siyaset&kayitno=22\">Güncelle</a><br /><br />";
    $plugin_body .= "Dünya Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=5&interstitial=true&kategori=dunya&kayitno=23\">Güncelle</a><br /><br />";
    $plugin_body .= "Spor Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=6&interstitial=true&kategori=spor&kayitno=24\">Güncelle</a><br /><br />";
    $plugin_body .= "Magazin Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=10&interstitial=true&kategori=magazin&kayitno=25\">Güncelle</a><br /><br />";
    $plugin_body .= "Yaþam Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=13&interstitial=true&kategori=yasam&kayitno=26\">Güncelle</a><br /><br />";
    $plugin_body .= "Teknoloji Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=8&interstitial=true&kategori=teknoloji&kayitno=27\">Güncelle</a><br /><br />";
    $plugin_body .= "Kültür/Sanat Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=9&interstitial=true&kategori=kultur&kayitno=28\">Güncelle</a><br /><br />";
    $plugin_body .= "Eðitim Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=96&interstitial=true&kategori=egitim&kayitno=29\">Güncelle</a><br /><br />";
    $plugin_body .= "Saðlýk Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=11&interstitial=true&kategori=saglik&kayitno=30\">Güncelle</a><br /><br />";
    $plugin_body .= "Yerel Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=18&interstitial=true&kategori=yerel&kayitno=32\">Güncelle</a><br /><br />";
    $plugin_body .= "Ýstanbul Kategorisini <a href=\"admin.php?m=tools&amp;p=konumatik&amp;a=calistir&adres=http://www.internethaber.com/news.php?cid=14&interstitial=true&kategori=istanbul&kayitno=33\">Güncelle</a><br /><br />";
    break;
}