<table width="100%" height="100%" style="border:0px solid #cccccc">
    <tr>
 
    </tr>
     <tr>
      
 
<td align="center" valign="top" width="40%" style="border-style: solid; border-width: 0">
       <table cellspacing="5" cellpadding="5" style="border-width: 0">
       <tr>
                         
 
 
 <td id="haber_spot" name="haber_spot" style="border-style:none; border-width:medium; font-family:verdana;font-size:10pt;color:#ff0033;font-weight:bold">
 
 

</td></tr>
       <tr>
                         
 
 
 <td id="haber_metin" name="haber_metin" style="border-style:none; border-width:medium; font-family:verdana;font-size:10pt;color:#000000;text-align:left"></td></tr>
       </table>

      </td>
 
 
 
 
     <td width="60%" valign="top" style="border-style: solid; border-width: 0">
<?php
       include("mainfile.php");
       $yol = XOOPS_DB_HOST;
       $kullanici_adi = XOOPS_DB_USER;
       $kullanici_sifre = XOOPS_DB_PASS;
       $veritabani_adi = XOOPS_DB_NAME;
       $veritabani_oneki = XOOPS_DB_PREFIX;
       $veri_yolu = mysql_connect($yol, $kullanici_adi, $kullanici_sifre);
       if ( ! $veri_yolu ) die ("MySQL ile veri bağlantısı kurulamıyor!");
       
 
mysql_select_db($veritabani_adi , $veri_yolu) or die ("Veritabanına ulaşılamıyor!" . mysql_error() );
       $sonuc = mysql_query("SELECT storyid, title, keywords, hometext FROM 
 
".$veritabani_oneki."_stories  ORDER BY published DESC limit 0,15",$veri_yolu);
       

while($satir = mysql_fetch_array($sonuc)) {
        $satir[hometext] = trim($satir[hometext]);
        $satir[hometext] = str_replace("\n", "", $satir[hometext]);
        $satir[hometext] = str_replace("\r", "", 
 
$satir[hometext]);
    

$satir[hometext] = str_replace("(", "", $satir[hometext]);
 $satir[hometext] = str_replace(")", "", $satir[hometext]);
        

$satir[hometext] = str_replace("'", "", $satir[hometext]);
        

$satir[hometext] = addslashes ($satir[hometext]);
        
$satir[title] = strip_tags($satir[title]);
        
$satir[title] = trim($satir[title]);
        
 

  
$satirr[title] = strip_tags($satirr[title]);
        
$satirr[title] = trim($satirr[title]);

$satir[keywords] = strip_tags($satir[keywords]);
 
 
$satir[title] = str_replace("\n", "", $satir[title]);
        
$satir[title] = str_replace("\r", "", 
$satir[title]);                                            
 

$satir[keywords]=trim(eregi_replace('[^abcçdefghiıjklmnöopqrşstuüvwxyzABCÇDEFGĞHIıİJKLMNOÖPQRSŞTUÜVWXYZ0123456789]','-',$satir[keywords]));
$satir[keywords]=strtolower($satir[keywords]);
$f=array("ş","ö","ü","ı","ğ","Ğ","Ç","Ü","İ","Ö","Ş");
$r=array("s","o","u","i","g","g","c","u","i","o","s");
$satir[keywords]=strtolower(str_replace($f,$r,$satir[keywords]));
$satir[keywords]=str_replace("---","--",$satir[keywords]);
$satir[keywords]=str_replace("--","-",$satir[keywords]);
 

        $satir[title] = str_replace("(", "", $satir[title]);
        $satir[title] = str_replace(")", "", $satir[title]);
        $satir[title] = str_replace("'", "", $satir[title]);
        $satir[title] = addslashes ($satir[title]);
        $satir[hometext] = str_replace("[b]", "<b>", $satir[hometext]);
        $satir[hometext] = str_replace("[/b]", "</b>",
 
$satir[hometext]);
        $satir[hometext] = str_replace("[i]", "<i>", $satir[hometext]);
        $satir[hometext] = str_replace("[/i]", "</i>", $satir[hometext]);
        $satir[hometext] = str_replace("[u]", "<u>", $satir[hometext]);
        $satir[hometext] = str_replace("[/u]", "</u>", $satir[hometext]);
        $satir[title] = str_replace("[b]", "<b>", $satir[title]);
        $satir[title] = str_replace("[/b]", "</b>", $satir[title]);
        $satir[title] = str_replace("[i]", "<i>", $satir[title]);
        $satir[title] = str_replace("[/i]", "</i>", $satir[title]);
        $satir[title] = str_replace("[u]", "<u>", $satir[title]);
        $satir[title] = str_replace("[/u]", "</u>", $satir[title]);
        
 
 

$satir[hometext] = str_replace("[img align=center]", "<img border=\"0\"  height=\"170\" width=\"200\"  src=", $satir[hometext]);
 
 
 

        $satir[hometext] = str_replace("[/img]", "><br />", $satir[hometext]);
     
        $js_kodu = "<script language=javascript>function goster".$satir[storyid]."() { document.getElementById('haber_spot').innerHTML = '".$satir[title]."' ; document.getElementById('haber_metin').innerHTML = '".$satir[hometext]."' } </script>";
        $basliklar = "&nbsp;&nbsp;<img src='/modules/news/haberikon.gif'><a target='_top' style='font-family:arial;color:#333333;font-size:9pt;text-decoration:none;font-weight:bold' onmouseover='goster".$satir[storyid]."()'"." href='".$xoops_url."/modules/news/article.php?storyid=".$satir[storyid]."-".$satir[keywords].".html"."'>".substr($satir[title],0,30).".."."</a><br /><div style='display: none'>".$satir[hometext]."</div>";
        echo ($js_kodu);
        echo ($basliklar);
       }
        $son_sonuc = mysql_query("SELECT storyid, title, hometext FROM ".$veritabani_oneki."_stories  ORDER BY published DESC",$veri_yolu);
        $ilk_baslik = mysql_result($son_sonuc,0,"title");
        $ilk_yazi = mysql_result($son_sonuc,0,"hometext");
        $ilk_yazi = trim($ilk_yazi);
        $ilk_yazi = str_replace("\n", "", $ilk_yazi);
        $ilk_yazi = str_replace("\r", "", $ilk_yazi);
        $ilk_yazi = str_replace("(", "", $ilk_yazi);
        $ilk_yazi = str_replace(")", "", $ilk_yazi);
        $ilk_yazi = str_replace("'", "", $ilk_yazi);
        $ilk_yazi = addslashes ($ilk_yazi);
        $ilk_baslik = strip_tags($ilk_baslik);
        $ilk_baslik = trim($ilk_baslik);
        $ilk_baslik = str_replace("\n", "", $ilk_baslik);
        $ilk_baslik = str_replace("\r", "", $ilk_baslik);
        $ilk_baslik = str_replace("(", "", $ilk_baslik);
        $ilk_baslik = str_replace(")", "", $ilk_baslik);
        $ilk_baslik = str_replace("'", "", $ilk_baslik);
        $ilk_baslik = addslashes ($ilk_baslik);
        $ilk_yazi = str_replace("[b]", "<b>", $ilk_yazi);
        $ilk_yazi = str_replace("[/b]", "</b>", $ilk_yazi);
        $ilk_yazi = str_replace("[i]", "<i>", $ilk_yazi);
        $ilk_yazi = str_replace("[/i]", "</i>", $ilk_yazi);
        $ilk_yazi = str_replace("[u]", "<u>", $ilk_yazi);
        $ilk_yazi = str_replace("[/u]", "</u>", $ilk_yazi);
        $ilk_baslik = str_replace("[b]", "<b>", $ilk_baslik);
        $ilk_baslik = str_replace("[/b]", "</b>", $ilk_baslik);
        $ilk_baslik = str_replace("[i]", "<i>", $ilk_baslik);
        $ilk_baslik = str_replace("[/i]", "</i>", $ilk_baslik);
        $ilk_baslik = str_replace("[u]", "<u>", $ilk_baslik);
        $ilk_baslik = str_replace("[/u]", "</u>", $ilk_baslik);
        $ilk_yazi = str_replace("[img align=center]", "<img width=\"200\" hight=\"150\" src=", $ilk_yazi);
        $ilk_yazi = str_replace("[/img]", "><br>", $ilk_yazi);
        $ilk_yazi = substr($ilk_yazi, 0, 500);
        $ilk_js = "<script language=javascript>haber_spot.innerHTML = '".$ilk_baslik."' ; haber_metin.innerHTML = '".$ilk_yazi."'</script>";
        echo ($ilk_js);
       mysql_close();
      ?>
<body oncontextmenu="return false">
<body onselectstart="return false">
     </td>
    </tr>
   </table>